004 - owner_users (mpc-owner auth)

• Tanggal: 2026-08-08
• DB: ksrdb
• Ringkas: Tabel akun login untuk mpc-owner; hanya role Owner yang diterima aplikasi.

ALTER (jalankan di DB server)

CREATE TABLE IF NOT EXISTS owner_users (
  id            TEXT PRIMARY KEY,
  email         TEXT NOT NULL UNIQUE,
  password_hash TEXT NOT NULL,
  role          TEXT NOT NULL,
  name          TEXT,
  created_at    TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at    TIMESTAMP(3) NOT NULL
);

CREATE UNIQUE INDEX IF NOT EXISTS owner_users_email_key ON owner_users (email);

Atau dari app:

cd mpc-owner && npx prisma db push
# lalu seed:
npm run seed:owner

Rollback

DROP TABLE IF EXISTS owner_users;

Catatan

• ksr-sync tidak membaca/menulis tabel ini (schema mirror saja).
• Seed default: owner.ksr@mail.com / role Owner.