Switching all MyISAM tables to InnoDB, fixed charset and small bugs in init sql files.

[fa-stable.git] / sql / alter2.4.sql

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index e8c2d3d02909bcc52a6a6f56cb26614b5d7af75e..1a135b77b5f2cd7be899e6b9e17e1013ad59cf8f 100644 (file)
--- a/sql/alter2.4.sql
+++ b/sql/alter2.4.sql
@@ -97,3 +97,43 @@ INSERT INTO `0_sys_prefs` VALUES('print_invoice_no', 'glsetup.sales', 'tinyint',
 INSERT INTO `0_sys_prefs` VALUES('allow_negative_prices', 'glsetup.inventory', 'tinyint', 1, '1');
 INSERT INTO `0_sys_prefs` VALUES('print_item_images_on_quote', 'glsetup.inventory', 'tinyint', 1, '0');
 INSERT INTO `0_sys_prefs` VALUES('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
+
+# switching all MyISAM tables to InnoDB
+ALTER TABLE `0_areas` ENGINE=InnoDB;
+ALTER TABLE `0_attachments` ENGINE=InnoDB;
+ALTER TABLE `0_bank_accounts` ENGINE=InnoDB;
+ALTER TABLE `0_bom` ENGINE=InnoDB;
+ALTER TABLE `0_chart_class` ENGINE=InnoDB;
+ALTER TABLE `0_chart_master` ENGINE=InnoDB;
+ALTER TABLE `0_chart_types` ENGINE=InnoDB;
+ALTER TABLE `0_credit_status` ENGINE=InnoDB;
+ALTER TABLE `0_currencies` ENGINE=InnoDB;
+ALTER TABLE `0_cust_branch` ENGINE=InnoDB;
+ALTER TABLE `0_debtors_master` ENGINE=InnoDB;
+ALTER TABLE `0_exchange_rates` ENGINE=InnoDB;
+ALTER TABLE `0_groups` ENGINE=InnoDB;
+ALTER TABLE `0_item_codes` ENGINE=InnoDB;
+ALTER TABLE `0_item_units` ENGINE=InnoDB;
+ALTER TABLE `0_locations` ENGINE=InnoDB;
+ALTER TABLE `0_movement_types` ENGINE=InnoDB;
+ALTER TABLE `0_payment_terms` ENGINE=InnoDB;
+ALTER TABLE `0_prices` ENGINE=InnoDB;
+ALTER TABLE `0_printers` ENGINE=InnoDB;
+ALTER TABLE `0_print_profiles` ENGINE=InnoDB;
+ALTER TABLE `0_purch_data` ENGINE=InnoDB;
+ALTER TABLE `0_quick_entries` ENGINE=InnoDB;
+ALTER TABLE `0_quick_entry_lines` ENGINE=InnoDB;
+ALTER TABLE `0_salesman` ENGINE=InnoDB;
+ALTER TABLE `0_sales_pos` ENGINE=InnoDB;
+ALTER TABLE `0_sales_types` ENGINE=InnoDB;
+ALTER TABLE `0_security_roles` ENGINE=InnoDB;
+ALTER TABLE `0_shippers` ENGINE=InnoDB;
+ALTER TABLE `0_sql_trail` ENGINE=InnoDB;
+ALTER TABLE `0_stock_category` ENGINE=InnoDB;
+ALTER TABLE `0_suppliers` ENGINE=InnoDB;
+ALTER TABLE `0_sys_prefs` ENGINE=InnoDB;
+ALTER TABLE `0_tags` ENGINE=InnoDB;
+ALTER TABLE `0_tag_associations` ENGINE=InnoDB;
+ALTER TABLE `0_useronline` ENGINE=InnoDB;
+ALTER TABLE `0_users` ENGINE=InnoDB;
+ALTER TABLE `0_workcentres` ENGINE=InnoDB;