fa1d7ba2b4
* fix(playback): freeze v3 seek reanchor recipes * fix(playback): address v3 recipe review feedback * test(playback): isolate v3 fallback route fixture * fix(database): split v3 recipe constraint validation * fix(playback): preserve frozen seek recipe identity --------- Co-authored-by: Quick104 <31828688+Quick104@users.noreply.github.com>
13 lines
435 B
SQL
13 lines
435 B
SQL
-- +goose Up
|
|
ALTER TABLE playback_v3_attempts
|
|
ADD COLUMN frozen_recipe JSONB NOT NULL DEFAULT '{}'::jsonb;
|
|
|
|
ALTER TABLE playback_v3_attempts
|
|
ADD CONSTRAINT playback_v3_attempts_frozen_recipe_object
|
|
CHECK (jsonb_typeof(frozen_recipe) = 'object') NOT VALID;
|
|
|
|
-- +goose Down
|
|
ALTER TABLE playback_v3_attempts
|
|
DROP CONSTRAINT IF EXISTS playback_v3_attempts_frozen_recipe_object,
|
|
DROP COLUMN IF EXISTS frozen_recipe;
|