Line 57... |
Line 57... |
57 |
db_query "ALTER TABLE radacct ADD INDEX (framedinterfaceid);"
|
57 |
db_query "ALTER TABLE radacct ADD INDEX (framedinterfaceid);"
|
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
|
- |
|
63 |
db_query "ALTER TABLE radacct DROP CONSTRAINT acctuniqueid;"
|
- |
|
64 |
db_query "ALTER TABLE radacct ADD INDEX (acctuniqueid);"
|
- |
|
65 |
|
62 |
# update radpostauth table
|
66 |
# update radpostauth table
|
63 |
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;"
|
64 |
db_query "ALTER TABLE radpostauth ADD INDEX (class);"
|
68 |
db_query "ALTER TABLE radpostauth ADD INDEX (class);"
|
65 |
|
69 |
|
66 |
# add nas table
|
70 |
# add nas table
|