X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=819fae9f5a7a6548765613effcf73089534029b7;hb=bb119c4cc86e906f698a205437790bd8f96bb3d0;hp=430efd9e2208ebb6f1cc2cadbee48ac970865361;hpb=ccb341fa032dc2e57a12d69ae1b06198a6731286;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 430efd9e2..819fae9f5 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1452,7 +1452,7 @@ sub tables_hashref { [ 'usernum' ], [ 'agent_pkgid' ], ['order_date'], [ 'start_date' ], ['setup'], ['bill'], ['last_bill'], ['susp'], ['adjourn'], ['cancel'], - ['expire'], ['contract_end'], ['change_date'], + ['expire'], ['contract_end'], ['change_date'], ['no_auto'], ], }, @@ -1631,7 +1631,7 @@ sub tables_hashref { 'primary_key' => 'pkgpart', 'unique' => [], 'index' => [ [ 'promo_code' ], [ 'disabled' ], [ 'classnum' ], - [ 'agentnum' ], + [ 'agentnum' ], ['no_auto'], ], }, @@ -2337,7 +2337,7 @@ sub tables_hashref { 'msgcat' => { 'columns' => [ 'msgnum', 'serial', '', '', '', '', - 'msgcode', 'varchar', '', $char_d, '', '', + 'msgcode', 'varchar', '', 255, '', '', 'locale', 'varchar', '', 16, '', '', 'msg', 'text', '', '', '', '', ], @@ -3354,6 +3354,24 @@ sub tables_hashref { 'index' => [ ['agentnum'], ] }, + 'cust_msg' => { + 'columns' => [ + 'custmsgnum', 'serial', '', '', '', '', + 'custnum', 'int', '', '', '', '', + 'msgnum', 'int', 'NULL', '', '', '', + '_date', @date_type, '', '', + 'env_from', 'varchar', 'NULL', 255, '', '', + 'env_to', 'varchar', 'NULL', 255, '', '', + 'header', 'blob', 'NULL', '', '', '', + 'body', 'blob', 'NULL', '', '', '', + 'error', 'varchar', 'NULL', 255, '', '', + 'status', 'varchar', '',$char_d, '', '', + ], + 'primary_key' => 'custmsgnum', + 'unique' => [ ], + 'index' => [ ['custnum'], ], + }, + 'svc_cert' => { 'columns' => [ 'svcnum', 'int', '', '', '', '',