二手交易平台网站.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: jspm0ghn9 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- -- Table structure for table `chat` -- DROP TABLE IF EXISTS `chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id', `ask` longtext COMMENT '提问', `reply` longtext COMMENT '回复', `isreply` int(11) DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1615514228265 DEFAULT CHARSET=utf8 COMMENT='客服聊天表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat` -- LOCK TABLES `chat` WRITE; /*!40000 ALTER TABLE `chat` DISABLE KEYS */; INSERT INTO `chat` VALUES (71,'2021-03-12 01:54:21',1,1,'提问1','回复1',1),(72,'2021-03-12 01:54:21',2,2,'提问2','回复2',2),(73,'2021-03-12 01:54:21',3,3,'提问3','回复3',3),(74,'2021-03-12 01:54:21',4,4,'提问4','回复4',4),(75,'2021-03-12 01:54:21',5,5,'提问5','回复5',5),(76,'2021-03-12 01:54:21',6,6,'提问6','回复6',6),(1615514228264,'2021-03-12 01:57:07',1615514161213,NULL,'你好',NULL,1); /*!40000 ALTER TABLE `chat` 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=7 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','http://localhost:8080/jspm0ghn9/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/jspm0ghn9/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/jspm0ghn9/upload/picture3.jpg'),(6,'homepage',NULL); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dingdanpeisong` -- DROP TABLE IF EXISTS `dingdanpeisong`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dingdanpeisong` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号', `shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称', `shuliang` varchar(200) DEFAULT NULL COMMENT '数量', `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名', `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名', `shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码', `shouhuodizhi` varchar(200) DEFAULT NULL COMMENT '收货地址', `fahuoriqi` date DEFAULT NULL COMMENT '发货日期', `shangjiahao` varchar(200) DEFAULT NULL COMMENT '商家号', `shangjiamingcheng` varchar(200) DEFAULT NULL COMMENT '商家名称', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1615514493733 DEFAULT CHARSET=utf8 COMMENT='订单配送'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dingdanpeisong` -- LOCK TABLES `dingdanpeisong` WRITE; /*!40000 ALTER TABLE `dingdanpeisong` DISABLE KEYS */; INSERT INTO `dingdanpeisong` VALUES (61,'2021-03-12 01:54:21','订单编号1','商品名称1','数量1','用户名1','用户姓名1','手机号码1','收货地址1','2021-03-12','商家号1','商家名称1'),(62,'2021-03-12 01:54:21','订单编号2','商品名称2','数量2','用户名2','用户姓名2','手机号码2','收货地址2','2021-03-12','商家号2','商家名称2'),(63,'2021-03-12 01:54:21','订单编号3','商品名称3','数量3','用户名3','用户姓名3','手机号码3','收货地址3','2021-03-12','商家号3','商家名称3'),(64,'2021-03-12 01:54:21','订单编号4','商品名称4','数量4','用户名4','用户姓名4','手机号码4','收货地址4','2021-03-12','商家号4','商家名称4'),(65,'2021-03-12 01:54:21','订单编号5','商品名称5','数量5','用户名5','用户姓名5','手机号码5','收货地址5','2021-03-12','商家号5','商家名称5'),(66,'2021-03-12 01:54:21','订单编号6','商品名称6','数量6','用户名6','用户姓名6','手机号码6','收货地址6','2021-03-12','商家号6','商家名称6'),(1615514493732,'2021-03-12 02:01:33','20213121001223673720','相机','2','11','杨小姐','13823899999','广州市广州路8号','2021-03-13','22','新作的店'); /*!40000 ALTER TABLE `dingdanpeisong` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dingdanxinxi` -- DROP TABLE IF EXISTS `dingdanxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dingdanxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号', `shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称', `chengse` varchar(200) DEFAULT NULL COMMENT '成色', `jiage` varchar(200) DEFAULT NULL COMMENT '价格', `shuliang` int(11) DEFAULT NULL COMMENT '数量', `zongjine` varchar(200) DEFAULT NULL COMMENT '总金额', `shangjiahao` varchar(200) DEFAULT NULL COMMENT '商家号', `xiadanriqi` date DEFAULT NULL COMMENT '下单日期', `beizhu` varchar(200) DEFAULT NULL COMMENT '备注', `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名', `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名', `shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码', `shouhuodizhi` varchar(200) DEFAULT NULL COMMENT '收货地址', `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`), UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=1615514434366 DEFAULT CHARSET=utf8 COMMENT='订单信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dingdanxinxi` -- LOCK TABLES `dingdanxinxi` WRITE; /*!40000 ALTER TABLE `dingdanxinxi` DISABLE KEYS */; INSERT INTO `dingdanxinxi` VALUES (51,'2021-03-12 01:54:21','订单编号1','商品名称1','成色1','价格1',1,'总金额1','商家号1','2021-03-12','备注1','用户名1','用户姓名1','手机号码1','收货地址1','未支付'),(52,'2021-03-12 01:54:21','订单编号2','商品名称2','成色2','价格2',2,'总金额2','商家号2','2021-03-12','备注2','用户名2','用户姓名2','手机号码2','收货地址2','未支付'),(53,'2021-03-12 01:54:21','订单编号3','商品名称3','成色3','价格3',3,'总金额3','商家号3','2021-03-12','备注3','用户名3','用户姓名3','手机号码3','收货地址3','未支付'),(54,'2021-03-12 01:54:2