X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=e2a761c87b69b7c0ce1b6d8c5e7da2722792e67d;hb=d8863db36cebcc809e1d9000c1f4c81dc4e460d1;hp=75903fc876c23a3a04685260ac26da24ff1a9874;hpb=e4c7f0dbe9fa83ed6382713b32a4586ce3e60d81;p=fa-stable.git

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index 75903fc8..e2a761c8 100644
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -648,7 +648,6 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
   `alloc` double NOT NULL default '0',
   `rate` double NOT NULL default '1',
   `ship_via` int(11) default NULL,
-  `trans_link` int(11) NOT NULL default '0',
   `dimension_id` int(11) NOT NULL default '0',
   `dimension2_id` int(11) NOT NULL default '0',
   `payment_terms` int(11) default NULL,
@@ -681,8 +680,10 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` (
   `discount_percent` double NOT NULL default '0',
   `standard_cost` double NOT NULL default '0',
   `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 ;
 
 --
@@ -1645,6 +1646,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,
+  `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,