(almost) everything for bug#375 - create export_svc table - part_svc to

[freeside.git] / README.1.4.0pre12

diff --git a/README.1.4.0pre12 b/README.1.4.0pre12
index ea1f952..e8fdd30 100644 (file)
--- a/README.1.4.0pre12
+++ b/README.1.4.0pre12
@@ -32,6 +32,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