40a9de7f26
* feat(watchsync): add plugin-backed providers * fix(watchsync): address plugin review findings * fix(watchsync): harden plugin provider failures * feat(watchsync): complete plugin provider contract * fix(watchsync): address provider review feedback * fix(watchsync): keep device state host-private * fix(watchsync): build reconciliation index concurrently * fix(watchsync): preserve empty device state updates * chore(deps): use released watch-sync SDK --------- Co-authored-by: Quick <31828688+Quick104@users.noreply.github.com>
17 lines
582 B
SQL
17 lines
582 B
SQL
-- +goose Up
|
|
ALTER TABLE watch_provider_connections
|
|
ADD COLUMN plugin_credentials text NOT NULL DEFAULT '';
|
|
|
|
ALTER TABLE watch_provider_scrobble_sessions
|
|
ADD COLUMN history_reconciled_at timestamptz;
|
|
|
|
-- +goose Down
|
|
-- Irreversible for plugin connections: TokenType, Scopes, and
|
|
-- SecretAttributes exist only in plugin_credentials, so rolling back may
|
|
-- require those providers to reconnect.
|
|
ALTER TABLE watch_provider_connections
|
|
DROP COLUMN IF EXISTS plugin_credentials;
|
|
|
|
ALTER TABLE watch_provider_scrobble_sessions
|
|
DROP COLUMN IF EXISTS history_reconciled_at;
|