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-new.sql
diff --git
a/sql/en_US-new.sql
b/sql/en_US-new.sql
index cf3920cb57e745fed265dc4430d31bafbb44e1ae..2276c338ed6446037e0334300135c18bad01f9fd 100644
(file)
--- 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',
`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;