-- Notun moderator table. phpMyAdmin > Import e eta chalan (migration lagbe na).
-- Purono `admin` ar business table e kono change nai.
CREATE TABLE IF NOT EXISTS `raj_mod` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL,
  `username` VARCHAR(60) NOT NULL,
  `password` VARCHAR(255) NOT NULL,            -- bcrypt hash
  `status` TINYINT(1) NOT NULL DEFAULT 1,      -- 1 = active, 0 = blocked
  `permissions` LONGTEXT NULL,                 -- JSON: ["users.view","withdraw.manage",...]
  `api_token` CHAR(64) NULL,                   -- sha256 of app token
  `last_login_at` TIMESTAMP NULL DEFAULT NULL,
  `last_login_ip` VARCHAR(45) NULL,
  `created_by` VARCHAR(60) NULL,
  `created_at` TIMESTAMP NULL DEFAULT NULL,
  `updated_at` TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `raj_mod_username_unique` (`username`),
  KEY `raj_mod_api_token_index` (`api_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
