diff options
author | ivan <ivan> | 2001-09-26 09:17:06 +0000 |
---|---|---|
committer | ivan <ivan> | 2001-09-26 09:17:06 +0000 |
commit | 8ca6f203e5dae208d7af581d68671fe47c5e1a1a (patch) | |
tree | 1b3abd74d3b2118a3ca059e4b2ad65632f98c5e4 /httemplate/docs | |
parent | fec5c7b3ffb749ad8658ea6f2366aa5c2be3d3fc (diff) |
add part_pop_local table
Diffstat (limited to 'httemplate/docs')
-rw-r--r-- | httemplate/docs/schema.html | 9 | ||||
-rw-r--r-- | httemplate/docs/upgrade8.html | 10 |
2 files changed, 19 insertions, 0 deletions
diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index e3fe98096..c3cb51425 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -273,6 +273,15 @@ <li>exch - exchange <li>loc - rest of number </ul> + <li><a name="part_pop_local" href="man/FS/part_pop_local.html">part_pop_local</a> - Local calling areas + <ul> + <li>localnum - primary key + <li>popnum - primary key + <li>city + <li>state + <li>npa - area code + <li>nxx - exchange + </ul> <li><a name="svc_acct_sm" href="man/FS/svc_acct_sm.html">svc_acct_sm</a> - <b>DEPRECIATED</b> Domain mail aliases <ul> <li>svcnum - <a href="#cust_svc">primary key</a> diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index a179e96b4..747b8e29c 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -118,6 +118,16 @@ CREATE TABLE queue_arg ( ); CREATE INDEX queue_arg1 ON queue_arg ( jobnum ); +CREATE TABLE part_pop_local ( + localnum int primary key, + popnum int not null, + city varchar(80) null, + state char(2) null, + npa char(3) not null, + nxx char(3) not null +); +CREATE UNIQUE INDEX part_pop_local1 ON part_pop_local ( npa, nxx ); + ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; |