2 ratenum serial NOT NULL,
3 ratename varchar(80) NOT NULL,
7 CREATE TABLE rate_detail (
9 orig_regionnum int NULL,
10 dest_regionnum int NOT NULL,
11 min_included int NOT NULL,
12 min_charge decimal(10,2) NOT NULL,
13 sec_granularity int NOT NULL
15 CREATE UNIQUE INDEX rate_detail1 ON rate_detail ( ratenum, orig_regionnum, dest_regionnum );
17 CREATE TABLE rate_region (
18 regionnum serial NOT NULL,
19 regionname varchar(80) NOT NULL,
20 PRIMARY KEY (regionnum)
23 CREATE TABLE rate_prefix (
24 prefixnum serial NOT NULL,
25 regionnum int NOT NULL,
26 countrycode varchar(3) NOT NULL,
29 PRIMARY KEY (prefixnum)
31 CREATE INDEX rate_prefix1 ON rate_prefix ( countrycode );
32 CREATE INDEX rate_prefix2 ON rate_prefix ( regionnum );
34 ALTER TABLE part_pkg ADD promo_code varchar(80) NULL;
35 ALTER TABLE h_part_pkg ADD promo_code varchar(80) NULL;
36 CREATE INDEX part_pkg2 ON part_pkg ( promo_code );
37 CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code );
39 ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL;
40 ALTER TABLE h_cust_main ALTER COLUMN zip DROP NOT NULL;
42 Installs w/integrated RT:
43 CREATE SEQUENCE attributes_id_seq;
45 CREATE TABLE Attributes (
46 id INTEGER DEFAULT nextval('attributes_id_seq'),
47 Name varchar(255) NOT NULL ,
48 Description varchar(255) NULL ,
50 ContentType varchar(16),
51 ObjectType varchar(64),
52 ObjectId integer, -- foreign key to anything
53 Creator integer NOT NULL DEFAULT 0 ,
54 Created TIMESTAMP NULL ,
55 LastUpdatedBy integer NOT NULL DEFAULT 0 ,
56 LastUpdated TIMESTAMP NULL ,
61 CREATE INDEX Attributes1 on Attributes(Name);
62 CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);
66 create-history-tables username rate rate_detail rate_region rate_prefix
70 afterwords (for installs w/integrated RT):
73 /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.15
74 /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.17