数据库

常见问题

默认账号密码

默认后台账号密码: admin / 123456

内置密码生成策略

base64(sha256(sha256("用户密码"+"盐")+"盐")+"|"++"盐");

数据库模型

数据库模型

数据库结构

  1. CREATE TABLE `admin_auth`
  2. (
  3.     `id`          int(10) unsigned NOT NULL AUTO_INCREMENT,
  4.     `name`        varchar(100)     NOT NULL DEFAULT '' COMMENT '名称',
  5.     `description` varchar(255)     NOT NULL DEFAULT '' COMMENT '描述',
  6.     `create_time` timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  7.     `update_time` timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  8.     PRIMARY KEY (`id`) USING BTREE,
  9.     KEY `name` (`name`) USING BTREE
  10. ) ENGINE = InnoDB
  11.   DEFAULT CHARSET = utf8mb4 COMMENT ='权限';
  13. CREATE TABLE `admin_menu`
  14. (
  15.     `id`          int(10) unsigned NOT NULL AUTO_INCREMENT,
  16.     `parent_id`   int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单ID',
  17.     `name`        varchar(100)     NOT NULL DEFAULT '' COMMENT '名称',
  18.     `url`         varchar(255)     NOT NULL DEFAULT '' COMMENT '链接',
  19.     `icon`        varchar(30)      NOT NULL DEFAULT '' COMMENT 'icon',
  20.     `description` varchar(255)     NOT NULL DEFAULT '' COMMENT '描述',
  21.     `sort`        int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序值 越小越在前',
  22.     `create_time` timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  23.     `update_time` timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  24.     PRIMARY KEY (`id`) USING BTREE
  25. ) ENGINE = InnoDB
  26.   DEFAULT CHARSET = utf8mb4 COMMENT ='菜单';
  28. CREATE TABLE `admin_menu_relate`
  29. (
  30.     `id`            int(10) unsigned NOT NULL AUTO_INCREMENT,
  31.     `admin_auth_id` int(10) unsigned NOT NULL,
  32.     `admin_menu_id` int(10) unsigned NOT NULL,
  33.     `create_time`   timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  34.     `update_time`   timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  35.     PRIMARY KEY (`id`) USING BTREE,
  36.     UNIQUE KEY `unique` (`admin_auth_id`, `admin_menu_id`) USING BTREE
  37. ) ENGINE = InnoDB
  38.   DEFAULT CHARSET = utf8mb4 COMMENT ='菜单权限关联';
  40. CREATE TABLE `admin_request`
  41. (
  42.     `id`          int(10) unsigned NOT NULL AUTO_INCREMENT,
  43.     `type`        varchar(50)      NOT NULL DEFAULT 'default' COMMENT '请求类型',
  44.     `name`        varchar(100)     NOT NULL DEFAULT '' COMMENT '名称',
  45.     `action`      varchar(100)     NOT NULL DEFAULT '' COMMENT 'action',
  46.     `call`        varchar(100)     NOT NULL DEFAULT '' COMMENT '类型配置',
  47.     `create_time` timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  48.     `update_time` timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  49.     PRIMARY KEY (`id`) USING BTREE,
  50.     UNIQUE KEY `action` (`action`) USING BTREE
  51. ) ENGINE = InnoDB
  52.   DEFAULT CHARSET = utf8mb4 COMMENT ='请求';
  54. CREATE TABLE `admin_request_relate`
  55. (
  56.     `id`               int(10) unsigned NOT NULL AUTO_INCREMENT,
  57.     `admin_auth_id`    int(10) unsigned NOT NULL,
  58.     `admin_request_id` int(10) unsigned NOT NULL,
  59.     `create_time`      timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  60.     `update_time`      timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  61.     PRIMARY KEY (`id`) USING BTREE,
  62.     UNIQUE KEY `unique` (`admin_auth_id`, `admin_request_id`) USING BTREE
  63. ) ENGINE = InnoDB
  64.   DEFAULT CHARSET = utf8mb4 COMMENT ='请求权限关联';
  66. CREATE TABLE `admin_user`
  67. (
  68.     `id`              int(10) unsigned    NOT NULL AUTO_INCREMENT,
  69.     `username`        varchar(100)        NOT NULL DEFAULT '' COMMENT '用户名',
  70.     `password`        varchar(255)        NOT NULL DEFAULT '' COMMENT '密码',
  71.     `last_login_ip`   varchar(15)         NOT NULL DEFAULT '' COMMENT '最后登录IP',
  72.     `last_login_time` timestamp           NULL     DEFAULT NULL COMMENT '最后登录时间',
  73.     `status`          tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  74.     `description`     varchar(150)        NOT NULL DEFAULT '' COMMENT '描述',
  75.     `create_time`     timestamp           NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  76.     `update_time`     timestamp           NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  77.     PRIMARY KEY (`id`) USING BTREE,
  78.     UNIQUE KEY `username` (`username`) USING BTREE
  79. ) ENGINE = InnoDB
  80.   DEFAULT CHARSET = utf8mb4 COMMENT ='管理员用户';
  82. CREATE TABLE `admin_user_relate`
  83. (
  84.     `id`                  int(10) unsigned NOT NULL AUTO_INCREMENT,
  85.     `admin_user_group_id` int(10) unsigned NOT NULL,
  86.     `admin_user_id`       int(10) unsigned NOT NULL,
  87.     `create_time`         timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  88.     `update_time`         timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  89.     PRIMARY KEY (`id`) USING BTREE,
  90.     UNIQUE KEY `unique` (`admin_user_group_id`, `admin_user_id`) USING BTREE
  91. ) ENGINE = InnoDB
  92.   DEFAULT CHARSET = utf8mb4 COMMENT ='用户组关联';
  94. CREATE TABLE `admin_user_group`
  95. (
  96.     `id`          int(10) unsigned NOT NULL AUTO_INCREMENT,
  97.     `name`        varchar(100)     NOT NULL DEFAULT '' COMMENT '名称',
  98.     `description` varchar(255)     NOT NULL DEFAULT '' COMMENT '描述',
  99.     `create_time` timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  100.     `update_time` timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  101.     PRIMARY KEY (`id`) USING BTREE,
  102.     KEY `name` (`name`) USING BTREE
  103. ) ENGINE = InnoDB
  104.   DEFAULT CHARSET = utf8mb4 COMMENT ='用户组';
  106. CREATE TABLE `admin_user_group_relate`
  107. (
  108.     `id`                  int(10) unsigned NOT NULL AUTO_INCREMENT,
  109.     `admin_user_group_id` int(10) unsigned NOT NULL,
  110.     `admin_auth_id`       int(10) unsigned NOT NULL,
  111.     `create_time`         timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  112.     `update_time`         timestamp        NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  113.     PRIMARY KEY (`id`) USING BTREE,
  114.     UNIQUE KEY `unique` (`admin_user_group_id`, `admin_auth_id`) USING BTREE
  115. ) ENGINE = InnoDB
  116.   DEFAULT CHARSET = utf8mb4 COMMENT ='用户组权限关联';
  118. CREATE TABLE `admin_token`
  119. (
  120.     `id`            bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  121.     `token`         varchar(32)         NOT NULL DEFAULT '' COMMENT 'token',
  122.     `admin_user_id` int(10) unsigned    NOT NULL COMMENT '用户ID',
  123.     `expire_time`   timestamp           NULL     DEFAULT NULL COMMENT '过期时间',
  124.     `create_time`   timestamp           NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  125.     `update_time`   timestamp           NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  126.     PRIMARY KEY (`id`) USING BTREE,
  127.     UNIQUE KEY `token` (`token`) USING BTREE,
  128.     KEY `expire_time` (`expire_time`) USING BTREE
  129. ) ENGINE = InnoDB
  130.   DEFAULT CHARSET = utf8mb4 COMMENT ='登录token';
  132. INSERT INTO `admin_auth`(`id`, `name`)
  133. VALUES (1, '系统设置-用户管理'),
  134.        (2, '系统设置-权限管理');
  136. INSERT INTO `admin_menu`(`id`, `parent_id`, `name`, `url`, `icon`, `description`, `sort`)
  137. VALUES (1, 0, '系统设置', '', '', '', 1),
  138.        (10, 1, '用户管理', '', '', '', 1),
  139.        (11, 10, '用户', '/system/user', '', '', 1),
  140.        (12, 10, '用户组', '/system/userGroup', '', '', 2),
  141.        (20, 1, '权限管理', '', '', '', 2),
  142.        (21, 20, '请求', '/system/request', '', '', 1),
  143.        (22, 20, '菜单', '/system/menu', '', '', 2),
  144.        (23, 20, '权限', '/system/auth', '', '', 4);
  146. INSERT INTO `admin_menu_relate`(`admin_auth_id`, `admin_menu_id`)
  147. VALUES (1, 1),
  148.        (1, 10),
  149.        (1, 11),
  150.        (1, 12),
  151.        (2, 20),
  152.        (2, 21),
  153.        (2, 22),
  154.        (2, 23);
  156. INSERT INTO `admin_request`(`id`, `type`, `name`, `action`, `call`)
  157. VALUES (1, 'default', '登录', '/login', 'Baiy.Cadmin.System.Index.login'),
  158.        (2, 'default', '退出', '/logout', 'Baiy.Cadmin.System.Index.logout'),
  159.        (3, 'default', '初始数据加载', '/load', 'Baiy.Cadmin.System.Index.load'),
  160.        (4, 'default', '当前用户编辑', '/current/user/setting', 'Baiy.Cadmin.System.User.currentSetting'),
  161.        (10, 'default', '用户管理-用户-列表数据', '/system/user/lists', 'Baiy.Cadmin.System.User.lists'),
  162.        (11, 'default', '用户管理-用户-保存', '/system/user/save', 'Baiy.Cadmin.System.User.save'),
  163.        (12, 'default', '用户管理-用户-删除', '/system/user/remove', 'Baiy.Cadmin.System.User.remove'),
  164.        (20, 'default', '用户管理-用户组-列表数据', '/system/userGroup/lists', 'Baiy.Cadmin.System.UserGroup.lists'),
  165.        (21, 'default', '用户管理-用户组-保存', '/system/userGroup/save', 'Baiy.Cadmin.System.UserGroup.save'),
  166.        (22, 'default', '用户管理-用户组-删除', '/system/userGroup/remove', 'Baiy.Cadmin.System.UserGroup.remove'),
  167.        (23, 'default', '用户管理-用户组-获取用户分组信息', '/system/userGroup/getUser', 'Baiy.Cadmin.System.UserGroup.getUser'),
  168.        (24, 'default', '用户管理-用户组-用户分配', '/system/userGroup/assignUser', 'Baiy.Cadmin.System.UserGroup.assignUser'),
  169.        (25, 'default', '用户管理-用户组-移除用户分配', '/system/userGroup/removeUser', 'Baiy.Cadmin.System.UserGroup.removeUser'),
  170.        (30, 'default', '权限管理-请求-列表数据', '/system/request/lists', 'Baiy.Cadmin.System.Request.lists'),
  171.        (31, 'default', '权限管理-请求-保存', '/system/request/save', 'Baiy.Cadmin.System.Request.save'),
  172.        (32, 'default', '权限管理-请求-删除', '/system/request/remove', 'Baiy.Cadmin.System.Request.remove'),
  173.        (33, 'default', '权限管理-请求-类型映射', '/system/request/type', 'Baiy.Cadmin.System.Request.type'),
  174.        (40, 'default', '权限管理-菜单-列表数据', '/system/menu/lists', 'Baiy.Cadmin.System.Menu.lists'),
  175.        (41, 'default', '权限管理-菜单-排序', '/system/menu/sort', 'Baiy.Cadmin.System.Menu.sort'),
  176.        (42, 'default', '权限管理-菜单-保存', '/system/menu/save', 'Baiy.Cadmin.System.Menu.save'),
  177.        (43, 'default', '权限管理-菜单-删除', '/system/menu/remove', 'Baiy.Cadmin.System.Menu.remove'),
  178.        (60, 'default', '权限管理-权限-列表数据', '/system/auth/lists', 'Baiy.Cadmin.System.Auth.lists'),
  179.        (61, 'default', '权限管理-权限-保存', '/system/auth/save', 'Baiy.Cadmin.System.Auth.save'),
  180.        (62, 'default', '权限管理-权限-删除', '/system/auth/remove', 'Baiy.Cadmin.System.Auth.remove'),
  181.        (63, 'default', '权限管理-权限-获取请求分配信息', '/system/auth/getRequest', 'Baiy.Cadmin.System.Auth.getRequest'),
  182.        (64, 'default', '权限管理-权限-请求分配', '/system/auth/assignRequest', 'Baiy.Cadmin.System.Auth.assignRequest'),
  183.        (65, 'default', '权限管理-权限-移除请求分配', '/system/auth/removeRequest', 'Baiy.Cadmin.System.Auth.removeRequest'),
  184.        (70, 'default', '权限管理-权限-获取用户组分配信息', '/system/auth/getUserGroup', 'Baiy.Cadmin.System.Auth.getUserGroup'),
  185.        (71, 'default', '权限管理-权限-用户组分配', '/system/auth/assignUserGroup', 'Baiy.Cadmin.System.Auth.assignUserGroup'),
  186.        (72, 'default', '权限管理-权限-移除用户组分配', '/system/auth/removeUserGroup', 'Baiy.Cadmin.System.Auth.removeUserGroup'),
  187.        (73, 'default', '权限管理-权限-获取菜单分配信息', '/system/auth/getMenu', 'Baiy.Cadmin.System.Auth.getMenu'),
  188.        (74, 'default', '权限管理-权限-分配菜单', '/system/auth/assignMenu', 'Baiy.Cadmin.System.Auth.assignMenu');
  190. INSERT INTO `admin_request_relate`(`admin_auth_id`, `admin_request_id`)
  191. VALUES (1, 10),
  192.        (1, 11),
  193.        (1, 12),
  194.        (1, 20),
  195.        (1, 21),
  196.        (1, 22),
  197.        (1, 23),
  198.        (1, 24),
  199.        (1, 25),
  200.        (2, 30),
  201.        (2, 31),
  202.        (2, 32),
  203.        (2, 33),
  204.        (2, 40),
  205.        (2, 41),
  206.        (2, 42),
  207.        (2, 43),
  208.        (2, 60),
  209.        (2, 61),
  210.        (2, 62),
  211.        (2, 63),
  212.        (2, 64),
  213.        (2, 65),
  214.        (2, 70),
  215.        (2, 71),
  216.        (2, 72),
  217.        (2, 73),
  218.        (2, 74);
  220. INSERT INTO `admin_user`(`id`, `username`, `password`)
  221. VALUES (1, 'admin',
  222.         'ZjU3NzE5ZWU3OWFlYjQ1MzMyNzI1NTI5NDNlNzZiZjk3ZGVlNWMwZDRkMTU1ZDRiOThlNWUwMjRmOGZlMmZmZnwxanVlYXEyOQ==');
  224. INSERT INTO `admin_user_group`(`id`, `name`)
  225. VALUES (1, '超级管理员');
  227. INSERT INTO `admin_user_relate`(`admin_user_group_id`, `admin_user_id`)
  228. VALUES (1, 1);
  230. INSERT INTO `admin_user_group_relate`(`admin_auth_id`, `admin_user_group_id`)
  231. VALUES (1, 1),
  232.        (2, 1);