fix mistake in part_pop_local schema (not used by anyone really so no big deal)

[freeside.git] / README.1.4.0pre12

diff --git a/README.1.4.0pre12 b/README.1.4.0pre12
index d61656c..72353ba 100644 (file)
--- a/README.1.4.0pre12
+++ b/README.1.4.0pre12
@@ -15,12 +15,31 @@ 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';
 
+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 );
+
 Run bin/dbdef-create
 
 Run bin/create-history-tables
 
 Run bin/dbdef-create again
 
+Run bin/populate-msgcat
+
 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,