31 lines
1.2 KiB
SQL
31 lines
1.2 KiB
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
ALTER TABLE media_files
|
|
ADD COLUMN IF NOT EXISTS intro_markers_provider text,
|
|
ADD COLUMN IF NOT EXISTS credits_markers_source text,
|
|
ADD COLUMN IF NOT EXISTS credits_markers_provider text,
|
|
ADD COLUMN IF NOT EXISTS credits_markers_confidence double precision,
|
|
ADD COLUMN IF NOT EXISTS credits_markers_algorithm text,
|
|
ADD COLUMN IF NOT EXISTS credits_markers_detected_at timestamp with time zone;
|
|
|
|
INSERT INTO server_settings (key, value) VALUES ('markers.mode', 'local')
|
|
ON CONFLICT (key) DO NOTHING;
|
|
|
|
INSERT INTO server_settings (key, value) VALUES ('markers.lazy_playback', 'false')
|
|
ON CONFLICT (key) DO NOTHING;
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
DELETE FROM server_settings
|
|
WHERE key IN ('markers.mode', 'markers.lazy_playback');
|
|
|
|
ALTER TABLE media_files
|
|
DROP COLUMN IF EXISTS credits_markers_detected_at,
|
|
DROP COLUMN IF EXISTS credits_markers_algorithm,
|
|
DROP COLUMN IF EXISTS credits_markers_confidence,
|
|
DROP COLUMN IF EXISTS credits_markers_provider,
|
|
DROP COLUMN IF EXISTS credits_markers_source,
|
|
DROP COLUMN IF EXISTS intro_markers_provider;
|
|
-- +goose StatementEnd
|