-
Notifications
You must be signed in to change notification settings - Fork 9
Back end SQLs that might be useful
Hakju Oh edited this page Aug 13, 2020
·
3 revisions
- Purge unwanted published top-level BIE
SET FOREIGN_KEY_CHECKS = 0; DELETE FROM `abie` WHERE `owner_top_level_asbiep_id` IN (?); DELETE FROM `asbie` WHERE `owner_top_level_asbiep_id` IN (?); DELETE FROM `bbie` WHERE `owner_top_level_asbiep_id` IN (?); DELETE FROM `asbiep` WHERE `owner_top_level_asbiep_id` IN (?); DELETE FROM `bbiep` WHERE `owner_top_level_asbiep_id` IN (?); DELETE FROM `bbie_sc` WHERE `owner_top_level_asbiep_id` IN (?); DELETE FROM `biz_ctx_assignment` WHERE `top_level_asbiep_id` IN (?); DELETE FROM `top_level_asbiep` WHERE `top_level_asbiep_id` IN (?); SET FOREIGN_KEY_CHECKS = 1;
Replace ? with the ID of the top-level BIE. The ID can be obtained from the last token of the URL when the top-level BIE is opened in Score.