From 1b6e0df88c79f090958ee1779aa134a0fe18c7c6 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sat, 8 Mar 2008 17:49:53 +0000 Subject: [PATCH] Added 'type' field into sales_orders --- sql/alter.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/sql/alter.sql b/sql/alter.sql index d1b856aa..40f391c0 100644 --- a/sql/alter.sql +++ b/sql/alter.sql @@ -28,6 +28,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'; -- 2.30.2