12 lines
270 B
SQL
12 lines
270 B
SQL
-- +goose Up
|
|
ALTER TABLE opcs
|
|
ADD COLUMN note VARCHAR(255) NULL AFTER description,
|
|
ADD COLUMN sortkey INT NULL AFTER name,
|
|
ADD KEY idx_opcs_sortkey (sortkey);
|
|
|
|
-- +goose Down
|
|
ALTER TABLE opcs
|
|
DROP KEY idx_opcs_sortkey,
|
|
DROP COLUMN sortkey,
|
|
DROP COLUMN note;
|