58 lines
1.8 KiB
SQL
58 lines
1.8 KiB
SQL
-- AlterTable
|
|
ALTER TABLE "public"."Hunt"
|
|
ADD COLUMN "description_de" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN "description_en" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN "name_de" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN "name_en" TEXT NOT NULL DEFAULT '';
|
|
|
|
update "public"."Hunt"
|
|
set description_en = description,
|
|
description_de = description,
|
|
name_en = name,
|
|
name_de = name
|
|
where description_de = '';
|
|
|
|
ALTER TABLE "public"."Hunt"
|
|
DROP COLUMN "description",
|
|
DROP COLUMN "name",
|
|
ALTER COLUMN name_de drop default,
|
|
ALTER COLUMN name_en drop default,
|
|
ALTER COLUMN description_de drop default,
|
|
ALTER COLUMN description_en drop default;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "public"."HuntQuest"
|
|
ADD COLUMN "description_de" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN "description_en" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN "extraText_de" TEXT,
|
|
ADD COLUMN "extraText_en" TEXT,
|
|
ADD COLUMN "question_de" TEXT,
|
|
ADD COLUMN "question_en" TEXT,
|
|
ADD COLUMN "title_de" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN "title_en" TEXT NOT NULL DEFAULT '';
|
|
|
|
update "public"."HuntQuest"
|
|
set description_en = description,
|
|
description_de = description,
|
|
title_en = title,
|
|
title_de = title,
|
|
"extraText_en" = "extraText",
|
|
"extraText_de" = "extraText",
|
|
question_en = question,
|
|
question_de = question
|
|
where description_de = '';
|
|
|
|
ALTER TABLE "public"."HuntQuest"
|
|
DROP COLUMN "description",
|
|
DROP COLUMN "title",
|
|
DROP COLUMN question,
|
|
DROP COLUMN "extraText",
|
|
ALTER COLUMN title_de drop default,
|
|
ALTER COLUMN title_en drop default,
|
|
ALTER COLUMN description_de drop default,
|
|
ALTER COLUMN description_en drop default;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "public"."QuestAnswer"
|
|
ADD COLUMN "lang" CHAR(2) NOT NULL DEFAULT 'de';
|