Removed obsolete stock_move.discount_percent field

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

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index df69f877157a714ab6b387f52a5dc08505487321..aabaed559921e4fd40d072835c892a38a36a7309 100644 (file)
--- a/sql/alter2.4.sql
+++ b/sql/alter2.4.sql
@@ -231,3 +231,8 @@ DELETE moves
        WHERE moves.`type`=11;
 
 ALTER TABLE `0_stock_moves` DROP COLUMN `visible`;
+# stock_moves.discount_percent field are obsolete
+
+UPDATE `0_stock_moves` SET
+       price = price*(1-discount_percent);
+ALTER TABLE `0_stock_moves` DROP COLUMN `discount_percent`;