X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-demo.sql;h=d2066ec7a9270ee4e3c6b10d55236db69dbe3ff2;hb=0fcc421f3bc76dbaf2331a11804d804b08f37545;hp=a5f1b4653d7a92a3c24209ddbed915b2f52aacb3;hpb=5cd2769b439929e59a8a56da1f42ba5bdb582d09;p=fa-stable.git

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;