projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Small warning cleanup in bank payment/deposit edition.
[fa-stable.git]
/
sql
/
alter2.4.sql
diff --git
a/sql/alter2.4.sql
b/sql/alter2.4.sql
index aabaed559921e4fd40d072835c892a38a36a7309..727e91c3a39e83c979ff677fb058f5382d156edc 100644
(file)
--- 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_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_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`;
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`;