I think both these proposed changes are clearly correct and address RC bugs, so, since there's been no maintainer reaction, I'm going to upload an NMU for both. NMU diff attached.
Scott K
diff -Nru frontaccounting-2.2.10/debian/changelog frontaccounting-2.2.10/debian/changelog --- frontaccounting-2.2.10/debian/changelog 2010-10-29 11:44:31.000000000 -0400 +++ frontaccounting-2.2.10/debian/changelog 2012-07-28 19:11:53.000000000 -0400 @@ -1,3 +1,19 @@ +frontaccounting (2.2.10-3.1) unstable; urgency=medium + + [ Scott Kitterman ] + * Non-maintainer upload + * Urgency medium for grave data loss bug fix + + [ Evgeni Golov ] + * Use ENGINE=x instead of TYPE=x which was deprecated since MySQL 4.1 + and removed in 5.4.4. + Closes: #682249 + + [ Jamie McClelland ] + * Fix postinst variable quoting Closes: #618771 + + -- Scott Kitterman <sc...@kitterman.com> Sat, 28 Jul 2012 19:08:31 -0400 + frontaccounting (2.2.10-3) unstable; urgency=low * Fix pending l10n issues. Debconf translations: diff -Nru frontaccounting-2.2.10/debian/patches/series frontaccounting-2.2.10/debian/patches/series --- frontaccounting-2.2.10/debian/patches/series 2010-02-21 01:09:02.000000000 -0500 +++ frontaccounting-2.2.10/debian/patches/series 2012-07-28 19:08:22.000000000 -0400 @@ -1,3 +1,4 @@ config.default.php.patch remove-files.patch debian-changes-2.2.6-1 +use_engine_instead_of_type.patch diff -Nru frontaccounting-2.2.10/debian/patches/use_engine_instead_of_type.patch frontaccounting-2.2.10/debian/patches/use_engine_instead_of_type.patch --- frontaccounting-2.2.10/debian/patches/use_engine_instead_of_type.patch 1969-12-31 19:00:00.000000000 -0500 +++ frontaccounting-2.2.10/debian/patches/use_engine_instead_of_type.patch 2012-07-28 19:08:22.000000000 -0400 @@ -0,0 +1,1521 @@ +Description: Use ENGINE=x instead of TYPE=x + It was deprecated since MySQL 4.1 and removed in 5.4.4. +Author: Evgeni Golov <evg...@debian.org> +Bug-Debian: http://bugs.debian.org/682249 +Last-Update: 2012-07-21 + +--- frontaccounting-2.2.10.orig/sql/alter2.2.sql ++++ frontaccounting-2.2.10/sql/alter2.2.sql +@@ -70,7 +70,7 @@ CREATE TABLE `0_audit_trail` ( + `gl_seq` int(11) unsigned default NULL, + PRIMARY KEY (`id`), + KEY (`fiscal_year`, `gl_seq`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + ALTER TABLE `0_stock_master` ADD COLUMN `no_sale` tinyint(1) NOT NULL default '0'; + ALTER TABLE `0_currencies` ADD COLUMN `auto_update` tinyint(1) NOT NULL default '1'; +@@ -93,7 +93,7 @@ CREATE TABLE `0_security_roles` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `role` (`role`) +-) TYPE=MyISAM AUTO_INCREMENT=1; ++) ENGINE=MyISAM AUTO_INCREMENT=1; + + ALTER TABLE `0_company` ADD COLUMN `login_tout` SMALLINT(6) NOT NULL DEFAULT '600'; + ALTER TABLE `0_users` CHANGE COLUMN `full_access` `role_id` int(11) NOT NULL default '1'; +@@ -119,7 +119,7 @@ CREATE TABLE `0_tags` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY(`type`,`name`) +-) TYPE=MyISAM AUTO_INCREMENT=1; ++) ENGINE=MyISAM AUTO_INCREMENT=1; + + DROP TABLE IF EXISTS `0_tag_associations`; + +@@ -127,7 +127,7 @@ CREATE TABLE `0_tag_associations` ( + `record_id` varchar(11) NOT NULL, + `tag_id` int(11) NOT NULL, + UNIQUE KEY(`record_id`,`tag_id`) +-) TYPE=MyISAM; ++) ENGINE=MyISAM; + + DROP TABLE IF EXISTS `0_useronline` ; + +@@ -138,7 +138,7 @@ CREATE TABLE `0_useronline` ( + `file` varchar(100) NOT NULL default '', + PRIMARY KEY `id` (`id`) , + KEY (`timestamp`) +-) TYPE=MYISAM AUTO_INCREMENT=1; ++) ENGINE=MYISAM AUTO_INCREMENT=1; + + ALTER TABLE `0_suppliers` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`; + ALTER TABLE `0_cust_branch` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`; +--- frontaccounting-2.2.10.orig/sql/alter2.2rc.sql ++++ frontaccounting-2.2.10/sql/alter2.2rc.sql +@@ -12,4 +12,4 @@ CREATE TABLE `0_useronline` ( + `file` varchar(100) NOT NULL default '', + PRIMARY KEY `id` (`id`) , + KEY (`timestamp`) +-) TYPE=MYISAM AUTO_INCREMENT=1; ++) ENGINE=MYISAM AUTO_INCREMENT=1; +--- frontaccounting-2.2.10.orig/sql/alter2.1.sql ++++ frontaccounting-2.2.10/sql/alter2.1.sql +@@ -25,7 +25,7 @@ CREATE TABLE `0_attachments` ( + `filetype` varchar(60) NOT NULL default '', + PRIMARY KEY (`id`), + KEY `type_no` (`type_no`,`trans_no`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + DROP TABLE IF EXISTS `0_groups`; + +@@ -35,7 +35,7 @@ CREATE TABLE `0_groups` ( + `inactive` tinyint(1) NOT NULL default 0, + PRIMARY KEY (`id`), + UNIQUE KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + INSERT INTO `0_groups` VALUES ('1', 'Small', '0'); + INSERT INTO `0_groups` VALUES ('2', 'Medium', '0'); +@@ -56,7 +56,7 @@ CREATE TABLE `0_recurrent_invoices` ( + `last_sent` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`), + UNIQUE KEY `description` (`description`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + ALTER TABLE `0_cust_branch` ADD `group_no` int(11) NOT NULL default '0'; + +@@ -87,7 +87,7 @@ CREATE TABLE `0_sales_pos` ( + `inactive` tinyint(1) NOT NULL default 0, + PRIMARY KEY (`id`), + UNIQUE KEY(`pos_name`) +-) TYPE=MyISAM AUTO_INCREMENT=1; ++) ENGINE=MyISAM AUTO_INCREMENT=1; + + # 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'); +@@ -104,7 +104,7 @@ CREATE TABLE `0_quick_entries` ( + `base_desc` varchar(60) NULL, + PRIMARY KEY (`id`), + KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=1; ++) ENGINE=MyISAM AUTO_INCREMENT=1; + + INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount'); + INSERT INTO `0_quick_entries` VALUES ('2', '1', 'Phone', '0', 'Amount'); +@@ -122,7 +122,7 @@ CREATE TABLE `0_quick_entry_lines` ( + `dimension2_id` smallint(6) UNSIGNED NULL default NULL, + PRIMARY KEY (`id`), + KEY `qid` (`qid`) +-) TYPE=MyISAM AUTO_INCREMENT=1; ++) ENGINE=MyISAM AUTO_INCREMENT=1; + + INSERT INTO `0_quick_entry_lines` VALUES ('1', '1','0','=', '6600', '0', '0'); + INSERT INTO `0_quick_entry_lines` VALUES ('2', '2','0','=', '6730', '0', '0'); +@@ -139,7 +139,7 @@ CREATE TABLE `0_print_profiles` ( + `printer` tinyint(3) UNSIGNED NULL default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `profile` (`profile`,`report`) +-) TYPE=MyISAM AUTO_INCREMENT=10; ++) ENGINE=MyISAM AUTO_INCREMENT=10; + + INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0'); + INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0'); +@@ -163,7 +163,7 @@ CREATE TABLE `0_printers` ( + `timeout` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=4; ++) ENGINE=MyISAM AUTO_INCREMENT=4; + + INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20'); + INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5'); +@@ -182,7 +182,7 @@ CREATE TABLE `0_item_codes` ( + `inactive` tinyint(1) NOT NULL default 0, + PRIMARY KEY (`id`), + UNIQUE KEY(`stock_id`, `item_code`) +-) TYPE=MyISAM AUTO_INCREMENT=1; ++) ENGINE=MyISAM AUTO_INCREMENT=1; + + ALTER TABLE `0_company` ADD `foreign_codes` TINYINT(1) NOT NULL DEFAULT '0'; + +@@ -218,7 +218,7 @@ CREATE TABLE IF NOT EXISTS `0_sql_trail` + `result` tinyint(1) NOT NULL, + `msg` varchar(255) NOT NULL, + PRIMARY KEY (`id`) +-) TYPE = MyISAM; ++) ENGINE = MyISAM; + + ALTER TABLE `0_tax_types` DROP COLUMN `out`; + +@@ -271,5 +271,5 @@ CREATE TABLE `0_trans_tax_details` ( + `amount` double NOT NULL default '0', + `memo` tinytext default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + +--- frontaccounting-2.2.10.orig/sql/alter.sql ++++ frontaccounting-2.2.10/sql/alter.sql +@@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `0_item_units + `decimals` tinyint(2) NOT NULL, + PRIMARY KEY (`abbr`), + UNIQUE KEY `name` (`name`) +-) TYPE = MyISAM; ++) ENGINE = MyISAM; + + INSERT INTO `0_item_units` (`abbr`, `name`, `decimals`) SELECT DISTINCT `units`, CONCAT(UPPER(SUBSTRING(`units`, 1, 1)), LOWER(SUBSTRING(`units`, 2))), 0 FROM `0_stock_master` ; + UPDATE `0_debtor_trans` SET `ov_amount`=-`ov_amount`, `ov_gst`=-`ov_gst`, `ov_freight`=-`ov_freight`, `ov_discount`=-`ov_discount` WHERE `ov_amount` < 0 AND `type` <> 10 AND `type` <> 13 ; +--- frontaccounting-2.2.10.orig/sql/en_US-new.sql ++++ frontaccounting-2.2.10/sql/en_US-new.sql +@@ -15,7 +15,7 @@ CREATE TABLE `0_areas` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`area_code`), + UNIQUE KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_areas` ### +@@ -38,7 +38,7 @@ CREATE TABLE `0_attachments` ( + `filetype` varchar(60) NOT NULL default '', + PRIMARY KEY (`id`), + KEY `type_no` (`type_no`,`trans_no`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_attachments` ### +@@ -59,7 +59,7 @@ CREATE TABLE `0_audit_trail` ( + `gl_seq` int(11) unsigned default NULL, + PRIMARY KEY (`id`), + KEY (`fiscal_year`, `gl_seq`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + ### Data of table `0_audit_trail` ### + +@@ -85,7 +85,7 @@ CREATE TABLE `0_bank_accounts` ( + PRIMARY KEY (`id`), + KEY `bank_account_name` (`bank_account_name`), + KEY `bank_account_number` (`bank_account_number`) +-) TYPE=MyISAM AUTO_INCREMENT=3 ; ++) ENGINE=MyISAM AUTO_INCREMENT=3 ; + + + ### Data of table `0_bank_accounts` ### +@@ -114,7 +114,7 @@ CREATE TABLE `0_bank_trans` ( + PRIMARY KEY (`id`), + KEY `bank_act` (`bank_act`,`ref`), + KEY `type` (`type`,`trans_no`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_bank_trans` ### +@@ -139,7 +139,7 @@ CREATE TABLE `0_bom` ( + KEY `parent` (`parent`,`loc_code`), + KEY `Parent_2` (`parent`), + KEY `workcentre_added` (`workcentre_added`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_bom` ### +@@ -164,7 +164,7 @@ CREATE TABLE `0_budget_trans` ( + `person_id` tinyblob, + PRIMARY KEY (`counter`), + KEY `Type_and_Number` (`type`,`type_no`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_budget_trans` ### +@@ -181,7 +181,7 @@ CREATE TABLE `0_chart_class` ( + `ctype` tinyint(1) NOT NULL default '0', + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`cid`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_chart_class` ### +@@ -204,7 +204,7 @@ CREATE TABLE `0_chart_master` ( + PRIMARY KEY (`account_code`), + KEY `account_code` (`account_code`), + KEY `account_name` (`account_name`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_chart_master` ### +@@ -302,7 +302,7 @@ CREATE TABLE `0_chart_types` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=13 ; ++) ENGINE=MyISAM AUTO_INCREMENT=13 ; + + + ### Data of table `0_chart_types` ### +@@ -330,7 +330,7 @@ CREATE TABLE `0_comments` ( + `id` int(11) NOT NULL default '0', + `date_` date default '0000-00-00', + `memo_` tinytext +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_comments` ### +@@ -395,7 +395,7 @@ CREATE TABLE `0_company` ( + `round_to` int(5) NOT NULL default '1', + `login_tout` SMALLINT(6) NOT NULL DEFAULT '600', + PRIMARY KEY (`coy_code`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + ### Data of table `0_company` ### + +@@ -412,7 +412,7 @@ CREATE TABLE `0_credit_status` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `reason_description` (`reason_description`) +-) TYPE=MyISAM AUTO_INCREMENT=5 ; ++) ENGINE=MyISAM AUTO_INCREMENT=5 ; + + + ### Data of table `0_credit_status` ### +@@ -435,7 +435,7 @@ CREATE TABLE `0_currencies` ( + `auto_update` tinyint(1) NOT NULL default '1', + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`curr_abrev`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_currencies` ### +@@ -458,7 +458,7 @@ CREATE TABLE `0_cust_allocations` ( + `trans_no_to` int(11) default NULL, + `trans_type_to` int(11) default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_cust_allocations` ### +@@ -497,7 +497,7 @@ CREATE TABLE `0_cust_branch` ( + PRIMARY KEY (`branch_code`,`debtor_no`), + KEY `branch_code` (`branch_code`), + KEY `br_name` (`br_name`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_cust_branch` ### +@@ -532,7 +532,7 @@ CREATE TABLE `0_debtor_trans` ( + `dimension2_id` int(11) NOT NULL default '0', + PRIMARY KEY (`trans_no`,`type`), + KEY `debtor_no` (`debtor_no`,`branch_code`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_debtor_trans` ### +@@ -556,7 +556,7 @@ CREATE TABLE `0_debtor_trans_details` ( + `standard_cost` double NOT NULL default '0', + `qty_done` double NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_debtor_trans_details` ### +@@ -587,7 +587,7 @@ CREATE TABLE `0_debtors_master` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`debtor_no`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_debtors_master` ### +@@ -608,7 +608,7 @@ CREATE TABLE `0_dimensions` ( + `due_date` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`), + UNIQUE KEY `reference` (`reference`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_dimensions` ### +@@ -627,7 +627,7 @@ CREATE TABLE `0_exchange_rates` ( + `date_` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`), + UNIQUE KEY `curr_code` (`curr_code`,`date_`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_exchange_rates` ### +@@ -644,7 +644,7 @@ CREATE TABLE `0_fiscal_year` ( + `end` date default '0000-00-00', + `closed` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=2 ; ++) ENGINE=InnoDB AUTO_INCREMENT=2 ; + + + ### Data of table `0_fiscal_year` ### +@@ -672,7 +672,7 @@ CREATE TABLE `0_gl_trans` ( + `person_id` tinyblob, + PRIMARY KEY (`counter`), + KEY `Type_and_Number` (`type`,`type_no`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_gl_trans` ### +@@ -691,7 +691,7 @@ CREATE TABLE `0_grn_batch` ( + `delivery_date` date NOT NULL default '0000-00-00', + `loc_code` varchar(5) default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_grn_batch` ### +@@ -711,7 +711,7 @@ CREATE TABLE `0_grn_items` ( + `qty_recd` double NOT NULL default '0', + `quantity_inv` double NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_grn_items` ### +@@ -728,7 +728,7 @@ CREATE TABLE `0_groups` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_groups` ### +@@ -753,7 +753,7 @@ CREATE TABLE `0_item_codes` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `stock_id` (`stock_id`,`item_code`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_item_codes` ### +@@ -768,7 +768,7 @@ CREATE TABLE `0_item_tax_type_exemptions + `item_tax_type_id` int(11) NOT NULL default '0', + `tax_type_id` int(11) NOT NULL default '0', + PRIMARY KEY (`item_tax_type_id`,`tax_type_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_item_tax_type_exemptions` ### +@@ -786,7 +786,7 @@ CREATE TABLE `0_item_tax_types` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=InnoDB AUTO_INCREMENT=2 ; ++) ENGINE=InnoDB AUTO_INCREMENT=2 ; + + + ### Data of table `0_item_tax_types` ### +@@ -805,7 +805,7 @@ CREATE TABLE `0_item_units` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`abbr`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_item_units` ### +@@ -823,7 +823,7 @@ CREATE TABLE `0_loc_stock` ( + `reorder_level` bigint(20) NOT NULL default '0', + PRIMARY KEY (`loc_code`,`stock_id`), + KEY `stock_id` (`stock_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_loc_stock` ### +@@ -845,7 +845,7 @@ CREATE TABLE `0_locations` ( + `contact` varchar(30) NOT NULL default '', + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`loc_code`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_locations` ### +@@ -863,7 +863,7 @@ CREATE TABLE `0_movement_types` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_movement_types` ### +@@ -883,7 +883,7 @@ CREATE TABLE `0_payment_terms` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`terms_indicator`), + UNIQUE KEY `terms` (`terms`) +-) TYPE=MyISAM AUTO_INCREMENT=5 ; ++) ENGINE=MyISAM AUTO_INCREMENT=5 ; + + + ### Data of table `0_payment_terms` ### +@@ -906,7 +906,7 @@ CREATE TABLE `0_prices` ( + `price` double NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_prices` ### +@@ -924,7 +924,7 @@ CREATE TABLE `0_print_profiles` ( + `printer` tinyint(3) unsigned default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `profile` (`profile`,`report`) +-) TYPE=MyISAM AUTO_INCREMENT=10 ; ++) ENGINE=MyISAM AUTO_INCREMENT=10 ; + + + ### Data of table `0_print_profiles` ### +@@ -954,7 +954,7 @@ CREATE TABLE `0_printers` ( + `timeout` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_printers` ### +@@ -976,7 +976,7 @@ CREATE TABLE `0_purch_data` ( + `conversion_factor` double NOT NULL default '1', + `supplier_description` char(50) NOT NULL default '', + PRIMARY KEY (`supplier_id`,`stock_id`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_purch_data` ### +@@ -1000,7 +1000,7 @@ CREATE TABLE `0_purch_order_details` ( + `quantity_ordered` double NOT NULL default '0', + `quantity_received` double NOT NULL default '0', + PRIMARY KEY (`po_detail_item`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_purch_order_details` ### +@@ -1021,7 +1021,7 @@ CREATE TABLE `0_purch_orders` ( + `into_stock_location` varchar(5) NOT NULL default '', + `delivery_address` tinytext NOT NULL, + PRIMARY KEY (`order_no`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_purch_orders` ### +@@ -1040,7 +1040,7 @@ CREATE TABLE `0_quick_entries` ( + `base_desc` varchar(60) default NULL, + PRIMARY KEY (`id`), + KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_quick_entries` ### +@@ -1064,7 +1064,7 @@ CREATE TABLE `0_quick_entry_lines` ( + `dimension2_id` smallint(6) unsigned default NULL, + PRIMARY KEY (`id`), + KEY `qid` (`qid`) +-) TYPE=MyISAM AUTO_INCREMENT=7 ; ++) ENGINE=MyISAM AUTO_INCREMENT=7 ; + + + ### Data of table `0_quick_entry_lines` ### +@@ -1094,7 +1094,7 @@ CREATE TABLE `0_recurrent_invoices` ( + `last_sent` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`), + UNIQUE KEY `description` (`description`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_recurrent_invoices` ### +@@ -1110,7 +1110,7 @@ CREATE TABLE `0_refs` ( + `type` int(11) NOT NULL default '0', + `reference` varchar(100) NOT NULL default '', + PRIMARY KEY (`id`,`type`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_refs` ### +@@ -1132,7 +1132,7 @@ CREATE TABLE `0_sales_order_details` ( + `quantity` double NOT NULL default '0', + `discount_percent` double NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_sales_order_details` ### +@@ -1164,7 +1164,7 @@ CREATE TABLE `0_sales_orders` ( + `from_stk_loc` varchar(5) NOT NULL default '', + `delivery_date` date NOT NULL default '0000-00-00', + PRIMARY KEY (`trans_type`, `order_no`) +-) TYPE=InnoDB; ++) ENGINE=InnoDB; + + + ### Data of table `0_sales_orders` ### +@@ -1185,7 +1185,7 @@ CREATE TABLE `0_sales_pos` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `pos_name` (`pos_name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_sales_pos` ### +@@ -1205,7 +1205,7 @@ CREATE TABLE `0_sales_types` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `sales_type` (`sales_type`) +-) TYPE=MyISAM AUTO_INCREMENT=3 ; ++) ENGINE=MyISAM AUTO_INCREMENT=3 ; + + + ### Data of table `0_sales_types` ### +@@ -1230,7 +1230,7 @@ CREATE TABLE `0_salesman` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`salesman_code`), + UNIQUE KEY `salesman_name` (`salesman_name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_salesman` ### +@@ -1249,7 +1249,7 @@ CREATE TABLE IF NOT EXISTS `0_security_r + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `role` (`role`) +-) TYPE=MyISAM AUTO_INCREMENT=11 ; ++) ENGINE=MyISAM AUTO_INCREMENT=11 ; + + -- + -- Data of table `0_security_roles` +@@ -1280,7 +1280,7 @@ CREATE TABLE `0_shippers` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`shipper_id`), + UNIQUE KEY `name` (`shipper_name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_shippers` ### +@@ -1298,7 +1298,7 @@ CREATE TABLE `0_sql_trail` ( + `result` tinyint(1) NOT NULL, + `msg` varchar(255) NOT NULL, + PRIMARY KEY (`id`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_sql_trail` ### +@@ -1326,7 +1326,7 @@ CREATE TABLE `0_stock_category` ( + `dflt_no_sale` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`category_id`), + UNIQUE KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=5 ; ++) ENGINE=MyISAM AUTO_INCREMENT=5 ; + + + ### Data of table `0_stock_category` ### +@@ -1364,7 +1364,7 @@ CREATE TABLE `0_stock_master` ( + `inactive` tinyint(1) NOT NULL default '0', + `no_sale` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`stock_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_stock_master` ### +@@ -1391,7 +1391,7 @@ CREATE TABLE `0_stock_moves` ( + `visible` tinyint(1) NOT NULL default '1', + PRIMARY KEY (`trans_id`), + KEY `type` (`type`,`trans_no`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_stock_moves` ### +@@ -1411,7 +1411,7 @@ CREATE TABLE `0_supp_allocations` ( + `trans_no_to` int(11) default NULL, + `trans_type_to` int(11) default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_supp_allocations` ### +@@ -1436,7 +1436,7 @@ CREATE TABLE `0_supp_invoice_items` ( + `unit_tax` double NOT NULL default '0', + `memo_` tinytext, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_supp_invoice_items` ### +@@ -1464,7 +1464,7 @@ CREATE TABLE `0_supp_trans` ( + KEY `supplier_id` (`supplier_id`), + KEY `SupplierID_2` (`supplier_id`,`supp_reference`), + KEY `type` (`type`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_supp_trans` ### +@@ -1502,7 +1502,7 @@ CREATE TABLE `0_suppliers` ( + `notes` tinytext NOT NULL, + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`supplier_id`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_suppliers` ### +@@ -1518,7 +1518,7 @@ CREATE TABLE `0_sys_types` ( + `type_no` int(11) NOT NULL default '1', + `next_reference` varchar(100) NOT NULL default '', + PRIMARY KEY (`type_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_sys_types` ### +@@ -1556,7 +1556,7 @@ CREATE TABLE `0_tax_group_items` ( + `tax_type_id` int(11) NOT NULL default '0', + `rate` double NOT NULL default '0', + PRIMARY KEY (`tax_group_id`,`tax_type_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_tax_group_items` ### +@@ -1575,7 +1575,7 @@ CREATE TABLE `0_tax_groups` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=InnoDB AUTO_INCREMENT=3 ; ++) ENGINE=InnoDB AUTO_INCREMENT=3 ; + + + ### Data of table `0_tax_groups` ### +@@ -1596,7 +1596,7 @@ CREATE TABLE `0_tax_types` ( + `name` varchar(60) NOT NULL default '', + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=2 ; ++) ENGINE=InnoDB AUTO_INCREMENT=2 ; + + + ### Data of table `0_tax_types` ### +@@ -1621,7 +1621,7 @@ CREATE TABLE `0_trans_tax_details` ( + `amount` double NOT NULL default '0', + `memo` tinytext, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_trans_tax_details` ### +@@ -1665,7 +1665,7 @@ CREATE TABLE `0_users` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY (`user_id`) +-) TYPE=MyISAM AUTO_INCREMENT=2; ++) ENGINE=MyISAM AUTO_INCREMENT=2; + + + ### Data of table `0_users` ### +@@ -1682,7 +1682,7 @@ CREATE TABLE `0_voided` ( + `date_` date NOT NULL default '0000-00-00', + `memo_` tinytext NOT NULL, + UNIQUE KEY `id` (`type`,`id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_voided` ### +@@ -1699,7 +1699,7 @@ CREATE TABLE `0_wo_issue_items` ( + `issue_id` int(11) default NULL, + `qty_issued` double default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_wo_issue_items` ### +@@ -1718,7 +1718,7 @@ CREATE TABLE `0_wo_issues` ( + `loc_code` varchar(5) default NULL, + `workcentre_id` int(11) default NULL, + PRIMARY KEY (`issue_no`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_wo_issues` ### +@@ -1736,7 +1736,7 @@ CREATE TABLE `0_wo_manufacture` ( + `quantity` double NOT NULL default '0', + `date_` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_wo_manufacture` ### +@@ -1757,7 +1757,7 @@ CREATE TABLE `0_wo_requirements` ( + `loc_code` char(5) NOT NULL default '', + `units_issued` double NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_wo_requirements` ### +@@ -1775,7 +1775,7 @@ CREATE TABLE `0_workcentres` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_workcentres` ### +@@ -1802,7 +1802,7 @@ CREATE TABLE `0_workorders` ( + `additional_costs` double NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `wo_ref` (`wo_ref`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_workorders` ### +@@ -1821,7 +1821,7 @@ CREATE TABLE `0_tags` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY(`type`,`name`) +-) TYPE=MyISAM AUTO_INCREMENT=1; ++) ENGINE=MyISAM AUTO_INCREMENT=1; + + + ### Data of table `0_chart_tags` ### +@@ -1836,7 +1836,7 @@ CREATE TABLE `0_tag_associations` ( + `record_id` varchar(11) NOT NULL, + `tag_id` int(11) NOT NULL, + UNIQUE KEY(`record_id`,`tag_id`) +-) TYPE=MyISAM; ++) ENGINE=MyISAM; + + + ### Data of table `0_tag_associations` ### +@@ -1850,5 +1850,5 @@ CREATE TABLE `0_useronline` ( + `file` varchar(100) NOT NULL default '', + PRIMARY KEY `id` (`id`) , + KEY (`timestamp`) +-) TYPE=MYISAM AUTO_INCREMENT=1; ++) ENGINE=MYISAM AUTO_INCREMENT=1; + +--- frontaccounting-2.2.10.orig/sql/en_US-demo.sql ++++ frontaccounting-2.2.10/sql/en_US-demo.sql +@@ -15,7 +15,7 @@ CREATE TABLE `0_areas` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`area_code`), + UNIQUE KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_areas` ### +@@ -39,7 +39,7 @@ CREATE TABLE `0_attachments` ( + `filetype` varchar(60) NOT NULL default '', + PRIMARY KEY (`id`), + KEY `type_no` (`type_no`,`trans_no`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_attachments` ### +@@ -60,7 +60,7 @@ CREATE TABLE `0_audit_trail` ( + `gl_seq` int(11) unsigned default NULL, + PRIMARY KEY (`id`), + KEY (`fiscal_year`, `gl_seq`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + ### Data of table `0_audit_trail` ### + +@@ -88,7 +88,7 @@ CREATE TABLE `0_bank_accounts` ( + PRIMARY KEY (`id`), + KEY `bank_account_name` (`bank_account_name`), + KEY `bank_account_number` (`bank_account_number`) +-) TYPE=MyISAM AUTO_INCREMENT=3 ; ++) ENGINE=MyISAM AUTO_INCREMENT=3 ; + + + ### Data of table `0_bank_accounts` ### +@@ -117,7 +117,7 @@ CREATE TABLE `0_bank_trans` ( + PRIMARY KEY (`id`), + KEY `bank_act` (`bank_act`,`ref`), + KEY `type` (`type`,`trans_no`) +-) TYPE=InnoDB AUTO_INCREMENT=12 ; ++) ENGINE=InnoDB AUTO_INCREMENT=12 ; + + + ### Data of table `0_bank_trans` ### +@@ -153,7 +153,7 @@ CREATE TABLE `0_bom` ( + KEY `parent` (`parent`,`loc_code`), + KEY `Parent_2` (`parent`), + KEY `workcentre_added` (`workcentre_added`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_bom` ### +@@ -181,7 +181,7 @@ CREATE TABLE `0_budget_trans` ( + `person_id` tinyblob, + PRIMARY KEY (`counter`), + KEY `Type_and_Number` (`type`,`type_no`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_budget_trans` ### +@@ -198,7 +198,7 @@ CREATE TABLE `0_chart_class` ( + `ctype` tinyint(1) NOT NULL default '0', + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`cid`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_chart_class` ### +@@ -222,7 +222,7 @@ CREATE TABLE `0_chart_master` ( + PRIMARY KEY (`account_code`), + KEY `account_code` (`account_code`), + KEY `account_name` (`account_name`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_chart_master` ### +@@ -319,7 +319,7 @@ CREATE TABLE `0_chart_types` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=13 ; ++) ENGINE=MyISAM AUTO_INCREMENT=13 ; + + + ### Data of table `0_chart_types` ### +@@ -347,7 +347,7 @@ CREATE TABLE `0_comments` ( + `id` int(11) NOT NULL default '0', + `date_` date default '0000-00-00', + `memo_` tinytext +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_comments` ### +@@ -412,7 +412,7 @@ CREATE TABLE `0_company` ( + `round_to` int(5) NOT NULL default '1', + `login_tout` SMALLINT(6) NOT NULL DEFAULT '600', + PRIMARY KEY (`coy_code`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + ### Data of table `0_company` ### + +@@ -429,7 +429,7 @@ CREATE TABLE `0_credit_status` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `reason_description` (`reason_description`) +-) TYPE=MyISAM AUTO_INCREMENT=5 ; ++) ENGINE=MyISAM AUTO_INCREMENT=5 ; + + + ### Data of table `0_credit_status` ### +@@ -452,7 +452,7 @@ CREATE TABLE `0_currencies` ( + `auto_update` tinyint(1) NOT NULL default '1', + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`curr_abrev`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_currencies` ### +@@ -476,7 +476,7 @@ CREATE TABLE `0_cust_allocations` ( + `trans_no_to` int(11) default NULL, + `trans_type_to` int(11) default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=2 ; ++) ENGINE=InnoDB AUTO_INCREMENT=2 ; + + + ### Data of table `0_cust_allocations` ### +@@ -516,7 +516,7 @@ CREATE TABLE `0_cust_branch` ( + PRIMARY KEY (`branch_code`,`debtor_no`), + KEY `branch_code` (`branch_code`), + KEY `br_name` (`br_name`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_cust_branch` ### +@@ -554,7 +554,7 @@ CREATE TABLE `0_debtor_trans` ( + `dimension2_id` int(11) NOT NULL default '0', + PRIMARY KEY (`trans_no`,`type`), + KEY `debtor_no` (`debtor_no`,`branch_code`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_debtor_trans` ### +@@ -586,7 +586,7 @@ CREATE TABLE `0_debtor_trans_details` ( + `standard_cost` double NOT NULL default '0', + `qty_done` double NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=9 ; ++) ENGINE=InnoDB AUTO_INCREMENT=9 ; + + + ### Data of table `0_debtor_trans_details` ### +@@ -625,7 +625,7 @@ CREATE TABLE `0_debtors_master` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`debtor_no`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_debtors_master` ### +@@ -649,7 +649,7 @@ CREATE TABLE `0_dimensions` ( + `due_date` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`), + UNIQUE KEY `reference` (`reference`) +-) TYPE=InnoDB AUTO_INCREMENT=3 ; ++) ENGINE=InnoDB AUTO_INCREMENT=3 ; + + + ### Data of table `0_dimensions` ### +@@ -670,7 +670,7 @@ CREATE TABLE `0_exchange_rates` ( + `date_` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`), + UNIQUE KEY `curr_code` (`curr_code`,`date_`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_exchange_rates` ### +@@ -690,7 +690,7 @@ CREATE TABLE `0_fiscal_year` ( + `end` date default '0000-00-00', + `closed` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=3 ; ++) ENGINE=InnoDB AUTO_INCREMENT=3 ; + + + ### Data of table `0_fiscal_year` ### +@@ -718,7 +718,7 @@ CREATE TABLE `0_gl_trans` ( + `person_id` tinyblob, + PRIMARY KEY (`counter`), + KEY `Type_and_Number` (`type`,`type_no`) +-) TYPE=InnoDB AUTO_INCREMENT=84 ; ++) ENGINE=InnoDB AUTO_INCREMENT=84 ; + + + ### Data of table `0_gl_trans` ### +@@ -820,7 +820,7 @@ CREATE TABLE `0_grn_batch` ( + `delivery_date` date NOT NULL default '0000-00-00', + `loc_code` varchar(5) default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=2 ; ++) ENGINE=InnoDB AUTO_INCREMENT=2 ; + + + ### Data of table `0_grn_batch` ### +@@ -841,7 +841,7 @@ CREATE TABLE `0_grn_items` ( + `qty_recd` double NOT NULL default '0', + `quantity_inv` double NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=4 ; ++) ENGINE=InnoDB AUTO_INCREMENT=4 ; + + + ### Data of table `0_grn_items` ### +@@ -861,7 +861,7 @@ CREATE TABLE `0_groups` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ; + + + ### Data of table `0_groups` ### +@@ -886,7 +886,7 @@ CREATE TABLE `0_item_codes` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `stock_id` (`stock_id`,`item_code`) +-) TYPE=MyISAM AUTO_INCREMENT=6 ; ++) ENGINE=MyISAM AUTO_INCREMENT=6 ; + + + ### Data of table `0_item_codes` ### +@@ -906,7 +906,7 @@ CREATE TABLE `0_item_tax_type_exemptions + `item_tax_type_id` int(11) NOT NULL default '0', + `tax_type_id` int(11) NOT NULL default '0', + PRIMARY KEY (`item_tax_type_id`,`tax_type_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_item_tax_type_exemptions` ### +@@ -924,7 +924,7 @@ CREATE TABLE `0_item_tax_types` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=InnoDB AUTO_INCREMENT=2 ; ++) ENGINE=InnoDB AUTO_INCREMENT=2 ; + + + ### Data of table `0_item_tax_types` ### +@@ -942,7 +942,7 @@ CREATE TABLE `0_item_units` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`abbr`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_item_units` ### +@@ -961,7 +961,7 @@ CREATE TABLE `0_loc_stock` ( + `reorder_level` bigint(20) NOT NULL default '0', + PRIMARY KEY (`loc_code`,`stock_id`), + KEY `stock_id` (`stock_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_loc_stock` ### +@@ -988,7 +988,7 @@ CREATE TABLE `0_locations` ( + `contact` varchar(30) NOT NULL default '', + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`loc_code`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_locations` ### +@@ -1006,7 +1006,7 @@ CREATE TABLE `0_movement_types` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_movement_types` ### +@@ -1026,7 +1026,7 @@ CREATE TABLE `0_payment_terms` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`terms_indicator`), + UNIQUE KEY `terms` (`terms`) +-) TYPE=MyISAM AUTO_INCREMENT=5 ; ++) ENGINE=MyISAM AUTO_INCREMENT=5 ; + + + ### Data of table `0_payment_terms` ### +@@ -1049,7 +1049,7 @@ CREATE TABLE `0_prices` ( + `price` double NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`) +-) TYPE=MyISAM AUTO_INCREMENT=5 ; ++) ENGINE=MyISAM AUTO_INCREMENT=5 ; + + + ### Data of table `0_prices` ### +@@ -1071,7 +1071,7 @@ CREATE TABLE `0_print_profiles` ( + `printer` tinyint(3) unsigned default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `profile` (`profile`,`report`) +-) TYPE=MyISAM AUTO_INCREMENT=10 ; ++) ENGINE=MyISAM AUTO_INCREMENT=10 ; + + + ### Data of table `0_print_profiles` ### +@@ -1101,7 +1101,7 @@ CREATE TABLE `0_printers` ( + `timeout` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_printers` ### +@@ -1123,7 +1123,7 @@ CREATE TABLE `0_purch_data` ( + `conversion_factor` double NOT NULL default '1', + `supplier_description` char(50) NOT NULL default '', + PRIMARY KEY (`supplier_id`,`stock_id`) +-) TYPE=MyISAM ; ++) ENGINE=MyISAM ; + + + ### Data of table `0_purch_data` ### +@@ -1150,7 +1150,7 @@ CREATE TABLE `0_purch_order_details` ( + `quantity_ordered` double NOT NULL default '0', + `quantity_received` double NOT NULL default '0', + PRIMARY KEY (`po_detail_item`) +-) TYPE=InnoDB AUTO_INCREMENT=6 ; ++) ENGINE=InnoDB AUTO_INCREMENT=6 ; + + + ### Data of table `0_purch_order_details` ### +@@ -1176,7 +1176,7 @@ CREATE TABLE `0_purch_orders` ( + `into_stock_location` varchar(5) NOT NULL default '', + `delivery_address` tinytext NOT NULL, + PRIMARY KEY (`order_no`) +-) TYPE=InnoDB AUTO_INCREMENT=3 ; ++) ENGINE=InnoDB AUTO_INCREMENT=3 ; + + + ### Data of table `0_purch_orders` ### +@@ -1197,7 +1197,7 @@ CREATE TABLE `0_quick_entries` ( + `base_desc` varchar(60) default NULL, + PRIMARY KEY (`id`), + KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_quick_entries` ### +@@ -1221,7 +1221,7 @@ CREATE TABLE `0_quick_entry_lines` ( + `dimension2_id` smallint(6) unsigned default NULL, + PRIMARY KEY (`id`), + KEY `qid` (`qid`) +-) TYPE=MyISAM AUTO_INCREMENT=8 ; ++) ENGINE=MyISAM AUTO_INCREMENT=8 ; + + + ### Data of table `0_quick_entry_lines` ### +@@ -1251,7 +1251,7 @@ CREATE TABLE `0_recurrent_invoices` ( + `last_sent` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`), + UNIQUE KEY `description` (`description`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_recurrent_invoices` ### +@@ -1267,7 +1267,7 @@ CREATE TABLE `0_refs` ( + `type` int(11) NOT NULL default '0', + `reference` varchar(100) NOT NULL default '', + PRIMARY KEY (`id`,`type`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_refs` ### +@@ -1291,7 +1291,7 @@ CREATE TABLE `0_sales_order_details` ( + `quantity` double NOT NULL default '0', + `discount_percent` double NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=6 ; ++) ENGINE=InnoDB AUTO_INCREMENT=6 ; + + + ### Data of table `0_sales_order_details` ### +@@ -1328,7 +1328,7 @@ CREATE TABLE `0_sales_orders` ( + `from_stk_loc` varchar(5) NOT NULL default '', + `delivery_date` date NOT NULL default '0000-00-00', + PRIMARY KEY (`trans_type`, `order_no`) +-) TYPE=InnoDB; ++) ENGINE=InnoDB; + + ### Data of table `0_sales_orders` ### + +@@ -1353,7 +1353,7 @@ CREATE TABLE `0_sales_pos` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `pos_name` (`pos_name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_sales_pos` ### +@@ -1373,7 +1373,7 @@ CREATE TABLE `0_sales_types` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `sales_type` (`sales_type`) +-) TYPE=MyISAM AUTO_INCREMENT=3 ; ++) ENGINE=MyISAM AUTO_INCREMENT=3 ; + + + ### Data of table `0_sales_types` ### +@@ -1398,7 +1398,7 @@ CREATE TABLE `0_salesman` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`salesman_code`), + UNIQUE KEY `salesman_name` (`salesman_name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_salesman` ### +@@ -1417,7 +1417,7 @@ CREATE TABLE IF NOT EXISTS `0_security_r + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `role` (`role`) +-) TYPE=MyISAM AUTO_INCREMENT=11 ; ++) ENGINE=MyISAM AUTO_INCREMENT=11 ; + + -- + -- Data of table `0_security_roles` +@@ -1448,7 +1448,7 @@ CREATE TABLE `0_shippers` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`shipper_id`), + UNIQUE KEY `name` (`shipper_name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_shippers` ### +@@ -1466,7 +1466,7 @@ CREATE TABLE `0_sql_trail` ( + `result` tinyint(1) NOT NULL, + `msg` varchar(255) NOT NULL, + PRIMARY KEY (`id`) +-) TYPE=MyISAM AUTO_INCREMENT=1 ; ++) ENGINE=MyISAM AUTO_INCREMENT=1 ; + + + ### Data of table `0_sql_trail` ### +@@ -1494,7 +1494,7 @@ CREATE TABLE `0_stock_category` ( + `dflt_no_sale` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`category_id`), + UNIQUE KEY `description` (`description`) +-) TYPE=MyISAM AUTO_INCREMENT=5 ; ++) ENGINE=MyISAM AUTO_INCREMENT=5 ; + + ### Data of table `0_stock_category` ### + +@@ -1531,7 +1531,7 @@ CREATE TABLE `0_stock_master` ( + `inactive` tinyint(1) NOT NULL default '0', + `no_sale` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`stock_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_stock_master` ### +@@ -1563,7 +1563,7 @@ CREATE TABLE `0_stock_moves` ( + `visible` tinyint(1) NOT NULL default '1', + PRIMARY KEY (`trans_id`), + KEY `type` (`type`,`trans_no`) +-) TYPE=InnoDB AUTO_INCREMENT=37 ; ++) ENGINE=InnoDB AUTO_INCREMENT=37 ; + + + ### Data of table `0_stock_moves` ### +@@ -1619,7 +1619,7 @@ CREATE TABLE `0_supp_allocations` ( + `trans_no_to` int(11) default NULL, + `trans_type_to` int(11) default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=2 ; ++) ENGINE=InnoDB AUTO_INCREMENT=2 ; + + + ### Data of table `0_supp_allocations` ### +@@ -1645,7 +1645,7 @@ CREATE TABLE `0_supp_invoice_items` ( + `unit_tax` double NOT NULL default '0', + `memo_` tinytext, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=6 ; ++) ENGINE=InnoDB AUTO_INCREMENT=6 ; + + + ### Data of table `0_supp_invoice_items` ### +@@ -1678,7 +1678,7 @@ CREATE TABLE `0_supp_trans` ( + KEY `supplier_id` (`supplier_id`), + KEY `SupplierID_2` (`supplier_id`,`supp_reference`), + KEY `type` (`type`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_supp_trans` ### +@@ -1719,7 +1719,7 @@ CREATE TABLE `0_suppliers` ( + `notes` tinytext NOT NULL, + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`supplier_id`) +-) TYPE=MyISAM AUTO_INCREMENT=4 ; ++) ENGINE=MyISAM AUTO_INCREMENT=4 ; + + + ### Data of table `0_suppliers` ### +@@ -1738,7 +1738,7 @@ CREATE TABLE `0_sys_types` ( + `type_no` int(11) NOT NULL default '1', + `next_reference` varchar(100) NOT NULL default '', + PRIMARY KEY (`type_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_sys_types` ### +@@ -1776,7 +1776,7 @@ CREATE TABLE `0_tax_group_items` ( + `tax_type_id` int(11) NOT NULL default '0', + `rate` double NOT NULL default '0', + PRIMARY KEY (`tax_group_id`,`tax_type_id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_tax_group_items` ### +@@ -1795,7 +1795,7 @@ CREATE TABLE `0_tax_groups` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=InnoDB AUTO_INCREMENT=3 ; ++) ENGINE=InnoDB AUTO_INCREMENT=3 ; + + + ### Data of table `0_tax_groups` ### +@@ -1815,7 +1815,7 @@ CREATE TABLE `0_tax_types` ( + `name` varchar(60) NOT NULL default '', + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ; ++) ENGINE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ; + + + ### Data of table `0_tax_types` ### +@@ -1839,7 +1839,7 @@ CREATE TABLE `0_trans_tax_details` ( + `amount` double NOT NULL default '0', + `memo` tinytext, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=12 ; ++) ENGINE=InnoDB AUTO_INCREMENT=12 ; + + + ### Data of table `0_trans_tax_details` ### +@@ -1893,7 +1893,7 @@ CREATE TABLE `0_users` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY (`user_id`) +-) TYPE=MyISAM AUTO_INCREMENT=2; ++) ENGINE=MyISAM AUTO_INCREMENT=2; + + + ### Data of table `0_users` ### +@@ -1911,7 +1911,7 @@ CREATE TABLE `0_voided` ( + `date_` date NOT NULL default '0000-00-00', + `memo_` tinytext NOT NULL, + UNIQUE KEY `id` (`type`,`id`) +-) TYPE=InnoDB ; ++) ENGINE=InnoDB ; + + + ### Data of table `0_voided` ### +@@ -1928,7 +1928,7 @@ CREATE TABLE `0_wo_issue_items` ( + `issue_id` int(11) default NULL, + `qty_issued` double default NULL, + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_wo_issue_items` ### +@@ -1947,7 +1947,7 @@ CREATE TABLE `0_wo_issues` ( + `loc_code` varchar(5) default NULL, + `workcentre_id` int(11) default NULL, + PRIMARY KEY (`issue_no`) +-) TYPE=InnoDB AUTO_INCREMENT=1 ; ++) ENGINE=InnoDB AUTO_INCREMENT=1 ; + + + ### Data of table `0_wo_issues` ### +@@ -1965,7 +1965,7 @@ CREATE TABLE `0_wo_manufacture` ( + `quantity` double NOT NULL default '0', + `date_` date NOT NULL default '0000-00-00', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=2 ; ++) ENGINE=InnoDB AUTO_INCREMENT=2 ; + + + ### Data of table `0_wo_manufacture` ### +@@ -1987,7 +1987,7 @@ CREATE TABLE `0_wo_requirements` ( + `loc_code` char(5) NOT NULL default '', + `units_issued` double NOT NULL default '0', + PRIMARY KEY (`id`) +-) TYPE=InnoDB AUTO_INCREMENT=22 ; ++) ENGINE=InnoDB AUTO_INCREMENT=22 ; + + + ### Data of table `0_wo_requirements` ### +@@ -2026,7 +2026,7 @@ CREATE TABLE `0_workcentres` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +-) TYPE=MyISAM AUTO_INCREMENT=2 ; ++) ENGINE=MyISAM AUTO_INCREMENT=2 ; + + + ### Data of table `0_workcentres` ### +@@ -2054,7 +2054,7 @@ CREATE TABLE `0_workorders` ( + `additional_costs` double NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `wo_ref` (`wo_ref`) +-) TYPE=InnoDB AUTO_INCREMENT=8 ; ++) ENGINE=InnoDB AUTO_INCREMENT=8 ; + + + ### Data of table `0_workorders` ### +@@ -2080,7 +2080,7 @@ CREATE TABLE `0_tags` ( + `inactive` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY(`type`,`name`) +-) TYPE=MyISAM AUTO_INCREMENT=1; ++) ENGINE=MyISAM AUTO_INCREMENT=1; + + + ### Data of table `0_chart_tags` ### +@@ -2095,7 +2095,7 @@ CREATE TABLE `0_tag_associations` ( + `record_id` varchar(11) NOT NULL, + `tag_id` int(11) NOT NULL, + UNIQUE KEY(`record_id`,`tag_id`) +-) TYPE=MyISAM; ++) ENGINE=MyISAM; + + + ### Data of table `0_tag_associations` ### +@@ -2109,5 +2109,5 @@ CREATE TABLE `0_useronline` ( + `file` varchar(100) NOT NULL default '', + PRIMARY KEY `id` (`id`) , + KEY (`timestamp`) +-) TYPE=MYISAM AUTO_INCREMENT=1; ++) ENGINE=MYISAM AUTO_INCREMENT=1; + diff -Nru frontaccounting-2.2.10/debian/postinst frontaccounting-2.2.10/debian/postinst --- frontaccounting-2.2.10/debian/postinst 2010-05-06 15:22:47.000000000 -0400 +++ frontaccounting-2.2.10/debian/postinst 2012-07-28 19:20:14.000000000 -0400 @@ -129,7 +129,7 @@ sed $varscript < $sqlfile | $(eval $mysqlcmd -D ${dbname} -s) # Expand our config file varscript="s#{DB_USER}#${dbuser}#g;s#{DB_PASS}#${dbpass}#g;s#{DB_HOST}#${dbserver}#g;s#{DB_NAME}#${dbname}#g;s#{DB_PREFIX}#${dbprefix}#g;s#{DB_COMPANY}#${company}#g;"; - sed $varscript < $template > $config + sed "$varscript" < $template > $config chown www-data:root $config chmod 640 $config rm $template
signature.asc
Description: This is a digitally signed message part.