小程序开发说明
开发语言：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 bisaibaoming;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE bisaibaoming (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
baomingbianhao varchar(200) DEFAULT NULL COMMENT '报名编号',
xiangmumingcheng varchar(200) DEFAULT NULL COMMENT '项目名称',
xiangmuleixing varchar(200) DEFAULT NULL COMMENT '项目类型',
tupian varchar(200) DEFAULT NULL COMMENT '图片',
baomingshijian datetime DEFAULT NULL COMMENT '报名时间',
yonghuzhanghao varchar(200) DEFAULT NULL COMMENT '用户账号',
yonghuxingming varchar(200) DEFAULT NULL COMMENT '用户姓名',
sfsh varchar(200) DEFAULT '否' COMMENT '是否审核',
shhf longtext COMMENT '审核回复',
PRIMARY KEY (id),
UNIQUE KEY baomingbianhao (baomingbianhao)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='比赛报名';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table bisaibaoming
--
LOCK TABLES bisaibaoming WRITE;
/*!40000 ALTER TABLE bisaibaoming DISABLE KEYS /;
INSERT INTO bisaibaoming VALUES (41,'2022-05-27 05:45:04','1111111111','项目名称1','项目类型1','upload/bisaibaoming_tupian1.jpg','2022-05-27 13:45:04','用户账号1','用户姓名1','是',''),(42,'2022-05-27 05:45:04','2222222222','项目名称2','项目类型2','upload/bisaibaoming_tupian2.jpg','2022-05-27 13:45:04','用户账号2','用户姓名2','是',''),(43,'2022-05-27 05:45:04','3333333333','项目名称3','项目类型3','upload/bisaibaoming_tupian3.jpg','2022-05-27 13:45:04','用户账号3','用户姓名3','是',''),(44,'2022-05-27 05:45:04','4444444444','项目名称4','项目类型4','upload/bisaibaoming_tupian4.jpg','2022-05-27 13:45:04','用户账号4','用户姓名4','是',''),(45,'2022-05-27 05:45:04','5555555555','项目名称5','项目类型5','upload/bisaibaoming_tupian5.jpg','2022-05-27 13:45:04','用户账号5','用户姓名5','是',''),(46,'2022-05-27 05:45:04','6666666666','项目名称6','项目类型6','upload/bisaibaoming_tupian6.jpg','2022-05-27 13:45:04','用户账号6','用户姓名6','是','');
/!40000 ALTER TABLE bisaibaoming ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table chengjixinxi
--
DROP TABLE IF EXISTS chengjixinxi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE chengjixinxi (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
chengjibianhao varchar(200) DEFAULT NULL COMMENT '成绩编号',
xiangmumingcheng varchar(200) DEFAULT NULL COMMENT '项目名称',
xiangmuleixing varchar(200) DEFAULT NULL COMMENT '项目类型',
tupian varchar(200) DEFAULT NULL COMMENT '图片',
baobiao varchar(200) DEFAULT NULL COMMENT '报表',
fabushijian datetime DEFAULT NULL COMMENT '发布时间',
bisaichengji float DEFAULT NULL COMMENT '比赛成绩',
xiangqing longtext COMMENT '详情',
yonghuzhanghao varchar(200) DEFAULT NULL COMMENT '用户账号',
yonghuxingming varchar(200) DEFAULT NULL COMMENT '用户姓名',
userid bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (id),
UNIQUE KEY chengjibianhao (chengjibianhao)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='成绩信息';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table chengjixinxi
--
LOCK TABLES chengjixinxi WRITE;
/*!40000 ALTER TABLE chengjixinxi DISABLE KEYS /;
INSERT INTO chengjixinxi VALUES (51,'2022-05-27 05:45:04','1111111111','项目名称1','项目类型1','upload/chengjixinxi_tupian1.jpg','upload/1653630419489.png','2022-05-27 13:45:04',1,'
详情1
','用户账号1','用户姓名1',1),(52,'2022-05-27 05:45:04','2222222222','项目名称2','项目类型2','upload/chengjixinxi_tupian2.jpg','upload/chengjixinxi_baobiao2.jpg','2022-05-27 13:45:04',2,'详情2','用户账号2','用户姓名2',2),(53,'2022-05-27 05:45:04','3333333333','项目名称3','项目类型3','upload/chengjixinxi_tupian3.jpg','upload/chengjixinxi_baobiao3.jpg','2022-05-27 13:45:04',3,'详情3','用户账号3','用户姓名3',3),(54,'2022-05-27 05:45:04','4444444444','项目名称4','项目类型4','upload/chengjixinxi_tupian4.jpg','upload/chengjixinxi_baobiao4.jpg','2022-05-27 13:45:04',4,'详情4','用户账号4','用户姓名4',4),(55,'2022-05-27 05:45:04','5555555555','项目名称5','项目类型5','upload/chengjixinxi_tupian5.jpg','upload/chengjixinxi_baobiao5.jpg','2022-05-27 13:45:04',5,'详情5','用户账号5','用户姓名5',5),(56,'2022-05-27 05:45:04','6666666666','项目名称6','项目类型6','upload/chengjixinxi_tupian6.jpg','upload/chengjixinxi_baobiao6.jpg','2022-05-27 13:45:04',6,'详情6','用户账号6','用户姓名6',6);
/!40000 ALTER TABLE chengjixinxi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table chexiaobaoming
--
DROP TABLE IF EXISTS chexiaobaoming;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE chexiaobaoming (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
chexiaobianhao varchar(200) DEFAULT NULL COMMENT '撤销编号',
xiangmumingcheng varchar(200) DEFAULT NULL COMMENT '项目名称',
xiangmuleixing varchar(200) DEFAULT NULL COMMENT '项目类型',
tupian varchar(200) DEFAULT NULL COMMENT '图片',
chexiaoshijian datetime DEFAULT NULL COMMENT '撤销时间',
chexiaobeizhu longtext COMMENT '撤销备注',
yonghuzhanghao varchar(200) DEFAULT NULL COMMENT '用户账号',
yonghuxingming varchar(200) DEFAULT NULL COMMENT '用户姓名',
sfsh varchar(200) DEFAULT '否' COMMENT '是否审核',
shhf longtext COMMENT '审核回复',
PRIMARY KEY (id),
UNIQUE KEY chexiaobianhao (chexiaobianhao)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='撤销报名';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table chexiaobaoming
--
LOCK TABLES chexiaobaoming WRITE;
/*!40000 ALTER TABLE chexiaobaoming DISABLE KEYS /;
INSERT INTO chexiaobaoming VALUES (61,'2022-05-27 05:45:04','1111111111','项目名称1','项目类型1','upload/chexiaobaoming_tupian1.jpg','2022-05-27 13:45:04','撤销备注1','用户账号1','用户姓名1','是',''),(62,'2022-05-27 05:45:04','2222222222','项目名称2','项目类型2','upload/chexiaobaoming_tupian2.jpg','2022-05-27 13:45:04','撤销备注2','用户账号2','用户姓名2','是',''),(63,'2022-05-27 05:45:04','3333333333','项目名称3','项目类型3','upload/chexiaobaoming_tupian3.jpg','2022-05-27 13:45:04','撤销备注3','用户账号3','用户姓名3','是',''),(64,'2022-05-27 05:45:04','4444444444','项目名称4','项目类型4','upload/chexiaobaoming_tupian4.jpg','2022-05-27 13:45:04','撤销备注4','用户账号4','用户姓名4','是',''),(65,'2022-05-27 05:45:04','5555555555','项目名称5','项目类型5','upload/chexiaobaoming_tupian5.jpg','2022-05-27 13:45:04','撤销备注5','用户账号5','用户姓名5','是',''),(66,'2022-05-27 05:45:04','6666666666','项目名称6','项目类型6','upload/chexiaobaoming_tupian6.jpg','2022-05-27 13:45:04','撤销备注6','用户账号6','用户姓名6','是','');
/!40000 ALTER TABLE chexiaobaoming 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 news
--
DROP TABLE IF EXISTS news;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE news (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
title varchar(200) NOT NULL COMMENT '标题',
introduction longtext COMMENT '简介',
picture varchar(200) NOT NULL COMMENT '图片',
content longtext NOT NULL COMMENT '内容',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='广播信息';
/!40101 SET character_set_client = @saved_cs_client */;
