X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.4.0pre12;h=8b883d4dfb64461269097763a840c4338f29b767;hp=7de0619cc5eb96f5aa81ef889efff6191d46b850;hb=ab33e906a196646c5351c21848b5d6f63b4400dd;hpb=95a40a1b8ebf86c76784c220d0d561f952d934ef diff --git a/README.1.4.0pre12 b/README.1.4.0pre12 index 7de0619cc..8b883d4df 100644 --- a/README.1.4.0pre12 +++ b/README.1.4.0pre12 @@ -44,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