X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=09fe3108c6d170333a64605a80fc550fa1867a75;hb=ead566f5e20aec8925be69a83803d2de95c26bb8;hp=c80bd31421b3da9ea511a477a51c8327a0d421ac;hpb=22c84933870f016a7c124410151bc61906d93244;p=fa-stable.git

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index c80bd314..09fe3108 100644
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -576,6 +576,7 @@ CREATE TABLE IF NOT EXISTS `0_cust_branch` (
   `br_post_address` tinytext NOT NULL,
   `group_no` int(11) NOT NULL default '0',
   `notes` tinytext NOT NULL,
+  `bank_account` varchar(60) DEFAULT NULL,
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`branch_code`,`debtor_no`),
   KEY `branch_code` (`branch_code`),
@@ -651,6 +652,7 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
   `dimension_id` int(11) NOT NULL default '0',
   `dimension2_id` int(11) NOT NULL default '0',
   `payment_terms` int(11) default NULL,
+  `tax_included` tinyint(1) unsigned NOT NULL default '0',
   PRIMARY KEY  (`type`,`trans_no`),
   KEY `debtor_no` (`debtor_no`,`branch_code`),
   KEY `tran_date` (`tran_date`)
@@ -764,6 +766,7 @@ CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
 INSERT INTO `0_fiscal_year` VALUES(1, '2008-01-01', '2008-12-31', 0);
 INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 0);
 INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES(4, '2011-01-01', '2011-12-31', 0);
 
 --
 -- Table structure for table `0_gl_trans`