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 a5f1b4653d7a92a3c24209ddbed915b2f52aacb3..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`),
+ 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;