X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.4.sql;h=727e91c3a39e83c979ff677fb058f5382d156edc;hb=fec081ddbcf4f2ceb4b325f30cfc1005e855b724;hp=aabaed559921e4fd40d072835c892a38a36a7309;hpb=8c8a0c2edc1de65820507e7129bcb340209e6164;p=fa-stable.git

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index aabaed55..727e91c3 100644
--- a/sql/alter2.4.sql
+++ b/sql/alter2.4.sql
@@ -115,7 +115,6 @@ 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;
@@ -236,3 +235,7 @@ ALTER TABLE `0_stock_moves` DROP COLUMN `visible`;
 UPDATE `0_stock_moves` SET
 	price = price*(1-discount_percent);
 ALTER TABLE `0_stock_moves` DROP COLUMN `discount_percent`;
+
+ALTER TABLE `0_stock_moves` DROP COLUMN `person_id`;
+
+DROP TABLE IF EXISTS `0_movement_types`;