seed_combined.sql

-- 数据库初始化脚本 (包含 Phase 1 和 Phase 2A 代码生成器表)
CREATE DATABASE IF NOT EXISTS `kangmaiwei` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `kangmaiwei`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 1. 账户主体类表
-- ----------------------------
DROP TABLE IF EXISTS `dzb_sys_user`;
CREATE TABLE `dzb_sys_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL COMMENT '登录账号',
  `password` varchar(128) NOT NULL DEFAULT '' COMMENT '密码(bcrypt)',
  `nickname` varchar(64) NOT NULL COMMENT '用户昵称',
  `avatar` varchar(255) DEFAULT '' COMMENT '头像地址',
  `email` varchar(128) DEFAULT '' COMMENT '用户邮箱',
  `phone` varchar(32) DEFAULT '' COMMENT '手机号码',
  `is_superadmin` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为全局超级管理员(1是 0否)',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态(1正常 0停用)',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted_at` datetime DEFAULT NULL COMMENT '删除时间(软删除)',
  `created_by` bigint unsigned DEFAULT '0' COMMENT '创建者',
  `updated_by` bigint unsigned DEFAULT '0' COMMENT '更新者',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_username_deleted_at` (`username`, `deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户信息主表';

DROP TABLE IF EXISTS `dzb_sys_user_social`;
CREATE TABLE `dzb_sys_user_social` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL COMMENT '系统用户ID',
  `platform` varchar(32) NOT NULL COMMENT '三方平台(wechat/dingtalk/github)',
  `openid` varchar(128) NOT NULL COMMENT '平台唯一标识',
  `unionid` varchar(128) DEFAULT '' COMMENT '平台开放标识',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '绑定时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_platform_openid` (`platform`, `openid`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户社交登录关联表';

-- ----------------------------
-- 2. 组织架构类表
-- ----------------------------
DROP TABLE IF EXISTS `dzb_sys_org`;
CREATE TABLE `dzb_sys_org` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL COMMENT '组织名称(公司/集团)',
  `code` varchar(64) NOT NULL COMMENT '组织编码',
  `logo` varchar(255) DEFAULT '' COMMENT 'Logo',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态(1正常 0停用)',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='组织机构表';

DROP TABLE IF EXISTS `dzb_sys_dept`;
CREATE TABLE `dzb_sys_dept` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `org_id` bigint unsigned NOT NULL COMMENT '所属组织',
  `parent_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '父部门ID',
  `name` varchar(64) NOT NULL COMMENT '部门名称',
  `sort` int NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_org_parent` (`org_id`, `parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部门管理表';

DROP TABLE IF EXISTS `dzb_sys_post`;
CREATE TABLE `dzb_sys_post` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `org_id` bigint unsigned NOT NULL COMMENT '所属组织',
  `code` varchar(64) NOT NULL COMMENT '岗位编码',
  `name` varchar(64) NOT NULL COMMENT '岗位名称',
  `sort` int NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_org_code` (`org_id`, `code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='岗位信息表';

-- ----------------------------
-- 3. 权限与身份架构表
-- ----------------------------
DROP TABLE IF EXISTS `dzb_sys_role`;
CREATE TABLE `dzb_sys_role` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `org_id` bigint unsigned NOT NULL COMMENT '所属组织(值为0表示全局系统角色)',
  `name` varchar(64) NOT NULL COMMENT '角色名称',
  `code` varchar(64) NOT NULL COMMENT '角色编码',
  `data_scope` tinyint NOT NULL DEFAULT '1' COMMENT '数据权限(1全部数据 2本司数据 3本部门 4下级部门 5本人 6自定义)',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态(1正常 0停用)',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_org_code` (`org_id`, `code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色信息表';

DROP TABLE IF EXISTS `dzb_sys_user_identity`;
CREATE TABLE `dzb_sys_user_identity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL COMMENT '关联系统用户表',
  `org_id` bigint unsigned NOT NULL COMMENT '所属组织',
  `dept_id` bigint unsigned NOT NULL COMMENT '所属部门',
  `role_id` bigint unsigned NOT NULL COMMENT '持有角色',
  `post_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '岗位ID(可选)',
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为默认身份登录',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态(1正常 0禁止登录此身份)',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_u_o_d_r` (`user_id`, `org_id`, `dept_id`, `role_id`),
  KEY `idx_user_org` (`user_id`, `org_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='🔥多组织多角色身份映射表';

DROP TABLE IF EXISTS `dzb_sys_menu`;
CREATE TABLE `dzb_sys_menu` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '父菜单ID',
  `type` char(1) NOT NULL DEFAULT 'M' COMMENT '类型(M目录 C菜单 F按钮)',
  `title` varchar(64) NOT NULL COMMENT '菜单标题',
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '组件名称(前端动态路由)',
  `path` varchar(200) DEFAULT '' COMMENT '路由路径',
  `component` varchar(255) DEFAULT '' COMMENT '组件路径',
  `perms` varchar(100) DEFAULT '' COMMENT '权限标识(后端Casbin及前端v-permission匹配用)',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `sort` int NOT NULL DEFAULT '0' COMMENT '菜单顺序',
  `is_hidden` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否隐藏(1是 0否)',
  `is_cached` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否缓存(1是 0否)',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` bigint unsigned DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_parent_sort` (`parent_id`, `sort`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='全局菜单权限控制表(不加org)';

DROP TABLE IF EXISTS `dzb_sys_role_menu`;
CREATE TABLE `dzb_sys_role_menu` (
  `role_id` bigint unsigned NOT NULL COMMENT '角色ID',
  `menu_id` bigint unsigned NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`, `menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色与菜单关联表';

DROP TABLE IF EXISTS `dzb_sys_role_dept`;
CREATE TABLE `dzb_sys_role_dept` (
  `role_id` bigint unsigned NOT NULL COMMENT '角色ID',
  `dept_id` bigint unsigned NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`, `dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色自定义数据权限关联表';

-- ----------------------------
-- 4. 字典配置等表
-- ----------------------------
DROP TABLE IF EXISTS `dzb_sys_dict_type`;
CREATE TABLE `dzb_sys_dict_type` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '字典名称',
  `type` varchar(100) NOT NULL COMMENT '字典类型',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` bigint unsigned DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='字典类型表';

DROP TABLE IF EXISTS `dzb_sys_dict_data`;
CREATE TABLE `dzb_sys_dict_data` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sort` int NOT NULL DEFAULT '0' COMMENT '字典排序',
  `label` varchar(100) NOT NULL COMMENT '字典标签',
  `value` varchar(100) NOT NULL COMMENT '字典键值',
  `type_id` bigint unsigned NOT NULL COMMENT '字典类型ID',
  `list_class` varchar(100) DEFAULT '' COMMENT '表格回显样式(如success/warning)',
  `css_class` varchar(100) DEFAULT '' COMMENT '样式属性(其他样式)',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` bigint unsigned DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_type_sort` (`type_id`, `sort`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='字典数据表';

DROP TABLE IF EXISTS `dzb_sys_config`;
CREATE TABLE `dzb_sys_config` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '配置名称',
  `key` varchar(100) NOT NULL COMMENT '配置键名',
  `value` text NOT NULL COMMENT '配置键值',
  `type` tinyint NOT NULL DEFAULT '1' COMMENT '系统内置(1是 0否)',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` bigint unsigned DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统全局配置表';

DROP TABLE IF EXISTS `dzb_sys_oper_log`;
CREATE TABLE `dzb_sys_oper_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL COMMENT '操作人ID',
  `identity_id` bigint unsigned NOT NULL COMMENT '操作人身份ID',
  `module` varchar(64) NOT NULL DEFAULT '' COMMENT '操作模块',
  `title` varchar(128) NOT NULL DEFAULT '' COMMENT '业务标题/接口说明',
  `action` varchar(32) NOT NULL DEFAULT '' COMMENT '操作类型(POST/PUT/DELETE)',
  `method` varchar(128) NOT NULL DEFAULT '' COMMENT '请求方法名/路径',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '请求URL',
  `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '请求IP',
  `location` varchar(255) NOT NULL DEFAULT '' COMMENT 'IP归属地',
  `param` text COMMENT '请求参数',
  `result` text COMMENT '返回结果',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '操作状态(1成功 0异常)',
  `error_msg` text COMMENT '错误信息',
  `cost_time` bigint NOT NULL DEFAULT '0' COMMENT '消耗时间(毫秒)',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_user_identity` (`user_id`, `identity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='操作日志表';

DROP TABLE IF EXISTS `dzb_sys_login_log`;
CREATE TABLE `dzb_sys_login_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL COMMENT '登录账号',
  `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '登录IP',
  `location` varchar(255) NOT NULL DEFAULT '' COMMENT '登录地点',
  `browser` varchar(128) NOT NULL DEFAULT '' COMMENT '浏览器',
  `os` varchar(128) NOT NULL DEFAULT '' COMMENT '操作系统',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '登录状态(1成功 0失败)',
  `msg` varchar(255) NOT NULL DEFAULT '' COMMENT '提示信息',
  `login_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '登录时间',
  PRIMARY KEY (`id`),
  KEY `idx_login_at` (`login_at`),
  KEY `idx_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='登录日志表';

-- ----------------------------
-- 5. 代码生成器相关表 (Phase 2A)
-- ----------------------------
DROP TABLE IF EXISTS `dzb_gen_table`;
CREATE TABLE `dzb_gen_table` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_name` varchar(200) NOT NULL DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(500) NOT NULL DEFAULT '' COMMENT '表描述',
  `class_name` varchar(100) NOT NULL DEFAULT '' COMMENT '实体类名称',
  `module_name` varchar(30) NOT NULL DEFAULT '' COMMENT '生成模块名',
  `package_name` varchar(100) NOT NULL DEFAULT '' COMMENT '生成包路径',
  `business_name` varchar(30) NOT NULL DEFAULT '' COMMENT '生成业务名',
  `function_name` varchar(50) NOT NULL DEFAULT '' COMMENT '生成功能名',
  `function_author` varchar(50) NOT NULL DEFAULT '' COMMENT '生成功能作者',
  `gen_type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '生成代码方式（1zip压缩包 2自定义路径）',
  `options` varchar(1000) DEFAULT '' COMMENT '其它生成选项',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` bigint unsigned DEFAULT '0' COMMENT '创建者',
  `updated_by` bigint unsigned DEFAULT '0' COMMENT '更新者',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_table_name` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代码生成业务表';

DROP TABLE IF EXISTS `dzb_gen_table_column`;
CREATE TABLE `dzb_gen_table_column` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` bigint unsigned NOT NULL COMMENT '归属表编号',
  `column_name` varchar(200) NOT NULL COMMENT '列名称',
  `column_comment` varchar(500) NOT NULL COMMENT '列描述',
  `column_type` varchar(100) NOT NULL COMMENT '列类型',
  `go_type` varchar(500) NOT NULL COMMENT 'Go类型',
  `go_field` varchar(200) NOT NULL COMMENT 'Go字段名',
  `is_pk` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否主键（1是）',
  `is_increment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否自增（1是）',
  `is_required` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否必填（1是）',
  `is_insert` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否为插入字段（1是）',
  `is_edit` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否编辑字段（1是）',
  `is_list` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否列表字段（1是）',
  `is_query` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否查询字段（1是）',
  `query_type` varchar(200) NOT NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
  `html_type` varchar(200) NOT NULL DEFAULT 'input' COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
  `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型',
  `sort` int NOT NULL DEFAULT '0' COMMENT '排序',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` bigint unsigned DEFAULT '0' COMMENT '创建者',
  `updated_by` bigint unsigned DEFAULT '0' COMMENT '更新者',
  PRIMARY KEY (`id`),
  KEY `idx_table_id` (`table_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代码生成业务表字段';

-- ----------------------------
-- 6. 初始化极简测试数据 (Data Seeding)
-- ----------------------------
BEGIN;

-- 插入超级管理员账户: admin / 123456
INSERT INTO `dzb_sys_user` (`id`, `username`, `password`, `nickname`, `is_superadmin`) 
VALUES (1, 'admin', '$2a$12$Z0E0.9zEq/S0rM8yC.g/BOnR40q6A20L19kL6/jK2oE5WqX9nJ1pW', '超级管理员', 1);

-- 默认根组织
INSERT INTO `dzb_sys_org` (`id`, `name`, `code`) VALUES (1, '总部集团', 'ROOT_ORG');

-- 默认根部门
INSERT INTO `dzb_sys_dept` (`id`, `org_id`, `parent_id`, `name`) VALUES (1, 1, 0, '总公司/董事会');

-- 默认超级管理员角色
INSERT INTO `dzb_sys_role` (`id`, `org_id`, `name`, `code`, `data_scope`) VALUES (1, 1, '超级管理员', 'superadmin', 1);

-- 赋予 admin 用户默认身份
INSERT INTO `dzb_sys_user_identity` (`id`, `user_id`, `org_id`, `dept_id`, `role_id`, `is_default`) VALUES (1, 1, 1, 1, 1, 1);

-- 创建一些系统顶层菜单
INSERT INTO `dzb_sys_menu` (`id`, `parent_id`, `type`, `title`, `name`, `path`, `component`, `perms`, `icon`, `sort`) VALUES
(1, 0, 'M', '系统管理', 'manage', '/manage', 'layout.base', '', 'carbon:settings', 1),
(2, 1, 'C', '用户管理', 'manage_user', '/manage/user', 'view.manage_user', 'system:user:query', 'ic:round-manage-accounts', 1),
(3, 1, 'C', '角色管理', 'manage_role', '/manage/role', 'view.manage_role', 'system:role:query', 'carbon:user-role', 2),
(4, 1, 'C', '菜单管理', 'manage_menu', '/manage/menu', 'view.manage_menu', 'system:menu:query', 'carbon:menu', 3);

-- 分配角色菜单
INSERT INTO `dzb_sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1), (1, 2), (1, 3);

-- 初始化男女字典
INSERT INTO `dzb_sys_dict_type` (`id`, `name`, `type`, `remark`) VALUES (1, '用户性别', 'dzb_sys_user_sex', '用户性别列表');
INSERT INTO `dzb_sys_dict_data` (`id`, `sort`, `label`, `value`, `type_id`, `list_class`, `css_class`) VALUES 
(1, 1, '男', '1', 1, '', ''), 
(2, 2, '女', '2', 1, '', ''), 
(3, 3, '未知', '0', 1, '', '');

COMMIT;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 1;