11 lines
512 B
SQL
11 lines
512 B
SQL
-- AlterTable
|
|
ALTER TABLE "synology_ds_configs" ADD COLUMN IF NOT EXISTS "films_host_path" TEXT NOT NULL DEFAULT '';
|
|
ALTER TABLE "synology_ds_configs" ADD COLUMN IF NOT EXISTS "series_host_path" TEXT NOT NULL DEFAULT '';
|
|
|
|
-- CreateEnum
|
|
DO $$ BEGIN
|
|
CREATE TYPE "DownloadLibraryTarget" AS ENUM ('FILMS', 'FOUR_K', 'SERIES');
|
|
EXCEPTION WHEN duplicate_object THEN null; END $$;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "download_jobs" ADD COLUMN IF NOT EXISTS "library_target" "DownloadLibraryTarget" NOT NULL DEFAULT 'FOUR_K';
|