support for cch fixed format

[freeside.git] / FS / FS / Schema.pm

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 941eafc..26900b0 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -342,8 +342,11 @@ sub tables_hashref {
         'prog',                     @perl_type, '', '', #deprecated (never used)
       ],
       'primary_key' => 'agentnum',
-      'unique' => [ [ 'agent_custnum' ] ], #one agent per customer?
-      'index' => [ ['typenum'], ['disabled'] ],
+      #'unique' => [ [ 'agent_custnum' ] ], #one agent per customer?
+                                            #insert is giving it a value, tho..
+      #'index' => [ ['typenum'], ['disabled'] ],
+      'unique' => [],
+      'index' => [ ['typenum'], ['disabled'], ['agent_custnum'] ],
     },
 
     'agent_type' => {
@@ -1107,7 +1110,7 @@ sub tables_hashref {
         'taxproductnum', 'serial',      '',        '', '', '',
         'data_vendor',   'varchar', 'NULL',   $char_d, '', '', 
         'taxproduct',    'varchar',     '',   $char_d, '', '', 
-        'description',   'varchar',     '', 2*$char_d, '', '', 
+        'description',   'varchar',     '', 3*$char_d, '', '', 
       ],
       'primary_key' => 'taxproductnum',
       'unique'      => [ [ 'data_vendor', 'taxproduct' ] ],
@@ -2116,7 +2119,7 @@ sub tables_hashref {
 
     'phone_avail' => {
       'columns' => [
-        'availnum',    'int',      '', '', '', '', 
+        'availnum',    'serial',   '', '', '', '', 
         'exportnum',   'int',      '', '', '', '', 
         'countrycode', 'varchar',  '',  3, '', '', 
         'state',       'char', 'NULL',  2, '', '',