Matt
6ca39c976b
All checks were successful
Build and Push Docker Image / build (push) Successful in 7m45s
Replace Pipeline/Stage system with Competition/Round architecture. New schema: Competition, Round (7 types), JuryGroup, AssignmentPolicy, ProjectRoundState, DeliberationSession, ResultLock, SubmissionWindow. New services: round-engine, round-assignment, deliberation, result-lock, submission-manager, competition-context, ai-prompt-guard. Full admin/jury/applicant/mentor UI rewrite. AI prompt hardening with structured prompts, retry logic, and injection detection. All legacy pipeline/stage code removed. 4 new migrations + seed aligned. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
32 lines
1.4 KiB
SQL
32 lines
1.4 KiB
SQL
-- =============================================================================
|
|
-- Phase 7/8 Migration Part 2: Drop legacy Pipeline/Track/Stage tables and enums
|
|
-- =============================================================================
|
|
-- This migration removes the old stage-based architecture tables and enums.
|
|
-- All data has been migrated to Competition/Round architecture.
|
|
|
|
-- ─── Drop Tables in FK-safe order ────────────────────────────────────────────
|
|
|
|
-- Drop ProjectStageState (references Track and Stage)
|
|
DROP TABLE IF EXISTS "ProjectStageState" CASCADE;
|
|
|
|
-- Drop StageTransition (references Stage)
|
|
DROP TABLE IF EXISTS "StageTransition" CASCADE;
|
|
|
|
-- Drop Stage (references Track)
|
|
DROP TABLE IF EXISTS "Stage" CASCADE;
|
|
|
|
-- Drop Track (references Pipeline)
|
|
DROP TABLE IF EXISTS "Track" CASCADE;
|
|
|
|
-- Drop Pipeline
|
|
DROP TABLE IF EXISTS "Pipeline" CASCADE;
|
|
|
|
-- ─── Drop Enums ──────────────────────────────────────────────────────────────
|
|
|
|
DROP TYPE IF EXISTS "StageType";
|
|
DROP TYPE IF EXISTS "TrackKind";
|
|
DROP TYPE IF EXISTS "RoutingMode";
|
|
DROP TYPE IF EXISTS "StageStatus";
|
|
DROP TYPE IF EXISTS "ProjectStageStateValue";
|
|
DROP TYPE IF EXISTS "DecisionMode";
|