小程序开发说明
开发语言: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;