diff options
Diffstat (limited to 'httemplate/docs/upgrade8.html')
-rw-r--r-- | httemplate/docs/upgrade8.html | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index e52b69ad3..440024de2 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -171,6 +171,14 @@ CREATE TABLE part_export_option ( CREATE INDEX part_export_option1 ON part_export_option ( exportnum ); CREATE INDEX part_export_option2 ON part_export_option ( optionname ); +CREATE TABLE radius_usergroup ( + usergroupnum int primary key, + svcnum int not null, + groupname varchar(80) not null +); +CREATE INDEX radius_usergroup1 ON radius_usergroup ( svcnum ); +CREATE INDEX radius_usergroup2 ON radius_usergroup ( groupname ); + ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; |