-- CAS 专用 MySQL 初始化（仅首次启动执行一次）
-- 库/用户由容器环境变量 MYSQL_DATABASE / MYSQL_USER / MYSQL_PASSWORD 创建，这里只建表与种子数据

CREATE DATABASE IF NOT EXISTS cas CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE cas;

CREATE TABLE IF NOT EXISTS sys_user (
  id       BIGINT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(64)  NOT NULL,
  password VARCHAR(100) NOT NULL,
  disabled TINYINT(1)   DEFAULT 0,
  expired  TINYINT(1)   DEFAULT 0,
  UNIQUE KEY uk_username (username)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 默认管理员：admin / admin123 （BCrypt，前缀 $2a$ 与 Spring Security 兼容）
INSERT INTO sys_user(username, password, disabled, expired) VALUES
('admin', '$2a$10$kRc0qMMC9NGbE.46fEWZvOlpcy.pjKef2ZA9yoFdKFfBw.nEJEUZO', 0, 0)
ON DUPLICATE KEY UPDATE password = VALUES(password);