halkyon/apps/learn/halkyon_learn_server/migrations/20261009202105673-explore/migration.sql
Tizian 「ティツィアーン」 649499be23
chore: Halkyon Learn moves into apps/learn
Its server, client, app and curator, and the tools that write its
assets (maps, Anki fixtures, icons), as they are; paths are fixed in
the commits that follow.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Signed-off-by: Tizian 「ティツィアーン」 <raisondetredev@pm.me>
2026-10-22 18:11:02 +02:00

59 lines
2 KiB
PL/PgSQL

BEGIN;
--
-- ACTION ALTER TABLE
--
ALTER TABLE "published_studyset" ADD COLUMN "withdrawnAt" timestamp without time zone;
--
-- ACTION ALTER TABLE
--
ALTER TABLE "studyset_release" ADD COLUMN "title" text NOT NULL DEFAULT ''::text;
ALTER TABLE "studyset_release" ADD COLUMN "secondaryTitle" text;
ALTER TABLE "studyset_release" ADD COLUMN "description" text;
ALTER TABLE "studyset_release" ADD COLUMN "frontLanguage" text;
ALTER TABLE "studyset_release" ADD COLUMN "backLanguage" text;
ALTER TABLE "studyset_release" ADD COLUMN "licenseHolder" text;
ALTER TABLE "studyset_release" ADD COLUMN "licenseYear" bigint;
--
-- MIGRATION VERSION FOR halkyon_learn
--
INSERT INTO "serverpod_migrations" ("module", "version", "timestamp")
VALUES ('halkyon_learn', '20261009202105673-explore', now())
ON CONFLICT ("module")
DO UPDATE SET "version" = '20261009202105673-explore', "timestamp" = now();
--
-- MIGRATION VERSION FOR serverpod
--
INSERT INTO "serverpod_migrations" ("module", "version", "timestamp")
VALUES ('serverpod', '20260824182259319', now())
ON CONFLICT ("module")
DO UPDATE SET "version" = '20260824182259319', "timestamp" = now();
--
-- MIGRATION VERSION FOR serverpod_auth_idp
--
INSERT INTO "serverpod_migrations" ("module", "version", "timestamp")
VALUES ('serverpod_auth_idp', '20260924105404509', now())
ON CONFLICT ("module")
DO UPDATE SET "version" = '20260924105404509', "timestamp" = now();
--
-- MIGRATION VERSION FOR serverpod_offline_sync
--
INSERT INTO "serverpod_migrations" ("module", "version", "timestamp")
VALUES ('serverpod_offline_sync', '20260914143806119', now())
ON CONFLICT ("module")
DO UPDATE SET "version" = '20260914143806119', "timestamp" = now();
--
-- MIGRATION VERSION FOR serverpod_auth_core
--
INSERT INTO "serverpod_migrations" ("module", "version", "timestamp")
VALUES ('serverpod_auth_core', '20260924105232991', now())
ON CONFLICT ("module")
DO UPDATE SET "version" = '20260924105232991', "timestamp" = now();
COMMIT;