X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-setup;h=c867a721fb90ecffe83475cba147062c72607172;hb=6cf964d0dc008621fb30fd2da28e2c44f29c6364;hp=49953b8f7db68bcf61fce73037fe66d5bbec412b;hpb=f7fd2a3e34da751cbc02bbf215e99c6dc89adc15;p=freeside.git

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index 49953b8f7..c867a721f 100755
--- a/FS/bin/freeside-setup
+++ b/FS/bin/freeside-setup
@@ -463,7 +463,7 @@ sub tables_hash_hack {
         'city',     'varchar', '',     $char_d,
         'county',   'varchar', 'NULL', $char_d,
         'state',    'varchar', 'NULL', $char_d,
-        'zip',      'varchar', '',     10,
+        'zip',      'varchar', 'NULL', 10,
         'country',  'char', '',     2,
         'daytime',  'varchar', 'NULL', 20,
         'night',    'varchar', 'NULL', 20,
@@ -597,7 +597,7 @@ sub tables_hash_hack {
         'address2', 'varchar', 'NULL', $char_d,
         'city',     'varchar', '',     $char_d,
         'state',    'varchar', 'NULL', $char_d,
-        'zip',      'varchar', '',     10,
+        'zip',      'varchar', 'NULL', 10,
         'country',  'char', '',     2,
 #        'trancode', 'int', '', '',
         'cardnum',  'varchar', '',     16,
@@ -692,8 +692,8 @@ sub tables_hash_hack {
         'taxclass',   'varchar', 'NULL', $char_d,
       ],
       'primary_key' => 'pkgpart',
-      'unique' => [ [ 'promo_code' ] ],
-      'index' => [ [ 'disabled' ] ],
+      'unique' => [],
+      'index' => [ [ 'promo_code' ], [ 'disabled' ] ],
     },
 
 #    'part_title' => {
@@ -1190,8 +1190,9 @@ sub tables_hash_hack {
       'columns' => [
         'regionnum',   'serial',      '', '',
         'regionname',  'varchar',     '', $char_d,
+      ],
       'primary_key' => 'regionnum',
-      'unique'      => [].
+      'unique'      => [],
       'index'       => [],
     },
 
@@ -1200,12 +1201,13 @@ 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',
-      'unique'      => [].
+      'unique'      => [],
       'index'       => [ [ 'countrycode' ], [ 'regionnum' ] ],
+    },
 
 
   );