X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.4.0pre12;h=8b883d4dfb64461269097763a840c4338f29b767;hp=abbf6e55cb91b93ad9cde374d7aa5824c7367c8c;hb=ab33e906a196646c5351c21848b5d6f63b4400dd;hpb=20bb426a02c0ea54d8feaea7c5da51735ab70293

diff --git a/README.1.4.0pre12 b/README.1.4.0pre12
index abbf6e55c..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,
@@ -23,12 +24,51 @@ CREATE TABLE radius_usergroup (
 CREATE INDEX radius_usergroup1 ON radius_usergroup ( svcnum );
 CREATE INDEX radius_usergroup2 ON radius_usergroup ( groupname );
 
+ALTER TABLE svc_acct ADD sec_phrase varchar(80) NULL;
+CREATE TABLE msgcat (
+  msgnum int primary key,
+  msgcode varchar(80) not null,
+  locale varchar(16) not null,
+  msg text not null
+);
+CREATE INDEX msgcat1 ON msgcat ( msgcode, locale );
+
+CREATE TABLE export_svc (
+  exportsvcnum int primary key,
+  exportnum int not null,
+  svcpart int not null
+);
+CREATE UNIQUE INDEX export_svc1 ON export_svc ( exportnum, svcpart );
+CREATE INDEX export_svc2 ON export_svc ( exportnum );
+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
 
 Run bin/dbdef-create again
 
+Run bin/populate-msgcat
+
+Set the `locale' configuration option to `en_US'.
+
 the mxmachines, nsmachines, arecords and cnamerecords configuration values have been deprecated.  Use the defaultrecords configuration value instead.
 
 New export code has landed!  If you were using the icradiusmachines,