20221114120500_add_place_table.sql 258 B

123456789101112
  1. -- +goose Up
  2. CREATE TABLE place
  3. (
  4. id SERIAL PRIMARY KEY,
  5. parent_id INT,
  6. title TEXT NOT NULL,
  7. created_at TIMESTAMP NOT NULL DEFAULT NOW(),
  8. updated_at TIMESTAMP NOT NULL DEFAULT NOW()
  9. );
  10. -- +goose Down
  11. DROP TABLE place;