X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.3.sql;h=c5518404e25e9b185a8569c3abd12b58ea41619a;hb=1c257d9ff0bfe6452423acdb8358e26bd3ce7f43;hp=4d45ed16afdaa9c93f114fc3b239ae3f1916f5c1;hpb=e4c7f0dbe9fa83ed6382713b32a4586ce3e60d81;p=fa-stable.git

diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql
index 4d45ed16..c5518404 100644
--- a/sql/alter2.3.sql
+++ b/sql/alter2.3.sql
@@ -56,7 +56,7 @@ INSERT INTO `0_sys_prefs` SELECT 'gst_no','setup.company', 'varchar','25', c.gst
 INSERT INTO `0_sys_prefs` SELECT 'coy_no','setup.company', 'varchar','25', c.coy_no FROM `0_company` c;
 INSERT INTO `0_sys_prefs` SELECT 'tax_prd','setup.company', 'int','11', c.tax_prd FROM `0_company` c;
 INSERT INTO `0_sys_prefs` SELECT 'tax_last','setup.company', 'int','11', c.tax_last FROM `0_company` c;
-INSERT INTO `0_sys_prefs` SELECT 'postal_address','setup.company', 'tinytext','', c.postal_address FROM `0_company` c;
+INSERT INTO `0_sys_prefs` SELECT 'postal_address','setup.company', 'tinytext','0', c.postal_address FROM `0_company` c;
 INSERT INTO `0_sys_prefs` SELECT 'phone','setup.company', 'varchar','30', c.phone FROM `0_company` c;
 INSERT INTO `0_sys_prefs` SELECT 'fax','setup.company', 'varchar','30',c.fax FROM `0_company` c;
 INSERT INTO `0_sys_prefs` SELECT 'email','setup.company', 'varchar','100', c.email FROM `0_company` c;
@@ -83,7 +83,7 @@ INSERT INTO `0_sys_prefs` SELECT 'exchange_diff_act','glsetup.general', 'varchar
 
 INSERT INTO `0_sys_prefs` SELECT 'default_credit_limit','glsetup.customer', 'int','11', c.default_credit_limit FROM `0_company` c;
 INSERT INTO `0_sys_prefs` SELECT 'accumulate_shipping','glsetup.customer', 'tinyint','1', c.accumulate_shipping FROM `0_company` c;
-INSERT INTO `0_sys_prefs` SELECT 'legal_text','glsetup.customer', 'tinytext','', c.legal_text FROM `0_company` c;
+INSERT INTO `0_sys_prefs` SELECT 'legal_text','glsetup.customer', 'tinytext','0', c.legal_text FROM `0_company` c;
 INSERT INTO `0_sys_prefs` SELECT 'freight_act','glsetup.customer', 'varchar','15', c.freight_act FROM `0_company` c;
 
 INSERT INTO `0_sys_prefs` SELECT 'debtors_act','glsetup.sales', 'varchar','15', c.debtors_act FROM `0_company` c;
@@ -152,7 +152,7 @@ ALTER TABLE `0_chart_master` CHANGE `account_type` `account_type` VARCHAR(10) NO
 ALTER TABLE `0_chart_types` CHANGE `id` `id` VARCHAR(10) NOT NULL;
 ALTER TABLE `0_chart_types` CHANGE `parent` `parent` VARCHAR(10) NOT NULL DEFAULT '-1';
 ALTER TABLE `0_chart_types` CHANGE `class_id` `class_id` VARCHAR(3) NOT NULL DEFAULT '';
-.
+
 UPDATE `0_chart_types` SET parent='' WHERE parent='0' OR parent='-1';
 
 INSERT INTO `0_sys_prefs` (name, category, type, length, value) VALUES ('auto_curr_reval','setup.company', 'smallint','6', '1');
@@ -243,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';