X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=85ad9453142005a71d0d46dea660982bfad07770;hb=51bf0e9b404cd6e4ae84435230447619269f77c0;hp=d9d5f5a03df230e5858c88a3582034750e4adbd8;hpb=fbfffdabe931d704aae420984058e61dc4196b01;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index d9d5f5a03..85ad94531 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -408,6 +408,8 @@ sub tables_hashref {
 #        'middle',   'varchar', 'NULL', $char_d, '', '', 
         'first',    'varchar', '',     $char_d, '', '', 
         'ss',       'varchar', 'NULL', 11, '', '', 
+        'stateid', 'varchar', 'NULL', $char_d, '', '', 
+        'stateid_state', 'varchar', 'NULL', $char_d, '', '', 
         'birthdate' ,@date_type, '', '', 
         'signupdate',@date_type, '', '', 
         'company',  'varchar', 'NULL', $char_d, '', '', 
@@ -940,6 +942,7 @@ sub tables_hashref {
         'svcnum',   'int',    '',  '', '', '', 
         'recnum',   'int',    '',  '', '', '', 
         'usersvc',  'int',    '',  '', '', '', 
+        'config',   'text',   'NULL',  '', '', '', 
       ],
       'primary_key' => 'svcnum',
       'unique'      => [],
@@ -1195,7 +1198,7 @@ sub tables_hashref {
 
     'part_virtual_field' => {
       'columns' => [
-        'vfieldpart', 'int', '', '', '', '', 
+        'vfieldpart', 'serial', '', '', '', '', 
         'dbtable', 'varchar', '', 32, '', '', 
         'name', 'varchar', '', 32, '', '', 
         'check_block', 'text', 'NULL', '', '', '',