Changes in db scheme: gl_trans.type_no optimized to int, changed lock_stock.reorder_l...

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

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index 1ab1effbab77e4d810eb4a389bc33c94ebd8d93f..b250e04af3783cc251be31cb7dff72af6c0b9861 100644 (file)
--- a/sql/alter2.4.sql
+++ b/sql/alter2.4.sql
@@ -139,3 +139,6 @@ 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;
+
+ALTER TABLE `0_gl_trans` CHANGE `type_no` `type_no` int(11) NOT NULL default '0';
+ALTER TABLE `0_loc_stock` CHANGE `reorder_level` `reorder_level` double NOT NULL default '0';