10 lines
199 B
SQL
10 lines
199 B
SQL
-- +goose Up
|
|
ALTER TABLE lands
|
|
ADD COLUMN sortkey INT NULL AFTER name,
|
|
ADD KEY idx_lands_sortkey (sortkey);
|
|
|
|
-- +goose Down
|
|
ALTER TABLE lands
|
|
DROP KEY idx_lands_sortkey,
|
|
DROP COLUMN sortkey;
|