From 1f1b3af2918107e75c39aad5667321ba80d46249 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sun, 22 Aug 2010 19:19:32 +0000 Subject: [PATCH] Fixed bug in lang update, changed purchase account for suppliers to default --- sql/alter2.3rc.sql | 5 +++-- sql/en_US-demo.sql | 6 +++--- 2 files changed, 6 insertions(+), 5 deletions(-) diff --git a/sql/alter2.3rc.sql b/sql/alter2.3rc.sql index c50b6b05..38ac6f06 100644 --- a/sql/alter2.3rc.sql +++ b/sql/alter2.3rc.sql @@ -1,4 +1,5 @@ ALTER TABLE `0_supp_trans` ADD COLUMN `tax_included` tinyint(1) NOT NULL default '0'; ALTER TABLE `0_purch_orders` ADD COLUMN `tax_included` tinyint(1) NOT NULL default '0'; -UPDATE `crm_persons` SET `lang`='C' WHERE `lang`='en_GB'; -UPDATE `crm_users` SET `language`='C' WHERE `language`='en_GB'; +UPDATE `0_crm_persons` SET `lang`='C' WHERE `lang`='en_GB'; +UPDATE `0_crm_users` SET `language`='C' WHERE `language`='en_GB'; +UPDATE `0_suppliers` SET `purchase_account`=''; diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index b2e48be8..a80a7b7e 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -1892,9 +1892,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, 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); +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, '', '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, '', '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, '', '2100', '5060', '', 0); -- -------------------------------------------------------- -- 2.30.2