X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=09daef0144a8e845f7b0a9d02b744f0ecb310c8d;hb=cb0b8c862de7c7ab68b172faa29167f47894627b;hp=ca54d7b798a6b19c2ca0b6b044ba16a21acffd6b;hpb=3a201934245c2e72b167804a6d512e0e6d435f65;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index ca54d7b79..09daef014 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -570,6 +570,7 @@ sub tables_hashref { 'itemdesc', 'varchar', 'NULL', $char_d, '', '', 'itemcomment', 'varchar', 'NULL', $char_d, '', '', 'section', 'varchar', 'NULL', $char_d, '', '', + 'freq', 'varchar', 'NULL', $char_d, '', '', 'quantity', 'int', 'NULL', '', '', '', 'unitsetup', @money_typen, '', '', 'unitrecur', @money_typen, '', '', @@ -767,6 +768,7 @@ sub tables_hashref { 'squelch_cdr','char', 'NULL', 1, '', '', 'cdr_termination_percentage', 'decimal', 'NULL', '', '', '', 'invoice_terms', 'varchar', 'NULL', $char_d, '', '', + 'credit_limit', @money_typen, '', '', 'archived', 'char', 'NULL', 1, '', '', 'email_csv_cdr', 'char', 'NULL', 1, '', '', ], @@ -960,6 +962,30 @@ sub tables_hashref { 'unique' => [], 'index' => [ ['disabled'] ], }, + + 'cust_tag' => { + 'columns' => [ + 'custtagnum', 'serial', '', '', '', '', + 'custnum', 'int', '', '', '', '', + 'tagnum', 'int', '', '', '', '', + ], + 'primary_key' => 'custtagnum', + 'unique' => [ [ 'custnum', 'tagnum' ] ], + 'index' => [ [ 'custnum' ] ], + }, + + 'part_tag' => { + 'columns' => [ + 'tagnum', 'serial', '', '', '', '', + 'tagname', 'varchar', '', $char_d, '', '', + 'tagdesc', 'varchar', 'NULL', $char_d, '', '', + 'tagcolor', 'varchar', 'NULL', 6, '', '', + 'disabled', 'char', 'NULL', 1, '', '', + ], + 'primary_key' => 'tagnum', + 'unique' => [], #[ [ 'tagname' ] ], #? + 'index' => [ [ 'disabled' ] ], + }, 'cust_main_exemption' => { 'columns' => [ @@ -1265,6 +1291,7 @@ sub tables_hashref { 'pkgnum', 'serial', '', '', '', '', 'custnum', 'int', '', '', '', '', 'pkgpart', 'int', '', '', '', '', + 'pkgbatch', 'varchar', 'NULL', $char_d, '', '', 'locationnum', 'int', 'NULL', '', '', '', 'otaker', 'varchar', 'NULL', 32, '', '', 'usernum', 'int', 'NULL', '', '', '', @@ -1286,7 +1313,8 @@ sub tables_hashref { ], 'primary_key' => 'pkgnum', 'unique' => [], - 'index' => [ ['custnum'], ['pkgpart'], [ 'locationnum' ], [ 'usernum' ], + 'index' => [ ['custnum'], ['pkgpart'], [ 'pkgbatch' ], [ 'locationnum' ], + [ 'usernum' ], [ 'start_date' ], ['setup'], ['last_bill'], ['bill'], ['susp'], ['adjourn'], ['expire'], ['cancel'], ['change_date'], @@ -1461,6 +1489,7 @@ sub tables_hashref { 'pay_weight', 'real', 'NULL', '', '', '', 'credit_weight', 'real', 'NULL', '', '', '', 'agentnum', 'int', 'NULL', '', '', '', + 'fcc_ds0s', 'int', 'NULL', '', '', '', 'no_auto', 'char', 'NULL', 1, '', '', ], 'primary_key' => 'pkgpart', @@ -1485,6 +1514,17 @@ sub tables_hashref { # XXX somewhat borked unique: we don't really want a hidden and unhidden # it turns out we'd prefer to use svc, bill, and invisibill (or something) + 'part_pkg_discount' => { + 'columns' => [ + 'pkgdiscountnum', 'serial', '', '', '', '', + 'pkgpart', 'int', '', '', '', '', + 'discountnum', 'int', '', '', '', '', + ], + 'primary_key' => 'pkgdiscountnum', + 'unique' => [ [ 'pkgpart', 'discountnum' ] ], + 'index' => [], + }, + 'part_pkg_taxclass' => { 'columns' => [ 'taxclassnum', 'serial', '', '', '', '', @@ -1673,7 +1713,8 @@ sub tables_hashref { 'cgp_rpopallowed', 'char', 'NULL', 1, '', '', #RPOPAllowed 'cgp_mailtoall', 'char', 'NULL', 1, '', '', #MailToAll 'cgp_addmailtrailer', 'char', 'NULL', 1, '', '', #AddMailTrailer - #XXX archive messages, mailing lists + 'cgp_archiveafter', 'int', 'NULL', '', '', '', #ArchiveMessagesAfter + #XXX mailing lists #preferences 'cgp_deletemode', 'varchar', 'NULL', $char_d, '', '',#DeleteMode 'cgp_emptytrash', 'varchar', 'NULL', $char_d, '', '',#EmptyTrash @@ -1683,7 +1724,6 @@ sub tables_hashref { 'cgp_prontoskinname', 'varchar', 'NULL', $char_d, '', '',#ProntoSkinName 'cgp_sendmdnmode', 'varchar', 'NULL', $char_d, '', '',#SendMDNMode #mail -#vacation message, redirect all mail, mail rules #XXX RPOP settings ], 'primary_key' => 'svcnum', @@ -1745,7 +1785,7 @@ sub tables_hashref { 'acct_def_cgp_rpopallowed', 'char', 'NULL', 1, '', '', 'acct_def_cgp_mailtoall', 'char', 'NULL', 1, '', '', 'acct_def_cgp_addmailtrailer', 'char', 'NULL', 1, '', '', - #XXX archive messages + 'acct_def_cgp_archiveafter', 'int', 'NULL', '', '', '', #preferences 'acct_def_cgp_deletemode', 'varchar', 'NULL', $char_d, '', '', 'acct_def_cgp_emptytrash', 'varchar', 'NULL', $char_d, '', '', @@ -1754,8 +1794,6 @@ sub tables_hashref { 'acct_def_cgp_skinname', 'varchar', 'NULL', $char_d, '', '', 'acct_def_cgp_prontoskinname', 'varchar', 'NULL', $char_d, '', '', 'acct_def_cgp_sendmdnmode', 'varchar', 'NULL', $char_d, '', '', - #mail - #XXX rules, archive rule, spam foldering rule(s) ], 'primary_key' => 'svcnum', 'unique' => [ ], @@ -1770,6 +1808,7 @@ sub tables_hashref { 'recaf', 'char', '', 2, '', '', 'rectype', 'varchar', '', 5, '', '', 'recdata', 'varchar', '', 255, '', '', + 'ttl', 'int', 'NULL', '', '', '', ], 'primary_key' => 'recnum', 'unique' => [], @@ -1788,40 +1827,40 @@ sub tables_hashref { 'cgp_rule' => { 'columns' => [ - 'rulenum', 'serial', '', '', '', '', - 'name', 'varchar', '', $char_d, '', '', - 'comment', 'varchar', '', $char_d, '', '', - 'svcnum', 'int', '', '', '', '', - 'priority', 'int', '', '', '', '', + 'rulenum', 'serial', '', '', '', '', + 'name', 'varchar', '', $char_d, '', '', + 'comment', 'varchar', 'NULL', $char_d, '', '', + 'svcnum', 'int', '', '', '', '', + 'priority', 'int', '', '', '', '', ], 'primary_key' => 'rulenum', - 'unique' => [], - 'index ' => [ [ 'svcnum' ] ], + 'unique' => [ [ 'svcnum', 'name' ] ], + 'index' => [ [ 'svcnum' ] ], }, 'cgp_rule_condition' => { 'columns' => [ - 'ruleconditionnum', 'serial', '', '', '', '', - 'condition', 'varchar', '', $char_d, '', '', - 'op', 'varchar', '', $char_d, '', '', - 'params', 'varchar', '', 255, '', '', - 'rulenum', 'int', '', '', '', '', + 'ruleconditionnum', 'serial', '', '', '', '', + 'conditionname', 'varchar', '', $char_d, '', '', + 'op', 'varchar', 'NULL', $char_d, '', '', + 'params', 'varchar', 'NULL', 255, '', '', + 'rulenum', 'int', '', '', '', '', ], 'primary_key' => 'ruleconditionnum', 'unique' => [], - 'index ' => [ [ 'rulenum' ] ], + 'index' => [ [ 'rulenum' ] ], }, 'cgp_rule_action' => { 'columns' => [ - 'ruleactionnum', 'serial', '', '', '', '', - 'action', 'varchar', '', $char_d, '', '', - 'params', 'varchar', '', 255, '', '', - 'rulenum', 'int', '', '', '', '', + 'ruleactionnum', 'serial', '', '', '', '', + 'action', 'varchar', '', $char_d, '', '', + 'params', 'varchar', 'NULL', 255, '', '', + 'rulenum', 'int', '', '', '', '', ], 'primary_key' => 'ruleactionnum', 'unique' => [], - 'index ' => [ [ 'rulenum' ] ], + 'index' => [ [ 'rulenum' ] ], }, 'svc_forward' => { @@ -2148,12 +2187,18 @@ sub tables_hashref { 'acct_snarf' => { 'columns' => [ - 'snarfnum', 'int', '', '', '', '', - 'svcnum', 'int', '', '', '', '', - 'machine', 'varchar', '', 255, '', '', - 'protocol', 'varchar', '', $char_d, '', '', - 'username', 'varchar', '', $char_d, '', '', - '_password', 'varchar', '', $char_d, '', '', + 'snarfnum', 'serial', '', '', '', '', + 'snarfname', 'varchar', 'NULL', $char_d, '', '', + 'svcnum', 'int', '', '', '', '', + 'machine', 'varchar', '', 255, '', '', + 'protocol', 'varchar', '', $char_d, '', '', + 'username', 'varchar', '', $char_d, '', '', + '_password', 'varchar', '', $char_d, '', '', + 'check_freq', 'int', 'NULL', '', '', '', + 'leavemail', 'char', 'NULL', 1, '', '', + 'apop', 'char', 'NULL', 1, '', '', + 'tls', 'char', 'NULL', 1, '', '', + 'mailbox', 'varchar', 'NULL', $char_d, '', '', ], 'primary_key' => 'snarfnum', 'unique' => [], @@ -2228,6 +2273,7 @@ sub tables_hashref { 'conn_sec', 'int', '', '', '0', '', 'min_charge', 'decimal', '', '10,5', '', '', #@money_type, '', '', 'sec_granularity', 'int', '', '', '', '', + 'ratetimenum', 'int', 'NULL', '', '', '', #time period (link to table of periods)? 'classnum', 'int', 'NULL', '', '', '', ], @@ -2259,6 +2305,28 @@ sub tables_hashref { 'index' => [ [ 'countrycode' ], [ 'npa' ], [ 'regionnum' ] ], }, + 'rate_time' => { + 'columns' => [ + 'ratetimenum', 'serial', '', '', '', '', + 'ratetimename', 'varchar', '', $char_d, '', '', + ], + 'primary_key' => 'ratetimenum', + 'unique' => [], + 'index' => [], + }, + + 'rate_time_interval' => { + 'columns' => [ + 'intervalnum', 'serial', '', '', '', '', + 'stime', 'int', '', '', '', '', + 'etime', 'int', '', '', '', '', + 'ratetimenum', 'int', '', '', '', '', + ], + 'primary_key' => 'intervalnum', + 'unique' => [], + 'index' => [], + }, + 'usage_class' => { 'columns' => [ 'classnum', 'serial', '', '', '', '', @@ -2440,6 +2508,8 @@ sub tables_hashref { 'uniqueid', 'varchar', '', 32, \"''", '', 'userfield', 'varchar', '', 255, \"''", '', + 'max_callers', 'int', 'NULL', '', '', '', + ### # fields for unitel/RSLCOM/convergent that don't map well to asterisk # defaults @@ -2524,6 +2594,7 @@ sub tables_hashref { 'termpart', 'int', '', '', '', '',#future use see below 'rated_price', 'decimal', 'NULL', '10,4', '', '', 'status', 'varchar', 'NULL', 32, '', '', + 'svcnum', 'int', 'NULL', '', '', '', ], 'primary_key' => 'cdrtermnum', 'unique' => [ [ 'acctid', 'termpart' ] ], @@ -2592,12 +2663,13 @@ sub tables_hashref { 'columns' => [ 'itemnum', 'serial', '', '', '', '', 'classnum', 'int', '', '', '', '', + 'agentnum', 'int', 'NULL', '', '', '', 'item', 'varchar', '', $char_d, '', '', 'svcnum', 'int', 'NULL', '', '', '', ], 'primary_key' => 'itemnum', 'unique' => [ [ 'classnum', 'item' ] ], - 'index' => [ [ 'classnum' ], [ 'svcnum' ] ], + 'index' => [ [ 'classnum' ], [ 'agentnum' ], [ 'svcnum' ] ], }, 'inventory_class' => { @@ -2796,10 +2868,11 @@ sub tables_hashref { 'svc_pbx' => { 'columns' => [ - 'svcnum', 'int', '', '', '', '', - 'id', 'int', 'NULL', '', '', '', - 'title', 'varchar', 'NULL', $char_d, '', '', - 'max_extensions', 'int', 'NULL', '', '', '', + 'svcnum', 'int', '', '', '', '', + 'id', 'int', 'NULL', '', '', '', + 'title', 'varchar', 'NULL', $char_d, '', '', + 'max_extensions', 'int', 'NULL', '', '', '', + 'max_simultaneous', 'int', 'NULL', '', '', '', ], 'primary_key' => 'svcnum', 'unique' => [], @@ -2845,6 +2918,58 @@ sub tables_hashref { 'index' => [['listnum'],['svcnum'],['contactemailnum'],['email']], }, + 'bill_batch' => { + 'columns' => [ + 'batchnum', 'serial', '', '', '', '', + 'status', 'char', 'NULL','1', '', '', + 'pdf', 'blob', 'NULL', '', '', '', + ], + 'primary_key' => 'batchnum', + 'unique' => [], + 'index' => [], + }, + + 'cust_bill_batch' => { + 'columns' => [ + 'billbatchnum', 'serial', '', '', '', '', + 'batchnum', 'int', '', '', '', '', + 'invnum', 'int', '', '', '', '', + ], + 'primary_key' => 'billbatchnum', + 'unique' => [], + 'index' => [ [ 'batchnum' ], [ 'invnum' ] ], + }, + + 'cust_bill_batch_option' => { + 'columns' => [ + 'optionnum', 'serial', '', '', '', '', + 'billbatchnum', 'int', '', '', '', '', + 'optionname', 'varchar', '', $char_d, '', '', + 'optionvalue', 'text', 'NULL', '', '', '', + ], + 'primary_key' => 'optionnum', + 'unique' => [], + 'index' => [ [ 'billbatchnum' ], [ 'optionname' ] ], + }, + + 'msg_template' => { + 'columns' => [ + 'msgnum', 'serial', '', '', '', '', + 'msgname', 'varchar', '', $char_d, '', '', + 'agentnum', 'int', 'NULL', '', '', '', + 'subject', 'varchar', 'NULL', 512, '', '', + 'mime_type', 'varchar', '', $char_d, '', '', + 'body', 'blob', 'NULL', '', '', '', + 'disabled', 'char', 'NULL', 1, '', '', + 'from_addr', 'varchar', 'NULL', 255, '', '', + 'bcc_addr', 'varchar', 'NULL', 255, '', '', + ], + 'primary_key' => 'msgnum', + 'unique' => [ ['msgname', 'mime_type'] ], + 'index' => [ ['agentnum'], ] + }, + + # name type nullability length default local