From ae91cfc98a8343d3886099df3f346bedd7a194b0 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sun, 27 Jun 2010 13:37:48 +0000 Subject: [PATCH] Added tax_included firld in suppliers table. --- sql/alter2.3.sql | 1 + sql/en_US-demo.sql | 7 ++++--- sql/en_US-new.sql | 1 + 3 files changed, 6 insertions(+), 3 deletions(-) diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql index 5cf5e04e..65f1ef4b 100644 --- a/sql/alter2.3.sql +++ b/sql/alter2.3.sql @@ -246,3 +246,4 @@ INSERT INTO `0_crm_contacts` (`person_id`, `type`, `action`, `entity_id`) ALTER TABLE `0_debtor_trans_details` ADD COLUMN `src_id` int(11) default NULL; ALTER TABLE `0_debtor_trans_details` ADD KEY (`src_id`); +ALTER TABLE `0_suppliers` ADD COLUMN `tax_included` tinyint(1) NOT NULL default '0' AFTER `payment_terms`; diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 54da3fc8..024dd44d 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -1873,6 +1873,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, @@ -1890,9 +1891,9 @@ CREATE TABLE IF NOT EXISTS `0_suppliers` ( -- Dumping data for table `0_suppliers` -- -INSERT INTO `0_suppliers` VALUES(1, 'Junk Beer ApS', 'Junk Beer', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '123456', 'Contact', '111', '', '', 'DKK', 3, 1, 0, 2, 1000, '5010', '2100', '5060', 'A supplier with junk beers.', 0); -INSERT INTO `0_suppliers` VALUES(2, 'Lucky Luke Inc.', 'Lucky Luke', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '654321', 'Luke', '333', '', '', 'USD', 3, 0, 0, 1, 500, '5010', '2100', '5060', '', 0); -INSERT INTO `0_suppliers` VALUES(3, 'Money Makers Ltd.', 'Money Makers', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '987654', 'Makers', '222', '', '', 'GBP', 3, 0, 0, 2, 300, '5010', '2100', '5060', '', 0); +INSERT INTO `0_suppliers` VALUES(1, 'Junk Beer ApS', 'Junk Beer', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '123456', 'Contact', '111', '', '', 'DKK', 3, 0, 1, 0, 2, 1000, '5010', '2100', '5060', 'A supplier with junk beers.', 0); +INSERT INTO `0_suppliers` VALUES(2, 'Lucky Luke Inc.', 'Lucky Luke', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '654321', 'Luke', '333', '', '', 'USD', 3, 0, 0, 0, 1, 500, '5010', '2100', '5060', '', 0); +INSERT INTO `0_suppliers` VALUES(3, 'Money Makers Ltd.', 'Money Makers', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '987654', 'Makers', '222', '', '', 'GBP', 3, 0, 0, 0, 2, 300, '5010', '2100', '5060', '', 0); -- -------------------------------------------------------- diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index ec72638c..e2a761c8 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1646,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, -- 2.30.2