Minor change in menu and function in view_print_transaction.php

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

diff --git a/sql/alter.sql b/sql/alter.sql
index b602197962f08be3773442f59c42dd80106784c9..9c50af4bf0ea8119301ddf785c2395fdccdbf0b9 100644 (file)
--- a/sql/alter.sql
+++ b/sql/alter.sql
@@ -13,14 +13,20 @@
 -- --------------------------------------------------------
 
 -- 
--- ALTER TABLE for `0_company`
+-- ALTER TABLE
 -- 
 
-ALTER TABLE `0_supp_invoice_items` CHANGE `gl_code` `gl_code` VARCHAR(11) NOT NULL DEFAULT '0';
+ALTER TABLE `0_tax_types` DROP `out`;
+ALTER TABLE `0_debtor_trans_details` ADD COLUMN `qty_done` double NOT NULL default '0';
+
+ALTER TABLE `0_debtor_trans` ADD COLUMN `trans_link` int(11) NOT NULL default '0';
+INSERT INTO `0_sys_types` VALUES ('13', 'Delivery', '1', '1');
+ALTER TABLE `0_sales_order_details` CHANGE `qty_invoiced` `qty_sent` DOUBLE NOT NULL default '0';
+
 
+ALTER TABLE `0_supp_invoice_items` CHANGE `gl_code` `gl_code` VARCHAR(11) NOT NULL DEFAULT '0';
 ALTER TABLE `0_sales_order_details` DROP PRIMARY KEY;
 ALTER TABLE `0_sales_order_details` ADD `id` INTEGER(11) NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);
-ALTER TABLE `0_sales_order_details` CHANGE `qty_invoiced` `qty_sent` DOUBLE NOT NULL default '0';
 
 ALTER TABLE `0_company` ADD `no_item_list` TINYINT(1) NOT NULL DEFAULT '0' AFTER `f_year`;
 ALTER TABLE `0_company` ADD `no_customer_list` TINYINT(1) NOT NULL DEFAULT '0' AFTER `no_item_list`;
@@ -30,7 +36,3 @@ ALTER TABLE `0_salesman` ADD `provision` DOUBLE NOT NULL DEFAULT '0' AFTER `sale
 ALTER TABLE `0_salesman` ADD `break_pt` DOUBLE NOT NULL DEFAULT '0' AFTER `provision`;
 ALTER TABLE `0_salesman` ADD `provision2` DOUBLE NOT NULL DEFAULT '0' AFTER `break_pt`;
 
-ALTER TABLE `0_debtor_trans_details` ADD COLUMN `qty_done` double NOT NULL default '0';
-ALTER TABLE `0_debtor_trans` ADD COLUMN `trans_link` int(11) NOT NULL default '0';
-
-INSERT INTO `0_sys_types` VALUES ('13', 'Delivery', '1', '1');