小程序开发说明
开发语言：Java 框架：ssm JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器
小程序框架：uniapp 小程序开发软件：HBuilder X 小程序运行软件：微信开发者
数据库脚本：
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=7 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,'2022-04-12 07:54:21',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-04-12 07:54:21',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-04-12 07:54:21',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-04-12 07:54:21',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-04-12 07:54:21',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-04-12 07:54:21',16,'宇宙银河系月球1号','月某','13823888886','是');
/!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 varchar(200) DEFAULT NULL COMMENT '图片',
buynumber int(11) NOT NULL COMMENT '购买数量',
price float DEFAULT NULL COMMENT '单价',
discountprice float DEFAULT NULL COMMENT '会员价',
mendianzhanghao 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 discussfuwuxiangmu
--
DROP TABLE IF EXISTS discussfuwuxiangmu;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE discussfuwuxiangmu (
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',
nickname varchar(200) DEFAULT NULL COMMENT '用户名',
content longtext NOT NULL COMMENT '评论内容',
reply longtext COMMENT '回复内容',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='服务项目评论表';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table discussfuwuxiangmu
--
LOCK TABLES discussfuwuxiangmu WRITE;
/*!40000 ALTER TABLE discussfuwuxiangmu DISABLE KEYS /;
INSERT INTO discussfuwuxiangmu VALUES (131,'2022-04-12 07:54:21',1,1,'用户名1','评论内容1','回复内容1'),(132,'2022-04-12 07:54:21',2,2,'用户名2','评论内容2','回复内容2'),(133,'2022-04-12 07:54:21',3,3,'用户名3','评论内容3','回复内容3'),(134,'2022-04-12 07:54:21',4,4,'用户名4','评论内容4','回复内容4'),(135,'2022-04-12 07:54:22',5,5,'用户名5','评论内容5','回复内容5'),(136,'2022-04-12 07:54:22',6,6,'用户名6','评论内容6','回复内容6');
/!40000 ALTER TABLE discussfuwuxiangmu 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',
nickname varchar(200) DEFAULT NULL COMMENT '用户名',
content longtext NOT NULL COMMENT '评论内容',
reply longtext COMMENT '回复内容',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=147 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 /;
INSERT INTO discussshangpinxinxi VALUES (141,'2022-04-12 07:54:22',1,1,'用户名1','评论内容1','回复内容1'),(142,'2022-04-12 07:54:22',2,2,'用户名2','评论内容2','回复内容2'),(143,'2022-04-12 07:54:22',3,3,'用户名3','评论内容3','回复内容3'),(144,'2022-04-12 07:54:22',4,4,'用户名4','评论内容4','回复内容4'),(145,'2022-04-12 07:54:22',5,5,'用户名5','评论内容5','回复内容5'),(146,'2022-04-12 07:54:22',6,6,'用户名6','评论内容6','回复内容6');
/!40000 ALTER TABLE discussshangpinxinxi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table fuwuxiangmu
--
DROP TABLE IF EXISTS fuwuxiangmu;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE fuwuxiangmu (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
xiangmubianhao varchar(200) DEFAULT NULL COMMENT '项目编号',
xiangmumingcheng varchar(200) DEFAULT NULL COMMENT '项目名称',
xiangmuleixing varchar(200) DEFAULT NULL COMMENT '项目类型',
jiage float DEFAULT NULL COMMENT '价格',
fengmian varchar(200) DEFAULT NULL COMMENT '封面',
xiangxijieshao longtext COMMENT '详细介绍',
mendianzhanghao varchar(200) DEFAULT NULL COMMENT '门店账号',
mendianmingcheng varchar(200) DEFAULT NULL COMMENT '门店名称',
thumbsupnum int(11) DEFAULT '0' COMMENT '赞',
crazilynum int(11) DEFAULT '0' COMMENT '踩',
clicktime datetime DEFAULT NULL COMMENT '最近点击时间',
clicknum int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (id),
UNIQUE KEY xiangmubianhao (xiangmubianhao)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='服务项目';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table fuwuxiangmu
--
LOCK TABLES fuwuxiangmu WRITE;
/*!40000 ALTER TABLE fuwuxiangmu DISABLE KEYS /;
INSERT INTO fuwuxiangmu VALUES (41,'2022-04-12 07:54:21','1111111111','项目名称1','项目类型1',1,'upload/fuwuxiangmu_fengmian1.jpg','详细介绍1','门店账号1','门店名称1',1,1,'2022-04-12 15:54:21',1),(42,'2022-04-12 07:54:21','2222222222','项目名称2','项目类型2',2,'upload/fuwuxiangmu_fengmian2.jpg','详细介绍2','门店账号2','门店名称2',2,2,'2022-04-12 15:54:21',2),(43,'2022-04-12 07:54:21','3333333333','项目名称3','项目类型3',3,'upload/fuwuxiangmu_fengmian3.jpg','详细介绍3','门店账号3','门店名称3',3,3,'2022-04-12 15:54:21',3),(44,'2022-04-12 07:54:21','4444444444','项目名称4','项目类型4',4,'upload/fuwuxiangmu_fengmian4.jpg','详细介绍4','门店账号4','门店名称4',4,4,'2022-04-12 15:54:21',4),(45,'2022-04-12 07:54:21','5555555555','项目名称5','项目类型5',5,'upload/fuwuxiangmu_fengmian5.jpg','详细介绍5','门店账号5','门店名称5',5,5,'2022-04-12 15:54:21',5),(46,'2022-04-12 07:54:21','6666666666','项目名称6','项目类型6',6,'upload/fuwuxiangmu_fengmian6.jpg','详细介绍6','门店账号6','门店名称6',6,6,'2022-04-12 15:54:21',6);
/!40000 ALTER TABLE fuwuxiangmu ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table mendian
--
DROP TABLE IF EXISTS mendian;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE mendian (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
mendianzhanghao varchar(200) NOT NULL COMMENT '门店账号',
mima varchar(200) NOT NULL COMMENT '密码',
mendianmingcheng varchar(200) NOT NULL COMMENT '门店名称',
fuzeren varchar(200) DEFAULT NULL COMMENT '负责人',
lianxidianhua varchar(200) DEFAULT NULL COMMENT '联系电话',
dianputupian varchar(200) DEFAULT NULL COMMENT '店铺图片',
dianpudizhi varchar(200) DEFAULT NULL COMMENT '店铺地址',
money float DEFAULT '0' COMMENT '余额',
PRIMARY KEY (id),
UNIQUE KEY mendianzhanghao (mendianzhanghao)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='门店';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table mendian
--
LOCK TABLES mendian WRITE;
/*!40000 ALTER TABLE mendian DISABLE KEYS /;
INSERT INTO mendian VALUES (21,'2022-04-12 07:54:21','门店账号1','123456','门店名称1','负责人1','13823888881','upload/mendian_dianputupian1.jpg','店铺地址1',100),(22,'2022-04-12 07:54:21','门店账号2','123456','门店名称2','负责人2','13823888882','upload/mendian_dianputupian2.jpg','店铺地址2',100),(23,'2022-04-12 07:54:21','门店账号3','123456','门店名称3','负责人3','13823888883','upload/mendian_dianputupian3.jpg','店铺地址3',100),(24,'2022-04-12 07:54:21','门店账号4','123456','门店名称4','负责人4','13823888884','upload/mendian_dianputupian4.jpg','店铺地址4',100),(25,'2022-04-12 07:54:21','门店账号5','123456','门店名称5','负责人5','13823888885','upload/mendian_dianputupian5.jpg','店铺地址5',100),(26,'2022-04-12 07:54:21','门店账号6','123456','门店名称6','负责人6','13823888886','upload/mendian_dianputupian6.jpg','店铺地址6',100);
/!40000 ALTER TABLE mendian ENABLE KEYS */;
UNLOCK TABLES;
