homethings/migrations/20221114120500_add_place_table.sql

-- +goose Up
CREATE TABLE place
(
    id         SERIAL PRIMARY KEY,
    parent_id  INT,
    title      TEXT      NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);

-- +goose Down
DROP TABLE place;