2 Star 0 Fork 1

海南丁当软件科技有限公司 / wocms

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
wocms.sql 47.90 KB
一键复制 编辑 原始数据 按行查看 历史
lulizhi 提交于 2019-02-22 17:14 . 增加清除session,修改函数命名
# Host: localhost (Version 5.5.5-10.1.37-MariaDB)
# Date: 2019-02-22 15:30:51
# Generator: MySQL-Front 6.1 (Build 1.26)
#
# Structure for table "about"
#
CREATE TABLE `about` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` blob NOT NULL COMMENT '文章内容-富文本',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建者id',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近更新',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
#
# Data for table "about"
#
REPLACE INTO `about` VALUES (1,X'3C703EE8BF99E698AFE4B880E5AEB6E4B893E6B3A8E8BDAFE4BBB6E5BC80E58F91E79A84E585ACE58FB83C2F703E',0,1547456942,1547456942);
#
# Structure for table "article"
#
CREATE TABLE `article` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章id',
`title` varchar(60) NOT NULL DEFAULT '' COMMENT '文章标题-60字符限制',
`sub_title` varchar(120) DEFAULT NULL COMMENT '子标题-预留',
`title_image` varchar(255) DEFAULT NULL COMMENT '题图-缩略图',
`abstract` varchar(255) DEFAULT NULL COMMENT '摘要-255字符限制',
`content` blob NOT NULL COMMENT '文章内容-富文本',
`page_view` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '浏览次数',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建者id',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近更新',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='文章表';
#
# Data for table "article"
#
REPLACE INTO `article` VALUES (33,'微信小程序开发','小程序开发','http://localhost:9090/upload/QW0yQosYfewbwSTvKSDI5eP.jpg','这是一家小程序开发很强的公司',X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F625833436E37756A6F75536E6F4F706D66613752375436472E6A7067223E3C2F6669677572653E3C703E266E6273703B3C2F703E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F5033385A4A555859584254667958586C3566535138684A762E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F6A6864566754744F4F6669505A4C7865686879507936552E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F674578714A61465436454F4C5635753158774253717041742E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F6C30634C77754B476D65773442507838507A666F4373634C2E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F54763178505A5666484931524E6961546B6878783261566C2E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4A57796E3579767A46585253576A4844526272704E36452E6A7067223E3C2F6669677572653E3C6832207374796C653D22746578742D616C69676E3A63656E7465723B223E3C7374726F6E673EE8BF99E698AFE4B880E5AEB6E5B08FE7A88BE5BA8FE5BC80E58F91E5BE88E5BCBAE79A84E585ACE58FB83C2F7374726F6E673E3C2F68323E',20,2,1547534212,1547458672),(34,'百度小程序',NULL,'http://localhost:9090/upload/Dv2dPpfBzm1FeM5gFO8AlsMb.jpg',NULL,X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F73654B4D5576725941694E556D44624B75743741394A58662E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F6B454D6F3537665630304D4D304A62436547467A30547A442E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4D3872343875484D445835356E3146415369535157454D482E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F7752315871526B42395A726B6A396561426455344F43684B2E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F6732716241326C4D30756468447455556A4E6479754B47622E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4D4D73326961444B376155614C45783144476B684C51676B2E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F594751506764786F465A414B6766594C57664A584D47754B2E6A7067223E3C2F6669677572653E',18,2,1547519459,1547518528),(35,'支付宝小程序',NULL,'http://localhost:9090/upload/bfump6UFAaBrwKPFiGYhtuMk.jpg',NULL,X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4A623649336333476D6352314A6D4734693332394F31314B2E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4976304C35694F31534934705172334A76327334614F792E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F49747A72654975596B547037746770556D444A69316937352E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F393747567A734334555153556563664643556131503579572E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4F7278785346445A706730446850677A73346158767167572E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F704D53423179445032675549766C356750595A485975344B2E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F697673346C745A6F7736495835596357534236375839636C2E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F7355444C4F646F4131336769486750614D59574B4E4B664D2E6A7067223E3C2F6669677572653E3C703E266E6273703B3C2F703E',10,2,1547519290,1547519290),(36,'小程序开发',NULL,'http://localhost:9090/upload/9CV64UabvFbcVqZfaWH8IpJ7.jpg',NULL,X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4F43626674774D4654437650733153764A4D71516D5648622E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4E695459613132735A493938743345513938503847434D782E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F453354435572326678413452454A356E7939335431656B432E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F6E5967434E786E6745505057716B4A48426C3057753539562E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F5139314767776234424D4B46436D587863306F4A5364592E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F5274644A654A44593168507637766C753455476576776D6A2E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F52724C7445364269797338707169736D7163694D424D322E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F50674C6D70684549635871504C4C7A6C357A6453666E43412E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F6F676E30734E34386E5130446B4C454B37584C524C6356732E6A7067223E3C2F6669677572653E',2,2,1547520019,1547520019),(37,'安卓app开发',NULL,'http://localhost:9090/upload/yyZttBm18Q3mu2rIx0m0cE.jpg','做APP,找我们 高保真原型图制作,精美效果图设计,功能全部定制化开发,按需制作 我们为遍布各个行业的600+个产品进行了专业服务。为什么选择我们? 完整的顾问式服务链条,实现项目开发的价值。',X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F6A54454465314C5A755A5373624B7A6D764D64486E7964772E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F33457A3250674964554A336A767962353950496F6F6C77502E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F584A4B37666C6A73627A346861773861587877556E344E742E6A7067223E3C2F6669677572653E3C703E266E6273703B3C2F703E',22,2,1547523456,1547523308),(38,'iosApp开发',NULL,'http://localhost:9090/upload/Dbb2VzFNE09NvWOAQgOqxz3S.jpg',NULL,X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4E344A666F33693257585063506C6245667735626E7046372E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F79417256683164764A44395079567A3374436456436861752E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F526E7366564B5770655650307366337A3455505A50664B552E6A7067223E3C2F6669677572653E',8,2,1547523780,1547523780),(39,'安卓深度定制app开发',NULL,'http://localhost:9090/upload/g95xlVOC3RzEvJnA7sUNMplY.jpg','做APP,找我们 高保真原型图制作,精美效果图设计,功能全部定制化开发,按需制作 我们为遍布各个行业的600+个产品进行了专业服务。为什么选择我们? 完整的顾问式服务链条,实现项目开发的价值。',X'3C68323E3C7374726F6E673EE68891E4BBACE8AEA4E79C9FE4BA8EE68A80E69CAFE4BA8CE58D81E5B9B43C2F7374726F6E673E3C2F68323E',10,2,1547531441,1547523308),(40,'iosApp开发',NULL,'http://localhost:9090/upload/15YrON59JUdDsjbYMZB9BEZF.jpg',NULL,X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F7857746B70444A6F374945536B616F3852753573683956522E6A7067223E3C2F6669677572653E',6,2,1547531520,1547523780),(41,'H5手机端',NULL,'http://localhost:9090/upload/rTEaNml8R3Dafi25Y7gsB.jpg','我们认真于H5开发很多年。只做精品',X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F7636596336664A6556504A4F574D4F4458736379495957552E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F7066534533496638396C7464774A47314D77516B4576442E6A7067223E3C2F6669677572653E3C66696775726520636C6173733D22696D616765223E3C696D67207372633D22687474703A2F2F6C6F63616C686F73743A393039302F75706C6F61642F4A6B4549723378644E6456426876336A4467757342307A322E6A7067223E3C2F6669677572653E',4,2,1550741271,1547535969);
#
# Structure for table "article_category"
#
CREATE TABLE `article_category` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
`title` varchar(20) NOT NULL DEFAULT '' COMMENT '分类标题-文字',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建者id,没什么作用',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近更新',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='文章分类';
#
# Data for table "article_category"
#
REPLACE INTO `article_category` VALUES (1,'APP开发',2,1547457641,1547457641),(2,'小程序开发',2,1547457648,1547457648),(3,'H5开发',2,1547457669,1547457669),(4,'其他',2,1547457795,1547457795);
#
# Structure for table "article_published_category"
#
CREATE TABLE `article_published_category` (
`category_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
`category_name` varchar(20) DEFAULT NULL COMMENT '分类标题,预留,冗余',
`article_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文章id',
PRIMARY KEY (`article_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='发布的文章分类记录表';
#
# Data for table "article_published_category"
#
REPLACE INTO `article_published_category` VALUES (2,'小程序开发',33),(2,'小程序开发',34),(2,'小程序开发',35),(2,'小程序开发',36),(1,'APP开发',37),(1,'APP开发',38),(1,'APP开发',39),(1,'APP开发',40),(3,'H5开发',41),(3,'H5开发',42),(4,'其他',43);
#
# Structure for table "block_show_article_category"
#
CREATE TABLE `block_show_article_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) NOT NULL DEFAULT '0',
`category_name` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='首页块对文章分类映射表';
#
# Data for table "block_show_article_category"
#
REPLACE INTO `block_show_article_category` VALUES (1,1,'APP开发'),(2,2,'小程序开发'),(3,3,'H5开发'),(4,4,'其他');
#
# Structure for table "company"
#
CREATE TABLE `company` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`logo` varchar(255) NOT NULL DEFAULT '' COMMENT '公司logo资源连接',
`c_name` varchar(120) NOT NULL DEFAULT '' COMMENT '公司名字',
`c_addr` varchar(255) DEFAULT NULL COMMENT '公司地址',
`tel` varchar(255) DEFAULT NULL COMMENT '联系电话',
`icp` varchar(255) DEFAULT NULL COMMENT '网站icp备案信息',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近更新',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='公司信息表';
#
# Data for table "company"
#
REPLACE INTO `company` VALUES (1,'http://localhost:9090/upload/eRs1amRGukr27KvyZwtmqAI6.jpg.png','wo-cms','海南省海口市','0898','琼ICP备00000000号',1547459960,1547459960);
#
# Structure for table "consult"
#
CREATE TABLE `consult` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录id',
`c_email` varchar(60) NOT NULL DEFAULT '' COMMENT '客户邮箱地址',
`c_phone` varchar(20) NOT NULL DEFAULT '0' COMMENT '客户联系电话',
`c_name` varchar(60) NOT NULL DEFAULT '' COMMENT '客户名称,可能是公司名称',
`c_requirement` varchar(512) NOT NULL DEFAULT '' COMMENT '客户需求描述',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='咨询信息收集表';
#
# Data for table "consult"
#
#
# Structure for table "email_service_config"
#
CREATE TABLE `email_service_config` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录id',
`email` varchar(120) NOT NULL DEFAULT '' COMMENT '服务邮箱',
`from_name` varchar(120) NOT NULL DEFAULT '' COMMENT 'from name,来自名字',
`to_email` varchar(255) NOT NULL DEFAULT '',
`smtp_server` varchar(120) NOT NULL DEFAULT '' COMMENT 'smtp服务地址',
`port` varchar(8) NOT NULL DEFAULT '25' COMMENT '端口号,默认25',
`password` varchar(255) NOT NULL DEFAULT '' COMMENT '服务器密码',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近更新',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='邮件服务配置';
#
# Data for table "email_service_config"
#
REPLACE INTO `email_service_config` VALUES (1,'','zhitou','895873165@qq.com,18819268971@163.com','','25','',1547450177,1547450177);
#
# Structure for table "file_upload"
#
CREATE TABLE `file_upload` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
`uri` varchar(255) NOT NULL DEFAULT '' COMMENT '文件路径',
`type` varchar(255) NOT NULL DEFAULT '' COMMENT '文件类型',
`size` int(11) NOT NULL DEFAULT '0' COMMENT '文件大小',
`updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
`created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8 COMMENT='文件上传表';
#
# Data for table "file_upload"
#
REPLACE INTO `file_upload` VALUES (36,'EzBTRJa0brPvBMVCQ03TNRH6.jpg','upload/EzBTRJa0brPvBMVCQ03TNRH6.jpg','image/jpeg',27773,1545962151,1545962151),(37,'NNDUZXPYbiTghE7ur9UyxuKA.jpg','upload/NNDUZXPYbiTghE7ur9UyxuKA.jpg','image/jpeg',27773,1545963497,1545963497),(38,'FhJIajYrFBjmDsavMejGmXP.jpg','upload/FhJIajYrFBjmDsavMejGmXP.jpg','image/jpeg',27773,1545963537,1545963537),(39,'eM7G1yG6Oi7xKPViwRD24fs.jpg','upload/eM7G1yG6Oi7xKPViwRD24fs.jpg','image/jpeg',27773,1545964003,1545964003),(40,'z0dUQ4CoiQN8S6oGwAJBiKHM.jpg','upload/z0dUQ4CoiQN8S6oGwAJBiKHM.jpg','image/jpeg',27773,1545964149,1545964149),(41,'9eLZvAY4SDIFG9VoUi6ZBvaU.jpg','upload/9eLZvAY4SDIFG9VoUi6ZBvaU.jpg','image/jpeg',27773,1545964384,1545964384),(42,'zG8dpygKxCkBaABWd3iJajV1.jpg','upload/zG8dpygKxCkBaABWd3iJajV1.jpg','image/jpeg',27773,1545964390,1545964390),(43,'48VBTyclDCEDP7UKE8xhXit.jpg','upload/48VBTyclDCEDP7UKE8xhXit.jpg','image/jpeg',27773,1545964410,1545964410),(44,'mHdyfIQyG9ZelXeiLwL8Pqsp.jpg','upload/mHdyfIQyG9ZelXeiLwL8Pqsp.jpg','image/jpeg',70211,1545985744,1545985744),(45,'mpPluwWvA3oqqAZbWerZZnrH.jpg','upload/mpPluwWvA3oqqAZbWerZZnrH.jpg','image/jpeg',70211,1545985775,1545985775),(46,'MymTGzga2JQz9fY1ZvdsvWDD.jpg','upload/MymTGzga2JQz9fY1ZvdsvWDD.jpg','image/jpeg',70211,1545985911,1545985911),(47,'FL4cAPVD6QaFb4CymwGVdBG7.jpg','upload/FL4cAPVD6QaFb4CymwGVdBG7.jpg','image/jpeg',70211,1545986053,1545986053),(48,'jjjpP9Lbp0RlgLRbYJ5XYly.jpg','upload/jjjpP9Lbp0RlgLRbYJ5XYly.jpg','image/jpeg',27773,1546048718,1546048718),(49,'Ke8CZThmCWRhSkMdVXiNOmK9.jpg','upload/Ke8CZThmCWRhSkMdVXiNOmK9.jpg','image/jpeg',27773,1546048923,1546048923),(50,'RnnW275jxaOTxVmtPGu3y7k8.jpg','upload/RnnW275jxaOTxVmtPGu3y7k8.jpg','image/jpeg',70211,1546049003,1546049003),(51,'CHrOkpuYN1xbvsYOVIulflm5.jpg','upload/CHrOkpuYN1xbvsYOVIulflm5.jpg','image/jpeg',27773,1546051888,1546051888),(52,'afqQDHinIXJd9iI0sqR4DsU2.jpg','upload/afqQDHinIXJd9iI0sqR4DsU2.jpg','image/jpeg',27773,1546052640,1546052640),(53,'rsr9ye5u8tHb52oqpWLqoHYM.jpg','upload/rsr9ye5u8tHb52oqpWLqoHYM.jpg','image/jpeg',27773,1546053613,1546053613),(54,'nHeJ7810VnVqGllMxH1jFDAW.jpg','upload/nHeJ7810VnVqGllMxH1jFDAW.jpg','image/jpeg',27773,1546420529,1546420529),(55,'vbvSUVM2cVawguxo2KKFoGX2.jpg','upload/vbvSUVM2cVawguxo2KKFoGX2.jpg','image/jpeg',27773,1546420616,1546420616),(56,'dZB3kxW9YyiW9MLS3vH4XedY.jpg','upload/dZB3kxW9YyiW9MLS3vH4XedY.jpg','image/jpeg',27773,1546420642,1546420642),(57,'Q95Xb4sOOqB6Mky4NTyhnEC2.jpg','upload/Q95Xb4sOOqB6Mky4NTyhnEC2.jpg','image/jpeg',27773,1546420709,1546420709),(58,'ZDxRuI8NazeRPmEMvytdGSs.jpg','upload/ZDxRuI8NazeRPmEMvytdGSs.jpg','image/jpeg',27773,1546420775,1546420775),(59,'Je4q40upVXDeuuxu1vHyvjnq.jpg','upload/Je4q40upVXDeuuxu1vHyvjnq.jpg','image/jpeg',70211,1546420956,1546420956),(60,'siXm5toqdinZK7Yh4PsqzqpQ.jpg','upload/siXm5toqdinZK7Yh4PsqzqpQ.jpg','image/jpeg',296813,1546504447,1546504447),(61,'BeYyS5KClMcDySjzOKXoaYCY.jpg','upload/BeYyS5KClMcDySjzOKXoaYCY.jpg','image/jpeg',1006210,1546504565,1546504565),(62,'CrUTdseDBaMmfV8MEca3oJsJ.jpg','upload/CrUTdseDBaMmfV8MEca3oJsJ.jpg','image/jpeg',60872,1546589384,1546589384),(63,'ri9CShP4tEW8BzNhmIpsbOO5.jpg','upload/ri9CShP4tEW8BzNhmIpsbOO5.jpg','image/jpeg',79520,1546589730,1546589730),(64,'I8A7xDKW1eNAaelctwHiNJs.jpg','upload/I8A7xDKW1eNAaelctwHiNJs.jpg','image/jpeg',125415,1546589827,1546589827),(65,'AgZr1gnfEcoDDNrONEARGLMe.jpg','upload/AgZr1gnfEcoDDNrONEARGLMe.jpg','image/jpeg',79147,1546590142,1546590142),(66,'19iI4AeZ4e1JbPLrKM7EtsbA.jpg','upload/19iI4AeZ4e1JbPLrKM7EtsbA.jpg','image/jpeg',63612,1546590317,1546590317),(67,'pl0vIw0x3LCFtzju4RnwdDA.jpg','upload/pl0vIw0x3LCFtzju4RnwdDA.jpg','image/jpeg',104213,1546590395,1546590395),(68,'seRSp42wtOk0K9wDXcag8n7l.jpg','upload/seRSp42wtOk0K9wDXcag8n7l.jpg','image/jpeg',52749,1546590482,1546590482),(69,'fLQZTScclFs8BjVsMU16DyP3.jpg','upload/fLQZTScclFs8BjVsMU16DyP3.jpg','image/jpeg',92781,1546593149,1546593149),(70,'p0u3rpRy0Heb5gVCxmab5iAP.jpg','upload/p0u3rpRy0Heb5gVCxmab5iAP.jpg','image/jpeg',39946,1546593239,1546593239),(71,'bTTetdXRp6LOwG204TdfMzE.jpg','upload/bTTetdXRp6LOwG204TdfMzE.jpg','image/jpeg',61302,1546593363,1546593363),(72,'pB1rKhLNPa57KLCw5Kxiicp.jpg','upload/pB1rKhLNPa57KLCw5Kxiicp.jpg','image/jpeg',82862,1546593497,1546593497),(73,'zVJ1nqdSSrcV2f89xSO6dCcr.jpg','upload/zVJ1nqdSSrcV2f89xSO6dCcr.jpg','image/jpeg',13324,1546595229,1546595229),(74,'1PyxyTiLxmzwY0CpqEX1Zjm.jpg','upload/1PyxyTiLxmzwY0CpqEX1Zjm.jpg','image/jpeg',14064,1546595343,1546595343),(75,'szK8ZR9QPADqlEBeBl3xxYx.jpg','upload/szK8ZR9QPADqlEBeBl3xxYx.jpg','image/jpeg',14064,1546595431,1546595431),(76,'75LTZkwFnTSGYFO1GnklhBNe.jpg','upload/75LTZkwFnTSGYFO1GnklhBNe.jpg','image/jpeg',12954,1546595437,1546595437),(77,'2S1R4YvLTG2naVZpBjvr3upY.jpg','upload/2S1R4YvLTG2naVZpBjvr3upY.jpg','image/jpeg',2731,1546596756,1546596756),(78,'TIx79GyiY6EbVgo4qMZnpxD.jpg','upload/TIx79GyiY6EbVgo4qMZnpxD.jpg','image/jpeg',92781,1546666883,1546666883),(79,'iNh58G4JvVy9oveGi6Eo2hGi.jpg','upload/iNh58G4JvVy9oveGi6Eo2hGi.jpg','image/jpeg',82862,1547018499,1547018499),(80,'ja1iSW6Dg9h2KyFW3KXVRnt5.jpg','upload/ja1iSW6Dg9h2KyFW3KXVRnt5.jpg','image/jpeg',63612,1547023661,1547023661),(81,'llYoU8wj7OPV1c8jQP2VcV0.jpg','upload/llYoU8wj7OPV1c8jQP2VcV0.jpg','image/jpeg',125415,1547087307,1547087307),(82,'CMnFxJdDJKyug33dJ6lOktrT.jpg','upload/CMnFxJdDJKyug33dJ6lOktrT.jpg','image/jpeg',79520,1547087343,1547087343),(83,'ffXG4Xz8vJPSMCxy2qx7CfiK.jpg','upload/ffXG4Xz8vJPSMCxy2qx7CfiK.jpg','image/jpeg',79520,1547087366,1547087366),(84,'4aIsGuNr1fncw2pIwyqVX5Qh.jpg','upload/4aIsGuNr1fncw2pIwyqVX5Qh.jpg','image/jpeg',125415,1547087423,1547087423),(85,'Hg7t4Rj3v3Aa38D0dz3HHQor.jpg','upload/Hg7t4Rj3v3Aa38D0dz3HHQor.jpg','image/jpeg',79520,1547087427,1547087427),(86,'6Vo7cf4AplRLTBNpTgEw5bG.jpg','upload/6Vo7cf4AplRLTBNpTgEw5bG.jpg','image/jpeg',79520,1547087655,1547087655),(87,'o0BYB8S8GCruGlpP1Hcuo1k.jpg','upload/o0BYB8S8GCruGlpP1Hcuo1k.jpg','image/jpeg',79520,1547087676,1547087676),(88,'b00lKBm5CHoVKBy9Bc3BSD0J.jpg','upload/b00lKBm5CHoVKBy9Bc3BSD0J.jpg','image/jpeg',2731,1547087988,1547087988),(89,'9FuBXSr1nUmUIRqP6c65f3Xd.jpg','upload/9FuBXSr1nUmUIRqP6c65f3Xd.jpg','image/jpeg',79520,1547088500,1547088500),(90,'PSzO0eXrDFHFQ7OQtnPetkUf.jpg','upload/PSzO0eXrDFHFQ7OQtnPetkUf.jpg','image/jpeg',79520,1547088759,1547088759),(91,'kupcf6PAJnRhAsa9Xu8N2zig.jpg','upload/kupcf6PAJnRhAsa9Xu8N2zig.jpg','image/jpeg',52749,1547088780,1547088780),(92,'7B4eKSeRrOGVz9bJG7Sqtq9.jpg','upload/7B4eKSeRrOGVz9bJG7Sqtq9.jpg','image/jpeg',79520,1547088891,1547088891),(93,'Hw3FGsmR9CjIdEhp418OSSP3.jpg','upload/Hw3FGsmR9CjIdEhp418OSSP3.jpg','image/jpeg',52749,1547088957,1547088957),(94,'9XYdjwPpLUpW6P4V3hZg3h.jpg','upload/9XYdjwPpLUpW6P4V3hZg3h.jpg','image/jpeg',79520,1547089093,1547089093),(95,'VZRaoZyheuz2tp5Glsxxv9K.jpg','upload/VZRaoZyheuz2tp5Glsxxv9K.jpg','image/jpeg',104213,1547089129,1547089129),(96,'XiySj3fv1G7gSyKl9wDUziTq.jpg','upload/XiySj3fv1G7gSyKl9wDUziTq.jpg','image/jpeg',79520,1547089157,1547089157),(97,'RNIFoZmZtDKS4IwTCEvRe2f.jpg','upload/RNIFoZmZtDKS4IwTCEvRe2f.jpg','image/jpeg',125415,1547089344,1547089344),(98,'tvOT8g52dIgnMZqdGn0NK2PE.jpg','upload/tvOT8g52dIgnMZqdGn0NK2PE.jpg','image/jpeg',52749,1547089427,1547089427),(99,'YhxYPbnIVyZIVC7BsXqMNXTw.jpg','upload/YhxYPbnIVyZIVC7BsXqMNXTw.jpg','image/jpeg',79520,1547089467,1547089467),(100,'xc7FvXhOPBkjXwuVkT6Whd6b.jpg','upload/xc7FvXhOPBkjXwuVkT6Whd6b.jpg','image/jpeg',79520,1547090095,1547090095),(101,'2Dfuk1lRtW4gmXZQ9hLPTl9v.jpg','upload/2Dfuk1lRtW4gmXZQ9hLPTl9v.jpg','image/jpeg',125415,1547090117,1547090117),(102,'5KXKUvPTqO1Fn9TmYwz8Aws7.jpg','upload/5KXKUvPTqO1Fn9TmYwz8Aws7.jpg','image/jpeg',14064,1547090671,1547090671),(103,'rr3NvyS8bKVj2i78rwHV6J.jpg','upload/rr3NvyS8bKVj2i78rwHV6J.jpg','image/jpeg',12954,1547090707,1547090707),(104,'rFa3jynksYI6Vx2nHYA0nUy.jpg','upload/rFa3jynksYI6Vx2nHYA0nUy.jpg','image/jpeg',52749,1547091393,1547091393),(105,'I9nfTZYRZoBFJISqbSiTApA1.jpg','upload/I9nfTZYRZoBFJISqbSiTApA1.jpg','image/jpeg',79520,1547091498,1547091498),(106,'TI8AAkQX4rehfOpINHr6xFtF.jpg','upload/TI8AAkQX4rehfOpINHr6xFtF.jpg','image/jpeg',79520,1547091611,1547091611),(107,'JxNpQ91CTuF9Dl05TGdcOTcS.jpg','upload/JxNpQ91CTuF9Dl05TGdcOTcS.jpg','image/jpeg',104213,1547091643,1547091643),(108,'RCrgd6e2rDGvYlpVFrQ4Ry1A.jpg','upload/RCrgd6e2rDGvYlpVFrQ4Ry1A.jpg','image/jpeg',79520,1547091647,1547091647),(109,'1xDQQMHasjPfKZea3ZT87OqP.jpg','upload/1xDQQMHasjPfKZea3ZT87OqP.jpg','image/jpeg',13324,1547091691,1547091691),(110,'FmAUEq1flTh22xvQjK2uFN.jpg','upload/FmAUEq1flTh22xvQjK2uFN.jpg','image/jpeg',79520,1547091775,1547091775),(111,'glcYDiTIxvSZ7NXiSyJXWd1Y.jpg','upload/glcYDiTIxvSZ7NXiSyJXWd1Y.jpg','image/jpeg',79520,1547091806,1547091806),(112,'YZT70t83hRNrJmXSewER88N.jpg','upload/YZT70t83hRNrJmXSewER88N.jpg','image/jpeg',52749,1547091846,1547091846),(113,'ahGzsMxnasCosMAXOkzpkWKB.jpg','upload/ahGzsMxnasCosMAXOkzpkWKB.jpg','image/jpeg',125415,1547091850,1547091850),(114,'3Y1watKJ2StIjLY5sAzEmJJ5.jpg','upload/3Y1watKJ2StIjLY5sAzEmJJ5.jpg','image/jpeg',79147,1547091859,1547091859),(115,'2dOGCKOXgiPFmwauSsbUZCgT.jpg','upload/2dOGCKOXgiPFmwauSsbUZCgT.jpg','image/jpeg',296813,1547091862,1547091862),(116,'4K67cicp2YQUC32WezK1vllE.jpg','upload/4K67cicp2YQUC32WezK1vllE.jpg','image/jpeg',125415,1547098307,1547098307),(117,'Jydsuyeihs4F2wCWs8YheAfj.jpg','upload/Jydsuyeihs4F2wCWs8YheAfj.jpg','image/jpeg',70211,1547100589,1547100589),(129,'Mtxgtj0F1UQspyzB2T45itL.jpg','upload/Mtxgtj0F1UQspyzB2T45itL.jpg','image/jpeg',68773,1547458489,1547458489),(130,'bX3Cn7ujouSnoOpmfa7R7T6G.jpg','upload/bX3Cn7ujouSnoOpmfa7R7T6G.jpg','image/jpeg',68773,1547458504,1547458504),(131,'P38ZJUXYXBTfyXXl5fSQ8hJv.jpg','upload/P38ZJUXYXBTfyXXl5fSQ8hJv.jpg','image/jpeg',47599,1547458530,1547458530),(132,'jhdVgTtOOfiPZLxehhyPy6U.jpg','upload/jhdVgTtOOfiPZLxehhyPy6U.jpg','image/jpeg',40932,1547458574,1547458574),(133,'gExqJaFT6EOLV5u1XwBSqpAt.jpg','upload/gExqJaFT6EOLV5u1XwBSqpAt.jpg','image/jpeg',37598,1547458598,1547458598),(134,'l0cLwuKGmew4BPx8PzfoCscL.jpg','upload/l0cLwuKGmew4BPx8PzfoCscL.jpg','image/jpeg',35185,1547458607,1547458607),(135,'Tv1xPZVfHI1RNiaTkhxx2aVl.jpg','upload/Tv1xPZVfHI1RNiaTkhxx2aVl.jpg','image/jpeg',36483,1547458620,1547458620),(136,'JWyn5yvzFXRSWjHDRbrpN6E.jpg','upload/JWyn5yvzFXRSWjHDRbrpN6E.jpg','image/jpeg',40193,1547458627,1547458627),(137,'h0ynEgbXziUBE04bmzJToW08.jpg','upload/h0ynEgbXziUBE04bmzJToW08.jpg','image/jpeg',75170,1547459959,1547459959),(138,'NmSTMwBE1UP0jbRYNrcRepy.jpg','upload/NmSTMwBE1UP0jbRYNrcRepy.jpg','image/jpeg',39148,1547514643,1547514643),(139,'8znWqFhAzGAxva82RJl6RDA.jpg','upload/8znWqFhAzGAxva82RJl6RDA.jpg','image/jpeg',47599,1547514653,1547514653),(140,'4uxPXWRVWWIyOPbNRJS4yz3J.jpg','upload/4uxPXWRVWWIyOPbNRJS4yz3J.jpg','image/jpeg',53705,1547518466,1547518466),(141,'seKMUvrYAiNUmDbKut7A9JXf.jpg','upload/seKMUvrYAiNUmDbKut7A9JXf.jpg','image/jpeg',53705,1547518479,1547518479),(142,'kEMo57fV00MM0JbCeGFz0TzD.jpg','upload/kEMo57fV00MM0JbCeGFz0TzD.jpg','image/jpeg',93901,1547518491,1547518491),(143,'M8r48uHMDX55n1FASiSQWEMH.jpg','upload/M8r48uHMDX55n1FASiSQWEMH.jpg','image/jpeg',70375,1547518500,1547518500),(144,'wR1XqRkB9Zrkj9eaBdU4OChK.jpg','upload/wR1XqRkB9Zrkj9eaBdU4OChK.jpg','image/jpeg',73580,1547518506,1547518506),(145,'g2qbA2lM0udhDtUUjNdyuKGb.jpg','upload/g2qbA2lM0udhDtUUjNdyuKGb.jpg','image/jpeg',67037,1547518512,1547518512),(146,'MMs2iaDK7aUaLEx1DGkhLQgk.jpg','upload/MMs2iaDK7aUaLEx1DGkhLQgk.jpg','image/jpeg',69574,1547518517,1547518517),(147,'YGQPgdxoFZAKgfYLWfJXMGuK.jpg','upload/YGQPgdxoFZAKgfYLWfJXMGuK.jpg','image/jpeg',39810,1547518523,1547518523),(148,'bfump6UFAaBrwKPFiGYhtuMk.jpg','upload/bfump6UFAaBrwKPFiGYhtuMk.jpg','image/jpeg',53557,1547519249,1547519249),(149,'Jb6I3c3GmcR1JmG4i329O11K.jpg','upload/Jb6I3c3GmcR1JmG4i329O11K.jpg','image/jpeg',53557,1547519258,1547519258),(150,'Iv0L5iO1SI4pQr3Jv2s4aOy.jpg','upload/Iv0L5iO1SI4pQr3Jv2s4aOy.jpg','image/jpeg',54126,1547519265,1547519265),(151,'ItzreIuYkTp7tgpUmDJi1i75.jpg','upload/ItzreIuYkTp7tgpUmDJi1i75.jpg','image/jpeg',148310,1547519268,1547519268),(152,'97GVzsC4UQSUecfFCUa1P5yW.jpg','upload/97GVzsC4UQSUecfFCUa1P5yW.jpg','image/jpeg',270427,1547519272,1547519272),(153,'OrxxSFDZpg0DhPgzs4aXvqgW.jpg','upload/OrxxSFDZpg0DhPgzs4aXvqgW.jpg','image/jpeg',193225,1547519276,1547519276),(154,'pMSB1yDP2gUIvl5gPYZHYu4K.jpg','upload/pMSB1yDP2gUIvl5gPYZHYu4K.jpg','image/jpeg',176542,1547519279,1547519279),(155,'ivs4ltZow6IX5YcWSB67X9cl.jpg','upload/ivs4ltZow6IX5YcWSB67X9cl.jpg','image/jpeg',191648,1547519283,1547519283),(156,'sUDLOdoA13giHgPaMYWKNKfM.jpg','upload/sUDLOdoA13giHgPaMYWKNKfM.jpg','image/jpeg',97003,1547519286,1547519286),(157,'QW0yQosYfewbwSTvKSDI5eP.jpg','upload/QW0yQosYfewbwSTvKSDI5eP.jpg','image/jpeg',31155,1547519397,1547519397),(158,'Dv2dPpfBzm1FeM5gFO8AlsMb.jpg','upload/Dv2dPpfBzm1FeM5gFO8AlsMb.jpg','image/jpeg',32490,1547519457,1547519457),(159,'9CV64UabvFbcVqZfaWH8IpJ7.jpg','upload/9CV64UabvFbcVqZfaWH8IpJ7.jpg','image/jpeg',433597,1547519946,1547519946),(160,'OCbftwMFTCvPs1SvJMqQmVHb.jpg','upload/OCbftwMFTCvPs1SvJMqQmVHb.jpg','image/jpeg',433597,1547519956,1547519956),(161,'NiTYa12sZI98t3EQ98P8GCMx.jpg','upload/NiTYa12sZI98t3EQ98P8GCMx.jpg','image/jpeg',1073106,1547519963,1547519963),(162,'E3TCUr2fxA4REJ5ny93T1ekC.jpg','upload/E3TCUr2fxA4REJ5ny93T1ekC.jpg','image/jpeg',319017,1547519972,1547519972),(163,'nYgCNxngEPPWqkJHBl0Wu59V.jpg','upload/nYgCNxngEPPWqkJHBl0Wu59V.jpg','image/jpeg',581290,1547519979,1547519979),(164,'Q91Ggwb4BMKFCmXxc0oJSdY.jpg','upload/Q91Ggwb4BMKFCmXxc0oJSdY.jpg','image/jpeg',480042,1547519984,1547519984),(165,'RtdJeJDY1hPv7vlu4UGevwmj.jpg','upload/RtdJeJDY1hPv7vlu4UGevwmj.jpg','image/jpeg',275228,1547519988,1547519988),(166,'RrLtE6Biys8pqismqciMBM2.jpg','upload/RrLtE6Biys8pqismqciMBM2.jpg','image/jpeg',415049,1547519992,1547519992),(167,'PgLmphEIcXqPLLzl5zdSfnCA.jpg','upload/PgLmphEIcXqPLLzl5zdSfnCA.jpg','image/jpeg',499867,1547519995,1547519995),(168,'ogn0sN48nQ0DkLEK7XLRLcVs.jpg','upload/ogn0sN48nQ0DkLEK7XLRLcVs.jpg','image/jpeg',379018,1547520016,1547520016),(169,'CXF7tmeQm691ymTwBvhTRTGw.jpg','upload/CXF7tmeQm691ymTwBvhTRTGw.jpg','image/jpeg',447999,1547520067,1547520067),(170,'aGbQu2eIpFRDVOXfZ8CfS11e.jpg','upload/aGbQu2eIpFRDVOXfZ8CfS11e.jpg','image/jpeg',194866,1547521285,1547521285),(171,'IsOKIh6VlO8sDWoWo1JDOww0.jpg','upload/IsOKIh6VlO8sDWoWo1JDOww0.jpg','image/jpeg',47425,1547522555,1547522555),(172,'niRFwRL2x82N3f6mhCCyBwA.jpg','upload/niRFwRL2x82N3f6mhCCyBwA.jpg','image/jpeg',41875,1547522580,1547522580),(173,'WrAvBH4rUK2OAG0kHFthVpe3.jpg','upload/WrAvBH4rUK2OAG0kHFthVpe3.jpg','image/jpeg',66073,1547522601,1547522601),(174,'jTEDe1LZuZSsbKzmvMdHnydw.jpg','upload/jTEDe1LZuZSsbKzmvMdHnydw.jpg','image/jpeg',397571,1547523229,1547523229),(175,'3Ez2PgIdUJ3jvyb59PIoolwP.jpg','upload/3Ez2PgIdUJ3jvyb59PIoolwP.jpg','image/jpeg',437147,1547523234,1547523234),(176,'XJK7fljsbz4haw8aXxwUn4Nt.jpg','upload/XJK7fljsbz4haw8aXxwUn4Nt.jpg','image/jpeg',275033,1547523237,1547523237),(177,'yyZttBm18Q3mu2rIx0m0cE.jpg','upload/yyZttBm18Q3mu2rIx0m0cE.jpg','image/jpeg',564202,1547523305,1547523305),(178,'Dbb2VzFNE09NvWOAQgOqxz3S.jpg','upload/Dbb2VzFNE09NvWOAQgOqxz3S.jpg','image/jpeg',18381,1547523742,1547523742),(179,'N4Jfo3i2WXPcPlbEfw5bnpF7.jpg','upload/N4Jfo3i2WXPcPlbEfw5bnpF7.jpg','image/jpeg',387861,1547523758,1547523758),(180,'yArVh1dvJD9PyVz3tCdVChau.jpg','upload/yArVh1dvJD9PyVz3tCdVChau.jpg','image/jpeg',1094017,1547523769,1547523769),(181,'RnsfVKWpeVP0sf3z4UPZPfKU.jpg','upload/RnsfVKWpeVP0sf3z4UPZPfKU.jpg','image/jpeg',336308,1547523779,1547523779),(182,'bNZYbjJ564zbPS7S4R8C1609.jpg','upload/bNZYbjJ564zbPS7S4R8C1609.jpg','image/jpeg',385322,1547530366,1547530366),(183,'HJNYXoHCCn78QMd5Gafrt5v.jpg','upload/HJNYXoHCCn78QMd5Gafrt5v.jpg','image/jpeg',44602,1547530441,1547530441),(184,'OpQnk6wWGUobRUoMeRRrpLwL.jpg','upload/OpQnk6wWGUobRUoMeRRrpLwL.jpg','image/jpeg',49943,1547530472,1547530472),(185,'g95xlVOC3RzEvJnA7sUNMplY.jpg','upload/g95xlVOC3RzEvJnA7sUNMplY.jpg','image/jpeg',78022,1547531416,1547531416),(186,'xWtkpDJo7IESkao8Ru5sh9VR.jpg','upload/xWtkpDJo7IESkao8Ru5sh9VR.jpg','image/jpeg',387861,1547531510,1547531510),(187,'15YrON59JUdDsjbYMZB9BEZF.jpg','upload/15YrON59JUdDsjbYMZB9BEZF.jpg','image/jpeg',387861,1547531518,1547531518),(188,'rTEaNml8R3Dafi25Y7gsB.jpg','upload/rTEaNml8R3Dafi25Y7gsB.jpg','image/jpeg',164229,1547535931,1547535931),(189,'v6Yc6fJeVPJOWMODXscyIYWU.jpg','upload/v6Yc6fJeVPJOWMODXscyIYWU.jpg','image/jpeg',186019,1547535949,1547535949),(190,'pfSE3If89ltdwJG1MwQkEvD.jpg','upload/pfSE3If89ltdwJG1MwQkEvD.jpg','image/jpeg',164229,1547535960,1547535960),(191,'JkEIr3xdNdVBhv3jDgusB0z2.jpg','upload/JkEIr3xdNdVBhv3jDgusB0z2.jpg','image/jpeg',124487,1547535968,1547535968),(193,'5gufVNjpg8YmoGJrcKpB22Pw.jpg','upload/5gufVNjpg8YmoGJrcKpB22Pw.jpg','image/jpeg',217717,1547536242,1547536242),(194,'A6cJThXfj4AQrqvVUD8oqWMW.jpg','upload/A6cJThXfj4AQrqvVUD8oqWMW.jpg','image/jpeg',522505,1547536260,1547536260),(195,'RG7y35rgoWr0xPsu0VYEbDO.jpg','upload/RG7y35rgoWr0xPsu0VYEbDO.jpg','image/jpeg',631749,1547536280,1547536280),(196,'o7rp2Nrk5MCKclrbU1axxCN.jpg','upload/o7rp2Nrk5MCKclrbU1axxCN.jpg','image/jpeg',255138,1547536298,1547536298),(197,'lp3buzbP9yHYm2DKqdO1Hz2Y.jpg','upload/lp3buzbP9yHYm2DKqdO1Hz2Y.jpg','image/jpeg',352804,1547536574,1547536574),(198,'2INjU5G8ZKb3nKq7Gjv7Mm5c.jpg','upload/2INjU5G8ZKb3nKq7Gjv7Mm5c.jpg','image/jpeg',157661,1547536593,1547536593),(199,'eQro9QC6IKwt1zoUQlrEMoUg.jpg','upload/eQro9QC6IKwt1zoUQlrEMoUg.jpg','image/jpeg',161975,1547536602,1547536602),(200,'o8QWGBslSlGWF6GFKcF24P9y.jpg','upload/o8QWGBslSlGWF6GFKcF24P9y.jpg','image/jpeg',147370,1547536607,1547536607),(201,'eRs1amRGukr27KvyZwtmqAI5.jpg','upload/eRs1amRGukr27KvyZwtmqAI5.jpg','image/jpeg',11453,1547601699,1547601699),(202,'eRs1amRGukr27KvyZwtmqAI6.jpg','upload/eRs1amRGukr27KvyZwtmqAI6.jpg','image/jpeg',49943,1547601699,1547601699);
#
# Structure for table "footer_1"
#
CREATE TABLE `footer_1` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`display_position` enum('left','center','right') NOT NULL DEFAULT 'center' COMMENT '展示位置',
`link_txt` blob NOT NULL COMMENT '可以是富文本连接的内容',
`link_url` varchar(255) DEFAULT NULL COMMENT '导航链接',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='最底部页脚信息';
#
# Data for table "footer_1"
#
REPLACE INTO `footer_1` VALUES (1,'left',X'3C703E3230313820C2A920E6B5B7E58D97E699BAE68A95E7BD91E7BB9CE7A791E68A80E69C89E99990E585ACE58FB83C2F703E',' /',1544696203),(2,'center',X'3C64697620636C6173733D226C6963656E73654E756D626572223EE790BC4943502D313730303031307878783C2F6469763E',NULL,1544696203),(3,'right',X'3C66696775726520636C6173733D22696D616765223E3C696D67207372633D222E2E2F61737365742F49436C6F676F2E706E672220616C743D22223E3C2F6669677572653E3C756C3E3C6C693E3C6120687265663D2223223EE4BDBFE794A8E69DA1E6ACBE3C2F613E3C2F6C693E3C6C693E3C6120687265663D2223223EE99A90E7A781E4BF9DE68AA43C2F613E3C2F6C693E3C2F756C3E','#',1544696203);
#
# Structure for table "footer_2"
#
CREATE TABLE `footer_2` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`col_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分组栏目id',
`col_title` varchar(255) NOT NULL DEFAULT '' COMMENT '分栏标题',
`link_txt` varchar(255) DEFAULT NULL COMMENT '链接文字',
`link_url` varchar(255) DEFAULT NULL COMMENT '链接',
`weight` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '权重-用于排序展示',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='页脚信息,倒数第二块页脚信息';
#
# Data for table "footer_2"
#
REPLACE INTO `footer_2` VALUES (19,9,'小程序开发','微信小程序','/article?id=33',1,1547459917),(20,9,'小程序开发','百度小程序','/article?id=34',2,1547459927),(21,9,'小程序开发','支付宝小程序','/article?id=35',3,1547459943),(22,10,'app开发','ios开发','/article?id=38',1,1547459977),(23,10,'app开发','安卓开发','/article?id=37',2,1547459989),(24,11,'加入我们','校园招聘','/recruits',1,1547459997),(25,11,'加入我们','社会招聘','/recruits',2,1547460007),(26,12,'联系我们','联系电话:0898','#',1,1547460026),(27,12,'联系我们','我们的地址:xxxx','#',2,1547460053),(28,13,'服务支持','咨询信息','/consult',0,1547535288);
#
# Structure for table "footer_2_col"
#
CREATE TABLE `footer_2_col` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '分栏id',
`col_title` varchar(255) NOT NULL DEFAULT '' COMMENT '分栏标题',
`weight` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '权重,用于排序先后顺序',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='页脚分栏信息';
#
# Data for table "footer_2_col"
#
REPLACE INTO `footer_2_col` VALUES (9,'小程序开发',1,1547459868),(10,'app开发',2,1547459876),(11,'加入我们',3,1547459896),(12,'联系我们',5,1547459904),(13,'服务支持',4,1547535133);
#
# Structure for table "nav"
#
CREATE TABLE `nav` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`parent_nav_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id,一级菜单此段为0',
`title` varchar(20) NOT NULL DEFAULT '' COMMENT '标题-显示的文字',
`is_show` char(1) NOT NULL DEFAULT '1' COMMENT '是否显示【0-1】',
`level` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序使用,先后顺序',
`link_url` varchar(255) NOT NULL DEFAULT '/' COMMENT '连接,有子菜单可以不设置',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='导航菜单';
#
# Data for table "nav"
#
REPLACE INTO `nav` VALUES (18,0,'小程序开发','1',1,'article/list?category_id=1',0),(21,0,'app开发','1',2,'article/list?category_id=2',0),(24,18,'微信小程序开发','1',1,'/article?id=33',0),(25,18,'百度小程序开发','1',2,'/article?id=34',0),(26,18,'支付宝小程序开发','1',3,'/article?id=35',0),(27,21,'安卓开发','1',1,'/article?id=37',0),(28,21,'iOS开发','1',2,'/article?id=38',0),(29,21,'手机H5开发','1',0,'/',0),(30,0,'首页','1',0,'/#',0),(31,0,'关于我们','1',4,'/about',0),(32,123,'标题','1',0,'/',0);
#
# Structure for table "recruit"
#
CREATE TABLE `recruit` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录id',
`job` varchar(60) NOT NULL DEFAULT '' COMMENT '职位-60字符限制',
`recruit_type_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '招聘类型分类id',
`recruit_type` varchar(60) NOT NULL DEFAULT '' COMMENT '招聘类型',
`job_nature` varchar(30) NOT NULL DEFAULT '全职' COMMENT '工作类型',
`salary` varchar(60) NOT NULL DEFAULT '面议' COMMENT '薪资范围',
`num` varchar(10) NOT NULL DEFAULT '若干' COMMENT '招聘人数',
`work_at` varchar(60) NOT NULL DEFAULT '全国' COMMENT '工作地点',
`skill_requirement` blob NOT NULL COMMENT '职位技能要求',
`published_at` date DEFAULT NULL COMMENT '发布时间',
`expired_at` date DEFAULT NULL COMMENT '岗位截止日期,有效期',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='招聘信息jobs';
#
# Data for table "recruit"
#
REPLACE INTO `recruit` VALUES (7,'PHP高级工程师',9,'社会招聘','全职','面议','1','海口',X'3C703E31E38081E4B880E5B9B4E4BBA5E4B88A706870E5BC80E58F91E7BB8FE9AA8CEFBC8CE5ADA6E4B9A0E883BDE58A9BE5BCBAE4B88AE6898BE5BFABEFBC8CE8AEA1E7AE97E69CBAE79BB8E585B3E4B893E4B89AEFBC9B3C62723E32E38081E69C89E889AFE5A5BDE79A84E7BC96E7A88BE4B9A0E683AFE5928CE68A80E69CAFE69687E6A1A3E7BC96E58699E4B9A0E683AFEFBC9B3C62723E33E38081E7869FE7BB83E68E8CE68FA15048502B4D7953514CE7BC96E7A88BEFBC8CE7869FE6828948544D4CE380814A617661736372697074E38081435353EFBC8CE887B3E5B091E7869FE7BB83E4BDBFE794A84A51E5BA93EFBC9B3C62723E34E38081E7869FE68289E695B0E68DAEE5BA93E8AEBEE8AEA1EFBC8CE7869FE682894E67696E782B5048502B4D7953514CE9858DE7BDAEE88085E4BC98E58588EFBC9B3C62723E35E38081E7869FE7BB83E68E8CE68FA17265616374E38081767565E380817265646973E88085E4BC98E58588EFBC9B3C62723E36E38081E7869FE68289536C696DE3808153796D666F6E79E380814349E7AD89706870E5BC80E58F91E6A186E69EB6E88085E4BC98E58588EFBC9B3C62723E37E38081E69C89E5A4A7E59E8BE7BD91E7AB99E5BC80E58F91E7BB8FE9AA8CE88085E4BC98E58588EFBC8CE58F82E4B88EE8BF87E5BC80E6BA90E9A1B9E79BAEE88085E4BC98E58588EFBC9B3C62723E38E38081E4BC9AE4BDBFE794A8676974E58D8FE5908CE5BC80E58F91E5B7A5E585B7EFBC9B3C62723EE5B7A5E4BD9CE697B6E997B4EFBC9AE58F8CE4BC91EFBC8CE4BAABE58F97E59BBDE5AEB6E8A784E5AE9AE88A82E58187E697A5EFBC8CE883BDE68EA5E58F97E98082E5BD93E58AA0E78FAD3C2F703E','2019-01-14','2019-02-07',1547457189,1547457189),(8,'android开发工程师',9,'社会招聘','全职','面议','2','海口',X'3C703E31E3808131E5B9B4E58F8AE4BBA5E4B88A416E64726F6964E5BC80E58F91E5B7A5E4BD9CE7BB8FE9AA8CEFBC9B3C62723E32E38081416E64726F6964E5BC80E58F91E59FBAE7A180E6898EE5AE9EEFBC9B3C62723E33E38081E7869FE6828948544D4CE380814A617661736372697074E38081435353E7AD89E5898DE7ABAFE79FA5E8AF86EFBC9B3C62723E34E38081E5ADA6E4B9A0E883BDE58A9BE5BCBAEFBC8CE6809DE7BBB4E6B4BBE8B783EFBC8CE68EA5E58F97E696B0E4BA8BE789A9E883BDE58A9BE5BCBAEFBC9B3C62723E35E38081E7869FE7BB83E68E8CE68FA1E5AE89E58D93E69EB6E69E84E5928CE59FBAE69CACE5AE89E58D93E68EA7E4BBB6E79A84E4BDBFE794A8EFBC8CE7869FE68289E59FBAE4BA8E41444BE5928C4E444BE79A84E5BC80E58F91E6B581E7A88BEFBC9B3C62723E36E38081E8AFADE8A880E59FBAE7A180E79FA5E8AF86E6898EE5AE9EEFBC8CE69C894F4F50E6809DE683B3EFBC8CE7869FE68289E5B8B8E794A8E8AEBEE8AEA1E6A8A1E5BC8FEFBC9B3C62723E37E38081E69C895048502F507974686F6EE5908EE7ABAFE5BC80E58F91E7BB8FE9AA8CE88085E4BC98E58588EFBC9B3C62723E38E38081E69C89E5AE8CE695B4E79A84415050E4BAA7E59381E5BC80E58F91E7BB8FE9AA8CEFBC8CE4B8BBE5AFBCE68896E58F82E4B88EE8BF87E6ADA3E5BC8FE58F91E5B883E4B88AE7BABFE79A84617070E88085E4BC98E58588EFBC9B3C2F703E','2019-01-14','2019-02-28',1550547281,1547457235),(9,'python开发工程师',9,'社会招聘','全职','面议','1','海口',X'3C703E266E6273703B3C2F703E','2019-02-05','2019-02-19',1550547329,1550547329);
#
# Structure for table "recruit_types"
#
CREATE TABLE `recruit_types` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '类型id',
`o_type` varchar(60) NOT NULL DEFAULT '' COMMENT '招聘类型-校招,社招...',
`cnt` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '该分类职位数量',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近编辑',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='招聘类型表';
#
# Data for table "recruit_types"
#
REPLACE INTO `recruit_types` VALUES (8,'校园招聘',1,1547457273,1547457015),(9,'社会招聘',4,1550628774,1547457022),(10,'合伙人招聘',1,1550629460,1550629460),(11,'管理层招聘',2,1550741100,1550630255);
#
# Structure for table "security_code"
#
CREATE TABLE `security_code` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`security_code` varchar(6) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
`expired` int(11) NOT NULL DEFAULT '0',
`created_at` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='验证码表';
#
# Data for table "security_code"
#
#
# Structure for table "session"
#
CREATE TABLE `session` (
`id` varchar(255) NOT NULL DEFAULT '' COMMENT '记录id',
`userinfo` blob NOT NULL COMMENT '用户信息',
`expired` int(11) NOT NULL DEFAULT '0' COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='session表';
#
# Data for table "session"
#
#
# Structure for table "user"
#
CREATE TABLE `user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
`avatar` varchar(255) DEFAULT NULL COMMENT '头像连接',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名-20字符',
`email` varchar(120) NOT NULL DEFAULT '' COMMENT '邮箱地址-120字符',
`phone` varchar(15) NOT NULL DEFAULT '' COMMENT '手机号',
`sex` int(1) NOT NULL DEFAULT '1' COMMENT '性别',
`password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
`role_level` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '角色权限等级',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近更新',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户表';
#
# Data for table "user"
#
REPLACE INTO `user` VALUES (1,'http://g.hiphotos.baidu.com/zhidao/pic/item/8c1001e93901213fce85790251e736d12e2e95bd.jpg','刘强东','jdstore@163.com','18889887888',1,'251f2bd295d258d95ee77b63d7d3dce6',0,1547024876,1888988788),(2,'http://localhost:9090/upload/eRs1amRGukr27KvyZwtmqAI5.jpg','Lu','895873165@qq.com','16666666666',1,'251f2bd295d258d95ee77b63d7d3dce6',1,1550740293,1546666913);
#
# Structure for table "slide"
#
CREATE TABLE `slide` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`image` varchar(255) NOT NULL DEFAULT '' COMMENT '幻灯片连接地址',
`title` varchar(120) DEFAULT NULL COMMENT '标题-120字符',
`link_url` varchar(255) NOT NULL DEFAULT '' COMMENT '重定向地址',
`remark` varchar(255) DEFAULT NULL COMMENT '备注,描述',
`weight` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '权重,用于排序',
`is_show` char(1) NOT NULL DEFAULT '1' COMMENT '是否展示0-1',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建管理者id',
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近更新',
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建记录时间',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
CONSTRAINT `slide_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='幻灯片';
#
# Data for table "slide"
#
REPLACE INTO `slide` VALUES (1,'http://localhost:9090/upload/CXF7tmeQm691ymTwBvhTRTGw.jpg',NULL,'article?id=33','(可选)',1,'1',2,1547530503,1547520072),(2,'http://localhost:9090/upload/aGbQu2eIpFRDVOXfZ8CfS11e.jpg',NULL,'#','(可选)',1,'1',2,1547521288,1547521288),(3,'http://localhost:9090/upload/OpQnk6wWGUobRUoMeRRrpLwL.jpg',NULL,'/article?id=37','(可选)',1,'1',2,1547530481,1547522565),(4,'http://localhost:9090/upload/HJNYXoHCCn78QMd5Gafrt5v.jpg',NULL,'/article?id=38','(可选)',1,'1',2,1547530456,1547522586),(5,'http://localhost:9090/upload/bNZYbjJ564zbPS7S4R8C1609.jpg',NULL,'/','(可选)',2,'1',2,1550740519,1547522605);
#
# Trigger "trig_delete"
#
CREATE TRIGGER `trig_delete` AFTER DELETE ON `recruit` FOR EACH ROW BEGIN
UPDATE `recruit_types` SET `cnt` = `cnt` - 1 WHERE `id` = OLD.recruit_type_id;
END;
#
# Trigger "trig_insert"
#
CREATE TRIGGER `trig_insert` AFTER INSERT ON `recruit` FOR EACH ROW BEGIN
UPDATE `recruit_types` SET `cnt` = `cnt` + 1 WHERE `id` = NEW.recruit_type_id;
END;
#
# Trigger "trig_update"
#
CREATE TRIGGER `trig_update` AFTER UPDATE ON `recruit` FOR EACH ROW BEGIN
UPDATE `recruit_types` SET `cnt` = `cnt` - 1 WHERE `id` = OLD.recruit_type_id;
UPDATE `recruit_types` SET `cnt` = `cnt` + 1 WHERE `id` = NEW.recruit_type_id;
END;
PHP
1
https://gitee.com/dingdang-software/wocms.git
git@gitee.com:dingdang-software/wocms.git
dingdang-software
wocms
wocms
master

搜索帮助