contest/orbit-boards

Orbit Boards, a private, remixable team task board built with FastAPI, DataK3, AppID, Models and MCP.

• dodil-challenge
• dodil-challenge-boards

A remix template · 0 remixes · Remix contest/orbit-boards

migrations/001_starter_schema_alignment.sql

-- Forward-only, additive migration for buckets created from the original starter schema.
-- Fresh remixes get these columns from schema.sql; existing buckets do not rerun schema.sql
-- during an Ignite code deploy. Run each statement with `dodil data pg -b <repo>-data "..."`.
ALTER TABLE activity ADD COLUMN IF NOT EXISTS field TEXT;
ALTER TABLE activity ADD COLUMN IF NOT EXISTS old_value TEXT;
ALTER TABLE activity ADD COLUMN IF NOT EXISTS new_value TEXT;
ALTER TABLE cards ADD COLUMN IF NOT EXISTS description TEXT NOT NULL DEFAULT '';
ALTER TABLE cards ADD COLUMN IF NOT EXISTS labels TEXT NOT NULL DEFAULT '[]';
ALTER TABLE cards ADD COLUMN IF NOT EXISTS position INTEGER NOT NULL DEFAULT 0;
ALTER TABLE cards ADD COLUMN IF NOT EXISTS created_at TIMESTAMPTZ NOT NULL DEFAULT now();