32 lines
1.4 KiB
SQL
32 lines
1.4 KiB
SQL
-- AIOps 数据库初始化脚本
|
|
-- 创建数据库
|
|
CREATE DATABASE IF NOT EXISTS ezops CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
|
|
USE ezops;
|
|
|
|
-- 创建初始管理员用户
|
|
-- 密码: admin123 (bcrypt hash)
|
|
INSERT INTO users (username, password, email, real_name, phone, status, is_admin, created_at, updated_at) VALUES
|
|
('admin', '$2a$10$N9qo8uLOickgx2ZMRZoMy.MqrqQzBZN0UfGNEsKYGsGqNQJx3wDxG', 'admin@ezops.local', '系统管理员', '13800138000', 'active', true, NOW(), NOW())
|
|
ON DUPLICATE KEY UPDATE updated_at = NOW();
|
|
|
|
-- 创建默认角色
|
|
INSERT INTO roles (name, description, created_at, updated_at) VALUES
|
|
('超级管理员', '拥有所有权限', NOW(), NOW()),
|
|
('运维工程师', '运维操作权限', NOW(), NOW()),
|
|
('开发人员', '开发相关权限', NOW(), NOW()),
|
|
('只读用户', '只读查看权限', NOW(), NOW())
|
|
ON DUPLICATE KEY UPDATE updated_at = NOW();
|
|
|
|
-- 创建默认权限
|
|
INSERT INTO permissions (name, resource, action, created_at, updated_at) VALUES
|
|
('用户管理', 'user', 'manage', NOW(), NOW()),
|
|
('服务器管理', 'server', 'manage', NOW(), NOW()),
|
|
('K8s管理', 'k8s', 'manage', NOW(), NOW()),
|
|
('监控告警', 'alert', 'manage', NOW(), NOW()),
|
|
('应用发布', 'pipeline', 'manage', NOW(), NOW()),
|
|
('自动化运维', 'automation', 'manage', NOW(), NOW()),
|
|
('审批流程', 'approval', 'manage', NOW(), NOW()),
|
|
('系统设置', 'system', 'manage', NOW(), NOW())
|
|
ON DUPLICATE KEY UPDATE updated_at = NOW();
|