root
7b4d7ccf68
Provide a unified ops console for inspecting, retrying and cancelling jobs across generation, template/kol assist, knowledge parse, desktop publish/task, compliance review and monitoring collect sources. Wires RabbitMQ for retry republish and consolidates the desktop_publish_jobs columns into the base migration. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
25 lines
897 B
SQL
25 lines
897 B
SQL
DROP INDEX IF EXISTS idx_desktop_publish_jobs_status_scheduled;
|
|
|
|
ALTER TABLE desktop_publish_jobs
|
|
DROP CONSTRAINT IF EXISTS desktop_publish_jobs_compliance_blocked_record_id_fkey;
|
|
|
|
ALTER TABLE article_versions
|
|
DROP CONSTRAINT IF EXISTS fk_article_versions_manual_review;
|
|
|
|
DROP TABLE IF EXISTS compliance_manual_reviews;
|
|
DROP TABLE IF EXISTS compliance_review_jobs;
|
|
|
|
ALTER TABLE compliance_violations
|
|
DROP CONSTRAINT IF EXISTS fk_compliance_violations_ack;
|
|
|
|
DROP TABLE IF EXISTS compliance_ack_records;
|
|
DROP TABLE IF EXISTS compliance_violations;
|
|
DROP TABLE IF EXISTS compliance_check_records;
|
|
|
|
ALTER TABLE article_versions
|
|
DROP CONSTRAINT IF EXISTS ck_article_versions_manual_review_status,
|
|
DROP COLUMN IF EXISTS manual_review_updated_at,
|
|
DROP COLUMN IF EXISTS manual_review_id,
|
|
DROP COLUMN IF EXISTS manual_review_status,
|
|
DROP COLUMN IF EXISTS plaintext_snapshot;
|