projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Cleanup.
[fa-stable.git]
/
sql
/
en_US-new.sql
diff --git
a/sql/en_US-new.sql
b/sql/en_US-new.sql
index 9f9a4f01675d1b790c9ee3b7922cf03a7827f320..078442bcdb3b0d8fad0a78b9029299dff24a7d12 100644
(file)
--- a/
sql/en_US-new.sql
+++ b/
sql/en_US-new.sql
@@
-682,7
+682,8
@@
CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` (
`qty_done` double NOT NULL default '0',
`src_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
`qty_done` double NOT NULL default '0',
`src_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
- KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`)
+ KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
+ KEY (`src_id`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;
--
) TYPE=InnoDB AUTO_INCREMENT=1 ;
--
@@
-1164,6
+1165,7
@@
CREATE TABLE IF NOT EXISTS `0_purch_orders` (
`into_stock_location` varchar(5) NOT NULL default '',
`delivery_address` tinytext NOT NULL,
`total` double NOT NULL default '0',
`into_stock_location` varchar(5) NOT NULL default '',
`delivery_address` tinytext NOT NULL,
`total` double NOT NULL default '0',
+ `tax_included` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`order_no`),
KEY `ord_date` (`ord_date`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;
PRIMARY KEY (`order_no`),
KEY `ord_date` (`ord_date`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;
@@
-1645,6
+1647,7
@@
CREATE TABLE IF NOT EXISTS `0_suppliers` (
`bank_account` varchar(60) NOT NULL default '',
`curr_code` char(3) default NULL,
`payment_terms` int(11) default NULL,
`bank_account` varchar(60) NOT NULL default '',
`curr_code` char(3) default NULL,
`payment_terms` int(11) default NULL,
+ `tax_included` tinyint(1) NOT NULL default '0',
`dimension_id` int(11) default '0',
`dimension2_id` int(11) default '0',
`tax_group_id` int(11) default NULL,
`dimension_id` int(11) default '0',
`dimension2_id` int(11) default '0',
`tax_group_id` int(11) default NULL,
@@
-1737,6
+1740,7
@@
CREATE TABLE IF NOT EXISTS `0_supp_trans` (
`ov_gst` double NOT NULL default '0',
`rate` double NOT NULL default '1',
`alloc` double NOT NULL default '0',
`ov_gst` double 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`),
KEY `supplier_id` (`supplier_id`),
KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
PRIMARY KEY (`type`,`trans_no`),
KEY `supplier_id` (`supplier_id`),
KEY `SupplierID_2` (`supplier_id`,`supp_reference`),