shomei-migrations-0.2.0.0: migrations/shomei/0003-shomei-password-credentials.sql

SET LOCAL search_path = pg_catalog, pg_temp;

CREATE TABLE IF NOT EXISTS shomei.shomei_password_credentials (
  credential_id uuid PRIMARY KEY,
  user_id       uuid NOT NULL REFERENCES shomei.shomei_users(user_id),
  email         text NOT NULL UNIQUE,
  password_hash text NOT NULL,
  created_at    timestamptz NOT NULL,
  updated_at    timestamptz NOT NULL
);