going with 6 digit misnamed "npa" for now

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index 9f50ec3..1c5c3d2 100755 (executable)
--- a/FS/bin/freeside-setup
+++ b/FS/bin/freeside-setup
@@ -1201,7 +1201,7 @@ sub tables_hash_hack {
         'prefixnum',   'serial',    '', '',
         'regionnum',   'int',       '', '',,
         'countrycode', 'varchar',     '', 3,
-        'npa',         'varchar', 'NULL', 4, #not 3?
+        'npa',         'varchar', 'NULL', 6,
         'nxx',         'varchar', 'NULL', 3,
       ],
       'primary_key' => 'prefixnum',

diff --git a/README.1.5.0pre7 b/README.1.5.0pre7
index 04a323c..b521d5d 100644 (file)
--- a/README.1.5.0pre7
+++ b/README.1.5.0pre7
@@ -24,7 +24,7 @@ CREATE TABLE rate_prefix (
     prefixnum serial NOT NULL,
     regionnum int NOT NULL, 
     countrycode varchar(3) NOT NULL,
-    npa varchar(4) NULL,
+    npa varchar(6) NULL,
     nxx varchar(3) NULL,
     PRIMARY KEY (prefixnum)
 );

diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html
index 9dacf91..9e6418b 100644 (file)
--- a/httemplate/docs/upgrade10.html
+++ b/httemplate/docs/upgrade10.html
@@ -216,7 +216,7 @@ CREATE TABLE rate_prefix (
     prefixnum serial NOT NULL,
     regionnum int NOT NULL, 
     countrycode varchar(3) NOT NULL,
-    npa varchar(4) NULL,
+    npa varchar(6) NULL,
     nxx varchar(3) NULL,
     PRIMARY KEY (prefixnum)
 );