X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.3.sql;h=496144d054f2443e8c480e914c6e1aa77c9442ad;hb=4d3a86a9286de3f4d5552ad2aa237a91df6aa689;hp=e6d3da0cfaa89d5dfa1c749808a9ce04f54ae48c;hpb=bd3023c1b5e64429043358a691b3aae20eb54c09;p=fa-stable.git

diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql
index e6d3da0c..496144d0 100644
--- a/sql/alter2.3.sql
+++ b/sql/alter2.3.sql
@@ -115,6 +115,8 @@ INSERT INTO `0_sys_prefs` SELECT 'version_id', 'system', 'varchar', '11', c.vers
 ALTER TABLE `0_stock_master` ADD COLUMN `editable` TINYINT(1) NOT NULL default '0';
 ALTER TABLE `0_debtor_trans` ADD COLUMN `payment_terms` int(11) default NULL;
 ALTER TABLE `0_sales_orders` ADD COLUMN `payment_terms` int(11) default NULL;
+ALTER TABLE `0_sales_orders` ADD COLUMN `total` double NOT NULL default '0';
+ALTER TABLE `0_purch_orders` ADD COLUMN `total` double NOT NULL default '0';
 
 # change account, groups and classes id's
 ALTER TABLE `0_bank_accounts` CHANGE `account_code` `account_code` VARCHAR(15) NOT NULL DEFAULT '';
@@ -241,3 +243,9 @@ INSERT INTO `0_crm_persons` (`ref`, `name`, `address`, `phone`, `phone2`,
 INSERT INTO `0_crm_contacts` (`person_id`, `type`, `action`, `entity_id`)
 	SELECT `id`, `tmp_class`, 'general', `tmp_id`
 	FROM `0_crm_persons`;
+
+ALTER TABLE `0_debtor_trans_details` ADD COLUMN `src_id` int(11) default NULL;
+ALTER TABLE `0_debtor_trans_details` ADD KEY (`src_id`);
+ALTER TABLE `0_suppliers` ADD COLUMN `tax_included` tinyint(1) NOT NULL default '0' AFTER `payment_terms`;
+ALTER TABLE `0_supp_trans` ADD COLUMN `tax_included` tinyint(1) NOT NULL default '0';
+ALTER TABLE `0_purch_orders` ADD COLUMN `tax_included` tinyint(1) NOT NULL default '0';