X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.4.0pre12;h=7de0619cc5eb96f5aa81ef889efff6191d46b850;hb=6565b17f2bc8bff541854ad80578c502fd52134a;hp=c801a260499591e7e2fa53d9b0a2ce6d1e4ea715;hpb=daac302e231e2e09b84e771c0413b0f2119c52e8;p=freeside.git

diff --git a/README.1.4.0pre12 b/README.1.4.0pre12
index c801a2604..7de0619cc 100644
--- a/README.1.4.0pre12
+++ b/README.1.4.0pre12
@@ -14,6 +14,35 @@ 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,
+  svcnum int not null,
+  groupname varchar(80) not null
+);
+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;
 
 Run bin/dbdef-create
 
@@ -21,9 +50,20 @@ Run bin/create-history-tables
 
 Run bin/dbdef-create again
 
-Arrange for freeside-expiration-alerter to be run daily, if desired.
+Run bin/populate-msgcat
 
-Restart Apache and freeside-queued
+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,
+icradius_mysqldest, icradius_mysqlsource, or icradius_secrets files, see
+the "sqlradius" export instead.  Use MySQL replication 
+<http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication>
+or point the "sqlradius" export directly at your external ICRADIUS or
+FreeRADIUS (or through an SSL-encrypting proxy...)
+
+Arrange for freeside-expiration-alerter to be run daily, if desired.
+
+Restart Apache and freeside-queued
+