From c428c827fef8156052be0e430be9af738536e3b0 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sat, 28 Oct 2017 10:27:23 +0200 Subject: [PATCH] Fixed supp_trans primary keys, rerun. --- 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 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; -- 2.30.2