/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 10.6.3-MariaDB : Database - newipet
*********************************************************************
*/

/*!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*/`newipet` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `newipet`;

/*Table structure for table `chatmsg` */

DROP TABLE IF EXISTS `chatmsg`;

CREATE TABLE `chatmsg` (
  `senduserid` int(10) DEFAULT NULL COMMENT '发送者id',
  `reciveuserid` int(10) DEFAULT NULL COMMENT '接受者id',
  `content` text CHARACTER SET eucjpms DEFAULT NULL,
  `sendtime` datetime DEFAULT NULL COMMENT '发送时间',
  `msgtype` varchar(64) CHARACTER SET eucjpms DEFAULT NULL COMMENT '消息类型'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `chatmsg` */

/*Table structure for table `collect` */

DROP TABLE IF EXISTS `collect`;

CREATE TABLE `collect` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '收藏id',
  `item_id` int(10) NOT NULL COMMENT '商品id',
  `item_name` varchar(255) DEFAULT '' COMMENT '商品名',
  `item_desc` varchar(255) DEFAULT '' COMMENT '商品描述',
  `collstatus` int(10) DEFAULT 1 COMMENT '0失效 1正常 2删除',
  `seller_id` int(10) NOT NULL COMMENT '商品用户id',
  `sellername` varchar(64) NOT NULL,
  `city` varchar(255) DEFAULT '' COMMENT '商品所在学校',
  `user_id` int(10) NOT NULL COMMENT '收藏用户id',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

/*Data for the table `collect` */

insert  into `collect`(`id`,`item_id`,`item_name`,`item_desc`,`collstatus`,`seller_id`,`sellername`,`city`,`user_id`,`created`,`updated`) values (2,1,'英国短毛猫','我爱我情爱我祖国',1,7,'admin','',11,'2021-07-27 09:57:15','2021-07-27 09:57:15');

/*Table structure for table `friends` */

DROP TABLE IF EXISTS `friends`;

CREATE TABLE `friends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(10) DEFAULT NULL COMMENT '用户id',
  `fuserid` int(10) DEFAULT NULL COMMENT '好友id',
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;

/*Data for the table `friends` */

insert  into `friends`(`id`,`userid`,`fuserid`,`created`) values (1,7,14,'2021-07-09 19:26:55'),(2,7,15,'2021-07-09 19:26:55'),(3,7,16,'2021-07-09 19:26:55'),(4,11,14,'2021-07-21 08:48:11'),(5,11,22,'2021-07-21 08:48:15'),(6,14,7,'2021-07-21 08:48:18'),(7,15,7,'2021-07-21 08:48:20'),(8,14,11,'2021-07-21 08:49:13'),(9,16,7,'2021-07-24 09:57:33'),(10,22,11,'2021-07-23 18:11:05'),(13,11,7,NULL),(14,7,11,NULL),(15,47,7,NULL),(16,7,47,NULL),(17,46,7,NULL),(18,7,46,NULL),(19,35,7,NULL),(20,7,35,NULL),(21,37,7,NULL),(22,7,37,NULL);

/*Table structure for table `item` */

DROP TABLE IF EXISTS `item`;

CREATE TABLE `item` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_desc` varchar(512) DEFAULT NULL COMMENT '商品描述',
  `category` varchar(255) DEFAULT NULL COMMENT '商品类别',
  `image` mediumblob DEFAULT NULL,
  `orimoney` int(11) DEFAULT NULL COMMENT '商品价格,单位为分',
  `city` varchar(255) DEFAULT NULL,
  `item_status` int(11) DEFAULT NULL COMMENT '商品状态:0违规 1正常 2删除 3待审核 4已售出',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`item_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

/*Data for the table `item` */

insert  into `item`(`item_id`,`user_id`,`item_name`,`item_desc`,`category`,`image`,`orimoney`,`city`,`item_status`,`created`,`updated`) values (1,7,'英国短毛猫','我爱我情爱我祖国','宠物猫',NULL,2500,'',1,'2021-07-26 14:19:37','2021-07-26 14:19:47'),(2,8,'印度猫',NULL,'宠物猫',NULL,2600,'',1,NULL,NULL),(3,11,'波米粒猫',NULL,'宠物猫',NULL,2700,'',1,NULL,NULL),(4,9,'美国刚毛猫',NULL,'宠物猫',NULL,2800,'',1,NULL,NULL),(5,10,'美国短毛猫','你是我大大低洼阿瓦达哇多哇低洼撒多啊','宠物猫',NULL,2800,'',1,NULL,NULL),(6,12,'雪鞋猫',NULL,'宠物猫',NULL,2800,'',1,NULL,NULL),(7,12,'布偶猫',NULL,'宠物猫',NULL,2800,'',1,NULL,NULL),(8,13,'波斯猫',NULL,'宠物猫',NULL,2800,'',1,NULL,NULL),(9,13,'金吉拉猫',NULL,'宠物猫',NULL,2800,'',1,NULL,NULL),(10,15,'东方长毛猫',NULL,'宠物猫',NULL,2800,'',1,NULL,NULL),(11,14,'彼得秃猫',NULL,'宠物猫',NULL,2800,'',1,NULL,NULL),(12,13,'顿斯科伊猫',NULL,'宠物猫',NULL,4800,'',1,NULL,NULL),(13,17,'斯芬克斯猫',NULL,'宠物猫',NULL,4800,'',1,NULL,NULL),(14,33,'泰迪',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(15,22,'比熊犬',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(16,17,'博美犬',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(17,34,'雪纳瑞',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(18,14,'柯基',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(19,18,'八哥犬',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(20,35,'西施犬',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(21,28,'哈士奇',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(22,28,'萨摩耶',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(23,26,'拉布拉多',NULL,'宠物狗',NULL,4800,'',1,NULL,NULL),(24,28,'边牧',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(25,36,'贝灵顿梗',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(26,21,'柴犬',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(27,23,'秋田犬',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(28,22,'金毛',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(29,25,'布列塔尼猎犬',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(30,26,'舒伯齐犬',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(31,8,'金毛寻回犬',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(32,9,'德国牧羊犬',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(33,19,'阿拉斯加',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(34,20,'苏格兰牧羊犬',NULL,'宠物狗',NULL,5000,'',1,NULL,NULL),(35,26,'藏獒',NULL,'宠物狗',NULL,3600,'',1,NULL,NULL),(36,23,'高加索犬',NULL,'宠物狗',NULL,3600,'',1,NULL,NULL),(37,38,'杜宾犬',NULL,'宠物狗',NULL,3600,'',1,NULL,NULL),(38,29,'荷兰垂耳兔',NULL,'宠物兔',NULL,3600,'',1,NULL,NULL),(39,32,'长毛垂耳兔',NULL,'宠物兔',NULL,5000,'',1,NULL,NULL),(40,33,'荷兰侏儒兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(41,24,'狮子兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(42,39,'小型安哥拉兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(43,42,'海棠兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(44,49,'西施兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(45,45,'英国斑点兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(46,46,'标准金吉拉兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(47,47,'雷克斯兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(48,33,'比利时兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(49,12,'新西兰白兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(50,13,'法国垂耳兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(51,14,'巨型安哥拉兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(52,15,'大型海棠兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(53,19,'巨型金吉拉兔',NULL,'宠物兔',NULL,4500,'',1,NULL,NULL),(54,20,'布丁仓鼠',NULL,'宠物鼠',NULL,4500,'',1,NULL,NULL),(55,21,'一线仓鼠',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(56,23,'三线仓鼠',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(57,24,'银狐仓鼠',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(58,25,'米色龙猫',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(59,26,'丝绒黑龙猫',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(60,27,'金色龙猫',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(61,9,'纯白龙猫',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(62,10,'标准灰龙猫',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(63,30,'荷兰鼠',NULL,'宠物鼠',NULL,4300,'',1,NULL,NULL),(64,31,'巴西龟',NULL,'宠物龟',NULL,4300,'',1,NULL,NULL),(65,32,'草龟',NULL,'宠物龟',NULL,4300,'',1,NULL,NULL),(66,33,'花龟',NULL,'宠物龟',NULL,4300,'',1,NULL,NULL),(67,34,'鳄龟',NULL,'宠物龟',NULL,4300,'',1,NULL,NULL),(68,35,'黄喉拟水龟',NULL,'宠物龟',NULL,4300,'',1,NULL,NULL),(69,36,'金鱼',NULL,'宠物鱼',NULL,4300,'',1,NULL,NULL),(70,37,'米奇鱼',NULL,'宠物鱼',NULL,4300,'',1,NULL,NULL),(71,38,'龙鱼',NULL,'宠物鱼',NULL,4300,'',1,NULL,NULL),(72,39,'虎鱼',NULL,'宠物鱼',NULL,4300,'',1,NULL,NULL),(73,40,'罗汉鱼',NULL,'宠物鱼',NULL,4300,'',1,NULL,NULL),(74,41,'招财鱼',NULL,'宠物鱼',NULL,4300,'',1,NULL,NULL),(75,42,'锦鲤',NULL,'宠物鱼',NULL,4500,'',1,NULL,NULL),(76,43,'血鹦鹉',NULL,'宠物鱼',NULL,4500,'',1,NULL,NULL),(77,44,'地图鱼',NULL,'宠物鱼',NULL,4500,'',1,NULL,NULL),(78,45,'鹩哥',NULL,'宠物鸟',NULL,4500,'',1,NULL,NULL),(79,20,'八哥',NULL,'宠物鸟',NULL,4500,'',1,NULL,NULL),(80,21,'鹦鹉',NULL,'宠物鸟',NULL,4300,'',1,NULL,NULL),(81,22,'百灵',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(82,23,'画眉',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(83,24,'金丝雀',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(84,25,'点颏',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(85,26,'蜡嘴',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(86,27,'锡嘴',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(87,28,'黄雀',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(88,29,'芙蓉鸟',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(89,21,'金丝雀',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(90,22,'文鸟',NULL,'宠物鸟',NULL,5500,'',1,NULL,NULL),(91,23,'泰国金属蓝',NULL,'宠物蜘蛛',NULL,5500,'',1,NULL,NULL),(92,24,'智利红玫瑰',NULL,'宠物蜘蛛',NULL,5500,'',1,NULL,NULL),(93,25,'墨西哥红膝',NULL,'宠物蜘蛛',NULL,5500,'',1,NULL,NULL),(94,26,'墨西哥火脚',NULL,'宠物蜘蛛',NULL,4400,'',1,NULL,NULL),(95,27,'洪都拉斯卷毛',NULL,'宠物蜘蛛',NULL,4400,'',1,NULL,NULL),(96,28,'巴西白膝头',NULL,'宠物蜘蛛',NULL,4400,'',1,NULL,NULL),(97,29,'食鸟蛛',NULL,'宠物蜘蛛',NULL,4400,'',1,NULL,NULL),(98,30,'丽纹龙蜥',NULL,'宠物蜥蜴',NULL,4400,'',1,NULL,NULL),(99,31,'高冠变色龙',NULL,'宠物蜥蜴',NULL,4400,'',1,NULL,NULL),(100,33,'绿鬣蜥',NULL,'宠物蜥蜴',NULL,4400,'',1,NULL,NULL),(101,34,'绿水龙',NULL,'宠物蜥蜴',NULL,4400,'',1,NULL,NULL),(102,35,'豹纹守宫',NULL,'宠物蜥蜴',NULL,4400,'',1,NULL,NULL),(103,36,'鬃狮蜥',NULL,'宠物蜥蜴',NULL,4400,'',1,NULL,NULL),(104,37,'蛙眼守宫',NULL,'宠物蜥蜴',NULL,4400,'',1,NULL,NULL),(105,38,'大壁虎',NULL,'宠物蜥蜴',NULL,4400,'',1,NULL,NULL),(106,39,'茶杯猪',NULL,'宠物猪',NULL,4400,'',1,NULL,NULL),(107,40,'胡利亚尼猪',NULL,'宠物猪',NULL,4400,'',1,NULL,NULL),(108,41,'宠物蛇',NULL,'宠物蛇',NULL,4900,'',1,NULL,NULL),(109,42,'玉米蛇',NULL,'宠物蛇',NULL,4900,'',1,NULL,NULL),(110,43,'王蛇',NULL,'宠物蛇',NULL,4900,'',1,NULL,NULL),(111,44,'奶蛇',NULL,'宠物蛇',NULL,4900,'',1,NULL,NULL),(112,45,'棕黑锦蛇',NULL,'宠物蛇',NULL,4900,'',1,NULL,NULL),(113,46,'中华水蛇',NULL,'宠物蛇',NULL,4900,'',1,NULL,NULL),(114,47,'蟋蟀',NULL,'小昆虫',NULL,4900,'',1,NULL,NULL),(115,48,'独角仙',NULL,'小昆虫',NULL,4900,'',1,NULL,NULL),(116,49,'蝎子',NULL,'小昆虫',NULL,4900,'',1,NULL,NULL),(117,53,'蝈蝈',NULL,'小昆虫',NULL,4900,'',1,NULL,NULL);

/*Table structure for table `item_cate` */

DROP TABLE IF EXISTS `item_cate`;

CREATE TABLE `item_cate` (
  `id` int(64) NOT NULL AUTO_INCREMENT,
  `parent_id` int(64) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` int(5) DEFAULT 1,
  `level` int(5) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb3;

/*Data for the table `item_cate` */

insert  into `item_cate`(`id`,`parent_id`,`name`,`status`,`level`,`created`,`updated`) values (1,0,'宠物猫',1,1,'2021-03-29 18:09:38','2021-07-06 15:51:30'),(2,1,'短毛猫',1,2,'2021-07-05 15:59:54','2021-07-05 15:59:57'),(3,2,'英国短毛猫',1,3,'2021-07-05 16:01:48','2021-07-05 16:01:50'),(4,2,'印度猫',1,3,'2021-07-05 16:02:17','2021-07-05 16:02:21'),(5,2,'波米粒猫',1,3,'2021-07-05 16:02:48','2021-07-05 16:02:52'),(6,2,'美国刚毛猫',1,3,'2021-07-05 16:03:13','2021-07-05 16:03:16'),(7,2,'美国短毛猫',1,3,'2021-07-05 16:03:32','2021-07-05 16:03:35'),(8,2,'雪鞋猫',1,3,'2021-07-05 16:03:53','2021-07-05 16:04:01'),(9,1,'长毛猫',1,2,'2021-07-05 16:04:34','2021-07-05 16:04:37'),(10,9,'布偶猫',1,3,'2021-07-05 16:05:32','2021-07-05 16:05:34'),(11,9,'波斯猫',1,3,'2021-07-05 16:05:51','2021-07-05 16:05:53'),(12,9,'金吉拉猫',1,3,'2021-07-05 16:06:10','2021-07-05 16:06:15'),(13,9,'东方长毛猫',1,3,'2021-07-05 16:06:33','2021-07-05 16:06:38'),(14,9,'英国长毛猫',1,3,'2021-07-05 16:06:59','2021-07-05 16:07:00'),(15,1,'无毛猫',1,2,'2021-07-05 16:07:35','2021-07-05 16:07:37'),(16,15,'彼得秃猫',1,3,'2021-07-05 16:08:15','2021-07-05 16:08:18'),(17,15,'顿斯科伊猫',1,3,'2021-07-05 16:08:38','2021-07-05 16:08:41'),(18,15,'斯芬克斯猫',1,3,'2021-07-05 16:09:07','2021-07-05 16:09:10'),(19,0,'宠物狗',1,1,'2021-07-05 16:09:39','2021-07-05 16:09:42'),(20,19,'小型宠物狗',1,2,'2021-07-05 16:10:25','2021-07-05 16:10:29'),(21,20,'泰迪',1,3,'2021-07-05 16:11:15','2021-07-05 16:11:17'),(22,20,'比熊犬',1,3,'2021-07-05 16:11:40','2021-07-05 16:11:42'),(23,20,'博美犬',1,3,'2021-07-05 16:13:17','2021-07-05 16:13:19'),(24,20,'雪纳瑞',1,3,'2021-07-05 16:13:43','2021-07-05 16:13:45'),(25,20,'柯基',1,3,'2021-07-05 16:14:25','2021-07-05 16:14:27'),(26,20,'八哥犬',1,3,'2021-07-05 16:15:08','2021-07-05 16:15:10'),(27,20,'西施犬',1,3,'2021-07-05 16:15:53','2021-07-05 16:15:56'),(28,19,'中型宠物狗',1,2,'2021-07-05 16:16:24','2021-07-05 16:16:26'),(29,28,'哈士奇',1,3,'2021-07-05 16:17:13','2021-07-05 16:17:14'),(30,28,'萨摩耶',1,3,'2021-07-05 16:17:32','2021-07-05 16:17:34'),(31,28,'拉布拉多',1,3,'2021-07-05 16:17:52','2021-07-05 16:17:53'),(32,28,'边牧',1,3,'2021-07-05 16:18:13','2021-07-05 16:18:14'),(33,28,'贝灵顿梗',1,3,'2021-07-05 16:18:34','2021-07-05 16:18:36'),(34,28,'柴犬',1,3,'2021-07-05 16:18:54','2021-07-05 16:18:56'),(35,28,'秋田犬',1,3,'2021-07-05 16:19:26','2021-07-05 16:19:28'),(36,28,'金毛',1,3,'2021-07-05 16:19:43','2021-07-05 16:19:45'),(37,28,'布列塔尼猎犬',1,3,'2021-07-05 16:20:22','2021-07-05 16:20:24'),(38,28,'舒伯齐犬',1,3,'2021-07-05 16:20:45','2021-07-05 16:20:47'),(39,19,'大型宠物狗',1,2,'2021-07-05 16:21:31','2021-07-05 16:21:33'),(40,39,'金毛寻回犬',1,3,'2021-07-05 16:22:07','2021-07-05 16:22:09'),(41,39,'德国牧羊犬',1,3,'2021-07-05 16:22:58','2021-07-05 16:23:01'),(42,39,'阿拉斯加',1,3,'2021-07-05 16:23:13','2021-07-05 16:23:15'),(43,39,'苏格兰牧羊犬',1,3,'2021-07-05 16:23:36','2021-07-05 16:23:38'),(44,39,'藏獒',1,3,'2021-07-05 16:23:55','2021-07-05 16:23:57'),(45,39,'高加索犬',1,3,'2021-07-05 16:24:13','2021-07-05 16:24:15'),(46,39,'杜宾犬',1,3,'2021-07-05 16:24:35','2021-07-05 16:24:37'),(47,0,'宠物兔',1,1,'2021-07-05 16:25:13','2021-07-05 16:25:15'),(48,47,'小型宠物兔',1,2,'2021-07-05 16:25:34','2021-07-05 16:25:35'),(49,48,'荷兰垂耳兔',1,3,'2021-07-05 16:26:47','2021-07-05 16:26:49'),(50,48,'长毛垂耳兔',1,3,'2021-07-05 16:27:06','2021-07-05 16:27:08'),(51,48,'荷兰侏儒兔',1,3,'2021-07-05 16:27:28','2021-07-05 16:27:30'),(52,48,'狮子兔',1,3,'2021-07-05 16:27:55','2021-07-05 16:27:57'),(53,48,'小型安哥拉兔',1,3,'2021-07-05 16:28:19','2021-07-05 16:28:21'),(54,48,'海棠兔',1,3,'2021-07-05 16:28:41','2021-07-05 16:28:43'),(55,48,'西施兔',1,3,'2021-07-05 16:29:04','2021-07-05 16:29:07'),(56,47,'中型宠物兔',1,2,'2021-07-05 16:29:34','2021-07-05 16:29:36'),(57,56,'英国斑点兔',1,3,'2021-07-05 16:32:01','2021-07-05 16:32:03'),(58,56,'标准金吉拉兔',1,3,'2021-07-05 16:32:35','2021-07-05 16:32:37'),(59,56,'雷克斯兔',1,3,'2021-07-05 16:35:59','2021-07-05 16:36:01'),(60,56,'比利时兔',1,3,'2021-07-05 16:36:26','2021-07-05 16:36:28'),(61,56,'新西兰白兔',1,3,'2021-07-05 16:40:15','2021-07-05 16:40:18'),(62,56,'法国垂耳兔',1,3,'2021-07-05 16:41:15','2021-07-05 16:41:17'),(63,47,'大型宠物兔',1,2,'2021-07-05 16:42:46','2021-07-05 16:42:48'),(64,63,'巨型安哥拉兔',1,3,'2021-07-05 16:43:21','2021-07-05 16:43:24'),(65,63,'大型海棠兔',1,3,'2021-07-05 16:43:42','2021-07-05 16:43:43'),(66,63,'巨型金吉拉兔',1,3,'2021-07-05 16:44:03','2021-07-05 16:44:05'),(67,0,'宠物鼠',1,1,'2021-07-05 16:44:34','2021-07-05 16:44:37'),(68,67,'仓鼠类',1,2,'2021-07-05 16:44:52','2021-07-05 16:44:54'),(69,68,'布丁仓鼠',1,3,'2021-07-05 16:45:14','2021-07-05 16:45:16'),(70,68,'一线仓鼠',1,3,'2021-07-05 16:45:35','2021-07-05 16:45:37'),(71,68,'三线仓鼠',1,3,'2021-07-05 16:45:50','2021-07-05 16:45:52'),(72,68,'银狐仓鼠',1,3,'2021-07-05 16:46:06','2021-07-05 16:46:07'),(73,67,'龙猫类',1,2,'2021-07-05 16:47:14','2021-07-05 16:47:18'),(74,73,'米色龙猫',1,3,'2021-07-05 16:47:53','2021-07-05 16:47:56'),(75,73,'丝绒黑龙猫',1,3,'2021-07-05 16:48:19','2021-07-05 16:48:21'),(76,73,'金色龙猫',1,3,'2021-07-05 16:48:42','2021-07-05 16:48:44'),(77,73,'纯白龙猫',1,3,'2021-07-05 16:49:02','2021-07-05 16:49:03'),(78,73,'标准灰龙猫',1,3,'2021-07-05 16:49:36','2021-07-05 16:49:39'),(79,67,'其他种类',1,2,'2021-07-05 16:50:03','2021-07-05 16:50:06'),(80,79,'荷兰鼠',1,3,'2021-07-05 16:50:21','2021-07-05 16:50:24'),(81,0,'宠物龟',1,1,'2021-07-05 16:50:52','2021-07-05 16:50:54'),(82,81,'普通龟',1,2,'2021-07-05 16:51:48','2021-07-05 16:51:50'),(83,82,'巴西龟',1,3,'2021-07-05 16:52:12','2021-07-05 16:52:13'),(84,82,'草龟',1,3,'2021-07-05 16:52:28','2021-07-05 16:52:30'),(85,82,'花龟',1,3,'2021-07-05 16:52:50','2021-07-05 16:52:52'),(86,82,'鳄龟',1,3,'2021-07-05 16:53:09','2021-07-05 16:53:11'),(87,82,'黄喉拟水龟',1,3,'2021-07-05 16:53:32','2021-07-05 16:53:34'),(88,0,'宠物鱼',1,1,'2021-07-05 16:54:11','2021-07-05 16:54:13'),(89,88,'可爱型',1,2,'2021-07-05 16:54:28','2021-07-05 16:54:30'),(90,89,'金鱼',1,3,'2021-07-05 16:54:44','2021-07-05 16:54:46'),(91,89,'米奇鱼',1,3,'2021-07-05 16:55:04','2021-07-05 16:55:06'),(92,88,'霸气型',1,2,'2021-07-05 16:55:32','2021-07-05 16:55:35'),(93,92,'龙鱼',1,3,'2021-07-05 16:55:55','2021-07-05 16:55:57'),(94,92,'虎鱼',1,3,'2021-07-05 16:56:15','2021-07-05 16:56:17'),(95,88,'互动型',1,2,'2021-07-05 16:56:38','2021-07-05 16:56:39'),(96,95,'罗汉鱼',1,3,'2021-07-05 16:56:55','2021-07-05 16:56:57'),(97,95,'招财鱼',1,3,'2021-07-05 16:57:15','2021-07-05 16:57:17'),(98,95,'锦鲤',1,3,'2021-07-05 16:58:03','2021-07-05 16:58:06'),(99,95,'血鹦鹉',1,3,'2021-07-05 16:58:30','2021-07-05 16:58:31'),(100,95,'地图鱼',1,3,'2021-07-05 16:59:15','2021-07-05 16:59:17'),(101,0,'宠物鸟',1,1,'2021-07-05 16:59:37','2021-07-05 16:59:39'),(102,101,'模仿人语类',1,2,'2021-07-05 17:00:54','2021-07-05 17:00:56'),(103,102,'鹩哥',1,3,'2021-07-05 17:01:14','2021-07-05 17:01:15'),(104,102,'八哥',1,3,'2021-07-05 17:01:33','2021-07-05 17:01:34'),(105,102,'鹦鹉',1,3,'2021-07-05 17:01:48','2021-07-05 17:01:50'),(106,101,'闻鸣叫声类',1,2,'2021-07-05 17:02:13','2021-07-05 17:02:15'),(107,106,'百灵',1,3,'2021-07-05 17:02:34','2021-07-05 17:02:35'),(108,107,'画眉',1,3,'2021-07-05 17:02:52','2021-07-05 17:02:54'),(109,107,'金丝雀',1,3,'2021-07-05 17:03:10','2021-07-05 17:03:11'),(110,107,'点颏',1,3,'2021-07-05 17:03:30','2021-07-05 17:03:32'),(111,101,'表演技艺类',1,2,'2021-07-05 17:03:56','2021-07-05 17:03:57'),(112,111,'蜡嘴',1,3,'2021-07-05 17:04:10','2021-07-05 17:04:12'),(113,111,'锡嘴',1,3,'2021-07-05 17:04:42','2021-07-05 17:04:43'),(114,111,'黄雀',1,3,'2021-07-05 17:05:01','2021-07-05 17:05:03'),(115,101,'观赏类',1,2,'2021-07-05 17:05:30','2021-07-05 17:05:31'),(116,115,'金丝雀',1,3,'2021-07-05 17:05:50','2021-07-05 17:05:53'),(117,115,'文鸟',1,3,'2021-07-05 17:06:06','2021-07-05 17:06:09'),(118,0,'宠物蜘蛛',1,1,'2021-07-05 17:06:47','2021-07-05 17:06:49'),(119,118,'小型蜘蛛',1,2,'2021-07-05 17:07:04','2021-07-05 17:07:06'),(120,119,'泰国金属蓝',1,3,'2021-07-05 17:07:45','2021-07-05 17:07:47'),(121,118,'中型蜘蛛',1,2,'2021-07-05 17:08:44','2021-07-05 17:08:46'),(122,121,'智利红玫瑰',1,3,'2021-07-05 17:09:31','2021-07-05 17:09:32'),(123,121,'墨西哥红膝蛛',1,3,'2021-07-05 17:10:11','2021-07-05 17:10:13'),(124,121,'墨西哥火脚蛛',1,3,'2021-07-05 17:10:38','2021-07-05 17:10:40'),(125,121,'洪都拉斯卷毛',1,3,'2021-07-05 17:10:55','2021-07-05 17:10:57'),(126,121,'巴西白膝头',1,3,'2021-07-05 17:11:20','2021-07-05 17:11:22'),(127,118,'大型蜘蛛',1,2,'2021-07-05 17:11:43','2021-07-05 17:11:45'),(128,127,'食鸟蛛',1,3,'2021-07-05 17:12:01','2021-07-05 17:12:03'),(129,0,'宠物蜥蜴',1,1,'2021-07-05 17:12:24','2021-07-05 17:12:26'),(130,129,'绿色蜥蜴',1,2,'2021-07-05 17:13:06','2021-07-05 17:13:08'),(131,130,'丽纹龙蜥',1,3,'2021-07-05 17:13:27','2021-07-05 17:13:28'),(132,130,'高冠变色龙',1,3,'2021-07-05 17:13:47','2021-07-05 17:13:50'),(133,130,'绿鬣蜥',1,3,'2021-07-05 17:14:15','2021-07-05 17:14:18'),(134,130,'绿水龙',1,3,'2021-07-05 17:14:47','2021-07-05 17:14:49'),(135,129,'黄色蜥蜴',1,2,'2021-07-05 17:15:20','2021-07-05 17:15:22'),(136,135,'豹纹守宫',1,3,'2021-07-05 17:15:41','2021-07-05 17:15:43'),(137,135,'鬃狮蜥',1,3,'2021-07-05 17:16:06','2021-07-05 17:16:08'),(138,135,'蛙眼守宫',1,3,'2021-07-05 17:16:32','2021-07-05 17:16:33'),(139,129,'其他种类',1,2,'2021-07-05 17:16:53','2021-07-05 17:16:55'),(140,139,'大壁虎',1,3,'2021-07-05 17:17:09','2021-07-05 17:17:11'),(141,0,'其他宠物',1,1,'2021-07-05 17:17:39','2021-07-05 17:17:41'),(142,141,'宠物猪',1,2,'2021-07-05 17:17:59','2021-07-05 17:18:01'),(143,142,'茶杯猪',1,3,'2021-07-05 17:18:23','2021-07-05 17:18:25'),(144,142,'胡利亚尼猪',1,3,'2021-07-05 17:18:40','2021-07-05 17:18:42'),(145,141,'宠物蛇',1,2,'2021-07-05 17:19:05','2021-07-05 17:19:07'),(146,145,'玉米蛇',1,3,'2021-07-05 17:19:54','2021-07-05 17:19:55'),(147,145,'王蛇',1,3,'2021-07-05 17:20:17','2021-07-05 17:20:19'),(148,145,'奶蛇',1,3,'2021-07-05 17:20:37','2021-07-05 17:20:39'),(149,145,'棕黑锦蛇',1,3,'2021-07-05 17:21:12','2021-07-05 17:21:13'),(150,145,'中华水蛇',1,3,'2021-07-05 17:21:32','2021-07-05 17:21:33'),(151,141,'其他小型昆虫',1,2,'2021-07-05 17:21:54','2021-07-05 17:21:56'),(152,151,'蟋蟀',1,3,'2021-07-05 17:22:19','2021-07-05 17:22:22'),(153,151,'独角仙',1,3,'2021-07-05 17:22:34','2021-07-05 17:22:36'),(154,151,'蝎子',1,3,'2021-07-05 17:22:49','2021-07-05 17:22:51'),(155,151,'蝈蝈',1,3,'2021-07-05 17:23:02','2021-07-05 17:23:04');

/*Table structure for table `item_desc` */

DROP TABLE IF EXISTS `item_desc`;

CREATE TABLE `item_desc` (
  `id` int(50) NOT NULL,
  `item_id` varchar(64) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `videourl` varchar(512) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `item_desc` */

insert  into `item_desc`(`id`,`item_id`,`image`,`videourl`,`created`,`updated`) values (1,'1',NULL,NULL,NULL,NULL);

/*Table structure for table `itemorder` */

DROP TABLE IF EXISTS `itemorder`;

CREATE TABLE `itemorder` (
  `order_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '订单号',
  `item_id` int(10) DEFAULT NULL COMMENT '商品ID',
  `item_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `item_desc` varchar(512) DEFAULT NULL COMMENT '商品描述',
  `orimoney` int(11) DEFAULT NULL COMMENT '商品价格',
  `orderstatus` int(11) DEFAULT 0 COMMENT '订单状态',
  `user_id` int(10) DEFAULT NULL COMMENT '买家ID',
  `seller_id` int(10) DEFAULT NULL COMMENT '卖家ID',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4;

/*Data for the table `itemorder` */

/*Table structure for table `navigate` */

DROP TABLE IF EXISTS `navigate`;

CREATE TABLE `navigate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `path` varchar(50) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3;

/*Data for the table `navigate` */

insert  into `navigate`(`id`,`name`,`parent_id`,`path`,`level`,`created`,`updated`) values (1,'用户管理',0,NULL,1,NULL,NULL),(2,'用户列表',1,'/user',2,NULL,NULL),(3,'商品管理',0,NULL,1,NULL,NULL),(4,'商品列表',3,'/item',2,NULL,NULL),(5,'商品分类',3,'/itemCate',2,NULL,NULL),(6,'权限管理',0,NULL,1,NULL,NULL),(7,'角色列表',6,'/role',2,NULL,NULL),(8,'权限列表',6,'/rights',2,NULL,NULL),(9,'订单管理',0,NULL,1,NULL,NULL),(10,'订单列表',9,'/orders',2,NULL,NULL),(11,'通知管理',0,NULL,1,NULL,NULL),(12,'通知列表',11,'/notices',2,NULL,NULL),(13,'日志管理',0,NULL,1,NULL,NULL),(14,'登录日志',13,'/loginLog',2,NULL,NULL),(15,'操作日志',13,'/operateLog',2,NULL,NULL),(16,'管理员列表',1,'/manager',2,NULL,NULL);

/*Table structure for table `navigate_front` */

DROP TABLE IF EXISTS `navigate_front`;

CREATE TABLE `navigate_front` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL COMMENT '导航栏',
  `path` varchar(50) NOT NULL COMMENT '指定vue组件路径',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

/*Data for the table `navigate_front` */

insert  into `navigate_front`(`id`,`name`,`path`,`created`,`updated`) values (1,'个人信息','/myInfo',NULL,NULL),(2,'我的商品','/myItems',NULL,NULL),(3,'我的收藏','/myFavorite',NULL,NULL);

/*Table structure for table `user_info` */

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info` (
  `user_id` int(50) NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `uimage` varchar(255) DEFAULT NULL COMMENT '头像',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `sex` int(5) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `userstatus` tinyint(1) DEFAULT NULL COMMENT '用户是否在线',
  `status` tinyint(1) DEFAULT NULL COMMENT '账号是否正常',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb3;

/*Data for the table `user_info` */

insert  into `user_info`(`user_id`,`username`,`password`,`phone`,`uimage`,`email`,`sex`,`city`,`userstatus`,`status`,`created`,`updated`) values (7,'admin','81dc9bdb52d04dc20036dbd8313ed055','13551411513','http://image.ipet.com/2021/07/19/812c6d47fd384e1d95c632d4d3239638.jpg','123@qq.com',1,'[\"51\",\"5101\",\"510117\"]',1,1,'2021-07-09 19:26:55','2021-07-27 09:17:59'),(8,'admin1','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','897455@qq.com',1,NULL,0,1,'2021-07-09 19:26:55','2021-07-19 09:25:23'),(9,'admin2','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8974554@qq.com',1,NULL,0,1,'2021-07-09 19:27:04','2021-07-17 10:08:34'),(10,'admin3','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','89745547@qq.com',1,NULL,0,1,'2021-07-09 19:27:04','2021-07-09 19:27:04'),(11,'user1','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8@qq.com',1,'[\"11\",\"1101\",\"110101\"]',1,1,'2021-07-09 19:27:04','2021-07-27 18:07:17'),(12,'user2','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','89@qq.com',1,NULL,0,0,'2021-07-09 19:27:34','2021-07-19 09:17:33'),(13,'user3','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','897@qq.com',1,NULL,0,0,'2021-07-09 19:27:36','2021-07-19 09:26:36'),(14,'user4','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','89575@qq.com',1,NULL,0,1,'2021-07-09 19:27:37','2021-07-26 09:25:48'),(15,'user5','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','897455178778@qq.com',1,'[\"51\",\"5101\",\"510106\"]',0,1,'2021-07-09 19:27:38','2021-07-24 10:09:20'),(16,'user6','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','891@qq.com',1,NULL,0,1,'2021-07-09 19:27:38','2021-07-09 19:27:38'),(17,'user7','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','892@qq.com',1,NULL,0,1,'2021-07-09 19:27:38','2021-07-09 19:27:38'),(18,'usre8','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','893@qq.com',1,NULL,0,1,'2021-07-09 19:27:38','2021-07-09 19:27:38'),(19,'user9','81dc9bdb52d04dc20036dbd8313ed055','13551411513','http://image.jt.com/2021/16/15/c16adc5272014b4b85a72e6e17cdabe7.jpg','894@qq.com',1,NULL,0,1,'2021-07-09 19:27:38','2021-07-17 10:08:10'),(20,'user10','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','895@qq.com',1,NULL,0,1,'2021-07-09 19:27:39','2021-07-09 19:27:39'),(21,'user11','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','896@qq.com',1,NULL,0,1,'2021-07-09 19:27:39','2021-07-09 19:27:39'),(22,'user12','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','898@qq.com',1,NULL,0,1,'2021-07-09 19:27:39','2021-07-24 13:32:11'),(23,'user13','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','899@qq.com',1,NULL,0,1,'2021-07-09 19:27:39','2021-07-09 19:27:39'),(24,'user14','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8911@qq.com',1,NULL,0,1,'2021-07-09 19:28:29','2021-07-09 19:28:29'),(25,'user15','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8912@qq.com',1,NULL,0,1,'2021-07-09 19:28:29','2021-07-09 19:28:29'),(26,'user16','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8913@qq.com',1,NULL,0,1,'2021-07-09 19:28:29','2021-07-09 19:28:29'),(27,'user17','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8914@qq.com',1,NULL,0,1,'2021-07-09 19:28:29','2021-07-09 19:28:29'),(28,'user18','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8915@qq.com',1,NULL,0,1,'2021-07-09 19:28:30','2021-07-09 19:28:30'),(29,'user19','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8916@qq.com',1,NULL,0,1,'2021-07-09 19:28:30','2021-07-17 09:29:12'),(30,'user20','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8917@qq.com',1,NULL,0,1,'2021-07-09 19:28:30','2021-07-09 19:28:30'),(31,'user21','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8918@qq.com',1,NULL,0,1,'2021-07-09 19:28:30','2021-07-09 19:28:30'),(32,'user22','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8919@qq.com',1,NULL,0,1,'2021-07-09 19:28:30','2021-07-24 10:08:49'),(33,'user23','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8920@qq.com',1,NULL,0,1,'2021-07-09 19:28:30','2021-07-09 19:28:30'),(34,'user24','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8921@qq.com',1,NULL,0,1,'2021-07-09 19:28:31','2021-07-09 19:28:31'),(35,'user25','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8922@qq.com',1,NULL,0,1,'2021-07-09 19:28:31','2021-07-26 20:59:28'),(36,'user26','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8923@qq.com',1,NULL,0,1,'2021-07-09 19:28:31','2021-07-09 19:28:31'),(37,'user27','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8924@qq.com',1,NULL,0,1,'2021-07-09 19:28:31','2021-07-26 21:01:35'),(38,'user28','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8925@qq.com',1,NULL,0,1,'2021-07-09 19:28:32','2021-07-09 19:28:32'),(39,'user29','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8926@qq.com',1,NULL,0,1,'2021-07-09 19:28:32','2021-07-09 19:28:32'),(40,'user30','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8927@qq.com',1,NULL,0,1,'2021-07-09 19:28:32','2021-07-09 19:28:32'),(41,'user31','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8928@qq.com',1,NULL,0,1,'2021-07-09 19:28:32','2021-07-09 19:28:32'),(42,'user32','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8929@qq.com',1,NULL,0,1,'2021-07-09 19:28:33','2021-07-09 19:28:33'),(43,'user33','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8930@qq.com',1,NULL,0,1,'2021-07-09 19:28:33','2021-07-09 19:28:33'),(44,'user34','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8931@qq.com',1,NULL,0,1,'2021-07-09 19:28:33','2021-07-09 19:28:33'),(45,'user35','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8932@qq.com',1,NULL,0,1,'2021-07-09 19:28:33','2021-07-09 19:28:33'),(46,'user36','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8933@qq.com',1,NULL,0,1,'2021-07-09 19:28:33','2021-07-26 20:26:10'),(47,'user37','81dc9bdb52d04dc20036dbd8313ed055','13551411513','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','8934@qq.com',1,NULL,0,1,'2021-07-09 19:28:33','2021-07-26 20:24:40'),(48,'luojunsong','81dc9bdb52d04dc20036dbd8313ed055','15412454475','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','1192231291@qq.com',1,NULL,0,1,'2021-07-09 19:56:07','2021-07-09 19:56:07'),(50,'luojunsong1','81dc9bdb52d04dc20036dbd8313ed055','14522445568','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','1192231292@qq.com',1,NULL,0,1,'2021-07-09 20:01:46','2021-07-09 20:01:46'),(51,'luojunsong2','81dc9bdb52d04dc20036dbd8313ed055','13256455454','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','1192231293@qq.com',1,NULL,0,1,'2021-07-09 20:11:29','2021-07-09 20:11:29'),(52,'luojunsong3','81dc9bdb52d04dc20036dbd8313ed055','15354758617','https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png','1192231290@qq.com',1,NULL,0,1,'2021-07-10 11:23:26','2021-07-10 11:23:26');

/*Table structure for table `user_perm` */

DROP TABLE IF EXISTS `user_perm`;

CREATE TABLE `user_perm` (
  `role_id` int(11) DEFAULT NULL,
  `perms` varchar(255) DEFAULT NULL COMMENT '对应权限',
  `mean` varchar(255) DEFAULT NULL COMMENT '权限解释'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `user_perm` */

insert  into `user_perm`(`role_id`,`perms`,`mean`) values (1,NULL,'不可登录后台'),(2,NULL,'仅审核信息'),(3,NULL,'可以修改其他用户权限');

/*Table structure for table `user_role` */

DROP TABLE IF EXISTS `user_role`;

CREATE TABLE `user_role` (
  `user_id` int(50) NOT NULL,
  `role_id` int(11) DEFAULT 1,
  `identity` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `user_role` */

insert  into `user_role`(`user_id`,`role_id`,`identity`) values (7,3,'超级管理员'),(8,2,'管理员'),(9,2,'管理员'),(10,2,'管理员'),(11,1,'普通用户'),(12,1,'普通用户'),(13,1,'普通用户'),(14,1,'普通用户'),(15,1,'普通用户'),(16,1,'普通用户'),(17,1,'普通用户'),(18,1,'普通用户'),(19,1,'普通用户'),(20,1,'普通用户'),(21,1,'普通用户'),(22,1,'普通用户'),(23,1,'普通用户'),(24,1,'普通用户'),(25,1,'普通用户'),(26,1,'普通用户'),(27,1,'普通用户'),(28,1,'普通用户'),(29,1,'普通用户'),(30,1,'普通用户'),(31,1,'普通用户'),(32,1,'普通用户'),(33,1,'普通用户'),(34,1,'普通用户'),(35,1,'普通用户'),(36,1,'普通用户'),(37,1,'普通用户'),(38,1,'普通用户'),(39,1,'普通用户'),(40,1,'普通用户'),(41,1,'普通用户'),(42,1,'普通用户'),(43,1,'普通用户'),(44,1,'普通用户'),(45,1,'普通用户'),(46,1,'普通用户'),(47,1,'普通用户'),(48,1,'普通用户'),(49,1,'普通用户'),(50,1,'普通用户'),(51,1,'普通用户'),(52,1,'普通用户');

/*!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 */;