From c0f5875022fad0f717908c17ce4e3ba42315cffc Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Tue, 31 Oct 2017 09:11:36 +0100 Subject: [PATCH] Change on debtor_trans/supp_trans keys added in 2.4/2.4rc upgrade scripts --- sql/alter2.4.sql | 10 ++++++++++ sql/alter2.4rc1.sql | 10 ++++++++++ 2 files changed, 20 insertions(+) diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql index 6359598a..f51e1d2c 100644 --- a/sql/alter2.4.sql +++ b/sql/alter2.4.sql @@ -307,3 +307,13 @@ UPDATE `0_bank_trans` SET person_id=trans_no WHERE person_type_id=26; ALTER TABLE `0_budget_trans` CHANGE `counter` `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `0_sys_prefs` CHANGE `value` `value` text NOT NULL default ''; + +ALTER TABLE `0_debtor_trans` + CHANGE `debtor_no` `debtor_no` int(11) unsigned NOT NULL, + DROP PRIMARY KEY, + ADD PRIMARY KEY (`type`,`trans_no`,`debtor_no`); + +ALTER TABLE `0_supp_trans` + CHANGE `supplier_id` `supplier_id` int(11) unsigned NOT NULL, + DROP PRIMARY KEY, + ADD PRIMARY KEY (`type`,`trans_no`,`supplier_id`); diff --git a/sql/alter2.4rc1.sql b/sql/alter2.4rc1.sql index d71a92dc..81908dfe 100644 --- a/sql/alter2.4rc1.sql +++ b/sql/alter2.4rc1.sql @@ -49,3 +49,13 @@ UPDATE `0_bank_trans` SET person_id=trans_no WHERE person_type_id=26; ALTER TABLE `0_budget_trans` CHANGE `counter` `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `0_sys_prefs` CHANGE `value` `value` text NOT NULL default ''; + +ALTER TABLE `0_debtor_trans` + CHANGE `debtor_no` `debtor_no` int(11) unsigned NOT NULL, + DROP PRIMARY KEY, + ADD PRIMARY KEY (`type`,`trans_no`,`debtor_no`); + +ALTER TABLE `0_supp_trans` + CHANGE `supplier_id` `supplier_id` int(11) unsigned NOT NULL, + DROP PRIMARY KEY, + ADD PRIMARY KEY (`type`,`trans_no`,`supplier_id`); -- 2.30.2