Files
hspguard/migrations/00006_add_user_creator.sql

13 lines
255 B
SQL

-- +goose Up
-- +goose StatementBegin
ALTER TABLE users
ADD COLUMN created_by UUID REFERENCES users (id) ON DELETE SET NULL;
-- +goose StatementEnd
-- +goose Down
-- +goose StatementBegin
ALTER TABLE users
DROP COLUMN created_by;
-- +goose StatementEnd