mirror of
https://github.com/navidrome/navidrome.git
synced 2026-03-04 06:35:52 +00: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
|