-- MySQL dump 10.16 Distrib 10.1.32-MariaDB, for Linux (x86_64) -- -- Host: 0.0.0.0 Database: wechat -- ------------------------------------------------------ -- Server version 10.1.32-MariaDB /*!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 utf8 */; /*!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 `upload_manage_admin` -- DROP TABLE IF EXISTS `upload_manage_admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_admin` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID', `username` varchar(24) DEFAULT NULL COMMENT '管理员名', `email` varchar(150) DEFAULT NULL COMMENT '邮箱-可用于登录，请准确填写，不允许重复', `mobile` varchar(32) DEFAULT NULL COMMENT '手机号', `password` varchar(64) DEFAULT NULL COMMENT '管理员密码', `config` int(11) NOT NULL DEFAULT '1' COMMENT '后台配置', `role` varchar(100) DEFAULT NULL COMMENT '角色', `group` int(11) NOT NULL DEFAULT '1' COMMENT '分组', `top` text COMMENT '头部菜单-这里的头部菜单如果设置，则会覆盖角色中的头部菜单', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '数据状态', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_admin` -- LOCK TABLES `upload_manage_admin` WRITE; /*!40000 ALTER TABLE `upload_manage_admin` DISABLE KEYS */; INSERT INTO `upload_manage_admin` VALUES (1,'admin@admin.com','admin@admin.com',NULL,'8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92',1,'1',1,NULL,1,1,1543889304); /*!40000 ALTER TABLE `upload_manage_admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_manage_auth` -- DROP TABLE IF EXISTS `upload_manage_auth`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_auth` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `project` varchar(50) DEFAULT NULL COMMENT '项目KEY', `project_name` varchar(50) DEFAULT NULL COMMENT '项目名', `name` varchar(50) DEFAULT NULL COMMENT '权限名', `auth_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级权限', `key` varchar(100) DEFAULT NULL COMMENT '权限KEY', `value` varchar(30) DEFAULT NULL COMMENT '对应的值', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_auth` -- LOCK TABLES `upload_manage_auth` WRITE; /*!40000 ALTER TABLE `upload_manage_auth` DISABLE KEYS */; /*!40000 ALTER TABLE `upload_manage_auth` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_manage_config` -- DROP TABLE IF EXISTS `upload_manage_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_config` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID', `name` varchar(32) DEFAULT NULL COMMENT '配置名', `template` int(1) NOT NULL DEFAULT '1' COMMENT '后台模板', `title` varchar(32) DEFAULT NULL COMMENT '后台TITLE', `info` varchar(40) DEFAULT NULL COMMENT '控制台欢迎标题', `content` text COMMENT '控制台欢迎内容', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_config` -- LOCK TABLES `upload_manage_config` WRITE; /*!40000 ALTER TABLE `upload_manage_config` DISABLE KEYS */; INSERT INTO `upload_manage_config` VALUES (1,'默认配置',1,NULL,NULL,NULL,1,1543889304); /*!40000 ALTER TABLE `upload_manage_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_manage_group` -- DROP TABLE IF EXISTS `upload_manage_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_group` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '组ID', `name` varchar(50) DEFAULT NULL COMMENT '组名称', `area` varchar(255) DEFAULT NULL COMMENT '区域', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_group` -- LOCK TABLES `upload_manage_group` WRITE; /*!40000 ALTER TABLE `upload_manage_group` DISABLE KEYS */; INSERT INTO `upload_manage_group` VALUES (1,'默认分组',NULL,1,1543889305); /*!40000 ALTER TABLE `upload_manage_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_manage_log` -- DROP TABLE IF EXISTS `upload_manage_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `project` varchar(32) DEFAULT NULL COMMENT '项目名', `table` varchar(32) DEFAULT NULL COMMENT '项目下的表名', `info` longtext COMMENT '日志记录', `admin` int(11) NOT NULL DEFAULT '0' COMMENT '操作人', `tid` int(11) NOT NULL DEFAULT '0' COMMENT '来源表ID', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '操作时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_log` -- LOCK TABLES `upload_manage_log` WRITE; /*!40000 ALTER TABLE `upload_manage_log` DISABLE KEYS */; INSERT INTO `upload_manage_log` VALUES (1,'token','project','PHRhYmxlIGNsYXNzPSJkZXZlci1pbWciIGJvcmRlcj0xIHdpZHRoPTEwMCUgaGVpZ2h0PTEwMCUgIGlkPSJkZXZlci1pbWciPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7mk43kvZw8L3RkPjx0ZCBzdHlsZT13aWR0aDozMCU7d29yZC1icmVhazpicmVhay1hbGw7d29yZC13cmFwOmJyZWFrLXdvcmQ7Pmluc2VydDwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPXdpZHRoOjMwJTtsaW5lLWhlaWdodDoxLjc1O2ZvbnQtd2VpZ2h0OmJvbGQ+5pON5L2c5Lq6PC90ZD48dGQgc3R5bGU9d2lkdGg6MzAlO3dvcmQtYnJlYWs6YnJlYWstYWxsO3dvcmQtd3JhcDpicmVhay13b3JkOz5hZG1pbkBhZG1pbi5jb20tMTwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPXdpZHRoOjMwJTtsaW5lLWhlaWdodDoxLjc1O2ZvbnQtd2VpZ2h0OmJvbGQ+5pON5L2cSVA8L3RkPjx0ZCBzdHlsZT13aWR0aDozMCU7d29yZC1icmVhazpicmVhay1hbGw7d29yZC13cmFwOmJyZWFrLXdvcmQ7PjM2LjExMC44LjIyNjwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPXdpZHRoOjMwJTtsaW5lLWhlaWdodDoxLjc1O2ZvbnQtd2VpZ2h0OmJvbGQ+5pON5L2c5pe26Ze0PC90ZD48dGQgc3R5bGU9d2lkdGg6MzAlO3dvcmQtYnJlYWs6YnJlYWstYWxsO3dvcmQtd3JhcDpicmVhay13b3JkOz4yMDE4LTEyLTA0IDEwOjEwOjAzPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7mlbDmja5JRDwvdGQ+PHRkIHN0eWxlPXdpZHRoOjMwJTt3b3JkLWJyZWFrOmJyZWFrLWFsbDt3b3JkLXdyYXA6YnJlYWstd29yZDs+MTwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPXdpZHRoOjMwJTtsaW5lLWhlaWdodDoxLjc1O2ZvbnQtd2VpZ2h0OmJvbGQ+6aG555uu5ZCN56ewPC90ZD48dGQgc3R5bGU9d2lkdGg6MzAlO3dvcmQtYnJlYWs6YnJlYWstYWxsO3dvcmQtd3JhcDpicmVhay13b3JkOz7nsr7nvo7lsI/nqIvluo88L3RkPjwvdHI+PHRyPjx0ZCBzdHlsZT13aWR0aDozMCU7bGluZS1oZWlnaHQ6MS43NTtmb250LXdlaWdodDpib2xkPumhueebruexu+WeizwvdGQ+PHRkIHN0eWxlPXdpZHRoOjMwJTt3b3JkLWJyZWFrOmJyZWFrLWFsbDt3b3JkLXdyYXA6YnJlYWstd29yZDs+5bCP56iL5bqPPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7lvq7kv6FhcHBpZDwvdGQ+PHRkIHN0eWxlPXdpZHRoOjMwJTt3b3JkLWJyZWFrOmJyZWFrLWFsbDt3b3JkLXdyYXA6YnJlYWstd29yZDs+d3hkMDU5MDY2NGQwMDA0ZjIzPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7lvq7kv6FzZWNyZXQ8L3RkPjx0ZCBzdHlsZT13aWR0aDozMCU7d29yZC1icmVhazpicmVhay1hbGw7d29yZC13cmFwOmJyZWFrLXdvcmQ7PjAwOWJmNDhmZmQ1YTNjZWVjYjZhOTMzNDkyZDY0MWQyPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7pgJrkv6F0b2tlbijms6jmhI/kuI3mmK9hY2Nlc3NfdG9rZW4pPC90ZD48dGQgc3R5bGU9d2lkdGg6MzAlO3dvcmQtYnJlYWs6YnJlYWstYWxsO3dvcmQtd3JhcDpicmVhay13b3JkOz5udWxsPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7mtojmga/liqDop6Plr4blr4bpkqU8L3RkPjx0ZCBzdHlsZT13aWR0aDozMCU7d29yZC1icmVhazpicmVhay1hbGw7d29yZC13cmFwOmJyZWFrLXdvcmQ7Pm51bGw8L3RkPjwvdHI+PC90YWJsZT4=',1,1,1,1543889403); /*!40000 ALTER TABLE `upload_manage_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_manage_menu` -- DROP TABLE IF EXISTS `upload_manage_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_menu` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `name` varchar(50) DEFAULT NULL COMMENT '菜单名称', `menu_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级菜单', `key` varchar(100) DEFAULT NULL COMMENT '菜单唯一KEY', `link` varchar(150) DEFAULT NULL COMMENT '链接(或路径)', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序', `type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '开启子菜单', `icon` varchar(100) DEFAULT NULL COMMENT '图标代码-请点此查看图标代码', `fast` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否快捷菜单', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_menu` -- LOCK TABLES `upload_manage_menu` WRITE; /*!40000 ALTER TABLE `upload_manage_menu` DISABLE KEYS */; INSERT INTO `upload_manage_menu` VALUES (1,'主页',-1,'console','console:主页',10000,2,'layui-icon-home',2,1,1543889305),(2,'控制台',1,'console.index','http://www.huoxingkandiqiu.com/wechat/manage/?l=console',10,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(3,'后台设置',-1,'manage','/share/lib/php/dever_package/manage/:后台设置',-100,2,'glyphicon glyphicon-wrench layui-icon-set-sm',2,1,1543889305),(4,'管理账户设置',3,'manage.admin','project/database/list?project=manage&table=admin&menu=manage&search_option_state=1',9,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(5,'后台个性化',3,'manage.config','project/database/list?project=manage&table=config&menu=manage&search_option_state=1',10,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(6,'计划任务',3,'manage.cron','project/database/list?project=manage&table=cron&menu=manage&search_option_state=1',1,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(7,'管理组设置',3,'manage.group','project/database/list?project=manage&table=group&menu=manage&search_option_state=1',8,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(8,'管理操作日志',3,'manage.log','project/database/list?project=manage&table=log&menu=manage&search_option_state=1',1,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(9,'管理菜单设置',3,'manage.menu','project/database/list?project=manage&table=menu&menu=manage&search_option_state=1',2,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(10,'后台公告管理',3,'manage.notice','project/database/list?project=manage&table=notice&menu=manage&search_option_state=1',7,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(11,'字段记录表',3,'manage.opt','project/database/list?project=manage&table=opt&menu=manage&search_option_state=1',1,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(12,'管理角色设置',3,'manage.role','project/database/list?project=manage&table=role&menu=manage&search_option_state=1',8,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(13,'微信开发管理',-1,'token','/share/lib/php/dever_package/token/:微信开发管理',-1,2,'glyphicon glyphicon-road',2,1,1543889336),(14,'请求日志',13,'token.log','project/database/list?project=token&table=log&menu=token&search_option_state=1',1,2,'glyphicon glyphicon-folder-close',2,1,1543889336),(15,'项目管理',13,'token.project','project/database/list?project=token&table=project&menu=token&search_option_state=1',-10,2,'glyphicon glyphicon-folder-close',2,1,1543889336),(16,'小程序管理',-1,'wechat_applet','/share/lib/php/dever_package/wechat_applet/:小程序管理',90,2,'glyphicon glyphicon-tint',2,1,1543889345),(17,'模板消息列表',16,'wechat_applet.msg','project/database/list?project=wechat_applet&table=msg&menu=wechat_applet&search_option_state=1',100,2,'glyphicon glyphicon-folder-close',2,1,1543889345),(18,'模板消息日志',16,'wechat_applet.msg_log','project/database/list?project=wechat_applet&table=msg_log&menu=wechat_applet&search_option_state=1',90,2,'glyphicon glyphicon-folder-close',2,1,1543889345),(19,'发送模板消息',16,'wechat_applet.msg_send','project/database/list?project=wechat_applet&table=msg_send&menu=wechat_applet&search_option_state=1',90,2,'glyphicon glyphicon-folder-close',2,1,1543889345),(20,'统计概览',16,'wechat_applet.total_base','project/database/list?project=wechat_applet&table=total_base&menu=wechat_applet&search_option_state=1',20,2,'glyphicon glyphicon-folder-close',2,1,1543889345); /*!40000 ALTER TABLE `upload_manage_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_manage_notice` -- DROP TABLE IF EXISTS `upload_manage_notice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_notice` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '公告ID', `name` varchar(32) DEFAULT NULL COMMENT '公告标题', `config` int(11) NOT NULL DEFAULT '1' COMMENT '后台配置', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序(数值越大越靠前)', `content` text COMMENT '内容', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_notice` -- LOCK TABLES `upload_manage_notice` WRITE; /*!40000 ALTER TABLE `upload_manage_notice` DISABLE KEYS */; /*!40000 ALTER TABLE `upload_manage_notice` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_manage_role` -- DROP TABLE IF EXISTS `upload_manage_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_role` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色ID', `name` varchar(24) DEFAULT NULL COMMENT '角色名', `role_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级角色', `self` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否只能管理自己发布的内容-请在需要此项权限的表中增加[数据查询时影响的字段]', `col_select` varchar(30) DEFAULT NULL COMMENT '数据查询时影响的字段-该项影响数据查询，如果在表中增加该字段，则后台在查询数据时自动查询当前管理员的ID下的数据，多个用逗号隔开，与[是否只能管理自己发布的内容]相关', `col_insert` varchar(30) DEFAULT NULL COMMENT '数据插入时影响的字段-该项影响数据插入，如果在表中增加该字段，则后台操作时自动为该字段赋值为当前管理员的ID，多个用逗号隔开', `col_update` varchar(30) DEFAULT NULL COMMENT '数据更新时影响的字段-该项影响数据更新，如果在表中增加该字段，则后台操作时自动为该字段赋值为当前管理员的ID，多个用逗号隔开', `oper` varchar(24) DEFAULT NULL COMMENT '操作权限', `auth` text COMMENT '左侧菜单', `top` text COMMENT '右侧头部菜单', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序-数值越大越靠前', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_role` -- LOCK TABLES `upload_manage_role` WRITE; /*!40000 ALTER TABLE `upload_manage_role` DISABLE KEYS */; INSERT INTO `upload_manage_role` VALUES (1,'系统管理员',-1,2,'admin','admin','admin','1,2,3,4,5','all',NULL,1,1,1,1543889305),(2,'普通管理员',-1,2,'admin','admin','admin','1,2,3,4,5','',NULL,1,1,1,1543889305); /*!40000 ALTER TABLE `upload_manage_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_manage_top` -- DROP TABLE IF EXISTS `upload_manage_top`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_manage_top` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(50) DEFAULT NULL COMMENT '权限名', `top_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级权限', `key` varchar(100) DEFAULT NULL COMMENT '权限KEY', `value` varchar(30) DEFAULT NULL COMMENT '对应的值', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_manage_top` -- LOCK TABLES `upload_manage_top` WRITE; /*!40000 ALTER TABLE `upload_manage_top` DISABLE KEYS */; INSERT INTO `upload_manage_top` VALUES (1,'微信开发管理-项目选择',-1,'main/project_id','1',1,1543889336),(2,'精美小程序',1,'main/project_id-3_1','1',1,1543889403); /*!40000 ALTER TABLE `upload_manage_top` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_token_log` -- DROP TABLE IF EXISTS `upload_token_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_token_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(100) DEFAULT NULL COMMENT '请求名称', `url` varchar(255) DEFAULT NULL COMMENT '请求地址', `param` text COMMENT '请求信息', `result` longtext COMMENT '微信返回信息', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_token_log` -- LOCK TABLES `upload_token_log` WRITE; /*!40000 ALTER TABLE `upload_token_log` DISABLE KEYS */; /*!40000 ALTER TABLE `upload_token_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_token_project` -- DROP TABLE IF EXISTS `upload_token_project`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_token_project` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(60) DEFAULT NULL COMMENT '项目名称', `type` tinyint(11) NOT NULL DEFAULT '1' COMMENT '项目类型', `appid` varchar(150) DEFAULT NULL COMMENT '微信APPID', `secret` varchar(150) DEFAULT NULL COMMENT '微信SECRET', `token` varchar(150) DEFAULT NULL COMMENT '通信TOKEN(注意不是ACCESS_TOKEN)', `key` varchar(150) DEFAULT NULL COMMENT '消息加解密密钥', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_token_project` -- LOCK TABLES `upload_token_project` WRITE; /*!40000 ALTER TABLE `upload_token_project` DISABLE KEYS */; INSERT INTO `upload_token_project` VALUES (1,'精美小程序',3,'wxd0590664d0004f23','009bf48ffd5a3ceecb6a933492d641d2','','',1,1543889403); /*!40000 ALTER TABLE `upload_token_project` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_wechat_applet_msg` -- DROP TABLE IF EXISTS `upload_wechat_applet_msg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_wechat_applet_msg` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `project_id` int(11) NOT NULL DEFAULT '0' COMMENT '项目ID', `name` varchar(120) DEFAULT NULL COMMENT '模板标题', `key` varchar(20) DEFAULT NULL COMMENT '模板消息KEY-通过KEY值搜索数据', `template_id` varchar(120) DEFAULT NULL COMMENT '模板ID', `content` varchar(600) DEFAULT NULL COMMENT '模板内容', `example` varchar(600) DEFAULT NULL COMMENT '模板样例', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_wechat_applet_msg` -- LOCK TABLES `upload_wechat_applet_msg` WRITE; /*!40000 ALTER TABLE `upload_wechat_applet_msg` DISABLE KEYS */; /*!40000 ALTER TABLE `upload_wechat_applet_msg` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_wechat_applet_msg_log` -- DROP TABLE IF EXISTS `upload_wechat_applet_msg_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_wechat_applet_msg_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `project_id` int(11) NOT NULL DEFAULT '0' COMMENT '项目', `msg_id` int(11) NOT NULL DEFAULT '0' COMMENT '消息ID', `touser` varchar(120) DEFAULT NULL COMMENT '接收者', `page` varchar(200) DEFAULT NULL COMMENT '跳转页面', `data` text COMMENT '模板内容', `form_id` varchar(30) DEFAULT NULL COMMENT '表单或者支付ID', `emphasis_keyword` varchar(200) DEFAULT NULL COMMENT '模板需要放大的关键词', `num` int(11) NOT NULL DEFAULT '0' COMMENT '发送次数', `result` text COMMENT '微信返回信息', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_wechat_applet_msg_log` -- LOCK TABLES `upload_wechat_applet_msg_log` WRITE; /*!40000 ALTER TABLE `upload_wechat_applet_msg_log` DISABLE KEYS */; /*!40000 ALTER TABLE `upload_wechat_applet_msg_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_wechat_applet_msg_send` -- DROP TABLE IF EXISTS `upload_wechat_applet_msg_send`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_wechat_applet_msg_send` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `project_id` varchar(300) DEFAULT NULL COMMENT '选择项目', `key` varchar(20) DEFAULT NULL COMMENT '模板消息KEY', `page` varchar(200) DEFAULT NULL COMMENT '页面路径', `content` text COMMENT '模板内容', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_wechat_applet_msg_send` -- LOCK TABLES `upload_wechat_applet_msg_send` WRITE; /*!40000 ALTER TABLE `upload_wechat_applet_msg_send` DISABLE KEYS */; /*!40000 ALTER TABLE `upload_wechat_applet_msg_send` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `upload_wechat_applet_total_base` -- DROP TABLE IF EXISTS `upload_wechat_applet_total_base`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `upload_wechat_applet_total_base` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `project_id` int(11) NOT NULL DEFAULT '0' COMMENT '项目', `day` varchar(60) DEFAULT NULL COMMENT '统计日期', `daynum` int(11) NOT NULL DEFAULT '0' COMMENT '统计日期', `session_cnt` int(11) NOT NULL DEFAULT '0' COMMENT '打开次数', `visit_pv` int(11) NOT NULL DEFAULT '0' COMMENT '访问次数', `visit_uv` int(11) NOT NULL DEFAULT '0' COMMENT '访问人数', `visit_uv_new` int(11) NOT NULL DEFAULT '0' COMMENT '新用户数', `stay_time_uv` varchar(30) DEFAULT NULL COMMENT '人均停留时长', `stay_time_session` varchar(30) DEFAULT NULL COMMENT '次均停留时长', `visit_depth` varchar(30) DEFAULT NULL COMMENT '平均访问深度', `visit_total` int(11) NOT NULL DEFAULT '0' COMMENT '累计用户数', `share_pv` int(11) NOT NULL DEFAULT '0' COMMENT '转发次数', `share_uv` int(11) NOT NULL DEFAULT '0' COMMENT '转发人数', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `upload_wechat_applet_total_base` -- LOCK TABLES `upload_wechat_applet_total_base` WRITE; /*!40000 ALTER TABLE `upload_wechat_applet_total_base` DISABLE KEYS */; /*!40000 ALTER TABLE `upload_wechat_applet_total_base` ENABLE KEYS */; UNLOCK TABLES; /*!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 2018-12-04 10:35:14