master

分支 (1)

管理

管理

master

N-admin
/
n.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : n

Target Server Type    : MYSQL
Target Server Version : 50553
File Encoding         : 65001

Date: 2019-06-18 13:27:39
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for n_admin
-- ----------------------------
DROP TABLE IF EXISTS `n_admin`;
CREATE TABLE `n_admin` (
  `admin_id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'admin_id',
  `admin_name` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'admin名称',
  `admin_pwd` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'admin密码',
  `name` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `admin_role_id` int(10) DEFAULT NULL COMMENT '权限id',
  `login_time` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '上次登录时间',
  `login_ip` varchar(15) COLLATE utf8_bin DEFAULT NULL COMMENT '登录ip',
  `create_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `update_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `order` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `status` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of n_admin
-- ----------------------------
INSERT INTO `n_admin` VALUES ('1', 'admin', '28c8edde3d61a0411511d3b1866f0636', '开发者', '18021509783', '0', '2019年06月18日 01:21:19', '127.0.0.1', '1560755213', '1560835279', '50', '1');
INSERT INTO `n_admin` VALUES ('2', 'NEKGod', '12836706cbc544a6d6cc279359f82999', '1', '1', '8', '2019年06月18日 12:24:02', '127.0.0.1', '1560762629', '1560831842', '111', '1');
INSERT INTO `n_admin` VALUES ('3', 'NEK1', '28c8edde3d61a0411511d3b1866f0636', '1', '1', '10', '2019年06月18日 01:06:00', '127.0.0.1', '1560834346', '1560834360', '1', '1');

-- ----------------------------
-- Table structure for n_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_role`;
CREATE TABLE `n_admin_role` (
  `admin_role_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '权限id',
  `role_name` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '权限名称',
  `role_json` text COLLATE utf8_bin COMMENT '权限存储json',
  PRIMARY KEY (`admin_role_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of n_admin_role
-- ----------------------------
INSERT INTO `n_admin_role` VALUES ('8', '管理员', 0x7B226D656E7573223A7B224D656E75223A22322C31222C2241646D696E4C6F67223A2232392C31222C2253797374656D223A2234342C31222C2241646D696E223A2233392C3338222C2241646D696E526F6C65223A2234302C3338222C22566964656F223A2234362C3435227D2C226D656E75223A7B226D656E75616464223A2231222C226D656E75757064617465223A2231222C226D656E7564656C657465223A2231227D2C2261646D696E6C6F67223A7B2261646D696E6C6F67616464223A2231222C2261646D696E6C6F67757064617465223A2231222C2261646D696E6C6F6764656C657465223A2231227D2C2273797374656D223A7B2273797374656D616464223A2231222C2273797374656D757064617465223A2231222C2273797374656D64656C657465223A2231227D2C2261646D696E223A7B2261646D696E616464223A2231222C2261646D696E757064617465223A2231227D2C2261646D696E726F6C65223A7B2261646D696E726F6C65616464223A2231222C2261646D696E726F6C65757064617465223A2231227D2C22766964656F223A7B22766964656F616464223A2231222C22766964656F757064617465223A2231222C22766964656F64656C657465223A2231227D7D);
INSERT INTO `n_admin_role` VALUES ('10', '小编', 0x7B226D656E7573223A7B22566964656F223A2234362C3435227D2C22766964656F223A7B22766964656F616464223A2231222C22766964656F757064617465223A2231222C22766964656F64656C657465223A2231227D7D);

-- ----------------------------
-- Table structure for n_dome
-- ----------------------------
DROP TABLE IF EXISTS `n_dome`;
CREATE TABLE `n_dome` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `create_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `update_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `order` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of n_dome
-- ----------------------------
INSERT INTO `n_dome` VALUES ('1', '1560487626', '1560487626', '111', '111');

-- ----------------------------
-- Table structure for n_menu
-- ----------------------------
DROP TABLE IF EXISTS `n_menu`;
CREATE TABLE `n_menu` (
  `menu_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '菜单id',
  `menu_parent_id` int(10) DEFAULT NULL COMMENT '菜单父id',
  `menu_name` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '菜单名称',
  `menu_icon` varchar(120) COLLATE utf8_bin DEFAULT '0' COMMENT '菜单icon',
  `menu_controller` varchar(120) COLLATE utf8_bin DEFAULT NULL COMMENT '菜单控制器',
  `menu_src` varchar(120) COLLATE utf8_bin DEFAULT NULL COMMENT '菜单前端src地址',
  `create_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `update_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `order` varchar(50) COLLATE utf8_bin DEFAULT '50',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of n_menu
-- ----------------------------
INSERT INTO `n_menu` VALUES ('1', '0', '系统设置', 'layui-icon-set', '', '', '1559905414', '1559905414', '20');
INSERT INTO `n_menu` VALUES ('2', '1', '菜单设置', '0', 'Menu', 'MenuList', '1559905414', '1559905414', '50');
INSERT INTO `n_menu` VALUES ('38', '0', '管理员设置', 'layui-icon-user', '', '', '1560244858', '1560244858', '50');
INSERT INTO `n_menu` VALUES ('29', '1', '管理员日志', '', 'AdminLog', 'LogList', '1560236549', '1560242892', '50');
INSERT INTO `n_menu` VALUES ('44', '1', '控制器模块', '', 'System', 'System', '1560315526', '1560315526', '50');
INSERT INTO `n_menu` VALUES ('39', '38', '管理员列表', '', 'Admin', 'AdminList', '1560244879', '1560244879', '50');
INSERT INTO `n_menu` VALUES ('40', '38', '管理员角色列表', '', 'AdminRole', 'AdminRoleList', '1560244905', '1560244912', '50');
INSERT INTO `n_menu` VALUES ('45', '0', '视频设置', 'layui-icon-video', '', '', '1560328228', '1560328228', '50');
INSERT INTO `n_menu` VALUES ('46', '45', '视频列表', '', 'Video', 'VideoList', '1560328248', '1560328248', '50');

-- ----------------------------
-- Table structure for n_video
-- ----------------------------
DROP TABLE IF EXISTS `n_video`;
CREATE TABLE `n_video` (
  `video_id` int(10) NOT NULL AUTO_INCREMENT,
  `video_name` varchar(60) COLLATE utf8_bin NOT NULL COMMENT '视频名称',
  `video_url` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '视频url',
  `video_img` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '视频展示图',
  `video_classify_id` int(10) DEFAULT NULL COMMENT '视频分类id',
  `video_level_id` int(10) DEFAULT NULL COMMENT '视频集id',
  PRIMARY KEY (`video_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of n_video
-- ----------------------------
INSERT INTO `n_video` VALUES ('1', '11', '11', '1', '1', '1');
INSERT INTO `n_video` VALUES ('2', '视频1', '视频', '视频', '0', '0');
INSERT INTO `n_video` VALUES ('3', '111', '1', '1', '1', '1');