-- MySQL dump 10.13  Distrib 5.7.26, for Win64 (x86_64)
--
-- Host: localhost    Database: app_hebhuazhen_c
-- ------------------------------------------------------
-- Server version	5.7.26-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 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 `qinty_jobs`
--

DROP TABLE IF EXISTS `qinty_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_jobs`
--

LOCK TABLES `qinty_jobs` WRITE;
/*!40000 ALTER TABLE `qinty_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `qinty_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_pic`
--

DROP TABLE IF EXISTS `qinty_pic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_pic` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL COMMENT '标题',
  `author_id` int(11) NOT NULL COMMENT '作者',
  `img` varchar(255) NOT NULL COMMENT '图片',
  `content` text COMMENT '简介',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态:1=显示,0=不显示',
  `sort` int(11) NOT NULL DEFAULT '50' COMMENT '排序',
  `hot` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '人气',
  `cate_id` int(10) NOT NULL COMMENT '分类id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='图片资源表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_pic`
--

LOCK TABLES `qinty_pic` WRITE;
/*!40000 ALTER TABLE `qinty_pic` DISABLE KEYS */;
INSERT INTO `qinty_pic` VALUES (1,'蒙娜丽莎的微笑',2,'/upload/sys/image/71/241786737b4c77d0600c049e3e1e63.jpg','《蒙娜丽莎》（Mona Lisa）是意大利文艺复兴时期画家列奥纳多·达·芬奇创作的油画，现收藏于法国卢浮宫博物馆。 [1]  该画作主要表现了女性的典雅和恬静的典型形象，塑造了资本主义上升时期一位城市有产阶级的妇女形象。 [2] \r\n《蒙娜丽莎》代表了文艺复兴时期的美学方向；该作品折射出来的女性的深邃与高尚的思想品质，反映了文艺复兴时期人们对于女性美的审美理念和审美追求。 [3] \r\n每年到卢浮宫鉴赏《蒙娜丽莎》作品的人数，大约有600万左右。 [4]  1952年，德国发行首枚《蒙娜丽莎》邮票。',1,1,0,2),(6,'圣母子与圣安妮',2,'/upload/sys/image/1c/b7d9eae557b10bef18aa8a7104582f.jpg','《圣母子与圣安妮》是意大利画家列奥纳多·达·芬奇于1508年－1510年期间创作的一幅油画。高约168.4厘米，长129.9厘米，背面由4块白杨木板组合而成，并由2根横梁固定。此前，这幅画一直收藏在法国巴黎卢浮宫博物馆，供来自世界各地的游客观赏。',1,2,0,2),(7,'高清梦幻森林蘑菇',3,'/upload/sys/image/4b/72547fe1cf370649a31ad12761a983.jpg','高清梦幻森林蘑菇高清梦幻森林蘑菇高清梦幻森林蘑菇高清梦幻森林蘑菇',1,1,0,1),(8,'三亚旅游',3,'/upload/sys/image/b5/dc3be5d52bbc280d9e9f9e5d8e177c.jpg','三亚旅游三亚旅游三亚旅游三亚旅游三亚旅游',1,5,3,4),(9,'森林里的小兔子彩铅画',3,'/upload/sys/image/4f/d8a5faf0f5b81764392f32ac0dc5f9.jpg','森林里的小兔子彩铅画森林里的小兔子彩铅画森林里的小兔子彩铅画',1,5,2,4),(10,'星空',3,'/upload/sys/image/57/f68782e4e82f2feb43da504f0e819d.jpg','星空星空星空星空星空星空星空星空星空星空星空星空星空星空星空星空星空',1,5,2,4),(11,'雨天',9,'/upload/sys/image/e1/1448945adfb4557fc665a4064e25fa.jpg','雨天雨天雨天',1,5,0,1),(12,'晚霞',9,'/upload/sys/image/64/f565f341815a2a7697c4e789658236.jpg','晚霞晚霞晚霞',1,5,0,1),(13,'外太空',9,'/upload/sys/image/82/be21968d1b7cac986fd5df8b086aa9.jpg','外太空外太空外太空',1,5,0,1),(14,'粉色',9,'/upload/sys/image/9f/48c40f3369375d537c07eac4b48b63.jpg','粉色粉色粉色',1,5,0,1),(16,'壁纸',9,'/upload/sys/image/d8/9c8ba0f0f6ae680d8d3fc63a9dc993.jpg','壁纸壁纸',1,5,0,1),(17,'雪花',9,'/upload/sys/image/c5/ace7326fbcde25b194fc8ae89c5c14.jpg','雪花雪花雪花',1,5,0,1),(18,'小狗',9,'/upload/sys/image/a3/55e889dd9d38e1e63ce76bdc4d7a98.jpg','小狗小狗小狗',1,5,0,1),(19,'日落',9,'/upload/sys/image/1a/d0bba0071c141e9ef25162a3b5a03b.jpg','日落日落',1,5,0,1),(20,'河流',9,'/upload/sys/image/62/2e977e07e3509ab088cadf64904576.jpg','河流河流',1,5,0,1),(21,'空中',9,'/upload/sys/image/f3/cf35877606772a829e2c1a1184718b.jpg','空中空中',1,5,0,1),(22,'动漫人物',10,'/upload/sys/image/37/0e22033d965a8e3684b35eb521963c.jpg','动漫人物动漫人物',1,5,0,2),(23,'高楼大厦',10,'/upload/sys/image/1c/7f550ad8c2a5f4d008f47dd88f3247.jpg','高楼大厦高楼大厦',1,5,0,2),(24,'拥抱',10,'/upload/sys/image/97/15def6ac7c136e505a37d45562447e.jpg','拥抱拥抱',1,5,0,2),(25,'招手',10,'/upload/sys/image/83/0b82d2e315c44b9ae04df828f9772b.jpg','招手招手招手',1,5,0,2),(26,'绘画',10,'/upload/sys/image/de/c2263ef700a9ab4cf5a4c3820711ea.jpg','绘画绘画',1,5,0,2),(27,'游泳',10,'/upload/sys/image/cd/c34d2d7b27461b8c66658a790a401b.jpg','游泳游泳游泳',1,5,0,2),(28,'蜡笔小新',10,'/upload/sys/image/5a/283cee5c211c28b94c3b4f90a20b4b.jpg','蜡笔小新蜡笔小新',1,5,0,2),(29,'背对着的人物',10,'/upload/sys/image/0f/6ee226a25a89b0c35ddd477dc49747.jpg','背对着的人物背对着的人物',1,5,0,2),(30,'埃菲尔铁塔',10,'/upload/sys/image/07/77640b8b8ab4e86d958ea4857b0e6c.jpg','埃菲尔铁塔埃菲尔铁塔',1,5,0,2),(31,'王俊凯',10,'/upload/sys/image/6b/f621a7bbf055a128e43924b3a6cfc7.jpg','王俊凯王俊凯王俊凯',1,5,0,2),(32,'雪山',11,'/upload/sys/image/25/433d6567ec7aa5021478ef929a9e04.jpg','雪山雪山雪山',1,5,0,3),(33,'帆船',11,'/upload/sys/image/af/b3e55f7a9ac232b177c341a0c3d864.jpg','帆船帆船',1,5,0,3),(34,'夜色',11,'/upload/sys/image/6d/433a1c989f8ebfe37af88f2d2e48d3.jpg','夜色夜色夜色',1,5,0,3),(35,'人物',11,'/upload/sys/image/35/6283af489fc938affb5c09c71a0774.jpg','人物人物人物',1,5,0,3),(36,'艺术',11,'/upload/sys/image/91/df735cd14aec4889e63e9e95aae139.jpg','艺术艺术',1,5,0,3),(37,'小人',11,'/upload/sys/image/aa/8b124f16ee0c4822bd57e530c028d8.jpg','小人小人小人',1,5,0,3),(38,'梦',11,'/upload/sys/image/f8/e0c39e817a33fed2d0aa1e8e1b10d9.jpg','梦梦梦',1,5,0,3),(39,'动漫人物',11,'/upload/sys/image/36/f72c0b4ad7a3bec328e1940f612ae8.jpg','动漫人物动漫人物',1,5,0,3),(40,'动画人物',11,'/upload/sys/image/ca/d7dd45f778cebce6df699c4f54c389.jpg','动画人物动画人物',1,5,0,3),(41,'火箭升空',11,'/upload/sys/image/2d/30aaf149cef99be22cb3695191f7ce.jpg','火箭升空火箭升空',1,5,0,3),(42,'彩色的画',12,'/upload/sys/image/2f/038cfd94cfc4e76028d26fea86dea0.jpg','彩色的画彩色的画',1,5,0,4),(43,'才貌双全',12,'/upload/sys/image/bd/9fa995d52b5aabc96ff8f7b8d90ae1.jpg','才貌双全才貌双全',1,5,0,4),(44,'效果',12,'/upload/sys/image/2f/8644f6b9b887642ef292d1c73df348.jpg','效果效果',1,5,0,4),(45,'双手',12,'/upload/sys/image/68/8187cc246d7b2e29e86942056fc215.jpg','双手双手',1,5,0,4),(46,'奶牛',12,'/upload/sys/image/01/730c5c6e85d7d32049b9adc4ca432c.jpg','奶牛奶牛',1,5,0,4),(47,'心形石头',12,'/upload/sys/image/d9/9788c624fb723ea4bdf33e1fb8d0cf.jpg','心形石头心形石头心形石头',1,5,2,4),(48,'划过',12,'/upload/sys/image/4e/363dc4fc0e06d7cde7aabf4bb1f148.jpg','划过划过',1,5,2,4),(49,'猫',12,'/upload/sys/image/f0/fc62b2aab5752d1db5bac3540e45d7.jpg','猫猫',1,5,1,4),(50,'大话西游',12,'/upload/sys/image/23/dd0159f93a46187d5c4ea07898ed92.jpg','大话西游大话西游',1,5,4,4),(51,'橙子',12,'/upload/sys/image/8d/91062e8cf3b3b94117eb2eb1e6b628.jpg','橙子橙子',1,5,3,4);
/*!40000 ALTER TABLE `qinty_pic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_pic_cate`
--

DROP TABLE IF EXISTS `qinty_pic_cate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_pic_cate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '分类名称',
  `img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类图片',
  `sort` tinyint(3) NOT NULL DEFAULT '5',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态:1=正常2=禁用',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_pic_cate`
--

LOCK TABLES `qinty_pic_cate` WRITE;
/*!40000 ALTER TABLE `qinty_pic_cate` DISABLE KEYS */;
INSERT INTO `qinty_pic_cate` VALUES (1,'网络','/upload/sys/image/b5/86b0c605b4d6ffeb2d061bed2fec95.jpg',1,1),(2,'人文','/upload/sys/image/aa/a19930e808ff2b2dcc9c198456a4a2.jpg',2,1),(3,'自然','/upload/sys/image/21/d1c9ef6796f81789a3a4f790c5a0ca.jpg',3,1),(4,'投票区','/upload/sys/image/66/4818cf2f465debd61840e7bcfdfd4d.jpg',4,1),(5,'投票结果','/upload/sys/image/be/880937f4e2d148be157a9624f01d8d.jpg',5,1);
/*!40000 ALTER TABLE `qinty_pic_cate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_annex`
--

DROP TABLE IF EXISTS `qinty_system_annex`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_annex` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联的数据ID',
  `type` varchar(20) NOT NULL DEFAULT '' COMMENT '类型',
  `group` varchar(100) NOT NULL DEFAULT 'sys' COMMENT '文件分组',
  `file` varchar(255) NOT NULL COMMENT '上传文件',
  `hash` varchar(64) NOT NULL COMMENT '文件hash值',
  `size` decimal(12,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '附件大小KB',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '使用状态(0未使用，1已使用)',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='[系统] 上传附件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_annex`
--

LOCK TABLES `qinty_system_annex` WRITE;
/*!40000 ALTER TABLE `qinty_system_annex` DISABLE KEYS */;
/*!40000 ALTER TABLE `qinty_system_annex` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_annex_group`
--

DROP TABLE IF EXISTS `qinty_system_annex_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_annex_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '附件分组',
  `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '附件数量',
  `size` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '附件大小kb',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='[系统] 附件分组';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_annex_group`
--

LOCK TABLES `qinty_system_annex_group` WRITE;
/*!40000 ALTER TABLE `qinty_system_annex_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `qinty_system_annex_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_config`
--

DROP TABLE IF EXISTS `qinty_system_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为系统配置(1是，0否)',
  `group` varchar(20) NOT NULL DEFAULT 'base' COMMENT '分组',
  `title` varchar(20) NOT NULL COMMENT '配置标题',
  `name` varchar(50) NOT NULL COMMENT '配置名称，由英文字母和下划线组成',
  `value` text NOT NULL COMMENT '配置值',
  `type` varchar(20) NOT NULL DEFAULT 'input' COMMENT '配置类型()',
  `options` text NOT NULL COMMENT '配置项(选项名:选项值)',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '文件上传接口',
  `tips` varchar(255) NOT NULL COMMENT '配置提示',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL COMMENT '状态',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='[系统] 系统配置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_config`
--

LOCK TABLES `qinty_system_config` WRITE;
/*!40000 ALTER TABLE `qinty_system_config` DISABLE KEYS */;
INSERT INTO `qinty_system_config` VALUES (1,1,'sys','扩展配置分组','config_group','','array',' ','','请按如下格式填写：<br>键值:键名<br>键值:键名<br><span style="color:#f00">键值只能为英文、数字、下划线</span>',2,1,1492140215,1492140215),(13,1,'base','网站域名','site_domain','','input','','','',2,1,1492140215,1492140215),(14,1,'upload','图片上传大小限制','upload_image_size','0','input','','','单位：KB，0表示不限制大小',3,1,1490841797,1491040778),(15,1,'upload','允许上传图片格式','upload_image_ext','jpg,png,gif,jpeg,ico','input','','','多个格式请用英文逗号（,）隔开',4,1,1490842130,1491040778),(16,1,'upload','缩略图裁剪方式','thumb_type','2','select','1:等比例缩放\r\n2:缩放后填充\r\n3:居中裁剪\r\n4:左上角裁剪\r\n5:右下角裁剪\r\n6:固定尺寸缩放\r\n','','',5,1,1490842450,1491040778),(17,1,'upload','图片水印开关','image_watermark','1','switch','0:关闭\r\n1:开启','','',6,1,1490842583,1491040778),(18,1,'upload','图片水印图','image_watermark_pic','','image','','','',7,1,1490842679,1491040778),(19,1,'upload','图片水印透明度','image_watermark_opacity','50','input','','','可设置值为0~100，数字越小，透明度越高',8,1,1490857704,1491040778),(20,1,'upload','图片水印图位置','image_watermark_location','9','select','7:左下角\r\n1:左上角\r\n4:左居中\r\n9:右下角\r\n3:右上角\r\n6:右居中\r\n2:上居中\r\n8:下居中\r\n5:居中','','',9,1,1490858228,1491040778),(21,1,'upload','文件上传大小限制','upload_file_size','0','input','','','单位：KB，0表示不限制大小',1,1,1490859167,1491040778),(22,1,'upload','允许上传文件格式','upload_file_ext','doc,docx,xls,xlsx,ppt,pptx,pdf,wps,txt,rar,zip','input','','','多个格式请用英文逗号（,）隔开',2,1,1490859246,1491040778),(23,1,'upload','文字水印开关','text_watermark','0','switch','0:关闭\r\n1:开启','','',10,1,1490860872,1491040778),(24,1,'upload','文字水印内容','text_watermark_content','','input','','','',11,1,1490861005,1491040778),(25,1,'upload','文字水印字体','text_watermark_font','','file','','','不上传将使用系统默认字体',12,1,1490861117,1491040778),(26,1,'upload','文字水印字体大小','text_watermark_size','20','input','','','单位：px(像素)',13,1,1490861204,1491040778),(27,1,'upload','文字水印颜色','text_watermark_color','#000000','input','','','文字水印颜色，格式:#000000',14,1,1490861482,1491040778),(28,1,'upload','文字水印位置','text_watermark_location','7','select','7:左下角\r\n1:左上角\r\n4:左居中\r\n9:右下角\r\n3:右上角\r\n6:右居中\r\n2:上居中\r\n8:下居中\r\n5:居中','','',11,1,1490861718,1491040778),(29,1,'upload','缩略图尺寸','thumb_size','300x300;500x500','input','','','为空则不生成，生成 500x500 的缩略图，则填写 500x500，多个规格填写参考 300x300;500x500;800x800',4,1,1490947834,1491040778),(30,1,'sys','开发模式','app_debug','1','switch','0:关闭\r\n1:开启','','<strong class="red">生产环境下一定要关闭此配置</strong>',3,1,1491005004,1492093874),(31,1,'sys','页面Trace','app_trace','0','switch','0:关闭\r\n1:开启','','<strong class="red">生产环境下一定要关闭此配置</strong>',4,1,1491005081,1492093874),(33,1,'sys','富文本编辑器','editor','umeditor','select','ueditor:UEditor\r\numeditor:UMEditor\r\nkindeditor:KindEditor\r\nckeditor:CKEditor','','',0,1,1491142648,1492140215),(35,1,'databases','备份目录','backup_path','./backup/database/','input','','','数据库备份路径,路径必须以 / 结尾',0,1,1491881854,1491965974),(36,1,'databases','备份分卷大小','part_size','20971520','input','','','用于限制压缩后的分卷最大长度。单位：B；建议设置20M',0,1,1491881975,1491965974),(37,1,'databases','备份压缩开关','compress','1','switch','0:关闭\r\n1:开启','','压缩备份文件需要PHP环境支持gzopen,gzwrite函数',0,1,1491882038,1491965974),(38,1,'databases','备份压缩级别','compress_level','4','radio','1:最低\r\n4:一般\r\n9:最高','','数据库备份文件的压缩级别，该配置在开启压缩时生效',0,1,1491882154,1491965974),(39,1,'base','网站状态','site_status','1','switch','0:关闭\r\n1:开启','','站点关闭后将不能访问，后台可正常登录',1,1,1492049460,1494690024),(40,1,'sys','后台管理路径','admin_path','admin.php','input','','','必须以.php为后缀',1,1,1492139196,1492140215),(41,1,'base','网站标题','site_title','qinty','input','','','网站标题是体现一个网站的主旨，要做到主题突出、标题简洁、连贯等特点，建议不超过28个字',6,1,1492502354,1494695131),(42,1,'base','网站关键词','site_keywords','qinty','input','','','网页内容所包含的核心搜索关键词，多个关键字请用英文逗号","分隔',7,1,1494690508,1494690780),(43,1,'base','网站描述','site_description','','textarea','','','网页的描述信息，搜索引擎采纳后，作为搜索结果中的页面摘要显示，建议不超过80个字',8,1,1494690669,1494691075),(44,1,'base','ICP备案信息','site_icp','','input','','','请填写ICP备案号，用于展示在网站底部，ICP备案官网：<a href="http://www.miibeian.gov.cn" target="_blank">http://www.miibeian.gov.cn</a>',9,1,1494691721,1494692046),(45,1,'base','站点统计代码','site_statis','','textarea','','','第三方流量统计代码，前台调用时请先用 htmlspecialchars_decode函数转义输出',10,1,1494691959,1494694797),(46,1,'base','网站名称','site_name','qinty','input','','','将显示在浏览器窗口标题等位置',3,1,1494692103,1494694680),(47,1,'base','网站LOGO','site_logo','','image','','','网站LOGO图片',4,1,1494692345,1494693235),(48,1,'base','网站图标','site_favicon','','image','','/system/annex/favicon','又叫网站收藏夹图标，它显示位于浏览器的地址栏或者标题前面，<strong class="red">.ico格式</strong>，<a href="https://www.baidu.com/s?ie=UTF-8&wd=favicon" target="_blank">点此了解网站图标</a>',5,1,1494692781,1494693966),(49,1,'base','手机网站','wap_site_status','1','switch','0:关闭\r\n1:开启','','如果有手机网站，请设置为开启状态，否则只显示PC网站',2,1,1498405436,1498405436),(50,1,'sys','云端推送','cloud_push','0','switch','0:关闭\r\n1:开启','','关闭之后，无法通过云端推送安装扩展',5,1,1504250320,1504250320),(51,1,'base','手机网站域名','wap_domain','','input','','','手机访问将自动跳转至此域名，示例：http://m.domain.com',2,1,1504304776,1504304837),(52,1,'sys','多语言支持','multi_language','0','switch','0:关闭\r\n1:开启','','开启后你可以自由上传多种语言包',6,1,1506532211,1506532211),(53,1,'sys','后台白名单验证','admin_whitelist_verify','0','switch','0:禁用\r\n1:启用','','禁用后不存在的菜单节点将不在提示',7,1,1542012232,1542012321),(54,1,'sys','系统日志保留','system_log_retention','30','input','','','单位天，系统将自动清除 ? 天前的系统日志',8,1,1542013958,1542014158),(55,1,'upload','上传驱动','upload_driver','local','select','local:本地上传','','资源上传驱动设置',0,1,1558599270,1558618703),(56,0,'base','首页图片','index_pic','/upload/sys/image/4d/a0f7b9ec03005f5cdd493ff2d0ad69.jpg','image','','','',0,1,1601375067,1601375067);
/*!40000 ALTER TABLE `qinty_system_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_hook`
--

DROP TABLE IF EXISTS `qinty_system_hook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_hook` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '系统插件',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名称',
  `source` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子来源[plugins.插件名，module.模块名]',
  `intro` varchar(200) NOT NULL DEFAULT '' COMMENT '钩子简介',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 钩子表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_hook`
--

LOCK TABLES `qinty_system_hook` WRITE;
/*!40000 ALTER TABLE `qinty_system_hook` DISABLE KEYS */;
INSERT INTO `qinty_system_hook` VALUES (1,1,'system_admin_index','','后台首页',1,1490885108,1490885108),(2,1,'system_admin_tips','','后台所有页面提示',1,1490713165,1490885137),(3,1,'system_annex_upload','','附件上传钩子，可扩展上传到第三方存储',1,1490884242,1490885121),(4,1,'system_member_login','','会员登陆成功之后的动作',1,1490885108,1490885108),(5,1,'system_member_register','','会员注册成功后的动作',1,1512610518,1512610518);
/*!40000 ALTER TABLE `qinty_system_hook` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_hook_plugins`
--

DROP TABLE IF EXISTS `qinty_system_hook_plugins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_hook_plugins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `hook` varchar(32) NOT NULL COMMENT '钩子id',
  `plugins` varchar(32) NOT NULL COMMENT '插件标识',
  `ctime` int(11) unsigned NOT NULL DEFAULT '0',
  `mtime` int(11) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 钩子-插件对应表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_hook_plugins`
--

LOCK TABLES `qinty_system_hook_plugins` WRITE;
/*!40000 ALTER TABLE `qinty_system_hook_plugins` DISABLE KEYS */;
INSERT INTO `qinty_system_hook_plugins` VALUES (1,'system_admin_index','hisiphp',1509380301,1509380301,0,1);
/*!40000 ALTER TABLE `qinty_system_hook_plugins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_language`
--

DROP TABLE IF EXISTS `qinty_system_language`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_language` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '语言包名称',
  `code` varchar(20) NOT NULL DEFAULT '' COMMENT '编码',
  `locale` varchar(255) NOT NULL DEFAULT '' COMMENT '本地浏览器语言编码',
  `icon` varchar(30) NOT NULL DEFAULT '' COMMENT '图标',
  `pack` varchar(100) NOT NULL DEFAULT '' COMMENT '上传的语言包',
  `sort` tinyint(2) unsigned NOT NULL DEFAULT '1',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='[系统] 语言包';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_language`
--

LOCK TABLES `qinty_system_language` WRITE;
/*!40000 ALTER TABLE `qinty_system_language` DISABLE KEYS */;
INSERT INTO `qinty_system_language` VALUES (1,'简体中文','zh-cn','zh-CN,zh-CN.UTF-8,zh-cn','','1',1,1);
/*!40000 ALTER TABLE `qinty_system_language` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_log`
--

DROP TABLE IF EXISTS `qinty_system_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(100) DEFAULT '',
  `url` varchar(200) DEFAULT '',
  `param` text,
  `remark` varchar(255) DEFAULT '',
  `count` int(10) unsigned NOT NULL DEFAULT '1',
  `ip` varchar(128) DEFAULT '',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 COMMENT='[系统] 操作日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_log`
--

LOCK TABLES `qinty_system_log` WRITE;
/*!40000 ALTER TABLE `qinty_system_log` DISABLE KEYS */;
INSERT INTO `qinty_system_log` VALUES (1,1,'后台首页','/admin.php/system/index/index.html','[]','浏览数据',30,'27.184.12.184',1601281733,1603589661),(2,1,'本地模块','/admin.php/system/module/index.html','[]','浏览数据',7,'60.1.120.233',1601281746,1602661716),(3,1,'应用市场','/admin.php/system/store/index.html','[]','浏览数据',6,'60.1.120.233',1601281748,1602661718),(4,1,'应用市场','/admin.php/system/store/index.html?page=1&limit=10','{\"page\":\"1\",\"limit\":\"10\"}','浏览数据',6,'60.1.120.233',1601281748,1602661718),(5,1,'生成模块','/admin.php/system/module/design.html','[]','浏览数据',3,'127.0.0.1',1601281814,1601375144),(6,1,'生成模块','/admin.php/system/module/design.html','{\"name\":\"pic\",\"title\":\"\\u56fe\\u7247\\u7ba1\\u7406\",\"identifier\":\"pic.qinty.module\",\"intro\":\"\",\"author\":\"qinty\",\"url\":\"https:\\/\\/qinty.net\\/\",\"version\":\"1.0.0\",\"file\":\"common.php\",\"dir\":\"admin\\r\\nhome\\r\\nconfig\\r\\nmodel\\r\\nlang\\r\\nsql\\r\\nvalidate\\r\\nview\"}','保存数据',1,'127.0.0.1',1601282700,1601282700),(7,1,'本地模块','/admin.php/system/module/index/status/0.html','{\"status\":\"0\"}','浏览数据',1,'127.0.0.1',1601282703,1601282703),(8,1,'状态设置','/admin.php/system/module/status/id/4.html?val=1','{\"val\":\"1\",\"id\":\"4\"}','浏览数据',1,'127.0.0.1',1601282709,1601282709),(9,1,'安装模块','/admin.php/system/module/install/id/4.html','{\"id\":\"4\"}','浏览数据',1,'127.0.0.1',1601282714,1601282714),(10,1,'安装模块','/admin.php/system/module/install.html','{\"clear\":\"0\",\"demo_data\":\"0\",\"id\":\"4\"}','保存数据',1,'127.0.0.1',1601282719,1601282719),(11,1,'本地模块','/admin.php/system/module/index/status/2.html','{\"status\":\"2\"}','浏览数据',2,'127.0.0.1',1601282722,1601282733),(12,1,'主题管理','/admin.php/system/module/theme/id/4.html','{\"id\":\"4\"}','浏览数据',1,'127.0.0.1',1601282730,1601282730),(13,1,'本地插件','/admin.php/system/plugins/index.html','[]','浏览数据',3,'127.0.0.1',1601282746,1601373429),(14,1,'插件钩子','/admin.php/system/hook/index.html','[]','浏览数据',4,'127.0.0.1',1601282747,1601373431),(15,1,'插件钩子','/admin.php/system/hook/index.html?page=1&limit=20','{\"page\":\"1\",\"limit\":\"20\"}','浏览数据',4,'127.0.0.1',1601282747,1601373431),(16,1,'框架升级','/admin.php/system/upgrade/index.html','[]','浏览数据',3,'127.0.0.1',1601282749,1601373416),(17,1,'系统菜单','/admin.php/system/menu/index.html','[]','浏览数据',22,'27.184.12.184',1601282909,1603590212),(18,1,'添加菜单','/admin.php/system/menu/add/pid/141/mod/pic.html','{\"pid\":\"141\",\"mod\":\"pic\"}','浏览数据',2,'127.0.0.1',1601282912,1601282978),(19,1,'添加菜单','/admin.php/system/menu/add.html','{\"pid\":\"143\",\"title\":\"\\u6295\\u7968\\u7ba1\\u7406\",\"icon\":\"\",\"url\":\"pic\\/pic\\/index\",\"param\":\"\",\"status\":\"1\",\"system\":\"0\",\"nav\":\"1\",\"id\":\"\",\"module\":\"pic\"}','保存数据',7,'60.1.120.233',1601282971,1603519176),(20,1,'添加菜单','/admin.php/system/menu/add/pid/142/mod/pic.html','{\"pid\":\"142\",\"mod\":\"pic\"}','浏览数据',2,'127.0.0.1',1601283039,1601283091),(21,1,'添加菜单','/admin.php/system/menu/add/pid/143/mod/pic.html','{\"pid\":\"143\",\"mod\":\"pic\"}','浏览数据',4,'60.1.120.233',1601286246,1603519164),(22,1,'作者管理','/admin.php/pic/authors/index.html','[]','浏览数据',65,'27.184.12.184',1601286644,1603589962),(23,1,'作者管理','/admin.php/pic/authors/index.html?page=1&limit=20','{\"page\":\"1\",\"limit\":\"20\"}','浏览数据',61,'27.184.12.184',1601286876,1603589963),(24,1,'未加入系统菜单','/admin.php/pic/authors/add.html?hisi_iframe=yes','{\"hisi_iframe\":\"yes\"}','浏览数据',17,'60.1.120.233',1601287565,1603097731),(25,1,'未加入系统菜单','/admin.php/pic/authors/edit.html?id=2&hisi_iframe=yes','{\"id\":\"2\",\"hisi_iframe\":\"yes\"}','浏览数据',9,'127.0.0.1',1601361184,1601361565),(26,1,'未加入系统菜单','/admin.php/pic/authors/edit.html','{\"nickname\":\"\\u8fbe\\u82ac\\u5947\",\"identifier\":\"dafenqi1\",\"password\":\"123456\",\"repasswd\":\"123456\",\"__token__\":\"bc94918a07c550e1a1fed67da4af10b3\",\"id\":\"2\"}','保存数据',8,'127.0.0.1',1601361292,1601361572),(27,1,'图片分类','/admin.php/pic/pic_cate/index.html','[]','浏览数据',67,'27.184.12.184',1601361909,1603589968),(28,1,'图片分类','/admin.php/pic/pic_cate/index.html?page=1&limit=20','{\"page\":\"1\",\"limit\":\"20\"}','浏览数据',65,'27.184.12.184',1601362230,1603589968),(29,1,'未加入系统菜单','/admin.php/pic/pic_cate/add.html?hisi_iframe=yes','{\"hisi_iframe\":\"yes\"}','浏览数据',16,'127.0.0.1',1601362285,1602226354),(30,1,'配置管理','/admin.php/system/config/index.html','[]','浏览数据',8,'27.184.12.184',1601365705,1603589908),(31,1,'配置管理','/admin.php/system/config/index.html?page=1&limit=20','{\"page\":\"1\",\"limit\":\"20\"}','浏览数据',8,'27.184.12.184',1601365705,1603589908),(32,1,'系统设置','/admin.php/system/system/index.html','[]','浏览数据',8,'27.184.12.184',1601365706,1603589909),(33,1,'附件上传','/admin.php/system/annex/upload/thumb/no/water/no.html','{\"thumb\":\"no\",\"water\":\"no\"}','保存数据',62,'60.1.120.233',1601367894,1603098618),(34,1,'未加入系统菜单','/admin.php/pic/pic_cate/add.html','{\"name\":\"\\u6295\\u7968\\u7ed3\\u679c\",\"img\":\"\\/upload\\/sys\\/image\\/be\\/880937f4e2d148be157a9624f01d8d.jpg\",\"sort\":\"5\",\"id\":\"\"}','保存数据',7,'127.0.0.1',1601368114,1602226574),(35,1,'未加入系统菜单','/admin.php/pic/pic_cate/edit.html?id=1&hisi_iframe=yes','{\"id\":\"1\",\"hisi_iframe\":\"yes\"}','浏览数据',8,'127.0.0.1',1601368541,1602219328),(36,1,'图片列表','/admin.php/pic/pic/index.html','[]','浏览数据',121,'27.184.12.184',1601371050,1603590036),(37,1,'图片列表','/admin.php/pic/pic/index.html?page=1&limit=20','{\"page\":\"1\",\"limit\":\"20\"}','浏览数据',120,'27.184.12.184',1601371129,1603590036),(38,1,'未加入系统菜单','/admin.php/pic/pic/add.html?hisi_iframe=yes','{\"hisi_iframe\":\"yes\"}','浏览数据',74,'60.1.120.233',1601371154,1603098607),(39,1,'未加入系统菜单','/admin.php/pic/pic/add.html','{\"cate_id\":\"4\",\"title\":\"\\u6a59\\u5b50\",\"author_id\":\"12\",\"img\":\"\\/upload\\/sys\\/image\\/8d\\/91062e8cf3b3b94117eb2eb1e6b628.jpg\",\"content\":\"\\u6a59\\u5b50\\u6a59\\u5b50\",\"sort\":\"5\",\"status\":\"1\",\"id\":\"\"}','保存数据',51,'60.1.120.233',1601372380,1603098620),(40,1,'未加入系统菜单','/admin.php/pic/pic/edit.html?id=1&hisi_iframe=yes','{\"id\":\"1\",\"hisi_iframe\":\"yes\"}','浏览数据',4,'127.0.0.1',1601372395,1601372566),(41,1,'未加入系统菜单','/admin.php/pic/pic/status.html?id=1&val=0','{\"id\":\"1\",\"val\":\"0\"}','浏览数据',3,'127.0.0.1',1601372465,1601373223),(42,1,'未加入系统菜单','/admin.php/pic/pic/status.html?id=1&val=1','{\"id\":\"1\",\"val\":\"1\"}','浏览数据',3,'127.0.0.1',1601372472,1601373223),(43,1,'未加入系统菜单','/admin.php/pic/pic/sort.html?id=1','{\"id\":\"1\",\"val\":\"1\"}','保存数据',2,'127.0.0.1',1601372565,1601372570),(44,1,'未加入系统菜单','/admin.php/pic/pic/del.html?id=2','{\"id\":\"2\"}','浏览数据',1,'127.0.0.1',1601372702,1601372702),(45,1,'未加入系统菜单','/admin.php/pic/pic/del.html?id=3','{\"id\":\"3\"}','浏览数据',1,'127.0.0.1',1601372787,1601372787),(46,1,'未加入系统菜单','/admin.php/pic/pic/del.html?id=4','{\"id\":\"4\"}','浏览数据',1,'127.0.0.1',1601372829,1601372829),(47,1,'未加入系统菜单','/admin.php/pic/pic/del.html?id=5','{\"id\":\"5\"}','浏览数据',1,'127.0.0.1',1601373029,1601373029),(48,1,'系统管理员','/admin.php/system/user/index.html','[]','浏览数据',1,'127.0.0.1',1601373404,1601373404),(49,1,'系统管理员','/admin.php/system/user/index.html?page=1&limit=20','{\"page\":\"1\",\"limit\":\"20\"}','浏览数据',1,'127.0.0.1',1601373404,1601373404),(50,1,'数据库管理','/admin.php/system/database/index.html','[]','浏览数据',1,'127.0.0.1',1601373405,1601373405),(51,1,'数据库管理','/admin.php/system/database/index.html?group=export&page=1&limit=10','{\"group\":\"export\",\"page\":\"1\",\"limit\":\"10\"}','浏览数据',1,'127.0.0.1',1601373405,1601373405),(52,1,'系统日志','/admin.php/system/log/index.html','[]','浏览数据',1,'127.0.0.1',1601373406,1601373406),(53,1,'系统日志','/admin.php/system/log/index.html?page=1&limit=20','{\"page\":\"1\",\"limit\":\"20\"}','浏览数据',1,'127.0.0.1',1601373406,1601373406),(54,1,'图片列表','/admin.php/pic/pic/index.html?page=1&limit=20&title=%E8%92%99%E5%A8%9C&author_id=&cate_id=','{\"page\":\"1\",\"limit\":\"20\",\"title\":\"\\u8499\\u5a1c\",\"author_id\":\"\",\"cate_id\":\"\"}','浏览数据',1,'127.0.0.1',1601374069,1601374069),(55,1,'图片列表','/admin.php/pic/pic/index.html?page=1&limit=20&title=&author_id=2&cate_id=','{\"page\":\"1\",\"limit\":\"20\",\"title\":\"\",\"author_id\":\"2\",\"cate_id\":\"\"}','浏览数据',1,'127.0.0.1',1601374075,1601374075),(56,1,'图片列表','/admin.php/pic/pic/index.html?page=1&limit=20&title=&author_id=2&cate_id=3','{\"page\":\"1\",\"limit\":\"20\",\"title\":\"\",\"author_id\":\"2\",\"cate_id\":\"3\"}','浏览数据',1,'127.0.0.1',1601374080,1601374080),(57,1,'图片列表','/admin.php/pic/pic/index.html?page=1&limit=20&title=&author_id=2&cate_id=2','{\"page\":\"1\",\"limit\":\"20\",\"title\":\"\",\"author_id\":\"2\",\"cate_id\":\"2\"}','浏览数据',1,'127.0.0.1',1601374082,1601374082),(58,1,'未加入系统菜单','/admin.php/pic/pic_cate/edit.html?id=3&hisi_iframe=yes','{\"id\":\"3\",\"hisi_iframe\":\"yes\"}','浏览数据',4,'127.0.0.1',1601374347,1602219314),(59,1,'未加入系统菜单','/admin.php/pic/pic_cate/sort.html?id=1','{\"id\":\"1\",\"val\":\"1\"}','保存数据',2,'127.0.0.1',1601374401,1601374407),(60,1,'未加入系统菜单','/admin.php/pic/pic_cate/sort.html?id=3','{\"id\":\"3\",\"val\":\"4\"}','保存数据',2,'127.0.0.1',1601374438,1601374459),(61,1,'未加入系统菜单','/admin.php/pic/pic_cate/edit.html','{\"name\":\"\\u6295\\u7968\\u533a\",\"img\":\"\\/upload\\/sys\\/image\\/66\\/4818cf2f465debd61840e7bcfdfd4d.jpg\",\"sort\":\"4\",\"id\":\"4\"}','保存数据',10,'127.0.0.1',1601374467,1602219380),(62,1,'未加入系统菜单','/admin.php/pic/authors/add.html','{\"nickname\":\"\\u5f204\",\"identifier\":\"tu123456\",\"password\":\"123456\",\"repasswd\":\"123456\",\"__token__\":\"ac8f43675f8755c58c5b64d248e8b459\",\"id\":\"\"}','保存数据',7,'60.1.120.233',1601374748,1603097742),(63,1,'基础配置','/admin.php/system/system/index/group/base.html','{\"id\":{\"index_pic\":\"\\/upload\\/sys\\/image\\/4d\\/a0f7b9ec03005f5cdd493ff2d0ad69.jpg\",\"site_status\":\"1\",\"site_domain\":\"\",\"wap_site_status\":\"1\",\"wap_domain\":\"\",\"site_name\":\"qinty\",\"site_logo\":\"\",\"site_favicon\":\"\",\"site_title\":\"qinty\",\"site_keywords\":\"qinty\",\"site_description\":\"\",\"site_icp\":\"\",\"site_statis\":\"\"},\"type\":{\"index_pic\":\"image\",\"site_status\":\"switch\",\"site_domain\":\"input\",\"wap_site_status\":\"switch\",\"wap_domain\":\"input\",\"site_name\":\"input\",\"site_logo\":\"image\",\"site_favicon\":\"image\",\"site_title\":\"input\",\"site_keywords\":\"input\",\"site_description\":\"textarea\",\"site_icp\":\"input\",\"site_statis\":\"textarea\"},\"__token__\":\"0b8d90ee8438245389ce483fd90d04c1\",\"group\":\"base\"}','保存数据',2,'127.0.0.1',1601375012,1601375128),(64,1,'基础配置','/admin.php/system/system/index/group/base.html','{\"group\":\"base\"}','浏览数据',2,'127.0.0.1',1601375015,1601375131),(65,1,'添加配置','/admin.php/system/config/add.html','[]','浏览数据',2,'127.0.0.1',1601375034,1601375070),(66,1,'添加配置','/admin.php/system/config/add.html','{\"group\":\"base\",\"title\":\"\\u9996\\u9875\\u56fe\\u7247\",\"name\":\"index_pic\",\"type\":\"image\",\"value\":\"\",\"options\":\"\",\"tips\":\"\",\"status\":\"1\",\"id\":\"\"}','保存数据',1,'127.0.0.1',1601375067,1601375067),(67,1,'未加入系统菜单','/admin.php/pic/pic_cate/edit.html?id=4&hisi_iframe=yes','{\"id\":\"4\",\"hisi_iframe\":\"yes\"}','浏览数据',2,'127.0.0.1',1602219195,1602219375),(68,1,'未加入系统菜单','/admin.php/pic/pic_cate/edit.html?id=2&hisi_iframe=yes','{\"id\":\"2\",\"hisi_iframe\":\"yes\"}','浏览数据',2,'127.0.0.1',1602219274,1602219294),(69,1,'应用市场','/admin.php/system/store/index.html?type=2&page=1&limit=10','{\"type\":\"2\",\"page\":\"1\",\"limit\":\"10\"}','浏览数据',2,'60.1.120.233',1602661739,1602661790),(70,1,'应用市场','/admin.php/system/store/index.html?type=3&page=1&limit=10','{\"type\":\"3\",\"page\":\"1\",\"limit\":\"10\"}','浏览数据',1,'60.1.120.233',1602661754,1602661754),(71,1,'未加入系统菜单','/admin.php/pic/pic/sort.html?id=12','{\"id\":\"12\",\"val\":\"5\"}','保存数据',1,'60.1.120.233',1603097180,1603097180),(72,1,'图片列表','/admin.php/pic/pic/index.html?page=1&limit=20&title=&author_id=9&cate_id=1','{\"page\":\"1\",\"limit\":\"20\",\"title\":\"\",\"author_id\":\"9\",\"cate_id\":\"1\"}','浏览数据',1,'60.1.120.233',1603097213,1603097213),(73,1,'未加入系统菜单','/admin.php/pic/pic/edit.html?id=14&hisi_iframe=yes','{\"id\":\"14\",\"hisi_iframe\":\"yes\"}','浏览数据',6,'60.1.120.233',1603097299,1603097404),(74,1,'未加入系统菜单','/admin.php/pic/pic/edit.html?id=7&hisi_iframe=yes','{\"id\":\"7\",\"hisi_iframe\":\"yes\"}','浏览数据',1,'60.1.120.233',1603097320,1603097320),(75,1,'未加入系统菜单','/admin.php/pic/pic/edit.html?id=15&hisi_iframe=yes','{\"id\":\"15\",\"hisi_iframe\":\"yes\"}','浏览数据',2,'60.1.120.233',1603097322,1603097339),(76,1,'未加入系统菜单','/admin.php/pic/pic/del.html?id=15','{\"id\":\"15\"}','浏览数据',1,'60.1.120.233',1603097337,1603097337),(77,1,'未加入系统菜单','/admin.php/pic/pic/edit.html?id=14','{\"id\":\"14\"}','浏览数据',1,'60.1.120.233',1603097390,1603097390),(78,1,'未加入系统菜单','/admin.php/pic/pic/edit.html','{\"cate_id\":\"1\",\"title\":\"\\u7c89\\u8272\",\"author_id\":\"9\",\"img\":\"\\/upload\\/sys\\/image\\/9f\\/48c40f3369375d537c07eac4b48b63.jpg\",\"content\":\"\\u7c89\\u8272\\u7c89\\u8272\\u7c89\\u8272\",\"sort\":\"5\",\"status\":\"1\",\"id\":\"14\"}','保存数据',1,'60.1.120.233',1603097413,1603097413),(79,1,'未加入系统菜单','/admin.php/pic/pic/sort.html?id=7','{\"id\":\"7\",\"val\":\"1\"}','保存数据',1,'60.1.120.233',1603097419,1603097419),(80,1,'清空缓存','/admin.php/system/index/clear.html','{\"cache\":\"1\",\"log\":\"1\",\"temp\":\"1\"}','保存数据',1,'60.1.120.233',1603173425,1603173425),(81,1,'状态设置','/admin.php/system/menu/status/table/admin_menu/id/145.html?val=0','{\"val\":\"0\",\"table\":\"admin_menu\",\"id\":\"145\"}','浏览数据',1,'60.1.120.233',1603519027,1603519027),(82,1,'图片列表','/admin.php/pic/pic/index.html?page=1&limit=20&title=&author_id=&cate_id=4','{\"page\":\"1\",\"limit\":\"20\",\"title\":\"\",\"author_id\":\"\",\"cate_id\":\"4\"}','浏览数据',1,'60.1.120.233',1603519108,1603519108),(83,1,'修改菜单','/admin.php/system/menu/edit/id/146/mod/pic.html','{\"id\":\"146\",\"mod\":\"pic\"}','浏览数据',1,'60.1.120.233',1603519156,1603519156),(84,1,'修改菜单','/admin.php/system/menu/edit/id/148/mod/pic.html','{\"id\":\"148\",\"mod\":\"pic\"}','浏览数据',1,'60.1.120.233',1603519194,1603519194),(85,1,'修改菜单','/admin.php/system/menu/edit.html','{\"pid\":\"143\",\"title\":\"\\u6295\\u7968\\u7ba1\\u7406\",\"icon\":\"\",\"url\":\"pic\\/pic\\/vote\",\"param\":\"\",\"status\":\"1\",\"system\":\"0\",\"nav\":\"1\",\"id\":\"148\",\"module\":\"pic\"}','保存数据',1,'60.1.120.233',1603519221,1603519221),(86,1,'投票管理','/admin.php/pic/pic/vote.html','[]','浏览数据',27,'27.184.12.184',1603519228,1603590109),(87,1,'投票管理','/admin.php/pic/pic/vote.html?page=1&limit=20','{\"page\":\"1\",\"limit\":\"20\"}','浏览数据',26,'27.184.12.184',1603519294,1603590110),(88,1,'状态设置','/admin.php/system/menu/status/table/admin_menu/id/3.html?val=0','{\"val\":\"0\",\"table\":\"admin_menu\",\"id\":\"3\"}','浏览数据',1,'27.184.12.184',1603590188,1603590188),(89,1,'状态设置','/admin.php/system/menu/status/table/admin_menu/id/8.html?val=0','{\"val\":\"0\",\"table\":\"admin_menu\",\"id\":\"8\"}','浏览数据',1,'27.184.12.184',1603590207,1603590207);
/*!40000 ALTER TABLE `qinty_system_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_menu`
--

DROP TABLE IF EXISTS `qinty_system_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID(快捷菜单专用)',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `module` varchar(20) NOT NULL COMMENT '模块名或插件名，插件名格式:plugins.插件名',
  `title` varchar(20) NOT NULL COMMENT '菜单标题',
  `icon` varchar(80) NOT NULL DEFAULT 'aicon ai-shezhi' COMMENT '菜单图标',
  `url` varchar(200) NOT NULL COMMENT '链接地址(模块/控制器/方法)',
  `param` varchar(200) NOT NULL DEFAULT '' COMMENT '扩展参数',
  `target` varchar(20) NOT NULL DEFAULT '_self' COMMENT '打开方式(_blank,_self)',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `debug` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '开发模式可见',
  `system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为系统菜单，系统菜单不可删除',
  `nav` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否为菜单显示，1显示0不显示',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态1显示，0隐藏',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 管理菜单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_menu`
--

LOCK TABLES `qinty_system_menu` WRITE;
/*!40000 ALTER TABLE `qinty_system_menu` DISABLE KEYS */;
INSERT INTO `qinty_system_menu` VALUES (1,0,0,'system','首页','','system/index','','_self',0,0,1,1,1,1490315067),(2,0,0,'system','系统','','system/system','','_self',1,0,1,1,1,1490315067),(3,0,0,'system','插件','aicon ai-shezhi','system/plugins','','_self',2,0,1,1,0,1490315067),(4,0,1,'system','快捷菜单','aicon ai-caidan','system/quick','','_self',0,0,1,1,1,1490315067),(5,0,3,'system','插件列表','aicon ai-mokuaiguanli','system/plugins','','_self',0,0,1,1,1,1490315067),(6,0,2,'system','系统基础','aicon ai-gongneng','system/system','','_self',1,0,1,1,1,1490315067),(7,0,17,'system','导入主题SQL','','system/module/exeSql','','_self',10,0,1,0,1,1490315067),(8,0,2,'system','系统扩展','aicon ai-shezhi','system/extend','','_self',3,0,1,1,0,1490315067),(9,0,4,'system','预留占位','','','','_self',4,0,1,1,0,1490315067),(10,0,6,'system','系统设置','aicon ai-icon01','system/system/index','','_self',1,0,1,1,1,1490315067),(11,0,6,'system','配置管理','aicon ai-peizhiguanli','system/config/index','','_self',2,1,1,1,1,1490315067),(12,0,6,'system','系统菜单','aicon ai-systemmenu','system/menu/index','','_self',3,1,1,1,1,1490315067),(13,0,6,'system','管理员角色','','system/user/role','','_self',4,0,1,0,1,1490315067),(14,0,6,'system','系统管理员','aicon ai-tubiao05','system/user/index','','_self',5,0,1,1,1,1490315067),(15,0,6,'system','系统日志','aicon ai-xitongrizhi-tiaoshi','system/log/index','','_self',7,0,1,1,1,1490315067),(16,0,6,'system','附件管理','','system/annex/index','','_self',8,0,1,0,1,1490315067),(17,0,8,'system','本地模块','aicon ai-mokuaiguanli1','system/module/index','','_self',1,0,1,1,1,1490315067),(18,0,8,'system','本地插件','aicon ai-chajianguanli','system/plugins/index','','_self',2,0,1,1,1,1490315067),(19,0,8,'system','插件钩子','aicon ai-icon-test','system/hook/index','','_self',3,0,1,1,1,1490315067),(20,0,4,'system','预留占位','','','','_self',1,0,1,1,0,1490315067),(21,0,4,'system','预留占位','','','','_self',2,0,1,1,0,1490315067),(22,0,4,'system','预留占位','','','','_self',1,0,1,1,0,1490315067),(23,0,4,'system','预留占位','','','','_self',2,0,1,1,0,1490315067),(24,0,4,'system','后台首页','','system/index/index','','_self',100,0,1,0,1,1490315067),(25,0,4,'system','清空缓存','','system/index/clear','','_self',2,0,1,0,1,1490315067),(26,0,12,'system','添加菜单','','system/menu/add','','_self',1,0,1,1,1,1490315067),(27,0,12,'system','修改菜单','','system/menu/edit','','_self',2,0,1,1,1,1490315067),(28,0,12,'system','删除菜单','','system/menu/del','','_self',3,0,1,1,1,1490315067),(29,0,12,'system','状态设置','','system/menu/status','','_self',4,0,1,1,1,1490315067),(30,0,12,'system','排序设置','','system/menu/sort','','_self',5,0,1,1,1,1490315067),(31,0,12,'system','添加快捷菜单','','system/menu/quick','','_self',6,0,1,1,1,1490315067),(32,0,12,'system','导出菜单','','system/menu/export','','_self',7,0,1,1,1,1490315067),(33,0,13,'system','添加角色','','system/user/addrole','','_self',1,0,1,1,1,1490315067),(34,0,13,'system','修改角色','','system/user/editrole','','_self',2,0,1,1,1,1490315067),(35,0,13,'system','删除角色','','system/user/delrole','','_self',3,0,1,1,1,1490315067),(36,0,13,'system','状态设置','','system/user/statusRole','','_self',4,0,1,1,1,1490315067),(37,0,14,'system','添加管理员','','system/user/adduser','','_self',1,0,1,1,1,1490315067),(38,0,14,'system','修改管理员','','system/user/edituser','','_self',2,0,1,1,1,1490315067),(39,0,14,'system','删除管理员','','system/user/deluser','','_self',3,0,1,1,1,1490315067),(40,0,14,'system','状态设置','','system/user/status','','_self',4,0,1,0,1,1490315067),(41,0,4,'system','个人信息设置','','system/user/info','','_self',5,0,1,0,1,1490315067),(42,0,18,'system','安装插件','','system/plugins/install','','_self',1,0,1,1,1,1490315067),(43,0,18,'system','卸载插件','','system/plugins/uninstall','','_self',2,0,1,1,1,1490315067),(44,0,18,'system','删除插件','','system/plugins/del','','_self',3,0,1,1,1,1490315067),(45,0,18,'system','状态设置','','system/plugins/status','','_self',4,0,1,1,1,1490315067),(46,0,18,'system','生成插件','','system/plugins/design','','_self',5,0,1,1,1,1490315067),(47,0,18,'system','运行插件','','system/plugins/run','','_self',6,0,1,1,1,1490315067),(48,0,18,'system','更新插件','','system/plugins/update','','_self',7,0,1,1,1,1490315067),(49,0,18,'system','插件配置','','system/plugins/setting','','_self',8,0,1,1,1,1490315067),(50,0,19,'system','添加钩子','','system/hook/add','','_self',1,0,1,1,1,1490315067),(51,0,19,'system','修改钩子','','system/hook/edit','','_self',2,0,1,1,1,1490315067),(52,0,19,'system','删除钩子','','system/hook/del','','_self',3,0,1,1,1,1490315067),(53,0,19,'system','状态设置','','system/hook/status','','_self',4,0,1,1,1,1490315067),(54,0,19,'system','插件排序','','system/hook/sort','','_self',5,0,1,1,1,1490315067),(55,0,11,'system','添加配置','','system/config/add','','_self',1,0,1,1,1,1490315067),(56,0,11,'system','修改配置','','system/config/edit','','_self',2,0,1,1,1,1490315067),(57,0,11,'system','删除配置','','system/config/del','','_self',3,0,1,1,1,1490315067),(58,0,11,'system','状态设置','','system/config/status','','_self',4,0,1,1,1,1490315067),(59,0,11,'system','排序设置','','system/config/sort','','_self',5,0,1,1,1,1490315067),(60,0,10,'system','基础配置','','system/system/index','group=base','_self',1,0,1,1,1,1490315067),(61,0,10,'system','系统配置','','system/system/index','group=sys','_self',2,0,1,1,1,1490315067),(62,0,10,'system','上传配置','','system/system/index','group=upload','_self',3,0,1,1,1,1490315067),(63,0,10,'system','开发配置','','system/system/index','group=develop','_self',4,0,1,1,1,1490315067),(64,0,17,'system','生成模块','','system/module/design','','_self',6,1,1,1,1,1490315067),(65,0,17,'system','安装模块','','system/module/install','','_self',1,0,1,1,1,1490315067),(66,0,17,'system','卸载模块','','system/module/uninstall','','_self',2,0,1,1,1,1490315067),(67,0,17,'system','状态设置','','system/module/status','','_self',3,0,1,1,1,1490315067),(68,0,17,'system','设置默认模块','','system/module/setdefault','','_self',4,0,1,1,1,1490315067),(69,0,17,'system','删除模块','','system/module/del','','_self',5,0,1,1,1,1490315067),(70,0,4,'system','预留占位','','','','_self',1,0,1,1,0,1490315067),(71,0,4,'system','预留占位','','','','_self',2,0,1,1,0,1490315067),(72,0,4,'system','预留占位','','','','_self',3,0,1,1,0,1490315067),(73,0,4,'system','预留占位','','','','_self',4,0,1,1,0,1490315067),(74,0,4,'system','预留占位','','','','_self',5,0,1,1,0,1490315067),(75,0,4,'system','预留占位','','','','_self',0,0,1,1,0,1490315067),(76,0,4,'system','预留占位','','','','_self',0,0,1,1,0,1490315067),(77,0,4,'system','预留占位','','','','_self',0,0,1,1,0,1490315067),(78,0,16,'system','附件上传','','system/annex/upload','','_self',1,0,1,1,1,1490315067),(79,0,16,'system','删除附件','','system/annex/del','','_self',2,0,1,1,1,1490315067),(80,0,8,'system','框架升级','aicon ai-iconfontshengji','system/upgrade/index','','_self',4,0,1,1,1,1491352728),(81,0,80,'system','获取升级列表','','system/upgrade/lists','','_self',0,0,1,1,1,1491353504),(82,0,80,'system','安装升级包','','system/upgrade/install','','_self',0,0,1,1,1,1491353568),(83,0,80,'system','下载升级包','','system/upgrade/download','','_self',0,0,1,1,1,1491395830),(84,0,6,'system','数据库管理','aicon ai-shujukuguanli','system/database/index','','_self',6,0,1,1,1,1491461136),(85,0,84,'system','备份数据库','','system/database/export','','_self',0,0,1,1,1,1491461250),(86,0,84,'system','恢复数据库','','system/database/import','','_self',0,0,1,1,1,1491461315),(87,0,84,'system','优化数据库','','system/database/optimize','','_self',0,0,1,1,1,1491467000),(88,0,84,'system','删除备份','','system/database/del','','_self',0,0,1,1,1,1491467058),(89,0,84,'system','修复数据库','','system/database/repair','','_self',0,0,1,1,1,1491880879),(90,0,21,'system','设置默认等级','','system/member/setdefault','','_self',0,0,1,1,1,1491966585),(91,0,10,'system','数据库配置','','system/system/index','group=databases','_self',5,0,1,0,1,1492072213),(92,0,17,'system','模块打包','','system/module/package','','_self',7,0,1,1,1,1492134693),(93,0,18,'system','插件打包','','system/plugins/package','','_self',0,0,1,1,1,1492134743),(94,0,17,'system','主题管理','','system/module/theme','','_self',8,0,1,1,1,1492433470),(95,0,17,'system','设置默认主题','','system/module/setdefaulttheme','','_self',9,0,1,1,1,1492433618),(96,0,17,'system','删除主题','','system/module/deltheme','','_self',10,0,1,1,1,1490315067),(97,0,6,'system','语言包管理','','system/language/index','','_self',9,0,1,0,1,1490315067),(98,0,97,'system','添加语言包','','system/language/add','','_self',100,0,1,0,1,1490315067),(99,0,97,'system','修改语言包','','system/language/edit','','_self',100,0,1,0,1,1490315067),(100,0,97,'system','删除语言包','','system/language/del','','_self',100,0,1,0,1,1490315067),(101,0,97,'system','排序设置','','system/language/sort','','_self',100,0,1,0,1,1490315067),(102,0,97,'system','状态设置','','system/language/status','','_self',100,0,1,0,1,1490315067),(103,0,16,'system','收藏夹图标上传','','system/annex/favicon','','_self',3,0,1,0,1,1490315067),(104,0,17,'system','导入模块','','system/module/import','','_self',11,0,1,0,1,1490315067),(105,0,4,'system','后台首页','','system/index/welcome','','_self',100,0,1,0,1,1490315067),(106,0,4,'system','布局切换','','system/user/iframe','','_self',100,0,1,0,1,1490315067),(107,0,15,'system','删除日志','','system/log/del','table=admin_log','_self',100,0,1,0,1,1490315067),(108,0,15,'system','清空日志','','system/log/clear','','_self',100,0,1,0,1,1490315067),(109,0,17,'system','编辑模块','','system/module/edit','','_self',100,0,1,0,1,1490315067),(110,0,17,'system','模块图标上传','','system/module/icon','','_self',100,0,1,0,1,1490315067),(111,0,18,'system','导入插件','','system/plugins/import','','_self',100,0,1,0,1,1490315067),(112,0,4,'system','钩子插件状态','','system/hook/hookPluginsStatus','','_self',100,0,1,0,1,1490315067),(113,0,4,'system','设置主题','','system/user/setTheme','','_self',100,0,1,0,1,1490315067),(114,0,8,'system','应用市场','aicon ai-app-store','system/store/index','','_self',0,0,1,1,1,1490315067),(115,0,114,'system','安装应用','','system/store/install','','_self',0,0,1,1,1,1490315067),(116,0,21,'system','重置密码','','system/member/resetPwd','','_self',6,0,1,1,1,1490315067),(117,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(118,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(119,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(120,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(121,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(122,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(123,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(124,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(125,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(126,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(127,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(128,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(129,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(130,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(131,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(132,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(133,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(134,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(135,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(136,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(137,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(138,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(139,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(140,0,4,'system','预留占位','','','','_self',100,0,1,1,0,1490315067),(141,0,0,'pic','图片管理','aicon ai-shezhi','pic','','_self',100,0,0,1,1,1601282719),(142,0,141,'pic','会员管理','aicon ai-huiyuanliebiao','pic/member','','_self',0,0,0,1,1,1601282971),(143,0,141,'pic','图片管理','typcn typcn-image-outline','pic/pic','','_self',0,0,0,1,1,1601283033),(144,0,142,'pic','作者管理','','pic/authors/index','','_self',0,0,0,1,1,1601283077),(145,0,142,'pic','用户管理','','pic/user/index','','_self',0,0,0,1,0,1601284147),(146,0,143,'pic','图片列表','','pic/pic/index','','_self',0,0,0,1,1,1601286262),(147,0,143,'pic','图片分类','','pic/picCate/index','','_self',0,0,0,1,1,1601361901),(148,0,143,'pic','投票管理','','pic/pic/vote','','_self',0,0,0,1,1,1603519176);
/*!40000 ALTER TABLE `qinty_system_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_menu_lang`
--

DROP TABLE IF EXISTS `qinty_system_menu_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_menu_lang` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int(11) unsigned NOT NULL DEFAULT '0',
  `title` varchar(120) NOT NULL DEFAULT '' COMMENT '标题',
  `lang` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '语言包',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=utf8 COMMENT='[系统] 管理菜单语言包';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_menu_lang`
--

LOCK TABLES `qinty_system_menu_lang` WRITE;
/*!40000 ALTER TABLE `qinty_system_menu_lang` DISABLE KEYS */;
INSERT INTO `qinty_system_menu_lang` VALUES (131,1,'首页',1),(132,2,'系统',1),(133,3,'插件',1),(134,4,'快捷菜单',1),(135,5,'插件列表',1),(136,6,'系统基础',1),(137,7,'预留占位',1),(138,8,'系统扩展',1),(139,9,'开发专用',1),(140,10,'系统设置',1),(141,11,'配置管理',1),(142,12,'系统菜单',1),(143,13,'管理员角色',1),(144,14,'系统管理员',1),(145,15,'系统日志',1),(146,16,'附件管理',1),(147,17,'本地模块',1),(148,18,'本地插件',1),(149,19,'插件钩子',1),(150,20,'预留占位',1),(151,21,'预留占位',1),(152,22,'预留占位',1),(153,23,'预留占位',1),(154,24,'后台首页',1),(155,25,'清空缓存',1),(156,26,'添加菜单',1),(157,27,'修改菜单',1),(158,28,'删除菜单',1),(159,29,'状态设置',1),(160,30,'排序设置',1),(161,31,'添加快捷菜单',1),(162,32,'导出菜单',1),(163,33,'添加角色',1),(164,34,'修改角色',1),(165,35,'删除角色',1),(166,36,'状态设置',1),(167,37,'添加管理员',1),(168,38,'修改管理员',1),(169,39,'删除管理员',1),(170,40,'状态设置',1),(171,41,'个人信息设置',1),(172,42,'安装插件',1),(173,43,'卸载插件',1),(174,44,'删除插件',1),(175,45,'状态设置',1),(176,46,'生成插件',1),(177,47,'运行插件',1),(178,48,'更新插件',1),(179,49,'插件配置',1),(180,50,'添加钩子',1),(181,51,'修改钩子',1),(182,52,'删除钩子',1),(183,53,'状态设置',1),(184,54,'插件排序',1),(185,55,'添加配置',1),(186,56,'修改配置',1),(187,57,'删除配置',1),(188,58,'状态设置',1),(189,59,'排序设置',1),(190,60,'基础配置',1),(191,61,'系统配置',1),(192,62,'上传配置',1),(193,63,'开发配置',1),(194,64,'生成模块',1),(195,65,'安装模块',1),(196,66,'卸载模块',1),(197,67,'状态设置',1),(198,68,'设置默认模块',1),(199,69,'删除模块',1),(200,70,'预留占位',1),(201,71,'预留占位',1),(202,72,'预留占位',1),(203,73,'预留占位',1),(204,74,'预留占位',1),(205,75,'预留占位',1),(206,76,'预留占位',1),(207,77,'预留占位',1),(208,78,'附件上传',1),(209,79,'删除附件',1),(210,80,'框架升级',1),(211,81,'获取升级列表',1),(212,82,'安装升级包',1),(213,83,'下载升级包',1),(214,84,'数据库管理',1),(215,85,'备份数据库',1),(216,86,'恢复数据库',1),(217,87,'优化数据库',1),(218,88,'删除备份',1),(219,89,'修复数据库',1),(220,90,'设置默认等级',1),(221,91,'数据库配置',1),(222,92,'模块打包',1),(223,93,'插件打包',1),(224,94,'主题管理',1),(225,95,'设置默认主题',1),(226,96,'删除主题',1),(227,97,'语言包管理',1),(228,98,'添加语言包',1),(229,99,'修改语言包',1),(230,100,'删除语言包',1),(231,101,'排序设置',1),(232,102,'状态设置',1),(233,103,'收藏夹图标上传',1),(234,104,'导入模块',1),(235,105,'后台首页',1),(236,106,'布局切换',1),(237,107,'删除日志',1),(238,108,'清空日志',1),(239,109,'编辑模块',1),(240,110,'模块图标上传',1),(241,111,'导入插件',1),(242,112,'钩子插件状态',1),(243,113,'设置主题',1),(244,114,'应用市场',1),(245,115,'安装应用',1),(246,116,'重置密码',1),(247,117,'预留占位',1),(248,118,'预留占位',1),(249,119,'预留占位',1),(250,120,'预留占位',1),(251,121,'预留占位',1),(252,122,'预留占位',1),(253,123,'预留占位',1),(254,124,'预留占位',1),(255,125,'预留占位',1),(256,126,'预留占位',1),(257,127,'预留占位',1),(258,128,'预留占位',1),(259,129,'预留占位',1),(260,130,'预留占位',1),(261,131,'预留占位',1),(262,132,'预留占位',1),(263,133,'预留占位',1),(264,134,'预留占位',1),(265,135,'预留占位',1),(266,136,'预留占位',1),(267,137,'预留占位',1),(268,138,'预留占位',1),(269,139,'预留占位',1),(270,140,'预留占位',1);
/*!40000 ALTER TABLE `qinty_system_menu_lang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_module`
--

DROP TABLE IF EXISTS `qinty_system_module`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_module` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '系统模块',
  `name` varchar(50) NOT NULL COMMENT '模块名(英文)',
  `identifier` varchar(100) NOT NULL COMMENT '模块标识(模块名(字母).开发者标识.module)',
  `title` varchar(50) NOT NULL COMMENT '模块标题',
  `intro` varchar(255) NOT NULL COMMENT '模块简介',
  `author` varchar(100) NOT NULL COMMENT '作者',
  `icon` varchar(80) NOT NULL DEFAULT 'aicon ai-mokuaiguanli' COMMENT '图标',
  `version` varchar(20) NOT NULL COMMENT '版本号',
  `url` varchar(255) NOT NULL COMMENT '链接',
  `sort` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未安装，1未启用，2已启用',
  `default` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '默认模块(只能有一个)',
  `config` text NOT NULL COMMENT '配置',
  `app_id` varchar(30) NOT NULL DEFAULT '0' COMMENT '应用市场ID(0本地)',
  `app_keys` varchar(200) DEFAULT '' COMMENT '应用秘钥',
  `theme` varchar(50) NOT NULL DEFAULT 'default' COMMENT '主题模板',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='[系统] 模块';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_module`
--

LOCK TABLES `qinty_system_module` WRITE;
/*!40000 ALTER TABLE `qinty_system_module` DISABLE KEYS */;
INSERT INTO `qinty_system_module` VALUES (1,1,'system','system.hisiphp.module','系统管理模块','系统核心模块，用于后台各项管理功能模块及功能拓展','HisiPHP官方出品','','1.0.0','http://www.hisiphp.com',0,2,0,'','0','','default',1489998096,1489998096),(2,1,'index','index.hisiphp.module','默认模块','推荐使用扩展模块作为默认首页。','HisiPHP官方出品','','1.0.0','http://www.hisiphp.com',0,2,0,'','0','','default',1489998096,1489998096),(3,1,'install','install.hisiphp.module','系统安装模块','系统安装模块，勿动。','HisiPHP官方出品','','1.0.0','http://www.hisiphp.com',0,2,0,'','0','','default',1489998096,1489998096),(4,0,'pic','pic.qinty.module','图片管理','','qinty','/static/pic/pic.png','1.0.0','https://qinty.net/',0,2,0,'','0','','default',1601282700,1601282700);
/*!40000 ALTER TABLE `qinty_system_module` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_plugins`
--

DROP TABLE IF EXISTS `qinty_system_plugins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_plugins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `system` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `name` varchar(32) NOT NULL COMMENT '插件名称(英文)',
  `title` varchar(32) NOT NULL COMMENT '插件标题',
  `icon` varchar(64) NOT NULL COMMENT '图标',
  `intro` text NOT NULL COMMENT '插件简介',
  `author` varchar(32) NOT NULL COMMENT '作者',
  `url` varchar(255) NOT NULL COMMENT '作者主页',
  `version` varchar(16) NOT NULL DEFAULT '' COMMENT '版本号',
  `identifier` varchar(64) NOT NULL DEFAULT '' COMMENT '插件唯一标识符',
  `config` text NOT NULL COMMENT '插件配置',
  `app_id` varchar(30) NOT NULL DEFAULT '0' COMMENT '来源(0本地)',
  `app_keys` varchar(200) DEFAULT '' COMMENT '应用秘钥',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='[系统] 插件表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_plugins`
--

LOCK TABLES `qinty_system_plugins` WRITE;
/*!40000 ALTER TABLE `qinty_system_plugins` DISABLE KEYS */;
INSERT INTO `qinty_system_plugins` VALUES (1,1,'hisiphp','系统基础信息','/static/plugins/hisiphp/hisiphp.png','后台首页展示系统基础信息和开发团队信息','HisiPHP','http://www.hisiphp.com','1.0.0','hisiphp.hisiphp.plugins','','0','',1509379331,1509379331,0,2);
/*!40000 ALTER TABLE `qinty_system_plugins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_role`
--

DROP TABLE IF EXISTS `qinty_system_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '角色名称',
  `intro` varchar(200) NOT NULL COMMENT '角色简介',
  `auth` text NOT NULL COMMENT '角色权限',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='[系统] 管理角色';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_role`
--

LOCK TABLES `qinty_system_role` WRITE;
/*!40000 ALTER TABLE `qinty_system_role` DISABLE KEYS */;
INSERT INTO `qinty_system_role` VALUES (1,'超级管理员','拥有系统最高权限','0',1489411760,0,1),(2,'系统管理员','拥有系统管理员权限','[\"1\",\"4\",\"25\",\"24\",\"2\",\"6\",\"10\",\"60\",\"61\",\"62\",\"63\",\"91\",\"11\",\"55\",\"56\",\"57\",\"58\",\"59\",\"12\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"13\",\"33\",\"34\",\"35\",\"36\",\"14\",\"37\",\"38\",\"39\",\"40\",\"41\",\"16\",\"78\",\"79\",\"84\",\"85\",\"86\",\"87\",\"88\",\"89\",\"7\",\"20\",\"75\",\"76\",\"77\",\"21\",\"90\",\"70\",\"71\",\"72\",\"73\",\"74\",\"8\",\"17\",\"65\",\"66\",\"67\",\"68\",\"94\",\"95\",\"18\",\"42\",\"43\",\"45\",\"47\",\"48\",\"49\",\"19\",\"80\",\"81\",\"82\",\"83\",\"9\",\"22\",\"23\",\"3\",\"5\"]',1489411760,1507731116,1),(3,'普通管理员','普通管理员','{\"0\":\"1\",\"1\":\"4\",\"2\":\"25\",\"4\":\"24\",\"6\":\"106\",\"8\":\"113\"}',1507737902,1542075415,1);
/*!40000 ALTER TABLE `qinty_system_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_user`
--

DROP TABLE IF EXISTS `qinty_system_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(64) NOT NULL,
  `nick` varchar(50) NOT NULL COMMENT '昵称',
  `mobile` varchar(11) NOT NULL,
  `email` varchar(50) NOT NULL COMMENT '邮箱',
  `auth` text NOT NULL COMMENT '权限',
  `iframe` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0默认，1框架',
  `theme` varchar(50) NOT NULL DEFAULT 'default' COMMENT '主题',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `last_login_ip` varchar(128) NOT NULL COMMENT '最后登陆IP',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登陆时间',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='[系统] 管理用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_user`
--

LOCK TABLES `qinty_system_user` WRITE;
/*!40000 ALTER TABLE `qinty_system_user` DISABLE KEYS */;
INSERT INTO `qinty_system_user` VALUES (1,'admin','$2y$10$l2RLcGeb5VA7dZnB1d07Y.K6iHrqW4NDGDLraSiwoKkvu1y/XAyOa','超级管理员','','','',0,'default',1,'27.184.12.184',1603589657,1601281722,1601281722);
/*!40000 ALTER TABLE `qinty_system_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_system_user_role`
--

DROP TABLE IF EXISTS `qinty_system_user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_system_user_role` (
  `user_id` int(11) unsigned NOT NULL,
  `role_id` int(10) unsigned DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员角色索引';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_system_user_role`
--

LOCK TABLES `qinty_system_user_role` WRITE;
/*!40000 ALTER TABLE `qinty_system_user_role` DISABLE KEYS */;
INSERT INTO `qinty_system_user_role` VALUES (1,1);
/*!40000 ALTER TABLE `qinty_system_user_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_token`
--

DROP TABLE IF EXISTS `qinty_token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_token` (
  `token` varchar(128) NOT NULL DEFAULT '' COMMENT 'Token',
  `tag` varchar(50) DEFAULT '' COMMENT '标签',
  `value` varchar(30) NOT NULL DEFAULT '' COMMENT '映射的值',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '过期时间',
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_token`
--

LOCK TABLES `qinty_token` WRITE;
/*!40000 ALTER TABLE `qinty_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `qinty_token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_user_auths`
--

DROP TABLE IF EXISTS `qinty_user_auths`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_user_auths` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `identity_type` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '登录类型:phone,email,username,official_accounts,mini_apps',
  `identifier` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '账号,唯一ID',
  `credential` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密码/token',
  `login_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户登录信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_user_auths`
--

LOCK TABLES `qinty_user_auths` WRITE;
/*!40000 ALTER TABLE `qinty_user_auths` DISABLE KEYS */;
INSERT INTO `qinty_user_auths` VALUES (1,2,'username','dafenqi1','$2y$10$AaBGa/a554qfSRBGwJgEiO1vJ340JQ5AbV1JK1kaUUMbZofwONLJW',9),(2,3,'username','wanger','$2y$10$ipAV664QsGC1SEKoDRi8NuPN62JaBBRt5Jq1tDdnpAWh2sYT6GhXO',35),(7,8,'official_accounts','orQvbt417gEOpqsq9anU0ZSSIEGc','',1),(8,9,'username','tu123','$2y$10$NS5YdZyGB8Sr1QE1NzKfM.llwqZnUM9u.u3GkNmLF3VK9YxnQGo8e',1),(9,10,'username','tu1234','$2y$10$UwyoYQ0pWgkU3OEzUtKUpeAu0kK9Dzj3njGd77YQfwZzs7/7KaCNe',0),(10,11,'username','tu12345','$2y$10$vt3zRcSbEJPAB0UE5jJxG.S2TJCiXT/IfmVslUglD4I6R4W6VGqPu',0),(11,12,'username','tu123456','$2y$10$iPmPYfl4Fei43fm82hcpaueFSXffY1P96wQDtnnsa2cLbGHD58Kk2',0),(12,13,'mini_apps','o_Tqo5NnfrDHA5nRGN86KPgxnhBc','',1),(13,14,'mini_apps','undefined','',1);
/*!40000 ALTER TABLE `qinty_user_auths` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_users`
--

DROP TABLE IF EXISTS `qinty_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '昵称',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '头像',
  `createtime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `user_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户类型:0=普通用户,1=作者',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户基础信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_users`
--

LOCK TABLES `qinty_users` WRITE;
/*!40000 ALTER TABLE `qinty_users` DISABLE KEYS */;
INSERT INTO `qinty_users` VALUES (2,'达芬奇','/static/images/avatar.png','2020-09-29 14:38:31',1),(3,'王二麻子','/static/images/avatar.png','2020-09-29 18:19:08',1),(8,'Not Found','/upload/headimg//orQvbt417gEOpqsq9anU0ZSSIEGc.jpg','2020-10-19 13:49:48',0),(9,'张1','/static/images/avatar.png','2020-10-19 16:26:01',1),(10,'张2','/static/images/avatar.png','2020-10-19 16:54:58',1),(11,'张3','/static/images/avatar.png','2020-10-19 16:55:26',1),(12,'张4','/static/images/avatar.png','2020-10-19 16:55:42',1),(13,'Not Found','/upload/headimg//o_Tqo5NnfrDHA5nRGN86KPgxnhBc.jpg','2020-10-20 15:49:42',0),(14,'潘怡孜','/upload/headimg//undefined.jpg','2020-10-26 10:06:40',0);
/*!40000 ALTER TABLE `qinty_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qinty_vote_log`
--

DROP TABLE IF EXISTS `qinty_vote_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qinty_vote_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pic_id` int(10) unsigned NOT NULL COMMENT '图片id',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '投票时间',
  `unique_str` varchar(255) NOT NULL COMMENT '唯一标识',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_str` (`unique_str`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COMMENT='投票记录表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qinty_vote_log`
--

LOCK TABLES `qinty_vote_log` WRITE;
/*!40000 ALTER TABLE `qinty_vote_log` DISABLE KEYS */;
INSERT INTO `qinty_vote_log` VALUES (15,8,2,1603095438,'5421a9a23ce1167dc52bdc617244eefb'),(16,10,2,1603095445,'266e5f3d05f2a07c64702e059b86cb75'),(19,9,8,1603096367,'e7a10d40dba2284f8a61451803d522a3'),(21,9,9,1603096602,'83fd0c6cd6e092e57dbe2d014a1e4cb5'),(23,8,9,1603098278,'05f12cb5dcbcc40afb977268a7ca41af'),(25,50,13,1603180199,'e4639e226672baa6354b4d1ee2898e2e'),(28,51,13,1603180349,'498c90985c7419ec51a7b86295076b1f'),(29,48,13,1603180364,'3d77b8a0c289ae31783a03dfe2845ff4'),(31,49,13,1603180452,'23b287404179c4ea7d08c5ee4d006fe4'),(32,47,13,1603180924,'56a82d34f79ee09cc6e07c0aa7c86d6b'),(33,50,3,1603181286,'c0eaa00b389f814b28bd4a3276461e51'),(34,51,3,1603181301,'7b31aebf1248bb58c118b9b0173a3787'),(35,8,13,1603183213,'dd4dba79876f472198a1b48fcf388f2e'),(36,50,14,1603183455,'9c8d15e62b2e85059de3b5980b7cc42b'),(39,51,14,1603503976,'a72587eb1a48d6e458c3f1d23f9b45b9'),(40,50,14,1603504093,'a16b05dbd2bd09d9fda433dac29eb8a9'),(42,48,14,1603504689,'ccd989f9af941a62b1ae856f93ed5d06'),(43,47,14,1603589760,'1def882b02fc2678d11e00bcfbadd45f'),(44,10,14,1603589777,'2d4821a9e51dda24da11fdfab62e2230');
/*!40000 ALTER TABLE `qinty_vote_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'app_hebhuazhen_c'
--
/*!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 2020-10-27 14:11:03