47 lines
2.3 KiB
SQL
47 lines
2.3 KiB
SQL
|
-- +goose Up
|
||
|
|
-- +goose StatementBegin
|
||
|
|
DROP INDEX IF EXISTS idx_request_integrations_default_per_kind;
|
||
|
|
DROP INDEX IF EXISTS idx_request_integrations_default4k_per_kind;
|
||
|
|
ALTER TABLE public.request_integrations
|
||
|
|
DROP CONSTRAINT IF EXISTS request_integrations_kind_check,
|
||
|
|
DROP COLUMN IF EXISTS kind,
|
||
|
|
DROP COLUMN IF EXISTS root_folder,
|
||
|
|
DROP COLUMN IF EXISTS quality_profile_id,
|
||
|
|
DROP COLUMN IF EXISTS tags,
|
||
|
|
DROP COLUMN IF EXISTS is_4k,
|
||
|
|
DROP COLUMN IF EXISTS is_default,
|
||
|
|
DROP COLUMN IF EXISTS is_default_4k,
|
||
|
|
DROP COLUMN IF EXISTS anime_enabled,
|
||
|
|
DROP COLUMN IF EXISTS anime_quality_profile_id,
|
||
|
|
DROP COLUMN IF EXISTS anime_root_folder,
|
||
|
|
DROP COLUMN IF EXISTS anime_tags,
|
||
|
|
DROP COLUMN IF EXISTS options;
|
||
|
|
-- +goose StatementEnd
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- +goose StatementBegin
|
||
|
|
ALTER TABLE public.request_integrations
|
||
|
|
ADD COLUMN IF NOT EXISTS kind text NOT NULL DEFAULT '',
|
||
|
|
ADD COLUMN IF NOT EXISTS root_folder text NOT NULL DEFAULT '',
|
||
|
|
ADD COLUMN IF NOT EXISTS quality_profile_id integer,
|
||
|
|
ADD COLUMN IF NOT EXISTS tags integer[] NOT NULL DEFAULT '{}',
|
||
|
|
ADD COLUMN IF NOT EXISTS is_4k boolean NOT NULL DEFAULT false,
|
||
|
|
ADD COLUMN IF NOT EXISTS is_default boolean NOT NULL DEFAULT false,
|
||
|
|
ADD COLUMN IF NOT EXISTS is_default_4k boolean NOT NULL DEFAULT false,
|
||
|
|
ADD COLUMN IF NOT EXISTS anime_enabled boolean NOT NULL DEFAULT false,
|
||
|
|
ADD COLUMN IF NOT EXISTS anime_quality_profile_id integer,
|
||
|
|
ADD COLUMN IF NOT EXISTS anime_root_folder text NOT NULL DEFAULT '',
|
||
|
|
ADD COLUMN IF NOT EXISTS anime_tags integer[] NOT NULL DEFAULT '{}',
|
||
|
|
ADD COLUMN IF NOT EXISTS options jsonb NOT NULL DEFAULT '{}'::jsonb;
|
||
|
|
-- Best-effort backfill from plugin_config (the source of truth).
|
||
|
|
UPDATE public.request_integrations SET
|
||
|
|
kind = COALESCE(plugin_config->>'service_kind', ''),
|
||
|
|
root_folder = COALESCE(plugin_config->>'root_folder', ''),
|
||
|
|
quality_profile_id = NULLIF(plugin_config->>'quality_profile_id','')::integer,
|
||
|
|
is_4k = COALESCE((plugin_config->>'is_4k')::boolean, false),
|
||
|
|
is_default = COALESCE((plugin_config->>'is_default')::boolean, false),
|
||
|
|
is_default_4k = COALESCE((plugin_config->>'is_default_4k')::boolean, false),
|
||
|
|
anime_enabled = COALESCE((plugin_config->>'anime_enabled')::boolean, false),
|
||
|
|
anime_root_folder = COALESCE(plugin_config->>'anime_root_folder', '');
|
||
|
|
-- +goose StatementEnd
|