From: Ivan Kohler <ivan@freeside.biz>
Date: Thu, 19 May 2016 21:09:55 +0000 (-0700)
Subject: remove FK on acct_tr_transaction.svcnum
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=24d75c7bb38b8729a40f1468f64d5cf76fb6fef7

remove FK on acct_tr_transaction.svcnum
---

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