X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter.sql;h=9d87fc5737f3cdd1edf0379395bf01760a8c5308;hb=60d8961142e146fc12a209727c7c77774303f07a;hp=ae2fd8176b6e781b4fbaa7390e60a40658dbefc7;hpb=512f9dbe2a3dc1282358c6641ebd715e1bae5136;p=fa-stable.git

diff --git a/sql/alter.sql b/sql/alter.sql
index ae2fd817..9d87fc57 100644
--- a/sql/alter.sql
+++ b/sql/alter.sql
@@ -16,15 +16,17 @@
 -- ALTER TABLE
 -- 
 
-CREATE TABLE `0_item_units` (
-  `abbr` VARCHAR(20) NOT NULL, 
-  `name` VARCHAR(40) NOT NULL, 
-  `decimals` TINYINT(2) NOT NULL,
+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 (`name`)
-)
-TYPE = myisam
-COMMENT = 'units of measure';
+  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`;