X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter.sql;h=ab30ca4f8b3bd41a7fd569eccf13f412729be4c3;hb=d7dde51cf888dfc7e049fefed38e786a369b9b38;hp=d1b856aa9c44c96b5ddee095f2145afc5f85fff6;hpb=dc45c23788aef82de242efa67ad47979099b1e97;p=fa-stable.git

diff --git a/sql/alter.sql b/sql/alter.sql
index d1b856aa..ab30ca4f 100644
--- a/sql/alter.sql
+++ b/sql/alter.sql
@@ -16,6 +16,22 @@
 -- ALTER TABLE
 -- 
 
+ALTER TABLE `0_company` ADD `base_sales` INT( 11 ) DEFAULT '-1' NOT NULL AFTER `no_supplier_list` ;
+ALTER TABLE `0_sales_types` ADD `factor` DOUBLE DEFAULT '1' NOT NULL AFTER `tax_included` ;
+
+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` );
 
@@ -28,6 +44,7 @@ ALTER TABLE `0_wo_requirements` CHANGE `workcentre` `workcentre` INT( 11 ) NOT N
 
 ALTER TABLE `0_debtor_trans` ADD `version` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `type`;
 ALTER TABLE `0_sales_orders` ADD `version` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `order_no`;
+ALTER TABLE `0_sales_orders` ADD `type` TINYINT(1) NOT NULL DEFAULT '0' AFTER `version`;
 
 ALTER TABLE `0_tax_types` DROP `out`;
 ALTER TABLE `0_debtor_trans_details` ADD COLUMN `qty_done` double NOT NULL default '0';