独立版校园跑腿校园社区小程序系统源码.zip

-- MySQL dump 10.13 Distrib 5.7.39, for Linux (x86_64) -- -- Host: localhost Database: run -- ------------------------------------------------------ -- Server version 5.7.39-log /*!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 */; /*!40101 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 `gc_access` -- DROP TABLE IF EXISTS `gc_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gc_access` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分组ID', `purviewval` longtext COMMENT '分组对应权限值', `role_id` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`), KEY `group_id` (`role_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3279 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gc_access` -- LOCK TABLES `gc_access` WRITE; /*!40000 ALTER TABLE `gc_access` DISABLE KEYS */; INSERT INTO `gc_access` VALUES (3278,'admin/Reserve/view',22),(3277,'admin/Reserve/updateExt',22),(3276,'admin/Reserve/index',22),(3275,'admin/Reserve',22),(3274,'admin/Special/delete',22),(3273,'admin/Special/update',22),(3272,'admin/Special/add',22),(3271,'admin/Special/updateExt',22),(3270,'admin/Special/index',22),(3269,'admin/Special',22),(3268,'admin/Ticket/delete',22),(3267,'admin/Ticket/update',22),(3266,'admin/Ticket/add',22),(3265,'admin/Ticket/updateExt',22),(3264,'admin/Ticket/index',22),(3263,'admin/Ticket',22),(3262,'admin/Slide/view',22),(3261,'admin/Slide/delete',22),(3260,'admin/Slide/update',22),(3259,'admin/Slide/add',22),(3258,'admin/Slide/updateExt',22),(3257,'admin/Slide/index',22),(3256,'admin/Slide',22),(3255,'admin/Notice/view',22),(3254,'admin/Notice/delete',22),(3253,'admin/Notice/update',22),(3252,'admin/Notice/add',22),(3251,'admin/Notice/updateExt',22),(3250,'admin/Notice/index',22),(3249,'admin/Notice',22),(3248,'admin/TicketConfig/view',22),(3245,'admin/TicketConfig',22),(3246,'admin/TicketConfig/index',22),(3247,'admin/TicketConfig/update',22),(3244,'admin/Member/updateExt',22),(3243,'admin/Member/index',22),(3242,'admin/Member',22),(3241,'admin/Base/password',22),(3240,'admin/Index/main',22); /*!40000 ALTER TABLE `gc_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gc_account` -- DROP TABLE IF EXISTS `gc_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gc_account` ( `wxapp_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `account` varchar(250) DEFAULT NULL COMMENT '登录账号', `pwd` varchar(250) DEFAULT NULL COMMENT '登录密码', `create_time` int(11) DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`wxapp_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gc_account` -- LOCK TABLES `gc_account` WRITE; /*!40000 ALTER TABLE `gc_account` DISABLE KEYS */; INSERT INTO `gc_account` VALUES (6,'admin','de5a04c19b7959864497421f94054cbc',0); /*!40000 ALTER TABLE `gc_account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gc_action` -- DROP TABLE IF EXISTS `gc_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gc_action` ( `id` int(11) NOT NULL AUTO_INCREMENT, `menu_id` int(11) NOT NULL COMMENT '模块ID', `name` varchar(255) DEFAULT NULL COMMENT '动作名称', `action_name` varchar(128) NOT NULL COMMENT '动作名称', `type` tinyint(4) NOT NULL, `icon` varchar(32) DEFAULT NULL COMMENT 'icon图标', `pagesize` varchar(5) DEFAULT '20' COMMENT '每页显示数据条数', `is_view` tinyint(4) DEFAULT '0' COMMENT '是否按钮', `button_status` tinyint(4) DEFAULT NULL COMMENT '按钮是否显示列表', `sql_query` mediumtext COMMENT 'sql数据源', `block_name` varchar(255) DEFAULT NULL COMMENT '注释', `remark` varchar(255) DEFAULT NULL COMMENT '打开页面尺寸', `fields` text COMMENT '操作的字段', `note` varchar(255) DEFAULT NULL COMMENT '备注', `lable_color` varchar(12) DEFAULT NULL COMMENT '按钮背景色', `relate_table` varchar(32) DEFAULT NULL COMMENT '关联表', `relate_field` varchar(32) DEFAULT NULL COMMENT '关联字段', `list_field` varchar(255) DEFAULT NULL COMMENT '查询的字段', `bs_icon` varchar(32) DEFAULT NULL COMMENT '按钮图标', `sortid` mediumint(9) DEFAULT '0' COMMENT '排序', `orderby` varchar(250) DEFAULT NULL COMMENT '配置排序', `default_orderby` varchar(50) DEFAULT NULL COMMENT '默认排序', `tree_config` varchar(50) DEFAULT NULL, `jump` varchar(120) DEFAULT NULL COMMENT '按钮跳转地址', `is_controller_create` tinyint(4) DEFAULT '1' COMMENT '是否生成控制其方法', `is_service_create` tinyint(4) DEFAULT NULL COMMENT '是否生成服务层方法', `is_view_create` tinyint(4) DEFAULT NULL COMMENT '视图生成', `cache_time` mediumint(9) DEFAULT NULL COMMENT '缓存时间', `log_status` tinyint(4) DEFAULT NULL COMMENT '是否生成日志', `api_auth` tinyint(4) DEFAULT NULL COMMENT '接口是否鉴权', `sms_auth` tinyint(4) DEFAULT NULL COMMENT '短信验证', `captcha_auth` tinyint(4) DEFAULT NULL COMMENT '列表选中方式 1多选 2单选', `request_type` varchar(20) DEFAULT NULL COMMENT '请求类型', `do_condition` varchar(50) DEFAULT NULL COMMENT '操作条件', `select_type` tinyint(4) DEFAULT NULL, PRIMARY KEY (`id`), KEY `menu_id` (`menu_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2935 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gc_action` -- LOCK TABLES `gc_action` WRITE; /*!40000 ALTER TABLE `gc_action` DISABLE KEYS */; INSERT INTO `gc_action` VALUES (78,18,'首页数据列表','index',1,'','',0,0,'select a.*,group_concat(b.name) as role_name from pre_user as a left join pre_role as b on find_in_set(b.role_id,a.role_id) group by a.user_id','','','','','primary','','','','',1,'','','','',1,1,1,NULL,NULL,NULL,NULL,0,NULL,'',2),(80,18,'添加','add',3,'','20',1,0,'','添加账户','800px|600px','name,user,pwd,role_id,note,status,create_time,avatar','','primary','','','','fa fa-plus',3,'','','','',1,1,1,NULL,NULL,NULL,NULL,0,NULL,'',NULL),(81,18,'修改','update',4,'','',1,1,'','修改账户','800px|550px','name,user,role_id,note,status,create_time,avatar','','success','','','','fa fa-edit',4,'','','','',1,1,1,NULL,NULL,NULL,NULL,0,NULL,'',NULL),(82,18,'修改密码','updatePassword',9,'','',1,0,'','修改密码','600px|300px','pwd','','warning','','','','',6,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(85,19,'首页数据列表','index',1,'','',0,0,'','','600px|250px','','','primary','','','','',1,'','','pid,name','',1,1,1,NULL,NULL,NULL,NULL,0,NULL,'',1),(87,19,'添加','add',3,'','',1,0,'','添加分组','800px|400px','pid,name,status,description','','primary','','','','fa fa-plus',3,'','','','',1,1,1,NULL,NULL,NULL,NULL,0,NULL,'',NULL),(88,19,'修改','update',4,'','',1,1,'','修改分组','800px|400px','pid,name,status,description','','primary','','','','fa fa-edit',4,'','','','',1,1,1,NULL,NULL,NULL,NULL,0,NULL,'',NULL),(2131,19,'修改状态','updateExt',16,NULL,'',0,0,'','修改排序开关按钮操作','','',NULL,'primary','','','','',324,NULL,'','','',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(2132,19,'设置权限','auth',11,NULL,'',1,1,'','弹窗连接