Added update of Units of Measure and converting of deptor_trans records from release...

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

diff --git a/sql/alter.sql b/sql/alter.sql
index 40f391c04d0af8c2e518806b67609d167c5deca5..9d87fc5737f3cdd1edf0379395bf01760a8c5308 100644 (file)
--- a/sql/alter.sql
+++ b/sql/alter.sql
@@ -16,6 +16,19 @@
 -- ALTER TABLE
 -- 
 
+DROP TABLE IF EXISTS `0_item_units`; 
+CREATE TABLE IF NOT EXISTS `0_item_units` (
+  `abbr` varchar(20) NOT NULL, 
+  `name` varchar(40) NOT NULL, 
+  `decimals` tinyint(2) NOT NULL,
+  PRIMARY KEY (`abbr`),
+  UNIQUE KEY `name` (`name`)
+) TYPE = MyISAM;
+
+INSERT INTO `0_item_units` (`abbr`, `name`, `decimals`) SELECT DISTINCT `units`, CONCAT(UPPER(SUBSTRING(`units`, 1, 1)), LOWER(SUBSTRING(`units`, 2))), 0 FROM `0_stock_master` ;
+UPDATE `0_debtor_trans` SET `ov_amount`=-`ov_amount`, `ov_gst`=-`ov_gst`, `ov_freight`=-`ov_freight`, `ov_discount`=-`ov_discount` WHERE `ov_amount` < 0 AND `type` <> 10 AND `type` <> 13 ;
+
+DROP TABLE IF EXISTS `0_form_items`; 
 
 ALTER TABLE `0_tax_types` DROP INDEX `name`, ADD UNIQUE `name` ( `name` , `rate` );