| Line 58... |
Line 58... |
| 58 |
db_query "ALTER TABLE radacct ADD INDEX (delegatedipv6prefix);"
|
58 |
db_query "ALTER TABLE radacct ADD INDEX (delegatedipv6prefix);"
|
| 59 |
db_query "ALTER TABLE radacct ADD INDEX (acctinterval);"
|
59 |
db_query "ALTER TABLE radacct ADD INDEX (acctinterval);"
|
| 60 |
db_query "ALTER TABLE radacct ADD INDEX (class);"
|
60 |
db_query "ALTER TABLE radacct ADD INDEX (class);"
|
| 61 |
|
61 |
|
| 62 |
# remove unique constraint on acctuniqueid index
|
62 |
# remove unique constraint on acctuniqueid index
|
| 63 |
db_query "ALTER TABLE radacct DROP CONSTRAINT acctuniqueid;"
|
63 |
db_query "ALTER TABLE radacct DROP CONSTRAINT IF EXISTS acctuniqueid;"
|
| 64 |
db_query "ALTER TABLE radacct ADD INDEX (acctuniqueid);"
|
64 |
db_query "ALTER TABLE radacct ADD INDEX (acctuniqueid);"
|
| 65 |
|
65 |
|
| 66 |
# update radpostauth table
|
66 |
# update radpostauth table
|
| 67 |
db_query "ALTER TABLE radpostauth ADD COLUMN IF NOT EXISTS class varchar(64) DEFAULT NULL;"
|
67 |
db_query "ALTER TABLE radpostauth ADD COLUMN IF NOT EXISTS class varchar(64) DEFAULT NULL;"
|
| 68 |
db_query "ALTER TABLE radpostauth ADD INDEX (class);"
|
68 |
db_query "ALTER TABLE radpostauth ADD INDEX (class);"
|