diff options
author | ivan <ivan> | 2005-04-02 22:46:44 +0000 |
---|---|---|
committer | ivan <ivan> | 2005-04-02 22:46:44 +0000 |
commit | f583418a23dfb001978d3abf8476670d5adb96af (patch) | |
tree | 14bc6232c49f4ef9a1890f95f0d8dbc28536d334 /httemplate/docs | |
parent | 5d2eb9bf6bc24562ed6cff037379e78a2da7a654 (diff) |
herding elephants: add primary keys to *all* tables for slony
Diffstat (limited to 'httemplate/docs')
-rw-r--r-- | httemplate/docs/schema.html | 5 | ||||
-rw-r--r-- | httemplate/docs/upgrade10.html | 31 |
2 files changed, 33 insertions, 3 deletions
diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index e9688756b..cdb59a2e9 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -23,6 +23,7 @@ </ul> <li><a name="cust_bill" href="man/FS/cust_bill.html">cust_bill</a> - Invoices. Declarations that a customer owes you money. The specific charges are itemized in <a href="#cust_bill_pkg">cust_bill_pkg</a>. <ul> + <li>billpkgnum - primary_key <li>invnum - primary key <li>custnum - <a href="#cust_main">customer</a> <li>_date @@ -293,6 +294,7 @@ </ul> <li><a name="reg_code_pkg" href="man/FS/reg_code_pkg.html">reg_code_pkg</A> - Registration code link to package definitions <ul> + <li>codepkgnum - primary key <li>codenum - <a href="#reg_code">Registration code</a> <li>pkgpart - <a href="#part_pkg">Package definition</a> </ul> @@ -321,6 +323,7 @@ </ul> <li><a name="pkg_svc" href="man/FS/pkg_svc.html">pkg_svc</a> <ul> + <li>pkgsvcnum - primary key <li>pkgpart - <a href="#part_pkg">Package definition</a> <li>svcpart - <a href="#part_svc">Service definition</a> <li>quantity - quantity of this service that this package includes @@ -437,6 +440,7 @@ </ul> <li><a name="type_pkgs" href="man/FS/type_pkgs.html">type_pkgs</a> <ul> + <li>typepkgnum - primary key <li>typenum - <a href="#agent_type">agent type</a> <li>pkgpart - <a href="#part_pkg">Package definition</a> </ul> @@ -474,6 +478,7 @@ </ul> <li><a name="rate_detail" href="man/FS/rate_detail.html">rate_detail</a> - Call rate detail <ul> + <li>ratedetailnum - primary key <li>ratenum - <a href="#rate">rate plan</a> <li>orig_regionnum - call origination <a href="#rate_region">region</a> <li>dest_regionnum - call destination <a href="#rate_region">region</a> diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 70a9aeee3..b81268e46 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -52,8 +52,10 @@ CREATE TABLE router ( ); CREATE TABLE part_svc_router ( + svcrouternum serial, svcpart int NOT NULL, - routernum int NOT NULL + routernum int NOT NULL, + PRIMARY KEY (svcrouternum), ); CREATE TABLE addr_block ( @@ -186,10 +188,11 @@ CREATE TABLE cust_pay_void ( CREATE INDEX cust_pay_void1 ON cust_pay_void(custnum); CREATE TABLE part_pkg_option ( - optionnum int primary key, + optionnum serial, pkgpart int not null, optionname varchar(80) not null, optionvalue text NULL + PRIMARY KEY (optionnum), ); CREATE INDEX part_pkg_option1 ON part_pkg_option ( pkgpart ); CREATE INDEX part_pkg_option2 ON part_pkg_option ( optionname ); @@ -201,12 +204,14 @@ CREATE TABLE rate ( ); CREATE TABLE rate_detail ( + ratedetailnum serial NOT NULL, 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 + sec_granularity int NOT NULL, + PRIMARY KEY (ratedetailnum) ); CREATE UNIQUE INDEX rate_detail1 ON rate_detail ( ratenum, orig_regionnum, dest_regionnum ); @@ -237,8 +242,10 @@ CREATE UNIQUE INDEX reg_code1 ON reg_code ( agentnum, code ); CREATE INDEX reg_code2 ON reg_code ( agentnum ); CREATE TABLE reg_code_pkg ( + codepkgnum serial, codenum int NOT NULL, pkgpart int NOT NULL + PRIMARY KEY (codepkgnum) ); CREATE UNIQUE INDEX reg_code_pkg1 ON reg_code_pkg ( codenum, pkgpart ); CREATE INDEX reg_code_pkg2 ON reg_code_pkg ( codenum ); @@ -298,6 +305,24 @@ CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code ); ALTER TABLE prepay_credit ADD agentnum integer NULL; ALTER TABLE h_prepay_credit ADD agentnum integer NULL; +ALTER TABLE type_pkgs ADD typepkgnum int; +ALTER TABLE type_pkgs ALTER COLUMN typepkgnum SET DEFAULT nextval('public.type_pkgs_typepkgnum_seq'::text); +CREATE SEQUENCE type_pkgs_typepkgnum_seq; +ALTER TABLE type_pkgs ALTER typepkgnum SET NOT NULL; +ALTER TABLE type_pkgs ADD PRIMARY KEY (typepkgnum); + +ALTER TABLE cust_bill_pkg ADD billpkgnum int; +ALTER TABLE cust_bill_pkg ALTER COLUMN billpkgnum SET DEFAULT nextval('public.cust_bill_pkg_billpkgnum_seq'::text); +CREATE SEQUENCE cust_bill_pkg_billpkgnum_seq; +ALTER TABLE cust_bill_pkg ALTER billpkgnum SET NOT NULL; +ALTER TABLE cust_bill_pkg ADD PRIMARY KEY (billpkgnum); + +ALTER TABLE pkg_svc ADD pkgsvcnum int; +ALTER TABLE pkg_svc ALTER COLUMN pkgsvcnum SET DEFAULT nextval('public.pkg_svc_pkgsvcnum_seq'::text); +CREATE SEQUENCE pkg_svc_pkgsvcnum_seq; +ALTER TABLE pkg_svc ALTER pkgsvcnum SET NOT NULL; +ALTER TABLE pkg_svc ADD PRIMARY KEY (pkgsvcnum); + On recent Pg versions: ALTER TABLE svc_forward ALTER COLUMN srcsvc DROP NOT NULL; |