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

lhtzbj12 / sdrms

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
sdrms.sql 15.04 KB
一键复制 编辑 原始数据 按行查看 历史
lhtzbj12 提交于 2019-05-11 22:15 . 新增数据初始化功能
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228
/*

 Navicat Premium Data Transfer



 Source Server         : local

 Source Server Type    : MySQL

 Source Server Version : 50726

 Source Host           : localhost:3306

 Source Schema         : sdrms



 Target Server Type    : MySQL

 Target Server Version : 50726

 File Encoding         : 65001



 Date: 11/05/2019 22:04:54

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



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

-- Table structure for rms_backend_user

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

DROP TABLE IF EXISTS `rms_backend_user`;

CREATE TABLE `rms_backend_user`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `user_pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `is_super` tinyint(1) NOT NULL DEFAULT 0,

  `status` int(11) NOT NULL DEFAULT 0,

  `mobile` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `email` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `avatar` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of rms_backend_user

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

INSERT INTO `rms_backend_user` VALUES (1, 'lihaitao', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 0, 1, '18612348765', 'lhtzbj18@126.com', '/static/upload/1.jpg');

INSERT INTO `rms_backend_user` VALUES (3, '张三', 'zhangsan', 'e10adc3949ba59abbe56e057f20f883e', 0, 1, '', '', '');

INSERT INTO `rms_backend_user` VALUES (5, '李四', 'lisi', 'e10adc3949ba59abbe56e057f20f883e', 0, 0, '', '', '');



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

-- Table structure for rms_backend_user_rms_roles

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

DROP TABLE IF EXISTS `rms_backend_user_rms_roles`;

CREATE TABLE `rms_backend_user_rms_roles`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `rms_backend_user_id` int(11) NOT NULL,

  `rms_role_id` int(11) NOT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Table structure for rms_course

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

DROP TABLE IF EXISTS `rms_course`;

CREATE TABLE `rms_course`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `short_name` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `price` double NOT NULL DEFAULT 0,

  `real_price` double NOT NULL DEFAULT 0,

  `img` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `start_time` datetime(0) NOT NULL,

  `end_time` datetime(0) NOT NULL,

  `seq` int(11) NOT NULL DEFAULT 0,

  `creator_id` int(11) NOT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of rms_course

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

INSERT INTO `rms_course` VALUES (1, '2020考研政治精讲1', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (2, '2020考研政治精讲2', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (3, '2020考研政治精讲3', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (4, '2020考研政治精讲3', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (5, '2020考研政治精讲4', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (6, '2020考研政治精讲5', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (7, '2020考研政治精讲6', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (8, '2020考研政治精讲7', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (9, '2020考研政治精讲8', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (10, '2020考研政治精讲9', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (11, '2020考研政治精讲10', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (12, '2020考研政治精讲11', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (13, '2020考研政治精讲12', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (14, '2020考研政治精讲13', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (15, '2020考研政治精讲13', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (16, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (17, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (18, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (19, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (20, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (21, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (22, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (23, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (24, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (25, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (26, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (27, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (28, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (29, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (30, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (31, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (32, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (33, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (34, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);

INSERT INTO `rms_course` VALUES (35, '2020考研政治精讲15', '2020考研', 100, 0, '', '2019-04-30 16:00:00', '2019-05-30 16:00:00', 100, 1);



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

-- Table structure for rms_resource

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

DROP TABLE IF EXISTS `rms_resource`;

CREATE TABLE `rms_resource`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `rtype` int(11) NOT NULL DEFAULT 0,

  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `parent_id` int(11) NULL DEFAULT NULL,

  `seq` int(11) NOT NULL DEFAULT 0,

  `icon` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `url_for` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of rms_resource

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

INSERT INTO `rms_resource` VALUES (7, 1, '权限管理', 8, 100, 'fa fa-balance-scale', '');

INSERT INTO `rms_resource` VALUES (8, 0, '系统菜单', NULL, 200, '', '');

INSERT INTO `rms_resource` VALUES (9, 1, '资源管理', 7, 100, '', 'ResourceController.Index');

INSERT INTO `rms_resource` VALUES (12, 1, '角色管理', 7, 100, '', 'RoleController.Index');

INSERT INTO `rms_resource` VALUES (13, 1, '用户管理', 7, 100, '', 'BackendUserController.Index');

INSERT INTO `rms_resource` VALUES (14, 1, '系统管理', 8, 90, 'fa fa-gears', '');

INSERT INTO `rms_resource` VALUES (21, 0, '业务菜单', NULL, 170, '', '');

INSERT INTO `rms_resource` VALUES (22, 1, '课程资源', 21, 100, 'fa fa-book', 'CourseController.Index');

INSERT INTO `rms_resource` VALUES (23, 1, '日志管理(空)', 14, 100, '', '');

INSERT INTO `rms_resource` VALUES (25, 2, '编辑', 9, 100, 'fa fa-pencil', 'ResourceController.Edit');

INSERT INTO `rms_resource` VALUES (26, 2, '编辑', 13, 100, 'fa fa-pencil', 'BackendUserController.Edit');

INSERT INTO `rms_resource` VALUES (27, 2, '删除', 9, 100, 'fa fa-trash', 'ResourceController.Delete');

INSERT INTO `rms_resource` VALUES (29, 2, '删除', 13, 100, 'fa fa-trash', 'BackendUserController.Delete');

INSERT INTO `rms_resource` VALUES (30, 2, '编辑', 12, 100, 'fa fa-pencil', 'RoleController.Edit');

INSERT INTO `rms_resource` VALUES (31, 2, '删除', 12, 100, 'fa fa-trash', 'RoleController.Delete');

INSERT INTO `rms_resource` VALUES (32, 2, '分配资源', 12, 100, 'fa fa-th', 'RoleController.Allocate');

INSERT INTO `rms_resource` VALUES (35, 1, ' 首页', NULL, 100, 'fa fa-dashboard', 'HomeController.Index');

INSERT INTO `rms_resource` VALUES (36, 2, '编辑', 22, 100, '', 'CourseController.Edit');

INSERT INTO `rms_resource` VALUES (37, 2, '删除', 22, 100, '', 'CourseController.Delete');



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

-- Table structure for rms_role

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

DROP TABLE IF EXISTS `rms_role`;

CREATE TABLE `rms_role`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `seq` int(11) NOT NULL DEFAULT 0,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of rms_role

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

INSERT INTO `rms_role` VALUES (22, '超级管理员', 20);

INSERT INTO `rms_role` VALUES (24, '角色管理员', 10);

INSERT INTO `rms_role` VALUES (25, '课程资源管理员', 5);



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

-- Table structure for rms_role_backenduser_rel

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

DROP TABLE IF EXISTS `rms_role_backenduser_rel`;

CREATE TABLE `rms_role_backenduser_rel`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `role_id` int(11) NOT NULL,

  `backend_user_id` int(11) NOT NULL,

  `created` datetime(0) NOT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of rms_role_backenduser_rel

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

INSERT INTO `rms_role_backenduser_rel` VALUES (61, 22, 1, '2017-12-18 07:35:58');

INSERT INTO `rms_role_backenduser_rel` VALUES (66, 25, 3, '2017-12-19 06:40:34');



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

-- Table structure for rms_role_resource_rel

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

DROP TABLE IF EXISTS `rms_role_resource_rel`;

CREATE TABLE `rms_role_resource_rel`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `role_id` int(11) NOT NULL,

  `resource_id` int(11) NOT NULL,

  `created` datetime(0) NOT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 474 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of rms_role_resource_rel

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

INSERT INTO `rms_role_resource_rel` VALUES (448, 24, 8, '2017-12-19 06:40:16');

INSERT INTO `rms_role_resource_rel` VALUES (449, 24, 14, '2017-12-19 06:40:16');

INSERT INTO `rms_role_resource_rel` VALUES (450, 24, 23, '2017-12-19 06:40:16');

INSERT INTO `rms_role_resource_rel` VALUES (451, 25, 21, '2019-05-11 13:57:37');

INSERT INTO `rms_role_resource_rel` VALUES (452, 25, 22, '2019-05-11 13:57:37');

INSERT INTO `rms_role_resource_rel` VALUES (453, 25, 36, '2019-05-11 13:57:37');

INSERT INTO `rms_role_resource_rel` VALUES (454, 25, 37, '2019-05-11 13:57:37');

INSERT INTO `rms_role_resource_rel` VALUES (455, 22, 35, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (456, 22, 21, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (457, 22, 22, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (458, 22, 36, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (459, 22, 37, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (460, 22, 8, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (461, 22, 14, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (462, 22, 23, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (463, 22, 7, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (464, 22, 9, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (465, 22, 25, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (466, 22, 27, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (467, 22, 12, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (468, 22, 30, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (469, 22, 31, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (470, 22, 32, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (471, 22, 13, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (472, 22, 26, '2019-05-11 13:57:51');

INSERT INTO `rms_role_resource_rel` VALUES (473, 22, 29, '2019-05-11 13:57:51');



SET FOREIGN_KEY_CHECKS = 1;
Go
1
https://gitee.com/lhtzbj12/sdrms.git
git@gitee.com:lhtzbj12/sdrms.git
lhtzbj12
sdrms
sdrms
master
点此查找更多帮助

搜索帮助

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