From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Sat, 28 Oct 2017 08:27:23 +0000 (+0200)
Subject: Fixed supp_trans primary keys, rerun.
X-Git-Tag: v2.4.3~16
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=c428c827fef8156052be0e430be9af738536e3b0

Fixed supp_trans primary keys, rerun.
---

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index d2066ec7..f2b7e2f0 100644
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -2069,7 +2069,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `rate` double NOT NULL DEFAULT '1',
   `alloc` double NOT NULL DEFAULT '0',
   `tax_included` tinyint(1) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`type`,`trans_no`,`debtor_no`),
+  PRIMARY KEY (`type`,`trans_no`,`supplier_id`),
   KEY `supplier_id` (`supplier_id`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;
diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index cf3920cb..2276c338 100644
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -1796,7 +1796,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `rate` double NOT NULL default '1',
   `alloc` double NOT NULL default '0',
   `tax_included` tinyint(1) NOT NULL default '0',
-  PRIMARY KEY (`type`,`trans_no`),
+  PRIMARY KEY (`type`,`trans_no`,`supplier_id`),
   KEY `supplier_id` (`supplier_id`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;