20220915102300_add_user_table.sql 281 B

123456789101112
  1. -- +goose Up
  2. CREATE TABLE "user"
  3. (
  4. id SERIAL PRIMARY KEY,
  5. username TEXT NOT NULL UNIQUE,
  6. password 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 "user";