mirror of
https://gh-proxy.org/https://github.com/klinsmaya/multica.git
synced 2026-11-08 01:16:45 +08:00
YYClaw
8c563b49be
* feat(issues): preserve source context for sub-issues * fix(issues): address source context review findings * fix(migrations): guard source context rollback preflight
16 lines
676 B
SQL
16 lines
676 B
SQL
DO $$
|
|
BEGIN
|
|
IF EXISTS (SELECT 1 FROM issue_source_context)
|
|
OR EXISTS (SELECT 1 FROM attachment WHERE source_context_id IS NOT NULL)
|
|
OR EXISTS (SELECT 1 FROM issue_source_context_object_intent) THEN
|
|
RAISE EXCEPTION USING
|
|
MESSAGE = 'cannot roll back issue source context while captured data or stored objects still exist',
|
|
HINT = 'Remove source-context captures and their stored objects through application cleanup, then retry the rollback.';
|
|
END IF;
|
|
END
|
|
$$;
|
|
|
|
ALTER TABLE attachment DROP COLUMN IF EXISTS source_context_id;
|
|
DROP TABLE IF EXISTS issue_source_context_object_intent;
|
|
DROP TABLE IF EXISTS issue_source_context;
|