-- MySQL dump 10.13 Distrib 5.7.25, for Linux (x86_64) -- -- Host: localhost Database: hdm721879203_db -- ------------------------------------------------------ -- Server version 5.7.25-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 `cmf_admin_menu` -- DROP TABLE IF EXISTS `cmf_admin_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_admin_menu` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父菜单id', `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '菜单类型;1:有界面可访问菜单,2:无界面可访问菜单,0:只作为菜单', `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态;1:显示,0:不显示', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `app` varchar(40) NOT NULL DEFAULT '' COMMENT '应用名', `controller` varchar(30) NOT NULL DEFAULT '' COMMENT '控制器名', `action` varchar(30) NOT NULL DEFAULT '' COMMENT '操作名称', `param` varchar(50) NOT NULL DEFAULT '' COMMENT '额外参数', `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称', `icon` varchar(20) NOT NULL DEFAULT '' COMMENT '菜单图标', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`id`), KEY `status` (`status`), KEY `parent_id` (`parent_id`), KEY `controller` (`controller`) ) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8 COMMENT='后台菜单表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_admin_menu` -- LOCK TABLES `cmf_admin_menu` WRITE; /*!40000 ALTER TABLE `cmf_admin_menu` DISABLE KEYS */; INSERT INTO `cmf_admin_menu` VALUES (1,0,0,0,20,'admin','Plugin','default','','插件中心','cloud','插件中心'),(2,1,1,1,10000,'admin','Hook','index','','钩子管理','','钩子管理'),(3,2,1,0,10000,'admin','Hook','plugins','','钩子插件管理','','钩子插件管理'),(4,2,2,0,10000,'admin','Hook','pluginListOrder','','钩子插件排序','','钩子插件排序'),(5,2,1,0,10000,'admin','Hook','sync','','同步钩子','','同步钩子'),(6,0,0,1,0,'admin','Setting','default','','设置','cogs','系统设置入口'),(7,6,1,0,50,'admin','Link','index','','友情链接','','友情链接管理'),(8,7,1,0,10000,'admin','Link','add','','添加友情链接','','添加友情链接'),(9,7,2,0,10000,'admin','Link','addPost','','添加友情链接提交保存','','添加友情链接提交保存'),(10,7,1,0,10000,'admin','Link','edit','','编辑友情链接','','编辑友情链接'),(11,7,2,0,10000,'admin','Link','editPost','','编辑友情链接提交保存','','编辑友情链接提交保存'),(12,7,2,0,10000,'admin','Link','delete','','删除友情链接','','删除友情链接'),(13,7,2,0,10000,'admin','Link','listOrder','','友情链接排序','','友情链接排序'),(14,7,2,0,10000,'admin','Link','toggle','','友情链接显示隐藏','','友情链接显示隐藏'),(15,6,1,0,10,'admin','Mailer','index','','邮箱配置','','邮箱配置'),(16,15,2,0,10000,'admin','Mailer','indexPost','','邮箱配置提交保存','','邮箱配置提交保存'),(17,15,1,0,10000,'admin','Mailer','template','','邮件模板','','邮件模板'),(18,15,2,0,10000,'admin','Mailer','templatePost','','邮件模板提交','','邮件模板提交'),(19,15,1,0,10000,'admin','Mailer','test','','邮件发送测试','','邮件发送测试'),(20,6,1,0,10000,'admin','Menu','index','','后台菜单','','后台菜单管理'),(21,20,1,0,10000,'admin','Menu','lists','','所有菜单','','后台所有菜单列表'),(22,20,1,0,10000,'admin','Menu','add','','后台菜单添加','','后台菜单添加'),(23,20,2,0,10000,'admin','Menu','addPost','','后台菜单添加提交保存','','后台菜单添加提交保存'),(24,20,1,0,10000,'admin','Menu','edit','','后台菜单编辑','','后台菜单编辑'),(25,20,2,0,10000,'admin','Menu','editPost','','后台菜单编辑提交保存','','后台菜单编辑提交保存'),(26,20,2,0,10000,'admin','Menu','delete','','后台菜单删除','','后台菜单删除'),(27,20,2,0,10000,'admin','Menu','listOrder','','后台菜单排序','','后台菜单排序'),(28,20,1,0,10000,'admin','Menu','getActions','','导入新后台菜单','','导入新后台菜单'),(29,6,1,0,30,'admin','Nav','index','','导航管理','','导航管理'),(30,29,1,0,10000,'admin','Nav','add','','添加导航','','添加导航'),(31,29,2,0,10000,'admin','Nav','addPost','','添加导航提交保存','','添加导航提交保存'),(32,29,1,0,10000,'admin','Nav','edit','','编辑导航','','编辑导航'),(33,29,2,0,10000,'admin','Nav','editPost','','编辑导航提交保存','','编辑导航提交保存'),(34,29,2,0,10000,'admin','Nav','delete','','删除导航','','删除导航'),(35,29,1,0,10000,'admin','NavMenu','index','','导航菜单','','导航菜单'),(36,35,1,0,10000,'admin','NavMenu','add','','添加导航菜单','','添加导航菜单'),(37,35,2,0,10000,'admin','NavMenu','addPost','','添加导航菜单提交保存','','添加导航菜单提交保存'),(38,35,1,0,10000,'admin','NavMenu','edit','','编辑导航菜单','','编辑导航菜单'),(39,35,2,0,10000,'admin','NavMenu','editPost','','编辑导航菜单提交保存','','编辑导航菜单提交保存'),(40,35,2,0,10000,'admin','NavMenu','delete','','删除导航菜单','','删除导航菜单'),(41,35,2,0,10000,'admin','NavMenu','listOrder','','导航菜单排序','','导航菜单排序'),(42,1,1,1,10000,'admin','Plugin','index','','插件列表','','插件列表'),(43,42,2,0,10000,'admin','Plugin','toggle','','插件启用禁用','','插件启用禁用'),(44,42,1,0,10000,'admin','Plugin','setting','','插件设置','','插件设置'),(45,42,2,0,10000,'admin','Plugin','settingPost','','插件设置提交','','插件设置提交'),(46,42,2,0,10000,'admin','Plugin','install','','插件安装','','插件安装'),(47,42,2,0,10000,'admin','Plugin','update','','插件更新','','插件更新'),(48,42,2,0,10000,'admin','Plugin','uninstall','','卸载插件','','卸载插件'),(49,110,0,1,10000,'admin','User','default','','管理组','','管理组'),(50,49,1,1,10000,'admin','Rbac','index','','角色管理','','角色管理'),(51,50,1,0,10000,'admin','Rbac','roleAdd','','添加角色','','添加角色'),(52,50,2,0,10000,'admin','Rbac','roleAddPost','','添加角色提交','','添加角色提交'),(53,50,1,0,10000,'admin','Rbac','roleEdit','','编辑角色','','编辑角色'),(54,50,2,0,10000,'admin','Rbac','roleEditPost','','编辑角色提交','','编辑角色提交'),(55,50,2,0,10000,'admin','Rbac','roleDelete','','删除角色','','删除角色'),(56,50,1,0,10000,'admin','Rbac','authorize','','设置角色权限','','设置角色权限'),(57,50,2,0,10000,'admin','Rbac','authorizePost','','角色授权提交','','角色授权提交'),(58,0,1,0,10000,'admin','RecycleBin','index','','回收站','','回收站'),(59,58,2,0,10000,'admin','RecycleBin','restore','','回收站还原','','回收站还原'),(60,58,2,0,10000,'admin','RecycleBin','delete','','回收站彻底删除','','回收站彻底删除'),(61,6,1,0,10000,'admin','Route','index','','URL美化','','URL规则管理'),(62,61,1,0,10000,'admin','Route','add','','添加路由规则','','添加路由规则'),(63,61,2,0,10000,'admin','Route','addPost','','添加路由规则提交','','添加路由规则提交'),(64,61,1,0,10000,'admin','Route','edit','','路由规则编辑','','路由规则编辑'),(65,61,2,0,10000,'admin','Route','editPost','','路由规则编辑提交','','路由规则编辑提交'),(66,61,2,0,10000,'admin','Route','delete','','路由规则删除','','路由规则删除'),(67,61,2,0,10000,'admin','Route','ban','','路由规则禁用','','路由规则禁用'),(68,61,2,0,10000,'admin','Route','open','','路由规则启用','','路由规则启用'),(69,61,2,0,10000,'admin','Route','listOrder','','路由规则排序','','路由规则排序'),(70,61,1,0,10000,'admin','Route','select','','选择URL','','选择URL'),(71,6,1,1,0,'admin','Setting','site','','网站信息','','网站信息'),(72,71,2,0,10000,'admin','Setting','sitePost','','网站信息设置提交','','网站信息设置提交'),(73,6,1,0,10000,'admin','Setting','password','','密码修改','','密码修改'),(74,73,2,0,10000,'admin','Setting','passwordPost','','密码修改提交','','密码修改提交'),(75,6,1,1,10000,'admin','Setting','upload','','上传设置','','上传设置'),(76,75,2,0,10000,'admin','Setting','uploadPost','','上传设置提交','','上传设置提交'),(77,6,1,0,10000,'admin','Setting','clearCache','','清除缓存','','清除缓存'),(78,6,1,0,40,'admin','Slide','index','','幻灯片管理','','幻灯片管理'),(79,78,1,0,10000,'admin','Slide','add','','添加幻灯片','','添加幻灯片'),(80,78,2,0,10000,'admin','Slide','addPost','','添加幻灯片提交','','添加幻灯片提交'),(81,78,1,0,10000,'admin','Slide','edit','','编辑幻灯片','','编辑幻灯片'),(82,78,2,0,10000,'admin','Slide','editPost','','编辑幻灯片提交','','编辑幻灯片提交'),(83,78,2,0,10000,'admin','Slide','delete','','删除幻灯片','','删除幻灯片'),(84,78,1,0,10000,'admin','SlideItem','index','','幻灯片页面列表','','幻灯片页面列表'),(85,84,1,0,10000,'admin','SlideItem','add','','幻灯片页面添加','','幻灯片页面添加'),(86,84,2,0,10000,'admin','SlideItem','addPost','','幻灯片页面添加提交','','幻灯片页面添加提交'),(87,84,1,0,10000,'admin','SlideItem','edit','','幻灯片页面编辑','','幻灯片页面编辑'),(88,84,2,0,10000,'admin','SlideItem','editPost','','幻灯片页面编辑提交','','幻灯片页面编辑提交'),(89,84,2,0,10000,'admin','SlideItem','delete','','幻灯片页面删除','','幻灯片页面删除'),(90,84,2,0,10000,'admin','SlideItem','ban','','幻灯片页面隐藏','','幻灯片页面隐藏'),(91,84,2,0,10000,'admin','SlideItem','cancelBan','','幻灯片页面显示','','幻灯片页面显示'),(92,84,2,0,10000,'admin','SlideItem','listOrder','','幻灯片页面排序','','幻灯片页面排序'),(93,6,1,0,10000,'admin','Storage','index','','文件存储','','文件存储'),(94,93,2,0,10000,'admin','Storage','settingPost','','文件存储设置提交','','文件存储设置提交'),(95,6,1,0,20,'admin','Theme','index','','模板管理','','模板管理'),(96,95,1,0,10000,'admin','Theme','install','','安装模板','','安装模板'),(97,95,2,0,10000,'admin','Theme','uninstall','','卸载模板','','卸载模板'),(98,95,2,0,10000,'admin','Theme','installTheme','','模板安装','','模板安装'),(99,95,2,0,10000,'admin','Theme','update','','模板更新','','模板更新'),(100,95,2,0,10000,'admin','Theme','active','','启用模板','','启用模板'),(101,95,1,0,10000,'admin','Theme','files','','模板文件列表','','启用模板'),(102,95,1,0,10000,'admin','Theme','fileSetting','','模板文件设置','','模板文件设置'),(103,95,1,0,10000,'admin','Theme','fileArrayData','','模板文件数组数据列表','','模板文件数组数据列表'),(104,95,2,0,10000,'admin','Theme','fileArrayDataEdit','','模板文件数组数据添加编辑','','模板文件数组数据添加编辑'),(105,95,2,0,10000,'admin','Theme','fileArrayDataEditPost','','模板文件数组数据添加编辑提交保存','','模板文件数组数据添加编辑提交保存'),(106,95,2,0,10000,'admin','Theme','fileArrayDataDelete','','模板文件数组数据删除','','模板文件数组数据删除'),(107,95,2,0,10000,'admin','Theme','settingPost','','模板文件编辑提交保存','','模板文件编辑提交保存'),(108,95,1,0,10000,'admin','Theme','dataSource','','模板文件设置数据源','','模板文件设置数据源'),(109,95,1,0,10000,'admin','Theme','design','','模板设计','','模板设计'),(110,0,0,1,10,'user','AdminIndex','default','','用户管理','group','用户管理'),(111,49,1,1,10000,'admin','User','index','','管理员','','管理员管理'),(112,111,1,0,10000,'admin','User','add','','管理员添加','','管理员添加'),(113,111,2,0,10000,'admin','User','addPost','','管理员添加提交','','管理员添加提交'),(114,111,1,0,10000,'admin','User','edit','','管理员编辑','','管理员编辑'),(115,111,2,0,10000,'admin','User','editPost','','管理员编辑提交','','管理员编辑提交'),(116,111,1,0,10000,'admin','User','userInfo','','个人信息','','管理员个人信息修改'),(117,111,2,0,10000,'admin','User','userInfoPost','','管理员个人信息修改提交','','管理员个人信息修改提交'),(118,111,2,0,10000,'admin','User','delete','','管理员删除','','管理员删除'),(119,111,2,0,10000,'admin','User','ban','','停用管理员','','停用管理员'),(120,111,2,0,10000,'admin','User','cancelBan','','启用管理员','','启用管理员'),(121,0,0,0,30,'portal','AdminIndex','default','','门户管理','th','门户管理'),(122,121,1,1,10000,'portal','AdminArticle','index','','文章管理','','文章列表'),(123,122,1,0,10000,'portal','AdminArticle','add','','添加文章','','添加文章'),(124,122,2,0,10000,'portal','AdminArticle','addPost','','添加文章提交','','添加文章提交'),(125,122,1,0,10000,'portal','AdminArticle','edit','','编辑文章','','编辑文章'),(126,122,2,0,10000,'portal','AdminArticle','editPost','','编辑文章提交','','编辑文章提交'),(127,122,2,0,10000,'portal','AdminArticle','delete','','文章删除','','文章删除'),(128,122,2,0,10000,'portal','AdminArticle','publish','','文章发布','','文章发布'),(129,122,2,0,10000,'portal','AdminArticle','top','','文章置顶','','文章置顶'),(130,122,2,0,10000,'portal','AdminArticle','recommend','','文章推荐','','文章推荐'),(131,122,2,0,10000,'portal','AdminArticle','listOrder','','文章排序','','文章排序'),(132,121,1,1,10000,'portal','AdminCategory','index','','分类管理','','文章分类列表'),(133,132,1,0,10000,'portal','AdminCategory','add','','添加文章分类','','添加文章分类'),(134,132,2,0,10000,'portal','AdminCategory','addPost','','添加文章分类提交','','添加文章分类提交'),(135,132,1,0,10000,'portal','AdminCategory','edit','','编辑文章分类','','编辑文章分类'),(136,132,2,0,10000,'portal','AdminCategory','editPost','','编辑文章分类提交','','编辑文章分类提交'),(137,132,1,0,10000,'portal','AdminCategory','select','','文章分类选择对话框','','文章分类选择对话框'),(138,132,2,0,10000,'portal','AdminCategory','listOrder','','文章分类排序','','文章分类排序'),(139,132,2,0,10000,'portal','AdminCategory','delete','','删除文章分类','','删除文章分类'),(140,6,1,1,10000,'portal','AdminPage','index','','页面管理','','页面管理'),(141,140,1,0,10000,'portal','AdminPage','add','','添加页面','','添加页面'),(142,140,2,0,10000,'portal','AdminPage','addPost','','添加页面提交','','添加页面提交'),(143,140,1,0,10000,'portal','AdminPage','edit','','编辑页面','','编辑页面'),(144,140,2,0,10000,'portal','AdminPage','editPost','','编辑页面提交','','编辑页面提交'),(145,140,2,0,10000,'portal','AdminPage','delete','','删除页面','','删除页面'),(146,121,1,1,10000,'portal','AdminTag','index','','文章标签','','文章标签'),(147,146,1,0,10000,'portal','AdminTag','add','','添加文章标签','','添加文章标签'),(148,146,2,0,10000,'portal','AdminTag','addPost','','添加文章标签提交','','添加文章标签提交'),(149,146,2,0,10000,'portal','AdminTag','upStatus','','更新标签状态','','更新标签状态'),(150,146,2,0,10000,'portal','AdminTag','delete','','删除文章标签','','删除文章标签'),(151,0,1,0,10000,'user','AdminAsset','index','','资源管理','file','资源管理列表'),(152,151,2,0,10000,'user','AdminAsset','delete','','删除文件','','删除文件'),(153,110,0,1,10000,'user','AdminIndex','default1','','用户组','','用户组'),(154,153,1,1,10000,'user','AdminIndex','index','','本站用户','','本站用户'),(155,154,2,0,10000,'user','AdminIndex','ban','','本站用户拉黑','','本站用户拉黑'),(156,154,2,0,10000,'user','AdminIndex','cancelBan','','本站用户启用','','本站用户启用'),(157,153,1,1,10000,'user','AdminOauth','index','','第三方用户','','第三方用户'),(158,157,2,0,10000,'user','AdminOauth','delete','','删除第三方用户绑定','','删除第三方用户绑定'),(159,6,1,0,10000,'user','AdminUserAction','index','','用户操作管理','','用户操作管理'),(160,159,1,0,10000,'user','AdminUserAction','edit','','编辑用户操作','','编辑用户操作'),(161,159,2,0,10000,'user','AdminUserAction','editPost','','编辑用户操作提交','','编辑用户操作提交'),(162,159,1,0,10000,'user','AdminUserAction','sync','','同步用户操作','','同步用户操作'),(163,0,0,1,30,'cat','AdminIndex','default','','猫舍管理','th','猫舍管理'),(164,163,1,1,10000,'cat','AdminBreed','index','','繁育列表','','繁育列表'),(165,163,1,1,10000,'cat','AdminCard','index','','证书管理','','证书管理'),(166,163,1,1,10000,'cat','AdminCat','index','','猫管理','','猫管理'),(167,163,1,1,10000,'cat','AdminHome','index','','猫舍管理','','猫舍管理'),(168,163,1,1,10000,'cat','AdminScore','index','','积分管理','','积分管理'),(169,132,2,0,10000,'portal','AdminCategory','toggle','','文章分类显示隐藏','','文章分类显示隐藏'),(170,6,1,1,10000,'cat','AdminIndex','setting','','短信配置','','短信配置'),(171,6,1,1,10000,'cat','AdminIndex','wxSetting','','微信配置','','微信配置'),(172,6,1,1,10000,'cat','AdminIndex','priceSetting','','价格配置','','价格配置'),(173,163,1,1,10000,'cat','AdminOrder','index','','订单管理','','订单管理'),(174,163,1,1,10000,'cat','AdminCat','transferList','','转让记录','','转让记录'),(175,163,1,1,10000,'cat','AdminOrder','certList','','邮寄管理','','邮寄管理'); /*!40000 ALTER TABLE `cmf_admin_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_asset` -- DROP TABLE IF EXISTS `cmf_asset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_asset` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id', `file_size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小,单位B', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:可用,0:不可用', `download_times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下载次数', `file_key` varchar(64) NOT NULL DEFAULT '' COMMENT '文件惟一码', `filename` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '文件名', `file_path` varchar(100) NOT NULL DEFAULT '' COMMENT '文件路径,相对于upload目录,可以为url', `file_md5` varchar(32) NOT NULL DEFAULT '' COMMENT '文件md5值', `file_sha1` varchar(40) NOT NULL DEFAULT '', `suffix` varchar(10) NOT NULL DEFAULT '' COMMENT '文件后缀名,不包括点', `more` text COMMENT '其它详细信息,JSON格式', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='资源表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_asset` -- LOCK TABLES `cmf_asset` WRITE; /*!40000 ALTER TABLE `cmf_asset` DISABLE KEYS */; INSERT INTO `cmf_asset` VALUES (1,1,3970,1578646443,1,0,'a6a80570081581d23b690176c8cf9178f1d76552acad910faa125f5a2553e646','200k16000000z13dbD665_R_130_130.jpg','cat/20200110/ea9742f7b15b4727094584a0ad1a9677.jpg','a6a80570081581d23b690176c8cf9178','aeb52c3bdc09bdc7390e9b3d8d2b89ba81ae951e','jpg',NULL),(2,1,70240,1579328662,1,0,'f6a1b78833c857912fd804055d0bc7fe7b03ea9583c82f8c3bf06e0e876b1834','logo.png','default/20200118/4895427662b2a69f630fad0a98d1efcd.png','f6a1b78833c857912fd804055d0bc7fe','5ef117e4506f9fa50415eb3a2a7c280244b1f42b','png',NULL),(3,1,163581,1582472052,1,0,'8d637211306c8e1a367aad10d05715e4075081c95bcece93a67db3dfeea2ec90','1.png','default/20200223/edc7debc88f85be9f15f3144da49c8f0.png','8d637211306c8e1a367aad10d05715e4','e6ee76797f345e8151ee2a34351ea6b98f8a5036','png',NULL),(4,1,655783,1583470505,1,0,'34a802c0793146e695a07e98215695b3c47273c2bdff9bf7e0d6a3448f801d3c','8D822424564307146546B67DDB8F5AF8.png','default/20200306/1a71cb73f0a274c78b439a48049d1c8d.png','34a802c0793146e695a07e98215695b3','f5406aa44ac98e90332e4ca0662c3e9d71bb0cf2','png',NULL); /*!40000 ALTER TABLE `cmf_asset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_auth_access` -- DROP TABLE IF EXISTS `cmf_auth_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_auth_access` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` int(10) unsigned NOT NULL COMMENT '角色', `rule_name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写', `type` varchar(30) NOT NULL DEFAULT '' COMMENT '权限规则分类,请加应用前缀,如admin_', PRIMARY KEY (`id`), KEY `role_id` (`role_id`), KEY `rule_name` (`rule_name`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限授权表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_auth_access` -- LOCK TABLES `cmf_auth_access` WRITE; /*!40000 ALTER TABLE `cmf_auth_access` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_auth_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_auth_rule` -- DROP TABLE IF EXISTS `cmf_auth_rule`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_auth_rule` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)', `app` varchar(40) NOT NULL DEFAULT '' COMMENT '规则所属app', `type` varchar(30) NOT NULL DEFAULT '' COMMENT '权限规则分类,请加应用前缀,如admin_', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写', `param` varchar(100) NOT NULL DEFAULT '' COMMENT '额外url参数', `title` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '规则描述', `condition` varchar(200) NOT NULL DEFAULT '' COMMENT '规则附加条件', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) USING BTREE, KEY `module` (`app`,`status`,`type`) ) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8 COMMENT='权限规则表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_auth_rule` -- LOCK TABLES `cmf_auth_rule` WRITE; /*!40000 ALTER TABLE `cmf_auth_rule` DISABLE KEYS */; INSERT INTO `cmf_auth_rule` VALUES (1,1,'admin','admin_url','admin/Hook/index','','钩子管理',''),(2,1,'admin','admin_url','admin/Hook/plugins','','钩子插件管理',''),(3,1,'admin','admin_url','admin/Hook/pluginListOrder','','钩子插件排序',''),(4,1,'admin','admin_url','admin/Hook/sync','','同步钩子',''),(5,1,'admin','admin_url','admin/Link/index','','友情链接',''),(6,1,'admin','admin_url','admin/Link/add','','添加友情链接',''),(7,1,'admin','admin_url','admin/Link/addPost','','添加友情链接提交保存',''),(8,1,'admin','admin_url','admin/Link/edit','','编辑友情链接',''),(9,1,'admin','admin_url','admin/Link/editPost','','编辑友情链接提交保存',''),(10,1,'admin','admin_url','admin/Link/delete','','删除友情链接',''),(11,1,'admin','admin_url','admin/Link/listOrder','','友情链接排序',''),(12,1,'admin','admin_url','admin/Link/toggle','','友情链接显示隐藏',''),(13,1,'admin','admin_url','admin/Mailer/index','','邮箱配置',''),(14,1,'admin','admin_url','admin/Mailer/indexPost','','邮箱配置提交保存',''),(15,1,'admin','admin_url','admin/Mailer/template','','邮件模板',''),(16,1,'admin','admin_url','admin/Mailer/templatePost','','邮件模板提交',''),(17,1,'admin','admin_url','admin/Mailer/test','','邮件发送测试',''),(18,1,'admin','admin_url','admin/Menu/index','','后台菜单',''),(19,1,'admin','admin_url','admin/Menu/lists','','所有菜单',''),(20,1,'admin','admin_url','admin/Menu/add','','后台菜单添加',''),(21,1,'admin','admin_url','admin/Menu/addPost','','后台菜单添加提交保存',''),(22,1,'admin','admin_url','admin/Menu/edit','','后台菜单编辑',''),(23,1,'admin','admin_url','admin/Menu/editPost','','后台菜单编辑提交保存',''),(24,1,'admin','admin_url','admin/Menu/delete','','后台菜单删除',''),(25,1,'admin','admin_url','admin/Menu/listOrder','','后台菜单排序',''),(26,1,'admin','admin_url','admin/Menu/getActions','','导入新后台菜单',''),(27,1,'admin','admin_url','admin/Nav/index','','导航管理',''),(28,1,'admin','admin_url','admin/Nav/add','','添加导航',''),(29,1,'admin','admin_url','admin/Nav/addPost','','添加导航提交保存',''),(30,1,'admin','admin_url','admin/Nav/edit','','编辑导航',''),(31,1,'admin','admin_url','admin/Nav/editPost','','编辑导航提交保存',''),(32,1,'admin','admin_url','admin/Nav/delete','','删除导航',''),(33,1,'admin','admin_url','admin/NavMenu/index','','导航菜单',''),(34,1,'admin','admin_url','admin/NavMenu/add','','添加导航菜单',''),(35,1,'admin','admin_url','admin/NavMenu/addPost','','添加导航菜单提交保存',''),(36,1,'admin','admin_url','admin/NavMenu/edit','','编辑导航菜单',''),(37,1,'admin','admin_url','admin/NavMenu/editPost','','编辑导航菜单提交保存',''),(38,1,'admin','admin_url','admin/NavMenu/delete','','删除导航菜单',''),(39,1,'admin','admin_url','admin/NavMenu/listOrder','','导航菜单排序',''),(40,1,'admin','admin_url','admin/Plugin/default','','插件中心',''),(41,1,'admin','admin_url','admin/Plugin/index','','插件列表',''),(42,1,'admin','admin_url','admin/Plugin/toggle','','插件启用禁用',''),(43,1,'admin','admin_url','admin/Plugin/setting','','插件设置',''),(44,1,'admin','admin_url','admin/Plugin/settingPost','','插件设置提交',''),(45,1,'admin','admin_url','admin/Plugin/install','','插件安装',''),(46,1,'admin','admin_url','admin/Plugin/update','','插件更新',''),(47,1,'admin','admin_url','admin/Plugin/uninstall','','卸载插件',''),(48,1,'admin','admin_url','admin/Rbac/index','','角色管理',''),(49,1,'admin','admin_url','admin/Rbac/roleAdd','','添加角色',''),(50,1,'admin','admin_url','admin/Rbac/roleAddPost','','添加角色提交',''),(51,1,'admin','admin_url','admin/Rbac/roleEdit','','编辑角色',''),(52,1,'admin','admin_url','admin/Rbac/roleEditPost','','编辑角色提交',''),(53,1,'admin','admin_url','admin/Rbac/roleDelete','','删除角色',''),(54,1,'admin','admin_url','admin/Rbac/authorize','','设置角色权限',''),(55,1,'admin','admin_url','admin/Rbac/authorizePost','','角色授权提交',''),(56,1,'admin','admin_url','admin/RecycleBin/index','','回收站',''),(57,1,'admin','admin_url','admin/RecycleBin/restore','','回收站还原',''),(58,1,'admin','admin_url','admin/RecycleBin/delete','','回收站彻底删除',''),(59,1,'admin','admin_url','admin/Route/index','','URL美化',''),(60,1,'admin','admin_url','admin/Route/add','','添加路由规则',''),(61,1,'admin','admin_url','admin/Route/addPost','','添加路由规则提交',''),(62,1,'admin','admin_url','admin/Route/edit','','路由规则编辑',''),(63,1,'admin','admin_url','admin/Route/editPost','','路由规则编辑提交',''),(64,1,'admin','admin_url','admin/Route/delete','','路由规则删除',''),(65,1,'admin','admin_url','admin/Route/ban','','路由规则禁用',''),(66,1,'admin','admin_url','admin/Route/open','','路由规则启用',''),(67,1,'admin','admin_url','admin/Route/listOrder','','路由规则排序',''),(68,1,'admin','admin_url','admin/Route/select','','选择URL',''),(69,1,'admin','admin_url','admin/Setting/default','','设置',''),(70,1,'admin','admin_url','admin/Setting/site','','网站信息',''),(71,1,'admin','admin_url','admin/Setting/sitePost','','网站信息设置提交',''),(72,1,'admin','admin_url','admin/Setting/password','','密码修改',''),(73,1,'admin','admin_url','admin/Setting/passwordPost','','密码修改提交',''),(74,1,'admin','admin_url','admin/Setting/upload','','上传设置',''),(75,1,'admin','admin_url','admin/Setting/uploadPost','','上传设置提交',''),(76,1,'admin','admin_url','admin/Setting/clearCache','','清除缓存',''),(77,1,'admin','admin_url','admin/Slide/index','','幻灯片管理',''),(78,1,'admin','admin_url','admin/Slide/add','','添加幻灯片',''),(79,1,'admin','admin_url','admin/Slide/addPost','','添加幻灯片提交',''),(80,1,'admin','admin_url','admin/Slide/edit','','编辑幻灯片',''),(81,1,'admin','admin_url','admin/Slide/editPost','','编辑幻灯片提交',''),(82,1,'admin','admin_url','admin/Slide/delete','','删除幻灯片',''),(83,1,'admin','admin_url','admin/SlideItem/index','','幻灯片页面列表',''),(84,1,'admin','admin_url','admin/SlideItem/add','','幻灯片页面添加',''),(85,1,'admin','admin_url','admin/SlideItem/addPost','','幻灯片页面添加提交',''),(86,1,'admin','admin_url','admin/SlideItem/edit','','幻灯片页面编辑',''),(87,1,'admin','admin_url','admin/SlideItem/editPost','','幻灯片页面编辑提交',''),(88,1,'admin','admin_url','admin/SlideItem/delete','','幻灯片页面删除',''),(89,1,'admin','admin_url','admin/SlideItem/ban','','幻灯片页面隐藏',''),(90,1,'admin','admin_url','admin/SlideItem/cancelBan','','幻灯片页面显示',''),(91,1,'admin','admin_url','admin/SlideItem/listOrder','','幻灯片页面排序',''),(92,1,'admin','admin_url','admin/Storage/index','','文件存储',''),(93,1,'admin','admin_url','admin/Storage/settingPost','','文件存储设置提交',''),(94,1,'admin','admin_url','admin/Theme/index','','模板管理',''),(95,1,'admin','admin_url','admin/Theme/install','','安装模板',''),(96,1,'admin','admin_url','admin/Theme/uninstall','','卸载模板',''),(97,1,'admin','admin_url','admin/Theme/installTheme','','模板安装',''),(98,1,'admin','admin_url','admin/Theme/update','','模板更新',''),(99,1,'admin','admin_url','admin/Theme/active','','启用模板',''),(100,1,'admin','admin_url','admin/Theme/files','','模板文件列表',''),(101,1,'admin','admin_url','admin/Theme/fileSetting','','模板文件设置',''),(102,1,'admin','admin_url','admin/Theme/fileArrayData','','模板文件数组数据列表',''),(103,1,'admin','admin_url','admin/Theme/fileArrayDataEdit','','模板文件数组数据添加编辑',''),(104,1,'admin','admin_url','admin/Theme/fileArrayDataEditPost','','模板文件数组数据添加编辑提交保存',''),(105,1,'admin','admin_url','admin/Theme/fileArrayDataDelete','','模板文件数组数据删除',''),(106,1,'admin','admin_url','admin/Theme/settingPost','','模板文件编辑提交保存',''),(107,1,'admin','admin_url','admin/Theme/dataSource','','模板文件设置数据源',''),(108,1,'admin','admin_url','admin/Theme/design','','模板设计',''),(109,1,'admin','admin_url','admin/User/default','','管理组',''),(110,1,'admin','admin_url','admin/User/index','','管理员',''),(111,1,'admin','admin_url','admin/User/add','','管理员添加',''),(112,1,'admin','admin_url','admin/User/addPost','','管理员添加提交',''),(113,1,'admin','admin_url','admin/User/edit','','管理员编辑',''),(114,1,'admin','admin_url','admin/User/editPost','','管理员编辑提交',''),(115,1,'admin','admin_url','admin/User/userInfo','','个人信息',''),(116,1,'admin','admin_url','admin/User/userInfoPost','','管理员个人信息修改提交',''),(117,1,'admin','admin_url','admin/User/delete','','管理员删除',''),(118,1,'admin','admin_url','admin/User/ban','','停用管理员',''),(119,1,'admin','admin_url','admin/User/cancelBan','','启用管理员',''),(120,1,'portal','admin_url','portal/AdminArticle/index','','文章管理',''),(121,1,'portal','admin_url','portal/AdminArticle/add','','添加文章',''),(122,1,'portal','admin_url','portal/AdminArticle/addPost','','添加文章提交',''),(123,1,'portal','admin_url','portal/AdminArticle/edit','','编辑文章',''),(124,1,'portal','admin_url','portal/AdminArticle/editPost','','编辑文章提交',''),(125,1,'portal','admin_url','portal/AdminArticle/delete','','文章删除',''),(126,1,'portal','admin_url','portal/AdminArticle/publish','','文章发布',''),(127,1,'portal','admin_url','portal/AdminArticle/top','','文章置顶',''),(128,1,'portal','admin_url','portal/AdminArticle/recommend','','文章推荐',''),(129,1,'portal','admin_url','portal/AdminArticle/listOrder','','文章排序',''),(130,1,'portal','admin_url','portal/AdminCategory/index','','分类管理',''),(131,1,'portal','admin_url','portal/AdminCategory/add','','添加文章分类',''),(132,1,'portal','admin_url','portal/AdminCategory/addPost','','添加文章分类提交',''),(133,1,'portal','admin_url','portal/AdminCategory/edit','','编辑文章分类',''),(134,1,'portal','admin_url','portal/AdminCategory/editPost','','编辑文章分类提交',''),(135,1,'portal','admin_url','portal/AdminCategory/select','','文章分类选择对话框',''),(136,1,'portal','admin_url','portal/AdminCategory/listOrder','','文章分类排序',''),(137,1,'portal','admin_url','portal/AdminCategory/delete','','删除文章分类',''),(138,1,'portal','admin_url','portal/AdminIndex/default','','门户管理',''),(139,1,'portal','admin_url','portal/AdminPage/index','','页面管理',''),(140,1,'portal','admin_url','portal/AdminPage/add','','添加页面',''),(141,1,'portal','admin_url','portal/AdminPage/addPost','','添加页面提交',''),(142,1,'portal','admin_url','portal/AdminPage/edit','','编辑页面',''),(143,1,'portal','admin_url','portal/AdminPage/editPost','','编辑页面提交',''),(144,1,'portal','admin_url','portal/AdminPage/delete','','删除页面',''),(145,1,'portal','admin_url','portal/AdminTag/index','','文章标签',''),(146,1,'portal','admin_url','portal/AdminTag/add','','添加文章标签',''),(147,1,'portal','admin_url','portal/AdminTag/addPost','','添加文章标签提交',''),(148,1,'portal','admin_url','portal/AdminTag/upStatus','','更新标签状态',''),(149,1,'portal','admin_url','portal/AdminTag/delete','','删除文章标签',''),(150,1,'user','admin_url','user/AdminAsset/index','','资源管理',''),(151,1,'user','admin_url','user/AdminAsset/delete','','删除文件',''),(152,1,'user','admin_url','user/AdminIndex/default','','用户管理',''),(153,1,'user','admin_url','user/AdminIndex/default1','','用户组',''),(154,1,'user','admin_url','user/AdminIndex/index','','本站用户',''),(155,1,'user','admin_url','user/AdminIndex/ban','','本站用户拉黑',''),(156,1,'user','admin_url','user/AdminIndex/cancelBan','','本站用户启用',''),(157,1,'user','admin_url','user/AdminOauth/index','','第三方用户',''),(158,1,'user','admin_url','user/AdminOauth/delete','','删除第三方用户绑定',''),(159,1,'user','admin_url','user/AdminUserAction/index','','用户操作管理',''),(160,1,'user','admin_url','user/AdminUserAction/edit','','编辑用户操作',''),(161,1,'user','admin_url','user/AdminUserAction/editPost','','编辑用户操作提交',''),(162,1,'user','admin_url','user/AdminUserAction/sync','','同步用户操作',''),(163,1,'cat','admin_url','cat/AdminBreed/index','','繁育列表',''),(164,1,'cat','admin_url','cat/AdminCard/index','','证书管理',''),(165,1,'cat','admin_url','cat/AdminCat/index','','猫管理',''),(166,1,'cat','admin_url','cat/AdminHome/index','','猫舍管理',''),(167,1,'cat','admin_url','cat/AdminIndex/default','','猫舍管理',''),(168,1,'cat','admin_url','cat/AdminScore/index','','积分管理',''),(169,1,'portal','admin_url','portal/AdminCategory/toggle','','文章分类显示隐藏',''),(170,1,'cat','admin_url','cat/AdminIndex/setting','','短信配置',''),(171,1,'cat','admin_url','cat/AdminIndex/wxSetting','','微信配置',''),(172,1,'cat','admin_url','cat/AdminIndex/priceSetting','','价格配置',''),(173,1,'cat','admin_url','cat/AdminOrder/index','','订单管理',''),(174,1,'cat','admin_url','cat/AdminCat/transferList','','转让记录',''),(175,1,'cat','admin_url','cat/AdminOrder/certList','','邮寄管理',''); /*!40000 ALTER TABLE `cmf_auth_rule` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat` -- DROP TABLE IF EXISTS `cmf_cat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `home_id` int(11) DEFAULT NULL, `category` varchar(50) NOT NULL, `card_number` varchar(20) DEFAULT NULL, `catname` varchar(30) NOT NULL, `birthday` varchar(50) DEFAULT NULL, `description` varchar(100) DEFAULT NULL, `images` text, `sex` tinyint(1) NOT NULL COMMENT '公1母0', `rank` varchar(50) DEFAULT NULL, `score` int(11) NOT NULL DEFAULT '0', `create_time` int(10) NOT NULL, `die_time` int(10) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL, `xp` char(50) DEFAULT NULL COMMENT '芯片编号', `more` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='猫'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat` -- LOCK TABLES `cmf_cat` WRITE; /*!40000 ALTER TABLE `cmf_cat` DISABLE KEYS */; INSERT INTO `cmf_cat` VALUES (1,37,NULL,'埃及猫',NULL,'测试','2018-03-03','','/public/upload/avatar/20200303/8a96f7802471ab414925b3658c5408cd.jpeg',1,NULL,0,1583249120,0,0,NULL,NULL),(2,37,NULL,'阿比西尼亚猫',NULL,'66666','2018-03-03','','/public/upload/avatar/20200303/bbf7613355505f0893135db517881d24.jpg',1,NULL,0,1583249468,0,0,NULL,NULL),(3,37,NULL,'阿比西尼亚猫',NULL,'66666','2018-03-03','','/public/upload/avatar/20200303/bbf7613355505f0893135db517881d24.jpg',1,NULL,0,1583249473,0,0,NULL,NULL),(4,37,NULL,'埃及猫',NULL,'111','2016-03-04','','/public/upload/avatar/20200304/04b70b765e2de5f3fc5410eefc24c7f2.jpeg',1,NULL,0,1583256837,0,0,NULL,NULL),(5,33,NULL,'埃及猫',NULL,'哈哈猫','2020-01-04','','',1,NULL,0,1583290670,0,0,NULL,NULL),(6,29,NULL,'埃及猫',NULL,'聚会','2020-01-04','还是','/public/upload/avatar/20200304/46986c39ae8d157a8e596e994401109e.jpg',1,NULL,0,1583291458,0,1,NULL,NULL),(7,37,NULL,'布偶猫','C34569341','布偶','2019-08-04','','/public/upload/avatar/20200304/cb25a92a18794ecfd44187b3a2d1ec94.jpeg',1,NULL,0,1583291597,0,2,'888888888',NULL),(8,39,NULL,'英国短毛猫','C56336797','拾贰','2017-06-01','','/public/upload/avatar/20200323/ad251b63a8b8183313fb56ff4ac31676.jpg',1,NULL,0,1584937470,0,2,NULL,NULL),(9,40,NULL,'美国短尾猫','C63135732','Seven','2018-07-03','','/public/upload/avatar/20200323/d4e036d260bd33643b2340a1a28b715a.jpg,/public/upload/avatar/20200323/ec8ae4a3921aa98715acc4b7d0e7cf88.jpg',1,NULL,0,1584937915,0,2,NULL,NULL),(10,41,NULL,'英国短毛猫',NULL,'钞票','2019-06-20','','/public/upload/avatar/20200323/1c705ed652f1bd75d58a0fb4a82bbb14.jpeg',1,NULL,0,1584938079,0,0,NULL,NULL),(11,40,NULL,'英国短毛猫',NULL,'一一','2019-09-10','一一是英短渐层和英短蓝猫的孩子 还是属于英短范畴吧','/public/upload/avatar/20200323/99147a872bedc6eda349ee02beb0ee45.jpg,/public/upload/avatar/20200323/0e3f8956136cf59b3ce1b8903561627c.jpg,/public/upload/avatar/20200323/865818d6ca074cac3b5426d5edf37119.jpg',1,NULL,0,1584938313,0,0,NULL,NULL),(12,42,NULL,'金吉拉',NULL,'球球','2018-03-17','','/upload/avatar/20200323/d726e165181f385f0f2f1eaef3ea5470.jpeg,/public/upload/avatar/20200323/67c5d98307bff60183934ed8fd52e7f9.jpeg,/public/upload/avatar/20200323/66f043e57e4a98ce5f8af12eca609b4b.jpeg',0,NULL,0,1584938431,0,0,NULL,NULL),(13,42,NULL,'金吉拉','C88992401','球球','2018-03-17','','/public/upload/avatar/20200323/bffb2b74f5830de8c8fa657c7aed5d47.jpeg,/public/upload/avatar/20200323/090ee0532d6cef8fe7b65ee541168619.jpeg,/public/upload/avatar/20200323/d72fee7ec80c3ecb8b6b71aa9abaec6d.jpeg',0,NULL,0,1584938681,0,2,NULL,NULL),(14,52,NULL,'孟加拉豹猫',NULL,'小豹子','2015-11-04','','/upload/avatar/20200323/247db731ac985eb68ba0e87791a3bbf2.jpg',1,NULL,0,1584965111,0,0,NULL,NULL),(15,46,NULL,'山东狮子猫',NULL,'','2019-07-07','','/public/upload/avatar/20200324/d994ca1a51f8c4986302fab7b5e5061c.jpeg',1,NULL,0,1585017431,0,0,NULL,NULL),(16,46,NULL,'缅因猫',NULL,'','2020-01-04','','/public/upload/avatar/20200324/730b9ec6ff59133cdc0f2295258864e6.jpeg',1,NULL,0,1585018518,0,0,NULL,NULL),(17,53,NULL,'英国短毛猫',NULL,'嘟嘟','2019-03-11','','/public/upload/avatar/20200324/1f3528fa07f41c3912a9e63f500f1165.jpeg',1,NULL,0,1585033504,0,0,NULL,NULL),(18,56,NULL,'美国短毛猫',NULL,'豆浆','2019-11-10','','/public/upload/avatar/20200406/618d33b68f917ed968ad6727bc872164.jpeg,/public/upload/avatar/20200406/104d2969a9b5d725384fa207d467c651.jpeg,/public/upload/avatar/20200406/b977096dd6bd84fa6e5e07323c6ba79e.jpeg',1,NULL,0,1586122677,0,0,NULL,NULL),(19,59,NULL,'布偶猫',NULL,'乖乖','2020-02-03','','/public/upload/avatar/20200429/35fe0743e6e7d05d994dec898e916665.jpeg',0,NULL,0,1588130151,0,0,NULL,NULL),(20,70,NULL,'布偶猫',NULL,'lisa','2019-02-02','','/public/upload/avatar/20200701/279466fbc51141ec6c0edf150cda4ad5.jpg',1,NULL,0,1593571185,0,0,NULL,NULL),(21,103,NULL,'英国短毛猫',NULL,'大圣','2020-06-09','','/public/upload/avatar/20200830/3499fb221228585dc37db7dc0bb85462.jpg',1,NULL,0,1598748500,0,0,NULL,NULL),(22,116,NULL,'英国短毛猫',NULL,'Miko','2019-12-15','','/upload/avatar/20200908/19c2dd275a00f4349f1b4c4f169f59f8.jpg,/upload/avatar/20200908/942868b5191f31fa06c57137cc50d7e3.jpg,/public/upload/avatar/20200908/e6a4607fcd79b677b3236f8ba9d6c96a.jpg',0,NULL,0,1599539174,0,0,NULL,NULL),(23,116,NULL,'英国短毛猫',NULL,'Miko','2019-12-15','','/public/upload/avatar/20200908/884e704c10be4c96a1e1acc4c477db5e.jpeg',0,NULL,0,1599545000,0,0,NULL,NULL),(24,136,NULL,'孟加拉豹猫',NULL,'kuola','2019-05-10','','/public/upload/avatar/20201007/bd6ffb62d589b36d79c08d8bce33afb4.jpg,/public/upload/avatar/20201007/f7a25a31751702511ead56b23e56a5fe.jpg',0,NULL,0,1602074624,0,0,NULL,NULL),(25,151,NULL,'英国短毛猫',NULL,'国庆','2019-09-30','','/public/upload/avatar/20201019/d00cda1a340e1cbe5646ad5bee0d6ca3.jpg',1,NULL,0,1603066726,0,0,NULL,NULL),(26,179,NULL,'布偶猫','C58560405','王子','2020-07-22','','/public/upload/avatar/20201121/c55325316eae2f696b4a2a4786cb042e.jpg,/public/upload/avatar/20201121/c531064cf7bcbb098c7a61ecf149d064.jpg',1,NULL,0,1605963843,0,2,NULL,NULL),(27,183,NULL,'埃及猫',NULL,'tom','2020-11-24','测试','/public/upload/avatar/20201124/a9506cacfbc5ee3378965c6ea50fc607.jpeg',1,NULL,0,1606210459,0,0,NULL,NULL); /*!40000 ALTER TABLE `cmf_cat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat_breed` -- DROP TABLE IF EXISTS `cmf_cat_breed`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat_breed` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `father_id` int(11) NOT NULL, `mother_id` int(11) NOT NULL, `home_id` int(11) NOT NULL, `cat_id` int(11) DEFAULT NULL, `is_my` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 表示 父亲是我的 0表示母亲是我的', `create_time` int(10) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `more` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='繁育记录'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat_breed` -- LOCK TABLES `cmf_cat_breed` WRITE; /*!40000 ALTER TABLE `cmf_cat_breed` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_cat_breed` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat_card` -- DROP TABLE IF EXISTS `cmf_cat_card`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat_card` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `type` tinyint(1) NOT NULL, `type_id` int(11) NOT NULL, `card_number` varchar(20) NOT NULL, `create_time` int(10) NOT NULL, `finish_time` int(10) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '1', `more` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='证书记录'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat_card` -- LOCK TABLES `cmf_cat_card` WRITE; /*!40000 ALTER TABLE `cmf_cat_card` DISABLE KEYS */; INSERT INTO `cmf_cat_card` VALUES (1,42,1,13,'C88992401',1584974727,0,1,NULL),(2,40,1,9,'C63135732',1584974733,0,1,NULL),(3,39,1,8,'C56336797',1584974738,0,1,NULL),(5,46,2,4,'F56987762',1584974950,0,1,NULL),(6,37,1,7,'C34569341',1585150769,0,1,NULL),(7,162,2,23,'F74803652',1604371495,0,1,NULL),(8,168,2,24,'F16016834',1604751840,0,1,NULL),(9,179,1,26,'C58560405',1605964124,0,1,NULL),(10,178,2,25,'F86698605',1606209752,0,1,NULL); /*!40000 ALTER TABLE `cmf_cat_card` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat_home` -- DROP TABLE IF EXISTS `cmf_cat_home`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat_home` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `card_number` varchar(20) DEFAULT NULL, `name` varchar(50) NOT NULL, `images` varchar(255) DEFAULT NULL, `description` text, `create_time` int(10) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `more` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='猫舍'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat_home` -- LOCK TABLES `cmf_cat_home` WRITE; /*!40000 ALTER TABLE `cmf_cat_home` DISABLE KEYS */; INSERT INTO `cmf_cat_home` VALUES (1,29,NULL,'很喜欢好像',NULL,'铜官区泓景苑(五松道南)',1583290583,0,NULL),(3,45,NULL,'Phoenix',NULL,'',1584938734,0,NULL),(4,46,'F56987762','GRACEI CATS',NULL,'山东省枣庄市山亭区BRT车站对面派多格宠物医院',1584939791,2,NULL),(5,48,NULL,'SERAXIAO-CAT',NULL,'双流区华阳左岸花都(华府大道北150米)',1584941888,0,NULL),(6,49,NULL,'MuseAround',NULL,'医院家属楼1-302',1584943127,0,NULL),(7,61,NULL,'梦露家的',NULL,'昌邑区百合家园北50米(哈达湾街北)',1588234666,0,NULL),(9,68,NULL,'柚子猫舍',NULL,'酒仙桥路',1593255874,0,NULL),(10,72,NULL,'WOJIAYOUZHIBUOUMAO',NULL,'如意路中粮祥云1A2401',1593759530,0,NULL),(11,74,NULL,'Jo’s Devon Rex House',NULL,'宁夏银川市金凤区中海国际社区橙郡30号楼1304',1593995658,0,NULL),(13,82,NULL,'Fairy',NULL,'长顺上街四道街一号院',1595312611,0,NULL),(14,85,NULL,'Dormammu',NULL,'昆明路三五一一社区',1595743168,0,NULL),(15,95,NULL,'喵司令',NULL,'丙烯颜料怎么洗',1597330454,0,NULL),(16,106,NULL,'晚云与猫',NULL,'长沙市岳麓区融创融公馆',1599050756,0,NULL),(17,121,NULL,'你好!独角兽!',NULL,'',1600056019,0,NULL),(18,146,NULL,'花卷猫舍',NULL,'星火路金辉天鹅湾8号楼1单元2902',1602604390,0,NULL),(19,147,NULL,'Fliger K',NULL,'城厢镇科教新城群星花园27幢702室',1602649544,0,NULL),(20,150,NULL,'羁绊',NULL,'汀州豪庭十五栋',1602917153,0,NULL),(23,162,'F74803652','秋阳名猫',NULL,'姑孰镇金汇康郡',1604368458,2,NULL),(24,168,'F16016834','hero fly',NULL,'四川省成都市成华区和顺西一路世茂茂立方3-1-2204',1604749849,-2,NULL),(25,178,'F86698605','测试',NULL,'槐树店',1605926515,2,NULL),(26,183,NULL,'成都大向天诚',NULL,'槐树店',1606210535,0,NULL); /*!40000 ALTER TABLE `cmf_cat_home` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat_order` -- DROP TABLE IF EXISTS `cmf_cat_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_sn` varchar(20) NOT NULL, `price` decimal(10,2) DEFAULT '0.00' COMMENT '支付价格', `user_id` int(11) NOT NULL, `type` tinyint(1) NOT NULL, `type_id` varchar(50) DEFAULT NULL, `is_mail` tinyint(1) NOT NULL DEFAULT '0', `province` varchar(32) DEFAULT NULL, `city` varchar(32) DEFAULT NULL, `area` varchar(32) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `create_time` int(10) NOT NULL, `pay_time` int(10) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `pay_status` tinyint(1) NOT NULL DEFAULT '0', `more` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='订单记录'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat_order` -- LOCK TABLES `cmf_cat_order` WRITE; /*!40000 ALTER TABLE `cmf_cat_order` DISABLE KEYS */; INSERT INTO `cmf_cat_order` VALUES (1,'15832491209419530632',0.01,37,1,'1',0,'','','','',1583249120,NULL,-1,0,NULL),(2,'15832494682090780635',100.01,37,1,'2',1,'浙江省','杭州市','拱墅区','拱墅区申花方家埭公交站西北(申花路北)',1583249468,NULL,-1,0,NULL),(3,'15832494737558770087',0.01,37,1,'3',0,'浙江省','杭州市','拱墅区','拱墅区申花方家埭公交站西北(申花路北)',1583249473,NULL,-1,0,NULL),(4,'15832568376581370966',0.01,37,1,'4',0,'','','','',1583256837,NULL,-1,0,NULL),(5,'15832905839921430425',100.01,29,2,'1',1,'安徽省','铜陵市','铜官区','铜官区泓景苑(五松道南)',1583290583,NULL,1,0,NULL),(6,'15832906702536770079',0.01,33,1,'5',0,'','','','',1583290670,NULL,1,0,NULL),(7,'15832914588589060968',0.01,29,1,'6',0,'','','','',1583291458,1583291466,1,1,NULL),(8,'15832915979328910831',0.01,37,1,'7',0,'','','','',1583291597,1583291602,1,1,NULL),(9,'15849374702759780419',1.00,39,1,'8',0,'','','','',1584937470,1584937487,1,1,NULL),(10,'15849379155598350904',1.00,40,1,'9',0,'','','','',1584937915,1584937924,1,1,NULL),(11,'15849380792588910221',101.00,41,1,'10',1,'四川省','成都市','龙泉驿区','怡和新城e1桂苑 ',1584938079,NULL,1,0,NULL),(12,'15849381857514350335',102.00,43,2,'2',1,'安徽省','马鞍山市','含山县','含山县漕河桥东300米(039县道北)',1584938185,NULL,1,0,NULL),(13,'15849383131092960016',101.00,40,1,'11',1,'河南省','郑州市','管城回族区','商都新城',1584938313,NULL,1,0,NULL),(14,'15849384312966770369',101.00,42,1,'12',1,'广东省','深圳市','罗湖区','罗湖区布心东晓路3063号新丝路时尚文创园A栋',1584938431,NULL,1,0,NULL),(15,'15849386810432800720',101.00,42,1,'13',1,'广东省','深圳市','罗湖区','罗湖区东晓街布心东晓路3063号新丝路时尚文创园A栋',1584938681,1584938687,1,1,NULL),(16,'15849387349927650464',102.00,45,2,'3',1,'安徽省','合肥市','蜀山区','',1584938734,NULL,-1,0,NULL),(17,'15849397911564590924',102.00,46,2,'4',1,'山东省','枣庄市','山亭区','派多格宠物医院',1584939791,1584939849,1,1,NULL),(18,'15849418886394110999',102.00,48,2,'5',1,'四川省','成都市','武侯区','双流区华阳左岸花都(华府大道北150米)',1584941888,NULL,1,0,NULL),(19,'15849431270021530276',102.00,49,2,'6',1,'辽宁省','盘锦市','兴隆台区','医院家属楼1-302',1584943127,NULL,1,0,NULL),(20,'15849651115256510949',101.00,52,1,'14',1,'云南省','昆明市','西山区','二环西路春苑花园A栋',1584965111,NULL,1,0,NULL),(21,'15850174317733240059',101.00,46,1,'15',1,'山东省','枣庄市','山亭区','山东省枣庄市山亭区BRT车站对面派多格宠物医院',1585017431,NULL,1,0,NULL),(22,'15850185189403430231',101.00,46,1,'16',1,'山东省','枣庄市','山亭区','山亭区枣庄市宏宇饲料有限公司(银光路北)',1585018518,NULL,1,0,NULL),(23,'15850335043941950611',1.00,53,1,'17',0,'','','','',1585033504,NULL,1,0,NULL),(24,'15861226775215180692',101.00,56,1,'18',1,'广东省','深圳市','罗湖区','东晓路3063号新丝路文创园',1586122677,NULL,1,0,NULL),(25,'15881301510878400131',101.00,59,1,'19',1,'江苏省','常州市','新北区','绿都万和城minimall3楼',1588130151,NULL,1,0,NULL),(26,'15882346661767970640',102.00,61,2,'7',1,'吉林省','吉林市','昌邑区','昌邑区百合家园北50米(哈达湾街北)',1588234666,NULL,1,0,NULL),(28,'15932558740308500068',600.00,68,2,'9',1,'北京市','北京市','朝阳区','酒仙桥路',1593255874,NULL,1,0,NULL),(29,'15935711858152130183',300.00,70,1,'20',0,'广东省','广州市','海珠区','桂田村南约大街菜鸟驿站',1593571185,NULL,1,0,NULL),(30,'15937595306079910972',600.00,72,2,'10',1,'广东省','深圳市','龙岗区','如意路中粮祥云1A2401',1593759530,NULL,1,0,NULL),(31,'15939956583515660744',600.00,74,2,'11',1,'宁夏','银川市','金凤区','宁夏银川市金凤区中海国际社区橙郡30号楼1304',1593995658,NULL,1,0,NULL),(33,'15953126115876290574',600.00,82,2,'13',1,'四川省','成都市','青羊区','长顺上街四道街一号院',1595312611,NULL,1,0,NULL),(34,'15957431689638990261',600.00,85,2,'14',1,'陕西省','西安市','雁塔区','昆明路三五一一社区',1595743168,NULL,1,0,NULL),(35,'15973304542580480469',600.00,95,2,'15',1,'北京市','北京市','通州区','丙烯颜料怎么洗',1597330454,NULL,1,0,NULL),(36,'15987485007984620452',300.00,103,1,'21',0,'','','','',1598748500,NULL,1,0,NULL),(37,'15990507564689620718',600.00,106,2,'16',1,'湖南省','长沙市','岳麓区','长沙市岳麓区融创融公馆',1599050756,NULL,1,0,NULL),(38,'15995391749917510728',400.00,116,1,'22',1,'江苏省','南京市','江宁区','东山街道竹山路149号',1599539174,NULL,1,0,NULL),(39,'15995450009736300881',300.00,116,1,'23',0,'','','','',1599545000,NULL,1,0,NULL),(40,'16000560195630150592',600.00,121,2,'17',1,'','','','',1600056019,NULL,1,0,NULL),(41,'16020746242086000419',400.00,136,1,'24',1,'广东省','深圳市','福田区','上梅林卓悦汇购物中心六楼爪爪喵星球 潘麒龙 13977074473',1602074624,NULL,1,0,NULL),(42,'16026043904639890271',450.00,146,2,'18',1,'陕西省','西安市','莲湖区','星火路金辉天鹅湾8号楼1单元2902',1602604390,NULL,1,0,NULL),(43,'16026495446290840389',450.00,147,2,'19',1,'江苏省','苏州市','太仓市','城厢镇科教新城群星花园27幢702室',1602649544,NULL,1,0,NULL),(44,'16029171532332830035',450.00,150,2,'20',1,'福建省','龙岩市','长汀县','汀州豪庭十五栋',1602917153,NULL,1,0,NULL),(45,'16030667264850420911',400.00,151,1,'25',1,'河南省','开封市','龙亭区','东京大道九道街河南应用职业技术学',1603066726,NULL,1,0,NULL),(48,'16043684580056120432',450.00,162,2,'23',1,'安徽省','马鞍山市','当涂县','姑孰镇金汇康郡',1604368458,1604368583,1,1,NULL),(49,'16047498492951980751',450.00,168,2,'24',1,'四川省','成都市','成华区','和顺西一路世茂茂立方3-1-2204',1604749849,1604749912,-1,1,NULL),(50,'16059265159616230087',450.00,178,2,'25',1,'四川省','成都市','成华区','槐树店',1605926515,NULL,-1,0,NULL),(51,'16059638430011480965',400.00,179,1,'26',1,'浙江省','杭州市','拱墅区','凯德龙湾1幢1单元1201',1605963843,1605963895,1,1,NULL),(52,'16062104596747910058',300.00,183,1,'27',0,'','','','',1606210459,NULL,1,0,NULL),(53,'16062105356427050957',450.00,183,2,'26',1,'四川省','成都市','成华区','槐树店',1606210535,NULL,1,0,NULL); /*!40000 ALTER TABLE `cmf_cat_order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat_order_address` -- DROP TABLE IF EXISTS `cmf_cat_order_address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat_order_address` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `order_sn` varchar(20) NOT NULL DEFAULT '', `card_number` varchar(20) DEFAULT '' COMMENT '补寄的证书编号', `num` tinyint(3) DEFAULT '1', `province` varchar(32) NOT NULL DEFAULT '', `city` varchar(32) NOT NULL DEFAULT '', `area` varchar(32) NOT NULL DEFAULT '', `address` varchar(100) NOT NULL DEFAULT '', `shipment_name` varchar(30) DEFAULT NULL COMMENT '快递名称', `shipment_number` varchar(100) DEFAULT NULL COMMENT '快递编号', `create_time` int(10) NOT NULL DEFAULT '0', `deliver_time` int(10) DEFAULT NULL COMMENT '发货时间', `status` tinyint(1) NOT NULL DEFAULT '0', `more` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COMMENT='补寄证书表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat_order_address` -- LOCK TABLES `cmf_cat_order_address` WRITE; /*!40000 ALTER TABLE `cmf_cat_order_address` DISABLE KEYS */; INSERT INTO `cmf_cat_order_address` VALUES (1,37,'15832494682090780635','',1,'浙江省','杭州市','拱墅区','拱墅区申花方家埭公交站西北(申花路北)',NULL,NULL,1583249468,NULL,0,NULL),(2,29,'15832905839921430425','',1,'安徽省','铜陵市','铜官区','铜官区泓景苑(五松道南)',NULL,NULL,1583290583,NULL,0,NULL),(3,41,'15849380792588910221','',1,'四川省','成都市','龙泉驿区','怡和新城e1桂苑 ',NULL,NULL,1584938079,NULL,0,NULL),(4,43,'15849381857514350335','F40933680',1,'安徽省','马鞍山市','含山县','含山县漕河桥东300米(039县道北)',NULL,NULL,1584938185,NULL,0,NULL),(5,40,'15849383131092960016','',1,'河南省','郑州市','管城回族区','商都新城',NULL,NULL,1584938313,NULL,0,NULL),(6,42,'15849384312966770369','',1,'广东省','深圳市','罗湖区','罗湖区布心东晓路3063号新丝路时尚文创园A栋',NULL,NULL,1584938431,NULL,0,NULL),(7,42,'15849386810432800720','C88992401',1,'广东省','深圳市','罗湖区','罗湖区东晓街布心东晓路3063号新丝路时尚文创园A栋','顺丰','SF6090270113087',1584938681,1585107827,2,NULL),(8,45,'15849387349927650464','',1,'安徽省','合肥市','蜀山区','',NULL,NULL,1584938734,NULL,0,NULL),(9,46,'15849397911564590924','F56987762',1,'山东省','枣庄市','山亭区','派多格宠物医院','顺丰','SF6090270109803',1584939791,1585107805,2,NULL),(10,48,'15849418886394110999','',1,'四川省','成都市','武侯区','双流区华阳左岸花都(华府大道北150米)',NULL,NULL,1584941888,NULL,0,NULL),(11,49,'15849431270021530276','',1,'辽宁省','盘锦市','兴隆台区','医院家属楼1-302',NULL,NULL,1584943127,NULL,0,NULL),(12,52,'15849651115256510949','',1,'云南省','昆明市','西山区','二环西路春苑花园A栋',NULL,NULL,1584965111,NULL,0,NULL),(13,46,'15850174317733240059','',1,'山东省','枣庄市','山亭区','山东省枣庄市山亭区BRT车站对面派多格宠物医院',NULL,NULL,1585017431,NULL,0,NULL),(14,46,'15850185189403430231','',1,'山东省','枣庄市','山亭区','山亭区枣庄市宏宇饲料有限公司(银光路北)',NULL,NULL,1585018518,NULL,0,NULL),(15,56,'15861226775215180692','',1,'广东省','深圳市','罗湖区','东晓路3063号新丝路文创园',NULL,NULL,1586122677,NULL,0,NULL),(16,59,'15881301510878400131','',1,'江苏省','常州市','新北区','绿都万和城minimall3楼',NULL,NULL,1588130151,NULL,0,NULL),(17,61,'15882346661767970640','',1,'吉林省','吉林市','昌邑区','昌邑区百合家园北50米(哈达湾街北)',NULL,NULL,1588234666,NULL,0,NULL),(18,62,'15912696178746700461','',1,'辽宁省','抚顺市','望花区','高湾经济开发区水木山城',NULL,NULL,1591269617,NULL,0,NULL),(19,68,'15932558740308500068','',1,'北京市','北京市','朝阳区','酒仙桥路',NULL,NULL,1593255874,NULL,0,NULL),(20,72,'15937595306079910972','',1,'广东省','深圳市','龙岗区','如意路中粮祥云1A2401',NULL,NULL,1593759530,NULL,0,NULL),(21,74,'15939956583515660744','',1,'宁夏','银川市','金凤区','宁夏银川市金凤区中海国际社区橙郡30号楼1304',NULL,NULL,1593995658,NULL,0,NULL),(22,80,'15950501291028650813','',1,'山东省','潍坊市','寿光市','文家街道北付村',NULL,NULL,1595050129,NULL,0,NULL),(23,82,'15953126115876290574','',1,'四川省','成都市','青羊区','长顺上街四道街一号院',NULL,NULL,1595312611,NULL,0,NULL),(24,85,'15957431689638990261','',1,'陕西省','西安市','雁塔区','昆明路三五一一社区',NULL,NULL,1595743168,NULL,0,NULL),(25,95,'15973304542580480469','',1,'北京市','北京市','通州区','丙烯颜料怎么洗',NULL,NULL,1597330454,NULL,0,NULL),(26,106,'15990507564689620718','',1,'湖南省','长沙市','岳麓区','长沙市岳麓区融创融公馆',NULL,NULL,1599050756,NULL,0,NULL),(27,116,'15995391749917510728','',1,'江苏省','南京市','江宁区','东山街道竹山路149号',NULL,NULL,1599539175,NULL,0,NULL),(28,121,'16000560195630150592','',1,'','','','',NULL,NULL,1600056019,NULL,0,NULL),(29,136,'16020746242086000419','',1,'广东省','深圳市','福田区','上梅林卓悦汇购物中心六楼爪爪喵星球 潘麒龙 13977074473',NULL,NULL,1602074624,NULL,0,NULL),(30,146,'16026043904639890271','',1,'陕西省','西安市','莲湖区','星火路金辉天鹅湾8号楼1单元2902',NULL,NULL,1602604390,NULL,0,NULL),(31,147,'16026495446290840389','',1,'江苏省','苏州市','太仓市','城厢镇科教新城群星花园27幢702室',NULL,NULL,1602649544,NULL,0,NULL),(32,150,'16029171532332830035','',1,'福建省','龙岩市','长汀县','汀州豪庭十五栋',NULL,NULL,1602917153,NULL,0,NULL),(33,151,'16030667264850420911','',1,'河南省','开封市','龙亭区','东京大道九道街河南应用职业技术学',NULL,NULL,1603066726,NULL,0,NULL),(34,156,'16034826793044710783','',1,'广西壮族','南宁市','青秀区','民族大道41号国贸中心A座1701',NULL,NULL,1603482679,NULL,0,NULL),(35,161,'16043342445513310450','',1,'北京市','北京市','东城区','的点点滴滴',NULL,NULL,1604334244,NULL,0,NULL),(36,162,'16043684580056120432','F74803652',1,'安徽省','马鞍山市','当涂县','姑孰镇金汇康郡','顺丰','SF6090549769655',1604368458,1604410073,2,NULL),(37,168,'16047498492951980751','F16016834',1,'四川省','成都市','成华区','和顺西一路世茂茂立方3-1-2204',NULL,NULL,1604749849,NULL,1,NULL),(38,178,'16059265159616230087','F86698605',1,'四川省','成都市','成华区','槐树店',NULL,NULL,1605926515,NULL,0,NULL),(39,179,'16059638430011480965','C58560405',1,'浙江省','杭州市','拱墅区','凯德龙湾1幢1单元1201',NULL,NULL,1605963843,NULL,1,NULL),(40,183,'16062105356427050957','',1,'四川省','成都市','成华区','槐树店',NULL,NULL,1606210535,NULL,0,NULL); /*!40000 ALTER TABLE `cmf_cat_order_address` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat_score` -- DROP TABLE IF EXISTS `cmf_cat_score`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat_score` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cat_id` int(11) NOT NULL, `score` int(11) NOT NULL, `msg` varchar(100) DEFAULT NULL, `create_time` int(10) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `more` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='积分记录'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat_score` -- LOCK TABLES `cmf_cat_score` WRITE; /*!40000 ALTER TABLE `cmf_cat_score` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_cat_score` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat_transfer` -- DROP TABLE IF EXISTS `cmf_cat_transfer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat_transfer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `to_user_id` int(11) NOT NULL, `cat_id` int(11) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `create_time` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='转让表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat_transfer` -- LOCK TABLES `cmf_cat_transfer` WRITE; /*!40000 ALTER TABLE `cmf_cat_transfer` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_cat_transfer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_cat_update` -- DROP TABLE IF EXISTS `cmf_cat_update`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_cat_update` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type_id` int(11) DEFAULT NULL, `type` tinyint(1) DEFAULT NULL, `category` varchar(32) DEFAULT NULL, `images` varchar(255) DEFAULT NULL, `sex` tinyint(1) DEFAULT NULL, `birthday` varchar(32) DEFAULT NULL, `catname` varchar(32) DEFAULT NULL, `description` text, `status` tinyint(1) DEFAULT '0', `create_time` int(10) DEFAULT NULL, `more` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='重新审核信息表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_cat_update` -- LOCK TABLES `cmf_cat_update` WRITE; /*!40000 ALTER TABLE `cmf_cat_update` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_cat_update` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_comment` -- DROP TABLE IF EXISTS `cmf_comment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_comment` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '被回复的评论id', `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发表评论的用户id', `to_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '被评论的用户id', `object_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论内容 id', `like_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数', `dislike_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '不喜欢数', `floor` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '楼层数', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论时间', `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:已审核,0:未审核', `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '评论类型;1实名评论', `table_name` varchar(64) NOT NULL DEFAULT '' COMMENT '评论内容所在表,不带表前缀', `full_name` varchar(50) NOT NULL DEFAULT '' COMMENT '评论者昵称', `email` varchar(255) NOT NULL DEFAULT '' COMMENT '评论者邮箱', `path` varchar(255) NOT NULL DEFAULT '' COMMENT '层级关系', `url` text COMMENT '原文地址', `content` text COMMENT '评论内容', `more` text COMMENT '扩展属性', PRIMARY KEY (`id`), KEY `table_id_status` (`table_name`,`object_id`,`status`), KEY `object_id` (`object_id`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `parent_id` (`parent_id`) USING BTREE, KEY `create_time` (`create_time`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_comment` -- LOCK TABLES `cmf_comment` WRITE; /*!40000 ALTER TABLE `cmf_comment` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_comment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_hook` -- DROP TABLE IF EXISTS `cmf_hook`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_hook` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '钩子类型(1:系统钩子;2:应用钩子;3:模板钩子;4:后台模板钩子)', `once` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否只允许一个插件运行(0:多个;1:一个)', `name` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名称', `hook` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子', `app` varchar(15) NOT NULL DEFAULT '' COMMENT '应用名(只有应用钩子才用)', `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COMMENT='系统钩子表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_hook` -- LOCK TABLES `cmf_hook` WRITE; /*!40000 ALTER TABLE `cmf_hook` DISABLE KEYS */; INSERT INTO `cmf_hook` VALUES (1,1,0,'应用初始化','app_init','cmf','应用初始化'),(2,1,0,'应用开始','app_begin','cmf','应用开始'),(3,1,0,'模块初始化','module_init','cmf','模块初始化'),(4,1,0,'控制器开始','action_begin','cmf','控制器开始'),(5,1,0,'视图输出过滤','view_filter','cmf','视图输出过滤'),(6,1,0,'应用结束','app_end','cmf','应用结束'),(7,1,0,'日志write方法','log_write','cmf','日志write方法'),(8,1,0,'输出结束','response_end','cmf','输出结束'),(9,1,0,'后台控制器初始化','admin_init','cmf','后台控制器初始化'),(10,1,0,'前台控制器初始化','home_init','cmf','前台控制器初始化'),(11,1,1,'发送手机验证码','send_mobile_verification_code','cmf','发送手机验证码'),(12,3,0,'模板 body标签开始','body_start','','模板 body标签开始'),(13,3,0,'模板 head标签结束前','before_head_end','','模板 head标签结束前'),(14,3,0,'模板底部开始','footer_start','','模板底部开始'),(15,3,0,'模板底部开始之前','before_footer','','模板底部开始之前'),(16,3,0,'模板底部结束之前','before_footer_end','','模板底部结束之前'),(17,3,0,'模板 body 标签结束之前','before_body_end','','模板 body 标签结束之前'),(18,3,0,'模板左边栏开始','left_sidebar_start','','模板左边栏开始'),(19,3,0,'模板左边栏结束之前','before_left_sidebar_end','','模板左边栏结束之前'),(20,3,0,'模板右边栏开始','right_sidebar_start','','模板右边栏开始'),(21,3,0,'模板右边栏结束之前','before_right_sidebar_end','','模板右边栏结束之前'),(22,3,1,'评论区','comment','','评论区'),(23,3,1,'留言区','guestbook','','留言区'),(24,2,0,'后台首页仪表盘','admin_dashboard','admin','后台首页仪表盘'),(25,4,0,'后台模板 head标签结束前','admin_before_head_end','','后台模板 head标签结束前'),(26,4,0,'后台模板 body 标签结束之前','admin_before_body_end','','后台模板 body 标签结束之前'),(27,2,0,'后台登录页面','admin_login','admin','后台登录页面'),(28,1,1,'前台模板切换','switch_theme','cmf','前台模板切换'),(29,3,0,'主要内容之后','after_content','','主要内容之后'),(30,2,0,'文章显示之前','portal_before_assign_article','portal','文章显示之前'),(31,2,0,'后台文章保存之后','portal_admin_after_save_article','portal','后台文章保存之后'),(32,2,1,'获取上传界面','fetch_upload_view','user','获取上传界面'),(33,3,0,'主要内容之前','before_content','cmf','主要内容之前'),(34,1,0,'日志写入完成','log_write_done','cmf','日志写入完成'),(35,1,1,'后台模板切换','switch_admin_theme','cmf','后台模板切换'),(36,1,1,'验证码图片','captcha_image','cmf','验证码图片'),(37,2,1,'后台模板设计界面','admin_theme_design_view','admin','后台模板设计界面'),(38,2,1,'后台设置网站信息界面','admin_setting_site_view','admin','后台设置网站信息界面'),(39,2,1,'后台清除缓存界面','admin_setting_clear_cache_view','admin','后台清除缓存界面'),(40,2,1,'后台导航管理界面','admin_nav_index_view','admin','后台导航管理界面'),(41,2,1,'后台友情链接管理界面','admin_link_index_view','admin','后台友情链接管理界面'),(42,2,1,'后台幻灯片管理界面','admin_slide_index_view','admin','后台幻灯片管理界面'),(43,2,1,'后台管理员列表界面','admin_user_index_view','admin','后台管理员列表界面'),(44,2,1,'后台角色管理界面','admin_rbac_index_view','admin','后台角色管理界面'),(45,2,1,'门户后台文章管理列表界面','portal_admin_article_index_view','portal','门户后台文章管理列表界面'),(46,2,1,'门户后台文章分类管理列表界面','portal_admin_category_index_view','portal','门户后台文章分类管理列表界面'),(47,2,1,'门户后台页面管理列表界面','portal_admin_page_index_view','portal','门户后台页面管理列表界面'),(48,2,1,'门户后台文章标签管理列表界面','portal_admin_tag_index_view','portal','门户后台文章标签管理列表界面'),(49,2,1,'用户管理本站用户列表界面','user_admin_index_view','user','用户管理本站用户列表界面'),(50,2,1,'资源管理列表界面','user_admin_asset_index_view','user','资源管理列表界面'),(51,2,1,'用户管理第三方用户列表界面','user_admin_oauth_index_view','user','用户管理第三方用户列表界面'),(52,2,1,'后台首页界面','admin_index_index_view','admin','后台首页界面'),(53,2,1,'后台回收站界面','admin_recycle_bin_index_view','admin','后台回收站界面'),(54,2,1,'后台菜单管理界面','admin_menu_index_view','admin','后台菜单管理界面'),(55,2,1,'后台自定义登录是否开启钩子','admin_custom_login_open','admin','后台自定义登录是否开启钩子'),(56,4,0,'门户后台文章添加编辑界面右侧栏','portal_admin_article_edit_view_right_sidebar','portal','门户后台文章添加编辑界面右侧栏'),(57,4,0,'门户后台文章添加编辑界面主要内容','portal_admin_article_edit_view_main','portal','门户后台文章添加编辑界面主要内容'),(58,2,1,'门户后台文章添加界面','portal_admin_article_add_view','portal','门户后台文章添加界面'),(59,2,1,'门户后台文章编辑界面','portal_admin_article_edit_view','portal','门户后台文章编辑界面'),(60,2,1,'门户后台文章分类添加界面','portal_admin_category_add_view','portal','门户后台文章分类添加界面'),(61,2,1,'门户后台文章分类编辑界面','portal_admin_category_edit_view','portal','门户后台文章分类编辑界面'),(62,2,1,'门户后台页面添加界面','portal_admin_page_add_view','portal','门户后台页面添加界面'),(63,2,1,'门户后台页面编辑界面','portal_admin_page_edit_view','portal','门户后台页面编辑界面'),(64,2,1,'后台幻灯片页面列表界面','admin_slide_item_index_view','admin','后台幻灯片页面列表界面'),(65,2,1,'后台幻灯片页面添加界面','admin_slide_item_add_view','admin','后台幻灯片页面添加界面'),(66,2,1,'后台幻灯片页面编辑界面','admin_slide_item_edit_view','admin','后台幻灯片页面编辑界面'),(67,2,1,'后台管理员添加界面','admin_user_add_view','admin','后台管理员添加界面'),(68,2,1,'后台管理员编辑界面','admin_user_edit_view','admin','后台管理员编辑界面'),(69,2,1,'后台角色添加界面','admin_rbac_role_add_view','admin','后台角色添加界面'),(70,2,1,'后台角色编辑界面','admin_rbac_role_edit_view','admin','后台角色编辑界面'),(71,2,1,'后台角色授权界面','admin_rbac_authorize_view','admin','后台角色授权界面'); /*!40000 ALTER TABLE `cmf_hook` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_hook_plugin` -- DROP TABLE IF EXISTS `cmf_hook_plugin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_hook_plugin` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)', `hook` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名', `plugin` varchar(50) NOT NULL DEFAULT '' COMMENT '插件', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统钩子插件表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_hook_plugin` -- LOCK TABLES `cmf_hook_plugin` WRITE; /*!40000 ALTER TABLE `cmf_hook_plugin` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_hook_plugin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_link` -- DROP TABLE IF EXISTS `cmf_link`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_link` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:不显示', `rating` int(11) NOT NULL DEFAULT '0' COMMENT '友情链接评级', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `description` varchar(255) NOT NULL DEFAULT '' COMMENT '友情链接描述', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '友情链接地址', `name` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '友情链接名称', `image` varchar(100) NOT NULL DEFAULT '' COMMENT '友情链接图标', `target` varchar(10) NOT NULL DEFAULT '' COMMENT '友情链接打开方式', `rel` varchar(50) NOT NULL DEFAULT '' COMMENT '链接与网站的关系', PRIMARY KEY (`id`), KEY `status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='友情链接表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_link` -- LOCK TABLES `cmf_link` WRITE; /*!40000 ALTER TABLE `cmf_link` DISABLE KEYS */; INSERT INTO `cmf_link` VALUES (1,1,1,8,'thinkcmf官网','http://www.thinkcmf.com','ThinkCMF','','_blank',''); /*!40000 ALTER TABLE `cmf_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_nav` -- DROP TABLE IF EXISTS `cmf_nav`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_nav` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `is_main` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否为主导航;1:是;0:不是', `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '导航位置名称', `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='前台导航位置表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_nav` -- LOCK TABLES `cmf_nav` WRITE; /*!40000 ALTER TABLE `cmf_nav` DISABLE KEYS */; INSERT INTO `cmf_nav` VALUES (1,1,'主导航','主导航'),(2,0,'底部导航',''); /*!40000 ALTER TABLE `cmf_nav` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_nav_menu` -- DROP TABLE IF EXISTS `cmf_nav_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_nav_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nav_id` int(11) NOT NULL COMMENT '导航 id', `parent_id` int(11) NOT NULL COMMENT '父 id', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:隐藏', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称', `target` varchar(10) NOT NULL DEFAULT '' COMMENT '打开方式', `href` varchar(100) NOT NULL DEFAULT '' COMMENT '链接', `icon` varchar(20) NOT NULL DEFAULT '' COMMENT '图标', `path` varchar(255) NOT NULL DEFAULT '' 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 `cmf_nav_menu` -- LOCK TABLES `cmf_nav_menu` WRITE; /*!40000 ALTER TABLE `cmf_nav_menu` DISABLE KEYS */; INSERT INTO `cmf_nav_menu` VALUES (1,1,0,1,0,'首页','','home','','0-1'); /*!40000 ALTER TABLE `cmf_nav_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_option` -- DROP TABLE IF EXISTS `cmf_option`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_option` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `autoload` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否自动加载;1:自动加载;0:不自动加载', `option_name` varchar(64) NOT NULL DEFAULT '' COMMENT '配置名', `option_value` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '配置值', PRIMARY KEY (`id`), UNIQUE KEY `option_name` (`option_name`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='全站配置表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_option` -- LOCK TABLES `cmf_option` WRITE; /*!40000 ALTER TABLE `cmf_option` DISABLE KEYS */; INSERT INTO `cmf_option` VALUES (1,1,'site_info','{\"site_name\":\"WORLD CAT ASSOCIATION\",\"site_seo_title\":\"WORLD CAT ASSOCIATION,\\u4e16\\u754c\\u732b\\u534f\\u4f1a,\\u732b\\u56fd\\u9645\\u8bc1\\u4e66,\\u732b\\u820d,WCA\\uff0c\\u732b\\u534f\\u4f1a\",\"site_seo_keywords\":\"WORLD CAT ASSOCIATION,\\u4e16\\u754c\\u732b\\u534f\\u4f1a,\\u732b\\u56fd\\u9645\\u8bc1\\u4e66,\\u732b\\u820d,WCA\\uff0c\\u732b\\u534f\\u4f1a\",\"site_seo_description\":\"WORLD CAT ASSOCIATION,\\u4e16\\u754c\\u732b\\u534f\\u4f1a,\\u732b\\u56fd\\u9645\\u8bc1\\u4e66,\\u732b\\u820d,WCA\\uff0c\\u732b\\u534f\\u4f1a\",\"site_icp\":\"\\u6d59ICP\\u590717004408\\u53f7-3\",\"site_gwa\":\"\",\"site_admin_email\":\"service@wca.cat\",\"site_analytics\":\"\"}'),(2,1,'cmf_settings','{\"open_registration\":\"0\",\"banned_usernames\":\"\"}'),(3,1,'cdn_settings','{\"cdn_static_root\":\"\"}'),(4,1,'admin_settings','{\"admin_password\":\"bossboss\",\"admin_theme\":\"admin_simpleboot3\",\"admin_style\":\"flatadmin\"}'),(5,1,'wx_setting','{\"token\":\"test\",\"appid\":\"wx537845588f94f61c\",\"appsecret\":\"8b78ed1a9cc3771b38f6a5f0897d45f2\",\"encodingaeskey\":\"BJIUzE0gqlWy0GxfPp4J1oPTBmOrNDIGPNav1YFH5Z5\",\"mch_id\":\"1438674402\",\"mch_key\":\"8s6f8fd356f4g8re68re8ter77rer\"}'),(6,1,'aliyun_setting','{\"key\":\"LTAI4FjUULcmkpzPV1hs8ECE\",\"secret\":\"MIkQShaxGj06xxa0W8VOWdPc1IcOea\",\"sign\":\"WCA\\u4e16\\u754c\\u732b\\u534f\\u4f1a\",\"tpl\":\"SMS_181859029\"}'),(7,1,'price_setting','{\"cprice\":\"300\",\"hprice\":\"350\",\"bprice\":\"200\",\"zprice\":\"100\",\"kprice\":\"100\",\"order_out\":\"2\"}'),(8,1,'upload_setting','{\"max_files\":\"5\",\"chunk_size\":\"512\",\"file_types\":{\"image\":{\"upload_max_filesize\":\"10240\",\"extensions\":\"jpg,jpeg,png,gif\"},\"video\":{\"upload_max_filesize\":\"10240\",\"extensions\":\"mp4,avi,wmv,rm,rmvb,mkv\"},\"audio\":{\"upload_max_filesize\":\"10240\",\"extensions\":\"mp3,wma,wav\"},\"file\":{\"upload_max_filesize\":\"10240\",\"extensions\":\"txt,pdf,doc,docx,xls,xlsx,ppt,pptx\"}}}'); /*!40000 ALTER TABLE `cmf_option` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_plugin` -- DROP TABLE IF EXISTS `cmf_plugin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_plugin` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id', `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '插件类型;1:网站;8:微信', `has_admin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否有后台管理,0:没有;1:有', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:开启;0:禁用', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '插件安装时间', `name` varchar(50) NOT NULL DEFAULT '' COMMENT '插件标识名,英文字母(惟一)', `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '插件名称', `demo_url` varchar(50) NOT NULL DEFAULT '' COMMENT '演示地址,带协议', `hooks` varchar(255) NOT NULL DEFAULT '' COMMENT '实现的钩子;以“,”分隔', `author` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '插件作者', `author_url` varchar(50) NOT NULL DEFAULT '' COMMENT '作者网站链接', `version` varchar(20) NOT NULL DEFAULT '' COMMENT '插件版本号', `description` varchar(255) NOT NULL COMMENT '插件描述', `config` text COMMENT '插件配置', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='插件表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_plugin` -- LOCK TABLES `cmf_plugin` WRITE; /*!40000 ALTER TABLE `cmf_plugin` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_plugin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_portal_category` -- DROP TABLE IF EXISTS `cmf_portal_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_portal_category` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id', `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类父id', `post_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类文章数', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布', `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称', `description` varchar(255) NOT NULL DEFAULT '' COMMENT '分类描述', `path` varchar(255) NOT NULL DEFAULT '' COMMENT '分类层级关系路径', `seo_title` varchar(100) NOT NULL DEFAULT '', `seo_keywords` varchar(255) NOT NULL DEFAULT '', `seo_description` varchar(255) NOT NULL DEFAULT '', `list_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类列表模板', `one_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类文章页模板', `more` text COMMENT '扩展属性', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='portal应用 文章分类表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_portal_category` -- LOCK TABLES `cmf_portal_category` WRITE; /*!40000 ALTER TABLE `cmf_portal_category` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_portal_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_portal_category_post` -- DROP TABLE IF EXISTS `cmf_portal_category_post`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_portal_category_post` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `post_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文章id', `category_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类id', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布', PRIMARY KEY (`id`), KEY `term_taxonomy_id` (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='portal应用 分类文章对应表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_portal_category_post` -- LOCK TABLES `cmf_portal_category_post` WRITE; /*!40000 ALTER TABLE `cmf_portal_category_post` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_portal_category_post` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_portal_post` -- DROP TABLE IF EXISTS `cmf_portal_post`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_portal_post` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父级id', `post_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '类型,1:文章;2:页面', `post_format` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '内容格式;1:html;2:md', `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '发表者用户id', `post_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:已发布;0:未发布;', `comment_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '评论状态;1:允许;0:不允许', `is_top` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶;1:置顶;0:不置顶', `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐', `post_hits` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '查看数', `post_favorites` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收藏数', `post_like` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数', `comment_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '评论数', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `published_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间', `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间', `post_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'post标题', `post_keywords` varchar(150) NOT NULL DEFAULT '' COMMENT 'seo keywords', `post_excerpt` varchar(500) NOT NULL DEFAULT '' COMMENT 'post摘要', `post_source` varchar(150) NOT NULL DEFAULT '' COMMENT '转载文章的来源', `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图', `post_content` text COMMENT '文章内容', `post_content_filtered` text COMMENT '处理过的文章内容', `more` text COMMENT '扩展属性,如缩略图;格式为json', PRIMARY KEY (`id`), KEY `type_status_date` (`post_type`,`post_status`,`create_time`,`id`), KEY `parent_id` (`parent_id`), KEY `user_id` (`user_id`), KEY `create_time` (`create_time`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='portal应用 文章表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_portal_post` -- LOCK TABLES `cmf_portal_post` WRITE; /*!40000 ALTER TABLE `cmf_portal_post` DISABLE KEYS */; INSERT INTO `cmf_portal_post` VALUES (1,0,2,1,1,1,1,0,0,0,0,0,0,1578277254,1583470634,1578277200,0,'联系客服','','','','','\n<p style="text-align: center;"><strong>World Cat Association</strong></p>\n<p style="text-align: center;"><strong>服务中心</strong></p>\n<p style="text-align: center;"><strong>如果您在注册认证时遇到困难,如果您想成为区域俱乐部成员,如果您想与我们进行商业合作,请扫长按信企业二维码与我们联系。</strong></p>\n<p style="text-align: center;"><strong><img src="/public/upload/default/20200306/1a71cb73f0a274c78b439a48049d1c8d.png" title="8D822424564307146546B67DDB8F5AF8.png" alt="8D822424564307146546B67DDB8F5AF8.png" width="217" height="319" style="width: 217px; height: 319px;"></strong></p>\n',NULL,'{\"thumbnail\":\"\",\"template\":\"page\"}'),(2,0,2,1,1,1,1,0,0,0,0,0,0,1578277265,1585022832,1578277200,0,'关于我们','','','','','\n<p><span style=''color: rgb(51, 51, 51); font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''>世界猫协会(World Cat Association,简称WCA,以下简称“WCA”)是一家提供世界级纯种猫基因注册的非盈利性组织,同时也开放针对家庭宠物进行国际证书注册。该协会成立的任务是进行所有品种猫的血统注册,保护、促进家猫的健康与基因改良。从真正意义上让所有的猫都能拥有属于自己的国际化证书,通过后台强大的数据,为宠物持有人提供查询、跟踪、繁育等一系列服务。</span></p>\n<p style="text-align: center;"><span style=''color: rgb(51, 51, 51); font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''><img src="/public/upload/default/20200118/4895427662b2a69f630fad0a98d1efcd.png" title="logo.png" alt="logo.png" width="115" height="123" style="width: 115px; height: 123px;"></span></p>\n<p><span style="color: rgb(255, 0, 0);"><strong><span style=''font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''>2020年3月活动:本月包括猫咪国际证书注册费、猫舍国际证书注册费均实行限免,仅收取证书邮寄费用。</span></strong></span></p>\n<p><span style="color: rgb(255, 0, 0);"><strong><span style=''font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''>2020年4月活动:<strong style="color: rgb(255, 0, 0); white-space: normal;"><span style=''font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''>包括猫咪国际证书注册费、猫舍国际证书注册费均实行原价7折优惠,费用为猫咪证书140元<strong style="color: rgb(255, 0, 0); white-space: normal;"><span style=''font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''><strong><strong><strong>/只</strong></strong></strong></span></strong>、猫舍证书210元,邮寄费用100元。</span></strong></span></strong></span></p>\n<p><span style="color: rgb(255, 0, 0);"><strong><span style=''font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''><strong style="color: rgb(255, 0, 0); white-space: normal;"><span style=''font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''>2020年5月起所有费用恢复原价执行,<strong style="color: rgb(255, 0, 0); white-space: normal;"><span style=''font-family: Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);''><strong>费用为猫咪证书200元/只、猫舍证书300元,邮寄费用100元。</strong></span></strong></span></strong></span></strong></span></p>\n',NULL,'{\"thumbnail\":\"\",\"template\":\"page\"}'),(3,0,2,1,1,1,1,0,0,0,0,0,0,1583470667,1583470667,1583470620,1583470707,'收听介绍','','','','',NULL,NULL,'{\"thumbnail\":\"\",\"template\":\"page\"}'); /*!40000 ALTER TABLE `cmf_portal_post` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_portal_tag` -- DROP TABLE IF EXISTS `cmf_portal_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_portal_tag` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布', `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐', `post_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '标签文章数', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '标签名称', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='portal应用 文章标签表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_portal_tag` -- LOCK TABLES `cmf_portal_tag` WRITE; /*!40000 ALTER TABLE `cmf_portal_tag` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_portal_tag` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_portal_tag_post` -- DROP TABLE IF EXISTS `cmf_portal_tag_post`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_portal_tag_post` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `tag_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '标签 id', `post_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文章 id', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布', PRIMARY KEY (`id`), KEY `post_id` (`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='portal应用 标签文章对应表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_portal_tag_post` -- LOCK TABLES `cmf_portal_tag_post` WRITE; /*!40000 ALTER TABLE `cmf_portal_tag_post` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_portal_tag_post` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_recycle_bin` -- DROP TABLE IF EXISTS `cmf_recycle_bin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_recycle_bin` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `object_id` int(11) DEFAULT '0' COMMENT '删除内容 id', `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间', `table_name` varchar(60) DEFAULT '' COMMENT '删除内容所在表名', `name` varchar(255) DEFAULT '' COMMENT '删除内容名称', `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=' 回收站'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_recycle_bin` -- LOCK TABLES `cmf_recycle_bin` WRITE; /*!40000 ALTER TABLE `cmf_recycle_bin` DISABLE KEYS */; INSERT INTO `cmf_recycle_bin` VALUES (1,3,1583470707,'portal_post#page','收听介绍',0); /*!40000 ALTER TABLE `cmf_recycle_bin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_role` -- DROP TABLE IF EXISTS `cmf_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_role` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父角色ID', `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态;0:禁用;1:正常', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `list_order` float NOT NULL DEFAULT '0' COMMENT '排序', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称', `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), KEY `status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_role` -- LOCK TABLES `cmf_role` WRITE; /*!40000 ALTER TABLE `cmf_role` DISABLE KEYS */; INSERT INTO `cmf_role` VALUES (1,0,1,1329633709,1329633709,0,'超级管理员','拥有网站最高管理员权限!'),(2,0,1,1329633709,1329633709,0,'普通管理员','权限由最高管理员分配!'); /*!40000 ALTER TABLE `cmf_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_role_user` -- DROP TABLE IF EXISTS `cmf_role_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_role_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色 id', `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id', PRIMARY KEY (`id`), KEY `role_id` (`role_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户角色对应表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_role_user` -- LOCK TABLES `cmf_role_user` WRITE; /*!40000 ALTER TABLE `cmf_role_user` DISABLE KEYS */; INSERT INTO `cmf_role_user` VALUES (3,1,36); /*!40000 ALTER TABLE `cmf_role_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_route` -- DROP TABLE IF EXISTS `cmf_route`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_route` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '路由id', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态;1:启用,0:不启用', `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'URL规则类型;1:用户自定义;2:别名添加', `full_url` varchar(255) NOT NULL DEFAULT '' COMMENT '完整url', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '实际显示的url', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='url路由表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_route` -- LOCK TABLES `cmf_route` WRITE; /*!40000 ALTER TABLE `cmf_route` DISABLE KEYS */; INSERT INTO `cmf_route` VALUES (1,5000,1,2,'admin/Index/index','bossboss$'); /*!40000 ALTER TABLE `cmf_route` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_slide` -- DROP TABLE IF EXISTS `cmf_slide`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_slide` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:显示,0不显示', `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间', `name` varchar(50) NOT NULL DEFAULT '' COMMENT '幻灯片分类', `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '分类备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='幻灯片表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_slide` -- LOCK TABLES `cmf_slide` WRITE; /*!40000 ALTER TABLE `cmf_slide` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_slide` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_slide_item` -- DROP TABLE IF EXISTS `cmf_slide_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_slide_item` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `slide_id` int(11) NOT NULL DEFAULT '0' COMMENT '幻灯片id', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:显示;0:隐藏', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '幻灯片名称', `image` varchar(255) NOT NULL DEFAULT '' COMMENT '幻灯片图片', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '幻灯片链接', `target` varchar(10) NOT NULL DEFAULT '' COMMENT '友情链接打开方式', `description` varchar(255) NOT NULL COMMENT '幻灯片描述', `content` text COMMENT '幻灯片内容', `more` text COMMENT '扩展信息', PRIMARY KEY (`id`), KEY `slide_id` (`slide_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='幻灯片子项表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_slide_item` -- LOCK TABLES `cmf_slide_item` WRITE; /*!40000 ALTER TABLE `cmf_slide_item` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_slide_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_theme` -- DROP TABLE IF EXISTS `cmf_theme`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_theme` ( `id` int(11) NOT NULL AUTO_INCREMENT, `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装时间', `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后升级时间', `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '模板状态,1:正在使用;0:未使用', `is_compiled` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否为已编译模板', `theme` varchar(20) NOT NULL DEFAULT '' COMMENT '主题目录名,用于主题的维一标识', `name` varchar(20) NOT NULL DEFAULT '' COMMENT '主题名称', `version` varchar(20) NOT NULL DEFAULT '' COMMENT '主题版本号', `demo_url` varchar(50) NOT NULL DEFAULT '' COMMENT '演示地址,带协议', `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图', `author` varchar(20) NOT NULL DEFAULT '' COMMENT '主题作者', `author_url` varchar(50) NOT NULL DEFAULT '' COMMENT '作者网站链接', `lang` varchar(10) NOT NULL DEFAULT '' COMMENT '支持语言', `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT '主题关键字', `description` varchar(100) NOT NULL DEFAULT '' COMMENT '主题描述', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_theme` -- LOCK TABLES `cmf_theme` WRITE; /*!40000 ALTER TABLE `cmf_theme` DISABLE KEYS */; INSERT INTO `cmf_theme` VALUES (1,0,0,0,0,'simpleboot3','simpleboot3','1.0.2','http://demo.thinkcmf.com','','ThinkCMF','http://www.thinkcmf.com','zh-cn','ThinkCMF模板','ThinkCMF默认模板'); /*!40000 ALTER TABLE `cmf_theme` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_theme_file` -- DROP TABLE IF EXISTS `cmf_theme_file`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_theme_file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `is_public` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否公共的模板文件', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `theme` varchar(20) NOT NULL DEFAULT '' COMMENT '模板名称', `name` varchar(20) NOT NULL DEFAULT '' COMMENT '模板文件名', `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作', `file` varchar(50) NOT NULL DEFAULT '' COMMENT '模板文件,相对于模板根目录,如Portal/index.html', `description` varchar(100) NOT NULL DEFAULT '' COMMENT '模板文件描述', `more` text COMMENT '模板更多配置,用户自己后台设置的', `config_more` text COMMENT '模板更多配置,来源模板的配置文件', `draft_more` text COMMENT '模板更多配置,用户临时保存的配置', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_theme_file` -- LOCK TABLES `cmf_theme_file` WRITE; /*!40000 ALTER TABLE `cmf_theme_file` DISABLE KEYS */; INSERT INTO `cmf_theme_file` VALUES (1,0,10,'simpleboot3','文章页','portal/Article/index','portal/article','文章页模板文件','{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}','{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',NULL),(2,0,10,'simpleboot3','联系我们页','portal/Page/index','portal/contact','联系我们页模板文件','{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"478519726\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}','{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"478519726\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}',NULL),(3,0,5,'simpleboot3','首页','portal/Index/index','portal/index','首页模板文件','{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"features\":{\"title\":\"\\u5feb\\u901f\\u4e86\\u89e3ThinkCMF\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Quickly understand the ThinkCMF\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"features\":{\"title\":\"\\u7279\\u6027\\u4ecb\\u7ecd\",\"value\":[{\"title\":\"MVC\\u5206\\u5c42\\u6a21\\u5f0f\",\"icon\":\"bars\",\"content\":\"\\u4f7f\\u7528MVC\\u5e94\\u7528\\u7a0b\\u5e8f\\u88ab\\u5206\\u6210\\u4e09\\u4e2a\\u6838\\u5fc3\\u90e8\\u4ef6\\uff1a\\u6a21\\u578b\\uff08M\\uff09\\u3001\\u89c6\\u56fe\\uff08V\\uff09\\u3001\\u63a7\\u5236\\u5668\\uff08C\\uff09\\uff0c\\u4ed6\\u4e0d\\u662f\\u4e00\\u4e2a\\u65b0\\u7684\\u6982\\u5ff5\\uff0c\\u53ea\\u662fThinkCMF\\u5c06\\u5176\\u53d1\\u6325\\u5230\\u4e86\\u6781\\u81f4\\u3002\"},{\"title\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"icon\":\"group\",\"content\":\"ThinkCMF\\u5185\\u7f6e\\u4e86\\u7075\\u6d3b\\u7684\\u7528\\u6237\\u7ba1\\u7406\\u65b9\\u5f0f\\uff0c\\u5e76\\u53ef\\u76f4\\u63a5\\u4e0e\\u7b2c\\u4e09\\u65b9\\u7ad9\\u70b9\\u8fdb\\u884c\\u4e92\\u8054\\u4e92\\u901a\\uff0c\\u5982\\u679c\\u4f60\\u613f\\u610f\\u751a\\u81f3\\u53ef\\u4ee5\\u5bf9\\u5355\\u4e2a\\u7528\\u6237\\u6216\\u7fa4\\u4f53\\u7528\\u6237\\u7684\\u884c\\u4e3a\\u8fdb\\u884c\\u8bb0\\u5f55\\u53ca\\u5206\\u4eab\\uff0c\\u4e3a\\u60a8\\u7684\\u8fd0\\u8425\\u51b3\\u7b56\\u63d0\\u4f9b\\u6709\\u6548\\u53c2\\u8003\\u6570\\u636e\\u3002\"},{\"title\":\"\\u4e91\\u7aef\\u90e8\\u7f72\",\"icon\":\"cloud\",\"content\":\"\\u901a\\u8fc7\\u9a71\\u52a8\\u7684\\u65b9\\u5f0f\\u53ef\\u4ee5\\u8f7b\\u677e\\u652f\\u6301\\u4e91\\u5e73\\u53f0\\u7684\\u90e8\\u7f72\\uff0c\\u8ba9\\u4f60\\u7684\\u7f51\\u7ad9\\u65e0\\u7f1d\\u8fc1\\u79fb\\uff0c\\u5185\\u7f6e\\u5df2\\u7ecf\\u652f\\u6301SAE\\u3001BAE\\uff0c\\u6b63\\u5f0f\\u7248\\u5c06\\u5bf9\\u4e91\\u7aef\\u90e8\\u7f72\\u8fdb\\u884c\\u8fdb\\u4e00\\u6b65\\u4f18\\u5316\\u3002\"},{\"title\":\"\\u5b89\\u5168\\u7b56\\u7565\",\"icon\":\"heart\",\"content\":\"\\u63d0\\u4f9b\\u7684\\u7a33\\u5065\\u7684\\u5b89\\u5168\\u7b56\\u7565\\uff0c\\u5305\\u62ec\\u5907\\u4efd\\u6062\\u590d\\uff0c\\u5bb9\\u9519\\uff0c\\u9632\\u6cbb\\u6076\\u610f\\u653b\\u51fb\\u767b\\u9646\\uff0c\\u7f51\\u9875\\u9632\\u7be1\\u6539\\u7b49\\u591a\\u9879\\u5b89\\u5168\\u7ba1\\u7406\\u529f\\u80fd\\uff0c\\u4fdd\\u8bc1\\u7cfb\\u7edf\\u5b89\\u5168\\uff0c\\u53ef\\u9760\\uff0c\\u7a33\\u5b9a\\u7684\\u8fd0\\u884c\\u3002\"},{\"title\":\"\\u5e94\\u7528\\u6a21\\u5757\\u5316\",\"icon\":\"cubes\",\"content\":\"\\u63d0\\u51fa\\u5168\\u65b0\\u7684\\u5e94\\u7528\\u6a21\\u5f0f\\u8fdb\\u884c\\u6269\\u5c55\\uff0c\\u4e0d\\u7ba1\\u662f\\u4f60\\u5f00\\u53d1\\u4e00\\u4e2a\\u5c0f\\u529f\\u80fd\\u8fd8\\u662f\\u4e00\\u4e2a\\u5168\\u65b0\\u7684\\u7ad9\\u70b9\\uff0c\\u5728ThinkCMF\\u4e2d\\u4f60\\u53ea\\u662f\\u589e\\u52a0\\u4e86\\u4e00\\u4e2aAPP\\uff0c\\u6bcf\\u4e2a\\u72ec\\u7acb\\u8fd0\\u884c\\u4e92\\u4e0d\\u5f71\\u54cd\\uff0c\\u4fbf\\u4e8e\\u7075\\u6d3b\\u6269\\u5c55\\u548c\\u4e8c\\u6b21\\u5f00\\u53d1\\u3002\"},{\"title\":\"\\u514d\\u8d39\\u5f00\\u6e90\",\"icon\":\"certificate\",\"content\":\"\\u4ee3\\u7801\\u9075\\u5faaApache2\\u5f00\\u6e90\\u534f\\u8bae\\uff0c\\u514d\\u8d39\\u4f7f\\u7528\\uff0c\\u5bf9\\u5546\\u4e1a\\u7528\\u6237\\u4e5f\\u65e0\\u4efb\\u4f55\\u9650\\u5236\\u3002\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"text\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}','{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"features\":{\"title\":\"\\u5feb\\u901f\\u4e86\\u89e3ThinkCMF\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Quickly understand the ThinkCMF\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"features\":{\"title\":\"\\u7279\\u6027\\u4ecb\\u7ecd\",\"value\":[{\"title\":\"MVC\\u5206\\u5c42\\u6a21\\u5f0f\",\"icon\":\"bars\",\"content\":\"\\u4f7f\\u7528MVC\\u5e94\\u7528\\u7a0b\\u5e8f\\u88ab\\u5206\\u6210\\u4e09\\u4e2a\\u6838\\u5fc3\\u90e8\\u4ef6\\uff1a\\u6a21\\u578b\\uff08M\\uff09\\u3001\\u89c6\\u56fe\\uff08V\\uff09\\u3001\\u63a7\\u5236\\u5668\\uff08C\\uff09\\uff0c\\u4ed6\\u4e0d\\u662f\\u4e00\\u4e2a\\u65b0\\u7684\\u6982\\u5ff5\\uff0c\\u53ea\\u662fThinkCMF\\u5c06\\u5176\\u53d1\\u6325\\u5230\\u4e86\\u6781\\u81f4\\u3002\"},{\"title\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"icon\":\"group\",\"content\":\"ThinkCMF\\u5185\\u7f6e\\u4e86\\u7075\\u6d3b\\u7684\\u7528\\u6237\\u7ba1\\u7406\\u65b9\\u5f0f\\uff0c\\u5e76\\u53ef\\u76f4\\u63a5\\u4e0e\\u7b2c\\u4e09\\u65b9\\u7ad9\\u70b9\\u8fdb\\u884c\\u4e92\\u8054\\u4e92\\u901a\\uff0c\\u5982\\u679c\\u4f60\\u613f\\u610f\\u751a\\u81f3\\u53ef\\u4ee5\\u5bf9\\u5355\\u4e2a\\u7528\\u6237\\u6216\\u7fa4\\u4f53\\u7528\\u6237\\u7684\\u884c\\u4e3a\\u8fdb\\u884c\\u8bb0\\u5f55\\u53ca\\u5206\\u4eab\\uff0c\\u4e3a\\u60a8\\u7684\\u8fd0\\u8425\\u51b3\\u7b56\\u63d0\\u4f9b\\u6709\\u6548\\u53c2\\u8003\\u6570\\u636e\\u3002\"},{\"title\":\"\\u4e91\\u7aef\\u90e8\\u7f72\",\"icon\":\"cloud\",\"content\":\"\\u901a\\u8fc7\\u9a71\\u52a8\\u7684\\u65b9\\u5f0f\\u53ef\\u4ee5\\u8f7b\\u677e\\u652f\\u6301\\u4e91\\u5e73\\u53f0\\u7684\\u90e8\\u7f72\\uff0c\\u8ba9\\u4f60\\u7684\\u7f51\\u7ad9\\u65e0\\u7f1d\\u8fc1\\u79fb\\uff0c\\u5185\\u7f6e\\u5df2\\u7ecf\\u652f\\u6301SAE\\u3001BAE\\uff0c\\u6b63\\u5f0f\\u7248\\u5c06\\u5bf9\\u4e91\\u7aef\\u90e8\\u7f72\\u8fdb\\u884c\\u8fdb\\u4e00\\u6b65\\u4f18\\u5316\\u3002\"},{\"title\":\"\\u5b89\\u5168\\u7b56\\u7565\",\"icon\":\"heart\",\"content\":\"\\u63d0\\u4f9b\\u7684\\u7a33\\u5065\\u7684\\u5b89\\u5168\\u7b56\\u7565\\uff0c\\u5305\\u62ec\\u5907\\u4efd\\u6062\\u590d\\uff0c\\u5bb9\\u9519\\uff0c\\u9632\\u6cbb\\u6076\\u610f\\u653b\\u51fb\\u767b\\u9646\\uff0c\\u7f51\\u9875\\u9632\\u7be1\\u6539\\u7b49\\u591a\\u9879\\u5b89\\u5168\\u7ba1\\u7406\\u529f\\u80fd\\uff0c\\u4fdd\\u8bc1\\u7cfb\\u7edf\\u5b89\\u5168\\uff0c\\u53ef\\u9760\\uff0c\\u7a33\\u5b9a\\u7684\\u8fd0\\u884c\\u3002\"},{\"title\":\"\\u5e94\\u7528\\u6a21\\u5757\\u5316\",\"icon\":\"cubes\",\"content\":\"\\u63d0\\u51fa\\u5168\\u65b0\\u7684\\u5e94\\u7528\\u6a21\\u5f0f\\u8fdb\\u884c\\u6269\\u5c55\\uff0c\\u4e0d\\u7ba1\\u662f\\u4f60\\u5f00\\u53d1\\u4e00\\u4e2a\\u5c0f\\u529f\\u80fd\\u8fd8\\u662f\\u4e00\\u4e2a\\u5168\\u65b0\\u7684\\u7ad9\\u70b9\\uff0c\\u5728ThinkCMF\\u4e2d\\u4f60\\u53ea\\u662f\\u589e\\u52a0\\u4e86\\u4e00\\u4e2aAPP\\uff0c\\u6bcf\\u4e2a\\u72ec\\u7acb\\u8fd0\\u884c\\u4e92\\u4e0d\\u5f71\\u54cd\\uff0c\\u4fbf\\u4e8e\\u7075\\u6d3b\\u6269\\u5c55\\u548c\\u4e8c\\u6b21\\u5f00\\u53d1\\u3002\"},{\"title\":\"\\u514d\\u8d39\\u5f00\\u6e90\",\"icon\":\"certificate\",\"content\":\"\\u4ee3\\u7801\\u9075\\u5faaApache2\\u5f00\\u6e90\\u534f\\u8bae\\uff0c\\u514d\\u8d39\\u4f7f\\u7528\\uff0c\\u5bf9\\u5546\\u4e1a\\u7528\\u6237\\u4e5f\\u65e0\\u4efb\\u4f55\\u9650\\u5236\\u3002\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"text\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',NULL),(4,0,10,'simpleboot3','文章列表页','portal/List/index','portal/list','文章列表模板文件','{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}','{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',NULL),(5,0,10,'simpleboot3','单页面','portal/Page/index','portal/page','单页面模板文件','{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}','{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',NULL),(6,0,10,'simpleboot3','搜索页面','portal/search/index','portal/search','搜索模板文件','{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}','{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}',NULL),(7,1,0,'simpleboot3','模板全局配置','public/Config','public/config','模板全局配置文件','{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}','{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}',NULL),(8,1,1,'simpleboot3','导航条','public/Nav','public/nav','导航条模板文件','{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"ThinkCMF\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}','{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"ThinkCMF\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',NULL); /*!40000 ALTER TABLE `cmf_theme_file` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_third_party_user` -- DROP TABLE IF EXISTS `cmf_third_party_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_third_party_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '本站用户id', `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间', `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'access_token过期时间', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '绑定时间', `login_times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:正常;0:禁用', `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '用户昵称', `third_party` varchar(20) NOT NULL DEFAULT '' COMMENT '第三方惟一码', `app_id` varchar(64) NOT NULL DEFAULT '' COMMENT '第三方应用 id', `last_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip', `access_token` varchar(512) NOT NULL DEFAULT '' COMMENT '第三方授权码', `openid` varchar(40) NOT NULL DEFAULT '' COMMENT '第三方用户id', `union_id` varchar(64) NOT NULL DEFAULT '' COMMENT '第三方用户多个产品中的惟一 id,(如:微信平台)', `more` text COMMENT '扩展信息', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='第三方用户表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_third_party_user` -- LOCK TABLES `cmf_third_party_user` WRITE; /*!40000 ALTER TABLE `cmf_third_party_user` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_third_party_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user` -- DROP TABLE IF EXISTS `cmf_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '用户类型;1:admin;2:会员', `sex` tinyint(2) NOT NULL DEFAULT '0' COMMENT '性别;0:保密,1:男,2:女', `birthday` int(11) NOT NULL DEFAULT '0' COMMENT '生日', `last_login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间', `score` int(11) NOT NULL DEFAULT '0' COMMENT '用户积分', `coin` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金币', `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间', `user_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '用户状态;0:禁用,1:正常,2:未验证', `user_login` varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名', `user_pass` varchar(64) NOT NULL DEFAULT '' COMMENT '登录密码;cmf_password加密', `user_nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称', `user_email` varchar(100) NOT NULL DEFAULT '' COMMENT '用户登录邮箱', `user_url` varchar(100) NOT NULL DEFAULT '' COMMENT '用户个人网址', `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像', `signature` varchar(255) NOT NULL DEFAULT '' COMMENT '个性签名', `last_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip', `user_activation_key` varchar(60) NOT NULL DEFAULT '' COMMENT '激活码', `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '中国手机不带国家代码,国际手机号格式为:国家代码-手机号', `openid` varchar(40) DEFAULT NULL COMMENT '微信openid', `more` text COMMENT '扩展属性', PRIMARY KEY (`id`), KEY `user_login` (`user_login`), KEY `user_nickname` (`user_nickname`) ) ENGINE=InnoDB AUTO_INCREMENT=184 DEFAULT CHARSET=utf8 COMMENT='用户表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user` -- LOCK TABLES `cmf_user` WRITE; /*!40000 ALTER TABLE `cmf_user` DISABLE KEYS */; INSERT INTO `cmf_user` VALUES (1,1,0,0,1606208910,0,0,0.00,1577498771,1,'admin','###4670ffafa435f023de9db7954e67b905','admin','admin@admin.com','','','','115.198.177.158','','',NULL,NULL),(36,1,0,0,1606209541,0,0,0.00,0,1,'boss','###25f682e3848905f2aa742855245475ed','','ceo@wca.cat','','','','182.150.133.97','','',NULL,NULL),(37,2,0,0,1606209936,19,19,0.00,1583249093,1,'玖爺','###0eff01ca979fc496dd8a009b47dc1713','玖爺','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJPR0ynHcF36kXSdECfVhibqIhUDrqicW90u7iaLqCdzicwCljbOuq6N7CnM865M0ibdaP2LruLJq9icrlA/132','','115.198.177.158','','15088666698','oDjx9t6BqAWvcjE8CK_IjK94255A',NULL),(38,2,0,0,1585001293,1,1,0.00,1584937324,1,'王栋斌','###0eff01ca979fc496dd8a009b47dc1713',' 楼主','','','http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83epWDH0v2UGnVcTkMrSGhpWsZ0CKgJQ3qh2u87HjKCavIicRibo9OsdIoQamRraFeaQSWMUFic6gJP1Ng/132','','115.204.127.12','','18968048971','oDjx9t4LOoKKhKJHEl8cYVtUTzGo',NULL),(39,2,0,0,1584937349,0,0,0.00,1584937349,1,'邓红亮','###0eff01ca979fc496dd8a009b47dc1713','三味疏屋','','','http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83erZm9ZSoUhX2RR7CHGicbAe4WxhqLm5G7dYKxlmHlj2ROQxicYyO1OoVoyf5w5rYXIlibodussmEtndg/132','','112.17.106.102','','13758107697','oDjx9t5vpDitI43SU6awdrzBiZW8',NULL),(40,2,0,0,1584937767,0,0,0.00,1584937767,1,'徐鹏展','###0eff01ca979fc496dd8a009b47dc1713','Xu.','','','http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eq4XTRc2K0lictN87EqvkIT7KGMUia8tBmJt74xs6iaKF1Lv7BVp1sdt3ibHrqEgkAoiaYBaFyKox4Vgag/132','','39.149.12.130','','13298314330','oDjx9t5nK_I7XrsUMYYHHLiF6OXc',NULL),(41,2,0,0,1584937911,0,0,0.00,1584937911,1,'黄诚','###0eff01ca979fc496dd8a009b47dc1713','小刑十七','','','http://thirdwx.qlogo.cn/mmopen/vi_32/MJ6gVyiavATTnGg2rafFetke9CxCzUic8Gt8Ypric29sVHweJFowgng6icLUqlItCCiajjD27AnRqvUdH2toLRZiaAJw/132','','218.89.215.156','','13228221127','oDjx9t6n01rACo6KL0wpOHVdoZLM',NULL),(42,2,0,0,1586013263,2,2,0.00,1584938001,1,'余梓圻','###0eff01ca979fc496dd8a009b47dc1713','?余帅气','','','http://thirdwx.qlogo.cn/mmopen/vi_32/LYOpxBxdu5XjW8yBj3cibf4o7ia3Je7YvBZo2nBJCKMLztTyoznfehJSachiaOJUjoQvg4Qc8Al6ZCwiaUd0GoZaeQ/132','','113.87.9.156','','13829620061','oDjx9t8S99ieXvk9gSrxaoWneViA',NULL),(43,2,0,0,1584938154,0,0,0.00,1584938154,1,'窦正龙','###0eff01ca979fc496dd8a009b47dc1713','蛋凡宠物','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLj1JIHX0icWAh2KL4L1beCEXbgyBI1ZvIeAQHnuZjrZvEsWdtmTicREERbA76NIb4y5AM9s0ebRNvA/132','','58.243.254.247','','13002188839','oDjx9t-wCCFuwB8YNhY9bfnzfu2g',NULL),(44,2,0,0,1584938231,0,0,0.00,1584938231,1,'陈静雯','###0eff01ca979fc496dd8a009b47dc1713','Mos ༶静雯','','','http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eq9dAhibicsKF8k4jriasKOAIGmzZibVXJicPNtPHSD1bxMYdlBLLQgAHLW4ib1NtH7rNsDXfBE4wJ0JhbA/132','','183.54.40.93','','15361020384','oDjx9t6uKJ2r6uZDaa_mSaH2WTH4',NULL),(45,2,0,0,1594746082,1,1,0.00,1584938634,1,'蒋涛','###0eff01ca979fc496dd8a009b47dc1713','蒋涛','','','','','117.136.116.20','','13865093093',NULL,NULL),(46,2,0,0,1596530179,4,4,0.00,1584939692,1,'王其龙','###0eff01ca979fc496dd8a009b47dc1713','甜湫studio¹?ྀི','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Hx8PLYNectia4m2E1kSsv4IggSVllXOPpVhHGXJcogFqib7cGezpCB8KqFwWnLiaB5TdynU0Uo0TRVWfe3RnPZfZA/132','','112.248.193.17','','17317739795','oDjx9twq9elN7yd9nxFC2lJaQ5v8',NULL),(47,2,0,0,1584941209,0,0,0.00,1584941209,1,'黄俊贤','###0eff01ca979fc496dd8a009b47dc1713','yellow-jun(喵不可颜)','','','http://thirdwx.qlogo.cn/mmopen/vi_32/pnWHOoy3S0eRIKD2OqQWtzrNWYCTCMHicz1M88yibFtS6QZ2lVqE7wdL399QKKicXc3wibU645IanS8CT0Ps5ZwLug/132','','223.192.248.194','','15989981477','oDjx9t3aHYKwCekp5F6LmfxJ52x4',NULL),(48,2,0,0,1584941826,0,0,0.00,1584941826,1,'肖茹允','###0eff01ca979fc496dd8a009b47dc1713','Sera?','','','http://thirdwx.qlogo.cn/mmopen/vi_32/icMIb1bWibxmPvVA7rfJA1PRVdicQJxRGx8OZicO4l4X2BErd7BRj97ON7Y6zqn3BJC8LgkPcHFqe3xXMtmPgL5MlQ/132','','117.136.62.10','','18380468886','oDjx9t-wUScP7i5BYzddCRiDZ27Y',NULL),(49,2,0,0,1584943052,0,0,0.00,1584943052,1,'韩宛彤','###0eff01ca979fc496dd8a009b47dc1713','饲养员','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTIl5uHJ2ia0A85UsUpzU82KSV4GOIGUFPEksVAuxmxHccSdNjoeELxjqWSXBUtyo9HXrE3AEKdXcGQ/132','','218.61.30.43','','18340857857','oDjx9t-4OJ5gTXTMVlRg68HVwsoU',NULL),(50,2,0,0,1585208893,3,3,0.00,1584956670,1,'李雪','###0eff01ca979fc496dd8a009b47dc1713','小野猫很酷','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLvfic0yoAJYva3yNodtkMQeSncfKAbIL9akOHj2v1QXj7l9bRhQoRGUVAssqibmibdgUX4zCArXxDPg/132','','223.104.5.169','','15121151161','oDjx9t9Nv9Zbgq5agwyjicHEJXoY',NULL),(51,2,0,0,1584960326,0,0,0.00,1584960326,1,'高雅婷','###0eff01ca979fc496dd8a009b47dc1713','Sheep','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKwZMN8lRQ5QSJHhe2Mk1FEcKEJPLKfDxhBErx4p6PB7GRlDQCRMmJsxMfTICZylDJUK6BYY6op8Q/132','','60.25.12.1','','17602233927','oDjx9t4cBxVqpjjlDnTOUkibRC4I',NULL),(52,2,0,0,1584964811,0,0,0.00,1584964811,1,'小豹','###0eff01ca979fc496dd8a009b47dc1713','小豹?','','','http://thirdwx.qlogo.cn/mmopen/vi_32/PiajxSqBRaEJiaicusG9PXK2djrpS9lB6hS74ib4oPFChQqI9IJ7u3PWoPpqKiaSfcQcGPoWtjvNP9PRTefmjkF7ia8w/132','','39.130.115.15','','13700633720','oDjx9txhBytaWN_XIxT3hs6MhAdk',NULL),(53,2,0,0,1585033445,0,0,0.00,1585033445,1,'刘丁毓','###0eff01ca979fc496dd8a009b47dc1713','??','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTIBKUcF74HD3pfcvWPAN2v8CYBYw1xWzqZqSV1MGcY1yTiae0JXkDoCtibUYTxI47MJ9oSNpicKricuBw/132','','112.10.126.94','','18072941890','oDjx9t_65ef-6FyY6PFhEUi5nQ1g',NULL),(54,2,0,0,1585104340,0,0,0.00,1585104340,1,'姚秀玲','###0eff01ca979fc496dd8a009b47dc1713','旅途中邂逅你的喵?(周二店休)','','','http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83erGP7iaAkPYdZalficzkhcnmn0AX5jsA5ocL6PtiaSRVFps21o02JnRefjRVsuGjicb7iavgGrDjasFgwA/132','','218.109.198.27','','18621720462','oDjx9t29qeWUM1jM3XhNe24V1jvs',NULL),(55,2,0,0,1585915578,1,1,0.00,1585137352,1,'龙燕','###0eff01ca979fc496dd8a009b47dc1713','我是小老虎?','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJys1dd5umMoRZwNHUegexZX4X1EuPGNzacXkWfpMasb5JHQDsYdTZfZ7mviaVOP3DGiaAWpulrbUrw/132','','122.238.155.226','','15155355273','oDjx9t4S5tc6a4ucBFycEdj-au04',NULL),(56,2,0,0,1586122330,0,0,0.00,1586122330,1,'王晴','###0eff01ca979fc496dd8a009b47dc1713','王兔子?','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKrnkeBWhKAmTH6pqA0QhR2YL39uhvN09ZnaNWh8tIy2fHBEyaca0WqVIGicrSzzrejt2gV49xJ8Jw/132','','183.13.212.152','','18002584003','oDjx9t7h8_stmlnFh7eMcXJU-938',NULL),(57,2,0,0,1587708724,0,0,0.00,1587708724,1,'Jerry','###0eff01ca979fc496dd8a009b47dc1713','DREAMS','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKMdwicC6ianQ37V1I8YsiaiafLnhJTj833waniasiav7lz4iafU1zeVMp2oB83D3eCVVy4yGwgd8xRExRibg/132','','36.17.124.50','','15381891358','oDjx9t3RzYMkg32q2X_dbxFyJy4w',NULL),(58,2,0,0,1588010214,0,0,0.00,1588010214,1,'孙龙坤','###0eff01ca979fc496dd8a009b47dc1713','Slk','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTItibLdiao3uW9u5vibe2XTD6piavPGiattcmduRELPyWZ1XMPxDuJiaialQHgMuPcGUNC40KlexoPZV8LeQ/132','','171.92.179.232','','17716109125','oDjx9t6ITL3LMP-YSa77I4m4V5Gs',NULL),(59,2,0,0,1588137512,2,2,0.00,1588129994,1,'李义洋','###0eff01ca979fc496dd8a009b47dc1713','Young','','','http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoZcrlaAibN6OW0ibsaZAjlNicSEfPxIrxARl8g0wZZyLbxHiacfn4ZiaibqtZPYm0BPpLQibZ9Qcib89IWCA/132','','121.231.48.193','','18951202868','oDjx9tzpAqvi40Rqq4gMFLDciqbY',NULL),(60,2,0,0,1590132350,1,1,0.00,1588234097,1,'高宗茂','###0eff01ca979fc496dd8a009b47dc1713','Jack','','','http://thirdwx.qlogo.cn/mmopen/vi_32/A2YibaBxSgQXlaqWEmMd8qhsAibfMPGUC511gtZJoquHwvOicZd6QhxndjyqumibyxicPmVAtC1ia7KK0icPvjrpxWeTg/132','','112.67.198.88','','17689745161','oDjx9t7uBKl4zOo92VPTQZTiOxOQ',NULL),(61,2,0,0,1588234597,0,0,0.00,1588234597,1,'袁明彤','###0eff01ca979fc496dd8a009b47dc1713','暴躁的小圆','','','http://thirdwx.qlogo.cn/mmopen/vi_32/c4l6MLKejkydHXEFe1CzqmApFicrTSiaROWNdicIoibG1MLO5oVicwp8FLSC7FajPGqJjA8I0KibgyORicyz5zjia661ZQ/132','','139.214.144.76','','16643422529','oDjx9t0zAtwuSfhFjBK1QiWi1Q8w',NULL),(62,2,0,0,1591020757,0,0,0.00,1591020757,1,'张元可','###0eff01ca979fc496dd8a009b47dc1713','奇缘','','','http://thirdwx.qlogo.cn/mmopen/vi_32/xtB603UoeXQojUqENlpTmRbaXbcQUZuskq5vBGC4vxwotXiaWbRCmvSBIc7b9JEqLEZXEoqjgIrFWp4ZWwFXc1g/132','','123.186.114.255','','13591559831','oDjx9t6YXDccfjX_4CVjxjVighIU',NULL),(63,2,0,0,1591194932,1,1,0.00,1591194514,1,'陈锦鹏','###0eff01ca979fc496dd8a009b47dc1713','Hi','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJeQVzYNLVuOm892PttBgOarOZJOTuugLzdIudGftkx9KaETTNkPOrAzuvUPVeNXRh4lCCGH5wpMQ/132','','58.247.70.195','','18516570679','oDjx9t0XDuWkxliIFoB2498Cdn4w',NULL),(64,2,0,0,1591943459,0,0,0.00,1591943459,1,'戴冰倩','###0eff01ca979fc496dd8a009b47dc1713','戴冰倩','','','','','112.14.97.34','','18072178982',NULL,NULL),(65,2,0,0,1592893408,0,0,0.00,1592893408,1,'任月','###0eff01ca979fc496dd8a009b47dc1713','任月','','','','','175.167.146.27','','17624189805',NULL,NULL),(66,2,0,0,1593069767,0,0,0.00,1593069767,1,'张哲凡','###0eff01ca979fc496dd8a009b47dc1713','张哲凡','','','','','222.80.202.32','','18709051765',NULL,NULL),(67,2,0,0,1593234203,0,0,0.00,1593234203,1,'张开礼','###0eff01ca979fc496dd8a009b47dc1713','张开礼','','','','','125.114.35.22','','13402026324',NULL,NULL),(68,2,0,0,1593256092,1,1,0.00,1593255832,1,'郑宏禄','###0eff01ca979fc496dd8a009b47dc1713','郑宏禄','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTI1PKibk8uJUzkKb1HsLOMsIA60FnoYEBfNLAQlOxA6ib7f2icXfALTveu5pz999OsSlmbpxwMcpvr7g/132','','27.190.222.39','','13920529218','oDjx9tyu6ucIUfLODSA4Nn7sKLpA',NULL),(69,2,0,0,1593483770,0,0,0.00,1593483770,1,'刘青云','###0eff01ca979fc496dd8a009b47dc1713','刘青云','','','','','220.176.183.121','','13766437394',NULL,NULL),(70,2,0,0,1593570442,0,0,0.00,1593570442,1,'陈兴文','###0eff01ca979fc496dd8a009b47dc1713','陈兴文','','','','','113.109.30.132','','18028511672',NULL,NULL),(71,2,0,0,1593745476,0,0,0.00,1593745476,1,'关爻','###0eff01ca979fc496dd8a009b47dc1713','关爻','','','','','118.125.91.241','','14780187792',NULL,NULL),(72,2,0,0,1593759409,0,0,0.00,1593759409,1,'LINPING','###0eff01ca979fc496dd8a009b47dc1713','a 林萍13632541413','','','http://thirdwx.qlogo.cn/mmopen/vi_32/6nk9Q8TUOS2FTJuwAm47yicUlpficmxEFjFLy40yL1FuiaJBOLSKd5vJxbGAteR1faGYcKwV38WTUhtXVHZOsDL6A/132','','116.7.54.9','','13632541413','oDjx9t8qIrMydQ3rr6NOeU5mrnZI',NULL),(73,2,0,0,1593788676,0,0,0.00,1593788676,1,'CAOZHENQI','###0eff01ca979fc496dd8a009b47dc1713','CAOZHENQI','','','','','117.188.7.225','','13765156863',NULL,NULL),(74,2,0,0,1593995393,0,0,0.00,1593995393,1,'孙至柔','###0eff01ca979fc496dd8a009b47dc1713','孙至柔','','','','','111.49.38.132','','15769593903',NULL,NULL),(75,2,0,0,1594187058,0,0,0.00,1594187058,1,'张先生','###0eff01ca979fc496dd8a009b47dc1713','张先生','','','','','124.193.222.202','','15810081074',NULL,NULL),(76,2,0,0,1594364018,0,0,0.00,1594364018,1,'赵文洁','###0eff01ca979fc496dd8a009b47dc1713','赵文洁','','','','','106.39.106.205','','15811589681',NULL,NULL),(77,2,0,0,1594373250,0,0,0.00,1594373250,1,'丁格','###0eff01ca979fc496dd8a009b47dc1713','丁格','','','','','112.31.188.134','','15551199500',NULL,NULL),(78,2,0,0,1594620056,0,0,0.00,1594620056,1,'吴为群','###0eff01ca979fc496dd8a009b47dc1713','吴为群','','','','','112.12.255.231','','13858819488',NULL,NULL),(79,2,0,0,1594927938,0,0,0.00,1594927938,1,'刘全','###0eff01ca979fc496dd8a009b47dc1713','刘全','','','','','223.104.98.1','','15903202345',NULL,NULL),(80,2,0,0,1595050508,1,1,0.00,1595050071,1,'黄振凯','###0eff01ca979fc496dd8a009b47dc1713','黄振凯','','','http://thirdwx.qlogo.cn/mmopen/vi_32/zMKVPCRAzH3LYwce6O1DrW32YBK5Qu9qqqMoCrTl5yKmlveFuBC3XzyQP0apdmSLaAnqTMBibRsb0WRZbJibaVlQ/132','','223.104.187.191','','18553603797','oDjx9t0y4TtLvc7ZXqIw5WI4qR6A',NULL),(81,2,0,0,1595169959,0,0,0.00,1595169959,1,'徐娜','###0eff01ca979fc496dd8a009b47dc1713','白雪公主的后妈','','','http://thirdwx.qlogo.cn/mmopen/vi_32/KvIK1VGbVMBVqg8wpeHnF1c2fcRHiaO52Ah0WT233horB1m7bJianX3Kp7lCibEcu74oP2yZYHBa9RGezU3En1VMg/132','','114.91.208.13','','15026935514','oDjx9t6QOHPo6Y2k2MYFPe9YqKBs',NULL),(82,2,0,0,1595311787,0,0,0.00,1595311787,1,'王新佳','###0eff01ca979fc496dd8a009b47dc1713','王新佳','','','','','222.209.27.34','','15708473997',NULL,NULL),(83,2,0,0,1595635390,0,0,0.00,1595635390,1,'王罡','###0eff01ca979fc496dd8a009b47dc1713','王罡','','','','','175.168.105.109','','13889188626',NULL,NULL),(84,2,0,0,1595725819,0,0,0.00,1595725819,1,'裴蕾','###0eff01ca979fc496dd8a009b47dc1713','裴蕾','','','','','119.250.157.37','','15122500121',NULL,NULL),(85,2,0,0,1601644542,1,1,0.00,1595743127,1,'李思奇','###0eff01ca979fc496dd8a009b47dc1713','CFA? Dormammu缅因猫?','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTL99ibrwlXeghtThKw24HkKl2PEWEd5OZY5LuyYr8UYP7yJfV2FiaJsbiaVSwRw5m6Ikhr9Y4WibWEOPQ/132','','117.39.194.250','','13689295431','oDjx9tyYZ-LDmEQlydWpj4AkT39o',NULL),(86,2,0,0,1595823254,0,0,0.00,1595823254,1,'潘涛','###0eff01ca979fc496dd8a009b47dc1713','潘涛','','','','','171.43.235.83','','13451007490',NULL,NULL),(87,2,0,0,1595841397,0,0,0.00,1595841397,1,'赵','###0eff01ca979fc496dd8a009b47dc1713','赵','','','','','125.116.213.192','','15957100450',NULL,NULL),(88,2,0,0,1596249837,0,0,0.00,1596249837,1,'杨德飞','###0eff01ca979fc496dd8a009b47dc1713','杨德飞','','','','','183.208.26.85','','18951950552',NULL,NULL),(89,2,0,0,1596373281,0,0,0.00,1596373281,1,'朱丹','###0eff01ca979fc496dd8a009b47dc1713','朱丹','','','','','175.161.161.153','','15998866775',NULL,NULL),(90,2,0,0,1596377357,0,0,0.00,1596377357,1,'林本立','###0eff01ca979fc496dd8a009b47dc1713','林本立','','','','','39.88.153.33','','13864861378',NULL,NULL),(91,2,0,0,1596466667,0,0,0.00,1596466667,1,'林婷婷','###0eff01ca979fc496dd8a009b47dc1713','林婷婷','','','','','112.1.54.17','','15365186510',NULL,NULL),(92,2,0,0,1596531790,0,0,0.00,1596531790,1,'袁钰淳','###0eff01ca979fc496dd8a009b47dc1713','袁钰淳','','','','','117.136.32.46','','15118413735',NULL,NULL),(93,2,0,0,1596631402,1,1,0.00,1596631231,1,'徐石柱','###0eff01ca979fc496dd8a009b47dc1713','徐石柱','','','','','223.102.70.218','','13904118628',NULL,NULL),(94,2,0,0,1597164591,0,0,0.00,1597164591,1,'孟繁秋','###0eff01ca979fc496dd8a009b47dc1713','孟繁秋','','','','','27.200.209.33','','18905480527',NULL,NULL),(95,2,0,0,1597330385,0,0,0.00,1597330385,1,'宫浩','###0eff01ca979fc496dd8a009b47dc1713','宫浩','','','','','114.242.250.119','','18611117721',NULL,NULL),(96,2,0,0,1597418413,0,0,0.00,1597418413,1,'魏子鹏','###0eff01ca979fc496dd8a009b47dc1713','Cat owners','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Epwiahv5YO1XROtmuSy5K67IEbEeLp6iafCUspnBxhSqTdtcVFrficV3fe5QeFaIWVu0NW3BUic0R5EJJRtvfcwMyg/132','','153.36.126.169','','15501444441','oDjx9tx_2cfyxUv78Np0VyFqjAII',NULL),(97,2,0,0,1597854956,0,0,0.00,1597854956,1,'孙玮泽','###0eff01ca979fc496dd8a009b47dc1713','孙玮泽','','','','','106.58.192.41','','13170736739',NULL,NULL),(98,2,0,0,1597928070,0,0,0.00,1597928070,1,'李欣笛','###0eff01ca979fc496dd8a009b47dc1713','李欣笛','','','','','123.119.46.167','','18611631358',NULL,NULL),(99,2,0,0,1598251163,0,0,0.00,1598251163,1,'王海瑞','###0eff01ca979fc496dd8a009b47dc1713','王海瑞','','','','','112.99.85.85','','18545361907',NULL,NULL),(100,2,0,0,1598251282,0,0,0.00,1598251282,1,'宋云鹤','###0eff01ca979fc496dd8a009b47dc1713','宋云鹤','','','','','223.104.17.234','','18814701277',NULL,NULL),(101,2,0,0,1598262756,0,0,0.00,1598262756,1,'贾婷','###0eff01ca979fc496dd8a009b47dc1713','贾婷','','','','','114.245.108.118','','15901088096',NULL,NULL),(102,2,0,0,1598620345,0,0,0.00,1598620345,1,'陈晨','###0eff01ca979fc496dd8a009b47dc1713','陈晨','','','','','119.123.227.184','','13813907456',NULL,NULL),(103,2,0,0,1598748415,1,1,0.00,1598687977,1,'单雪梅','###0eff01ca979fc496dd8a009b47dc1713','单雪梅','','','','','120.6.181.111','','13930322366',NULL,NULL),(104,2,0,0,1598835525,0,0,0.00,1598835525,1,'周柳利','###0eff01ca979fc496dd8a009b47dc1713','周柳利','','','','','101.244.164.150','','13816699732',NULL,NULL),(105,2,0,0,1598924008,0,0,0.00,1598924008,1,'admin','###0eff01ca979fc496dd8a009b47dc1713','admin','','','','','125.34.1.39','','13555863328',NULL,NULL),(106,2,0,0,1599050681,0,0,0.00,1599050681,1,'luoheng','###0eff01ca979fc496dd8a009b47dc1713','luoheng','','','','','222.240.120.94','','15364030010',NULL,NULL),(107,2,0,0,1599058441,0,0,0.00,1599058441,1,'潘媛媛','###0eff01ca979fc496dd8a009b47dc1713','潘媛媛','','','','','111.121.41.55','','17785818126',NULL,NULL),(108,2,0,0,1599061323,0,0,0.00,1599061323,1,'马海佳','###0eff01ca979fc496dd8a009b47dc1713','马海佳','','','','','49.223.37.185','','18718442904',NULL,NULL),(109,2,0,0,1599099663,0,0,0.00,1599099663,1,'juxiong','###0eff01ca979fc496dd8a009b47dc1713','juxiong','','','','','112.97.59.209','','13798572003',NULL,NULL),(110,2,0,0,1599161382,0,0,0.00,1599161382,1,'张诺','###0eff01ca979fc496dd8a009b47dc1713','张诺','','','','','221.197.133.27','','15320049123',NULL,NULL),(111,2,0,0,1599271408,0,0,0.00,1599271408,1,'ZHANG KAI','###0eff01ca979fc496dd8a009b47dc1713','ZHANG KAI','','','','','220.112.231.113','','18702165574',NULL,NULL),(112,2,0,0,1599357112,0,0,0.00,1599357112,1,'luxiaoming','###0eff01ca979fc496dd8a009b47dc1713','luxiaoming','','','','','113.71.40.177','','13928286295',NULL,NULL),(113,2,0,0,1599470186,0,0,0.00,1599470186,1,'黄思雨','###0eff01ca979fc496dd8a009b47dc1713','黄思雨','','','','','140.207.90.173','','17851303133',NULL,NULL),(114,2,0,0,1599471827,0,0,0.00,1599471827,1,'Lysyuk Tatiana','###0eff01ca979fc496dd8a009b47dc1713','Lysyuk Tatiana','','','','','117.100.207.16','','13241945559',NULL,NULL),(115,2,0,0,1599480878,0,0,0.00,1599480878,1,'阿猫','###0eff01ca979fc496dd8a009b47dc1713','阿猫','','','','','220.202.152.35','','15574850499',NULL,NULL),(116,2,0,0,1605374900,2,2,0.00,1599538540,1,'王婧','###0eff01ca979fc496dd8a009b47dc1713','王婧','','','http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLnmek320F6AEH6Y1k2WLibTY6pZgqbmiafkX8miaGKtmzfw2Vul50xbXIRWmxgS1xZ1pF9Xeyjz2kbQ/132','','114.222.58.185','','18652982090','oDjx9t3nTuFEuyaFwsE7Y7HVb8YM',NULL),(117,2,0,0,1599565332,0,0,0.00,1599565332,1,'yangjinmeng','###0eff01ca979fc496dd8a009b47dc1713','yangjinmeng','','','','','61.140.95.190','','15626462092',NULL,NULL),(118,2,0,0,1599708184,0,0,0.00,1599708184,1,'刘德玺','###0eff01ca979fc496dd8a009b47dc1713','吖','','','http://thirdwx.qlogo.cn/mmopen/vi_32/0YicmPnd4EzLVa4HtPh2qiaAzcOJlv585gLhicZfVyzCx2FrAzkJZYotOlicpKYCvogA7hn8htrHIDZXnbwViaBlia8Q/132','','113.70.100.41','','15876762912','oDjx9t17F5FMoidmgIb31t8ReoEA',NULL),(119,2,0,0,1599902851,0,0,0.00,1599902851,1,'zoasdj1','###0eff01ca979fc496dd8a009b47dc1713','zoasdj1','','','','','112.30.101.12','','18324710449',NULL,NULL),(120,2,0,0,1599909009,0,0,0.00,1599909009,1,'屈锦康','###0eff01ca979fc496dd8a009b47dc1713','屈锦康','','','','','120.235.185.46','','13826497874',NULL,NULL),(121,2,0,0,1600055995,0,0,0.00,1600055995,1,'周俊','###0eff01ca979fc496dd8a009b47dc1713','周俊','','','','','210.22.83.142','','15021107442',NULL,NULL),(122,2,0,0,1600148242,0,0,0.00,1600148242,1,'文','###0eff01ca979fc496dd8a009b47dc1713','文','','','','','14.16.81.141','','18926828031',NULL,NULL),(123,2,0,0,1600318889,0,0,0.00,1600318889,1,'王琳','###0eff01ca979fc496dd8a009b47dc1713','王琳','','','','','223.104.3.203','','18744023588',NULL,NULL),(124,2,0,0,1600407443,0,0,0.00,1600407443,1,'饶天轶','###0eff01ca979fc496dd8a009b47dc1713','饶天轶','','','','','182.147.38.5','','18283333959',NULL,NULL),(125,2,0,0,1600537142,0,0,0.00,1600537142,1,'林正佳','###0eff01ca979fc496dd8a009b47dc1713','林正佳','','','','','183.253.28.176','','18206056697',NULL,NULL),(126,2,0,0,1600565100,0,0,0.00,1600565100,1,'焉栩嘉','###0eff01ca979fc496dd8a009b47dc1713','焉栩嘉','','','','','117.136.38.144','','18806668669',NULL,NULL),(127,2,0,0,1600635610,0,0,0.00,1600635610,1,'郝健程','###0eff01ca979fc496dd8a009b47dc1713','郝健程','','','','','112.224.20.172','','15668061571',NULL,NULL),(128,2,0,0,1600832235,0,0,0.00,1600832235,1,'姚佳其','###0eff01ca979fc496dd8a009b47dc1713','姚佳其','','','','','60.10.205.130','','15383868165',NULL,NULL),(129,2,0,0,1600847957,0,0,0.00,1600847957,1,'董萍','###0eff01ca979fc496dd8a009b47dc1713','董萍','','','','','125.33.65.193','','18610301515',NULL,NULL),(130,2,0,0,1601001006,0,0,0.00,1601001006,1,'叶啟豪','###0eff01ca979fc496dd8a009b47dc1713','叶啟豪','','','','','119.123.70.35','','13528708862',NULL,NULL),(131,2,0,0,1601183755,0,0,0.00,1601183755,1,'tsai','###0eff01ca979fc496dd8a009b47dc1713','Cai','','','https://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eo3vSDJSZm0bcZromntFaCQj3yFO8WY8SyV1c4uMOZw0A6sDPMQNn2hQU7vj4cw60fZTnOjzMQsPQ/132','','120.231.182.121','','18520230881','oDjx9txDShZ-nJnluNurREjidBZA',NULL),(132,2,0,0,1601783168,0,0,0.00,1601783168,1,'wcf','###0eff01ca979fc496dd8a009b47dc1713','wcf','','','https://thirdwx.qlogo.cn/mmopen/vi_32/prLO6VIcvsULBia2yyIkkaO7BDQHicpBBP7wMqNiaTqUT1CYiaALibNLD3C9czsgECdQ2hHCicDiaJx5K5gNiaicgRKZrKA/132','','223.104.236.202','','13324130180','oDjx9t6S_RL6ZzELJ1AP_nP2sSPg',NULL),(133,2,0,0,1601952449,0,0,0.00,1601952449,1,'戴衍辰','###0eff01ca979fc496dd8a009b47dc1713','戴衍辰','','','','','27.154.113.56','','18707923880',NULL,NULL),(134,2,0,0,1601962705,1,1,0.00,1601956732,1,'张丽霞','###0eff01ca979fc496dd8a009b47dc1713','A 希','','','https://thirdwx.qlogo.cn/mmopen/vi_32/PiajxSqBRaELnTrcr7z41byy9G1h2Bfuee1ict01MriaH4jKEoXCPZjA0QlHrOoCE8RqsOFlkXLHJYGqWT4uXom7Q/132','','49.72.196.22','','18651009668','oDjx9t63a4L967RRxt6c8BFE08Zg',NULL),(135,2,0,0,1602052492,0,0,0.00,1602052492,1,'李博智','###0eff01ca979fc496dd8a009b47dc1713','李博智','','','','','111.192.70.95','','15210258722',NULL,NULL),(136,2,0,0,1602074258,0,0,0.00,1602074258,1,'潘麒龙','###0eff01ca979fc496dd8a009b47dc1713','潘麒龙','','','','','183.11.203.40','','13977074473',NULL,NULL),(137,2,0,0,1602125676,0,0,0.00,1602125676,1,'肖滔','###0eff01ca979fc496dd8a009b47dc1713','肖滔','','','','','118.115.40.34','','18181754232',NULL,NULL),(138,2,0,0,1602173227,0,0,0.00,1602173227,1,'才冠华','###0eff01ca979fc496dd8a009b47dc1713','才冠华','','','','','123.244.131.91','','18525705151',NULL,NULL),(139,2,0,0,1602205090,0,0,0.00,1602205090,1,'董贺喜','###0eff01ca979fc496dd8a009b47dc1713','董贺喜','','','','','223.104.236.225','','15841051226',NULL,NULL),(140,2,0,0,1602231089,0,0,0.00,1602231089,1,'123','###0eff01ca979fc496dd8a009b47dc1713','123','','','','','114.249.114.115','','18401245625',NULL,NULL),(141,2,0,0,1602306529,0,0,0.00,1602306529,1,'张翰文','###0eff01ca979fc496dd8a009b47dc1713','张翰文','','','','','106.47.76.71','','16600248806',NULL,NULL),(142,2,0,0,1602320576,0,0,0.00,1602320576,1,'王宇鑫','###0eff01ca979fc496dd8a009b47dc1713','王宇鑫','','','','','223.104.57.32','','18794212474',NULL,NULL),(143,2,0,0,1602469707,0,0,0.00,1602469707,1,'付德重','###0eff01ca979fc496dd8a009b47dc1713','付德重','','','','','106.116.69.81','','15128862393',NULL,NULL),(144,2,0,0,1602480061,0,0,0.00,1602480061,1,'申惠惠','###0eff01ca979fc496dd8a009b47dc1713','申惠惠','','','','','1.82.102.87','','15353868484',NULL,NULL),(145,2,0,0,1602571973,0,0,0.00,1602571973,1,'李桑','###0eff01ca979fc496dd8a009b47dc1713','李桑','','','','','220.191.217.9','','15557299269',NULL,NULL),(146,2,0,0,1602604300,0,0,0.00,1602604300,1,'马荣华','###0eff01ca979fc496dd8a009b47dc1713','马荣华','','','','','36.43.85.219','','18966608321',NULL,NULL),(147,2,0,0,1602649451,0,0,0.00,1602649451,1,'李莉','###0eff01ca979fc496dd8a009b47dc1713','李莉','','','','','58.210.140.219','','15850270504',NULL,NULL),(148,2,0,0,1602829387,0,0,0.00,1602829387,1,'宣西','###0eff01ca979fc496dd8a009b47dc1713','宣西','','','','','58.240.80.234','','17551062046',NULL,NULL),(149,2,0,0,1602857184,0,0,0.00,1602857184,1,'郑乾勇','###0eff01ca979fc496dd8a009b47dc1713','郑乾勇','','','','','183.193.51.172','','17765148087',NULL,NULL),(150,2,0,0,1602917052,0,0,0.00,1602917052,1,'袁彩云','###0eff01ca979fc496dd8a009b47dc1713','袁彩云','','','','','120.43.73.108','','15255540807',NULL,NULL),(151,2,0,0,1603066515,0,0,0.00,1603066515,1,'刘晓倩','###0eff01ca979fc496dd8a009b47dc1713','刘晓倩','','','','','223.104.110.33','','15993381517',NULL,NULL),(152,2,0,0,1603188268,0,0,0.00,1603188268,1,'陈世赓','###0eff01ca979fc496dd8a009b47dc1713','陈世赓','','','','','116.232.96.29','','19916931951',NULL,NULL),(153,2,0,0,1603338113,0,0,0.00,1603338113,1,'周栋斌','###0eff01ca979fc496dd8a009b47dc1713','周栋斌','','','','','180.175.26.47','','13917141189',NULL,NULL),(154,2,0,0,1603342440,0,0,0.00,1603342440,1,'原木','###0eff01ca979fc496dd8a009b47dc1713','原木','','','','','120.208.126.43','','15525124643',NULL,NULL),(155,2,0,0,1603463417,0,0,0.00,1603463417,1,'谭心雨','###0eff01ca979fc496dd8a009b47dc1713','谭心雨','','','','','113.115.42.159','','18144892567',NULL,NULL),(156,2,0,0,1603482600,0,0,0.00,1603482600,1,'王江华','###0eff01ca979fc496dd8a009b47dc1713','王江华','','','','','113.16.67.243','','18154557246',NULL,NULL),(157,2,0,0,1603543641,0,0,0.00,1603543641,1,'杨烁','###0eff01ca979fc496dd8a009b47dc1713','杨烁','','','','','114.252.229.245','','13269285431',NULL,NULL),(158,2,0,0,1603640079,0,0,0.00,1603640079,1,'Mufan Geng','###0eff01ca979fc496dd8a009b47dc1713','Mufan Geng','','','','','114.242.248.216','','17611658621',NULL,NULL),(159,2,0,0,1603776971,0,0,0.00,1603776971,1,'刘智超','###0eff01ca979fc496dd8a009b47dc1713','刘智超','','','','','221.203.113.110','','15041469808',NULL,NULL),(160,2,0,0,1603873019,0,0,0.00,1603873019,1,'冯超','###0eff01ca979fc496dd8a009b47dc1713','冯超','','','','','140.243.226.86','','13599514420',NULL,NULL),(161,2,0,0,1604334216,0,0,0.00,1604334216,1,'王旺','###0eff01ca979fc496dd8a009b47dc1713','王旺','','','','','183.221.40.135','','15183842870',NULL,NULL),(162,2,0,0,1604415767,2,2,0.00,1604368377,1,'刘学泰','###0eff01ca979fc496dd8a009b47dc1713','煮酒论诗(Thales)','','','https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLxpyP19LpuePannSITyibvJVZs8iaM9xOQwJvMcgdmpsTn4VrnuicZ1IKqXyL4F0d4giaDrqCkVJ6TEg/132','','223.246.45.150','','18055519088','oDjx9tw5-hUZfK-MLq4C1guzeUEs',NULL),(163,2,0,0,1604381820,0,0,0.00,1604381820,1,'李艺秋','###0eff01ca979fc496dd8a009b47dc1713','李艺秋','','','','','59.174.73.89','','15271808707',NULL,NULL),(164,2,0,0,1604487093,0,0,0.00,1604487093,1,'马岚','###0eff01ca979fc496dd8a009b47dc1713','马岚','','','','','123.130.58.104','','15653588891',NULL,NULL),(165,2,0,0,1604509907,0,0,0.00,1604509907,1,'曹羽毛','###0eff01ca979fc496dd8a009b47dc1713','Leo','','','https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTL9gpo1ndljNFTx7ewwnkkRT5k2SSH0WGOG0JZJWjIy40ZBoC2NTSSsib7k44torFxdMtTGFIiaUEBw/132','','101.72.40.222','','15133687762','oDjx9t-ZX3oD5oDWMW4yB0Uvmx8Q',NULL),(166,2,0,0,1604556856,0,0,0.00,1604556856,1,'李文冰','###0eff01ca979fc496dd8a009b47dc1713','李文冰','','','','','115.183.10.22','','13520167333',NULL,NULL),(167,2,0,0,1604588328,0,0,0.00,1604588328,1,'沈上','###0eff01ca979fc496dd8a009b47dc1713','沈上','','','','','112.224.67.167','','16653232619',NULL,NULL),(168,2,0,0,1604813322,3,3,0.00,1604749137,1,'陈鸿飞','###0eff01ca979fc496dd8a009b47dc1713','陈鸿飞','','','','','171.93.188.101','','18328607787',NULL,NULL),(169,2,0,0,1604830310,0,0,0.00,1604830310,1,'王婷','###0eff01ca979fc496dd8a009b47dc1713','王婷','','','','','110.81.29.167','','18965186565',NULL,NULL),(170,2,0,0,1604859472,0,0,0.00,1604859472,1,'刘艳江','###0eff01ca979fc496dd8a009b47dc1713','刘艳江','','','','','111.197.241.77','','17777787274',NULL,NULL),(171,2,0,0,1604898219,0,0,0.00,1604898219,1,'赵丽梅','###0eff01ca979fc496dd8a009b47dc1713','赵丽梅','','','','','61.51.150.75','','18600360839',NULL,NULL),(172,2,0,0,1604972665,0,0,0.00,1604972665,1,'杨依霖','###0eff01ca979fc496dd8a009b47dc1713','杨依霖','','','','','117.136.0.163','','15811347914',NULL,NULL),(173,2,0,0,1605111963,0,0,0.00,1605111963,1,'莫池','###0eff01ca979fc496dd8a009b47dc1713','莫池','','','','','223.104.10.105','','18370114979',NULL,NULL),(174,2,0,0,1605253395,0,0,0.00,1605253395,1,'王化川','###0eff01ca979fc496dd8a009b47dc1713','王化川','','','','','123.145.120.7','','18523501420',NULL,NULL),(175,2,0,0,1605463991,0,0,0.00,1605463991,1,'黄海峰','###0eff01ca979fc496dd8a009b47dc1713','黄海峰','','','','','121.35.185.30','','18665369117',NULL,NULL),(176,2,0,0,1605584565,0,0,0.00,1605584565,1,'李莉莉','###0eff01ca979fc496dd8a009b47dc1713','李莉莉','','','','','58.35.13.101','','15521108628',NULL,NULL),(177,2,0,0,1605693649,0,0,0.00,1605693649,1,'符梦婷','###0eff01ca979fc496dd8a009b47dc1713','符梦婷','','','','','117.136.63.112','','18725636109',NULL,NULL),(178,2,0,0,1606209386,1,1,0.00,1605926459,1,'大向天诚','###0eff01ca979fc496dd8a009b47dc1713','大向天诚','','','https://thirdwx.qlogo.cn/mmopen/vi_32/PW6uQz01qEENHxElCPWUGwlp6gWGwBF4u79J8FGtgSBKpfPfg8AibEttjPx3EZ86BnZoRukTxgxdWlibxjn4mGvQ/132','','182.150.133.97','','17761200649','oDjx9t-63mO5hbm-vwVG_wEt4evA',NULL),(179,2,0,0,1606028150,1,1,0.00,1605963716,1,'赵露','###0eff01ca979fc496dd8a009b47dc1713','好好。','','','https://thirdwx.qlogo.cn/mmopen/vi_32/ajNVdqHZLLCFnh5FIxfib7wgLHKgyXKg5q1T0b0PfRnTm0Y4aGDQ0JeibvEaqia0MgxnBic9zXYRzCm1QPUicMEJpiaw/132','','223.104.165.141','','18329120308','oDjx9t8zMNmhukE1Oaq5EM1QLT_Q',NULL),(180,2,0,0,1606039601,0,0,0.00,1606039601,1,'关笑','###0eff01ca979fc496dd8a009b47dc1713','关笑','','','','','113.58.138.106','','13215878810',NULL,NULL),(181,2,0,0,1606103165,0,0,0.00,1606103165,1,'翁力栋','###0eff01ca979fc496dd8a009b47dc1713','灰色回忆','','','https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKQbRAv4V7K2F9owZvibkFodJDPsLmVfzdJ5oRiaU9DkEUhXvpbVPvdkNGHPvMkxbh1hj5lobO0PMIQ/132','','36.23.122.2','','18969901816','oDjx9t3wc3-vJ7M7_BuK7s5YKFM4',NULL),(182,2,0,0,1606195687,0,0,0.00,1606195687,1,'冉鹏','###0eff01ca979fc496dd8a009b47dc1713','冉鹏','','','','','223.104.250.188','','19823505400',NULL,NULL),(183,2,0,0,1606210390,0,0,0.00,1606210390,1,'Ian','###0eff01ca979fc496dd8a009b47dc1713','Ian','','','','','182.150.133.97','','13541194069',NULL,NULL); /*!40000 ALTER TABLE `cmf_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user_action` -- DROP TABLE IF EXISTS `cmf_user_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user_action` ( `id` int(11) NOT NULL AUTO_INCREMENT, `score` int(11) NOT NULL DEFAULT '0' COMMENT '更改积分,可以为负', `coin` int(11) NOT NULL DEFAULT '0' COMMENT '更改金币,可以为负', `reward_number` int(11) NOT NULL DEFAULT '0' COMMENT '奖励次数', `cycle_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '周期类型;0:不限;1:按天;2:按小时;3:永久', `cycle_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '周期时间值', `name` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称', `action` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称', `app` varchar(50) NOT NULL DEFAULT '' COMMENT '操作所在应用名或插件名等', `url` text COMMENT '执行操作的url', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户操作表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user_action` -- LOCK TABLES `cmf_user_action` WRITE; /*!40000 ALTER TABLE `cmf_user_action` DISABLE KEYS */; INSERT INTO `cmf_user_action` VALUES (1,1,1,1,2,1,'用户登录','login','user',''); /*!40000 ALTER TABLE `cmf_user_action` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user_action_log` -- DROP TABLE IF EXISTS `cmf_user_action_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user_action_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id', `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数', `last_visit_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后访问时间', `object` varchar(100) NOT NULL DEFAULT '' COMMENT '访问对象的id,格式:不带前缀的表名+id;如posts1表示xx_posts表里id为1的记录', `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作名称;格式:应用名+控制器+操作名,也可自己定义格式只要不发生冲突且惟一;', `ip` varchar(15) NOT NULL DEFAULT '' COMMENT '用户ip', PRIMARY KEY (`id`), KEY `user_object_action` (`user_id`,`object`,`action`), KEY `user_object_action_ip` (`user_id`,`object`,`action`,`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='访问记录表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user_action_log` -- LOCK TABLES `cmf_user_action_log` WRITE; /*!40000 ALTER TABLE `cmf_user_action_log` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_user_action_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user_balance_log` -- DROP TABLE IF EXISTS `cmf_user_balance_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user_balance_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户 id', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `change` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '更改余额', `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '更改后余额', `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述', `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户余额变更日志表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user_balance_log` -- LOCK TABLES `cmf_user_balance_log` WRITE; /*!40000 ALTER TABLE `cmf_user_balance_log` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_user_balance_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user_favorite` -- DROP TABLE IF EXISTS `cmf_user_favorite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user_favorite` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户 id', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '收藏内容的标题', `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图', `url` varchar(255) DEFAULT NULL COMMENT '收藏内容的原文地址,JSON格式', `description` text COMMENT '收藏内容的描述', `table_name` varchar(64) NOT NULL DEFAULT '' COMMENT '收藏实体以前所在表,不带前缀', `object_id` int(10) unsigned DEFAULT '0' COMMENT '收藏内容原来的主键id', `create_time` int(10) unsigned DEFAULT '0' COMMENT '收藏时间', PRIMARY KEY (`id`), KEY `uid` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户收藏表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user_favorite` -- LOCK TABLES `cmf_user_favorite` WRITE; /*!40000 ALTER TABLE `cmf_user_favorite` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_user_favorite` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user_like` -- DROP TABLE IF EXISTS `cmf_user_like`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user_like` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户 id', `object_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容原来的主键id', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `table_name` varchar(64) NOT NULL DEFAULT '' COMMENT '内容以前所在表,不带前缀', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '内容的原文地址,不带域名', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '内容的标题', `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图', `description` text COMMENT '内容的描述', PRIMARY KEY (`id`), KEY `uid` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户点赞表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user_like` -- LOCK TABLES `cmf_user_like` WRITE; /*!40000 ALTER TABLE `cmf_user_like` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_user_like` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user_login_attempt` -- DROP TABLE IF EXISTS `cmf_user_login_attempt`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user_login_attempt` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `login_attempts` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '尝试次数', `attempt_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '尝试登录时间', `locked_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '锁定时间', `ip` varchar(15) NOT NULL DEFAULT '' COMMENT '用户 ip', `account` varchar(100) NOT NULL DEFAULT '' COMMENT '用户账号,手机号,邮箱或用户名', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户登录尝试表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user_login_attempt` -- LOCK TABLES `cmf_user_login_attempt` WRITE; /*!40000 ALTER TABLE `cmf_user_login_attempt` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_user_login_attempt` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user_score_log` -- DROP TABLE IF EXISTS `cmf_user_score_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user_score_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户 id', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `action` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称', `score` int(11) NOT NULL DEFAULT '0' COMMENT '更改积分,可以为负', `coin` int(11) NOT NULL DEFAULT '0' COMMENT '更改金币,可以为负', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8 COMMENT='用户操作积分等奖励日志表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user_score_log` -- LOCK TABLES `cmf_user_score_log` WRITE; /*!40000 ALTER TABLE `cmf_user_score_log` DISABLE KEYS */; INSERT INTO `cmf_user_score_log` VALUES (1,2,1578120193,'login',1,1),(2,2,1578271873,'login',1,1),(3,2,1578277676,'login',1,1),(4,2,1578359046,'login',1,1),(5,2,1578366654,'login',1,1),(6,5,1578546526,'login',1,1),(7,8,1578552932,'login',1,1),(8,8,1578557632,'login',1,1),(9,8,1578563190,'login',1,1),(10,8,1578618810,'login',1,1),(11,8,1578641630,'login',1,1),(12,9,1578648883,'login',1,1),(13,10,1578671984,'login',1,1),(14,8,1578704883,'login',1,1),(15,10,1578708603,'login',1,1),(16,10,1578735958,'login',1,1),(17,10,1578751917,'login',1,1),(18,8,1578791520,'login',1,1),(19,8,1578796189,'login',1,1),(20,10,1578800522,'login',1,1),(21,10,1578816228,'login',1,1),(22,10,1578974172,'login',1,1),(23,10,1579035393,'login',1,1),(24,8,1579137656,'login',1,1),(25,8,1579224563,'login',1,1),(26,8,1579230377,'login',1,1),(27,8,1579312574,'login',1,1),(28,9,1579320465,'login',1,1),(29,12,1579326098,'login',1,1),(30,10,1579333840,'login',1,1),(31,10,1579366073,'login',1,1),(32,10,1579409574,'login',1,1),(33,10,1580199876,'login',1,1),(34,8,1580518246,'login',1,1),(35,8,1580522710,'login',1,1),(36,8,1580527221,'login',1,1),(37,10,1580545669,'login',1,1),(38,8,1580605943,'login',1,1),(39,8,1580635383,'login',1,1),(40,8,1580690717,'login',1,1),(41,8,1580697481,'login',1,1),(42,14,1580701141,'login',1,1),(43,16,1580713726,'login',1,1),(44,16,1580719073,'login',1,1),(45,16,1580724407,'login',1,1),(46,14,1581053470,'login',1,1),(47,16,1581067084,'login',1,1),(48,14,1581123766,'login',1,1),(49,15,1581132665,'login',1,1),(50,21,1581218513,'login',1,1),(51,16,1581424567,'login',1,1),(52,22,1581486298,'login',1,1),(53,14,1581573212,'login',1,1),(54,25,1581641659,'login',1,1),(55,25,1581727841,'login',1,1),(56,23,1581752528,'login',1,1),(57,23,1581757316,'login',1,1),(58,25,1581899288,'login',1,1),(59,25,1582073838,'login',1,1),(60,28,1582079877,'login',1,1),(61,28,1582247051,'login',1,1),(62,31,1582472351,'login',1,1),(63,29,1582602696,'login',1,1),(64,32,1582639867,'login',1,1),(65,32,1582644775,'login',1,1),(66,29,1582678269,'login',1,1),(67,32,1582771174,'login',1,1),(68,32,1582786186,'login',1,1),(69,29,1582793203,'login',1,1),(70,33,1582797842,'login',1,1),(71,32,1582811770,'login',1,1),(72,35,1582864914,'login',1,1),(73,35,1582882281,'login',1,1),(74,31,1582895096,'login',1,1),(75,31,1582899285,'login',1,1),(76,34,1582945596,'login',1,1),(77,31,1582953590,'login',1,1),(78,34,1582959264,'login',1,1),(79,32,1582971154,'login',1,1),(80,32,1582975006,'login',1,1),(81,37,1583249446,'login',1,1),(82,37,1583256807,'login',1,1),(83,37,1583291560,'login',1,1),(84,37,1583470590,'login',1,1),(85,37,1584936669,'login',1,1),(86,50,1584978403,'login',1,1),(87,38,1585001293,'login',1,1),(88,46,1585016041,'login',1,1),(89,37,1585024926,'login',1,1),(90,42,1585131051,'login',1,1),(91,50,1585138466,'login',1,1),(92,37,1585150720,'login',1,1),(93,50,1585208893,'login',1,1),(94,55,1585915578,'login',1,1),(95,42,1586013263,'login',1,1),(96,37,1586185435,'login',1,1),(97,37,1586746370,'login',1,1),(98,46,1587203489,'login',1,1),(99,37,1587367751,'login',1,1),(100,59,1588130694,'login',1,1),(101,59,1588137512,'login',1,1),(102,37,1589714472,'login',1,1),(103,60,1590132350,'login',1,1),(104,37,1590721571,'login',1,1),(105,63,1591194932,'login',1,1),(106,37,1592546042,'login',1,1),(107,68,1593256093,'login',1,1),(108,45,1594746082,'login',1,1),(109,80,1595050508,'login',1,1),(110,37,1595694341,'login',1,1),(111,46,1596166475,'login',1,1),(112,46,1596530179,'login',1,1),(113,93,1596631402,'login',1,1),(114,103,1598748415,'login',1,1),(115,116,1599544654,'login',1,1),(116,85,1601644542,'login',1,1),(117,134,1601962705,'login',1,1),(118,37,1602008895,'login',1,1),(119,162,1604370121,'login',1,1),(120,37,1604404133,'login',1,1),(121,162,1604415767,'login',1,1),(122,168,1604795673,'login',1,1),(123,168,1604808221,'login',1,1),(124,168,1604813322,'login',1,1),(125,116,1605374900,'login',1,1),(126,37,1605926232,'login',1,1),(127,37,1605978065,'login',1,1),(128,179,1606028150,'login',1,1),(129,178,1606198606,'login',1,1),(130,37,1606209367,'login',1,1); /*!40000 ALTER TABLE `cmf_user_score_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_user_token` -- DROP TABLE IF EXISTS `cmf_user_token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_user_token` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id', `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT ' 过期时间', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `token` varchar(64) NOT NULL DEFAULT '' COMMENT 'token', `device_type` varchar(10) NOT NULL DEFAULT '' COMMENT '设备类型;mobile,android,iphone,ipad,web,pc,mac,wxapp', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8 COMMENT='用户客户端登录 token 表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_user_token` -- LOCK TABLES `cmf_user_token` WRITE; /*!40000 ALTER TABLE `cmf_user_token` DISABLE KEYS */; INSERT INTO `cmf_user_token` VALUES (1,1,1609768661,1594216661,'6849cde9f85d1cf8e1a5ec51f85ea91877c6fce132b1ab1c2d83d4568c550834','web'),(2,2,1593672193,1578120193,'9d4bd489a865434ad400fc2e5c64b9d89d4bd489a865434ad400fc2e5c64b9d8','web'),(3,5,1594098458,1578546458,'ad1af3d4979cea3d1a48e6485e3a967ad58d5e3ba2497f7370d95164091ff6e3','web'),(4,6,1594098676,1578546676,'639b0b93c626aa96465a2060df4c0c93e9ab75130db7dfd67023f802ef64cd0e','web'),(5,7,1594098839,1578546839,'8e241bce8ab3bbafe7cf55ffb3764a229987f1ed527c5e2860fad3e7d3298367','web'),(6,8,1594098911,1578546911,'b97b17eab289aa03518db837db492885a33cbed985fe6991a837ab2598d9e0fc','web'),(7,9,1594109945,1578557945,'05be538b56dbf5950759f468a26eb49dc022b57c1140784ff763393d306d582d','web'),(8,10,1594202001,1578650001,'4194c4bea9576c38c93a4daab27b8ad98292db5a882e9fd12c955684ff11b0df','web'),(9,11,1594780519,1579228519,'fdc81a3f874fd3667b305369cda1d3704c64ee5b418278678b0443b4c6ba4cf6','web'),(10,12,1594872747,1579320747,'eb5f1d49b61d8242cd6173ed806690497c8f415d8b29d9c458795240f34fce80','web'),(11,13,1596088479,1580536479,'8708ce369cb89aec865b4b87cd3e6727cf9ab81f9879c057cd62067284955c83','web'),(12,14,1596251664,1580699664,'0d11da8bb4d60a14e6025015d6889750fd6a95f01a1e09dc9262d4b5886056be','web'),(13,15,1596260412,1580708412,'fa4f2aedd460230bf08fbb66d5daf17f0727a0d896373bd01283d7c5d85ba241','web'),(14,16,1596262237,1580710237,'fba4516ca45d43c8323b8b5bae71680a9771610c09a788c3efb1c8092e6ec7be','web'),(15,17,1596279930,1580727930,'2fbe16209de1c1138ff4f442989518c69d843a03281692e742013d162f2aac3c','web'),(16,18,1596676584,1581124584,'6930151aad72ae6a68938ffd317292574559e07e957f47d9209176379934c571','web'),(17,19,1596676774,1581124774,'c111dc10058959963c315a1961f79188bc3f68944158f71184d9d8012726b579','web'),(18,20,1596677621,1581125621,'1b7d52bf425349ac849cdbc05c05e22c023f77357f26ecf481e0c2e1a15da20d','web'),(19,21,1596679411,1581127411,'aeae3fdad1e88575fb802d11c4b04bc8a77837b609d0811fe88a602eca996173','web'),(20,22,1596978155,1581426155,'6652087a68362268eb9094321ea5ba07a9275c87eaa837d71ba12d19fc19a443','web'),(21,23,1597126526,1581574526,'d0225cea1c78893859e03f02a78a36bfbec8430be8fdcb59b2521909ec802442','web'),(22,24,1597193423,1581641423,'d3c7c4aea46909a9edf4ce1ffeed876cf2c1512435215d21319c9aa5be9bae49','web'),(23,25,1597193558,1581641558,'04aaa6be16cec5c84456803ca828bc97ca996da24c94f031fe581e8d21fbdf13','web'),(24,26,1597383086,1581831086,'34b649273fb176dfb2618ae5373b752d9a1396ca31f0f0db979af6283dac8ba0','web'),(25,27,1597627504,1582075504,'33962d3083b6eeccc7abb664784681a730af24016e035ac964222e260e90ece5','web'),(26,28,1597631720,1582079720,'dfe51b9f310dafbe70d3d1f3e8291926a54268987e06ecda2f963a2e83e1e32d','web'),(27,29,1597800167,1582248167,'c8ecd1c1c0d8aea3fa33b157df82a7b033a8584d73bdde0b80b4992d9bcc6646','web'),(28,30,1597800197,1582248197,'721a72bc0efc9e891ba226c13f0ae4128c8f85937eb41960e29feaa73e295a76','web'),(29,31,1598023121,1582471121,'fd6ac2c6b9da0a3e0bebcad4ecbedbf0247338176607c5489733350ce63791b6','web'),(30,32,1598024320,1582472320,'cfde1250e762d1ca22f19bb6d5aefe073829557ae9736abf95c21afb14770569','web'),(31,33,1598265844,1582713844,'ed92e5a6cb3330caf6f1ff88a233ab2e80409391f9a6a1b9e3b9c6556b38a99d','web'),(32,34,1598327056,1582775056,'215e31c6c63edd5b1b840aa1fd5b035bc9e63c4c9d7b4130f45586fe0bea9b2d','web'),(33,35,1598364211,1582812211,'4af409ecc8f831c08e9a5e0b6f4336a1bf3d460b438d5313934417c564bd76aa','web'),(34,36,1621761131,1606209131,'c6573e8c53cd016c1dedac76daf47bbba0b427d25a2684b40f359155a3fdcadd','web'),(35,37,1617560895,1602008895,'498c6338cae6a8ca7c913a15573a2571379dab887ae0dbd96fafae685bab4c78','web'),(36,38,1600489324,1584937324,'7665820280c1d09d6d93ef41f337a236d95f483c109d4c95a9a7c4c1fadb274b','web'),(37,39,1600489349,1584937349,'084189563de88120cf4aa27abcd503c5da05a79cbea0800f2369c2936b0ac6dc','web'),(38,40,1600489767,1584937767,'85014e18f6e4b72f08bdb7bb14b4ad7e6f8fa0d9b26cd669077321353bc188ac','web'),(39,41,1600489911,1584937911,'32027e8a6efb5f5a149fdbfe78f5e6211e3f1bea2ba349629b3c53f782e531ac','web'),(40,42,1600490001,1584938001,'bd1df69cc948f317f1a7f929de59cc91400e7cd25d6e8d90ac009daedabdb105','web'),(41,43,1600490154,1584938154,'bc8115eba696c2e5f8a4c6942e3dbb06f1ef3ba8eca3774fff3378578d78769e','web'),(42,44,1600490231,1584938231,'ab0d3b30241a2aedb16ef0f11b1f5c19bd3d682d075abeb77d58d192d863c56d','web'),(43,45,1600490634,1584938634,'514e298d09fda72bd05dafbdaa14dfbb816f5867f385cfe42a98c6ddd25d4f93','web'),(44,46,1600491692,1584939692,'5ccea9fdb13b163f0a68fccbd6763a1ed33833dbb8ebc3f9810609535f182429','web'),(45,47,1600493209,1584941209,'b5dd73a2d68755024ac09c80bfa4144455c80761eba4d50b120d9de67f9acba1','web'),(46,48,1600493826,1584941826,'d8c4f2a93f9b1fdbdc7614ec8b228809f1f2950a3538c34e629a69e487b1e50b','web'),(47,49,1600495052,1584943052,'a22d87eaf9646eb6357affca0b21c1969573de02a2fb3576a46bc500eed57089','web'),(48,50,1600508670,1584956670,'5f0cc0a5638697bb4e340bd013978c0c54024f64fcaef5ea672ab86b130135af','web'),(49,51,1600512326,1584960326,'51709ff5c535d279b918edc9ad869bb7e597d5e0378c73b4dceeb337d28aa318','web'),(50,52,1600516811,1584964811,'6f37c8bc2116fcbee56fe35ba6ff2be01f9708caa1588470c1ec5c22de95989c','web'),(51,53,1600585445,1585033445,'7007a6d1c9cd62db1df0aa1d0f14b6d2ab30ca2ef2198429ec07e4f874430978','web'),(52,54,1600656340,1585104340,'f13a56133da156ba05e1bad185673695d013840e7839b629f10491cc4a093053','web'),(53,55,1600689352,1585137352,'53180edcb03c525160605aa0740de199ddbcd6673d6ed13f68261eeee1177561','web'),(54,56,1601674330,1586122330,'7e957810dab6a93bad22fdc2a408fa4b201e6816f6bbea6b8db22f94aa27251e','web'),(55,57,1603260724,1587708724,'e535455f445dbebb1441ac493d5263941274355d7ce7dc3d0815312faa2a76c0','web'),(56,58,1603562214,1588010214,'3872496e2e900bc77d468e360bc5d8664004c94b24e98a02c73d0471866dcba0','web'),(57,59,1603681995,1588129995,'265cd7392774bc01ebf2e65d65fca0a5531f2d9a63a064106240f1d54cd4b4d6','web'),(58,60,1603786097,1588234097,'49c93d856eb3668e41feb66281f1b4f25f98240042dcec35e2b76e8c88169f08','web'),(59,61,1603786597,1588234597,'fee5c2ad43ce37e43d94fc9fac28becf7fc3196e1af94612fa942d9a97a373b4','web'),(60,62,1606572757,1591020757,'92db715cb54f8fe63238fd766ade89bae022db164180677d56e870e9152888b2','web'),(61,63,1606746514,1591194514,'7cc048740ec10b85304e56bcb28dfa1b34624e67bab3511fe2c4d1c478d91d35','web'),(62,64,1607495459,1591943459,'637b8abe0f2b1da456e74521458353cd55b5a7a546dfdbe902d509f11e2e54bc','web'),(63,65,1608445408,1592893408,'34599473204a0ce2f6e0571c8ae03668804e18610bb975df7b578fc01c0c67ff','web'),(64,66,1608621767,1593069767,'8ef9b2dd79c8a0220b539a78740e7e5ba4b6609a17f335ddc73c8cb6b2acc257','web'),(65,67,1608786204,1593234204,'23151391b9c715938112e4df71871d0651d2c9995088150503ece94b3ae4c500','web'),(66,68,1608807832,1593255832,'0312b0e48a086b09222381641df94512459babf7a3b6044ba25f175bbfbbb1c0','web'),(67,69,1609035770,1593483770,'2e245a24fbf3d288b9ca11cd22d199fc0440cb130fd4f864756b210d42b34c50','web'),(68,70,1609122442,1593570442,'d4e7dbc69d154ca012976665132da4e1f8e3898e75c8cbb41ddb8a16d1f23242','web'),(69,71,1609297476,1593745476,'9e9bf60b746403112567380777e40e34aec3febc325fed270243a606a9446979','web'),(70,72,1609311410,1593759410,'958c2076d0cf98858ef6f2ae140093422938b977922bc1d5de051157be6e8a1b','web'),(71,73,1609340676,1593788676,'a408ef98cb929e40b9cf8ad9f50888e5597e27b8ea2d57c550798f1c4c40fb13','web'),(72,74,1609547393,1593995393,'d92542e5f375b54896a5eff8eb0035bb94cf977d7015073e067a8f05802ec481','web'),(73,75,1609739058,1594187058,'db3547b517d85b7ab7de9be377feec6c0b3d4351fdfe168b70e84258274bcbe9','web'),(74,76,1609916018,1594364018,'9e460be289268228b8922b7bf596b6b94bb4420470da94cddcc6c979413c5801','web'),(75,77,1609925250,1594373250,'bc51b846c562d27b6bc4a5dd3799fc66b3d43ab6c25f96c5a73f63d8368fa33a','web'),(76,78,1610172056,1594620056,'39670e1a56642735ba5b02487e6a8eeb0f85d5619c0e497663fc655764f4732d','web'),(77,79,1610479938,1594927938,'50f6c3c8e0c9f84b317811ccb8a65e48669ae9167d1a586fed0d92686aa3061e','web'),(78,80,1610602071,1595050071,'f1974b7ea8021d4de9abadd94013bb1db1e67ccf445fa5c4e63ad5f74ae45222','web'),(79,81,1610721959,1595169959,'ee5daf59773dec17a660ffd4c807366b4128a3c37d7f4fc70c70baf72977c229','web'),(80,82,1610863787,1595311787,'c92b96a6f52fc820a5aae4242dea6162d75e1086ed517fed2e2368904fdf5491','web'),(81,83,1611187390,1595635390,'aa219edd25abc15dc301cdaa4dc916b3bd13bddd4769f88ce9a83db42b74f510','web'),(82,84,1611277819,1595725819,'4e84bd4ce1fd90f4a3edeab6a232b3e3e356e117131e653b814db3878a048210','web'),(83,85,1611295127,1595743127,'8add3f84f1bc7accd66e707d45dbe69100c7697553d89f10412c12b724d124d9','web'),(84,86,1611375254,1595823254,'31aca40026b885397664b9d5d872cd40fd0446820e0305e266d87b72cf09fecb','web'),(85,87,1611393397,1595841397,'bbb61126629ca6336e553204f00e6d427013070a135270a132d3c6510236e399','web'),(86,88,1611801837,1596249837,'3c504457b136830300277416c023778cda2f1bdccd584f651c45fb1f62cd8246','web'),(87,89,1611925281,1596373281,'eee95f8e51d611d9785f17fb067ccd40ac36121dfa9749cc8f34811f4e74eebb','web'),(88,90,1611929357,1596377357,'eb0e8dc7fcd29c371ab96155f57db1246ae1906a4f7a0d24298a449ed69740b2','web'),(89,91,1612018667,1596466667,'97e956fbdb8a525cf4fb09a1abe550f440386b3b841c31cfc6bd6f598ebaa2ad','web'),(90,92,1612083790,1596531790,'9887cfb58f249f8c8a6f19f77fce02ef5faebf4f3e409dcb17bf44b5cc9eb3df','web'),(91,93,1612183231,1596631231,'7526c0fcca81dcbaacb1ab6349be3fdccf3163cbefa96343f57c0e75a4db5f8f','web'),(92,94,1612716591,1597164591,'bde4b2437966eef329c50a37c939b71f14ebb086acb03391413a2dffe45e28c9','web'),(93,95,1612882385,1597330385,'f69c8f3e259901b537db213f960b74687cbd811394e1377054eedfa14b6e543b','web'),(94,96,1612970413,1597418413,'45889e799477e89fc42d66f6e9f3d35a9b6209ad81a433ba61dfbacb0d8ee93e','web'),(95,97,1613406956,1597854956,'f269a49491aa9a88f6e96f202fa6a20d7108e5353b31c2b535462eedd0edaa57','web'),(96,98,1613480070,1597928070,'c10058dfafa32a0b858bad1a682aabf44c09af3f576bb14cd457685bf2090276','web'),(97,99,1613803163,1598251163,'1092cfcef68037e5f9a5462ba43c41de7a4251ee202535bfa29bc6202a5f89d0','web'),(98,100,1613803282,1598251282,'f5af8d0c71d097ca2790bd832a7db4b30cfde779f103d08eec30523481d73c3c','web'),(99,101,1613814756,1598262756,'a6528a3e8809f6f4f910fb140178da1f238b2816ac9fc1a96ef69b367cb0139c','web'),(100,102,1614172345,1598620345,'841041c819467a543f4a535464a1442161257da8f62c6f0b6d933631f36a8bef','web'),(101,103,1614239977,1598687977,'5069cf6cfea8652ca3e38c097663895ad86b62626b5b151f4ac1bd8df89d36b3','web'),(102,104,1614387525,1598835525,'fc3a94e5108332db59dc952c31de07c7c4dd3858d0fe099c5df18df51b216256','web'),(103,105,1614476009,1598924009,'93c647163087a539d81c38e570f100ab9bd979023c1b2469ed41138a69d3000c','web'),(104,106,1614602681,1599050681,'261407688ad91603e33ce85d49e1b460bf3820cf02bc04e40e97c02e69ee3745','web'),(105,107,1614610442,1599058442,'eed9136bdff954c4eeb80ce57319088b5d3401f01dcbe05751860ff5c32adb58','web'),(106,108,1614613323,1599061323,'0846df48a07484f54a26faa066884c2ba224d92477704c495ed01fec93214ad6','web'),(107,109,1614651663,1599099663,'f2cd6af6dd88b18cfed1becaa7d505231478608dd8be01e57071f052d7709805','web'),(108,110,1614713383,1599161383,'6da9160b56eff9ec96ccaa6dc1af059fd5d86ced99ea5ed753d55a5ceaa3c8b7','web'),(109,111,1614823408,1599271408,'b06f46dec3bdbde76270e7471b0bc32c3f9afb3d24065818185c358cb9868bbe','web'),(110,112,1614909112,1599357112,'c90a316ab1df3314a5eab1de79e1fe1a0c0c5799d20551ae7de7e24e368f5a3a','web'),(111,113,1615022186,1599470186,'53aa49d4cc3b765be66c7c29c9e3c212834188cbc5b517ee5e6e6573076223ac','web'),(112,114,1615023827,1599471827,'2ef2cef348b2dfcbfe86711fef19c0f223f66099e868790d850bcb5d158993b3','web'),(113,115,1615032878,1599480878,'c4d6a5e8215554120f337019a8291d785d933dadb67b4f9eef4f98c387d64115','web'),(114,116,1615090540,1599538540,'3fc20fefbdb9a4c97b6b1dfc79871bb0a8efbf8c4e7f82e5d38df639071e127d','web'),(115,117,1615117332,1599565332,'6a186739e2fb15e84a65cf9c2b7e9572b0cbbfa27b80c715c065a8b86ccd37f9','web'),(116,118,1615260184,1599708184,'60020772cf23ee4fc54344fe1dca90febc3c9b6923e68167fcc9d9bf3b378447','web'),(117,119,1615454851,1599902851,'e62aca549953083093d02cee2b8881374d895ca95a692bb22f51dbe7d0802684','web'),(118,120,1615461009,1599909009,'3acad642e6f466a86bf9f11d9df76ae80ac52691ace106812ca02b3098a470ca','web'),(119,121,1615607995,1600055995,'64c359ff9114204094618842d8be6907fe988c1d3bbdc8d021e754c46bb798c6','web'),(120,122,1615700242,1600148242,'780244e315c0bdc211ebd6d975e5e71c12626b36b2533c7120a7b895f1b462c4','web'),(121,123,1615870889,1600318889,'dc0bb34936b067dcc0d73d14423f48c32582d4096892afe6a58661a36259f494','web'),(122,124,1615959443,1600407443,'54688ff73c41fdd4e55761e0887e37b7d56e5a682acd1a42467aef2d204583fc','web'),(123,125,1616089142,1600537142,'ffe15af89219b9b8f6929840298a9cb42e57239699d1370ea259b2810672d2d1','web'),(124,126,1616117100,1600565100,'4f6508e03bc534de85fd0cc785b92483dd39d37cda36c8a1bfa00581430d4fba','web'),(125,127,1616187610,1600635610,'f25c7065f4b0deb48e7124c538e45f51d70a9970f06acc16fe0fdf57dc9fad7c','web'),(126,128,1616384235,1600832235,'d6d008b21802a70cf12cc2419197640ee5a77b5b77a67096f1aab6217f17d804','web'),(127,129,1616399957,1600847957,'6c1b987894b3c73a79bc9c09933505833fad6242cc8bcf0998bcfd94a64f9e45','web'),(128,130,1616553007,1601001007,'a6576e3e5e493d0872cfc3f09fe8f692c2794d20290656306a90be581adccf48','web'),(129,131,1616735755,1601183755,'a9feb163a24be6ba1a6e6b4c9dd713450a02e22215b36a8c629dae47d2437d97','web'),(130,132,1617335168,1601783168,'39ae72ee65ba1cac6b9f6ed50326340834a2446276eb9992328b244aa3e8f52a','web'),(131,133,1617504449,1601952449,'1acbb1bd9f08f21c8620532ee8c26086d06b49a28f519d52de33729b1e3c0fa8','web'),(132,134,1617508732,1601956732,'9e8116a5cae5c958d5aa88359c3a313b78542634d84bf9f795fb7c783698ba5c','web'),(133,135,1617604492,1602052492,'b3ec5cec2743ca9f6b8be052c04d4524ed302142ee5df55913586d1843a5c3ee','web'),(134,136,1617626258,1602074258,'f98cc9d72bb26385559c2f284ba3be0229970a1419c94559add306c1faff3dff','web'),(135,137,1617677676,1602125676,'847f208ad1c8888bdd49c418fbbcf943edc89ead8c64fe1a5db543b68ea9a2b5','web'),(136,138,1617725228,1602173228,'19f37febd7691a4db11b210dde759e5e13e903b0dc6931ee6e1e9d719fd8b188','web'),(137,139,1617757090,1602205090,'7dc7929b8ced02cf3b09936611e55021b88cc024ff17330a8fa9092d10e3271e','web'),(138,140,1617783089,1602231089,'e13f1549a4867c3229a583d182312f6b129d6a636d35e183a12c68a635084cf1','web'),(139,141,1617858529,1602306529,'3e9273c312f8ba5396713b89191b96ed97e4c47ead8579120c555c4fa0bc26c2','web'),(140,142,1617872576,1602320576,'cd942a03892e4bbec80e8ef9e9e2d3aa3848e05b6f9fc2f16ec9414cfd0f58fa','web'),(141,143,1618021707,1602469707,'903d79c8853423b5c39c3330a59cbca1925c4c995aee4b73b8d40c292b71d62b','web'),(142,144,1618032061,1602480061,'a7e508a6f832b8403707e198089b0daa2f65ed31d15dcffdae1b5f22fd9b714e','web'),(143,145,1618123973,1602571973,'1e5073ab2e341e431add479d89d28d94e08f7652adac4614444c63da402dd7bf','web'),(144,146,1618156300,1602604300,'f55b325d10d221d06cb3d323d63d6b88cf205886f4df2b08402b39bb1d939d3c','web'),(145,147,1618201451,1602649451,'809aeed685daeb1201c6810c0cce294431c78b989233c1a79b9549d4455ad556','web'),(146,148,1618381387,1602829387,'3ce82f140dd3718e9013e7606aeecfd26db7372c979c9c6f3bc52a245f58bd3b','web'),(147,149,1618409184,1602857184,'9f136d6b127a707fe68a862bb132d4afc0d82b93de2fe3951eed4c06b2954a18','web'),(148,150,1618469052,1602917052,'779c39149768d46334b6b2995eef49c753380457370e769dec6fbf8ca443abd4','web'),(149,151,1618618515,1603066515,'19fd9a4bf27ba1fadfae2c43572e4b996d0bac426c2d4b848abd1832cb9f8d38','web'),(150,152,1618740268,1603188268,'71dd313ddbfe50d8ca1f64071c18b52e76ef238966a352acf387fe252720c0c5','web'),(151,153,1618890113,1603338113,'5222ebcafa3bf7eb1c721811533bc42d64187533e29466f0d957c06663b9e726','web'),(152,154,1618894440,1603342440,'7040dfa445d360b0842c52936d2b9f4ab7ec076163431436e563e0038e8f446c','web'),(153,155,1619015417,1603463417,'f7fdd83cb1b669bd44ef59fa5b630c75638266d1fd14ba74d1191bd15f0d7a81','web'),(154,156,1619034600,1603482600,'a88737881c8dc9e2709fa0c1740896ab0344d1d898412ef5a570646edcc1f829','web'),(155,157,1619095641,1603543641,'80db12de0007d9d05254deff696928e35744bacfa640d21f06877b598a8e802d','web'),(156,158,1619192079,1603640079,'416395725b9a0c8fb41da32043fe5fe4b94feb324ec57f8629856548962586f6','web'),(157,159,1619328971,1603776971,'4465399e234a5ef3d8335869726a52d451366d8a1a9857033e9e53643912db0f','web'),(158,160,1619425019,1603873019,'c68079d4a745a168810f70080b30be10baf0668519b5a9e38b0f347d62dfe7e7','web'),(159,161,1619886216,1604334216,'efabae11ee471c6797a4544af3a35721e72229f921b9ef2b0b1e1625344375e6','web'),(160,162,1619920377,1604368377,'a7679b3a7e8211464a1947ef76642d5670f8dee2ec2a86dbdae1b456999d4db6','web'),(161,163,1619933820,1604381820,'cbb805ed94d64aaed39f1868678893a4755df9401856a4222b14eda9dbe973ca','web'),(162,164,1620039093,1604487093,'6595b729de69408f84fe404fe678feea1a77d2fb6de28c8ea9cdf53d49dc0ed9','web'),(163,165,1620061907,1604509907,'dd07a2ab702afc89440715894a343a47ed5a14d55208a31bd94506f5c4ce9d66','web'),(164,166,1620108856,1604556856,'5fd38e7d64c07ebd0921e37cb0448933ff54f900e1d2a4957ec71add369c37ca','web'),(165,167,1620140328,1604588328,'283cbf1d7b2adc6f76f859d5c05b94f846c07ba16f1fd22580b9a249f0537a6a','web'),(166,168,1620301137,1604749137,'1627bd3d181a878e96a2e93eb17cf6f078fd4d55c64704833a6fd4f618e72d64','web'),(167,169,1620382310,1604830310,'ed72e6fb869f69422544f512d6f5f9047b24b0c0f3b86696f68bf8cd120a8458','web'),(168,170,1620411472,1604859472,'c856c5da6d2607657ab69f0e469d8dde4e7d744791408dda70ee93e80c33eef1','web'),(169,171,1620450219,1604898219,'41736aaee545234ca6be0114c0f63038de09ea47531687936a5b21fd16cfa70f','web'),(170,172,1620524665,1604972665,'b1dcbe9ecefac361b707cd66fefbeeeef2e8d308f48640200d76510896babd11','web'),(171,173,1620663963,1605111963,'d3606952f6c9a44fd99d9a44d1ce3c64524a3b4e82ad669c02215a8457cb7ae2','web'),(172,174,1620805395,1605253395,'8a1b80b2ab2c23066ae384652a8bf8db473781fa34aeb9a51804f44449a88787','web'),(173,175,1621015991,1605463991,'e9daa3df5daab253eeda6b584bf4c4ee89eab3f04459e2889474800c1f96fa51','web'),(174,176,1621136565,1605584565,'75d97aa6541cbcfcbbab5a7b58d79cabff778c109cc3c3e352c4123120722f05','web'),(175,177,1621245649,1605693649,'ccf2a61e21b7407a64d02e0792e09136a8acf7af163ad42153dcef5a8e025f40','web'),(176,178,1621478459,1605926459,'d31d6a7c99f79ca8ba6be252fecf95db17639c6e3eaaf6c0e41d6b401560ce69','web'),(177,179,1621515716,1605963716,'90adbf314ded8bca87a5ef631ac0406d65d324e582274e249de66f152d7637b6','web'),(178,180,1621591601,1606039601,'8819812bced0742b42be65a1399f684b39ef76c2f5c2c192cc72f12f00443cc8','web'),(179,181,1621655165,1606103165,'0d44968dc433e2dcd39959f364f77a33914a1fa452d00c055012c5165448129e','web'),(180,182,1621747687,1606195687,'7e41051898883c62ce45e9d8e4856cb3aafe89dbfbb50d9705f51ceb1652fdfe','web'),(181,183,1621762390,1606210390,'0501d59df5e288757b16d936dce95db2df41c3438be4c1430b557bebcfd5df51','web'); /*!40000 ALTER TABLE `cmf_user_token` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmf_verification_code` -- DROP TABLE IF EXISTS `cmf_verification_code`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cmf_verification_code` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id', `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '当天已经发送成功的次数', `send_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后发送成功时间', `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证码过期时间', `code` varchar(8) NOT NULL DEFAULT '' COMMENT '最后发送成功的验证码', `account` varchar(100) NOT NULL DEFAULT '' COMMENT '手机号或者邮箱', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='手机邮箱数字验证码表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cmf_verification_code` -- LOCK TABLES `cmf_verification_code` WRITE; /*!40000 ALTER TABLE `cmf_verification_code` DISABLE KEYS */; /*!40000 ALTER TABLE `cmf_verification_code` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'hdm721879203_db' -- /*!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-11-27 15:17:27