From 4e1ede871ac4f57ef38be297bb0d4693341f7c07 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sat, 14 Feb 2009 10:54:47 +0000 Subject: [PATCH] Removed obsolete bank_trans_type_id from bank_trans table. --- sql/alter2.1.sql | 1 + sql/en_US-demo.sql | 19 +++++++++---------- sql/en_US-new.sql | 1 - 3 files changed, 10 insertions(+), 11 deletions(-) diff --git a/sql/alter2.1.sql b/sql/alter2.1.sql index d1cc5807..6e435d99 100644 --- a/sql/alter2.1.sql +++ b/sql/alter2.1.sql @@ -68,6 +68,7 @@ ALTER TABLE `0_bank_accounts` ADD `id` SMALLINT(6) AUTO_INCREMENT PRIMARY KEY; ALTER TABLE `0_bank_accounts` ADD `last_reconciled_date` timestamp NOT NULL default '0000-00-00'; ALTER TABLE `0_bank_accounts` ADD `ending_reconcile_balance` double NOT NULL default '0'; +ALTER TABLE `0_bank_trans` DROP COLUMN `bank_trans_type_id`; ALTER TABLE `0_bank_trans` ADD `reconciled` date default NULL; ALTER TABLE `0_users` ADD `query_size` TINYINT(1) DEFAULT '10'; diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 4fcfc0d4..8b80ee29 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -92,7 +92,6 @@ CREATE TABLE `0_bank_trans` ( `bank_act` varchar(11) default NULL, `ref` varchar(40) default NULL, `trans_date` date NOT NULL default '0000-00-00', - `bank_trans_type_id` int(10) unsigned default NULL, `amount` double default NULL, `dimension_id` int(11) NOT NULL default '0', `dimension2_id` int(11) NOT NULL default '0', @@ -107,15 +106,15 @@ CREATE TABLE `0_bank_trans` ( ### Data of table `0_bank_trans` ### -INSERT INTO `0_bank_trans` VALUES ('21', '12', '7', '1', '6', '2008-03-06', '1', '100', '0', '0', '2', '1', NULL); -INSERT INTO `0_bank_trans` VALUES ('22', '12', '8', '1', '7', '2008-03-06', '1', '100', '0', '0', '2', '4', NULL); -INSERT INTO `0_bank_trans` VALUES ('23', '12', '9', '1', '8', '2008-03-07', '1', '2000', '0', '0', '2', '1', NULL); -INSERT INTO `0_bank_trans` VALUES ('24', '12', '10', '1', '9', '2009-01-10', '0', '1000', '0', '0', '2', '1', NULL); -INSERT INTO `0_bank_trans` VALUES ('25', '12', '11', '1', '10', '2009-01-10', '0', '183.62116393597', '0', '0', '2', '3', NULL); -INSERT INTO `0_bank_trans` VALUES ('26', '22', '4', '1', '3', '2009-01-10', '0', '-200', '0', '0', '3', '1', NULL); -INSERT INTO `0_bank_trans` VALUES ('27', '2', '5', '1', '14', '2009-01-29', '', '200', '0', '0', '4', '3', NULL); -INSERT INTO `0_bank_trans` VALUES ('28', '1', '8', '1', '7', '2009-01-29', '', '-50', '0', '0', '4', '1', NULL); -INSERT INTO `0_bank_trans` VALUES ('29', '2', '6', '1', '15', '2009-01-29', '', '50', '0', '0', '4', '3', NULL); +INSERT INTO `0_bank_trans` VALUES ('21', '12', '7', '1', '6', '2008-03-06', '100', '0', '0', '2', '1', NULL); +INSERT INTO `0_bank_trans` VALUES ('22', '12', '8', '1', '7', '2008-03-06', '100', '0', '0', '2', '4', NULL); +INSERT INTO `0_bank_trans` VALUES ('23', '12', '9', '1', '8', '2008-03-07', '2000', '0', '0', '2', '1', NULL); +INSERT INTO `0_bank_trans` VALUES ('24', '12', '10', '1', '9', '2009-01-10', '1000', '0', '0', '2', '1', NULL); +INSERT INTO `0_bank_trans` VALUES ('25', '12', '11', '1', '10', '2009-01-10', '183.62116393597', '0', '0', '2', '3', NULL); +INSERT INTO `0_bank_trans` VALUES ('26', '22', '4', '1', '3', '2009-01-10', '-200', '0', '0', '3', '1', NULL); +INSERT INTO `0_bank_trans` VALUES ('27', '2', '5', '1', '14', '2009-01-29','200', '0', '0', '4', '3', NULL); +INSERT INTO `0_bank_trans` VALUES ('28', '1', '8', '1', '7', '2009-01-29', '-50', '0', '0', '4', '1', NULL); +INSERT INTO `0_bank_trans` VALUES ('29', '2', '6', '1', '15', '2009-01-29','50', '0', '0', '4', '3', NULL); ### Structure of table `0_bom` ### diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 43bbd808..cda5540a 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -87,7 +87,6 @@ CREATE TABLE `0_bank_trans` ( `bank_act` varchar(11) default NULL, `ref` varchar(40) default NULL, `trans_date` date NOT NULL default '0000-00-00', - `bank_trans_type_id` int(10) unsigned default NULL, `amount` double default NULL, `dimension_id` int(11) NOT NULL default '0', `dimension2_id` int(11) NOT NULL default '0', -- 2.30.2