Small warning cleanup in bank payment/deposit edition.
[fa-stable.git] / sql / alter2.4.sql
index aabaed559921e4fd40d072835c892a38a36a7309..727e91c3a39e83c979ff677fb058f5382d156edc 100644 (file)
@@ -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`;