ALTER TABLE `0_bank_accounts` DROP PRIMARY KEY;
ALTER TABLE `0_bank_accounts` ADD `id` SMALLINT(6) AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE `0_bank_accounts` DROP PRIMARY KEY;
ALTER TABLE `0_bank_accounts` ADD `id` SMALLINT(6) AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE `0_users` ADD `graphic_links` TINYINT(1) DEFAULT '1';
DROP TABLE IF EXISTS `0_sales_pos`;
ALTER TABLE `0_users` ADD `graphic_links` TINYINT(1) DEFAULT '1';
DROP TABLE IF EXISTS `0_sales_pos`;
-INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '1', '0');
+# After upgrade default POS cash sale is off. Change in POS setup if you wish.
+INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '0', '1', 'DEF', '1', '0');
INSERT INTO `0_quick_entry_lines` VALUES ('2', '2','0','=', '6730', '0', '0');
INSERT INTO `0_quick_entry_lines` VALUES ('3', '3','0','=', '3000', '0', '0');
INSERT INTO `0_quick_entry_lines` VALUES ('2', '2','0','=', '6730', '0', '0');
INSERT INTO `0_quick_entry_lines` VALUES ('3', '3','0','=', '3000', '0', '0');
ALTER TABLE `0_users` ADD `rep_popup` TINYINT(1) DEFAULT '1';
DROP TABLE IF EXISTS `0_print_profiles`;
ALTER TABLE `0_users` ADD `rep_popup` TINYINT(1) DEFAULT '1';
DROP TABLE IF EXISTS `0_print_profiles`;
UNIQUE KEY(`stock_id`, `item_code`)
) TYPE=MyISAM AUTO_INCREMENT=1;
UNIQUE KEY(`stock_id`, `item_code`)
) TYPE=MyISAM AUTO_INCREMENT=1;
ALTER TABLE `0_suppliers` ADD `notes` tinytext NOT NULL DEFAULT '';
ALTER TABLE `0_chart_types` DROP INDEX `name`, ADD INDEX `name` ( `name` );
ALTER TABLE `0_suppliers` ADD `notes` tinytext NOT NULL DEFAULT '';
ALTER TABLE `0_chart_types` DROP INDEX `name`, ADD INDEX `name` ( `name` );
ALTER TABLE `0_item_units` ADD `inactive` tinyint(1) NOT NULL DEFAULT '0';
DROP TABLE IF EXISTS `0_trans_tax_details`;
ALTER TABLE `0_item_units` ADD `inactive` tinyint(1) NOT NULL DEFAULT '0';
DROP TABLE IF EXISTS `0_trans_tax_details`;
`tran_date` date NOT NULL,
`tax_type_id` int(11) NOT NULL default '0',
`rate` double NOT NULL default '0',
`tran_date` date NOT NULL,
`tax_type_id` int(11) NOT NULL default '0',
`rate` double NOT NULL default '0',
`included_in_price` tinyint(1) NOT NULL default '0',
`net_amount` double NOT NULL default '0',
`amount` double NOT NULL default '0',
`included_in_price` tinyint(1) NOT NULL default '0',
`net_amount` double NOT NULL default '0',
`amount` double NOT NULL default '0',