Files
silo-server/migrations/sql/111_watch_provider_sync_hourly.sql

18 lines
435 B
SQL

-- +goose Up
-- +goose StatementBegin
UPDATE public.task_triggers
SET interval = 60 * 60 * 1000
WHERE task_key = 'sync_watch_providers'
AND type = 'interval'
AND interval = 15 * 60 * 1000;
-- +goose StatementEnd
-- +goose Down
-- +goose StatementBegin
UPDATE public.task_triggers
SET interval = 15 * 60 * 1000
WHERE task_key = 'sync_watch_providers'
AND type = 'interval'
AND interval = 60 * 60 * 1000;
-- +goose StatementEnd