LOCK TABLES `banjixinxi` WRITE;
/*!40000 ALTER TABLE `banjixinxi` DISABLE KEYS */;
INSERT INTO `banjixinxi` VALUES (31,'2021-03-21 16:16:04','班级1'),(32,'2021-03-21 16:16:04','班级2'),(33,'2021-03-21 16:16:04','班级3'),(34,'2021-03-21 16:16:04','班级4'),(35,'2021-03-21 16:16:04','班级5'),(36,'2021-03-21 16:16:04','班级6'),(1616344220355,'2021-03-21 16:30:19','三班');
/*!40000 ALTER TABLE `banjixinxi` 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/ssm65209/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssm65209/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssm65209/upload/1616344374651.jpg'),(6,'homepage',NULL);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huifeixinxi`
--
DROP TABLE IF EXISTS `huifeixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huifeixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huifeibianhao` varchar(200) NOT NULL COMMENT '会费编号',
`gerenzhanghao` varchar(200) DEFAULT NULL COMMENT '个人账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shetuan` varchar(200) DEFAULT NULL COMMENT '社团',
`xiangpian` varchar(200) DEFAULT NULL COMMENT '相片',
`huifeijine` int(11) DEFAULT NULL COMMENT '会费金额',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
UNIQUE KEY `huifeibianhao` (`huifeibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1616344161867 DEFAULT CHARSET=utf8 COMMENT='会费信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huifeixinxi`
--
LOCK TABLES `huifeixinxi` WRITE;
/*!40000 ALTER TABLE `huifeixinxi` DISABLE KEYS */;
INSERT INTO `huifeixinxi` VALUES (91,'2021-03-21 16:16:04','会费编号1','个人账号1','姓名1','社团1','http://localhost:8080/ssm65209/upload/huifeixinxi_xiangpian1.jpg',1,'2021-03-22','未支付',1),(92,'2021-03-21 16:16:04','会费编号2','个人账号2','姓名2','社团2','http://localhost:8080/ssm65209/upload/huifeixinxi_xiangpian2.jpg',2,'2021-03-22','未支付',2),(93,'2021-03-21 16:16:04','会费编号3','个人账号3','姓名3','社团3','http://localhost:8080/ssm65209/upload/huifeixinxi_xiangpian3.jpg',3,'2021-03-22','未支付',3),(94,'2021-03-21 16:16:04','会费编号4','个人账号4','姓名4','社团4','http://localhost:8080/ssm65209/upload/huifeixinxi_xiangpian4.jpg',4,'2021-03-22','未支付',4),(95,'2021-03-21 16:16:04','会费编号5','个人账号5','姓名5','社团5','http://localhost:8080/ssm65209/upload/huifeixinxi_xiangpian5.jpg',5,'2021-03-22','未支付',5),(96,'2021-03-21 16:16:04','会费编号6','个人账号6','姓名6','社团6','http://localhost:8080/ssm65209/upload/huifeixinxi_xiangpian6.jpg',6,'2021-03-22','未支付',6),(1616343771789,'2021-03-21 16:22:50','1616343766969','1','张三','社团名称3','http://localhost:8080/ssm65209/upload/1616343700836.png',200,'2021-03-31','已支付',1),(1616344161866,'2021-03-21 16:29:20','1616344158374','社团用户6','姓名6','社团6','http://localhost:8080/ssm65209/upload/shetuanyonghu_xiangpian6.jpg',1000,'2021-03-31','未支付',1);
/*!40000 ALTER TABLE `huifeixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huodong`
--
DROP TABLE IF EXISTS `huodong`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huodong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huodongbianhao` varchar(200) DEFAULT NULL COMMENT '活动编号',
`huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活动名称',
`huodongleixing` varchar(200) DEFAULT NULL COMMENT '活动类型',
`huodongjianjie` varchar(200) DEFAULT NULL COMMENT '活动简介',
`huodongtupian` varchar(200) DEFAULT NULL COMMENT '活动图片',
`huodongshijian` date DEFAULT NULL COMMENT '活动时间',
`shetuan` varchar(200) DEFAULT NULL COMMENT '社团',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1616343895708 DEFAULT CHARSET=utf8 COMMENT='活动';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huodong`
--
LOCK TABLES `huodong` WRITE;
/*!40000 ALTER TABLE `huodong` DISABLE KEYS */;
INSERT INTO `huodong` VALUES (71,'2021-03-21 16:16:04','活动编号1','活动名称1','活动类型1','活动简介1','http://localhost:8080/ssm65209/upload/huodong_huodongtupian1.jpg','2021-03-22','社团1','2021-03-22'),(73,'2021-03-21 16:16:04','活动编号3','活动名称3','活动类型3','活动简介3','http://localhost:8080/ssm65209/upload/huodong_huodongtupian3.jpg','2021-03-22','社团3','2021-03-22'),(74,'2021-03-21 16:16:04','活动编号4','活动名称4','活动类型4','活动简介4','http://localhost:8080/ssm65209/upload/huodong_huodongtupian4.jpg','2021-03-22','社团4','2021-03-22'),(75,'2021-03-21 16:16:04','活动编号5','活动名称5','活动类型5','活动简介5','http://localhost:8080/ssm65209/upload/huodong_huodongtupian5.jpg','2021-03-22','社团5','2021-03-22'),(76,'2021-03-21 16:16:04','活动编号6','活动名称6','活动类型6','活动简介6','http://localhost:8080/ssm65209/upload/huodong_huodongtupian6.jpg','2021-03-22','社团6','2021-03-22'),(1616343895707,'2021-03-21 16:24:55','1616343714078','大扫除','活动类型6','活动23232啊啊啊啊啊','http://localhost:8080/ssm65209/upload/1616343726136.jpg','2021-04-22','社团名称3','2021-04-22');
/*!40000 ALTER TABLE `huodong` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huodongbaoming`
--
DROP TABLE IF EXISTS `huodongbaoming`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huodongbaoming` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huodongbianhao` varchar(200) DEFAULT NULL COMMENT '活动编号',
`huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活动名称',
`huodongleixing` varchar(200) DEFAULT NULL COMMENT '活动类型',
`huodongshijian` varchar(200) DEFAULT NULL COMMENT '活动时间',
`huodongtupian` varchar(200) DEFAULT NULL COMMENT '活动图片',
`shetuan` varchar(200) DEFAULT NULL COMMENT '社团',
`shenqingyuanyin` varchar(200) DEFAULT NULL COMMENT '申请原因',
`shenqingriqi` date DEFAULT NULL COMMENT '申请日期',
`gerenzhanghao` varchar(200) DEFAULT NULL COMMENT '个人账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1616343619398 DEFAULT CHARSET=utf8 COMMENT='活动报名';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huodongbaoming`
--
LOCK TABLES `huodongbaoming` WRITE;
/*!40000 ALTER TABLE `huodongbaoming` DISABLE KEYS */;
INSERT INTO `huodongbaoming` VALUES (81,'2021-03-21 16:16:04','活动编号1','活动名称1','活动类型1','活动时间1','http://localhost:8080/ssm65209/upload/huodongbaoming_huodongtupian1.jpg','社团1','申请原因1','2021-03-22','个人账号1','姓名1','是','',1),(82,'2021-03-21 16:16:04','活动编号2','活动名称2','活动类型2','活动时间2','http://localhost:8080/ssm65209/upload/huodongbaoming_huodongtupian2.jpg','社团2','申请原因2','2021-03-22','个人账号2','姓名2','是','',2),(83,'2021-03-21 16:16:04','活动编号3','活动名称3','活动类型3','活动时间3','http://localhost:8080/ssm65209/upload/huodongbaoming_huodongtupian3.jpg','社团3','申请原因3','2021-03-22','个人账号3','姓名3','是','',3),(84,'2021-03-21 16:16:04','活动编号4','活动名称4','活动类型4','活动时间4','http://localhost:8080/ssm65209/upload/huodongbaoming_huodongtupian4.jpg','社团4','申请原因4','2021-03-22','个人账号4','姓名4','是','',4),(85,'2021-03-21 16:16:04','活动编号5','活动名称5','活动类型5','活动时间5','http://localhost:8080/ssm65209/upload/huodongbaoming_huodongtupian5.jpg','社团5','申请原因5','2021-03-22','个人账号5','姓名5','是','',5),(86,'2021-03-21 16:16:04','活动编号6','活动名称6','活动类型6','活动时间6','http://localhost:8080/ssm65209/upload/huodongbaoming_huodongtupian6.jpg','社团6','申请原因6','2021-03-22','个人账号6','姓名6','是','',6),(1616343619397,'2021-03-21 16:20:19','活动编号4','活动名称4','活动类型4','2021-03-22','http://localhost:8080/ssm65209/upload/huodong_huodongtupian4.jpg','社团4','我想加入','2021-03-21','1','张三','是','审批通过',1616343541629);
/*!40000 ALTER TABLE `huodongbaoming` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huodongchengguo`
--
DROP TABLE IF EXISTS `huodongchengguo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huodongchengguo` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huodongbianhao` varchar(200) DEFAULT NULL COMMENT '活动编号',
`huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活动名称',
`huodongleixing` varchar(200) DEFAULT NULL COMMENT '活动类型',
`huodongchengguo` longtext COMMENT '活动成果',
`xiangguantupian` varchar(200) DEFAULT NULL COMMENT '相关图片',
`shetuan` varchar(200) DEFAULT NULL COMMENT '社团',
`gerenzhanghao` varchar(200) DEFAULT NULL COMMENT '个人账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`fabiaoriqi` date DEFAULT NULL COMMENT '发表日期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1616343647763 DEFAULT CHARSET=utf8 COMMENT='活动成果';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huodongchengguo`
--
LOCK TABLES `huodongchengguo` WRITE;
/*!40000 ALTER TABLE `huodongchengguo` DISABLE KEYS */;
INSERT INTO `huodongchengguo` VALUES (111,'2021-03-21 16:16:04','活动编号1','活动名称1','活动类型1','活动成果1','http://localhost:8080/ssm65209/upload/huodongchengguo_xiangguantupian1.jpg','社团1','个人账号1','姓名1','2021-03-22'),(112,'2021-03-21 16:16:04','活动编号2','活动名称2','活动类型2','活动成果2','http://localhost:8080/ssm65209/upload/huodongchengguo_xiangguantupian2.jpg','社团2','个人账号2','姓名2','2021-03-22'),(113,'2021-03-21 16:16:04','活动编号3','活动名称3','活动类型3','活动成果3','http://localhost:8080/ssm65209/upload/huodongchengguo_xiangguantupian3.jpg','社团3','个人账号3','姓名3','2021-03-22'),(114,'2021-03-21 16:16:04','活动编号4','活动名称4','活动类型4','活动成果4','http://localhost:8080/ssm65209/upload/huodongchengguo_xiangguantupian4.jpg','社团4','个人账号4','姓名4','2021-03-22'),(115,'2021-03-21 16:16:04','活动编号5','活动名称5','活动类型5','活动成果5','http://localhost:8080/ssm65209/upload/huodongchengguo_xiangguantupian5.jpg','社团5','个人账号5','姓名5','2021-03-22'),(116,'2021-03-21 16:16:04','活动编号6','活动名称6','活动类型6','活动成果6','http://localhost:8080/ssm65209/upload/huodongchengguo_xiangguantupian6.jpg','社团6','个人账号6','姓名6','2021-03-22'),(1616343647762,'2021-03-21 16:20:46','活动编号4','活动名称4','活动类型4','好成果','http://localhost:8080/ssm65209/upload/1616343632791.jpg','社团4','1','张三','2021-03-31');
/*!40000 ALTER TABLE `huodongchengguo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huodongleixing`
--
DROP TABLE IF EXISTS `huodongleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huodongleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huodongleixing` varchar(200) NOT NULL COMMENT '活动类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1616344287690 DEFAULT CHARSET=utf8 COMMENT='活动类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huodongleixing`
--
LOCK TABLES `huodongleixing` WRITE;
/*!40000 ALTER TABLE `huodongleixing` DISABLE KEYS */;
INSERT INTO `huodongleixing` VALUES (61,'2021-03-21 16:16:04','活动类型1'),(62,'2021-03-21 16:16:04','活动类型2'),(63,'2021-03-21 16:16:04','活动类型3'),(64,'2021-03-21 16:16:04','活动类型4'),(65,'2021-03-21 16:16:04','活动类型5'),(66,'2021-03-21 16:16:04','活动类型6'),(1616344287689,'2021-03-21 16:31:27','大众类');
/*!40000 ALTER TABLE `huodongleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huodongxinxi`
--
DROP TABLE IF EXISTS `huodongxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huodongxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huodongbianhao` varchar(200) NOT NULL COMMENT '活动编号',
`huodongmingcheng` varchar(200) NOT NULL COMMENT '活动名称',
`huodongleixing` varchar(200) DEFAULT NULL COMMENT '活动类型',
`huodongjianjie` longtext COMMENT '活动简介',
`huodongtupian` varchar(200) DEFAULT NULL COMMENT '活动图片',
`huodongshijian` date DEFAULT NULL COMMENT '活动时间',
`gerenzhanghao` varchar(200) DEFAULT NULL COMMENT '个人账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shetuan` varchar(200) DEFAULT NULL COMMENT '社团',
`shenqingriqi` date DEFAULT NULL COMMENT '申请日期',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
UNIQUE KEY `huodongbianhao` (`huodongbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1616343740020 DEFAULT CHARSET=utf8 COMMENT='活动信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huodongxinxi`
--
LOCK TABLES `huodongxinxi` WRITE;
/*!40000 ALTER TABLE `huodongxinxi` DISABLE KEYS */;
INSERT INTO `huodongxinxi` VALUES (51,'2021-03-21 16:16:04','活动编号1','活动名称1','活动类型1','活动简介1','http://localhost:8080/ssm65209/upload/huodongxinxi_huodongtupian1.jpg','2021-03-22','个人账号1','姓名1','社团1','2021-03-22','是','',1),(52,'2021-03-21 16:16:04','活动编号2','活动名称2','活动类型2','活动简介2','http://localhost:8080/ssm65209/upload/huodongxinxi_huodongtupian2.jpg','2021-03-22','个人账号2','姓名2','社团2','2021-03-22','是','',2),(53,'2021-03-21 16:16:04','活动编号3','活动名称3','活动类型3','活动简介3','http://localhost:8080/ssm65209/upload/huodongxinxi_huodongtupian3.jpg','2021-03-22','个人账号3','姓名3','社团3','2021-03-22','是','',3),(54,'2021-03-21 16:16:04','活动编号4','活动名称4','活动类型4','活动简介4','http://localhost:8080/ssm65209/upload/huodongxinxi_huodongtupian4.jpg','2021-03-22','个人账号4','姓名4','社团4','2021-03-22','是','',4),(55,'2021-03-21 16:16:04','活动编号5','活动名称5','活动类型5','活动简介5','http://localhost:8080/ssm65209/upload/huodongxinxi_huodongtupian5.jpg','2021-03-22','个人账号5','姓名5','社团5','2021-03-22','是','',5),(56,'2021-03-21 16:16:04','活动编号6','活动名称6','活动类型6','活动简介6','http://localhost:8080/ssm65209/upload/huodongxinxi_huodongtupian6.jpg','2021-03-22','个人账号6','姓名6','社团6','2021-03-22','是','',6),(1616343740019,'2021-03-21 16:22:19','1616343714078','大扫除','活动类型6','活动23232啊啊啊啊啊','http://localhost:8080/ssm65209/upload/1616343726136.jpg','2021-04-22','1','张三','社团名称3','2021-03-22','是','活动通过',1616343541629);
/*!40000 ALTER TABLE `huodongxinxi` 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 '用户名',
`content` longtext NOT NULL COMMENT '留言内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1616344066696 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 (141,'2021-03-21 16:16:04',1,'用户名1','留言内容1','回复内容1'),(142,'2021-03-21 16:16:04',2,'用户名2','留言内容2','回复内容2'),(143,'2021-03-21 16:16:04',3,'用户名3','留言内容3','回复内容3'),(144,'2021-03-21 16:16:04',4,'用户名4','留言内容4','回复内容4'),(145,'2021-03-21 16:16:04',5,'用户名5','留言内容5','回复内容5'),(146,'2021-03-21 16:16:04',6,'用户名6','留言内容6','回复内容6'),(1616343869102,'2021-03-21 16:24:29',1616343541629,'1','有好友么','有'),(1616344066695,'2021-03-21 16:27:46',1616343563474,'2','找组织','嗯哼');
/*!40000 ALTER TABLE `messages` 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=1616343851015 DEFAULT CHARSET=utf8 COMMENT='新闻资讯';
/*!40101 SET character_set_client = @saved_cs_client */;
如需定做或者获取更多资料,请联系QQ:375279829