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.0pre742
1 files changed, 0 insertions, 42 deletions
diff --git a/README.1.5.0pre7 b/README.1.5.0pre7
deleted file mode 100644
index cd7e5a2..0000000
--- a/README.1.5.0pre7
+++ /dev/null
@@ -1,42 +0,0 @@
-CREATE TABLE rate (
- ratenum serial NOT NULL,
- ratename varchar(80) NOT NULL,
- PRIMARY KEY (ratenum)
-);
-
-CREATE TABLE rate_detail (
- ratenum int NOT NULL,
- orig_regionnum int NULL,
- dest_regionnum int NOT NULL,
- min_included int NOT NULL,
- min_charge decimal(10,2) NOT NULL,
- sec_granularity int NOT NULL
-);
-CREATE UNIQUE INDEX rate_detail1 ON rate_detail ( ratenum, orig_regionnum, dest_regionnum );
-
-CREATE TABLE rate_region (
- regionnum serial NOT NULL,
- regionname varchar(80) NOT NULL,
- PRIMARY KEY (regionnum)
-);
-
-CREATE TABLE rate_prefix (
- prefixnum serial NOT NULL,
- regionnum int NOT NULL,
- countrycode varchar(3) NOT NULL,
- npa varchar(4) NULL,
- nxx varchar(3) NULL,
- PRIMARY KEY (prefixnum)
-);
-CREATE INDEX rate_prefix1 ON rate_prefix ( countrycode );
-CREATE INDEX rate_prefix2 ON rate_prefix ( regionnum );
-
-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 );
-CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code );
-
-dbdef-create username
-create-history-tables username rate rate_detail rate_region rate_prefix
-dbdef-create username
-