+ALTER TABLE `0_trans_tax_details` ADD COLUMN `reg_type` tinyint(1) DEFAULT NULL AFTER `memo`;
+
+UPDATE `0_trans_tax_details` reg
+ SET reg.reg_type=1
+ WHERE reg.trans_type IN(20, 21);
+
+UPDATE `0_trans_tax_details` reg
+ SET reg.reg_type=0
+ WHERE reg.trans_type IN(10, 11);
+
+INSERT IGNORE INTO `0_sys_prefs` VALUES
+ ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, 0),
+ ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),
+ ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, 30),
+ ('no_zero_lines_amount', 'glsetup.sales', 'tinyint', 1, '1'),
+ ('show_po_item_codes', 'glsetup.purchase', 'tinyint', 1, '0'),
+ ('accounts_alpha', 'glsetup.general', 'tinyint', 1, '0'),
+ ('loc_notification', 'glsetup.inventory', 'tinyint', 1, '0'),
+ ('print_invoice_no', 'glsetup.sales', 'tinyint', 1, '0'),
+ ('allow_negative_prices', 'glsetup.inventory', 'tinyint', 1, '1'),
+ ('print_item_images_on_quote', 'glsetup.inventory', 'tinyint', 1, '0'),
+ ('bcc_email', 'setup.company', 'varchar', 100, ''),
+ ('alternative_tax_include_on_docs', 'setup.company', 'tinyint', 1, '0'),
+ ('suppress_tax_rates', 'setup.company', 'tinyint', 1, '0');
+
+# stock_moves.visible field is obsolete
+# removing obsolete moves for writeoffs
+DELETE moves
+ FROM `0_stock_moves` moves
+ INNER JOIN (SELECT * FROM `0_stock_moves` WHERE `type`=11 AND `qty`<0) writeoffs ON writeoffs.`trans_no`=moves.`trans_no` AND writeoffs.`type`=11
+ WHERE moves.`type`=11;
+
+ALTER TABLE `0_stock_moves` DROP COLUMN `visible`;