Automatic calculation of not set item prices from home currency and base price list...

[fa-stable.git] / sql / alter.sql

diff --git a/sql/alter.sql b/sql/alter.sql
index 9d87fc5737f3cdd1edf0379395bf01760a8c5308..c6a3dfcddb578deb64f195a9ee93add9e807f173 100644 (file)
--- a/sql/alter.sql
+++ b/sql/alter.sql
@@ -16,6 +16,9 @@
 -- ALTER TABLE
 -- 
 
+ALTER TABLE `0_sales_types` ADD `factor` DOUBLE DEFAULT '1' NOT NULL AFTER `tax_included` ;
+ALTER TABLE `0_sales_types` ADD `base` TINYINT(1) DEFAULT '0' NOT NULL AFTER `factor` ;
+
 DROP TABLE IF EXISTS `0_item_units`; 
 CREATE TABLE IF NOT EXISTS `0_item_units` (
   `abbr` varchar(20) NOT NULL,