X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=htdocs%2Fdocs%2Fupgrade5.html;h=f0a080d0204297e46bcf53021e6b754f184366a4;hb=61a85894466342b93507614785e61932f7358c50;hp=82a7602a3e28094f02aa0a34d7ad45f823ea7fbe;hpb=c2e9ca0ddbdcd3588f94c8c550120c73c0844bb1;p=freeside.git diff --git a/htdocs/docs/upgrade5.html b/htdocs/docs/upgrade5.html index 82a7602a3..f0a080d02 100644 --- a/htdocs/docs/upgrade5.html +++ b/htdocs/docs/upgrade5.html @@ -2,7 +2,7 @@ Upgrading to 1.3.0 -

Upgrading to 1.3.0 from 1.2.2

Upgrading to 1.2.3 from 1.2.2

If migrating from 1.0.0, see these instructions first.
If migrating from less than 1.1.4, see these instructions first. @@ -12,6 +12,35 @@

Apply the following changes to your database:

 ALTER TABLE svc_acct_pop ADD loc CHAR(4);
+CREATE TABLE prepay_credit (
+  prepaynum int NOT NULL,
+  identifier varchar(80) NOT NULL,
+  amount decimal(10,2) NOT NULL,
+  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;
+

Copy or symlink htdocs to the new copy.
Remove the symlink or directory (your_site_perl_directory)/FS.