X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=a50b551da9398c7ec8189702b70a82cadbd7c392;hb=9aa198dfc90054de34cf1af8f3238d004416ebc9;hp=cdb0d28a649e5a3b6ba0465bd512f6fc90ac57ef;hpb=5f26e344a894a65dfa7ccff7d3063e2f20eb0eff;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index cdb0d28a6..a50b551da 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -3870,9 +3870,12 @@ sub tables_hashref { 'unique' => [], 'index' => [ ['svcnum', 'transaction_id'] ], 'foreign_keys' => [ - { columns => [ 'svcnum' ], - table => 'svc_acct', #'cust_svc', - }, + # problems w/deleted services, and as per below, this + # is our internal hack, not a customer-facing feature + #{ columns => [ 'svcnum' ], + # table => 'svc_acct', #'cust_svc', + #}, + # 1. RT tables aren't part of our data structure, so # we can't make sure Queue is created already # 2. This is our internal hack for time tracking, not @@ -6632,6 +6635,7 @@ sub tables_hashref { 'min_level', 'int', 'NULL', '', '', '', 'msgnum', 'int', '', '', '', '', 'to_addr', 'varchar', 'NULL', 255, '', '', + 'context_height', 'int', 'NULL', '', '', '', ], 'primary_key' => 'logemailnum', 'unique' => [],