master

分支 (1)

管理

管理

master

NewGitee
/
saleslibrary.sql

/*
SQLyog Ultimate v12.14 (64 bit)
MySQL - 8.0.21 : Database - saleslibrary
*********************************************************************
*/

/*!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*/`saleslibrary` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `saleslibrary`;

/*Table structure for table `article` */

DROP TABLE IF EXISTS `article`;

CREATE TABLE `article` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容',
  `user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发布人',
  `time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `article` */

insert  into `article`(`id`,`name`,`content`,`user`,`time`) values
(1,'青哥哥的文章标题','# 我是青哥哥\n## 我是青哥哥2号\n\n::: hljs-center\n\n***++~~==我是那个哥哥==~~++***\n\n:::\n\n> 我是青哥哥的引用\n\n我是B站：程序员青戈\n\n[百度](https://www.baidu.com)\n\n```java\nclass Hello {\n  public static void main(String[] args) {\n    System.out.pringln(\"Hello 青哥哥\");\n  }\n}\n\n```\n\n![搜狗截图20220129174103.png](http://localhost:9090/file/8567a00d2bf740e0a63794baf600cec3.png)\n\n\n','程序员青戈','2022-03-22 19:22:58'),
(2,'青哥哥文章2号','青哥哥文章2号\n\n青哥哥文章2号\n\n青哥哥文章2号\n\n![QQ图片20220307194920.png](http://localhost:9090/file/5e40a867acd74d1f90b0ac9a765823e5.png)','程序员青戈','2022-03-22 19:22:58');

/*Table structure for table `course` */

DROP TABLE IF EXISTS `course`;

CREATE TABLE `course` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '课程名称',
  `score` int DEFAULT NULL COMMENT '学分',
  `times` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '上课时间',
  `state` tinyint(1) DEFAULT NULL COMMENT '是否开课',
  `teacher_id` int DEFAULT NULL COMMENT '授课老师id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `course` */

insert  into `course`(`id`,`name`,`score`,`times`,`state`,`teacher_id`) values
(1,'大学物理',10,'40',0,17),
(2,'高等数学',10,'45',NULL,16),
(3,'大学英语',10,'30',NULL,16);

/*Table structure for table `files` */

DROP TABLE IF EXISTS `files`;

CREATE TABLE `files` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名称',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件类型',
  `size` bigint DEFAULT NULL COMMENT '文件大小(kb)',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '下载链接',
  `md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件md5',
  `is_delete` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  `enable` tinyint(1) DEFAULT '1' COMMENT '是否禁用链接',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `files` */

insert  into `files`(`id`,`name`,`type`,`size`,`url`,`md5`,`is_delete`,`enable`) values
(83,'1.jpg','jpg',90,'http://localhost:43210/files/ef300b19e3bf4c4a824e2a916967f394.jpg','40527467e1aa6c93cbb4d67886a64215',0,1),
(84,'2.jpg','jpg',94,'http://localhost:43210/files/2c3bfcad7a344806ac5972b84d1d2e6d.jpg','9dfbfa5ca87f73edc67590de15426178',0,1),
(85,'4.jpg','jpg',73,'http://localhost:43210/files/c450139bd044481aba1424bf75608805.jpg','b1e23db70999b337f7adcff92a723613',0,1),
(86,'7bb345224b292bc4.jpg','jpg',148,'http://localhost:43210/files/b61bf2e891ac498a93e719e1fe953b7c.jpg','5792b0f6718ac9be6f83b364162fd37d',0,1),
(87,'795a0fbc19c11a0f9576e4cf4d8a17da.gif','gif',3095,'http://localhost:43210/files/69f558d7bc314003b8ec8088b80443f6.gif','795a0fbc19c11a0f9576e4cf4d8a17da',0,1),
(88,'752b848a94c258bd.jpg','jpg',448,'http://localhost:43210/files/c2ed68ff081f4bdcbfa22cd47800c36b.jpg','8b9b0e66867cf5169843e9e5ea2ed7d1',0,1),
(89,'aec3797d7.jpg','jpg',23,'http://localhost:43210/files/f0de58b73ae84179a0c558237446e6f9.jpg','8e761247133ff0be64579303025d8fa1',0,1),
(90,'5.jpg','jpg',67,'http://localhost:43210/files/2b6ca2645c774f9f8f76e6e68b527904.jpg','97a5254d8876b79c1be6d82fe65478a7',0,1),
(91,'1.jpg','jpg',90,'http://localhost:43210/files/ef300b19e3bf4c4a824e2a916967f394.jpg','40527467e1aa6c93cbb4d67886a64215',0,1);

/*Table structure for table `goods` */

DROP TABLE IF EXISTS `goods`;

CREATE TABLE `goods` (
  `gid` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商品号',
  `gname` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '商品名',
  `gkind` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '商品分类',
  `gunit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '商品单位',
  `gprice` double DEFAULT NULL COMMENT '商品价格',
  `gsaleprice` double DEFAULT NULL COMMENT '商品售价',
  `gintroduce` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '商品说明',
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `goods` */

insert  into `goods`(`gid`,`gname`,`gkind`,`gunit`,`gprice`,`gsaleprice`,`gintroduce`) values
('6921734966001','中性笔','文具','支',0.7,1,'得力中性笔，书桌好伙伴'),
('6971771080574','甜玉米肠','食品','根',0.7,1,'新鲜常在，美味常在');

/*Table structure for table `inventory` */

DROP TABLE IF EXISTS `inventory`;

CREATE TABLE `inventory` (
  `inid` int NOT NULL AUTO_INCREMENT COMMENT '库存号',
  `gid` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商品号',
  `inquantity` double DEFAULT NULL COMMENT '库存数量',
  `inInportDate` datetime DEFAULT NULL COMMENT '入库时间',
  `inallprice` double DEFAULT NULL COMMENT '总价',
  PRIMARY KEY (`inid`,`gid`),
  KEY `gid` (`gid`),
  CONSTRAINT `inventory_ibfk_1` FOREIGN KEY (`gid`) REFERENCES `goods` (`gid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `inventory` */

insert  into `inventory`(`inid`,`gid`,`inquantity`,`inInportDate`,`inallprice`) values
(1,'6921734966001',1000,'2023-09-27 14:47:51',1000),
(2,'6971771080574',200,'2023-09-27 14:48:21',200);

/*Table structure for table `salerecords` */

DROP TABLE IF EXISTS `salerecords`;

CREATE TABLE `salerecords` (
  `said` int NOT NULL AUTO_INCREMENT COMMENT '销售记录号',
  `gid` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '销售商品号',
  `uid` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '购买用户',
  `saquantity` double DEFAULT NULL COMMENT '购买数量',
  `saTime` datetime DEFAULT NULL COMMENT '购买时间',
  `saprice` double DEFAULT NULL COMMENT '购买价格',
  `saAllprice` double DEFAULT NULL COMMENT '总价',
  `isPay` tinyint(1) DEFAULT NULL COMMENT '是否支付',
  `isDelivery` tinyint(1) DEFAULT NULL COMMENT '是否发货',
  PRIMARY KEY (`said`),
  KEY `gid` (`gid`),
  KEY `uid` (`uid`),
  CONSTRAINT `salerecords_ibfk_1` FOREIGN KEY (`gid`) REFERENCES `goods` (`gid`),
  CONSTRAINT `salerecords_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `salerecords` */

insert  into `salerecords`(`said`,`gid`,`uid`,`saquantity`,`saTime`,`saprice`,`saAllprice`,`isPay`,`isDelivery`) values
(1,'6921734966001','27',1,'2023-09-27 14:51:18',1,1,1,1),
(3,'6921734966001','27',2,'2023-09-27 17:22:02',2,2,1,1);

/*Table structure for table `supply` */

DROP TABLE IF EXISTS `supply`;

CREATE TABLE `supply` (
  `sid` int NOT NULL AUTO_INCREMENT COMMENT '供货记录号',
  `gid` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '商品号',
  `uid` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '供货商',
  `squantity` double DEFAULT NULL COMMENT '供货数量',
  `sdatetime` datetime DEFAULT NULL COMMENT '供货时间',
  `sallprice` double DEFAULT NULL COMMENT '商品总价',
  `isPay` tinyint(1) DEFAULT NULL COMMENT '是否支付',
  `isReceipt` tinyint(1) DEFAULT NULL COMMENT '是否收货',
  PRIMARY KEY (`sid`),
  KEY `gid` (`gid`),
  KEY `uid` (`uid`),
  CONSTRAINT `supply_ibfk_1` FOREIGN KEY (`gid`) REFERENCES `goods` (`gid`),
  CONSTRAINT `supply_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2139160579 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `supply` */

insert  into `supply`(`sid`,`gid`,`uid`,`squantity`,`sdatetime`,`sallprice`,`isPay`,`isReceipt`) values
(1,'6921734966001','27',1,'2023-09-27 14:49:45',1,1,0),
(318832642,'6921734966001','26',1000,'2023-09-27 14:57:26',1000,0,0),
(1237385218,'6971771080574','26',200,'2023-09-27 14:56:18',200,1,1);

/*Table structure for table `sys_menu` */

DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE `sys_menu` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路径',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `pid` int DEFAULT NULL COMMENT '父级id',
  `page_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '页面路径',
  `sort_num` int DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `sys_menu` */

insert  into `sys_menu`(`id`,`name`,`path`,`icon`,`description`,`pid`,`page_path`,`sort_num`) values
(0,'图形主页','/homeSSS','el-icon-house','图形主页',NULL,'../views/HomeSSS.vue',1),
(1,'系统管理',NULL,'el-icon-message','系统管理组头列表',NULL,NULL,1),
(2,'事务管理',NULL,'el-icon-menu','事务管理组头列表',NULL,NULL,1),
(3,'其他功能',NULL,'el-icon-s-tools','其他功能组头列表',NULL,NULL,1),
(5,'用户管理','/user','el-icon-user','用户管理页面',1,'../views/系统管理/User.vue',1),
(6,'角色管理','/role','el-icon-s-custom','角色管理页面',3,'../views/系统管理/Role.vue',1),
(7,'菜单管理','/menu','el-icon-menu','菜单管理页面',3,'../views/系统管理/Menu.vue',1),
(8,'商品管理','/goods','el-icon-s-shop','商品管理页面',1,'../views/系统管理/Goods.vue',1),
(9,'仓储管理','/inventory','el-icon-wallet','仓库管理页面',1,'../views/系统管理/Inventory.vue',1),
(10,'销售管理','/salerecords','el-icon-s-goods','销售管理页面',2,'../views/事务管理/SaleRecords.vue',1),
(11,'供货管理','/supply','el-icon-s-help','供货管理页面',2,'../views/事务管理/Supply.vue',1),
(12,'供货商页面','/supplier','el-icon-house','供货商主页',NULL,NULL,1),
(13,'供货记录页面','/supplycount','el-icon-time','供货商供货记录管理',NULL,NULL,1),
(14,'客户页面','/customer','el-icon-s-goods','客户主页',NULL,NULL,1),
(15,'客户购物记录页面','/customercount','el-icon-time','客户购物记录管理',NULL,NULL,NULL),
(16,'系统说明页','/introduce','el-icon-warning','系统说明页面',NULL,NULL,1),
(17,'主页','/home','el-icon-house','说明主页',NULL,'../views/Home.vue',1);

/*Table structure for table `sys_role` */

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `flag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '唯一标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `sys_role` */

insert  into `sys_role`(`id`,`name`,`description`,`flag`) values
(1,'管理员','管理员','ROLE_ADMIN'),
(2,'用户','用户','ROLE_USER'),
(3,'供货商','供货商','ROLE_SUPPLY');

/*Table structure for table `sys_role_menu` */

DROP TABLE IF EXISTS `sys_role_menu`;

CREATE TABLE `sys_role_menu` (
  `role_id` int NOT NULL COMMENT '角色id',
  `menu_id` int NOT NULL COMMENT '菜单id',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='角色菜单关系表';

/*Data for the table `sys_role_menu` */

insert  into `sys_role_menu`(`role_id`,`menu_id`) values
(1,1),
(1,2),
(1,3),
(1,4),
(1,5),
(1,6),
(1,7),
(1,8),
(1,9),
(1,10),
(1,11),
(1,16),
(1,17),
(2,14),
(2,15),
(3,12),
(3,13);

/*Table structure for table `sys_user` */

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电话',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像',
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '角色',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `sys_user` */

insert  into `sys_user`(`id`,`username`,`password`,`nickname`,`email`,`phone`,`address`,`create_time`,`avatar_url`,`role`) values
(1,'admin','admin','程序员青戈','admin@qq.com','13988997788','安徽合肥1','2022-01-22 21:10:27','http://localhost:9090/file/8d966b0e6cf84fe191a72a58b8293b23.png','ROLE_ADMIN'),
(16,'222','123','甄姬好大','2','2','2','2022-02-26 22:10:14',NULL,'ROLE_TEACHER'),
(17,'333','123','我是三三哦豁','3','3','3','2022-02-26 22:10:18','http://localhost:9090/file/7737484487db47ab89e58504ddf86ac1.jpg','ROLE_TEACHER'),
(18,'nzz','123','哪吒','2','2','2','2022-03-29 16:59:44','','ROLE_STUDENT'),
(19,'yss','123','亚瑟','3','3','3','2022-04-29 16:59:44','','ROLE_STUDENT'),
(20,'lxx','123','李信','2','2','2','2022-05-29 17:12:04','2','ROLE_STUDENT'),
(25,'sir','123','安琪拉',NULL,NULL,NULL,'2022-06-08 17:00:47',NULL,'ROLE_STUDENT'),
(26,'err',NULL,'妲己','11','1','1','2022-07-08 17:20:01',NULL,'ROLE_STUDENT'),
(28,'ddd','123','ddd','','','','2022-11-09 10:41:07','http://localhost:9090/file/7de0e50f915547539db12023cf997276.jpg','ROLE_STUDENT'),
(29,'ffff','123',NULL,NULL,NULL,NULL,'2022-12-10 11:53:31',NULL,'ROLE_STUDENT');

/*Table structure for table `t_comment` */

DROP TABLE IF EXISTS `t_comment`;

CREATE TABLE `t_comment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '内容',
  `user_id` int DEFAULT NULL COMMENT '评论人id',
  `time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '评论时间',
  `pid` int DEFAULT NULL COMMENT '父id',
  `origin_id` int DEFAULT NULL COMMENT '最上级评论id',
  `article_id` int DEFAULT NULL COMMENT '关联文章的id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `t_comment` */

insert  into `t_comment`(`id`,`content`,`user_id`,`time`,`pid`,`origin_id`,`article_id`) values
(1,'测试测试',1,'2022-03-22 20:00:00',NULL,NULL,1),
(2,'123',NULL,NULL,NULL,NULL,NULL),
(5,'回复内容',1,'2022-03-22 21:01:00',NULL,NULL,1),
(6,'4444',1,'2022-03-22 21:03:15',4,4,1),
(7,'5555',1,'2022-03-22 21:04:11',4,4,1),
(8,'444444',1,'2022-03-22 21:29:55',7,7,1),
(9,'5555',1,'2022-03-22 21:30:04',7,7,1),
(10,'666',1,'2022-03-22 21:34:05',7,4,1),
(11,'甄姬真的好大好大！！',16,'2022-03-22 21:38:26',10,4,1),
(13,'哈哈哈哈，我是ddd',28,'2022-03-22 21:46:01',12,12,1),
(14,'我是李信，我很萌',20,'2022-03-22 21:46:48',13,12,1),
(15,'我在回复ddd',20,'2022-03-22 21:47:03',13,12,1),
(16,'我是李信',20,'2022-03-22 21:48:19',4,4,1),
(17,'33333',20,'2022-03-22 21:48:42',5,5,1),
(19,'我是李信嗯嗯嗯',20,'2022-03-22 21:49:21',1,1,1),
(21,'哈哈哈 我是ddd',28,'2022-03-22 21:50:04',20,1,1);

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `uid` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户编号',
  `uname` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '用户名',
  `upassword` varchar(18) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码',
  `identity` enum('用户','管理员','供货商') CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '用户身份',
  `loginTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  `ulastComing` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '上次登录时间',
  `secretProtection` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '密保问题',
  `secretAnswer` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '密保答案',
  `avatarUrl` varchar(300) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `user` */

insert  into `user`(`uid`,`uname`,`upassword`,`identity`,`loginTime`,`ulastComing`,`secretProtection`,`secretAnswer`,`avatarUrl`) values
('12112212','1212','12112212','管理员','2023-06-08 10:47:25','2023-09-22 10:47:25',NULL,NULL,NULL),
('2222222222222','2号','2222222222222','用户','2023-05-18 09:38:02','2023-09-12 09:38:06',NULL,NULL,NULL),
('23','23','23','管理员','2023-04-21 08:54:56','2023-09-22 08:54:56',NULL,NULL,NULL),
('2312','2图标','2312','管理员','2023-01-05 10:13:24','2023-09-26 10:13:26',NULL,NULL,NULL),
('23452','234','63443','用户','2023-02-17 10:13:28','2023-09-26 10:13:29',NULL,NULL,NULL),
('2352','2352','23452','用户','2023-02-10 10:13:31','2023-09-26 10:13:34',NULL,NULL,NULL),
('2353','2524','234524','用户','2023-09-26 10:13:38','2023-09-26 10:13:36',NULL,NULL,NULL),
('24','24','24','管理员','2023-11-22 08:55:09','2023-09-22 08:55:09',NULL,NULL,NULL),
('26','26','26','供货商','2023-09-22 08:55:20','2023-09-22 08:55:20',NULL,NULL,NULL),
('27','27','27','用户','2023-09-22 08:55:24','2023-09-22 08:55:24',NULL,NULL,NULL),
('28','28','28','供货商','2023-09-22 08:55:39','2023-09-22 08:55:39',NULL,NULL,NULL),
('323232','323232','323232','用户','2023-09-22 08:49:59','2023-09-22 08:49:59',NULL,NULL,NULL),
('333','333','333','用户','2023-09-19 15:15:07','2023-09-19 15:15:07',NULL,NULL,NULL),
('434343','434343','434343','用户','2023-09-22 08:45:01','2023-09-22 08:45:01',NULL,NULL,NULL),
('444','444','111','管理员','2023-09-19 15:15:07','2023-09-19 15:15:07','1','1','http://localhost:43210/files/ef300b19e3bf4c4a824e2a916967f394.jpg'),
('454545','454545','454545','用户','2023-02-23 08:42:25','2023-09-22 08:42:25',NULL,NULL,NULL),
('545454','545454','545454','用户','2023-05-04 08:52:42','2023-09-22 08:52:42',NULL,NULL,NULL),
('555','555','555','用户','2023-06-19 15:15:07','2023-09-19 15:15:07',NULL,NULL,NULL),
('63542','2352','645','供货商','2023-10-18 14:12:57','2023-10-18 14:13:28',NULL,NULL,NULL),
('666','666','666','供货商','2023-06-16 15:15:07','2023-09-19 15:15:07',NULL,NULL,NULL),
('666666666','666666666','666666666','用户','2023-09-22 08:38:17','2023-09-22 08:38:17',NULL,NULL,NULL),
('745','456','3452','供货商','2023-10-18 14:13:50','2023-10-18 14:13:55',NULL,NULL,NULL),
('777','777','777','用户','2023-10-18 14:13:20','2023-10-18 14:13:23',NULL,NULL,NULL),
('787878','787878','787878','用户','2023-02-24 08:50:54','2023-09-22 08:50:54',NULL,NULL,NULL),
('888','888','888','用户','2023-09-19 15:15:07','2023-09-19 15:15:07',NULL,NULL,NULL);

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