-- ============================================================
-- SISKA - Skema Database
-- Import file ini lewat phpMyAdmin (cPanel) ke database yang
-- sudah Anda buat, lalu isi kredensialnya di backend/config.php
-- ============================================================

CREATE TABLE IF NOT EXISTS siska_users (
  id             INT AUTO_INCREMENT PRIMARY KEY,
  username       VARCHAR(50) NOT NULL UNIQUE,
  full_name      VARCHAR(150) NOT NULL,
  role           ENUM('admin','supervisor') NOT NULL DEFAULT 'supervisor',
  password_hash  VARCHAR(255) NOT NULL,
  last_login     DATETIME NULL,
  created_at     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS siska_data (
  id            INT AUTO_INCREMENT PRIMARY KEY,
  backend_id    VARCHAR(100) NULL,
  type          VARCHAR(50) NULL,
  payload       LONGTEXT NOT NULL,
  updated_by    VARCHAR(50) NULL,
  updated_at    DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_type (type),
  INDEX idx_backend_id (backend_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ------------------------------------------------------------
-- Akun awal Kepala Madrasah.
--   Username : admin
--   Password : siska2026
-- SEGERA GANTI KATA SANDI INI setelah login pertama kali
-- (lewat halaman Manajemen Pengguna).
-- ------------------------------------------------------------
INSERT INTO siska_users (username, full_name, role, password_hash)
VALUES (
  'admin',
  'Kepala Madrasah',
  'admin',
  '$2b$10$nKx47xuPOknql5YM6lh1Y.36mRZ.16geLiIUnFNmS4QZ3.GRifk4m'
)
ON DUPLICATE KEY UPDATE username = username;