/* SQLyog Ultimate v13.1.1 (64 bit) MySQL - 5.7.38 : Database - data_mark ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`data_mark` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `data_mark`; /*Table structure for table `dict` */ DROP TABLE IF EXISTS `dict`; CREATE TABLE `dict` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增编号', `name` varchar(255) DEFAULT NULL COMMENT '名称', `type` varchar(255) DEFAULT NULL COMMENT '类型字符', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `dict` */ insert into `dict`(`id`,`name`,`type`,`remark`,`update_time`,`create_time`) values (1,'字典1','type1','第一','2023-05-25 10:29:01','2023-03-27 17:35:34'), (2,'字典2','type2','第二1','2023-05-26 10:31:51','2023-03-30 14:36:52'); /*Table structure for table `dict_item` */ DROP TABLE IF EXISTS `dict_item`; CREATE TABLE `dict_item` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增编号', `dict_id` int(255) DEFAULT NULL COMMENT '字典父级id', `dict_label` varchar(255) DEFAULT '' COMMENT '标签', `dict_value` varchar(255) DEFAULT '' COMMENT '值', `dict_sort` int(11) DEFAULT '0' COMMENT '排序', `dict_class` varchar(255) DEFAULT '' COMMENT '样式', `status` int(11) DEFAULT '1' COMMENT '状态', `remark` varchar(255) DEFAULT '' COMMENT '备注', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `dict_item` */ /*Table structure for table `ditor` */ DROP TABLE IF EXISTS `ditor`; CREATE TABLE `ditor` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `val` text COMMENT '富文本值', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `ditor` */ insert into `ditor`(`id`,`val`,`update_time`,`create_time`) values (1,'

一、项目预览地址

二、交流群、问题解答入口

三、项目启动

  1. #克隆项目git https://gitee.com/MMinter/vue_node.git
  2. #进入目录cd item
  3. #安装依赖（建议使用node版本16以下 10以上）npm install
  4. #启动项目npm run dev
  1. #创建数据库创建数据库 名：data_mark基字符集 选：默认（default） 或者 utf8排序规则 选：默认（default） 或者 utf8_general_ci
  2. #导入数据库将APP/数据库 文件夹的data_mark.sql导入新建的data_mark库中。
  3. #数据库配置信息//配置文件在APP/poo.js 中，请根据自身环境配置 const pool=mysql.createPool({ host:\"127.0.0.1\", port:3306,//端口 user:\"root\",//账户名 password:\"root\",//登录密码 database:\"data_mark\",//数据库名称 connectionLimit:15 });
  1. #克隆项目（如果已经执行了前端页面启动的克隆，可略过这点）git clone https://gitee.com/MMinter/vue_node.git
  2. #进入目录cd APP
  3. #安装依赖npm install
  4. #启动服务npm run dev

四、功能简明

五、效果截图

\"登录\"

\"用户管理\"\"主题修改\"
\"菜单管理\"\"菜单修改\"
\"角色管理\"\"字典管理\"


','2023-06-21 14:31:25','2023-06-21 14:25:45'); /*Table structure for table `files` */ DROP TABLE IF EXISTS `files`; CREATE TABLE `files` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `val` varchar(6000) DEFAULT NULL COMMENT '值', `type` int(11) DEFAULT '1' COMMENT '判断1图片，2其他', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `files` */ insert into `files`(`id`,`val`,`type`,`update_time`,`create_time`) values (1,'[{\"url\":\"http://127.0.0.1:8899/168716330188007431480203391654-微信图片_20221209135913.jpg\",\"name\":\"微信图片_20221209135913\",\"originalname\":\"微信图片_20221209135913.jpg\"}]',1,NULL,'2023-06-19 16:28:23'); /*Table structure for table `more` */ DROP TABLE IF EXISTS `more`; CREATE TABLE `more` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '账号昵称', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; /*Data for the table `more` */ insert into `more`(`id`,`name`,`remark`,`update_time`,`create_time`) values (8,'第二家店铺','','2023-06-16 15:42:24','2023-04-06 15:44:53'), (5,'第一家店铺','','2023-06-16 15:42:26','2023-04-06 15:44:53'); /*Table structure for table `roles` */ DROP TABLE IF EXISTS `roles`; CREATE TABLE `roles` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `name` varchar(225) NOT NULL DEFAULT '' COMMENT '名称', `roles` varchar(10000) NOT NULL DEFAULT '' COMMENT '权限标识', `checked_roles` varchar(255) NOT NULL DEFAULT '' COMMENT '权限默认选中标识', `role_key` varchar(10000) DEFAULT '' COMMENT '权限字符', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; /*Data for the table `roles` */ insert into `roles`(`id`,`name`,`roles`,`checked_roles`,`role_key`,`update_time`,`create_time`) values (1,'admin','8,9,10,2,5,11,17,1','8,9,10,5,11,17','admin',NULL,'2023-04-06 15:39:40'), (12,'中级管家2','49,30,43,31,122,121,123,128,125,124,1,10,8,26,27,69,76,32,113,44,65,68','49,43,31,32,68','middle','2023-06-16 15:45:04','2023-04-06 15:39:40'), (13,'初级管家1','30,43,31,122,121,123,125,124,1,10,8,26,27,69,76,32,113,44,65,66','49,43,31,10,8,26,27,76,32,113,110,109,108,107,105,104,103,102,100,99,98,97,96,92,91,90,89,66,68','primary','2023-06-16 15:45:11','2023-04-06 15:39:40'); /*Table structure for table `router_menu` */ DROP TABLE IF EXISTS `router_menu`; CREATE TABLE `router_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父级id', `title` varchar(255) DEFAULT '' COMMENT '标题', `icon` varchar(255) DEFAULT '' COMMENT '图标', `no_cache` int(11) DEFAULT '1' COMMENT '是否缓存', `meta` varchar(255) NOT NULL DEFAULT '' COMMENT '其他对象', `path` varchar(255) NOT NULL DEFAULT '/' COMMENT '路由地址', `hidden` tinyint(1) NOT NULL DEFAULT '0' COMMENT ' 当设置 true 的时候该路由不会在侧边栏出现 如401，login等页面', `redirect` varchar(255) NOT NULL DEFAULT '' COMMENT '当设置 noRedirect 的时候该路由在面包屑导航中不可被点击', `always_show` tinyint(1) NOT NULL DEFAULT '0' COMMENT '你可以设置 alwaysShow: true，这样它就会忽略之前定义的规则，一直显示根路由', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '设定路由的名字，一定要填写不然使用时会出现各种问题', `layout` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否需要含导航栏，只需一级才设置这个（默认为false）', `parent_view` tinyint(1) NOT NULL DEFAULT '0' COMMENT '如果第二级里面还需要套级，需在当前级设置为true', `component` varchar(255) NOT NULL DEFAULT '/' COMMENT '对应的页面路径', `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序', `alone` int(11) NOT NULL DEFAULT '0' COMMENT '是否独立的（一级）', `role_key` varchar(255) DEFAULT '' COMMENT '权限字符', `menu_type` varchar(255) NOT NULL DEFAULT 'C' COMMENT '菜单类型区分', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8; /*Data for the table `router_menu` */ insert into `router_menu`(`id`,`parent_id`,`title`,`icon`,`no_cache`,`meta`,`path`,`hidden`,`redirect`,`always_show`,`name`,`layout`,`parent_view`,`component`,`sort`,`alone`,`role_key`,`menu_type`,`update_time`,`create_time`) values (1,0,'系统设置','international',1,'{}','/menus',0,'',0,'',1,0,'/',11,0,'','M','2023-06-15 14:48:47','2023-05-26 11:11:07'), (26,1,'用户管理','user',1,'{}','/user',0,'',0,'user',0,0,'admin/user',2,0,'','C','2023-04-10 09:40:38','2023-05-26 11:11:07'), (27,1,'多账号管理','peoples',1,'{}','/more',0,'',0,'more',0,0,'admin/more',3,0,'','C','2023-04-10 09:40:51','2023-05-26 11:11:07'), (49,0,'图标','icon',1,'{}','/icon',0,'',0,'Icon',1,0,'icons/index',0,0,NULL,'C','2023-05-26 11:14:27','2023-05-26 11:11:07'), (8,1,'角色管理','role',1,'{}','/role',0,'',0,'Role',0,0,'admin/role',1,0,'','C','2023-05-25 11:20:21','2023-05-26 11:11:07'), (30,0,'测试数据','bug',1,'{}','/test',0,'',0,'',1,0,'/',0,0,'','M','2023-05-26 11:14:24','2023-05-26 11:11:07'), (10,1,'菜单管理','list',1,'{}','/menu',0,'',0,'Menu',0,0,'admin/menu',0,0,'','C','2023-05-26 11:14:37','2023-05-26 11:11:07'), (31,30,'多账号测试','bug',1,'{}','/index',0,'',0,'testMore',0,0,'test/index',1,0,'','C','2023-03-30 16:17:06','2023-05-26 11:11:07'), (32,0,'Gitee直达','link',1,'{}','https://gitee.com/MMinter/vue_node',0,'',0,'link',1,0,'/',14,0,'','C','2023-04-11 11:23:33','2023-05-26 11:11:07'), (65,44,'测试数据','eye',1,'{}','',1,'',0,'',0,0,'/',0,0,NULL,'F','2023-03-27 15:18:34','2023-05-26 11:11:07'), (44,0,'菜单权限字符','eye',1,'{}','',1,'',0,'',1,0,'/',100,0,NULL,'F','2023-04-11 11:24:29','2023-05-26 11:11:07'), (66,65,'权限测试1','form',1,'{}','',1,'',0,'',0,0,'/',0,0,'roleKey2','F','2023-06-07 16:44:24','2023-05-26 11:11:07'), (43,30,'权限隐藏API测试','eye',1,'{}','/RoleApi',0,'',0,'RoleApi',0,0,'test/roleApi',0,0,'','C','2023-03-15 15:52:16','2023-05-26 11:11:07'), (68,65,'权限测试2','example',1,'{}','',1,'',0,'',0,0,'/',1,0,'roleKey2','F','2023-03-27 15:23:59','2023-05-26 11:11:07'), (69,1,'字典管理','dashboard',1,'{}','/dict',0,'',0,'Dict',0,0,'admin/dict',4,0,NULL,'C','2023-03-30 16:58:47','2023-05-26 11:11:07'), (97,95,'用户新增','user',1,'{}','/',0,'',0,'',0,0,'/',0,0,'user_add','F','2023-04-03 16:47:22','2023-05-26 11:11:07'), (85,44,'系统设置','lock',1,'{}','/',1,'',0,'',0,0,'/',0,0,'','F','2023-04-03 15:21:17','2023-05-26 11:11:07'), (88,85,'菜单管理','documentation',1,'{}','/',0,'',0,'',0,0,'/',0,0,NULL,'F','2023-04-03 15:21:49','2023-05-26 11:11:07'), (89,88,'菜单查询','example',1,'{}','/',0,'',0,'',0,0,'/',0,0,'menu_query','F','2023-04-03 15:22:46','2023-05-26 11:11:07'), (90,88,'菜单新增','example',1,'{}','/',0,'',0,'',0,0,'/',0,0,'menu_add','F','2023-04-03 15:35:28','2023-05-26 11:11:07'), (91,88,'菜单修改','example',1,'{}','/',0,'',0,'',0,0,'/',0,0,'menu_up','F','2023-04-03 15:36:06','2023-05-26 11:11:07'), (92,88,'菜单删除','example',1,'{}','/',0,'',0,'',0,0,'/',0,0,'menu_delete','F','2023-04-03 15:36:19','2023-05-26 11:11:07'), (76,69,'字典项目','form',1,'{}','/dictItem',0,'',0,'DictItem',0,0,'admin/dictItem',0,0,'','C','2023-03-30 15:55:52','2023-05-26 11:11:07'), (95,85,'用户管理','user',1,'{}','/',0,'',0,'',0,0,'/',0,0,NULL,'F','2023-04-03 16:46:18','2023-05-26 11:11:07'), (96,95,'用户查询','user',1,'{}','/',0,'',0,'',0,0,'/',0,0,'user_query','F','2023-04-03 16:46:56','2023-05-26 11:11:07'), (98,95,'用户修改','user',1,'{}','/',0,'',0,'',0,0,'/',0,0,'user_up','F','2023-04-03 16:52:31','2023-05-26 11:11:07'), (99,95,'用户删除','user',1,'{}','/',0,'',0,'',0,0,'/',0,0,'user_delete','F','2023-04-03 16:52:47','2023-05-26 11:11:07'), (100,95,'用户修改密码','eye',1,'{}','/',0,'',0,'',0,0,'/',0,0,'user_pwd','F','2023-04-03 16:56:33','2023-05-26 11:11:07'), (101,85,'角色管理','peoples',1,'{}','/',0,'',0,'',0,0,'/',0,0,NULL,'F','2023-04-03 16:59:20','2023-05-26 11:11:07'), (102,101,'角色查询','peoples',1,'{}','/',0,'',0,'',0,0,'/',0,0,'role_query','F','2023-04-03 16:59:33','2023-05-26 11:11:07'), (103,101,'角色新增','peoples',1,'{}','/',0,'',0,'',0,0,'/',0,0,'role_add','F','2023-04-03 16:59:46','2023-05-26 11:11:07'), (104,101,'角色修改','peoples',1,'{}','/',0,'',0,'',0,0,'/',0,0,'role_up','F','2023-04-03 17:00:04','2023-05-26 11:11:07'), (105,101,'角色删除','peoples',1,'{}','/',0,'',0,'',0,0,'/',0,0,'role_delete','F','2023-04-03 17:00:24','2023-05-26 11:11:07'), (106,85,'多账户管理','nested',1,'{}','/',0,'',0,'',0,0,'/',0,0,NULL,'F','2023-04-03 17:12:25','2023-05-26 11:11:07'), (107,106,'多账户查询','people',1,'{}','/',0,'',0,'',0,0,'/',0,0,'more_query','F','2023-04-03 17:31:07','2023-05-26 11:11:07'), (108,106,'多账户新增','people',1,'{}','/',0,'',0,'',0,0,'/',0,0,'more_add','F','2023-04-03 17:31:30','2023-05-26 11:11:07'), (109,106,'多账户修改','people',1,'{}','/',0,'',0,'',0,0,'/',0,0,'more_up','F','2023-04-03 17:31:47','2023-05-26 11:11:07'), (110,106,'多账户删除','people',1,'{}','/',0,'',0,'',0,0,'/',0,0,'more_delete','F','2023-04-03 17:32:07','2023-05-26 11:11:07'), (113,0,'GitHub直达','link',1,'{}','https://github.com/MingMinter/vue_node_admin',0,'',0,'GitHub',1,0,'/',16,0,NULL,'C','2023-06-15 14:50:55','2023-05-26 11:11:07'), (121,122,'上传图片','education',1,'{}','/img',0,'',0,'Img',0,0,'components/img',0,0,NULL,'C','2023-05-29 14:35:29','2023-05-26 16:18:37'), (122,0,'文件管理','zip',1,'{}','/file',0,'',0,'',1,0,'/',0,0,NULL,'M',NULL,'2023-05-29 14:35:16'), (123,122,'上传文件','zip',1,'{}','/file',0,'',0,'File',0,0,'components/file',0,0,NULL,'C',NULL,'2023-05-30 15:13:26'), (124,0,'我的信息','user',1,'{}','/info',0,'',0,'Info',1,0,'admin/info',10,0,'www1','C','2023-06-15 14:37:57','2023-05-31 15:09:24'), (125,0,'富文本编辑','form',1,'{}','/ditor',0,'',0,'Ditor',1,0,'components/ditor',1,0,NULL,'C','2023-06-15 14:38:54','2023-06-02 10:00:59'), (128,0,'大屏展示','chart',1,'{}','/echart',0,'',0,'Echart',1,0,'components/echart',0,0,NULL,'C',NULL,'2023-06-13 10:24:44'); /*Table structure for table `tests` */ DROP TABLE IF EXISTS `tests`; CREATE TABLE `tests` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `name` varchar(255) DEFAULT NULL COMMENT '昵称', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `more_id` int(11) DEFAULT NULL COMMENT '多账号编号', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8; /*Data for the table `tests` */ insert into `tests`(`id`,`name`,`remark`,`more_id`,`update_time`,`create_time`) values (72,'名称6','备注6',6,NULL,'2023-06-21 14:21:53'), (71,'名称5','备注5',5,NULL,'2023-06-21 14:21:53'), (70,'名称4','备注4',4,NULL,'2023-06-21 14:21:53'), (69,'名称3','备注3',3,NULL,'2023-06-21 14:21:53'), (68,'名称2','备注2',2,NULL,'2023-06-21 14:21:53'), (67,'名称6','备注6啊撒打发',6,'2023-06-21 14:07:43','2023-06-21 14:00:36'), (66,'名称5','备注5',5,NULL,'2023-06-21 14:00:36'), (65,'名称4','备注4',4,NULL,'2023-06-21 14:00:36'), (64,'名称3','备注3',3,NULL,'2023-06-21 14:00:36'), (63,'名称2','备注2',2,NULL,'2023-06-21 14:00:36'), (62,'名称6','备注6',6,NULL,'2023-06-21 14:00:29'), (61,'名称5','备注5',5,NULL,'2023-06-21 14:00:29'), (60,'名称4','备注4',4,NULL,'2023-06-21 14:00:29'), (59,'名称3','备注3',3,NULL,'2023-06-21 14:00:29'), (58,'名称2','备注2',2,NULL,'2023-06-21 14:00:29'), (57,'名称6','备注6',6,NULL,'2023-06-20 17:18:37'), (56,'名称5','备注5',5,NULL,'2023-06-20 17:18:37'), (55,'名称4','备注4',4,NULL,'2023-06-20 17:18:37'), (54,'名称3','备注3',3,NULL,'2023-06-20 17:18:37'), (53,'名称2',NULL,2,NULL,'2023-06-20 17:18:37'); /*Table structure for table `theme` */ DROP TABLE IF EXISTS `theme`; CREATE TABLE `theme` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增', `user_id` int(11) DEFAULT NULL COMMENT '用户id', `menu_bg` varchar(255) DEFAULT '' COMMENT '默认背景', `menu_sub_bg` varchar(255) DEFAULT '' COMMENT '展开背景', `menu_text` varchar(255) DEFAULT '' COMMENT '默认文字', `menu_active_text` varchar(255) DEFAULT '' COMMENT '选中文字', `menu_sub_active_text` varchar(255) DEFAULT '' COMMENT '当前选中展开文字', `menu_hover_bg` varchar(255) DEFAULT '' COMMENT 'hover背景', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; /*Data for the table `theme` */ insert into `theme`(`id`,`user_id`,`menu_bg`,`menu_sub_bg`,`menu_text`,`menu_active_text`,`menu_sub_active_text`,`menu_hover_bg`,`update_time`,`create_time`) values (1,1,'#304156','#304156','#bfcad5','#409eff','#fff','#001528','2023-06-21 15:07:08','2023-05-26 11:30:29'), (25,53,'#304156','#304156','#bfcad5','#409eff','#fff','#001528',NULL,'2023-06-16 15:18:24'), (26,54,'#304156','#304156','#bfcad5','#409eff','#fff','#001528',NULL,'2023-06-16 15:18:55'); /*Table structure for table `user` */ DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称', `url` varchar(1000) DEFAULT NULL COMMENT '头像', `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态', `roles_id` varchar(255) NOT NULL DEFAULT '' COMMENT '角色编号', `remark` varchar(255) DEFAULT '' COMMENT '备注', `admin` int(11) NOT NULL DEFAULT '0' COMMENT '管理员', `pwd` varchar(255) NOT NULL DEFAULT '' COMMENT '密码', `more_id` int(11) NOT NULL DEFAULT '0' COMMENT '账号编号', `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8; /*Data for the table `user` */ insert into `user`(`id`,`name`,`url`,`status`,`roles_id`,`remark`,`admin`,`pwd`,`more_id`,`update_time`,`create_time`) values (1,'admin','http://127.0.0.1:8899/168733128710103334278761577498-bg.2fa5cb09.jpg',1,'1','管理员',1,'63f6deb737ab85677d6f11beea14a08b',5,'2023-06-21 15:08:08','2023-04-05 15:32:33'), (54,'用户2','http://127.0.0.1:8899/168689992581107644377496097021-5fdf8db1cb134954ff32f8327d50c852d1094a64.png',1,'12',NULL,0,'63f6deb737ab85677d6f11beea14a08b',8,NULL,'2023-06-16 15:18:55'), (53,'用户1','http://127.0.0.1:8899/168733130248802918960813102325-src=http___p2.itc.cn_q_70_images03_20220824_f94f1b9fd812425982e71afd7d115a93.jpeg&refer=http___p2.itc.jpg',1,'13',NULL,0,'63f6deb737ab85677d6f11beea14a08b',5,'2023-06-21 15:08:24','2023-06-16 15:18:24'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;