开发语言：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;
