mirror of
https://github.com/navidrome/navidrome.git
synced 2025-12-23 23:18:05 -05:00
10 lines
302 B
SQL
10 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
|