Subversion Repositories ALCASAR

Rev

Rev 3272 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 3272 Rev 3279
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