diff options
Diffstat (limited to 'htdocs/docs/upgrade5.html')
-rw-r--r-- | htdocs/docs/upgrade5.html | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/htdocs/docs/upgrade5.html b/htdocs/docs/upgrade5.html index fc4bf2c39..2be3c6e1b 100644 --- a/htdocs/docs/upgrade5.html +++ b/htdocs/docs/upgrade5.html @@ -19,6 +19,28 @@ CREATE TABLE prepay_credit ( PRIMARY KEY (prepaynum), INDEX (identifier) ); +CREATE TABLE domain_record ( + recnum int NOT NULL, + svcnum int NOT NULL, + reczone varchar(80) NOT NULL, + recaf char(2) NOT NULL, + rectype char(5) NOT NULL, + recdata varchar(80) NOT NULL, + PRIMARY KEY (recnum) +); +CREATE TABLE svc_www ( + svcnum int NOT NULL, + recnum int NOT NULL, + usersvc int NOT NULL, + PRIMARY KEY (svcnum) +); +ALTER TABLE part_svc ADD svc_www__svcnum varchar(80) NULL; +ALTER TABLE part_svc ADD svc_www__svcnum_flag char(1) NULL; +ALTER TABLE part_svc ADD svc_www__recnum varchar(80) NULL; +ALTER TABLE part_svc ADD svc_www__recnum_flag char(1) NULL; +ALTER TABLE part_svc ADD svc_www__usersvc varchar(80) NULL; +ALTER TABLE part_svc ADD svc_www__uesrsvc_flag char(1) NULL; + </pre> <li>Copy or symlink htdocs to the new copy. <li>Remove the symlink or directory <i>(your_site_perl_directory)</i>/FS. |