| 3,7 → 3,7 |
|---|
| # $Id$ |
| # |
| # alcasar-migration-3.2.0_dbStructure.sh |
| # by Tom HOUDAYER & Richard REY (Rexy) |
| # by Tom HOUDAYER |
| # |
| # This script is distributed under the Gnu General Public License (GPL) |
| # |
| 72,10 → 72,6 |
|---|
| 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 potential bugs |
| # Fix a potential bug |
| 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;" |