插画约稿平台-计算机毕业设计源码+LW文档

开发语言：Java

框架：springboot

JDK版本：JDK1.8

服务器：tomcat7

数据库：mysql 5.7（一定要5.7版本）

数据库工具：Navicat11

开发软件：eclipse/myeclipse/idea

Maven包：Maven3.3.9

浏览器：谷歌浏览器

DROP TABLE IF EXISTS `address`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `address` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`address` varchar(200) NOT NULL COMMENT '地址',

`name` varchar(200) NOT NULL COMMENT '收货人',

`phone` varchar(200) NOT NULL COMMENT '电话',

`isdefault` varchar(200) NOT NULL COMMENT '是否默认地址[是/否]',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='地址';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `address`

--

LOCK TABLES `address` WRITE;

/*!40000 ALTER TABLE `address` DISABLE KEYS */;

INSERT INTO `address` VALUES (1,'2023-05-16 14:08:48',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2023-05-16 14:08:48',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2023-05-16 14:08:48',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2023-05-16 14:08:48',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2023-05-16 14:08:48',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2023-05-16 14:08:48',16,'宇宙银河系月球1号','月某','13823888886','是'),(7,'2023-05-16 14:08:48',17,'宇宙银河系黑洞1号','黑某','13823888887','是'),(8,'2023-05-16 14:08:48',18,'宇宙银河系地球1号','地某','13823888888','是');

/*!40000 ALTER TABLE `address` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cart`

--

DROP TABLE IF EXISTS `cart`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cart` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`tablename` varchar(200) DEFAULT 'chuchuang' COMMENT '商品表名',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`goodid` bigint(20) NOT NULL COMMENT '商品id',

`goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',

`picture` longtext COMMENT '图片',

`buynumber` int(11) NOT NULL COMMENT '购买数量',

`price` float DEFAULT NULL COMMENT '单价',

`discountprice` float DEFAULT NULL COMMENT '会员价',

`huashizhanghao` varchar(200) DEFAULT NULL COMMENT '商户名称',

`goodtype` varchar(200) DEFAULT NULL COMMENT '商品类型',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1684246347056 DEFAULT CHARSET=utf8 COMMENT='购物车表';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `cart`

--

LOCK TABLES `cart` WRITE;

/*!40000 ALTER TABLE `cart` DISABLE KEYS */;

/*!40000 ALTER TABLE `cart` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `chahuashi`

--

DROP TABLE IF EXISTS `chahuashi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `chahuashi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`huashizhanghao` varchar(200) NOT NULL COMMENT '画师账号',

`mima` varchar(200) NOT NULL COMMENT '密码',

`huashixingming` varchar(200) DEFAULT NULL COMMENT '画师姓名',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`leixing` varchar(200) DEFAULT NULL COMMENT '类型',

`fengge` varchar(200) DEFAULT NULL COMMENT '风格',

`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',

`zuopinwenjian` longtext COMMENT '作品文件',

`touxiang` longtext COMMENT '头像',

`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',

`shhf` longtext COMMENT '审核回复',

`money` float DEFAULT '0' COMMENT '余额',

PRIMARY KEY (`id`),

UNIQUE KEY `huashizhanghao` (`huashizhanghao`)

) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='插画师';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `chahuashi`

--

LOCK TABLES `chahuashi` WRITE;

/*!40000 ALTER TABLE `chahuashi` DISABLE KEYS */;

INSERT INTO `chahuashi` VALUES (21,'2023-05-16 14:08:48','画师账号1','123456','画师姓名1','男','类型1','风格1','773890001@qq.com','','upload/chahuashi_touxiang1.jpg','是','',200),(22,'2023-05-16 14:08:48','画师账号2','123456','画师姓名2','男','类型2','风格2','773890002@qq.com','','upload/chahuashi_touxiang2.jpg','是','',200),(23,'2023-05-16 14:08:48','画师账号3','123456','画师姓名3','男','类型3','风格3','773890003@qq.com','','upload/chahuashi_touxiang3.jpg','是','',200),(24,'2023-05-16 14:08:48','画师账号4','123456','画师姓名4','男','类型4','风格4','773890004@qq.com','','upload/chahuashi_touxiang4.jpg','是','',200),(25,'2023-05-16 14:08:48','画师账号5','123456','画师姓名5','男','类型5','风格5','773890005@qq.com','','upload/chahuashi_touxiang5.jpg','是','',200),(26,'2023-05-16 14:08:48','画师账号6','123456','画师姓名6','男','类型6','风格6','773890006@qq.com','','upload/chahuashi_touxiang6.jpg','是','',200),(27,'2023-05-16 14:08:48','画师账号7','123456','画师姓名7','男','类型7','风格7','773890007@qq.com','','upload/chahuashi_touxiang7.jpg','是','',200),(28,'2023-05-16 14:08:48','画师账号8','123456','画师姓名8','男','类型8','风格8','773890008@qq.com','','upload/chahuashi_touxiang8.jpg','是','',200);

/*!40000 ALTER TABLE `chahuashi` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `chuchuang`

--

DROP TABLE IF EXISTS `chuchuang`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `chuchuang` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`chuchuangbiaoti` varchar(200) DEFAULT NULL COMMENT '橱窗标题',

`chuchuangfenlei` varchar(200) DEFAULT NULL COMMENT '橱窗分类',

`chuangzuozhouqi` varchar(200) DEFAULT NULL COMMENT '创作周期',

`chuangzuojieduan` varchar(200) DEFAULT NULL COMMENT '创作阶段',

`xiajiashijian` date DEFAULT NULL COMMENT '下架时间',

`chuchuangxiangqing` longtext COMMENT '橱窗详情',

`chuchuangfengmian` longtext COMMENT '橱窗封面',

`huashizhanghao` varchar(200) DEFAULT NULL COMMENT '画师账号',

`huashixingming` varchar(200) DEFAULT NULL COMMENT '画师姓名',

`onelimittimes` int(11) DEFAULT NULL COMMENT '单限',

`alllimittimes` int(11) DEFAULT NULL COMMENT '库存',

`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',

`price` float NOT NULL COMMENT '价格',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='橱窗';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `chuchuang`

--

LOCK TABLES `chuchuang` WRITE;

/*!40000 ALTER TABLE `chuchuang` DISABLE KEYS */;

INSERT INTO `chuchuang` VALUES (41,'2023-05-16 14:08:48','橱窗标题1','橱窗分类1','24小时特快橱窗','创作阶段1','2023-05-16','橱窗详情1','upload/chuchuang_chuchuangfengmian1.jpg,upload/chuchuang_chuchuangfengmian2.jpg,upload/chuchuang_chuchuangfengmian3.jpg','画师账号1','画师姓名1',1,98,'2023-05-16 22:12:49',99.9),(42,'2023-05-16 14:08:48','橱窗标题2','橱窗分类2','24小时特快橱窗','创作阶段2','2023-05-16','橱窗详情2','upload/chuchuang_chuchuangfengmian2.jpg,upload/chuchuang_chuchuangfengmian3.jpg,upload/chuchuang_chuchuangfengmian4.jpg','画师账号2','画师姓名2',2,99,'2023-05-16 22:08:48',99.9),(43,'2023-05-16 14:08:48','橱窗标题3','橱窗分类3','24小时特快橱窗','创作阶段3','2023-05-16','橱窗详情3','upload/chuchuang_chuchuangfengmian3.jpg,upload/chuchuang_chuchuangfengmian4.jpg,upload/chuchuang_chuchuangfengmian5.jpg','画师账号3','画师姓名3',3,99,'2023-05-16 22:08:48',99.9),(44,'2023-05-16 14:08:48','橱窗标题4','橱窗分类4','24小时特快橱窗','创作阶段4','2023-05-16','橱窗详情4','upload/chuchuang_chuchuangfengmian4.jpg,upload/chuchuang_chuchuangfengmian5.jpg,upload/chuchuang_chuchuangfengmian6.jpg','画师账号4','画师姓名4',4,99,'2023-05-16 22:08:48',99.9),(45,'2023-05-16 14:08:48','橱窗标题5','橱窗分类5','24小时特快橱窗','创作阶段5','2023-05-16','橱窗详情5','upload/chuchuang_chuchuangfengmian5.jpg,upload/chuchuang_chuchuangfengmian6.jpg,upload/chuchuang_chuchuangfengmian7.jpg','画师账号5','画师姓名5',5,99,'2023-05-16 22:08:48',99.9),(46,'2023-05-16 14:08:48','橱窗标题6','橱窗分类6','24小时特快橱窗','创作阶段6','2023-05-16','橱窗详情6','upload/chuchuang_chuchuangfengmian6.jpg,upload/chuchuang_chuchuangfengmian7.jpg,upload/chuchuang_chuchuangfengmian8.jpg','画师账号6','画师姓名6',6,99,'2023-05-16 22:08:48',99.9),(47,'2023-05-16 14:08:48','橱窗标题7','橱窗分类7','24小时特快橱窗','创作阶段7','2023-05-16','橱窗详情7','upload/chuchuang_chuchuangfengmian7.jpg,upload/chuchuang_chuchuangfengmian8.jpg,upload/chuchuang_chuchuangfengmian9.jpg','画师账号7','画师姓名7',7,99,'2023-05-16 22:08:48',99.9),(48,'2023-05-16 14:08:48','橱窗标题8','橱窗分类8','24小时特快橱窗','创作阶段8','2023-05-16','橱窗详情8','upload/chuchuang_chuchuangfengmian8.jpg,upload/chuchuang_chuchuangfengmian9.jpg,upload/chuchuang_chuchuangfengmian10.jpg','画师账号8','画师姓名8',8,99,'2023-05-16 22:08:48',99.9);

/*!40000 ALTER TABLE `chuchuang` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `chuchuangfenlei`

--

DROP TABLE IF EXISTS `chuchuangfenlei`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `chuchuangfenlei` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`chuchuangfenlei` varchar(200) DEFAULT NULL COMMENT '橱窗分类',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='橱窗分类';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `chuchuangfenlei`

--

LOCK TABLES `chuchuangfenlei` WRITE;

/*!40000 ALTER TABLE `chuchuangfenlei` DISABLE KEYS */;

INSERT INTO `chuchuangfenlei` VALUES (61,'2023-05-16 14:08:48','橱窗分类1'),(62,'2023-05-16 14:08:48','橱窗分类2'),(63,'2023-05-16 14:08:48','橱窗分类3'),(64,'2023-05-16 14:08:48','橱窗分类4'),(65,'2023-05-16 14:08:48','橱窗分类5'),(66,'2023-05-16 14:08:48','橱窗分类6'),(67,'2023-05-16 14:08:48','橱窗分类7'),(68,'2023-05-16 14:08:48','橱窗分类8');

/*!40000 ALTER TABLE `chuchuangfenlei` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `config`

--

DROP TABLE IF EXISTS `config`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `config` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`name` varchar(100) NOT NULL COMMENT '配置参数名称',

`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `config`

--

LOCK TABLES `config` WRITE;

/*!40000 ALTER TABLE `config` DISABLE KEYS */;

INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');

/*!40000 ALTER TABLE `config` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `discusschuchuang`

--

DROP TABLE IF EXISTS `discusschuchuang`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discusschuchuang` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`refid` bigint(20) NOT NULL COMMENT '关联表id',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`avatarurl` longtext COMMENT '头像',

`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',

`content` longtext NOT NULL COMMENT '评论内容',

`reply` longtext COMMENT '回复内容',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='橱窗评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `discusschuchuang`

--

LOCK TABLES `discusschuchuang` WRITE;

/*!40000 ALTER TABLE `discusschuchuang` DISABLE KEYS */;

/*!40000 ALTER TABLE `discusschuchuang` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `discusshuashi`

--

DROP TABLE IF EXISTS `discusshuashi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discusshuashi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`refid` bigint(20) NOT NULL COMMENT '关联表id',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`avatarurl` longtext COMMENT '头像',

`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',

`content` longtext NOT NULL COMMENT '评论内容',

`reply` longtext COMMENT '回复内容',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='画师评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `discusshuashi`

--

LOCK TABLES `discusshuashi` WRITE;

/*!40000 ALTER TABLE `discusshuashi` DISABLE KEYS */;

/*!40000 ALTER TABLE `discusshuashi` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `discussyuegao`

--

DROP TABLE IF EXISTS `discussyuegao`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discussyuegao` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`refid` bigint(20) NOT NULL COMMENT '关联表id',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`avatarurl` longtext COMMENT '头像',

`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',

`content` longtext NOT NULL COMMENT '评论内容',

`reply` longtext COMMENT '回复内容',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='约稿评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `discussyuegao`

--

LOCK TABLES `discussyuegao` WRITE;

/*!40000 ALTER TABLE `discussyuegao` DISABLE KEYS */;

/*!40000 ALTER TABLE `discussyuegao` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `fenxiang`

--

DROP TABLE IF EXISTS `fenxiang`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `fenxiang` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`biaoti` varchar(200) DEFAULT NULL COMMENT '标题',

`leixing` varchar(200) DEFAULT NULL COMMENT '类型',

`laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',

`neirong` longtext COMMENT '内容',

`riqi` date DEFAULT NULL COMMENT '日期',

`fengmian` longtext COMMENT '封面',

`userid` bigint(20) DEFAULT NULL COMMENT '用户id',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='分享';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `fenxiang`

--

LOCK TABLES `fenxiang` WRITE;

/*!40000 ALTER TABLE `fenxiang` DISABLE KEYS */;

INSERT INTO `fenxiang` VALUES (101,'2023-05-16 14:08:48','标题1','类型1','来源1','内容1','2023-05-16','upload/fenxiang_fengmian1.jpg,upload/fenxiang_fengmian2.jpg,upload/fenxiang_fengmian3.jpg',1),(102,'2023-05-16 14:08:48','标题2','类型2','来源2','内容2','2023-05-16','upload/fenxiang_fengmian2.jpg,upload/fenxiang_fengmian3.jpg,upload/fenxiang_fengmian4.jpg',2),(103,'2023-05-16 14:08:48','标题3','类型3','来源3','内容3','2023-05-16','upload/fenxiang_fengmian3.jpg,upload/fenxiang_fengmian4.jpg,upload/fenxiang_fengmian5.jpg',3),(104,'2023-05-16 14:08:48','标题4','类型4','来源4','内容4','2023-05-16','upload/fenxiang_fengmian4.jpg,upload/fenxiang_fengmian5.jpg,upload/fenxiang_fengmian6.jpg',4),(105,'2023-05-16 14:08:48','标题5','类型5','来源5','内容5','2023-05-16','upload/fenxiang_fengmian5.jpg,upload/fenxiang_fengmian6.jpg,upload/fenxiang_fengmian7.jpg',5),(106,'2023-05-16 14:08:48','标题6','类型6','来源6','内容6','2023-05-16','upload/fenxiang_fengmian6.jpg,upload/fenxiang_fengmian7.jpg,upload/fenxiang_fengmian8.jpg',6),(107,'2023-05-16 14:08:48','标题7','类型7','来源7','内容7','2023-05-16','upload/fenxiang_fengmian7.jpg,upload/fenxiang_fengmian8.jpg,upload/fenxiang_fengmian9.jpg',7),(108,'2023-05-16 14:08:48','标题8','类型8','来源8','内容8','2023-05-16','upload/fenxiang_fengmian8.jpg,upload/fenxiang_fengmian9.jpg,upload/fenxiang_fengmian10.jpg',8);

/*!40000 ALTER TABLE `fenxiang` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `forum`

--

DROP TABLE IF EXISTS `forum`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `forum` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',

`content` longtext NOT NULL COMMENT '帖子内容',

`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`username` varchar(200) DEFAULT NULL COMMENT '用户名',

`avatarurl` longtext COMMENT '头像',

`isdone` varchar(200) DEFAULT NULL COMMENT '状态',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='论坛';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `forum`

--

LOCK TABLES `forum` WRITE;

/*!40000 ALTER TABLE `forum` DISABLE KEYS */;

INSERT INTO `forum` VALUES (121,'2023-05-16 14:08:48','帖子标题1','帖子内容1',0,1,'用户名1','upload/forum_avatarurl1.jpg,upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg','开放'),(122,'2023-05-16 14:08:48','帖子标题2','帖子内容2',0,2,'用户名2','upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg','开放'),(123,'2023-05-16 14:08:48','帖子标题3','帖子内容3',0,3,'用户名3','upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg','开放'),(124,'2023-05-16 14:08:48','帖子标题4','帖子内容4',0,4,'用户名4','upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg','开放'),(125,'2023-05-16 14:08:48','帖子标题5','帖子内容5',0,5,'用户名5','upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg','开放'),(126,'2023-05-16 14:08:48','帖子标题6','帖子内容6',0,6,'用户名6','upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg','开放'),(127,'2023-05-16 14:08:48','帖子标题7','帖子内容7',0,7,'用户名7','upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg','开放'),(128,'2023-05-16 14:08:48','帖子标题8','帖子内容8',0,8,'用户名8','upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg,upload/forum_avatarurl10.jpg','开放');

/*!40000 ALTER TABLE `forum` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `gaojianleixing`

--

DROP TABLE IF EXISTS `gaojianleixing`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `gaojianleixing` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`gaojianleixing` varchar(200) DEFAULT NULL COMMENT '稿件类型',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='稿件类型';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `gaojianleixing`

--

LOCK TABLES `gaojianleixing` WRITE;

/*!40000 ALTER TABLE `gaojianleixing` DISABLE KEYS */;

INSERT INTO `gaojianleixing` VALUES (91,'2023-05-16 14:08:48','稿件类型1'),(92,'2023-05-16 14:08:48','稿件类型2'),(93,'2023-05-16 14:08:48','稿件类型3'),(94,'2023-05-16 14:08:48','稿件类型4'),(95,'2023-05-16 14:08:48','稿件类型5'),(96,'2023-05-16 14:08:48','稿件类型6'),(97,'2023-05-16 14:08:48','稿件类型7'),(98,'2023-05-16 14:08:48','稿件类型8');

/*!40000 ALTER TABLE `gaojianleixing` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `huashi`

--

DROP TABLE IF EXISTS `huashi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `huashi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`huashizhanghao` varchar(200) DEFAULT NULL COMMENT '画师账号',

`huashixingming` varchar(200) DEFAULT NULL COMMENT '画师姓名',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`leixing` varchar(200) DEFAULT NULL COMMENT '类型',

`fengge` varchar(200) DEFAULT NULL COMMENT '风格',

`zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',

`dangqianpai` varchar(200) DEFAULT NULL COMMENT '档期安排',

`zuopinxiangqing` longtext COMMENT '作品详情',

`touxiang` longtext COMMENT '头像',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='画师';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `huashi`

--

LOCK TABLES `huashi` WRITE;

/*!40000 ALTER TABLE `huashi` DISABLE KEYS */;

INSERT INTO `huashi` VALUES (31,'2023-05-16 14:08:48','画师账号1','画师姓名1','性别1','类型1','风格1','未设置','档期安排1','作品详情1','upload/huashi_touxiang1.jpg,upload/huashi_touxiang2.jpg,upload/huashi_touxiang3.jpg'),(32,'2023-05-16 14:08:48','画师账号2','画师姓名2','性别2','类型2','风格2','未设置','档期安排2','作品详情2','upload/huashi_touxiang2.jpg,upload/huashi_touxiang3.jpg,upload/huashi_touxiang4.jpg'),(33,'2023-05-16 14:08:48','画师账号3','画师姓名3','性别3','类型3','风格3','未设置','档期安排3','作品详情3','upload/huashi_touxiang3.jpg,upload/huashi_touxiang4.jpg,upload/huashi_touxiang5.jpg'),(34,'2023-05-16 14:08:48','画师账号4','画师姓名4','性别4','类型4','风格4','未设置','档期安排4','作品详情4','upload/huashi_touxiang4.jpg,upload/huashi_touxiang5.jpg,upload/huashi_touxiang6.jpg'),(35,'2023-05-16 14:08:48','画师账号5','画师姓名5','性别5','类型5','风格5','未设置','档期安排5','作品详情5','upload/huashi_touxiang5.jpg,upload/huashi_touxiang6.jpg,upload/huashi_touxiang7.jpg'),(36,'2023-05-16 14:08:48','画师账号6','画师姓名6','性别6','类型6','风格6','未设置','档期安排6','作品详情6','upload/huashi_touxiang6.jpg,upload/huashi_touxiang7.jpg,upload/huashi_touxiang8.jpg'),(37,'2023-05-16 14:08:48','画师账号7','画师姓名7','性别7','类型7','风格7','未设置','档期安排7','作品详情7','upload/huashi_touxiang7.jpg,upload/huashi_touxiang8.jpg,upload/huashi_touxiang9.jpg'),(38,'2023-05-16 14:08:48','画师账号8','画师姓名8','性别8','类型8','风格8','未设置','档期安排8','作品详情8','upload/huashi_touxiang8.jpg,upload/huashi_touxiang9.jpg,upload/huashi_touxiang10.jpg');

/*!40000 ALTER TABLE `huashi` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `liuyan`

--

DROP TABLE IF EXISTS `liuyan`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `liuyan` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`chuchuangbiaoti` varchar(200) DEFAULT NULL COMMENT '橱窗标题',

`chuchuangfenlei` varchar(200) DEFAULT NULL COMMENT '橱窗分类',

`liuyanneirong` longtext COMMENT '留言内容',

`liuyanshijian` datetime DEFAULT NULL COMMENT '留言时间',

`huashizhanghao` varchar(200) DEFAULT NULL COMMENT '画师账号',

`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',

`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',

`shhf` longtext COMMENT '回复内容',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='留言';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `liuyan`

--

LOCK TABLES `liuyan` WRITE;

/*!40000 ALTER TABLE `liuyan` DISABLE KEYS */;

INSERT INTO `liuyan` VALUES (51,'2023-05-16 14:08:48','橱窗标题1','橱窗分类1','留言内容1','2023-05-16 22:08:48','画师账号1','账号1','姓名1',''),(52,'2023-05-16 14:08:48','橱窗标题2','橱窗分类2','留言内容2','2023-05-16 22:08:48','画师账号2','账号2','姓名2',''),(53,'2023-05-16 14:08:48','橱窗标题3','橱窗分类3','留言内容3','2023-05-16 22:08:48','画师账号3','账号3','姓名3',''),(54,'2023-05-16 14:08:48','橱窗标题4','橱窗分类4','留言内容4','2023-05-16 22:08:48','画师账号4','账号4','姓名4',''),(55,'2023-05-16 14:08:48','橱窗标题5','橱窗分类5','留言内容5','2023-05-16 22:08:48','画师账号5','账号5','姓名5',''),(56,'2023-05-16 14:08:48','橱窗标题6','橱窗分类6','留言内容6','2023-05-16 22:08:48','画师账号6','账号6','姓名6',''),(57,'2023-05-16 14:08:48','橱窗标题7','橱窗分类7','留言内容7','2023-05-16 22:08:48','画师账号7','账号7','姓名7',''),(58,'2023-05-16 14:08:48','橱窗标题8','橱窗分类8','留言内容8','2023-05-16 22:08:48','画师账号8','账号8','姓名8','');

/*!40000 ALTER TABLE `liuyan` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `orders`

--

DROP TABLE IF EXISTS `orders`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `orders` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`orderid` varchar(200) NOT NULL COMMENT '订单编号',

`tablename` varchar(200) DEFAULT 'chuchuang' COMMENT '商品表名',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`goodid` bigint(20) NOT NULL COMMENT '商品id',

`goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',

`picture` longtext COMMENT '商品图片',

`buynumber` int(11) NOT NULL COMMENT '购买数量',

`price` float NOT NULL DEFAULT '0' COMMENT '价格',

`discountprice` float DEFAULT '0' COMMENT '折扣价格',

`total` float NOT NULL DEFAULT '0' COMMENT '总价格',

`discounttotal` float DEFAULT '0' COMMENT '折扣总价格',

`type` int(11) DEFAULT '1' COMMENT '支付类型',

`status` varchar(200) DEFAULT NULL COMMENT '状态',

`address` varchar(200) DEFAULT NULL COMMENT '地址',

`tel` varchar(200) DEFAULT NULL COMMENT '电话',

`consignee` varchar(200) DEFAULT NULL COMMENT '收货人',

`remark` varchar(200) DEFAULT NULL COMMENT '备注',

`logistics` longtext COMMENT '物流',

`huashizhanghao` varchar(200) DEFAULT NULL COMMENT '商户名称',

`goodtype` varchar(200) DEFAULT NULL COMMENT '商品类型',

PRIMARY KEY (`id`),

UNIQUE KEY `orderid` (`orderid`)

) ENGINE=InnoDB AUTO_INCREMENT=1684246370633 DEFAULT CHARSET=utf8 COMMENT='订单';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `orders`

--

LOCK TABLES `orders` WRITE;

/*!40000 ALTER TABLE `orders` DISABLE KEYS */;

INSERT INTO `orders` VALUES (1684246370632,'2023-05-16 14:12:49','2023516221214122','chuchuang',11,41,'橱窗标题1','upload/chuchuang_chuchuangfengmian1.jpg',1,99.9,99.9,99.9,99.9,1,'已完成','宇宙银河系金星1号','13823888881','金某','111',NULL,'画师账号1','橱窗分类1');

/*!40000 ALTER TABLE `orders` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `storeup`

--

DROP TABLE IF EXISTS `storeup`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `storeup` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`refid` bigint(20) DEFAULT NULL COMMENT '商品id',

`tablename` varchar(200) DEFAULT NULL COMMENT '表名',

`name` varchar(200) NOT NULL COMMENT '名称',

`picture` longtext NOT NULL COMMENT '图片',

`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注)',

`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',

`remark` varchar(200) DEFAULT NULL COMMENT '备注',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `storeup`

--

LOCK TABLES `storeup` WRITE;

/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;

/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `token`

--

DROP TABLE IF EXISTS `token`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `token` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`username` varchar(100) NOT NULL COMMENT '用户名',

`tablename` varchar(100) DEFAULT NULL COMMENT '表名',

`role` varchar(100) DEFAULT NULL COMMENT '角色',

`token` varchar(200) NOT NULL COMMENT '密码',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',

`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token表';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `token`

--

LOCK TABLES `token` WRITE;

/*!40000 ALTER TABLE `token` DISABLE KEYS */;

INSERT INTO `token` VALUES (1,21,'画师账号1','chahuashi','插画师','scih0eozx4jmbibu818cduddryfff7bo','2023-05-16 14:10:44','2023-05-16 15:13:17'),(2,11,'账号1','yonghu','用户','qbur2tqfsk6jl3vgpof9sq8w81kumoie','2023-05-16 14:11:55','2023-05-16 15:14:00');

/*!40000 ALTER TABLE `token` ENABLE KEYS */;

UNLOCK TABLES;