X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=de3659a4ceb5e407ac14dcc2473505d9561a9b85;hb=fc8d730d0a7b31b617c963c5619bd3f45c5c3eb6;hp=5ac2b5f0f99f408c4f73c4880a0c94c07563e7bc;hpb=b70b0d8c6f571a68ffb60c5ca728a230926abee4;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 5ac2b5f0f..de3659a4c 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1688,13 +1688,14 @@ sub tables_hashref { 'zip', 'varchar', 'NULL', 10, '', '', 'country', 'char', '', 2, '', '', # 'trancode', 'int', '', '', '', '' - 'payby', 'char', '', 4, '', '', # CARD/BILL/COMP, should be - 'payinfo', 'varchar', '', 512, '', '', + 'payby', 'char', '', 4, '', '', + 'payinfo', 'varchar', 'NULL', 512, '', '', #'exp', @date_type, '', '' - 'exp', 'varchar', 'NULL', 11, '', '', + 'exp', 'varchar', 'NULL', 11, '', '', 'payname', 'varchar', 'NULL', $char_d, '', '', 'amount', @money_type, '', '', - 'status', 'varchar', 'NULL', $char_d, '', '', + 'status', 'varchar', 'NULL', $char_d, '', '', + 'error_message', 'varchar', 'NULL', $char_d, '', '', ], 'primary_key' => 'paybatchnum', 'unique' => [], @@ -3366,7 +3367,7 @@ sub tables_hashref { 'rated_classnum', 'int', 'NULL', '', '', '', 'rated_ratename', 'varchar', 'NULL', $char_d, '', '', - 'carrierid', 'int', 'NULL', '', '', '', + 'carrierid', 'bigint', 'NULL', '', '', '', # service it was matched to 'svcnum', 'int', 'NULL', '', '', '', @@ -3600,6 +3601,7 @@ sub tables_hashref { 'svcnum', 'int', '', '', '', '', 'countrycode', 'varchar', '', 3, '', '', 'phonenum', 'varchar', '', 15, '', '', #12 ? + 'sim_imsi', 'varchar', 'NULL', 15, '', '', 'pin', 'varchar', 'NULL', $char_d, '', '', 'sip_password', 'varchar', 'NULL', $char_d, '', '', 'phone_name', 'varchar', 'NULL', $char_d, '', '',