summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2016-05-19 14:09:55 -0700
committerIvan Kohler <ivan@freeside.biz>2016-05-19 14:09:55 -0700
commit24d75c7bb38b8729a40f1468f64d5cf76fb6fef7 (patch)
tree20f88a436734779ac4707944168bd16fcec9e28c
parentc6c6f758f1699388bca7705fd66fb7139955b532 (diff)
remove FK on acct_tr_transaction.svcnum
-rw-r--r--FS/FS/Schema.pm9
1 files changed, 6 insertions, 3 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index cdb0d28a6..359354309 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