From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Fri, 27 Oct 2017 07:06:42 +0000 (+0200)
Subject: Fixed debtor_trans primary key to allow multiply AR accounts in journal transactions.
X-Git-Tag: v2.4.3~18
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=5cd2769b439929e59a8a56da1f42ba5bdb582d09

Fixed debtor_trans primary key to allow multiply AR accounts in journal transactions.
---

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index dd13f532..a5f1b465 100644
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -718,7 +718,7 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
   `dimension2_id` int(11) NOT NULL DEFAULT '0',
   `payment_terms` int(11) DEFAULT NULL,
   `tax_included` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`type`,`trans_no`),
+  PRIMARY KEY (`type`,`trans_no`,`debtor_no`),
   KEY `debtor_no` (`debtor_no`,`branch_code`),
   KEY `tran_date` (`tran_date`),
   KEY `order_` (`order_`)
diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index ad831659..cf3920cb 100644
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -639,7 +639,7 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
   `dimension2_id` int(11) NOT NULL default '0',
   `payment_terms` int(11) default NULL,
   `tax_included` tinyint(1) unsigned NOT NULL default '0',
-  PRIMARY KEY (`type`,`trans_no`),
+  PRIMARY KEY (`type`,`trans_no`,`debtor_no`),
   KEY `debtor_no` (`debtor_no`,`branch_code`),
   KEY `tran_date` (`tran_date`),
   KEY `order_` (`order_`)