登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 0

Dong Jeremy/panzer

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
mydb.sql 10.33 KB
一键复制 编辑 原始数据 按行查看 历史
Dong Jeremy 提交于 2020-12-30 14:44 . update 2020-12-30-1
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
/*

 Navicat Premium Data Transfer



 Source Server         : localhost

 Source Server Type    : MySQL

 Source Server Version : 50731

 Source Host           : localhost:3306

 Source Schema         : mydb



 Target Server Type    : MySQL

 Target Server Version : 50731

 File Encoding         : 65001



 Date: 29/12/2020 13:04:06

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for sys_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_permission`;

CREATE TABLE `sys_permission`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `parent_id` bigint(20) NOT NULL,

  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `css` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `href` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `type` smallint(6) NOT NULL,

  `permission` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `sort` int(11) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_permission

-- ----------------------------

INSERT INTO `sys_permission` VALUES (1, 0, '版本管理', 'fa-cubes', '', 1, '', 1);

INSERT INTO `sys_permission` VALUES (2, 1, '版本变更', 'fa-tag', '/main/version-config', 1, '', 2);

INSERT INTO `sys_permission` VALUES (3, 1, '七牛存储', 'fa-database', '/main/apk-file-list', 1, '', 3);

INSERT INTO `sys_permission` VALUES (4, 1, '我的七牛', 'fa-shopping-bag', '/main/my-file-list', 1, '', 4);

INSERT INTO `sys_permission` VALUES (5, 0, '系统管理', 'fa-cogs', '', 1, '', 5);

INSERT INTO `sys_permission` VALUES (6, 5, '用户管理', 'fa-id-card-o', '/main/user-list', 1, '', 6);

INSERT INTO `sys_permission` VALUES (7, 5, '角色管理', 'fa-registered', '/main/role-info', 1, '', 7);

INSERT INTO `sys_permission` VALUES (8, 5, '菜单管理', 'fa-list', '/main/menu-info', 1, '', 8);

INSERT INTO `sys_permission` VALUES (9, 5, '在线用户', 'fa-address-book', '/main/user-online', 1, '', 9);

INSERT INTO `sys_permission` VALUES (10, 0, '业务管理', 'fa-eye', '', 1, '', 10);

INSERT INTO `sys_permission` VALUES (11, 10, '接口swagger', 'fa-file-pdf-o', '/api/swagger-ui.html', 1, '', 11);

INSERT INTO `sys_permission` VALUES (12, 10, '定时任务管理', 'fa-tasks', '/main/jobView', 1, '', 12);

INSERT INTO `sys_permission` VALUES (13, 10, '文件管理', 'fa-folder-open', '/main/fileView', 1, '', 13);

INSERT INTO `sys_permission` VALUES (21, 2, '新增', '', '', 2, 'sys:emp:add', 100);

INSERT INTO `sys_permission` VALUES (22, 2, '删除', '', '', 2, 'sys:emp:del', 100);

INSERT INTO `sys_permission` VALUES (23, 2, '查询', '', '', 2, 'sys:emp:query', 100);

INSERT INTO `sys_permission` VALUES (24, 2, '更新', '', '', 2, 'sys:emp:update', 100);

INSERT INTO `sys_permission` VALUES (25, 2, '导入', '', '', 2, 'sys:emp:import', 100);

INSERT INTO `sys_permission` VALUES (26, 2, '导出', '', '', 2, 'sys:emp:export', 100);

INSERT INTO `sys_permission` VALUES (27, 3, '新增', '', '', 2, 'sys:dept:add', 100);

INSERT INTO `sys_permission` VALUES (28, 3, '删除', '', '', 2, 'sys:dept:del', 100);

INSERT INTO `sys_permission` VALUES (29, 3, '更新', '', '', 2, 'sys:dept:update', 100);

INSERT INTO `sys_permission` VALUES (30, 3, '查询', '', '', 2, 'sys:dept:query', 100);



-- ----------------------------

-- Table structure for sys_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `createtime` timestamp(0) NOT NULL,

  `updatetime` timestamp(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_role

-- ----------------------------

INSERT INTO `sys_role` VALUES (1, 'ROLE_ADMIN', '管理员', '2017-05-01 13:25:39', '2017-10-05 21:59:18');

INSERT INTO `sys_role` VALUES (2, 'ROLE_USER', '', '2017-08-01 21:47:31', '2017-10-05 21:59:26');



-- ----------------------------

-- Table structure for sys_role_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_role_permission`;

CREATE TABLE `sys_role_permission`  (

  `role_id` bigint(20) NOT NULL,

  `permission_id` bigint(20) NOT NULL,

  PRIMARY KEY (`role_id`, `permission_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_role_permission

-- ----------------------------

INSERT INTO `sys_role_permission` VALUES (1, 1);

INSERT INTO `sys_role_permission` VALUES (1, 2);

INSERT INTO `sys_role_permission` VALUES (1, 3);

INSERT INTO `sys_role_permission` VALUES (1, 4);

INSERT INTO `sys_role_permission` VALUES (1, 5);

INSERT INTO `sys_role_permission` VALUES (1, 6);

INSERT INTO `sys_role_permission` VALUES (1, 7);

INSERT INTO `sys_role_permission` VALUES (1, 8);

INSERT INTO `sys_role_permission` VALUES (1, 9);

INSERT INTO `sys_role_permission` VALUES (1, 10);

INSERT INTO `sys_role_permission` VALUES (1, 11);

INSERT INTO `sys_role_permission` VALUES (1, 12);

INSERT INTO `sys_role_permission` VALUES (1, 21);

INSERT INTO `sys_role_permission` VALUES (1, 22);

INSERT INTO `sys_role_permission` VALUES (1, 23);

INSERT INTO `sys_role_permission` VALUES (1, 24);

INSERT INTO `sys_role_permission` VALUES (1, 25);

INSERT INTO `sys_role_permission` VALUES (1, 26);

INSERT INTO `sys_role_permission` VALUES (1, 27);

INSERT INTO `sys_role_permission` VALUES (1, 28);

INSERT INTO `sys_role_permission` VALUES (1, 29);

INSERT INTO `sys_role_permission` VALUES (1, 30);

INSERT INTO `sys_role_permission` VALUES (1, 31);

INSERT INTO `sys_role_permission` VALUES (1, 32);

INSERT INTO `sys_role_permission` VALUES (1, 33);

INSERT INTO `sys_role_permission` VALUES (1, 34);

INSERT INTO `sys_role_permission` VALUES (1, 35);

INSERT INTO `sys_role_permission` VALUES (1, 36);

INSERT INTO `sys_role_permission` VALUES (1, 37);

INSERT INTO `sys_role_permission` VALUES (1, 38);

INSERT INTO `sys_role_permission` VALUES (1, 39);

INSERT INTO `sys_role_permission` VALUES (1, 40);

INSERT INTO `sys_role_permission` VALUES (2, 1);

INSERT INTO `sys_role_permission` VALUES (2, 2);

INSERT INTO `sys_role_permission` VALUES (2, 3);

INSERT INTO `sys_role_permission` VALUES (2, 4);

INSERT INTO `sys_role_permission` VALUES (2, 6);

INSERT INTO `sys_role_permission` VALUES (2, 7);

INSERT INTO `sys_role_permission` VALUES (2, 8);

INSERT INTO `sys_role_permission` VALUES (2, 9);

INSERT INTO `sys_role_permission` VALUES (2, 10);

INSERT INTO `sys_role_permission` VALUES (2, 11);

INSERT INTO `sys_role_permission` VALUES (2, 12);

INSERT INTO `sys_role_permission` VALUES (2, 13);

INSERT INTO `sys_role_permission` VALUES (2, 14);

INSERT INTO `sys_role_permission` VALUES (2, 15);

INSERT INTO `sys_role_permission` VALUES (2, 16);

INSERT INTO `sys_role_permission` VALUES (2, 17);

INSERT INTO `sys_role_permission` VALUES (2, 18);

INSERT INTO `sys_role_permission` VALUES (2, 19);

INSERT INTO `sys_role_permission` VALUES (2, 20);

INSERT INTO `sys_role_permission` VALUES (2, 21);

INSERT INTO `sys_role_permission` VALUES (2, 22);

INSERT INTO `sys_role_permission` VALUES (2, 23);

INSERT INTO `sys_role_permission` VALUES (2, 24);

INSERT INTO `sys_role_permission` VALUES (2, 25);

INSERT INTO `sys_role_permission` VALUES (2, 30);

INSERT INTO `sys_role_permission` VALUES (2, 31);

INSERT INTO `sys_role_permission` VALUES (2, 34);

INSERT INTO `sys_role_permission` VALUES (2, 36);



-- ----------------------------

-- Table structure for sys_role_user

-- ----------------------------

DROP TABLE IF EXISTS `sys_role_user`;

CREATE TABLE `sys_role_user`  (

  `user_id` bigint(20) NOT NULL,

  `role_id` bigint(20) NOT NULL,

  PRIMARY KEY (`user_id`, `role_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_role_user

-- ----------------------------

INSERT INTO `sys_role_user` VALUES (1, 1);

INSERT INTO `sys_role_user` VALUES (2, 2);



-- ----------------------------

-- Table structure for sys_user

-- ----------------------------

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `username` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `password` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `head_img_url` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `telephone` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `birthday` date NULL DEFAULT NULL,

  `sex` smallint(6) NULL DEFAULT NULL,

  `status` smallint(6) NOT NULL DEFAULT 1,

  `create_time` timestamp(0) NOT NULL,

  `update_time` timestamp(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),

  `intro` varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sys_user

-- ----------------------------

INSERT INTO `sys_user` VALUES (1, 'admin', '$2a$10$J.gP5fKIjV0s0tgGZKWvB.BZb0z9K.3rIXK4hbPkt5ay2dP/NTWvO', '管理员', NULL, '13888888888', '', 'admin@zhiming.org', '1998-07-01', 2, 1, '2017-04-10 15:21:38', '2017-07-06 09:20:19', '');

INSERT INTO `sys_user` VALUES (2, 'user', '$2a$10$E5IUEJG9diQSmr7usp5qy.jSLvptTX6mQiKHzfOM.MJd6cGsAoA6m', '用户', NULL, '', '', '', NULL, 1, 1, '2017-08-01 21:47:18', '2017-08-01 21:47:18', NULL);



-- ----------------------------

-- Table structure for t_token

-- ----------------------------

DROP TABLE IF EXISTS `t_token`;

CREATE TABLE `t_token`  (

  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `val` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `expire_time` timestamp(0) NOT NULL,

  `create_time` timestamp(0) NOT NULL,

  `update_time` timestamp(0) NOT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;



SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/dongjeremy/panzer.git
git@gitee.com:dongjeremy/panzer.git
dongjeremy
panzer
panzer
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部