abo开发说明 开发语言：Java 框架：springboot JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器
部分数据库：
--
-- Table structure for table address
--
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-08 07:26:28',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2023-05-08 07:26:28',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2023-05-08 07:26:28',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2023-05-08 07:26:28',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2023-05-08 07:26:28',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2023-05-08 07:26:28',16,'宇宙银河系月球1号','月某','13823888886','是'),(7,'2023-05-08 07:26:28',17,'宇宙银河系黑洞1号','黑某','13823888887','是'),(8,'2023-05-08 07:26:28',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 'shangpinxinxi' 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 '会员价',
shangpubianhao 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 cart
--
LOCK TABLES cart WRITE;
/*!40000 ALTER TABLE cart DISABLE KEYS /;
/!40000 ALTER TABLE cart 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 discussshangpinxinxi
--
DROP TABLE IF EXISTS discussshangpinxinxi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE discussshangpinxinxi (
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 discussshangpinxinxi
--
LOCK TABLES discussshangpinxinxi WRITE;
/*!40000 ALTER TABLE discussshangpinxinxi DISABLE KEYS /;
/!40000 ALTER TABLE discussshangpinxinxi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table messages
--
DROP TABLE IF EXISTS messages;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE messages (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
userid bigint(20) NOT NULL COMMENT '留言人id',
username varchar(200) DEFAULT NULL COMMENT '用户名',
avatarurl longtext COMMENT '头像',
content longtext NOT NULL COMMENT '留言内容',
cpicture longtext COMMENT '留言图片',
reply longtext COMMENT '回复内容',
rpicture longtext COMMENT '回复图片',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT='留言板';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table messages
--
LOCK TABLES messages WRITE;
/*!40000 ALTER TABLE messages DISABLE KEYS /;
INSERT INTO messages VALUES (111,'2023-05-08 07:26:28',1,'用户名1','upload/messages_avatarurl1.jpg','留言内容1','upload/messages_cpicture1.jpg','回复内容1','upload/messages_rpicture1.jpg'),(112,'2023-05-08 07:26:28',2,'用户名2','upload/messages_avatarurl2.jpg','留言内容2','upload/messages_cpicture2.jpg','回复内容2','upload/messages_rpicture2.jpg'),(113,'2023-05-08 07:26:28',3,'用户名3','upload/messages_avatarurl3.jpg','留言内容3','upload/messages_cpicture3.jpg','回复内容3','upload/messages_rpicture3.jpg'),(114,'2023-05-08 07:26:28',4,'用户名4','upload/messages_avatarurl4.jpg','留言内容4','upload/messages_cpicture4.jpg','回复内容4','upload/messages_rpicture4.jpg'),(115,'2023-05-08 07:26:28',5,'用户名5','upload/messages_avatarurl5.jpg','留言内容5','upload/messages_cpicture5.jpg','回复内容5','upload/messages_rpicture5.jpg'),(116,'2023-05-08 07:26:28',6,'用户名6','upload/messages_avatarurl6.jpg','留言内容6','upload/messages_cpicture6.jpg','回复内容6','upload/messages_rpicture6.jpg'),(117,'2023-05-08 07:26:28',7,'用户名7','upload/messages_avatarurl7.jpg','留言内容7','upload/messages_cpicture7.jpg','回复内容7','upload/messages_rpicture7.jpg'),(118,'2023-05-08 07:26:28',8,'用户名8','upload/messages_avatarurl8.jpg','留言内容8','upload/messages_cpicture8.jpg','回复内容8','upload/messages_rpicture8.jpg');
/!40000 ALTER TABLE messages ENABLE KEYS */;
UNLOCK TABLES;
