X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=747b8e29ccc1ebb0a497b52e04916820ec3d5fc0;hp=a179e96b425de76a3808ee03bc8bbd7d8ec8a339;hb=8ca6f203e5dae208d7af581d68671fe47c5e1a1a;hpb=fec5c7b3ffb749ad8658ea6f2366aa5c2be3d3fc

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;