Fixed point of sale handling and terms selection

[fa-stable.git] / sql / alter2.3.sql

diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql
index 4d45ed16afdaa9c93f114fc3b239ae3f1916f5c1..496144d054f2443e8c480e914c6e1aa77c9442ad 100644 (file)
--- a/sql/alter2.3.sql
+++ b/sql/alter2.3.sql
@@ -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';