-- MySQL dump 10.13  Distrib 8.0.30, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: club_manager
-- ------------------------------------------------------
-- Server version	8.0.30

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 `academy`
--

DROP TABLE IF EXISTS `academy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `academy` (
  `value` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `label` varchar(30) DEFAULT NULL COMMENT '学院名',
  PRIMARY KEY (`value`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='学院';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `academy`
--

INSERT INTO `academy` VALUES (1,'计算机学院'),(2,'农工学院'),(3,'土木学院'),(4,'生物学院'),(5,'法学院');

--
-- Table structure for table `club_activity`
--

DROP TABLE IF EXISTS `club_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `club_activity` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `club_id` bigint DEFAULT NULL COMMENT '社团ID',
  `club_name` varchar(30) DEFAULT NULL COMMENT '社团名称',
  `activity_name` varchar(30) DEFAULT NULL COMMENT '活动名称',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '活动截止',
  `address` varchar(30) DEFAULT NULL COMMENT '活动地点',
  `activity_time` timestamp NULL DEFAULT NULL COMMENT '活动时间',
  `activity_num` int DEFAULT NULL COMMENT '活动人数',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '申请时间',
  `status` tinyint DEFAULT '0' COMMENT '状态',
  `url` varchar(200) DEFAULT NULL COMMENT '申请资料',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社团活动';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club_activity`
--

INSERT INTO `club_activity` VALUES (1,1,'滴滴游戏社团','活动申请测试','2023-04-04 10:46:57','三体','2023-03-29 14:38:18',8,'2023-03-29 14:38:39',1,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/29/b5d07ed4-7ae5-40c6-894d-c36d0d58d7d1.jpg'),(2,1,'滴滴游戏社团','活动新增测试2','2023-04-04 10:46:57','三体','2023-03-29 14:39:12',10,'2023-03-29 14:39:16',1,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/29/93670fa8-c54a-4e52-a75a-a4ef0755516c.jpg'),(3,1,'滴滴游戏社团','春游','2023-04-04 10:46:57','三体','2023-03-29 16:00:00',18,'2023-03-30 11:52:45',1,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/77897980-7f0b-4dc9-9727-f4883e84e9f9.jpg'),(4,1,'滴滴游戏社团','春游2','2023-04-04 10:46:57','三体','2023-03-30 11:53:27',10,'2023-03-30 11:53:35',2,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/bba03923-c2e5-4620-8fcb-15fb59d7211a.jpg'),(5,9,'测试社团','huod','2023-04-04 10:46:57','三体','2023-03-30 12:59:36',18,'2023-03-30 12:59:42',1,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/3d661648-2430-4af0-923b-6cd3b898831d.jpg'),(6,1,'滴滴游戏社团','测试','2023-04-11 16:00:00','三体','2023-04-03 16:00:00',18,'2023-04-04 10:57:34',0,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/04/9d77bc53-8789-40b5-bec8-459f60576aa3.jpg'),(7,1,'滴滴游戏社团','玩耍','2023-04-13 11:02:57','三体','2023-04-04 11:03:01',18,'2023-04-04 11:03:14',0,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/04/3861b4fa-cbea-4a19-b99f-76df9caaa6f5.jpg'),(8,1,'滴滴游戏社团','测试','2023-04-25 16:00:00','第二体育场馆','2023-04-03 16:00:00',18,'2023-04-04 11:06:14',1,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/04/8bec8ece-80ef-427e-8ae5-160e527d2a5e.jpg'),(9,1,'滴滴游戏社团','手机','2023-05-17 16:00:00','手机','2023-04-13 16:00:00',18,'2023-04-09 10:10:01',0,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/09/26dbff4c-320b-483d-93c2-151099762bec.jpg'),(10,1,'滴滴游戏社团','手机','2023-03-28 16:00:00','手机','2023-03-28 16:00:00',18,'2023-04-09 10:16:18',0,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/09/32e9efe9-e44a-4ce7-b000-a9bd1a7950e3.jpg'),(11,1,'滴滴游戏社团','wuhuhu','2023-05-10 16:00:00','buzioddd','2023-05-03 16:00:00',18,'2023-04-09 10:28:12',0,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/09/cea829c0-c59e-452c-a70c-8f794fe515e5.jpg'),(12,1,'滴滴游戏社团','111','2023-05-24 16:00:00','1111','2023-05-19 16:00:00',111,'2023-04-09 10:30:11',0,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/09/1bee892e-910b-4a50-8db1-9554067e9453.jpg'),(13,1,'滴滴游戏社团','222','2023-05-17 16:00:00','122','2023-05-02 16:00:00',11,'2023-04-09 10:30:34',0,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/09/ef19b24d-0c38-4d0d-870b-b2cbf1532878.jpg'),(14,1,'滴滴游戏社团','333','2023-05-25 16:00:00','商城','2023-04-10 16:00:00',11,'2023-04-09 10:38:05',0,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/09/d5222074-9ee8-457f-af88-80ed1d881c27.jpg');

--
-- Table structure for table `club_budget`
--

DROP TABLE IF EXISTS `club_budget`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `club_budget` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `club_id` bigint DEFAULT NULL COMMENT '社团ID',
  `club_name` varchar(30) DEFAULT NULL COMMENT '社团名称',
  `price` decimal(10,0) DEFAULT NULL COMMENT '申请金额',
  `status` tinyint DEFAULT '0',
  `application` varchar(100) DEFAULT NULL COMMENT '用途',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '申请时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社团经费';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club_budget`
--

INSERT INTO `club_budget` VALUES (1,1,'滴滴游戏社团',288,1,'经费申请测试','2023-03-29 14:49:55'),(2,1,'滴滴游戏社团',366,2,'测试经费2','2023-03-29 14:50:29'),(3,9,'测试社团',188,1,'123','2023-03-30 12:59:51'),(4,1,'滴滴游戏社团',188,1,'测试','2023-04-04 11:06:32'),(5,1,'滴滴游戏社团',188,0,'111','2023-04-09 10:39:32');

--
-- Table structure for table `club_config`
--

DROP TABLE IF EXISTS `club_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `club_config` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `rstatus` tinyint DEFAULT '0' COMMENT '注册开关0关1开',
  `sstatus` tinyint DEFAULT '0' COMMENT '审核开关0关1开',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社团注册/审核控制';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club_config`
--

INSERT INTO `club_config` VALUES (1,1,1);

--
-- Table structure for table `club_exam`
--

DROP TABLE IF EXISTS `club_exam`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `club_exam` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `club_name` varchar(30) DEFAULT NULL COMMENT '社团名',
  `club_id` int DEFAULT NULL COMMENT '社团ID',
  `url` varchar(200) DEFAULT NULL COMMENT '考核资料',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '提交时间',
  `status` tinyint DEFAULT '0' COMMENT '审核状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='注册申请';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club_exam`
--

INSERT INTO `club_exam` VALUES (1,'滴滴游戏社团',1,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/2be513a2-517d-42cd-b14f-7ac8fe7867dd.jpg','2023-03-30 10:41:37',1),(2,'测试社团',9,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/f6510e9b-b957-440f-9f97-be15e21ed3c6.jpg','2023-03-30 12:58:43',1);

--
-- Table structure for table `club_info`
--

DROP TABLE IF EXISTS `club_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `club_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(30) DEFAULT NULL COMMENT '社团名称',
  `owner_id` bigint DEFAULT NULL COMMENT '负责人ID',
  `owner_user` varchar(30) DEFAULT NULL COMMENT '负责人姓名',
  `status` tinyint DEFAULT NULL COMMENT '社团状态',
  `rstatus` tinyint DEFAULT '0' COMMENT '注册状态',
  `academy_id` bigint DEFAULT NULL COMMENT '挂靠学院ID',
  `academy_name` varchar(30) DEFAULT NULL COMMENT '挂靠学院',
  `introduce` varchar(200) DEFAULT NULL COMMENT '注册资料',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '成立时间',
  `ac_num` int DEFAULT '0' COMMENT '活动次数',
  `budget` decimal(10,0) DEFAULT '0' COMMENT '经费',
  `per_num` int DEFAULT '0' COMMENT '成员人数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社团信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club_info`
--

INSERT INTO `club_info` VALUES (1,'滴滴游戏社团',1,'高启强',1,1,2,'农工学院','http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/29/987d3d5c-4a7d-4125-ae4d-c07a1fe953de.jpg','2023-03-29 13:27:46',4,842,3),(9,'测试社团',6,'abc123',1,1,1,'计算机学院','http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/f7dd7fee-0a26-4e70-9ef0-44a7ab213373.jpg','2023-03-30 12:56:56',1,188,1),(10,'呼啦圈社团',4,'王五',0,0,1,'计算机学院',NULL,'2023-04-09 11:01:18',0,0,0);

--
-- Table structure for table `club_reg`
--

DROP TABLE IF EXISTS `club_reg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `club_reg` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `club_name` varchar(30) DEFAULT NULL COMMENT '社团名',
  `club_id` int DEFAULT NULL COMMENT '社团ID',
  `url` varchar(200) DEFAULT NULL COMMENT '注册资料',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '申请时间',
  `status` tinyint DEFAULT '0' COMMENT '审核状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='注册申请';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club_reg`
--

INSERT INTO `club_reg` VALUES (4,'滴滴游戏社团',1,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/f2beef68-4989-422c-8f8c-41a7cbd8f067.jpg','2023-03-30 09:47:56',1),(5,'测试社团',9,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/770b8ee2-d704-46a7-a955-b6e7b5d4a573.jpg','2023-03-30 12:58:15',1);

--
-- Table structure for table `club_user`
--

DROP TABLE IF EXISTS `club_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `club_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(30) DEFAULT NULL COMMENT '姓名',
  `sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `tel` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `academy_name` varchar(30) DEFAULT NULL COMMENT '所属学院',
  `club_id` bigint DEFAULT NULL COMMENT '所属社团',
  `club_name` varchar(30) DEFAULT NULL COMMENT '社团名',
  `status` tinyint DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社团成员';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club_user`
--

INSERT INTO `club_user` VALUES (1,'张三','男','17625252626','计算机学院',1,'滴滴游戏社团',1),(2,'电视机1','女','17864388888','农工学院',1,'滴滴游戏社团',1),(3,'李四','男','17625252625','生物学院',1,'滴滴游戏社团',1),(4,'王五','男','12345677777','计算机学院',8,'社团创建测试2',1),(5,'琪琪','男','12345677777','生物学院',9,'测试社团',1);

--
-- Table structure for table `sys_captcha`
--

DROP TABLE IF EXISTS `sys_captcha`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_captcha` (
  `uuid` char(36) NOT NULL COMMENT 'uuid',
  `code` varchar(6) NOT NULL COMMENT '验证码',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统验证码';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_captcha`
--

INSERT INTO `sys_captcha` VALUES ('13aac35d-a4a2-45b2-80ee-9acd233317a8','nbccw','2023-03-27 23:42:32'),('2aedafe7-e416-4185-894c-c488b1193fb4','755p3','2023-03-29 19:55:00');

--
-- Table structure for table `sys_menu`
--

DROP TABLE IF EXISTS `sys_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_menu` (
  `menu_id` bigint NOT NULL AUTO_INCREMENT,
  `parent_id` bigint DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_menu`
--

INSERT INTO `sys_menu` VALUES (1,0,'系统管理',NULL,NULL,0,'system',0),(2,61,'人员管理','sys/user',NULL,1,'admin',1),(3,61,'角色管理','sys/role',NULL,1,'role',2),(4,1,'菜单管理','sys/menu',NULL,1,'menu',3),(15,2,'查看',NULL,'sys:user:list,sys:user:info',2,NULL,0),(16,2,'新增',NULL,'sys:user:save,sys:role:select',2,NULL,0),(17,2,'修改',NULL,'sys:user:update,sys:role:select',2,NULL,0),(18,2,'删除',NULL,'sys:user:delete',2,NULL,0),(19,3,'查看',NULL,'sys:role:list,sys:role:info',2,NULL,0),(20,3,'新增',NULL,'sys:role:save,sys:menu:list',2,NULL,0),(21,3,'修改',NULL,'sys:role:update,sys:menu:list',2,NULL,0),(22,3,'删除',NULL,'sys:role:delete',2,NULL,0),(23,4,'查看',NULL,'sys:menu:list,sys:menu:info',2,NULL,0),(24,4,'新增',NULL,'sys:menu:save,sys:menu:select',2,NULL,0),(25,4,'修改',NULL,'sys:menu:update,sys:menu:select',2,NULL,0),(26,4,'删除',NULL,'sys:menu:delete',2,NULL,0),(27,61,'社团列表','club/clubinfo',NULL,1,'zhedie',6),(28,27,'查看',NULL,'club:clubinfo:list,club:clubinfo:info',2,NULL,6),(29,27,'新增',NULL,'club:clubinfo:save',2,NULL,6),(30,27,'修改',NULL,'club:clubinfo:update',2,NULL,6),(31,27,'删除',NULL,'club:clubinfo:delete',2,NULL,6),(32,58,'社团信息','club/myClub','',1,'mudedi',0),(33,60,'活动审批','club/clubactivity',NULL,1,'log',3),(34,33,'查看',NULL,'club:clubactivity:list,club:clubactivity:info',2,NULL,6),(35,33,'新增',NULL,'club:clubactivity:save',2,NULL,6),(36,33,'修改',NULL,'club:clubactivity:update',2,NULL,6),(37,33,'删除',NULL,'club:clubactivity:delete',2,NULL,6),(38,60,'经费审批','club/clubbudget',NULL,1,'zonghe',4),(39,38,'查看',NULL,'club:clubbudget:list,club:clubbudget:info',2,NULL,6),(40,38,'新增',NULL,'club:clubbudget:save',2,NULL,6),(41,38,'修改',NULL,'club:clubbudget:update',2,NULL,6),(42,38,'删除',NULL,'club:clubbudget:delete',2,NULL,6),(44,27,'查看',NULL,'club:clubconfig:list,club:clubconfig:info',2,NULL,6),(45,27,'新增',NULL,'club:clubconfig:save',2,NULL,6),(46,27,'修改',NULL,'club:clubconfig:update',2,NULL,6),(47,27,'删除',NULL,'club:clubconfig:delete',2,NULL,6),(48,60,'成员审批','club/clubuser',NULL,1,'admin',1),(49,48,'查看',NULL,'club:clubuser:list,club:clubuser:info',2,NULL,6),(50,48,'新增',NULL,'club:clubuser:save',2,NULL,6),(51,48,'修改',NULL,'club:clubuser:update',2,NULL,6),(52,48,'删除',NULL,'club:clubuser:delete',2,NULL,6),(53,1,'学院字典','aca/academy',NULL,1,'tubiao',6),(54,53,'查看',NULL,'aca:academy:list,aca:academy:info',2,NULL,6),(55,53,'新增',NULL,'aca:academy:save',2,NULL,6),(56,53,'修改',NULL,'aca:academy:update',2,NULL,6),(57,53,'删除',NULL,'aca:academy:delete',2,NULL,6),(58,0,'社团管理','','',0,'tubiao',10),(59,58,'成员列表','club/clubuserList','',1,'menu',2),(60,0,'学院管理','','',0,'daohang',20),(61,0,'管理列表','','',0,'mudedi',30),(62,60,'信息审批','club/clubList','',1,'tubiao',0),(63,60,'负责人列表','sys/clubUser','',1,'geren',50),(64,61,'考核详情','club/clubexam',NULL,1,'bianji',6),(65,64,'查看',NULL,'club:clubexam:list,club:clubexam:info',2,NULL,6),(66,64,'新增',NULL,'club:clubexam:save',2,NULL,6),(67,64,'修改',NULL,'club:clubexam:update',2,NULL,6),(68,64,'删除',NULL,'club:clubexam:delete',2,NULL,6),(69,61,'注册申请','club/clubreg',NULL,1,'shoucang',6),(70,69,'查看',NULL,'club:clubreg:list,club:clubreg:info',2,NULL,6),(71,69,'新增',NULL,'club:clubreg:save',2,NULL,6),(72,69,'修改',NULL,'club:clubreg:update',2,NULL,6),(73,69,'删除',NULL,'club:clubreg:delete',2,NULL,6),(74,60,'注册审批','club/clubreg','',1,'sousuo',10),(75,61,'社团统计','club/club-sta','',1,'daohang',10),(76,59,'查看','','club:clubuser:list,club:clubuser:info',2,'',0),(88,60,'社团列表','club/acaclub','',1,'zonghe',0),(89,61,'活动审核','club/clubac','',1,'zonghe',5);

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role` (
  `role_id` bigint NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_user_id` bigint DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

INSERT INTO `sys_role` VALUES (1,'超级管理员','学校管理人员',1,'2023-03-26 13:15:59'),(2,'普通管理员','二级学院管理员',1,'2023-03-26 13:16:06'),(3,'普通用户','社团负责人',1,'2023-03-26 13:16:22');

--
-- Table structure for table `sys_role_menu`
--

DROP TABLE IF EXISTS `sys_role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色与菜单对应关系';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_menu`
--

INSERT INTO `sys_role_menu` VALUES (4,1,1),(5,1,4),(6,1,23),(7,1,24),(8,1,25),(9,1,26),(10,1,53),(11,1,54),(12,1,55),(13,1,56),(14,1,57),(15,1,61),(16,1,2),(17,1,15),(18,1,16),(19,1,17),(20,1,18),(21,1,3),(22,1,19),(23,1,20),(24,1,21),(25,1,22),(26,1,27),(27,1,28),(28,1,29),(29,1,30),(30,1,31),(31,1,44),(32,1,45),(33,1,46),(34,1,47),(35,1,64),(36,1,65),(37,1,66),(38,1,67),(39,1,68),(40,1,69),(41,1,70),(42,1,71),(43,1,72),(44,1,73),(45,1,75),(46,1,-666666),(47,2,60),(48,2,62),(49,2,48),(50,2,49),(51,2,50),(52,2,51),(53,2,52),(54,2,33),(55,2,34),(56,2,35),(57,2,36),(58,2,37),(59,2,38),(60,2,39),(61,2,40),(62,2,41),(63,2,42),(64,2,74),(65,2,63),(66,2,-666666),(67,3,58),(68,3,32),(69,3,59),(70,3,-666666);

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_user` (
  `user_id` bigint NOT NULL AUTO_INCREMENT,
  `image` varchar(200) DEFAULT NULL COMMENT '头像',
  `name` varchar(30) NOT NULL COMMENT '姓名',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '盐',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `status` tinyint DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `ac_id` bigint DEFAULT NULL COMMENT '学院ID',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

INSERT INTO `sys_user` VALUES (1,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/29/987d3d5c-4a7d-4125-ae4d-c07a1fe953de.jpg','高启强','admin','9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d','YzcmCZNvbXocrsz9dm8e','abc@163.com','17899999999',1,1,'2023-11-11 11:11:11',1),(2,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/29/987d3d5c-4a7d-4125-ae4d-c07a1fe953de.jpg','张三','qqqqqq','e1da293d06a877720e6788e8c5043378f752bca21eab299adeb4bfd57cbf4579','ZXUrUtlh2y7EN31vU1Ir','123@qq.com','17888888888',1,1,'2023-03-29 20:21:17',1),(3,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/4c8f47be-d2d4-41e0-a0f9-3fec86130d0a.jpg','李四','111111','9b27e863d21f8d530fc68fe286d850421ece8784613db92b9d4cd3f740a8443f','vmPygICPGuJFQaKEKPzX','111111@qq.com','17777777777',1,1,'2023-03-30 14:07:59',1),(4,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/2f194ae3-f0a7-48d1-9d89-02458fe48eb7.jpg','王五','222222','25a014f18aea70624ebb37d2613e4a2e35e68c0415f58e14e3bed437058c6a51','vhxoUi0YN7UdPOT8ut5b','22222@qq.com','17822222222',1,1,'2023-03-30 14:08:33',1),(5,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/fd5ec4d9-9c4f-4feb-bb43-e575c756afbb.jpg','王五','zzzzzz','d5f6e1a980dd290670d9e6a30e4682b4289474f57aa6e874255cdea9f81833a9','44Uj4x37jg4nnut1zKhJ','31392@qq.com','17888885555',1,1,'2023-03-30 19:47:48',1),(6,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/03/30/864619a1-46e6-4273-ab94-d2da2f4afa0d.jpg','琪琪','abc123','b3157ffe75a2329281caed4c43726d9bb18bf19d69dcd6dc2b233f846c3bd4f6','ZdOtsfVQaHRKvoCojTRk','313982@qq.com','18899996666',1,1,'2023-03-30 19:52:15',2),(7,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/09/bc2e06e9-870c-43dd-942c-f783ef103ce3.jpg','手机','11111111','441a67d62260c7f04f113c6f8809df3fd8bdfdd76b1e410af5f7897bcc844ec2','dKgZWfEdldPZRq0Wuauv','111111@qq.com','17899999999',1,1,'2023-04-09 18:51:00',1),(8,'http://mikey2001-1311147997.cos.ap-chengdu.myqcloud.com/2023/04/09/5c6e8e92-8f82-4f0b-853e-0a18c718a3d5.jpg','大众','dazhong','9bfa6ba98d3f3d95a1e68ee5304c955439866ef8a382133146b4aa192fec9482','rMFTFBshpSAhPfZLyg0C','111111@qq.com','18966665555',1,1,'2023-04-09 20:54:49',1);

--
-- Table structure for table `sys_user_role`
--

DROP TABLE IF EXISTS `sys_user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_user_role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户与角色对应关系';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_role`
--

INSERT INTO `sys_user_role` VALUES (1,2,2),(2,1,1),(3,3,3),(4,4,3),(7,6,3),(8,5,2),(9,7,2),(10,8,3);

--
-- Table structure for table `sys_user_token`
--

DROP TABLE IF EXISTS `sys_user_token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_user_token` (
  `user_id` bigint NOT NULL,
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户Token';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_token`
--

INSERT INTO `sys_user_token` VALUES (1,'44fb46ea23a0606448a510ce22ed5502','2023-04-10 06:44:08','2023-04-09 18:44:08'),(5,'6fc542ae4ee4f10475b2699fc4c93993','2023-03-31 08:59:10','2023-03-30 20:59:10'),(6,'41585ee1d18fdf8012cfc6bd2519f72b','2023-03-31 08:39:45','2023-03-30 20:39:45');
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-04-09 21:49:14