-- Patch 11 rollback removes DB constraints only.
-- Canonicalized values are intentionally not converted back to legacy aliases.
BEGIN;
ALTER TABLE public.article DROP CONSTRAINT IF EXISTS "CHK_article_state";
ALTER TABLE public.article DROP CONSTRAINT IF EXISTS "CHK_article_judgestate";
ALTER TABLE public.article DROP CONSTRAINT IF EXISTS "CHK_article_review_level";
ALTER TABLE public.article DROP CONSTRAINT IF EXISTS "CHK_article_version_positive";
ALTER TABLE public.article_user DROP CONSTRAINT IF EXISTS "CHK_article_user_state";
ALTER TABLE public.article_user DROP CONSTRAINT IF EXISTS "CHK_article_user_judgestate";
ALTER TABLE public.article_user DROP CONSTRAINT IF EXISTS "CHK_article_user_review_status";
ALTER TABLE public.article_user DROP CONSTRAINT IF EXISTS "CHK_article_user_level";
ALTER TABLE public.article ALTER COLUMN state DROP NOT NULL;
ALTER TABLE public.article ALTER COLUMN judgestate DROP NOT NULL;
ALTER TABLE public.article_user ALTER COLUMN state DROP NOT NULL;
ALTER TABLE public.article_user ALTER COLUMN judgestate DROP NOT NULL;
COMMIT;