X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.4.0pre12;h=7de0619cc5eb96f5aa81ef889efff6191d46b850;hb=1fb1f03d156cc44223dfdf0076c468ed011adf11;hp=ea1f95229607af1d571854389250dd6b40979bd0;hpb=0b65ce59c7d2ee712389c27954382274ddf718a5;p=freeside.git diff --git a/README.1.4.0pre12 b/README.1.4.0pre12 index ea1f95229..7de0619cc 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, @@ -32,6 +33,17 @@ CREATE TABLE msgcat ( ); 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; + Run bin/dbdef-create Run bin/create-history-tables