X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.5.0pre7;h=67554c8d3b1b3d2efd9c37fb266856090269de0c;hp=5c136ab5f103a14d1239dfe8fb1e8fb953e06038;hb=76f5008e4d5f6f5016f1c136f740f1f4b9c0b29c;hpb=55a68e4aabe10db4d9c3ab1bb8befd2f9f4b9008

diff --git a/README.1.5.0pre7 b/README.1.5.0pre7
index 5c136ab5f..67554c8d3 100644
--- a/README.1.5.0pre7
+++ b/README.1.5.0pre7
@@ -47,6 +47,23 @@ CREATE TABLE reg_code_pkg (
 CREATE UNIQUE INDEX reg_code_pkg1 ON reg_code_pkg ( codenum, pkgpart );
 CREATE INDEX reg_code_pkg2 ON reg_code_pkg ( codenum );
 
+CREATE TABLE clientapi_session (
+    sessionnum serial NOT NULL,
+    sessionid varchar(80) NOT NULL,
+    namespace varchar(80) NOT NULL,
+    PRIMARY KEY (sessionnum)
+);
+CREATE UNIQUE INDEX clientapi_session1 ON clientapi_session ( sessionid, namespace );
+
+CREATE TABLE clientapi_session_field (
+    fieldnum serial NOT NULL,
+    sessionnum int NOT NULL,
+    fieldname varchar(80) NOT NULL,
+    fieldvalue text NULL,
+    PRIMARY KEY (fieldnum)
+);
+CREATE UNIQUE INDEX clientapi_session_field1 ON clientapi_session_field ( sessionnum, fieldname );
+
 ALTER TABLE part_pkg ADD promo_code varchar(80) NULL;
 ALTER TABLE h_part_pkg ADD promo_code varchar(80) NULL;
 CREATE INDEX part_pkg2 ON part_pkg ( promo_code );