diff options
author | ivan <ivan> | 2004-12-03 21:23:19 +0000 |
---|---|---|
committer | ivan <ivan> | 2004-12-03 21:23:19 +0000 |
commit | 87aa7bebdd905db78a405d41b420f5ccd6756d7a (patch) | |
tree | 54f1d8c1901938946203ce3b665dfc7eae0bc74b /README.1.5.0pre7 | |
parent | e81cd66ea62231e89fbd30a95a0e5bdde2292eeb (diff) |
landing RT 3.2.2
Diffstat (limited to 'README.1.5.0pre7')
-rw-r--r-- | README.1.5.0pre7 | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/README.1.5.0pre7 b/README.1.5.0pre7 index cd7e5a266..04a323ca0 100644 --- a/README.1.5.0pre7 +++ b/README.1.5.0pre7 @@ -36,7 +36,37 @@ ALTER TABLE h_part_pkg ADD promo_code varchar(80) NULL; CREATE INDEX part_pkg2 ON part_pkg ( promo_code ); CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code ); +Installs w/integrated RT: + CREATE SEQUENCE attributes_id_seq; + + CREATE TABLE Attributes ( + id INTEGER DEFAULT nextval('attributes_id_seq'), + Name varchar(255) NOT NULL , + Description varchar(255) NULL , + Content text, + ContentType varchar(16), + ObjectType varchar(64), + ObjectId integer, -- foreign key to anything + Creator integer NOT NULL DEFAULT 0 , + Created TIMESTAMP NULL , + LastUpdatedBy integer NOT NULL DEFAULT 0 , + LastUpdated TIMESTAMP NULL , + PRIMARY KEY (id) + + ); + + CREATE INDEX Attributes1 on Attributes(Name); + CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); + + dbdef-create username create-history-tables username rate rate_detail rate_region rate_prefix dbdef-create username + +afterwords (for installs w/integrated RT): +make configure-rt +make deploy +/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.15 +/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.17 + |