projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fixed supp_trans primary keys, rerun.
[fa-stable.git]
/
sql
/
en_US-demo.sql
diff --git
a/sql/en_US-demo.sql
b/sql/en_US-demo.sql
index d2066ec7a9270ee4e3c6b10d55236db69dbe3ff2..f2b7e2f010752e7158cee9716ff49f2117fff5b8 100644
(file)
--- 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',
`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;
KEY `supplier_id` (`supplier_id`),
KEY `tran_date` (`tran_date`)
) ENGINE=InnoDB;