X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=5d453ac271b12d219ff4614acf91ae1196d6e81e;hp=cc0f21ffcccbf36155f4fe7b2983a6861bf8f2d4;hb=91fd4ea0e91ee9e6717e0b12e01eebb8f8b21322;hpb=4cd3537f6e3e14a596c67478bb83b2095303ec50 diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index cc0f21ffc..5d453ac27 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -2022,6 +2022,7 @@ sub tables_hashref { 'columns' => [ 'svcnum', 'int', '', '', '', '', 'acctnum', 'varchar', '', 16, '', '', + 'installdate', @date_type, '', '', 'note', 'text', 'NULL', '', '', '', ], 'primary_key' => 'svcnum', @@ -2036,7 +2037,8 @@ sub tables_hashref { 'serial', 'varchar', 'NULL', $char_d, '', '', 'ip_addr', 'varchar', 'NULL', 40, '', '', 'hw_addr', 'varchar', 'NULL', 12, '', '', - 'statusnum','int', 'NULL', '', '', '', + 'smartcard','varchar', 'NULL', 30, '', '', + 'statusnum','int', 'NULL', '', '', '', 'note', 'text', 'NULL', '', '', '', ], 'primary_key' => 'svcnum', @@ -2069,6 +2071,7 @@ sub tables_hashref { 'columns' => [ 'statusnum', 'serial', '', '', '', '', 'label' ,'varchar', '', $char_d, '', '', + 'disabled', 'char', 'NULL', 1, '', '', ], 'primary_key' => 'statusnum', 'unique' => [ ],