summaryrefslogtreecommitdiff
path: root/htdocs/docs/upgrade5.html
diff options
context:
space:
mode:
Diffstat (limited to 'htdocs/docs/upgrade5.html')
-rw-r--r--htdocs/docs/upgrade5.html22
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.