X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=c317e88c8ccb9acabb4982e58cbd8ef0434bba03;hb=d80be4d3bb68c34eb4e90b5b137b0d42d73f78d8;hp=6be51d6642503af184bc7ce0f4c3229f263fec5b;hpb=44e51a5c50be350fa698bcdcf86ad5c01a7631a2;p=freeside.git
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 6be51d664..c317e88c8 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -134,6 +134,9 @@ ALTER TABLE cust_main ADD referral_custnum integer NULL;
ALTER TABLE cust_pay ADD custnum integer;
ALTER TABLE cust_pay_batch ADD paybatchnum integer;
ALTER TABLE cust_refund ADD custnum integer;
+ALTER TABLE cust_pkg ADD manual_flag char(1) NULL;
+ALTER TABLE part_pkg ADD plan varchar NULL;
+ALTER TABLE part_pkg ADD plandata varchar NULL;
CREATE INDEX cust_main3 ON cust_main ( referral_custnum );
CREATE INDEX cust_credit_bill1 ON cust_credit_bill ( crednum );
CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum );
@@ -199,8 +202,11 @@ ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
If you are using the signup server, reinstall it according to the instructions. The 1.3.x signup server is not compatible with 1.4.x.
Run bin/dbdef-create.
- create a service based on svc_forward
- Run bin/fs-migrate-svc_acct_sm
+ If you have svc_acct_sm records or service definitions:
+
+ - Create a service definition with table svc_forward
+
- Run bin/fs-migrate-svc_acct_sm
+
Run bin/fs-migrate-payref
Run bin/fs-migrate-part_svc
After running bin/fs-migrate-payref, apply the following changes to your database:
@@ -219,7 +225,7 @@ CREATE TABLE cust_pay_temp (
INSERT INTO cust_pay_temp SELECT * from cust_pay;
DROP TABLE cust_pay;
ALTER TABLE cust_pay_temp RENAME TO cust_pay;
-CREATE UNIQUE INDEX cust_pay1 ON cust_pay paynum;
+CREATE UNIQUE INDEX cust_pay1 ON cust_pay (paynum);
CREATE TABLE cust_refund_temp (
refundnum int primary key,
custnum int not null,
@@ -234,7 +240,7 @@ CREATE TABLE cust_refund_temp (
INSERT INTO cust_refund_temp SELECT * from cust_refund;
DROP TABLE cust_refund;
ALTER TABLE cust_refund_temp RENAME TO cust_refund;
-CREATE UNIQUE INDEX cust_refund1 ON cust_refund refundnum;
+CREATE UNIQUE INDEX cust_refund1 ON cust_refund (refundnum);
|