X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.4.0pre12;h=8b883d4dfb64461269097763a840c4338f29b767;hp=e8fdd3070eb947c3747c3311cfa93cd9c118aa47;hb=4aaa65f643469cf2df1d97f5e12e05d0122d9570;hpb=a7c1b602f88c177db34477ed4cdc1f72603f8995 diff --git a/README.1.4.0pre12 b/README.1.4.0pre12 index e8fdd3070..8b883d4df 100644 --- a/README.1.4.0pre12 +++ b/README.1.4.0pre12 @@ -14,6 +14,7 @@ install the FS perl modules and httemplate as per install.html or upgrade8.html ALTER TABLE cust_bill_event ADD status varchar(80); ALTER TABLE cust_bill_event ADD statustext text NULL; UPDATE cust_bill_event SET status = 'done'; +DROP INDEX cust_bill_event1; CREATE TABLE radius_usergroup ( usergroupnum int primary key, @@ -43,6 +44,21 @@ CREATE INDEX export_svc3 ON export_svc ( svcpart ); ALTER TABLE part_export RENAME svcpart TO deprecated; +ALTER TABLE part_pkg ADD taxclass varchar(80) NULL; + +CREATE TABLE cust_tax_exempt ( + exemptnum int primary key, + custnum int not null, + taxnum int not null, + year int not null, + month int not null, + amount decimal(10,2) +); +CREATE UNIQUE INDEX cust_tax_exempt1 ON cust_tax_exempt ( custnum, taxnum, year, month ); + +ALTER TABLE cust_main_county ADD taxclass varchar(80) NULL; +ALTER TABLE cust_main_county ADD exempt_amount decimal(10,2); + Run bin/dbdef-create Run bin/create-history-tables