X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade10.html;fp=httemplate%2Fdocs%2Fupgrade10.html;h=85b36a8db7ec1da86430e99af6bceed8f8935bff;hp=76c49330c4f36e9b890193f93c167cdae90cfa75;hb=a638ae8bdba35169f61f2729d8f3491496992b55;hpb=3d85200f99b423c9c4a0be8c84fd398de911b4b0 diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 76c49330c..85b36a8db 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -278,8 +278,12 @@ ALTER TABLE agent ADD username varchar(80) NULL; ALTER TABLE h_agent ADD username varchar(80) NULL; ALTER TABLE agent ADD _password varchar(80) NULL; ALTER TABLE h_agent ADD _password varchar(80) NULL; -ALTER TABLE cust_main ADD paycvv varchar(4) NULL; -ALTER TABLE h_cust_main ADD paycvv varchar(4) NULL; +ALTER TABLE cust_main ADD paycvv varchar(512) NULL; +ALTER TABLE h_cust_main ADD paycvv varchar(512) NULL; +ALTER TABLE cust_main ALTER COLUMN payinfo varchar(512) NULL; +ALTER TABLE h_cust_main ALTER COLUMN payinfo varchar(512) NULL; +ALTER TABLE cust_main ADD paymask varchar(80) NULL; +ALTER TABLE h_cust_main ADD paymask varchar(80) NULL; ALTER TABLE part_referral ADD disabled char(1) NULL; ALTER TABLE h_part_referral ADD disabled char(1) NULL; CREATE INDEX part_referral1 ON part_referral ( disabled );