20 lines
870 B
SQL
20 lines
870 B
SQL
-- 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);
|