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

diff --git a/sql/alter.sql b/sql/alter.sql
index d1b856aa..3a98d59f 100644
--- a/sql/alter.sql
+++ b/sql/alter.sql
@@ -16,6 +16,7 @@
 -- ALTER TABLE
 -- 
 
+DROP TABLE IF EXISTS `0_form_items`; 
 
 ALTER TABLE `0_tax_types` DROP INDEX `name`, ADD UNIQUE `name` ( `name` , `rate` );
 
@@ -28,6 +29,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';