插画约稿平台-计算机毕业设计源码+LW文档
技术微信：375279829
本课题包括源程序、数据库、论文、运行软件、运行教程
毕业设计资料-计算机毕业设计源码网：我们提供的源码通过邮箱或者QQ微信传送,如果有啥问题直接联系客服
包在您电脑上运行成功
语言：Java
数据库：MySQL
框架：ssm、springboot、mvc
课题相关技术、功能详情请联系技术
作品描述
开发语言：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;
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ