.. ================================================== .. FOR YOUR INFORMATION .. -------------------------------------------------- .. -*- coding: utf-8 -*- with BOM. .. include:: ../../../Includes.txt .. _administrators_upgrades_org_102: 10.2 ==== 10.2.0 The relation between tx_org_cal and tx_org_headquerters has changed. **YOU MUST run the SQL statemants from below.** .. code:: sql -- Backup your table tx_org_mm_all before running the statements from below! -- -- The effected rows SELECT * FROM `tx_org_mm_all` WHERE `table_local` = 'tx_org_headquarters' AND `table_foreign` = 'tx_org_cal'; -- -- Update statements UPDATE `tx_org_mm_all` SET `table_local` = 'myaction', `table_foreign` = `uid_foreign` WHERE `table_local` = 'tx_org_headquarters' AND `table_foreign` = 'tx_org_cal'; UPDATE `tx_org_mm_all` SET `uid_foreign` = `uid_local` WHERE `table_local` = 'myaction'; UPDATE `tx_org_mm_all` SET `uid_local` = `table_foreign` WHERE `table_local` = 'myaction'; UPDATE `tx_org_mm_all` SET `table_local` = 'tx_org_cal', `table_foreign` = 'tx_org_headquarters' WHERE `table_local` = 'myaction';