+ALTER TABLE `0_bank_accounts` DROP COLUMN `last_reconciled_date`;
+ALTER TABLE `0_bank_accounts` ADD `last_reconciled_date` timestamp NOT NULL default '0000-00-00';
+ALTER TABLE `0_bank_accounts` DROP COLUMN `ending_reconcile_balance`;
+ALTER TABLE `0_bank_accounts` ADD `ending_reconcile_balance` double NOT NULL default '0';
+
+ALTER TABLE `0_bank_trans` DROP COLUMN `reconciled`;
+ALTER TABLE `0_bank_trans` ADD `reconciled` tinyint(1) NOT NULL default '0';