dilap54
c4e71fca93
All checks were successful
Build and push image / deploy (push) Successful in 2m36s
15 lines
296 B
SQL
15 lines
296 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
ALTER TABLE goods
|
|
ADD COLUMN good_id INTEGER NOT NULL DEFAULT 0;
|
|
|
|
UPDATE goods
|
|
SET good_id = split_part(goodlink, '/', 4)::integer;
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
ALTER TABLE goods
|
|
DROP COLUMN good_id;
|
|
-- +goose StatementEnd
|