summaryrefslogtreecommitdiff
path: root/README.1.5.0pre7
diff options
context:
space:
mode:
Diffstat (limited to 'README.1.5.0pre7')
-rw-r--r--README.1.5.0pre717
1 files changed, 17 insertions, 0 deletions
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 );