From 0fcc421f3bc76dbaf2331a11804d804b08f37545 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Fri, 27 Oct 2017 12:30:06 +0200 Subject: [PATCH] Fixed supp_trans primary key. --- sql/en_US-demo.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index a5f1b465..d2066ec7 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`), + PRIMARY KEY (`type`,`trans_no`,`debtor_no`), KEY `supplier_id` (`supplier_id`), KEY `tran_date` (`tran_date`) ) ENGINE=InnoDB; -- 2.30.2