From 5cd2769b439929e59a8a56da1f42ba5bdb582d09 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Fri, 27 Oct 2017 09:06:42 +0200 Subject: [PATCH] Fixed debtor_trans primary key to allow multiply AR accounts in journal transactions. --- sql/en_US-demo.sql | 2 +- sql/en_US-new.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) 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_`) -- 2.30.2