X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.5.0pre7;fp=README.1.5.0pre7;h=04a323ca0e6b19451aace05351045af6a3b3679b;hp=cd7e5a266bfe34762f45c5d65a5022df24f1f47a;hb=87aa7bebdd905db78a405d41b420f5ccd6756d7a;hpb=e81cd66ea62231e89fbd30a95a0e5bdde2292eeb 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 +