3,7 → 3,7 |
# $Id$ |
# |
# alcasar-migration-3.2.0_dbStructure.sh |
# by Tom HOUDAYER |
# by Tom HOUDAYER & Richard REY (Rexy) |
# |
# This script is distributed under the Gnu General Public License (GPL) |
# |
72,6 → 72,10 |
db_query "ALTER TABLE radgroupcheck MODIFY COLUMN attribute varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '';" |
db_query "ALTER TABLE radgroupreply MODIFY COLUMN attribute varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '';" |
|
# Fix a potential bug |
# Fix potential bugs |
db_query "UPDATE radreply SET attribute = 'Alcasar-Status-Page-Must-Stay-Open' WHERE attribute = 'Alcasar-Status-Page-Must-Stay-Op';" |
db_query "UPDATE radgroupreply SET attribute = 'Alcasar-Status-Page-Must-Stay-Open' WHERE attribute = 'Alcasar-Status-Page-Must-Stay-Op';" |
db_query "ALTER TABLE mtotacct DROP COLUMN mtotacctid;" |
db_query "ALTER TABLE mtotacct ADD COLUMN mtotacctid bigint(21) AUTO_INCREMENT NOT NULL PRIMARY KEY FIRST;" |
db_query "ALTER TABLE totacct DROP COLUMN totacctid;" |
db_query "ALTER TABLE totacct ADD COLUMN totacctid bigint(21) AUTO_INCREMENT NOT NULL PRIMARY KEY FIRST;" |