20221114122000_add_thing_table.sql 279 B

12345678910111213
  1. -- +goose Up
  2. CREATE TABLE thing
  3. (
  4. id SERIAL PRIMARY KEY,
  5. title TEXT NOT NULL,
  6. description 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 thing;