BEGIN;
DROP TABLE IF EXISTS public.article_review_history;
DROP TABLE IF EXISTS public.article_version;
DROP INDEX IF EXISTS public."IDX_article_user_review_queue";
DROP INDEX IF EXISTS public."IDX_article_review_level";
ALTER TABLE public.article_user
  DROP COLUMN IF EXISTS level,
  DROP COLUMN IF EXISTS active,
  DROP COLUMN IF EXISTS "reviewStatus",
  DROP COLUMN IF EXISTS decision,
  DROP COLUMN IF EXISTS "finalNote",
  DROP COLUMN IF EXISTS "assignedAt",
  DROP COLUMN IF EXISTS "acceptedAt",
  DROP COLUMN IF EXISTS "startedAt",
  DROP COLUMN IF EXISTS "submittedAt";
ALTER TABLE public.article
  DROP COLUMN IF EXISTS "reviewLevel",
  DROP COLUMN IF EXISTS "finalDecision",
  DROP COLUMN IF EXISTS "finalNote",
  DROP COLUMN IF EXISTS "ownerCanEdit",
  DROP COLUMN IF EXISTS "reviewsVisibleToAuthor",
  DROP COLUMN IF EXISTS version,
  DROP COLUMN IF EXISTS "reviewStartedAt",
  DROP COLUMN IF EXISTS "reviewCompletedAt";
COMMIT;