16 lines
764 B
SQL
16 lines
764 B
SQL
-- Capture schema drift: columns added directly to DB without migration files
|
|
|
|
ALTER TABLE "Team" ADD COLUMN IF NOT EXISTS "dateFormat" TEXT;
|
|
|
|
ALTER TABLE "Channel" ADD COLUMN IF NOT EXISTS "supplementalVideoIds" TEXT[] NOT NULL DEFAULT ARRAY[]::TEXT[];
|
|
|
|
ALTER TABLE "DescriptionBlock" ADD COLUMN IF NOT EXISTS "condition" JSONB;
|
|
|
|
ALTER TABLE "Template" ADD COLUMN IF NOT EXISTS "videoFields" JSONB;
|
|
|
|
ALTER TABLE "Collaborator" ADD COLUMN IF NOT EXISTS "instagramLink" TEXT;
|
|
ALTER TABLE "Collaborator" ADD COLUMN IF NOT EXISTS "tiktokLink" TEXT;
|
|
ALTER TABLE "Collaborator" ADD COLUMN IF NOT EXISTS "twitterLink" TEXT;
|
|
ALTER TABLE "Collaborator" ADD COLUMN IF NOT EXISTS "blueskyLink" TEXT;
|
|
ALTER TABLE "Collaborator" ADD COLUMN IF NOT EXISTS "discordHandle" TEXT;
|