X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;fp=httemplate%2Fdocs%2Fupgrade8.html;h=8ba3b5bafed7ce2dfe53f1caff2c3b0c623db8df;hp=11b80e3901317a004b67b8516bdfe5648a7aaab6;hb=45cf3a8cff466b4731a95e11ff7f4f76aee25d7c;hpb=fb98e91566e72bc3adb823b706529002af487c09 diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 11b80e390..8ba3b5baf 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -213,7 +213,7 @@ CREATE TABLE cust_tax_exempt ( ); CREATE UNIQUE INDEX cust_tax_exempt1 ON cust_tax_exempt ( taxnum, year, month ); -ALTER TABLE svc_acct ADD domsvc integer NOT NULL; +ALTER TABLE svc_acct ADD domsvc integer NULL; ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; ALTER TABLE cust_main ADD comments text NULL; @@ -304,6 +304,12 @@ CREATE INDEX cust_main5 ON cust_main ( ship_company );
  • Create a service definition with table svc_forward
  • Run bin/fs-migrate-svc_acct_sm username +
  • Or if you just have svc_acct records: +
  • Run bin/fs-migrate-payrefusername
  • Run bin/fs-migrate-part_svcusername
  • After running bin/fs-migrate-payref, apply the following changes to your database: