mirror of
https://github.com/navidrome/navidrome.git
synced 2026-10-12 04:17:16 +02:00
9 lines
302 B
SQL
9 lines
302 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
ALTER TABLE playqueue ADD COLUMN position_int integer;
|
|
UPDATE playqueue SET position_int = CAST(position as INTEGER) ;
|
|
ALTER TABLE playqueue DROP COLUMN position;
|
|
ALTER TABLE playqueue RENAME COLUMN position_int TO position;
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|