10 lines
203 B
SQL
10 lines
203 B
SQL
-- +goose Up
|
|
ALTER TABLE bases
|
|
ADD COLUMN sortkey INT NULL AFTER position,
|
|
ADD KEY idx_bases_sortkey (sortkey);
|
|
|
|
-- +goose Down
|
|
ALTER TABLE bases
|
|
DROP KEY idx_bases_sortkey,
|
|
DROP COLUMN sortkey;
|