29 lines
2.9 KiB
SQL
29 lines
2.9 KiB
SQL
ALTER TABLE "catalog"."artifact" DROP CONSTRAINT IF EXISTS "artifact_version_version_version_fk";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."character" DROP CONSTRAINT IF EXISTS "character_version_version_version_fk";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."weapon" DROP CONSTRAINT IF EXISTS "weapon_version_version_version_fk";--> statement-breakpoint
|
|
ALTER TABLE "guides"."guide" DROP CONSTRAINT IF EXISTS "guide_catalog_version_version_version_fk";--> statement-breakpoint
|
|
DELETE FROM "catalog"."artifact" WHERE "version" IS DISTINCT FROM (SELECT "version" FROM "catalog"."version" WHERE "active" = true LIMIT 1);--> statement-breakpoint
|
|
DELETE FROM "catalog"."character" WHERE "version" IS DISTINCT FROM (SELECT "version" FROM "catalog"."version" WHERE "active" = true LIMIT 1);--> statement-breakpoint
|
|
DELETE FROM "catalog"."weapon" WHERE "version" IS DISTINCT FROM (SELECT "version" FROM "catalog"."version" WHERE "active" = true LIMIT 1);--> statement-breakpoint
|
|
DROP INDEX IF EXISTS "catalog"."catalog_artifact_name_idx";--> statement-breakpoint
|
|
DROP INDEX IF EXISTS "catalog"."catalog_character_name_idx";--> statement-breakpoint
|
|
DROP INDEX IF EXISTS "catalog"."catalog_weapon_name_idx";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."artifact" DROP CONSTRAINT IF EXISTS "artifact_version_key_pk";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."character" DROP CONSTRAINT IF EXISTS "character_version_key_pk";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."weapon" DROP CONSTRAINT IF EXISTS "weapon_version_key_pk";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."artifact" ADD CONSTRAINT "artifact_key_pk" PRIMARY KEY("key");--> statement-breakpoint
|
|
ALTER TABLE "catalog"."character" ADD CONSTRAINT "character_key_pk" PRIMARY KEY("key");--> statement-breakpoint
|
|
ALTER TABLE "catalog"."weapon" ADD CONSTRAINT "weapon_key_pk" PRIMARY KEY("key");--> statement-breakpoint
|
|
ALTER TABLE "guides"."artifact_recommendation" DROP COLUMN "catalog_version";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."artifact" DROP COLUMN "version";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."character" DROP COLUMN "version";--> statement-breakpoint
|
|
ALTER TABLE "catalog"."weapon" DROP COLUMN "version";--> statement-breakpoint
|
|
ALTER TABLE "guides"."guide" DROP COLUMN "catalog_version";--> statement-breakpoint
|
|
ALTER TABLE "guides"."team_member" DROP COLUMN "catalog_version";--> statement-breakpoint
|
|
ALTER TABLE "guides"."weapon_recommendation" DROP COLUMN "catalog_version";--> statement-breakpoint
|
|
CREATE INDEX "catalog_artifact_name_idx" ON "catalog"."artifact" USING btree ("name");--> statement-breakpoint
|
|
CREATE INDEX "catalog_character_name_idx" ON "catalog"."character" USING btree ("name");--> statement-breakpoint
|
|
CREATE INDEX "catalog_weapon_name_idx" ON "catalog"."weapon" USING btree ("name");--> statement-breakpoint
|
|
DROP TABLE "catalog"."sync_job";--> statement-breakpoint
|
|
DROP TABLE "catalog"."version";
|