/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : sql58zufang_che

Target Server Type    : MYSQL
Target Server Version : 50553
File Encoding         : 65001

Date: 2019-02-12 11:12:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admins`
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_pass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of admins
-- ----------------------------
INSERT INTO `admins` VALUES ('1', 'admin', 'eyJpdiI6ImtydGhHVUtIbFQyKzFmQWI1UWV3WlE9PSIsInZhbHVlIjoiVFMwbFdjdGZLXC9MS3hkaHV5TnRiQ2c9PSIsIm1hYyI6IjY2OTNjMzA2OTdmMTUzMmI5ZWRhMWI2YmQ1NWRmZjMwOGI0ZjQ1NGFjM2QwZTFiNWRlOGVhZjMzZjlhOTJmNDEifQ==');

-- ----------------------------
-- Table structure for `ads`
-- ----------------------------
DROP TABLE IF EXISTS `ads`;
CREATE TABLE `ads` (
  `ad_id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_content` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ad_status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of ads
-- ----------------------------
INSERT INTO `ads` VALUES ('1', '网站上线了', '1');
INSERT INTO `ads` VALUES ('7', '网站测试中', '1');

-- ----------------------------
-- Table structure for `area`
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `area_id` int(11) NOT NULL AUTO_INCREMENT,
  `area_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '区域名称',
  `updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改时间',
  `created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `is_del` int(11) DEFAULT '0',
  PRIMARY KEY (`area_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('1', '章贡区', '2018-09-26 14:19:57', null, '0');
INSERT INTO `area` VALUES ('2', '开发区', '2018-09-26 14:20:01', null, '0');
INSERT INTO `area` VALUES ('3', '榕江新区', '2018-09-26 14:21:08', null, '0');
INSERT INTO `area` VALUES ('4', '赣县区', '2018-09-26 14:20:12', null, '0');
INSERT INTO `area` VALUES ('5', '南康区', '2018-09-26 14:29:33', null, '0');

-- ----------------------------
-- Table structure for `banner`
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `banner_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `carousel_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `carousel_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `carousel_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`banner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of banner
-- ----------------------------
INSERT INTO `banner` VALUES ('1', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/8omxi20170809102606.jpg', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/vm36p20170809011145.png', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/ou5d220170823015458.jpg', '[\"1\",\"2\",\"3\",\"4\",\"5\"]');

-- ----------------------------
-- Table structure for `bannerpcs`
-- ----------------------------
DROP TABLE IF EXISTS `bannerpcs`;
CREATE TABLE `bannerpcs` (
  `bannerpc_id` int(11) NOT NULL AUTO_INCREMENT,
  `bannerpc_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bannerpc_cover` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bannerpc_status` tinyint(2) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`bannerpc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of bannerpcs
-- ----------------------------
INSERT INTO `bannerpcs` VALUES ('8', null, 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/2ifsd20180818132053.jpg', '1', '2018-08-18 13:20:54', '2018-08-18 13:20:54');
INSERT INTO `bannerpcs` VALUES ('5', null, 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/ho3au20180818132050.jpg', '1', '2018-08-18 13:20:50', '2018-08-18 13:20:50');
INSERT INTO `bannerpcs` VALUES ('9', null, 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/o4pz720180818132058.png', '1', '2018-08-18 13:20:59', '2018-08-18 13:20:59');
INSERT INTO `bannerpcs` VALUES ('10', null, 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/ko2a320180823233349.jpg', '1', '2018-08-23 23:33:49', '2018-08-23 23:33:49');

-- ----------------------------
-- Table structure for `banners`
-- ----------------------------
DROP TABLE IF EXISTS `banners`;
CREATE TABLE `banners` (
  `banner_id` int(11) NOT NULL AUTO_INCREMENT,
  `banner_cover` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `banner_status` tinyint(2) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`banner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of banners
-- ----------------------------
INSERT INTO `banners` VALUES ('9', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/fyh.chengguo.link/jrg1o20181007083148.jpg', '1', '2018-10-07 08:32:49', '2018-10-07 08:32:49');
INSERT INTO `banners` VALUES ('7', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/fyh.chengguo.link/gmdu220181008005108.jpg', '1', '2018-10-08 00:51:10', '2018-10-08 00:51:10');

-- ----------------------------
-- Table structure for `brand_cates`
-- ----------------------------
DROP TABLE IF EXISTS `brand_cates`;
CREATE TABLE `brand_cates` (
  `cate_id` tinyint(2) NOT NULL AUTO_INCREMENT,
  `cate_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`cate_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of brand_cates
-- ----------------------------
INSERT INTO `brand_cates` VALUES ('1', '企业客户');
INSERT INTO `brand_cates` VALUES ('2', '政府机构');

-- ----------------------------
-- Table structure for `business`
-- ----------------------------
DROP TABLE IF EXISTS `business`;
CREATE TABLE `business` (
  `busines_id` int(11) NOT NULL AUTO_INCREMENT,
  `busines_name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `busines_sort` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`busines_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of business
-- ----------------------------
INSERT INTO `business` VALUES ('1', 'APP开发', '1');
INSERT INTO `business` VALUES ('2', '小程序开发', '4');
INSERT INTO `business` VALUES ('3', '微信开发', '3');
INSERT INTO `business` VALUES ('4', '网站开发', '5');
INSERT INTO `business` VALUES ('5', '软件开发', '5');
INSERT INTO `business` VALUES ('6', '运营推广', '6');

-- ----------------------------
-- Table structure for `caselist`
-- ----------------------------
DROP TABLE IF EXISTS `caselist`;
CREATE TABLE `caselist` (
  `new_id` int(11) NOT NULL AUTO_INCREMENT,
  `new_editor` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `new_keyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_content` longtext COLLATE utf8_unicode_ci,
  `new_view_count` int(255) DEFAULT NULL,
  `new_status` tinyint(4) DEFAULT '1',
  `new_cate` tinyint(4) DEFAULT NULL,
  `new_created_at` timestamp NULL DEFAULT NULL,
  `new_updated_at` timestamp NULL DEFAULT NULL,
  `new_deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`new_id`)
) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of caselist
-- ----------------------------

-- ----------------------------
-- Table structure for `case_categorys`
-- ----------------------------
DROP TABLE IF EXISTS `case_categorys`;
CREATE TABLE `case_categorys` (
  `cate_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `cate_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`cate_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of case_categorys
-- ----------------------------
INSERT INTO `case_categorys` VALUES ('1', '高端网站建设');
INSERT INTO `case_categorys` VALUES ('2', 'APP开发（安卓&苹果）');
INSERT INTO `case_categorys` VALUES ('3', '微信小程序&公众号');
INSERT INTO `case_categorys` VALUES ('4', '电商与大型门户');

-- ----------------------------
-- Table structure for `categorys`
-- ----------------------------
DROP TABLE IF EXISTS `categorys`;
CREATE TABLE `categorys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of categorys
-- ----------------------------
INSERT INTO `categorys` VALUES ('1', '0', '33', '赣州市', '', null, null, null);

-- ----------------------------
-- Table structure for `company`
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `company_id` int(1) NOT NULL AUTO_INCREMENT,
  `company_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_desc` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`company_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('1', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/fyh.chengguo.link/az3ek20181008015605.png', '58租房，经营范围为企业投资信息咨询服务、房地产销售代理、房地产销售顾问、房地产租赁咨询服务、房地产投资策划，公司本着“诚信规范，专业高效”的经营理念，并以“给您一个梦想的家”为终极目标。\r\n\r\n目前在赣州已开设公园壹号旗舰店、路福分店、迎宾大道分店、瑞安分店、中洋·公园首府店、九方店、水韵嘉城店、御景江山店、时间公园店、宏嘉分店、中海店、中海锦园店、中央城店、中洋公园首府店、万盛店、盛世江南店、金丰店、紫金店等多家门店，门店版图正在进一步扩张中……\r\n\r\n公司非常重视人才的培养，本着以人为本，知人善用，业绩主导，诚信为先的原则，公司将人才的培养与发展作为公司战略进行规划，挖掘人的潜能，为充满激情和理想的员工提供广阔的舞台和空间，实现员工和企业的共同成长。');

-- ----------------------------
-- Table structure for `cooperates`
-- ----------------------------
DROP TABLE IF EXISTS `cooperates`;
CREATE TABLE `cooperates` (
  `coo_id` int(11) NOT NULL AUTO_INCREMENT,
  `coo_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `coo_logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `coo_title` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `coo_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`coo_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of cooperates
-- ----------------------------
INSERT INTO `cooperates` VALUES ('1', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/d60mv20170802195507.png', null, null, null);
INSERT INTO `cooperates` VALUES ('2', null, 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/8aw9320170918112418.png', '商务合作', '互联网让生活更便捷，您刚好需要，我们正好专业');
INSERT INTO `cooperates` VALUES ('3', null, 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/srhe620170918112539.png', '媒体合作', '欢迎各自媒体与传统媒体网站门户论坛合作交流');
INSERT INTO `cooperates` VALUES ('4', null, 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/xio2j20170918112555.png', '品牌合作', '欢迎业内同行及异业品牌合作交流，强强结合，优劣互补');
INSERT INTO `cooperates` VALUES ('5', null, 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/atbvr20170918112611.png', '推广合作', '欢迎各品牌网站代理及网络联盟洽谈广告推广合作');

-- ----------------------------
-- Table structure for `co_brands`
-- ----------------------------
DROP TABLE IF EXISTS `co_brands`;
CREATE TABLE `co_brands` (
  `brand_id` int(11) NOT NULL AUTO_INCREMENT,
  `brand_logo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `brand_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `brand_order` tinyint(4) NOT NULL DEFAULT '0',
  `brand_status` tinyint(2) NOT NULL DEFAULT '1',
  `brand_cate` tinyint(2) NOT NULL DEFAULT '1',
  `brand_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`brand_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of co_brands
-- ----------------------------

-- ----------------------------
-- Table structure for `customers`
-- ----------------------------
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `job` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `tel` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tags` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `desc` varchar(1000) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of customers
-- ----------------------------
INSERT INTO `customers` VALUES ('1', '曾荣辉', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/teams/zengronghui.png', '商务顾问', '18720783525', '产品经验丰富，解答清晰', '以诚待人，以毅做事。');
INSERT INTO `customers` VALUES ('2', '李       忠', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/1tfla20171117153031.png', '商务顾问', '18970130703', '知识丰富全面，耐心沉稳', null);
INSERT INTO `customers` VALUES ('3', '李樱', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/yji1320180614221958.png', '商务顾问', '13367076864', '细致认真，真诚友善', '心无谦卑日伴高莫助，胸无大愿遍寻高人不得。');
INSERT INTO `customers` VALUES ('4', '黄秀发', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/miyqd20180617001542.png', '招商经理', '13367074770', '诚信待人，用心做事', '诚信是为人之本，用心是成功之母');
INSERT INTO `customers` VALUES ('5', '易祖伯', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/fh6wm20180614222013.png', '产品经理', '13367074725', '产品开发经验丰富，思维清晰', '多年在沿海城市负责产品开发与团队管理，经验丰富，技术先进。');

-- ----------------------------
-- Table structure for `forward`
-- ----------------------------
DROP TABLE IF EXISTS `forward`;
CREATE TABLE `forward` (
  `fuser_id` int(11) NOT NULL COMMENT '加入的用户id',
  `user_id` int(11) NOT NULL COMMENT '谁推荐的用户id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of forward
-- ----------------------------
INSERT INTO `forward` VALUES ('305', '203', '2018-08-22 18:36:36', '0000-00-00 00:00:00', '8');
INSERT INTO `forward` VALUES ('306', '203', '2018-08-22 18:39:06', '0000-00-00 00:00:00', '9');
INSERT INTO `forward` VALUES ('307', '203', '2018-08-22 19:21:00', '0000-00-00 00:00:00', '13');
INSERT INTO `forward` VALUES ('310', '203', '2018-08-23 07:04:19', '0000-00-00 00:00:00', '14');
INSERT INTO `forward` VALUES ('311', '288', '2018-08-23 10:45:02', '0000-00-00 00:00:00', '16');
INSERT INTO `forward` VALUES ('312', '203', '2018-08-23 14:17:28', '0000-00-00 00:00:00', '17');
INSERT INTO `forward` VALUES ('313', '203', '2018-08-23 21:33:32', '0000-00-00 00:00:00', '18');
INSERT INTO `forward` VALUES ('314', '307', '2018-08-24 09:27:43', '0000-00-00 00:00:00', '19');
INSERT INTO `forward` VALUES ('315', '314', '2018-08-24 09:28:32', '0000-00-00 00:00:00', '20');
INSERT INTO `forward` VALUES ('317', '219', '2018-08-24 18:20:45', '0000-00-00 00:00:00', '21');
INSERT INTO `forward` VALUES ('288', '203', '2018-08-24 18:57:37', '0000-00-00 00:00:00', '22');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-24 18:57:53', '0000-00-00 00:00:00', '23');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-24 19:01:30', '0000-00-00 00:00:00', '24');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-24 19:01:36', '0000-00-00 00:00:00', '25');
INSERT INTO `forward` VALUES ('318', '219', '2018-08-24 19:34:12', '0000-00-00 00:00:00', '26');
INSERT INTO `forward` VALUES ('319', '219', '2018-08-24 19:35:34', '0000-00-00 00:00:00', '27');
INSERT INTO `forward` VALUES ('320', '219', '2018-08-24 20:34:02', '0000-00-00 00:00:00', '28');
INSERT INTO `forward` VALUES ('320', '219', '2018-08-24 20:37:51', '0000-00-00 00:00:00', '29');
INSERT INTO `forward` VALUES ('320', '219', '2018-08-24 20:38:42', '0000-00-00 00:00:00', '30');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-24 21:03:19', '0000-00-00 00:00:00', '31');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-24 21:25:36', '0000-00-00 00:00:00', '32');
INSERT INTO `forward` VALUES ('219', '203', '2018-08-24 21:30:01', '0000-00-00 00:00:00', '33');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-24 21:33:22', '0000-00-00 00:00:00', '34');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-24 21:36:04', '0000-00-00 00:00:00', '35');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 13:16:27', '0000-00-00 00:00:00', '36');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 13:19:08', '0000-00-00 00:00:00', '37');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 13:21:03', '0000-00-00 00:00:00', '38');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 13:21:33', '0000-00-00 00:00:00', '39');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 13:22:40', '0000-00-00 00:00:00', '40');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 16:54:52', '0000-00-00 00:00:00', '41');
INSERT INTO `forward` VALUES ('326', '203', '2018-08-25 16:55:24', '0000-00-00 00:00:00', '42');
INSERT INTO `forward` VALUES ('327', '203', '2018-08-25 16:56:36', '0000-00-00 00:00:00', '43');
INSERT INTO `forward` VALUES ('329', '203', '2018-08-25 17:04:09', '0000-00-00 00:00:00', '44');
INSERT INTO `forward` VALUES ('219', '203', '2018-08-25 17:06:25', '0000-00-00 00:00:00', '45');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 17:19:59', '0000-00-00 00:00:00', '46');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 17:20:07', '0000-00-00 00:00:00', '47');
INSERT INTO `forward` VALUES ('330', '203', '2018-08-25 18:24:38', '0000-00-00 00:00:00', '48');
INSERT INTO `forward` VALUES ('331', '203', '2018-08-25 19:08:08', '0000-00-00 00:00:00', '49');
INSERT INTO `forward` VALUES ('331', '203', '2018-08-25 19:08:10', '0000-00-00 00:00:00', '50');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 20:16:06', '0000-00-00 00:00:00', '51');
INSERT INTO `forward` VALUES ('332', '203', '2018-08-25 20:21:55', '0000-00-00 00:00:00', '52');
INSERT INTO `forward` VALUES ('332', '203', '2018-08-25 20:21:58', '0000-00-00 00:00:00', '53');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-25 23:05:25', '0000-00-00 00:00:00', '54');
INSERT INTO `forward` VALUES ('319', '219', '2018-08-26 17:54:35', '0000-00-00 00:00:00', '55');
INSERT INTO `forward` VALUES ('319', '219', '2018-08-26 17:54:49', '0000-00-00 00:00:00', '56');
INSERT INTO `forward` VALUES ('203', '203', '2018-08-27 06:13:52', '0000-00-00 00:00:00', '57');
INSERT INTO `forward` VALUES ('334', '301', '2018-08-28 14:54:20', '0000-00-00 00:00:00', '58');
INSERT INTO `forward` VALUES ('334', '301', '2018-08-28 14:55:14', '0000-00-00 00:00:00', '59');
INSERT INTO `forward` VALUES ('337', '203', '2018-08-28 18:43:03', '0000-00-00 00:00:00', '60');
INSERT INTO `forward` VALUES ('340', '203', '2018-08-30 13:26:35', '0000-00-00 00:00:00', '61');
INSERT INTO `forward` VALUES ('218', '218', '2018-09-01 14:09:38', '0000-00-00 00:00:00', '62');
INSERT INTO `forward` VALUES ('343', '218', '2018-09-01 14:26:06', '0000-00-00 00:00:00', '63');
INSERT INTO `forward` VALUES ('343', '218', '2018-09-01 14:26:06', '0000-00-00 00:00:00', '64');
INSERT INTO `forward` VALUES ('343', '218', '2018-09-01 14:26:07', '0000-00-00 00:00:00', '65');
INSERT INTO `forward` VALUES ('218', '218', '2018-09-01 15:04:41', '0000-00-00 00:00:00', '66');
INSERT INTO `forward` VALUES ('347', '203', '2018-09-03 07:49:16', '0000-00-00 00:00:00', '67');
INSERT INTO `forward` VALUES ('349', '218', '2018-09-03 11:07:06', '0000-00-00 00:00:00', '68');
INSERT INTO `forward` VALUES ('278', '219', '2018-09-04 15:32:40', '0000-00-00 00:00:00', '69');
INSERT INTO `forward` VALUES ('203', '203', '2018-09-04 18:18:02', '0000-00-00 00:00:00', '70');
INSERT INTO `forward` VALUES ('203', '203', '2018-09-04 18:19:15', '0000-00-00 00:00:00', '71');
INSERT INTO `forward` VALUES ('350', '203', '2018-09-04 20:04:02', '0000-00-00 00:00:00', '72');
INSERT INTO `forward` VALUES ('350', '203', '2018-09-04 20:04:27', '0000-00-00 00:00:00', '73');
INSERT INTO `forward` VALUES ('315', '314', '2018-09-06 09:48:05', '0000-00-00 00:00:00', '74');
INSERT INTO `forward` VALUES ('315', '314', '2018-09-06 14:38:23', '0000-00-00 00:00:00', '75');
INSERT INTO `forward` VALUES ('353', '219', '2018-09-06 16:26:40', '0000-00-00 00:00:00', '76');
INSERT INTO `forward` VALUES ('354', '218', '2018-09-06 22:24:43', '0000-00-00 00:00:00', '77');
INSERT INTO `forward` VALUES ('355', '218', '2018-09-07 13:22:49', '0000-00-00 00:00:00', '78');
INSERT INTO `forward` VALUES ('355', '218', '2018-09-07 13:23:14', '0000-00-00 00:00:00', '79');
INSERT INTO `forward` VALUES ('354', '218', '2018-09-07 14:22:33', '0000-00-00 00:00:00', '80');
INSERT INTO `forward` VALUES ('293', '219', '2018-09-08 09:11:08', '0000-00-00 00:00:00', '81');
INSERT INTO `forward` VALUES ('293', '219', '2018-09-08 09:11:19', '0000-00-00 00:00:00', '82');
INSERT INTO `forward` VALUES ('339', '203', '2018-09-08 10:37:17', '0000-00-00 00:00:00', '83');
INSERT INTO `forward` VALUES ('218', '203', '2018-09-08 10:40:58', '0000-00-00 00:00:00', '84');
INSERT INTO `forward` VALUES ('203', '203', '2018-09-08 10:54:26', '0000-00-00 00:00:00', '85');
INSERT INTO `forward` VALUES ('203', '203', '2018-09-08 10:59:15', '0000-00-00 00:00:00', '86');
INSERT INTO `forward` VALUES ('248', '203', '2018-09-08 12:00:48', '0000-00-00 00:00:00', '87');
INSERT INTO `forward` VALUES ('203', '203', '2018-09-08 14:37:38', '0000-00-00 00:00:00', '88');
INSERT INTO `forward` VALUES ('203', '203', '2018-09-12 22:54:54', '0000-00-00 00:00:00', '89');

-- ----------------------------
-- Table structure for `friends`
-- ----------------------------
DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
  `friend_id` int(11) NOT NULL AUTO_INCREMENT,
  `friend_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `friend_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `friend_status` int(10) DEFAULT NULL,
  `friend_created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `friend_updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `friend_sort` int(255) DEFAULT NULL,
  PRIMARY KEY (`friend_id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of friends
-- ----------------------------
INSERT INTO `friends` VALUES ('20', '赣州APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:13:18', '2018-08-22 11:13:18', '50');
INSERT INTO `friends` VALUES ('18', '赣州网站建设', 'http://www.gzchengguo.cn/', null, '2018-08-22 10:57:38', '2018-08-22 10:57:38', '50');
INSERT INTO `friends` VALUES ('33', '深圳APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:48:03', '2018-08-30 18:48:03', '50');
INSERT INTO `friends` VALUES ('21', '厦门APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:13:28', '2018-08-22 11:13:28', '50');
INSERT INTO `friends` VALUES ('22', '九江APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:13:40', '2018-08-22 11:13:40', '50');
INSERT INTO `friends` VALUES ('23', '南昌APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:13:50', '2018-08-22 11:13:50', '50');
INSERT INTO `friends` VALUES ('24', '赣州小程序开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:14:00', '2018-08-22 11:14:00', '50');
INSERT INTO `friends` VALUES ('25', '厦门小程序开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:14:12', '2018-08-22 11:14:12', '50');
INSERT INTO `friends` VALUES ('26', '南昌小程序开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:14:22', '2018-08-22 11:14:22', '50');
INSERT INTO `friends` VALUES ('27', '九江小程序开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:14:33', '2018-08-22 11:14:33', '50');
INSERT INTO `friends` VALUES ('28', '赣州商城开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:15:17', '2018-08-22 11:15:17', '50');
INSERT INTO `friends` VALUES ('29', '厦门商城开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:15:28', '2018-08-22 11:15:28', '50');
INSERT INTO `friends` VALUES ('30', '赣州软件开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:15:36', '2018-08-22 11:15:36', '50');
INSERT INTO `friends` VALUES ('31', '九江软件开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:15:46', '2018-08-22 11:15:46', '50');
INSERT INTO `friends` VALUES ('32', '北京软件开发', 'http://www.gzchengguo.cn/', null, '2018-08-22 11:15:59', '2018-08-22 11:15:59', '50');
INSERT INTO `friends` VALUES ('34', '深圳小程序开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:48:13', '2018-08-30 18:48:13', '50');
INSERT INTO `friends` VALUES ('35', '吉安APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:48:25', '2018-08-30 18:48:25', '50');
INSERT INTO `friends` VALUES ('36', '南昌APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:48:34', '2018-08-30 18:48:34', '50');
INSERT INTO `friends` VALUES ('37', '抚州APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:48:46', '2018-08-30 18:48:46', '50');
INSERT INTO `friends` VALUES ('38', '上饶APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:48:57', '2018-08-30 18:48:57', '50');
INSERT INTO `friends` VALUES ('39', '南昌小程序开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:49:08', '2018-08-30 18:49:08', '50');
INSERT INTO `friends` VALUES ('40', '石城APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:49:42', '2018-08-30 18:49:42', '50');
INSERT INTO `friends` VALUES ('41', '于都APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:49:52', '2018-08-30 18:49:52', '50');
INSERT INTO `friends` VALUES ('42', '上犹APP开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:50:06', '2018-08-30 18:50:06', '50');
INSERT INTO `friends` VALUES ('43', '寻乌网站开发', 'http://www.gzchengguo.cn/', null, '2018-08-30 18:50:17', '2018-08-30 18:50:17', '50');

-- ----------------------------
-- Table structure for `huxing`
-- ----------------------------
DROP TABLE IF EXISTS `huxing`;
CREATE TABLE `huxing` (
  `huxing_id` int(11) NOT NULL AUTO_INCREMENT,
  `huxing_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改时间',
  `created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `is_del` int(11) DEFAULT '0',
  PRIMARY KEY (`huxing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of huxing
-- ----------------------------
INSERT INTO `huxing` VALUES ('1', '一室', '2018-09-26 14:41:57', null, '0');
INSERT INTO `huxing` VALUES ('2', '二室', '2018-09-26 14:51:42', null, '0');

-- ----------------------------
-- Table structure for `imgaes`
-- ----------------------------
DROP TABLE IF EXISTS `imgaes`;
CREATE TABLE `imgaes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imgurl` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `nav_id` varchar(255) CHARACTER SET utf8 DEFAULT '1表示租房 2收房 3新房',
  `img_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of imgaes
-- ----------------------------

-- ----------------------------
-- Table structure for `informations`
-- ----------------------------
DROP TABLE IF EXISTS `informations`;
CREATE TABLE `informations` (
  `info_id` int(11) NOT NULL AUTO_INCREMENT,
  `info_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info_created_at` timestamp NULL DEFAULT NULL,
  `info_view_count` int(11) DEFAULT '0',
  `info_cate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info_editor` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info_content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of informations
-- ----------------------------

-- ----------------------------
-- Table structure for `info_categorys`
-- ----------------------------
DROP TABLE IF EXISTS `info_categorys`;
CREATE TABLE `info_categorys` (
  `cate_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `cate_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`cate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of info_categorys
-- ----------------------------

-- ----------------------------
-- Table structure for `jiage`
-- ----------------------------
DROP TABLE IF EXISTS `jiage`;
CREATE TABLE `jiage` (
  `jiage_id` int(11) NOT NULL AUTO_INCREMENT,
  `jiage_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改时间',
  `created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `is_del` int(11) DEFAULT '0',
  PRIMARY KEY (`jiage_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of jiage
-- ----------------------------
INSERT INTO `jiage` VALUES ('1', '300', '2018-09-26 14:41:57', null, '0');
INSERT INTO `jiage` VALUES ('2', '500', '2018-09-26 14:51:42', null, '0');

-- ----------------------------
-- Table structure for `loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog`;
CREATE TABLE `loginlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `admin_id` int(11) NOT NULL COMMENT '登录用户的id',
  `admin_name` varchar(255) NOT NULL COMMENT '登录用户的名称',
  `ip` varchar(255) NOT NULL COMMENT 'ip地址',
  `cityinfo` varchar(255) NOT NULL COMMENT '位置信息',
  `browser` varchar(255) NOT NULL COMMENT '游览器',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of loginlog
-- ----------------------------
INSERT INTO `loginlog` VALUES ('22', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:35');
INSERT INTO `loginlog` VALUES ('23', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:36');
INSERT INTO `loginlog` VALUES ('24', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:51');
INSERT INTO `loginlog` VALUES ('25', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:52');
INSERT INTO `loginlog` VALUES ('26', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:53');
INSERT INTO `loginlog` VALUES ('27', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:55');
INSERT INTO `loginlog` VALUES ('28', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:55');
INSERT INTO `loginlog` VALUES ('29', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:56');
INSERT INTO `loginlog` VALUES ('30', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:56');
INSERT INTO `loginlog` VALUES ('31', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:57');
INSERT INTO `loginlog` VALUES ('32', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:57');
INSERT INTO `loginlog` VALUES ('33', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:58');
INSERT INTO `loginlog` VALUES ('34', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:58');
INSERT INTO `loginlog` VALUES ('35', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:58');
INSERT INTO `loginlog` VALUES ('36', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:59');
INSERT INTO `loginlog` VALUES ('37', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:17:59');
INSERT INTO `loginlog` VALUES ('38', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:00');
INSERT INTO `loginlog` VALUES ('39', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:00');
INSERT INTO `loginlog` VALUES ('40', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:01');
INSERT INTO `loginlog` VALUES ('41', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:01');
INSERT INTO `loginlog` VALUES ('42', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:11');
INSERT INTO `loginlog` VALUES ('43', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:12');
INSERT INTO `loginlog` VALUES ('44', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:12');
INSERT INTO `loginlog` VALUES ('45', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:13');
INSERT INTO `loginlog` VALUES ('46', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:13');
INSERT INTO `loginlog` VALUES ('47', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:13');
INSERT INTO `loginlog` VALUES ('48', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:14');
INSERT INTO `loginlog` VALUES ('49', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:14');
INSERT INTO `loginlog` VALUES ('50', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:18:33');
INSERT INTO `loginlog` VALUES ('51', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 15:32:21');
INSERT INTO `loginlog` VALUES ('52', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-07 21:32:23');
INSERT INTO `loginlog` VALUES ('53', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-08 18:26:46');
INSERT INTO `loginlog` VALUES ('54', '1', 'admin', '106.6.79.179', '江西|赣州', 'chrome', '2018-08-08 18:43:34');
INSERT INTO `loginlog` VALUES ('55', '1', 'admin', '106.6.150.188', '江西|赣州', 'chrome', '2018-08-09 09:40:46');
INSERT INTO `loginlog` VALUES ('56', '1', 'admin', '106.6.150.188', '江西|赣州', 'chrome', '2018-08-09 14:22:33');
INSERT INTO `loginlog` VALUES ('57', '1', 'admin', '106.6.150.188', '江西|赣州', 'chrome', '2018-08-09 14:30:13');
INSERT INTO `loginlog` VALUES ('58', '1', 'admin', '106.6.150.188', '江西|赣州', 'chrome', '2018-08-09 16:26:57');
INSERT INTO `loginlog` VALUES ('59', '1', 'admin', '106.6.150.188', '江西|赣州', 'chrome', '2018-08-10 10:19:56');
INSERT INTO `loginlog` VALUES ('60', '1', 'admin', '106.6.150.188', '江西|赣州', 'chrome', '2018-08-11 16:27:04');
INSERT INTO `loginlog` VALUES ('61', '1', 'admin', '106.6.150.188', '江西|赣州', 'chrome', '2018-08-11 17:57:49');
INSERT INTO `loginlog` VALUES ('62', '1', 'admin', '182.104.70.11', '江西|南昌', 'chrome', '2018-08-13 01:12:14');
INSERT INTO `loginlog` VALUES ('63', '1', 'admin', '111.77.229.250', '江西|赣州', 'chrome', '2018-08-13 21:06:32');
INSERT INTO `loginlog` VALUES ('64', '1', 'admin', '111.77.229.250', '江西|赣州', 'chrome', '2018-08-14 08:41:25');
INSERT INTO `loginlog` VALUES ('65', '1', 'admin', '127.0.0.1', 'XX|内网IP', 'chrome', '2018-08-14 16:45:03');
INSERT INTO `loginlog` VALUES ('66', '1', 'admin', '127.0.0.1', 'XX|内网IP', 'chrome', '2018-08-15 00:18:12');
INSERT INTO `loginlog` VALUES ('67', '1', 'admin', '127.0.0.1', 'XX|内网IP', 'chrome', '2018-08-15 00:18:15');
INSERT INTO `loginlog` VALUES ('68', '1', 'admin', '106.6.74.221', '江西|赣州', 'chrome', '2018-08-15 11:19:05');
INSERT INTO `loginlog` VALUES ('69', '1', 'admin', '106.6.74.221', '江西|赣州', 'chrome', '2018-08-15 14:10:08');
INSERT INTO `loginlog` VALUES ('70', '1', 'admin', '127.0.0.1', 'XX|内网IP', 'chrome', '2018-08-15 20:49:36');
INSERT INTO `loginlog` VALUES ('71', '1', 'admin', '127.0.0.1', 'XX|内网IP', 'chrome', '2018-08-16 11:12:56');
INSERT INTO `loginlog` VALUES ('72', '1', 'admin', '106.6.151.191', 'XX|未获取', 'chrome', '2018-09-07 18:19:58');
INSERT INTO `loginlog` VALUES ('73', '1', 'admin', '106.6.151.191', 'XX|未获取', 'chrome', '2018-09-07 18:20:47');
INSERT INTO `loginlog` VALUES ('74', '1', 'admin', '106.6.151.191', 'XX|未获取', 'chrome', '2018-09-07 18:20:55');
INSERT INTO `loginlog` VALUES ('75', '1', 'admin', '106.6.151.191', 'XX|未获取', 'chrome', '2018-09-07 18:24:58');
INSERT INTO `loginlog` VALUES ('76', '7', 'huangxiufa', '106.6.151.191', 'XX|未获取', 'chrome', '2018-09-07 21:11:26');
INSERT INTO `loginlog` VALUES ('77', '1', 'admin', '106.6.151.191', 'XX|未获取', 'chrome', '2018-09-07 22:56:16');
INSERT INTO `loginlog` VALUES ('78', '7', 'huangxiufa', '106.5.108.230', 'XX|未获取', 'chrome', '2018-09-08 00:29:18');
INSERT INTO `loginlog` VALUES ('79', '7', 'huangxiufa', '106.6.77.57', 'XX|未获取', 'chrome', '2018-09-09 20:15:39');
INSERT INTO `loginlog` VALUES ('80', '7', 'huangxiufa', '106.6.77.57', 'XX|未获取', 'chrome', '2018-09-09 20:16:36');
INSERT INTO `loginlog` VALUES ('81', '7', 'huangxiufa', '106.6.77.57', 'XX|未获取', 'chrome', '2018-09-10 19:59:18');
INSERT INTO `loginlog` VALUES ('82', '1', 'admin', '106.6.77.57', 'XX|未获取', 'chrome', '2018-09-11 09:34:46');
INSERT INTO `loginlog` VALUES ('83', '7', 'huangxiufa', '106.6.77.57', 'XX|未获取', 'chrome', '2018-09-11 10:01:53');
INSERT INTO `loginlog` VALUES ('84', '1', 'admin', '106.6.77.57', 'XX|未获取', 'ie', '2018-09-11 11:28:31');
INSERT INTO `loginlog` VALUES ('85', '1', 'admin', '106.6.77.57', 'XX|未获取', 'chrome', '2018-09-11 11:28:49');
INSERT INTO `loginlog` VALUES ('86', '7', 'huangxiufa', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-11 19:16:04');
INSERT INTO `loginlog` VALUES ('87', '7', 'huangxiufa', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-11 22:32:14');
INSERT INTO `loginlog` VALUES ('88', '7', 'huangxiufa', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-12 14:44:17');
INSERT INTO `loginlog` VALUES ('89', '1', 'admin', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-12 14:45:51');
INSERT INTO `loginlog` VALUES ('90', '7', 'huangxiufa', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-12 14:48:30');
INSERT INTO `loginlog` VALUES ('91', '1', 'admin', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-12 15:09:41');
INSERT INTO `loginlog` VALUES ('92', '7', 'huangxiufa', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-12 19:07:07');
INSERT INTO `loginlog` VALUES ('93', '7', 'huangxiufa', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-12 19:09:46');
INSERT INTO `loginlog` VALUES ('94', '1', 'admin', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-12 19:11:31');
INSERT INTO `loginlog` VALUES ('95', '1', 'admin', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-13 11:18:43');
INSERT INTO `loginlog` VALUES ('96', '1', 'admin', '106.6.76.42', 'XX|未获取', 'chrome', '2018-09-13 14:16:21');
INSERT INTO `loginlog` VALUES ('97', '1', 'admin', '106.5.109.97', 'XX|未获取', 'chrome', '2018-09-15 03:20:26');
INSERT INTO `loginlog` VALUES ('98', '1', 'admin', '124.134.4.219', 'XX|未获取', 'chrome', '2018-09-17 17:55:20');
INSERT INTO `loginlog` VALUES ('99', '1', 'admin', '123.169.85.181', 'XX|未获取', 'chrome', '2018-09-18 13:37:27');
INSERT INTO `loginlog` VALUES ('100', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-19 14:18:49');
INSERT INTO `loginlog` VALUES ('101', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-20 14:56:26');
INSERT INTO `loginlog` VALUES ('102', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-20 15:55:39');
INSERT INTO `loginlog` VALUES ('103', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-20 18:00:44');
INSERT INTO `loginlog` VALUES ('104', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-21 08:38:59');
INSERT INTO `loginlog` VALUES ('105', '1', 'admin', '10.211.55.3', 'XX|未获取', 'chrome', '2018-09-21 09:43:55');
INSERT INTO `loginlog` VALUES ('106', '1', 'admin', '10.211.55.3', 'XX|未获取', 'chrome', '2018-09-21 16:16:09');
INSERT INTO `loginlog` VALUES ('107', '1', 'admin', '10.211.55.3', 'XX|未获取', 'chrome', '2018-09-22 16:08:09');
INSERT INTO `loginlog` VALUES ('108', '1', 'admin', '106.6.78.56', 'XX|未获取', 'chrome', '2018-09-22 17:16:11');
INSERT INTO `loginlog` VALUES ('109', '1', 'admin', '106.6.72.70', 'XX|未获取', 'firefox', '2018-09-25 12:05:57');
INSERT INTO `loginlog` VALUES ('110', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-25 14:11:20');
INSERT INTO `loginlog` VALUES ('111', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-25 15:17:51');
INSERT INTO `loginlog` VALUES ('112', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-26 00:05:22');
INSERT INTO `loginlog` VALUES ('113', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-26 00:21:53');
INSERT INTO `loginlog` VALUES ('114', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-26 08:31:42');
INSERT INTO `loginlog` VALUES ('115', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-26 09:22:37');
INSERT INTO `loginlog` VALUES ('116', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-26 14:07:23');
INSERT INTO `loginlog` VALUES ('117', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-26 14:17:20');
INSERT INTO `loginlog` VALUES ('118', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-26 21:31:25');
INSERT INTO `loginlog` VALUES ('119', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-27 09:02:48');
INSERT INTO `loginlog` VALUES ('120', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-27 14:29:58');
INSERT INTO `loginlog` VALUES ('121', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-28 11:38:09');
INSERT INTO `loginlog` VALUES ('122', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-29 09:29:10');
INSERT INTO `loginlog` VALUES ('123', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-09-30 17:28:59');
INSERT INTO `loginlog` VALUES ('124', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-05 18:06:31');
INSERT INTO `loginlog` VALUES ('125', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-05 22:04:43');
INSERT INTO `loginlog` VALUES ('126', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-06 09:53:15');
INSERT INTO `loginlog` VALUES ('127', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-06 14:46:28');
INSERT INTO `loginlog` VALUES ('128', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-07 08:12:48');
INSERT INTO `loginlog` VALUES ('129', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-08 14:46:10');
INSERT INTO `loginlog` VALUES ('130', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-08 22:58:07');
INSERT INTO `loginlog` VALUES ('131', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-09 10:08:55');
INSERT INTO `loginlog` VALUES ('132', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2018-10-10 14:53:56');
INSERT INTO `loginlog` VALUES ('133', '1', 'admin', '106.6.79.159', 'XX|未获取', 'ie', '2019-01-09 14:02:22');
INSERT INTO `loginlog` VALUES ('134', '1', 'admin', '106.6.79.159', 'XX|未获取', 'chrome', '2019-01-09 14:04:56');
INSERT INTO `loginlog` VALUES ('135', '1', 'admin', '106.6.79.159', 'XX|未获取', 'ie', '2019-01-09 16:59:31');
INSERT INTO `loginlog` VALUES ('136', '1', 'admin', '106.6.151.55', 'XX|未获取', 'chrome', '2019-01-15 15:21:52');
INSERT INTO `loginlog` VALUES ('137', '1', 'admin', '106.6.75.44', 'XX|未获取', 'chrome', '2019-01-21 09:40:48');
INSERT INTO `loginlog` VALUES ('138', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-21 13:47:14');
INSERT INTO `loginlog` VALUES ('139', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-21 17:53:46');
INSERT INTO `loginlog` VALUES ('140', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-22 14:21:06');
INSERT INTO `loginlog` VALUES ('141', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-26 10:19:14');
INSERT INTO `loginlog` VALUES ('142', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-29 12:01:41');
INSERT INTO `loginlog` VALUES ('143', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-29 14:19:28');
INSERT INTO `loginlog` VALUES ('144', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-30 09:09:05');
INSERT INTO `loginlog` VALUES ('145', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-30 16:51:45');
INSERT INTO `loginlog` VALUES ('146', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-31 17:26:14');
INSERT INTO `loginlog` VALUES ('147', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-01-31 17:26:15');
INSERT INTO `loginlog` VALUES ('148', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-02-01 12:00:01');
INSERT INTO `loginlog` VALUES ('149', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-02-01 16:50:05');
INSERT INTO `loginlog` VALUES ('150', '1', 'admin', '127.0.0.1', 'XX|未获取', 'chrome', '2019-02-12 10:35:49');

-- ----------------------------
-- Table structure for `messages`
-- ----------------------------
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msg_phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `msg_content` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `msg_adress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `msg_type` tinyint(4) NOT NULL DEFAULT '1',
  `msg_status` tinyint(4) NOT NULL DEFAULT '0',
  `msg_time` timestamp NULL DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of messages
-- ----------------------------

-- ----------------------------
-- Table structure for `mianji`
-- ----------------------------
DROP TABLE IF EXISTS `mianji`;
CREATE TABLE `mianji` (
  `mianji_id` int(11) NOT NULL AUTO_INCREMENT,
  `mianji_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改时间',
  `created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `is_del` int(11) DEFAULT '0',
  PRIMARY KEY (`mianji_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of mianji
-- ----------------------------
INSERT INTO `mianji` VALUES ('1', '50m²以下', '2018-10-10 15:24:41', null, '0');
INSERT INTO `mianji` VALUES ('2', '50m²-80m²', '2018-10-10 15:24:52', null, '0');
INSERT INTO `mianji` VALUES ('3', '80m²-100m²', '2018-10-10 15:25:21', null, '0');
INSERT INTO `mianji` VALUES ('4', '100m²-130m²', '2018-10-10 15:25:30', null, '0');
INSERT INTO `mianji` VALUES ('5', '130m²-160m²', '2018-10-10 15:25:42', null, '0');
INSERT INTO `mianji` VALUES ('6', '160m²-180m²', '2018-10-10 15:25:58', null, '0');
INSERT INTO `mianji` VALUES ('7', '180m²-200m²', '2018-10-10 15:26:11', null, '0');
INSERT INTO `mianji` VALUES ('8', '200m²以上', '2018-10-10 15:26:18', null, '0');

-- ----------------------------
-- Table structure for `migrations`
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES ('1', '2019_01_30_094453_create_category_table', '1');
INSERT INTO `migrations` VALUES ('2', '2019_01_30_134930_create_categorys_table', '2');

-- ----------------------------
-- Table structure for `news`
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `new_id` int(11) NOT NULL AUTO_INCREMENT,
  `new_editor` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `new_keyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_content` longtext COLLATE utf8_unicode_ci,
  `new_view_count` int(255) DEFAULT NULL,
  `new_status` tinyint(4) DEFAULT '1',
  `new_recommend` int(4) DEFAULT NULL COMMENT '是否推荐',
  `new_cate` tinyint(4) DEFAULT NULL COMMENT '分类名称',
  `new_created_at` timestamp NULL DEFAULT NULL,
  `new_updated_at` timestamp NULL DEFAULT NULL,
  `new_deleted_at` timestamp NULL DEFAULT NULL,
  `specialarea` int(11) DEFAULT NULL COMMENT '专区的id 1 为技术专区 2 为 运营专区 3 为下载专区',
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件链接',
  `video` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '视频链接',
  `video_time` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学时',
  `isfree` int(10) DEFAULT NULL,
  PRIMARY KEY (`new_id`)
) ENGINE=MyISAM AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of news
-- ----------------------------

-- ----------------------------
-- Table structure for `news_categorys`
-- ----------------------------
DROP TABLE IF EXISTS `news_categorys`;
CREATE TABLE `news_categorys` (
  `cate_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `cate_name` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort` int(11) NOT NULL DEFAULT '5' COMMENT '越小越靠前',
  PRIMARY KEY (`cate_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of news_categorys
-- ----------------------------
INSERT INTO `news_categorys` VALUES ('1', '公司动态', '0');
INSERT INTO `news_categorys` VALUES ('2', '行业新闻', '2');
INSERT INTO `news_categorys` VALUES ('3', '技术趋势', '3');
INSERT INTO `news_categorys` VALUES ('4', '产品动态', '1');

-- ----------------------------
-- Table structure for `page`
-- ----------------------------
DROP TABLE IF EXISTS `page`;
CREATE TABLE `page` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `page_cover_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `page_cover_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `page_cover_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`page_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of page
-- ----------------------------
INSERT INTO `page` VALUES ('1', '橙果互联(赣州)信息科技有限公司', 'resources/assets/img/20170712215738.jpg', 'resources/assets/img/20170712211147.png', 'resources/assets/img/20170712221229.png');

-- ----------------------------
-- Table structure for `problems`
-- ----------------------------
DROP TABLE IF EXISTS `problems`;
CREATE TABLE `problems` (
  `problem_id` int(11) NOT NULL AUTO_INCREMENT,
  `problem_editor` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `problem_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `problem_keyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `problem_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `problem_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `problem_content` longtext COLLATE utf8_unicode_ci,
  `problem_view_count` int(255) DEFAULT NULL,
  `problem_status` tinyint(4) DEFAULT '1',
  `problem_recommend` int(4) DEFAULT NULL,
  `problem_cate` tinyint(4) DEFAULT NULL,
  `problem_created_at` timestamp NULL DEFAULT NULL,
  `problem_updated_at` timestamp NULL DEFAULT NULL,
  `problem_deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`problem_id`)
) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of problems
-- ----------------------------

-- ----------------------------
-- Table structure for `problem_categorys`
-- ----------------------------
DROP TABLE IF EXISTS `problem_categorys`;
CREATE TABLE `problem_categorys` (
  `cate_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `cate_name` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort` int(11) NOT NULL DEFAULT '5' COMMENT '越小越靠前',
  PRIMARY KEY (`cate_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of problem_categorys
-- ----------------------------
INSERT INTO `problem_categorys` VALUES ('1', 'APP问题', '1');
INSERT INTO `problem_categorys` VALUES ('2', '小程序问题', '2');
INSERT INTO `problem_categorys` VALUES ('3', '网站问题', '3');
INSERT INTO `problem_categorys` VALUES ('4', '服务器问题', '4');

-- ----------------------------
-- Table structure for `products`
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `product_keyword` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `product_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_view_count` int(60) DEFAULT NULL,
  `product_content` text COLLATE utf8_unicode_ci,
  `busines_id` tinyint(4) DEFAULT NULL,
  `product_status` tinyint(4) DEFAULT '1',
  `product_cate` tinyint(4) DEFAULT NULL,
  `product_created_at` timestamp NULL DEFAULT NULL,
  `product_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=125 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of products
-- ----------------------------
INSERT INTO `products` VALUES ('50', '自媒体大号推广', null, '思维方式', 'http://www.gzchengguo.cn/resources/assets/img/20170720121709.png', null, '<p>二十万份地方</p>', '6', '1', '1', '2017-07-20 12:17:15', '2017-08-10 23:06:53');
INSERT INTO `products` VALUES ('51', '原创软文撰写', null, '原创软文撰写', 'http://www.gzchengguo.cn/resources/assets/img/20170720124107.png', null, '<p>原创软文撰写</p>', '6', '1', '1', '2017-07-20 12:41:09', '2017-07-20 12:41:36');
INSERT INTO `products` VALUES ('3', '企业展示APP', null, '一个向外展示及对内培训的简易型APP', 'http://www.gzchengguo.cn/resources/assets/img/20170719153555.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500949391702579.png\" title=\"1500949391702579.png\" alt=\"移动电商APP手机软件专业源码成品开发-【微逍遥科技】-天蓬网.png\"/></p>', '1', '1', '1', '2017-07-15 09:32:32', '2017-07-25 23:06:04');
INSERT INTO `products` VALUES ('4', '教育行业APP', null, '教育与科技应走在前列', 'http://www.gzchengguo.cn/resources/assets/img/20170719153654.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500949423133213.png\" title=\"1500949423133213.png\" alt=\"教育培训机构APP定制-【微逍遥科技】-天蓬网.png\"/></p>', '1', '1', '1', '2017-07-15 09:33:21', '2017-07-25 23:07:46');
INSERT INTO `products` VALUES ('5', '商城外卖APP', null, '收货地址包括：姓名，电话号码，收货地址, 是否是默认地址。', 'http://www.gzchengguo.cn/resources/assets/img/20170719153710.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500949563216320.png\" title=\"1500949563216320.png\" alt=\"农产品电商app定制-【微逍遥科技】-天蓬网.png\"/></p>', '1', '1', '1', '2017-07-15 10:19:29', '2017-07-25 23:06:56');
INSERT INTO `products` VALUES ('6', '企业展示小程序', null, '小程序企业展示，增加品牌推广，有效的将企业形象提升到一个新的层次。', 'http://www.gzchengguo.cn/resources/assets/img/20170721142036.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/resources/assets/img/20170721095600.png\" style=\"max-width:100%;\" class=\"w-e-selected\"><br></p>', '2', '1', '1', '2017-07-15 17:52:15', '2017-07-21 14:21:46');
INSERT INTO `products` VALUES ('7', '同城生活小程序', null, '小程序同城，想做一个类似58的平台吗？一键搞定，抢占城市的封口！', 'http://www.gzchengguo.cn/resources/assets/img/20170721142239.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/resources/assets/img/20170721095620.png\" style=\"max-width:100%;\"><br></p>', '2', '1', '1', '2017-07-15 17:52:55', '2017-07-21 14:23:26');
INSERT INTO `products` VALUES ('72', '酒店预定APP', null, '一键预约，住宿更加便捷', 'http://www.gzchengguo.cn/resources/assets/img/20170725104252.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500950638723751.png\" title=\"1500950638723751.png\" alt=\"连锁酒店APP定制-【微逍遥科技】-天蓬网.png\"/></p>', '1', '1', '1', '2017-07-25 10:44:05', '2017-07-25 23:08:18');
INSERT INTO `products` VALUES ('9', '智慧酒店小程序', null, '基于小程序的酒店应用，提供在线预定及咨询等功能，让传统酒店快速拥有自己的小程序！', 'http://www.gzchengguo.cn/resources/assets/img/20170721142437.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/resources/assets/img/20170721095637.png\" style=\"max-width:100%;\"><br></p>', '2', '1', '1', '2017-07-15 17:56:21', '2017-07-21 14:24:39');
INSERT INTO `products` VALUES ('10', '智慧餐厅小程序', null, '小程序智慧餐厅，扫一扫即可点餐，无需服务员的参与，自动出单', 'http://www.gzchengguo.cn/resources/assets/img/20170721144049.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/resources/assets/img/20170721095700.png\" style=\"max-width:100%;\"><br></p>', '2', '1', '1', '2017-07-15 17:57:03', '2017-07-21 14:41:41');
INSERT INTO `products` VALUES ('11', '微拼团小程序', null, '基于小程序的拼团应用，用户可通过拼团，随时发起拼团活动并分享给好友', 'http://www.gzchengguo.cn/resources/assets/img/20170721142530.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/resources/assets/img/20170721095723.png\" style=\"max-width:100%;\"><br></p>', '2', '1', '1', '2017-07-15 17:57:45', '2017-07-21 14:34:29');
INSERT INTO `products` VALUES ('12', '微商城小程序', null, '小程序商城系统，让您的小程序瞬间拥有一个完整的商城系统！', 'http://www.gzchengguo.cn/resources/assets/img/20170721143947.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/resources/assets/img/20170721095742.png\" style=\"max-width:100%;\"><br></p>', '2', '1', '1', '2017-07-15 17:58:18', '2017-07-21 14:40:31');
INSERT INTO `products` VALUES ('13', '信息查询系统', null, '信息的查询软件', 'http://www.gzchengguo.cn/resources/assets/img/20170719143935.jpg', null, '<p><br></p>', '5', '1', '1', '2017-07-15 17:58:30', '2017-07-19 14:39:37');
INSERT INTO `products` VALUES ('48', '充电侠APP', null, '电动汽车充电桩查找、地图导航', 'http://www.gzchengguo.cn/resources/assets/img/20170726162019.png', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/zpyjd1501057260.png\" title=\"1501057260530237.png\" alt=\"充电侠.png\"/></p>', '1', '1', '2', '2017-07-18 14:12:53', '2017-07-26 16:21:08');
INSERT INTO `products` VALUES ('15', '代理商授权系统', null, '负责代理商的软件开发', 'http://www.gzchengguo.cn/resources/assets/img/20170719143956.jpg', null, '<p>负责代理商的软件开发</p>', '5', '1', '1', '2017-07-15 17:59:18', '2017-07-19 14:39:57');
INSERT INTO `products` VALUES ('17', '微信营销管理系统', null, '负责微信小软件的开发', 'http://www.gzchengguo.cn/resources/assets/img/20170719144008.jpg', null, '<p>负责微信小软件的开发</p>', '5', '1', '1', '2017-07-15 18:02:12', '2017-07-19 14:40:09');
INSERT INTO `products` VALUES ('90', '橙果互联小程序案例', null, '企业展示多产品子分类类型', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/m9jy420170817192153.jpg', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/2n0lg1501898565.jpg\" title=\"1501898565979317.jpeg\" alt=\"橙果互联.jpg\"/></p>', '2', '1', '2', '2017-08-05 10:02:53', '2017-08-17 19:23:14');
INSERT INTO `products` VALUES ('22', '模板网站', null, '模板网站的制作', 'http://www.gzchengguo.cn/resources/assets/img/20170725110701.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500952312478427.png\" title=\"1500952312478427.png\" alt=\"模板网站.png\"/></p>', '4', '1', '1', '2017-07-15 18:04:53', '2017-07-25 11:12:01');
INSERT INTO `products` VALUES ('23', '智慧同城', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722212320.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500729810121866.jpg\" title=\"1500729810121866.jpg\" alt=\"智慧58同城---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-15 18:05:14', '2017-07-22 21:23:51');
INSERT INTO `products` VALUES ('24', '企业网站', null, '企业网站的制作', 'http://www.gzchengguo.cn/resources/assets/img/20170725111221.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500952377205003.png\" title=\"1500952377205003.png\" alt=\"企业网站.png\"/></p>', '4', '1', '1', '2017-07-15 18:05:26', '2017-07-25 11:20:50');
INSERT INTO `products` VALUES ('25', '智慧O2O', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722212430.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500729885858268.jpg\" title=\"1500729885858268.jpg\" alt=\"智慧O2O---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-15 18:05:43', '2017-07-22 21:24:47');
INSERT INTO `products` VALUES ('26', '推广网站', null, '推广网站的制作', 'http://www.gzchengguo.cn/resources/assets/img/20170725111317.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500952413554636.png\" title=\"1500952413554636.png\" alt=\"推广网站.png\"/></p>', '4', '1', '1', '2017-07-15 18:05:54', '2017-07-25 11:13:35');
INSERT INTO `products` VALUES ('28', '智慧餐饮', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722212525.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500729936117717.jpg\" title=\"1500729936117717.jpg\" alt=\"智慧餐饮---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-15 18:06:17', '2017-07-22 21:25:40');
INSERT INTO `products` VALUES ('29', '社交网站', null, '响应式网站的制作', 'http://www.gzchengguo.cn/resources/assets/img/20170725111403.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500952467181508.png\" title=\"1500952467181508.png\" alt=\"社交网站.png\"/></p>', '4', '1', '1', '2017-07-15 18:06:36', '2017-07-25 11:14:29');
INSERT INTO `products` VALUES ('30', '二手市场', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722212614.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730006513584.jpg\" title=\"1500730006513584.jpg\" alt=\"智慧餐饮---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-15 18:06:42', '2017-07-22 21:26:49');
INSERT INTO `products` VALUES ('82', '江西永宁古寺', null, '网址：http://www.jxyngs.com', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/640p920180822154438.jpg', null, '<p>网址：<a href=\"http://www.jxyngs.com\">http://www.jxyngs.com</a> </p><p><br/></p><p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500992335813085.png\" title=\"1500992335813085.png\" alt=\"image.png\"/></p><p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500992405108392.png\" title=\"1500992405108392.png\" alt=\"image.png\"/></p>', '4', '1', '2', '2017-07-25 22:20:46', '2018-08-22 15:44:42');
INSERT INTO `products` VALUES ('81', '喜玫优选商城官网', null, '网址：www.ximeigegge.com', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/l4f1y20180818201148.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500992108240978.png\" title=\"1500992108240978.png\" alt=\"1fd49e1b83801bdfbd796dba9192f3d.png\"/></p><p>网址：www.ximeigegge.com</p>', '4', '1', '2', '2017-07-25 22:16:15', '2018-08-22 15:45:03');
INSERT INTO `products` VALUES ('39', '智慧房产', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722212741.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730075115970.jpg\" title=\"1500730075115970.jpg\" alt=\"智慧房产---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-15 18:09:58', '2017-07-22 21:27:57');
INSERT INTO `products` VALUES ('65', '智慧调研', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722214128.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730909867391.jpg\" title=\"1500730909867391.jpg\" alt=\"智慧调研---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:42:00', '2017-07-22 21:42:00');
INSERT INTO `products` VALUES ('41', '草凡生态社区', null, '草凡生态社区微信商城案例', 'http://www.gzchengguo.cn/resources/assets/img/20170726171025.png', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/sc6zg1501058241.png\" title=\"1501058241571935.png\" alt=\"草凡生态社区.png\"/></p>', '3', '1', '2', '2017-07-15 18:10:40', '2017-07-26 17:10:30');
INSERT INTO `products` VALUES ('42', '第地嘉', null, '第地嘉微信商城案例', 'http://www.gzchengguo.cn/resources/assets/img/20170726170225.JPG', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/gtnj11501058544.png\" title=\"1501058544552398.png\" alt=\"第地嘉.png\"/></p>', '3', '1', '2', '2017-07-15 18:10:58', '2017-07-26 17:08:04');
INSERT INTO `products` VALUES ('45', '微信服务号代运营', null, '服务号代运营服务号代运营', 'http://www.gzchengguo.cn/resources/assets/img/20170725160535.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500972469976218.png\" title=\"1500972469976218.png\" alt=\"微信公众号服务号代运营服务-C套餐---服务详情.png\"/></p>', '6', '1', '1', '2017-07-17 15:00:38', '2017-07-25 16:48:49');
INSERT INTO `products` VALUES ('46', '微信订阅号代运营', null, '微信订阅号代运营', 'http://www.gzchengguo.cn/resources/assets/img/20170725164817.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500972510135825.png\" title=\"1500972510135825.png\" alt=\"微信公众号订阅号代运营-A套餐---服务详情.png\"/></p>', '6', '1', '1', '2017-07-17 15:01:05', '2017-07-25 16:48:33');
INSERT INTO `products` VALUES ('47', '朋友圈广告投放', null, '网站代运营网站代运营网站代运营网站代运营网站代运营', 'http://www.gzchengguo.cn/resources/assets/img/20170720121644.png', null, '<p>网站代运营网站代运营网站代运营网站代运营网站代运营</p>', '6', '1', '1', '2017-07-17 15:01:46', '2017-08-10 23:07:05');
INSERT INTO `products` VALUES ('49', '物联网APP', null, '2017是共享经济年，共享单车、共享雨伞、共享充电宝、共享篮球...', 'http://www.gzchengguo.cn/resources/assets/img/20170719153755.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500963279112076.png\" title=\"1500963279112076.png\" alt=\"智能家居物联网定制开发-APP_微信_后台均可开发 机智云-【广东洪睿科技-软件定制专家】-猪八戒网.png\"/></p>', '1', '1', '1', '2017-07-19 15:38:01', '2017-07-25 23:09:51');
INSERT INTO `products` VALUES ('53', '互动社区小程序', null, '打造用户之间沟通的社区，为粉丝运营提供更多服务！', 'http://www.gzchengguo.cn/resources/assets/img/20170721143859.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/resources/assets/img/20170721095758.png\" style=\"max-width:100%;\"><br></p>', '2', '1', '1', '2017-07-20 22:31:43', '2017-07-21 14:42:08');
INSERT INTO `products` VALUES ('54', '智慧预约小程序', null, '小程序预约助手，后台自由添加项目，支持支付功能，让预约变得更实用！', 'http://www.gzchengguo.cn/resources/assets/img/20170721144444.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/resources/assets/img/20170721144452.png\" style=\"max-width:100%;\"><br></p>', '2', '1', '1', '2017-07-21 14:45:49', '2017-07-21 14:46:51');
INSERT INTO `products` VALUES ('56', '智慧家政', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722212840.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730128584500.jpg\" title=\"1500730128584500.jpg\" alt=\"智慧家政服务---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:28:49', '2017-07-22 21:29:44');
INSERT INTO `products` VALUES ('57', '智慧教育', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722212912.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730160973852.jpg\" title=\"1500730160973852.jpg\" alt=\"智慧教育---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:29:22', '2017-07-22 21:30:00');
INSERT INTO `products` VALUES ('58', '智慧景区', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722213530.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730542705635.jpg\" title=\"1500730542705635.jpg\" alt=\"智慧景区---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:35:48', '2017-07-22 21:35:48');
INSERT INTO `products` VALUES ('59', '智慧酒店', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722213605.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730592930218.jpg\" title=\"1500730592930218.jpg\" alt=\"智慧酒店---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:36:35', '2017-07-22 21:36:35');
INSERT INTO `products` VALUES ('60', '智慧考试', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722213701.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730627560058.jpg\" title=\"1500730627560058.jpg\" alt=\"智慧考试---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:37:11', '2017-07-22 21:59:37');
INSERT INTO `products` VALUES ('61', '智慧论坛', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722213736.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730670535530.jpg\" title=\"1500730670535530.jpg\" alt=\"智慧论坛---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:37:54', '2017-07-22 21:37:54');
INSERT INTO `products` VALUES ('62', '智慧美容美发', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722213824.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730720795743.jpg\" title=\"1500730720795743.jpg\" alt=\"智慧美容美发---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:39:21', '2017-07-22 21:39:21');
INSERT INTO `products` VALUES ('63', '智慧汽车', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722213940.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730798751076.jpg\" title=\"1500730798751076.jpg\" alt=\"智慧汽车---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:40:00', '2017-07-22 21:40:00');
INSERT INTO `products` VALUES ('64', '智慧商城', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722214028.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500730841871393.jpg\" title=\"1500730841871393.jpg\" alt=\"智慧商城---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:40:44', '2017-07-22 21:59:53');
INSERT INTO `products` VALUES ('66', '智慧投票', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722214909.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500731369328977.jpg\" title=\"1500731369328977.jpg\" alt=\"智慧投票---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:49:33', '2017-07-22 21:49:33');
INSERT INTO `products` VALUES ('67', '智慧外卖', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722214959.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500731410220451.jpg\" title=\"1500731410220451.jpg\" alt=\"智慧外卖---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:50:13', '2017-07-22 21:50:13');
INSERT INTO `products` VALUES ('68', '智慧医疗', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722215034.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500731443794667.jpg\" title=\"1500731443794667.jpg\" alt=\"智慧医疗---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:50:47', '2017-07-22 21:50:47');
INSERT INTO `products` VALUES ('69', '智慧语音问答', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722215115.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500731486735068.jpg\" title=\"1500731486735068.jpg\" alt=\"智慧问答---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:51:30', '2017-07-22 21:51:30');
INSERT INTO `products` VALUES ('70', '智慧预约', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722215147.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500731521567546.jpg\" title=\"1500731521567546.jpg\" alt=\"智慧预约---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:52:05', '2017-07-22 21:52:05');
INSERT INTO `products` VALUES ('71', '智慧直播', null, '移动互联网流量第一端口', 'http://www.gzchengguo.cn/resources/assets/img/20170722215223.jpg', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170722/1500731556205218.jpg\" title=\"1500731556205218.jpg\" alt=\"智慧直播---服务详情.jpg\"/></p>', '3', '1', '1', '2017-07-22 21:52:41', '2017-07-22 21:52:41');
INSERT INTO `products` VALUES ('73', '餐饮预定APP开发', null, '收货地址包括：姓名，电话号码，收货地址（小区/大履/学校和楼号-门牌号）, 是否是默认地址。', 'http://www.gzchengguo.cn/resources/assets/img/20170725104425.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500950676129013.png\" title=\"1500950676129013.png\" alt=\"餐饮APP定制-【微逍遥科技】-天蓬网.png\"/></p>', '1', '1', '1', '2017-07-25 10:44:38', '2017-07-25 23:08:50');
INSERT INTO `products` VALUES ('74', '门户网站', null, '门户网站制作', 'http://www.gzchengguo.cn/resources/assets/img/20170725111511.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500952527604897.png\" title=\"1500952527604897.png\" alt=\"门户网站.png\"/></p>', '4', '1', '1', '2017-07-25 11:15:30', '2017-07-25 11:15:30');
INSERT INTO `products` VALUES ('75', '电商网站', null, '电商网站的制作', 'http://www.gzchengguo.cn/resources/assets/img/20170725111559.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500952578771774.png\" title=\"1500952578771774.png\" alt=\"电商网站.png\"/></p>', '4', '1', '1', '2017-07-25 11:16:20', '2017-07-25 11:16:20');
INSERT INTO `products` VALUES ('76', '理财网站', null, '理财网站开发', 'http://www.gzchengguo.cn/resources/assets/img/20170725111657.png', null, '<p><img src=\"http://www.gzchengguo.cn/ueditor/php/upload/image/20170725/1500952644772205.png\" title=\"1500952644772205.png\" alt=\"理财网站.png\"/></p>', '4', '1', '1', '2017-07-25 11:17:26', '2017-07-25 11:17:26');
INSERT INTO `products` VALUES ('77', '爱与伞APP', null, '国内第二款上线APP共享雨伞', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/y5wt720180818195445.jpg', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/isjhg1501056479.png\" title=\"1501056479133092.png\" alt=\"爱与伞.png\"/></p>', '1', '1', '2', '2017-07-25 20:33:46', '2018-08-18 19:54:48');
INSERT INTO `products` VALUES ('87', '聚小利', null, '聚小利案例展示', 'http://www.gzchengguo.cn/resources/assets/img/20170726173017.png', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/jg9ck1501059154.png\" title=\"1501059154136823.png\" alt=\"聚小利.png\"/></p>', '3', '1', '2', '2017-07-26 16:52:42', '2017-07-26 17:30:19');
INSERT INTO `products` VALUES ('88', '喜玫优选', null, '喜玫优选案例展示', 'http://www.gzchengguo.cn/resources/assets/img/20170726171413.jpg', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/m6ksx1501059195.png\" title=\"1501059195986503.png\" alt=\"喜玫优选模板.png\"/></p>', '3', '1', '2', '2017-07-26 16:53:23', '2017-07-26 17:14:17');
INSERT INTO `products` VALUES ('89', '印象生活圈', null, '印象生活圈案例展示', 'http://www.gzchengguo.cn/resources/assets/img/20170726171259.JPG', null, '<p><img class=\"loadingclass\" id=\"loading_j5krvur4\" src=\"http://www.gzchengguo.cnhttp://www.gzchengguo.cn/resources/assets/plugins/laravel-u-editor/themes/default/images/spacer.gif\" title=\"loading...\"/></p>', '3', '1', '2', '2017-07-26 16:54:00', '2017-07-26 17:13:01');
INSERT INTO `products` VALUES ('78', '棒导游APP', null, '“棒导游”是为导游和领队提供团队咨询查询、团队管理、社交等服务的产品。', 'http://www.gzchengguo.cn/resources/assets/img/20170726163444.png', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/louyc1501056517.png\" title=\"1501056517110402.png\" alt=\"棒导游.png\"/></p>', '1', '1', '2', '2017-07-25 20:34:39', '2017-07-26 16:34:46');
INSERT INTO `products` VALUES ('86', '广元特产商城', null, '广元特产商城案例展示', 'http://www.gzchengguo.cn/resources/assets/img/20170726172343.png', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/4on6k1501059101.png\" title=\"1501059101140227.png\" alt=\"广元特产商城.png\"/></p>', '3', '1', '2', '2017-07-26 16:51:48', '2017-07-26 17:23:44');
INSERT INTO `products` VALUES ('79', '青社团APP', null, '专业兼职服务平台，迄今已有上百万的大学生加入青团社。', 'http://www.gzchengguo.cn/resources/assets/img/20170726161652.png', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/el2o51501056554.png\" title=\"1501056554127890.png\" alt=\"青社团兼职.png\"/></p>', '1', '1', '2', '2017-07-25 20:35:45', '2017-07-26 16:16:54');
INSERT INTO `products` VALUES ('85', '善佳SHACA', null, '善佳SHACA微信商城案例展示', 'http://www.gzchengguo.cn/resources/assets/img/20170726171154.JPG', null, '<p><img class=\"loadingclass\" id=\"loading_j5krs02t\" src=\"http://www.gzchengguo.cnhttp://www.gzchengguo.cn/resources/assets/plugins/laravel-u-editor/themes/default/images/spacer.gif\" title=\"loading...\"/></p>', '3', '1', '2', '2017-07-26 16:51:00', '2017-07-26 17:12:15');
INSERT INTO `products` VALUES ('80', '橙果互联APP', null, '​橙果互联--一站式企业互联网服务', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/a4kph20180818194522.jpg', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/4a36i1501056590.png\" title=\"1501056590107050.png\" alt=\"橙果互联.png\"/></p>', '1', '1', '2', '2017-07-25 20:37:26', '2018-08-18 19:45:26');
INSERT INTO `products` VALUES ('83', '漳州锦成电力设备有限公司官网', null, 'http://www.fjsjcdl.com/', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/r1scg20180822154557.jpg', null, '<p><br/></p><p style=\"text-align: center;\"><img src=\"/uploads/ueditor/php/upload/image/20180818/1534560697250200.jpeg\" title=\"1534560697250200.jpeg\" alt=\"漳州市锦成电力设备有限公司.jpg\"/></p><p><br/></p><p><br/></p>', '4', '1', '2', '2017-07-25 22:25:02', '2018-08-23 09:26:00');
INSERT INTO `products` VALUES ('91', '企业绩效管理咨询', null, '现有绩效管理手段方法，不能有效支撑企业目标的达成，企业没有建立起激励体系...', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/wkn0j20170811201008.jpg', null, '<p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">企业绩效管理体系的构建方案</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\"><br/></span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">一、挑战</span> &nbsp; &nbsp;&nbsp;</strong></span></p><p><br/></p><p><span style=\"color: rgb(127, 127, 127);\">1<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、现有绩效管理手段方法，不能有效支撑企业目标的达成</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">2<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、企业没有建立起激励体系</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">3<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、有激励体系，但没有合理的指标体系来支撑</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">4<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、部门目标完成很好，但组织目标未完成</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">二、方法</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\">1<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、运用</span>GPS-IE<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">管理改进系统，从战略导出开始，通过组织绩效、过程绩效、岗位绩效三个层面；</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">2<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、设计出从公司到部门到岗位的绩效指标体系；</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">3<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、核心是战略目标和岗位关键行为间形成必然的逻辑关系。</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">三、收益</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\">1<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、使公司战略变成所有员工清晰的具体数据指标；</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">2<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、形成事先预估指导、事中纠偏、即时反馈、事后分析总结的循环系统；</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">3<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">、形成一套从战略到岗位行为的系统性、逻辑性、结果性、持续性的绩效管理体系。</span></span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\"><br/></span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong>部分客户案例：</strong></span></p><p><br/></p><p><span style=\"color: rgb(127, 127, 127);\">1、民办贵族学校培训诊断</span></p><p><span style=\"color: rgb(127, 127, 127);\">2、编织袋企业咨询诊断</span></p><p><span style=\"color: rgb(127, 127, 127);\">3、咨询公司组织架构设置</span></p>', '8', '1', '1', '2017-08-06 21:45:00', '2017-08-11 20:11:54');
INSERT INTO `products` VALUES ('92', '猎头服务', null, '科学分析客户所属区域、行业以及客户招聘岗位、企业文化、制定人才寻访方案', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/34pzj20170811175522.jpg', null, '<p><span style=\"color: rgb(127, 127, 127);\"><strong>一、企业签单</strong></span></p><p class=\"MsoListParagraph\" style=\"margin-left:48px;text-indent:0\"><span style=\"color: rgb(127, 127, 127);\"><strong>&nbsp;</strong></span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">任意时间企业与橙果互联取得联系，客服专员记录企业客户的用人需求并导入系统</span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">二、顾问对接</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong>&nbsp;</strong></span></p><p><span style=\"color: rgb(127, 127, 127);\"><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">企业下单</span>1<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">小时内高级顾问与企业对接职位描述、招聘方案、项目时间及保证等</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">了解客户企业文化、公司背景</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">客户所属行业及产品特点</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">共同讨论、分析招聘岗位</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">三、评估方案</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">科学分析客户所属区域、行业以及客户招聘岗位、企业文化、制定人才寻访方案</span></p><p><span style=\"color: rgb(127, 127, 127);\">• <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">分析区域、行业、招聘岗位</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">结合企业文化、用人风格、战略发展</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">考察目标人才的分布、稀缺度</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">四、极速寻猎</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">勾勒人才画像，通过数据库、人脉网络、专门技能展开</span>360º<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">寻猎，进行甄选过滤</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">1-3<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">天</span> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">推荐首批候选人，并持续推荐</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• 3-5<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">天</span> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">开始安排面试，并撰写综合报告</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• 15<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">天</span> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">推荐成功，进行候选人背景调查</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">五、持续服务</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">橙果互联顾问提供免费后续支持，确保人选持续、稳定地服务企业</span></p><p><span style=\"color: rgb(127, 127, 127);\">• 3<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">个月人才保证期</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• 12<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">个月</span> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">候选人跟踪服务</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">• <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">薪酬方案、绩效考核、管理咨询服务</span></span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\"><br/></span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\"><strong style=\"white-space: normal;\">部分案例展示：</strong></span></strong></span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">1.赣州市赣商联合会</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">&nbsp;2.江西省农民专业合作社联合会&nbsp;</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">3.微宏动力（湖州）有限公司&nbsp;</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">4.亚新科（天津）汽车零部件有限公司&nbsp;</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">5.河北晨阳工贸集团</span></p>', '8', '1', '1', '2017-08-06 21:54:54', '2017-08-11 19:35:05');
INSERT INTO `products` VALUES ('93', '企业人才咨询', null, '组织能力诊断、人才管理体系评价。', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/itsr920170811201024.jpg', null, '<p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"font-family: 微软雅黑, sans-serif;\">一、组织与人才盘点</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">组织能力诊断、人才管理体系评价。通过组织能力诊断模型和人才评价体系，诊断组织战略、人才标准、评价、选拔、晋升、考评、发展等组织发展方面的实际情况，明确人才盘点的切入点和目前阶段通过人才盘点首要解决的问题。</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">建立或澄清人才标准。</span></p><p><span style=\"color: rgb(127, 127, 127);\"><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">建立或开发评价工具。在澄清标准的基础上，帮助企业定制化的开发评价工具，包括</span>360 <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">度评价问卷、潜力评估、九宫格、岗位经验地图、个人</span>profile <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">等，同时也拥有一整套标准化的在线评价工具可以供客户选择。</span></span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">建立人才盘点的运营体系。</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">选取试点，开展人才盘点。</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">帮助企业进行内部宣贯。试点成功后，通过各种渠道和形式协助企业进行内部宣贯。</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">指导人才盘点的实施落地。</span></p><p><span style=\"font-family: 微软雅黑, sans-serif; color: rgb(127, 127, 127);\">提供后续跟踪服务。</span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">二、教学设计</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">敏捷课程设计与开发</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">萃取组织最佳实践和成功案例</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">基于行为改变的课程设计与开发</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">高效互动性教学方法设计</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">教学案例设计与开发</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">微课设计与开发</span></span></p><p><span style=\"color: rgb(127, 127, 127);\"><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">移动学习设计认证</span><br/> STAR-<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">企业文化课程的设计与开发</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">以应用为导向的在线课程设计</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">三、培训评估</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">柯氏四级培训效果评估</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">评估工具开发与应用</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">科学培训评估体系的建立</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">四、体系设计</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\">DACUM<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">工作任务分析</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">培训需求分析和年度计划制定</span>2.0<br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">打造企业微学习体系</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">建立业务伙伴式的培训管理体系</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">基于岗位序列的课程体系设计</span></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><strong><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">五、培训交付</span></strong></span></p><p><span style=\"color: rgb(127, 127, 127);\">&nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\"><span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">完美授课</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">导师加速培养</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">导引技巧</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">人才随需到位</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">成人学习原理在教学中的应用</span><br/> FLASH<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">培训项目的内部营销与品牌建立</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">培训项目设计与运营管理</span><br/> <span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">学习，随需而变</span>——<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">混合式学习项目设计</span><br/> S-OJT<span style=\"color: rgb(127, 127, 127); font-family: 微软雅黑, sans-serif;\">结构化在岗培训认证</span></span></p>', '8', '1', '1', '2017-08-06 22:08:14', '2017-08-11 20:12:19');
INSERT INTO `products` VALUES ('94', '社会调研服务', null, '社会调研服务', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/quiny20170811201132.jpg', null, '<p><span style=\"color: rgb(127, 127, 127);\"><strong>调查步骤：</strong></span></p><p><br/></p><p><span style=\"color: rgb(127, 127, 127);\">准备阶段（准备调查内容、准备调查工具、准备调查对象）；</span></p><p><span style=\"color: rgb(127, 127, 127);\">调查阶段（收集资料，实施调查）；</span></p><p><span style=\"color: rgb(127, 127, 127);\">分析阶段（审核、整理、统计、分析）；</span></p><p><span style=\"color: rgb(127, 127, 127);\">总结阶段（调查报告）。</span></p><p><br/></p><p><span style=\"color: rgb(127, 127, 127);\"><strong>调查方法：</strong></span></p><p><br/></p><p><span style=\"color: rgb(127, 127, 127);\">第一步，选题。根据当前国家经济形势和相关的方针政策，以及自己的兴趣和学识，并结合社会调查的要素特征，选定一个值得研究的问题，如小城镇建设，退耕还林等等。选题时应当采用必要的查阅文献资料，咨询相关老师等方法。</span></p><p><span style=\"color: rgb(127, 127, 127);\">第二步，计划。紧扣选定的主题，参照相关资料，提出不同层次的问题，并确定系统的调查项目，比如说要研究小城镇建设的问题，就要提出其必要性和所需条件等问题，每个问题又包含了若干小问题。</span></p><p><span style=\"color: rgb(127, 127, 127);\">第三步，设计指标。指标就是用一定的数量和单位来描述调查对象，如某地区的人口和人均收入等。要用各种数量指标和质量指标从各方面完整地揭示调查对象的本质特征，保证其纵向和横向的可比性。</span></p><p><span style=\"color: rgb(127, 127, 127);\">第四步，拟定提纲。就是用提纲的形式将以上的准备确定下来，对所有提出的问题和项目加以精选，分别轻重稳急，使其系统，完整。</span></p><p><span style=\"color: rgb(127, 127, 127);\">第五步，选择适当的调查方式和方法。常用的调查方式有普遍调查（对调查对象的每个部分每个分子毫无遗漏的逐个调查），典型调查（选择一个或若干个具代表性的单位做全面，系统，周密的调查），个案调查（对社会的某个个人，某个人群，或某个事件，某个单位所做的调查）。</span></p><p><span style=\"color: rgb(127, 127, 127);\">常用的调查方法有问卷法（合理设计问卷，采用开放式，封闭式或混合式问卷收集信息），文献法（通过书面材料，统计数据等文献对研究对象进行间接调查），访问法（通过交谈获得资料），观察法（现场观察，凭借感觉的印象搜集数据资料）。</span></p><p><span style=\"color: rgb(127, 127, 127);\">第六步，培训与准备。请有关专家对调查人员进行必要的培训，包括调查态度和调查技能的培训。此外，还应该注意筹备必要的资金和物质条件，作好与被调查单位的接洽工作，并争取有关单位的支持，保证调查工作的顺利开展。</span></p><p><span style=\"color: rgb(127, 127, 127);\"><br/></span></p><p><strong><span style=\"color: rgb(127, 127, 127);\">部分案例展示：</span></strong></p><p><span style=\"color: rgb(127, 127, 127);\">1979年后中国华侨房产政策的执执行状况 &nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\">2.中国华侨房产政策的制定与执行——以厦门为例 &nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\">3.四线城市人力资源管理培训与发展的调查报告—以赣州为例</span></p><p><span style=\"color: rgb(127, 127, 127);\">4.2016年赣州薪酬福利调查报告 &nbsp;</span></p><p><span style=\"color: rgb(127, 127, 127);\">5.江西省赣州市人力资源与民营企业发展调查研究</span></p><p><span style=\"color: rgb(127, 127, 127);\">6.白莲种植基地调查报告</span></p>', '8', '1', '1', '2017-08-06 22:14:02', '2017-08-11 20:11:37');
INSERT INTO `products` VALUES ('95', '橙果互联LOGO设计案例', null, '橙果互联LOGO设计案例', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/1rf5g20170811141116.jpg', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/hi5mk1502431794.jpg\" title=\"1502431794798755.jpeg\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/zkdx11502431794.jpg\" title=\"1502431794968903.jpeg\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/6i3mr1502431795.jpg\" title=\"1502431795174149.jpeg\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/u3zlc1502431795.jpg\" title=\"1502431795473392.jpeg\"/></p>', '7', '1', '2', '2017-08-11 14:15:05', '2017-08-11 14:15:05');
INSERT INTO `products` VALUES ('96', '时光餐厅小程序案例', null, '时光餐厅小程序案例', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/x1uav20170817191322.jpg', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/rkhg31502968446.png\" title=\"1502968446138704.png\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/dvayx1502968449.png\" title=\"1502968449609932.png\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/rhf4z1502968451.png\" title=\"1502968451104894.png\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/ojrx81502968458.png\" title=\"1502968458635407.png\"/></p>', '2', '1', '2', '2017-08-17 19:15:01', '2017-08-17 19:15:01');
INSERT INTO `products` VALUES ('97', '婚纱摄影商城小程序案例', null, '婚纱摄影商城小程序案例', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/mtkfs20170817191522.jpg', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/o37xd1502968535.png\" title=\"1502968535108896.png\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/37ute1502968537.png\" title=\"1502968537530710.png\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/jd8tq1502968539.png\" title=\"1502968539100629.png\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/j2qu31502968552.png\" title=\"1502968552126440.png\"/></p><p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/6hfkp1502968559.png\" title=\"1502968559430231.png\"/></p>', '2', '1', '2', '2017-08-17 19:17:05', '2017-08-17 19:17:05');
INSERT INTO `products` VALUES ('98', '租房小程序案例', null, '租房小程序案例', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/5nuqc20170817191720.jpg', null, '<p>租房小程序案例</p>', '2', '1', '2', '2017-08-17 19:17:58', '2017-08-17 19:17:58');
INSERT INTO `products` VALUES ('99', '橙果创意小程序案例', null, '企业展示产品分类类型', 'http://chengguo123.oss-cn-shenzhen.aliyuncs.com/kc2tm20170817192358.jpg', null, '<p>企业展示产品分类类型</p>', '2', '1', '2', '2017-08-17 19:24:02', '2017-08-17 19:24:02');
INSERT INTO `products` VALUES ('100', '助企宝法律O2O', null, '展示企业信息', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/th8qu20180825113706.png', null, '<p style=\"text-align: center;\"><img src=\"/uploads/ueditor/php/upload/image/20180821/1534845309244335.png\" title=\"1534845309244335.png\" alt=\"4.png\"/>&nbsp; &nbsp;<img src=\"/uploads/ueditor/php/upload/image/20180821/1534845322769128.png\" title=\"1534845322769128.png\" alt=\"5.png\"/>&nbsp;&nbsp;&nbsp;<img src=\"/uploads/ueditor/php/upload/image/20180821/1534845330760418.png\" title=\"1534845330760418.png\" alt=\"6.png\"/></p>', '2', '1', '2', '2017-08-17 19:25:44', '2018-08-25 11:37:09');
INSERT INTO `products` VALUES ('101', '海鲜送到家APP', null, '海鲜送到家是一款O2O的海鲜零售APP，及海鲜饮食文化交流，力争打造一款线上购买海鲜，并根据订单的地区系统选择区域门店，并自建配送团队，实时快速的配送订单。', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/w8ptj20180818200154.jpg', null, '<p><img src=\"http://chengguo123.oss-cn-shenzhen.aliyuncs.com/72iw31515464587.png\" title=\"1515464587670133.png\" alt=\"haixiansongdaojia.png\"/></p>', '1', '1', '2', '2018-01-09 09:09:13', '2018-08-18 20:01:58');
INSERT INTO `products` VALUES ('102', 'APP开发的八大服务流程', null, '自从互联网+政策的提出和智能手机的普及，移动互联网已经成为了营销的主流模式，是PC所不能超越的!', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/nhg0v20180109104228.png', null, '<p><span class=\"tag\" style=\"border: 0px; margin: 0px; padding: 0px 0px 0px 25px; float: right; background: url(&quot;data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAA8AAAASCAYAAACEnoQPAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMy1jMDExIDY2LjE0NTY2MSwgMjAxMi8wMi8wNi0xNDo1NjoyNyAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNiAoV2luZG93cykiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6N0Y2Qjk4QUU3MTEzMTFFNzlBQzY4MTYyNjBFODlCMzUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6N0Y2Qjk4QUY3MTEzMTFFNzlBQzY4MTYyNjBFODlCMzUiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo3RjZCOThBQzcxMTMxMUU3OUFDNjgxNjI2MEU4OUIzNSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo3RjZCOThBRDcxMTMxMUU3OUFDNjgxNjI2MEU4OUIzNSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PikSsmEAAAJASURBVHjafFPNi1JRFD/v8fBzFBWT/AgE0cCF+AEugjYh/RVBmzYD0RRTDVOLgTbNIqKhoKh9UBEERRAILWoVmoiItsvUUktHFL9B+53Xm8eojw78OPece373no97hcViQVqSTqd3oTYBA/ATqAG/gB/Ak1Qq9VvQIoO4b7VadyKRCImiSJPJRMV4PKZ6vU7T6dQlaRDv2Wy27Wg0SpL0b1un05HFYlFj5vM5VSqVi+IK8b7D4diOxWIqsdPp0Gg0WrrAYOBKyC8dIz5wOp1bR6mylMtlGg6HMtnr9ZLf75f9RqNRJosK8aHL5Voi8o1MjMfjlEgkqFarrd4clkDcc7vdl8PhMAmCoAaYzWYaDAbU6/Wo2+0SDlf3lJu9fM1mMBhcIrLo9XoKBAJy6txhn8+n7vFhkD9MfpzL5Wg2m62NzOPxUDKZpFAoRCaTSfa1223K5/O8PGTyt36/P8tkMjw7+p+0Wi2ZiFFdgrkhKq8ohfr2+ABOUUsajQYVCgUmnof5EnAwuQGcxHO7g+7uZrPZtbnyiyoWi4TXeBbmR+AZlyvXDDxH1y/ggH0Qb3AG3GmWarVKpVKJiQmYX4BXXAFid+S3DeIZOD5xCXA+hX0FT/LAbrdTs9nkwx8B34HX3CPEXOWD1Y8BQhTqK3ANmwewT2B9DusXWG9g/RbIwr5+VM7Sr0LQaagtzhZBdxWfDeo98Bm+m8d7sfYlEXwKiv/yoZLuO+ADiLdWJyCuOhBUhboN8MyywBstIstfAQYANicOKtO4GqgAAAAASUVORK5CYII=&quot;) 0px 0px no-repeat;\"></span></p><p><br/></p><article><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">自从互联网+政策的提出和智能手机的普及，移动互联网已经成为了营销的主流模式，是PC所不能超越的。其带来的商业价值是巨大的，越来越多的企业都开始追求APP开发，APP的开发流程基本有八个服务步骤。</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">一、初步接洽 顾客对公司规模、技术实力、开发案例等进行了解，对开发公司有了简单了解后，告知开发公司项目情况，进入需求沟通阶段，双方对项目能够达到共识。</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">二、解决方案 市场人员根据和顾客达成的共识，根据客户的需要，为客户提供原型设计和方案报价。</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">三、签署合同APP需求确认书，双方确定合作签署合同之后，开发公司召开项目启动会正式启动项目，确定项目时间计划和任务计划。</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><img src=\"http://img.mp.itc.cn/upload/20161216/791d1705fe804cdf99a21814c3ab5afe.jpg\"/></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">四、UI设计 设计师对APP的框架进行总体设计，主要是对APP图标、大概界面和功能进行设计，设计好APP的整体框架之后，客户满意确定后，开始进入下一阶段。</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">五、程序开发首先，APP开发大功能模块代码和大概的界面模块编写；其次，把大概的界面和功能连接后，APP软件开发的大致demo就出来了；最后，demo自己试用和体验几遍后，根据情况修改；</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">六、验收测试 Demo基本确定后，寻找用户测试，根据测试用户的反馈，改进并反复测试。在产品经过多次测试，修改bug确认无误后。一个APP制作项目就完成，可以交付给用户。</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">七、售后服务 专业的售后团队,除了上线后持续跟进外,还能进行免费协助维护,突发情况发生后的紧急维修等。</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">八、运营支撑 产品上线后，运营工作正式开始。运营通常包含技术管理、版本管理、数据分析、网络推广、营销活动策划、软文编辑、视觉提升以及客服售后等。任何一个准备走向成功的产品，都需要一个极具执行力的运营团队来支撑，我们并不能主导客户产品的运营，但在某些环节可以为客户在打造完整的团队之前提供后续服务，比如数据分析、营销策略。</span></p><p style=\"border: 0px; margin-top: 0.63em; margin-bottom: 1.8em; padding: 0px; counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0;\"><span style=\"font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; font-size: 16px;\">以上八个步骤就是橙果互联为客户匹配无缝支撑的专业服务流程。</span></p></article><p><br/></p><p><br/></p>', '1', '1', '3', '2018-01-09 10:42:33', '2018-01-09 10:55:51');
INSERT INTO `products` VALUES ('103', '攒个车APP', null, '攒个车APP攒个车APP', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/7w3vp20180824173433.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180824/1535102913706320.jpeg\" title=\"1535102913706320.jpeg\" alt=\"攒个车详情 .jpg\"/></p>', '1', '1', '2', '2018-08-18 20:07:16', '2018-08-24 17:34:39');
INSERT INTO `products` VALUES ('104', '小鸡驾手APP', null, '小鸡驾手APP', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/netwq20180824172440.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180824/1535102692263436.jpeg\" title=\"1535102692263436.jpeg\" alt=\"小鸡驾手详情.jpg\"/></p>', '1', '1', '2', '2018-08-18 20:12:56', '2018-08-24 17:25:06');
INSERT INTO `products` VALUES ('105', 'AA语音驾驶APP', null, '方便发个表格发', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/qnmbk20180823095749.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180824/1535102887251021.jpeg\" title=\"1535102887251021.jpeg\" alt=\"AA驾驶详情.jpg\"/></p>', '1', '1', '2', '2018-08-18 20:13:33', '2018-08-24 17:28:10');
INSERT INTO `products` VALUES ('106', '陶友通APP', null, '陶友通APP', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/1r2qo20180823095600.jpg', null, '<p style=\"text-align: center;\"><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180824/1535102838113278.jpeg\" title=\"1535102838113278.jpeg\" alt=\"陶友通详情.jpg\"/></p>', '1', '1', '2', '2018-08-18 20:15:00', '2018-08-24 17:27:24');
INSERT INTO `products` VALUES ('109', '千叶子抹茶官网', null, 'http://11.yl0797.com/', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/1k07u20180829093509.jpg', null, '<p><img src=\"/uploads/ueditor/php/upload/image/20180822/1534910499716228.jpeg\" title=\"1534910499716228.jpeg\" alt=\"千叶子.jpg\"/></p>', '4', '1', '2', '2018-08-22 12:01:43', '2018-08-29 09:35:16');
INSERT INTO `products` VALUES ('110', '赣州大助理信息咨询服务有限公司', null, 'http://dazhuli.chengguo.link', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/xun6020180822154257.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180822/1534927328789551.jpeg\" title=\"1534927328789551.jpeg\" alt=\"赣州大助理信息咨询服务有限公司详情.jpg\"/></p>', '4', '1', '2', '2018-08-22 14:51:40', '2018-08-22 16:42:12');
INSERT INTO `products` VALUES ('111', '黑森林官方网站', null, 'http://www.heisenlinyueqi.com/', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/rak9d20180822163328.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180822/1534926821401981.jpeg\" title=\"1534926821401981.jpeg\" alt=\"黑森林官方网站详情.jpg\"/></p>', '4', '1', '2', '2018-08-22 16:33:44', '2018-08-22 16:33:44');
INSERT INTO `products` VALUES ('112', '福建省毅信科技发展有限公司', null, 'http://www.fjsyxkj.com/', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/o7vc420180822165444.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180822/1534928124995496.jpeg\" title=\"1534928124995496.jpeg\" alt=\"福建省毅信科技发展有限公司详情.jpg\"/></p>', '4', '1', '2', '2018-08-22 16:35:42', '2018-08-22 16:55:29');
INSERT INTO `products` VALUES ('113', '赣州艾特出行', null, 'http://www.myaite.com/', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/30opi20180822173123.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180822/1534930296149042.jpeg\" title=\"1534930296149042.jpeg\" alt=\"赣州艾特出行详情.jpg\"/></p>', '4', '1', '2', '2018-08-22 17:31:44', '2018-08-22 17:31:44');
INSERT INTO `products` VALUES ('115', '江西辉烁水利工程有限公司', null, 'http://www.jxhssl.cn/', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/zidmr20180822173442.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180822/1534930551768107.jpeg\" title=\"1534930551768107.jpeg\" alt=\"江西辉烁水利工程有限公司.jpg\"/></p>', '4', '1', '2', '2018-08-22 17:34:51', '2018-08-22 17:36:05');
INSERT INTO `products` VALUES ('116', '赣州上德教育信息咨询有限公司', null, 'http://www.jxsdjy.cn', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/6nazw20180822173719.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180822/1534930652178186.jpeg\" title=\"1534930652178186.jpeg\" alt=\"赣州上德教育信息咨询有限公司.jpg\"/></p>', '4', '1', '2', '2018-08-22 17:37:37', '2018-08-22 17:37:37');
INSERT INTO `products` VALUES ('117', '赣州中润规划设计有限公司网站', null, 'http://www.zrloo.com', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/6kfc720180822180049.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180822/1534932074933186.png\" title=\"1534932074933186.png\" alt=\"赣州中润规划设计有限公司网站.png\"/></p>', '4', '1', '2', '2018-08-22 18:01:22', '2018-08-22 18:01:22');
INSERT INTO `products` VALUES ('118', '赣州农产商城', null, 'http://www.0797nd.com/', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/2dxsc20180822182324.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180822/1534933410144055.jpeg\" title=\"1534933410144055.jpeg\" alt=\"赣州农产商城.jpg\"/></p>', '4', '1', '2', '2018-08-22 18:19:35', '2018-08-22 18:23:34');
INSERT INTO `products` VALUES ('119', '海顺好易学APP', null, '海顺好易学APP', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/7ldes20180824115615.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180824/1535102598515762.jpeg\" title=\"1535102598515762.jpeg\" alt=\"海顺好易学详情.jpg\"/></p>', '1', '1', '2', '2018-08-24 11:57:10', '2018-08-24 17:23:21');
INSERT INTO `products` VALUES ('120', '青团社APP', null, '青团社APP', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/qe0wm20180824115736.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180824/1535102636618871.jpeg\" title=\"1535102636618871.jpeg\" alt=\"青团社详情.jpg\"/></p>', '1', '1', '2', '2018-08-24 11:57:54', '2018-08-24 17:23:58');
INSERT INTO `products` VALUES ('121', '棒导游APP', null, '棒导游APP', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/zmshc20180824143818.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180824/1535102660106920.jpeg\" title=\"1535102660106920.jpeg\" alt=\"棒导游详情.jpg\"/></p>', '1', '1', '2', '2018-08-24 14:38:22', '2018-08-24 17:24:22');
INSERT INTO `products` VALUES ('123', '充电侠APP', null, '充电侠APP', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/udgxt20180824180731.jpg', null, '<p><img src=\"https://www.gzchengguo.cn/uploads/ueditor/php/upload/image/20180824/1535105259148135.jpeg\" title=\"1535105259148135.jpeg\" alt=\"充电侠详情.jpg\"/></p>', '1', '1', '2', '2018-08-24 18:07:42', '2018-08-24 18:07:42');
INSERT INTO `products` VALUES ('124', 'dgdgbgd', null, 'dgcbc', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/xnw3j20180830214318.png', null, '<p>bvbnvb</p>', '4', '1', '2', '2018-08-30 21:43:22', '2018-08-30 21:43:22');

-- ----------------------------
-- Table structure for `qualifications`
-- ----------------------------
DROP TABLE IF EXISTS `qualifications`;
CREATE TABLE `qualifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(250) NOT NULL COMMENT '标题',
  `img` varchar(250) NOT NULL COMMENT '图片',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qualifications
-- ----------------------------
INSERT INTO `qualifications` VALUES ('3', 'admin5555', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/iq2j020180806174500.png', '2018-08-06 17:45:03', '0000-00-00 00:00:00');
INSERT INTO `qualifications` VALUES ('4', '8888888', 'https://chengguo123.oss-cn-shenzhen.aliyuncs.com/7jek520180806174448.jpg', '2018-08-06 17:44:50', '0000-00-00 00:00:00');

-- ----------------------------
-- Table structure for `recruits`
-- ----------------------------
DROP TABLE IF EXISTS `recruits`;
CREATE TABLE `recruits` (
  `job_id` int(11) NOT NULL AUTO_INCREMENT,
  `job_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `job_count` tinyint(2) DEFAULT NULL,
  `job_desc` text COLLATE utf8_unicode_ci,
  `job_order` tinyint(2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`job_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of recruits
-- ----------------------------
INSERT INTO `recruits` VALUES ('1', 'IOS开发工程师', '1', '工作描述：\r\n1.主要负责IOS应用程序的设计、开发。\r\n2.基于公司的产品设计，根据需求，进行IOS版本应用的实现。\r\n3.对IOS平台开发技术进行研究，根据开发过程中的体验对产品提出改进建议。\r\n岗位要求：\r\n1.熟悉IOS环境下对应用的开发。\r\n2.熟悉iPhone/iPad开发技术，包括多线程、Socket网络通信方面。\r\n3.熟悉iPhone SDK。\r\n4.熟悉IOS界面开发规范以及AppStore上架流程和规则。', '2', '2017-10-14 10:05:30', '2017-10-31 16:51:54');
INSERT INTO `recruits` VALUES ('3', '软件商务代表', '2', '工作职责：\r\n1.通过电话/网络/渠道等方式与企业商家负责人进行沟通，推广APP开发、软件开发等业务 \r\n2.挖掘企业商家营销推广需求，为客户量身定制网络推广方案并最终促成成交。 \r\n3.为客户提供优质的售前、售中、售后服务。 \r\n任职资格：\r\n1.表达流畅，普通话标准，逻辑严密，善于沟通和说服。\r\n2.诚实、敬业、勤奋、上进。聪明，善于学习，有悟性。\r\n3.具备良好的服务意识。熟练操作计算机。\r\n4.有销售经验者优先', '1', '2017-10-17 11:11:08', '2017-10-31 16:51:54');
INSERT INTO `recruits` VALUES ('2', 'PHP软件工程师', '3', '【岗位职责】：\r\n1、 能独立完成PHP项目前端和后端的设计、开发、部署、维护； \r\n2、 按照项目计划，按时提交高质量代码，完成开发任务；\r\n3、 项目文档的编写、维护，以及其他与项目相关工作。\r\n\r\n【任职要求】：\r\n1、 大专以上学历，1年以上开发经验，有企业级应用开发经验者优先；\r\n2、 熟悉lamp开发环境并熟悉数据库相关知识及SQL语言； \r\n3、 熟练使用php进行开发，了解常见的php开源框架； \r\n4、 理解ajax运作机制，熟练使用js，Jquery，html，div+css，了解模板技术； \r\n5、 有较好的代码编写习惯，有独立解决技术问题的能力及较强的学习能力。', '3', '2017-10-14 10:26:13', '2018-08-20 19:28:58');

-- ----------------------------
-- Table structure for `rents`
-- ----------------------------
DROP TABLE IF EXISTS `rents`;
CREATE TABLE `rents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '标题',
  `area_id` int(11) DEFAULT NULL COMMENT '区域id',
  `desc` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cover` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '封面',
  `minPrice` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '租金',
  `huxing` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '户型室',
  `mianji` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '面积',
  `fitType` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '装修类型',
  `fukuanfangshi` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '付款方式',
  `floor` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '楼层',
  `zonglouceng` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '总楼层',
  `xiaoqu` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '小区名称',
  `mapr` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '坐标1',
  `mapl` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '地图坐标2',
  `updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改时间',
  `created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `tage` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `mianji_id` int(10) DEFAULT NULL,
  `huxing_id` int(11) DEFAULT NULL,
  `yongtu_id` int(10) DEFAULT NULL,
  `jiage_id` int(10) DEFAULT NULL,
  `view_count` int(11) DEFAULT NULL,
  `piclist` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '轮播图集',
  `dianti` char(11) CHARACTER SET utf8 DEFAULT NULL COMMENT '有无电梯',
  `address` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '具体地址',
  `tel` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '电话',
  `lxr` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '联系人',
  `chaoxiang` varchar(255) CHARACTER SET ujis DEFAULT NULL COMMENT '朝向',
  `zhuangxiu` varchar(255) CHARACTER SET ucs2 DEFAULT NULL COMMENT '装修',
  `niandai` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '年代',
  `menpaihao` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '门牌号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of rents
-- ----------------------------
INSERT INTO `rents` VALUES ('6', '三环新城7号院 2室1厅 6300元', '1', '三环新城7号院 2室1厅 6300元', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '1400', null, '100', null, '12123', '123123', null, '中海国际', '114.909894', '25.839078', '2018-10-09 14:29:11', '2018-09-27 14:37:53', '0', '11,22,33', '1', '1', '1', '1', '100', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg,https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889607844577de998-44fb-45e5-91ab-13d4cbe0488d.jpg.600x450.jpg', '电梯房', '赣州市章贡区嘉福金融中心对面', '15216118772', '曾女士', '南北', '精装修', '2008', null);
INSERT INTO `rents` VALUES ('7', '蓝波湾精装2房出租', '1', '位置：小区绿化环境好，人车分流，居民素质高。\r\n配套：有健身器材，小型篮球场，可供小区居民使用\r\n车位：停车位充足，建有地下车位\r\n保安：小区内24小时保安巡逻', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538888762896324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '3000', null, '62', null, '押一付三', '5层 /共7层', null, '城市家佳园', '114.95763', '25.84033', '2018-10-10 18:24:01', '2018-09-27 14:38:03', '0', '平精致俩', '2', '2', '2', '1', '11', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538888762896324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '电梯房', '蓝波湾', '15216118772', '曾女士', '南北', '精装修', '2008', null);
INSERT INTO `rents` VALUES ('11', '住房万网', '1', 'QQ', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538982961771516abfb9-f9fa-4da6-b742-485064099979.jpg.280x210.jpg', '123', null, '122', null, '231', 'QQ', null, 'QQ', '114.875543', '25.781832', '2019-01-09 14:04:24', '2018-10-08 15:17:11', '1', 'www,委屈额', '5', '2', '1', '1', '12312', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538982961771516abfb9-f9fa-4da6-b742-485064099979.jpg.280x210.jpg,https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y52015470138208775b62a9a2a1ff4.jpg', '电梯房', null, '15679771921', '111', '1121', '232', '111', null);
INSERT INTO `rents` VALUES ('12', '桃江御景 2室2厅出租', '2', '城中心学期房', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y520153916425460528153915aRFM.jpg', '1000', null, '123', null, '半年付', '12', null, '桃江御景', '114.927141', '25.835956', '2018-10-10 18:24:46', '2018-10-08 15:26:12', '1', '随时看房,带家具,交通方便', '3', '1', '1', '1', '11', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y520153916425460528153915aRFM.jpg,https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539164264401Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '电梯房', null, '15679771921', '旺盛', '南', '精装修', '2010', null);

-- ----------------------------
-- Table structure for `sells`
-- ----------------------------
DROP TABLE IF EXISTS `sells`;
CREATE TABLE `sells` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '标题',
  `area_id` int(11) DEFAULT NULL COMMENT '区域id',
  `desc` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cover` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '封面',
  `minPrice` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '租金',
  `huxing` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '户型室',
  `mianji` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '面积',
  `fitType` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '装修类型',
  `fukuanfangshi` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '付款方式',
  `floor` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '楼层',
  `zonglouceng` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '总楼层',
  `xiaoqu` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '小区名称',
  `mapr` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '坐标1',
  `mapl` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '地图坐标2',
  `updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改时间',
  `created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8 DEFAULT '0',
  `tage` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `mianji_id` int(10) DEFAULT NULL,
  `huxing_id` int(11) DEFAULT NULL,
  `yongtu_id` int(10) DEFAULT NULL,
  `jiage_id` int(10) DEFAULT NULL,
  `view_count` int(11) DEFAULT NULL,
  `piclist` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '轮播图集',
  `dianti` char(11) CHARACTER SET utf8 DEFAULT NULL COMMENT '有无电梯',
  `address` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '具体地址',
  `tel` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '电话',
  `lxr` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '联系人',
  `chaoxiang` varchar(255) CHARACTER SET ujis DEFAULT NULL COMMENT '朝向',
  `zhuangxiu` varchar(255) CHARACTER SET ucs2 DEFAULT NULL COMMENT '装修',
  `niandai` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '年代',
  `menpaihao` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '门牌号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of sells
-- ----------------------------
INSERT INTO `sells` VALUES ('2', '12313', '1', '123131231', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/fyh.chengguo.link/ry64a20180926164930.jpg', null, null, null, null, null, null, null, null, null, null, '2018-09-26 16:49:45', '2018-09-26 16:49:45', '0', null, '1', '1', '1', '2', '100', null, null, null, null, null, null, null, null, null);
INSERT INTO `sells` VALUES ('6', '三环新城7号院 2室1厅 6300元', '1', '三环新城7号院 2室1厅 6300元', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '1400', null, '100', null, '12123', '123123', null, '中海国际', '114.909894', '25.839078', '2018-10-07 22:39:48', '2018-09-27 14:37:53', '1', '随时看房', '1', '1', '1', '1', '100', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg,https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889607844577de998-44fb-45e5-91ab-13d4cbe0488d.jpg.600x450.jpg', '电梯房', '赣州市章贡区嘉福金融中心对面', '15216118772', '曾女士', '南北', '精装修', '2008', null);
INSERT INTO `sells` VALUES ('7', '售房测试', '1', '小区是2010年建成，钢混结构，电梯房，地采暖。小区门口有保安，上楼需要刷卡，小区内有监控。', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538888762896324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '1000', null, '120', null, '按揭', '2楼', null, '城市家佳园', '114.956462', '25.858328', '2018-10-07 22:51:50', '2018-09-27 14:38:03', '1', '房本满五年,随时看房', '1', '2', '2', '1', '11', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538888762896324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg,https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538888792301577de998-44fb-45e5-91ab-13d4cbe0488d.jpg.600x450.jpg', '电梯房', '金鹏·怡和园3栋1', '15216118772', '曾女士', '南北', '精装修', '2008', null);
INSERT INTO `sells` VALUES ('10', null, '1', null, null, null, null, null, null, null, null, null, '12313123213', null, null, '2018-10-08 04:03:14', '2018-10-08 04:03:14', null, null, null, '2', '1', null, null, null, null, null, '123131', '1231', null, null, null, '12313');
INSERT INTO `sells` VALUES ('11', '12313', '1', '123123', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539158092057Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '1232', null, '1232', null, '123', '11', null, '123123', '114.863901', '25.809938', '2018-10-10 15:54:55', '2018-10-08 17:15:52', '1', '11', '1', '1', '2', '1', '11', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539158092057Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '电梯房', '123213', null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `servers`
-- ----------------------------
DROP TABLE IF EXISTS `servers`;
CREATE TABLE `servers` (
  `server_id` int(11) NOT NULL AUTO_INCREMENT,
  `server_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_desc` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_content` text COLLATE utf8_unicode_ci,
  `server_created_at` timestamp NULL DEFAULT NULL,
  `server_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`server_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of servers
-- ----------------------------

-- ----------------------------
-- Table structure for `solvenews`
-- ----------------------------
DROP TABLE IF EXISTS `solvenews`;
CREATE TABLE `solvenews` (
  `new_id` int(11) NOT NULL AUTO_INCREMENT,
  `new_editor` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `new_keyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_content` longtext COLLATE utf8_unicode_ci,
  `new_view_count` int(255) DEFAULT NULL,
  `new_status` tinyint(4) DEFAULT '1',
  `new_recommend` int(4) DEFAULT NULL COMMENT '是否推荐',
  `new_cate` tinyint(4) DEFAULT NULL COMMENT '分类名称',
  `new_created_at` timestamp NULL DEFAULT NULL,
  `new_updated_at` timestamp NULL DEFAULT NULL,
  `new_deleted_at` timestamp NULL DEFAULT NULL,
  `specialarea` int(11) DEFAULT NULL COMMENT '专区的id 1 为技术专区 2 为 运营专区 3 为下载专区',
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件链接',
  `video` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '视频链接',
  `video_time` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学时',
  `isfree` int(10) DEFAULT NULL,
  PRIMARY KEY (`new_id`)
) ENGINE=MyISAM AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of solvenews
-- ----------------------------
INSERT INTO `solvenews` VALUES ('186', null, '物流解决方案', '物流解决方案', '物流解决方案', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/hqgd520180825130352.jpg', '<p>物流解决方案</p>', '100', '1', null, '1', '2018-08-25 13:04:02', '2018-08-25 13:04:02', null, null, null, null, null, null);
INSERT INTO `solvenews` VALUES ('187', null, '电商解决方案', '电商解决方案电商解决方案', '电商解决方案', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/lri4e20180825130434.jpg', '<p>电商解决方案电商解决方案</p>', '100', '1', null, '1', '2018-08-25 13:04:36', '2018-08-25 13:04:36', null, null, null, null, null, null);
INSERT INTO `solvenews` VALUES ('188', null, '出行解决方案', '出行解决方案', '出行解决方案', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/nzaq820180825130458.jpg', '<p>出行解决方案出行解决方案出行解决方案出行解决方案</p>', '100', '1', null, '1', '2018-08-25 13:05:02', '2018-08-25 13:05:02', null, null, null, null, null, null);
INSERT INTO `solvenews` VALUES ('189', null, '金融解决方案', '金融解决方案', '金融解决方案', 'https://chengguohl.oss-cn-shenzhen.aliyuncs.com/www.gzchengguo.cn/9cjz720180825130531.jpg', '<p>金融解决方案金融解决方案金融解决方案金融解决方案</p>', '100', '1', null, '1', '2018-08-25 13:05:33', '2018-08-25 13:05:33', null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `solve_cate`
-- ----------------------------
DROP TABLE IF EXISTS `solve_cate`;
CREATE TABLE `solve_cate` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '分类名',
  `sort` int(255) NOT NULL COMMENT '排序越小越靠前',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of solve_cate
-- ----------------------------

-- ----------------------------
-- Table structure for `statistics`
-- ----------------------------
DROP TABLE IF EXISTS `statistics`;
CREATE TABLE `statistics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `platform` varchar(30) COLLATE utf8_unicode_ci DEFAULT '',
  `brand` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `count` int(11) DEFAULT '1',
  `system` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `app_version` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of statistics
-- ----------------------------
INSERT INTO `statistics` VALUES ('1', '1', '3', '4', '2', '6', '5', '2', '2018-06-14 18:06:28', '2018-06-14 18:07:08');
INSERT INTO `statistics` VALUES ('2', 'AA驾驶-iOS-App', 'iPhone 6s', 'iPhone 6s', '4', '11.4', 'zh-Hans-CN', '1.2', '2018-06-15 14:47:04', '2018-06-17 11:49:37');

-- ----------------------------
-- Table structure for `teams`
-- ----------------------------
DROP TABLE IF EXISTS `teams`;
CREATE TABLE `teams` (
  `member_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `member_avatar` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `member_role` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `member_info` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
  `member_order` tinyint(2) DEFAULT NULL,
  PRIMARY KEY (`member_id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of teams
-- ----------------------------

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `open_id` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nickname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `avatar_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `province` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `isstaff` int(11) NOT NULL DEFAULT '0' COMMENT '是否为员工1为员工0为普通用户（游客）2为客户 3为拉黑名单的人',
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '手机号',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=357 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('356', 'o4jhd5WMEFGUIDCuDhn61LhMcTqM', '王勇', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTIhF90sjbxxUFiadN3x2pI6FWGKzppaCjsleN8tbw6NfnH0rqDEy8YIeCuw0wOQUF14QH5r2J6Lia8g/132', 'China', 'Ganzhou', 'Jiangxi', '2019-01-21 17:40:20', '2019-01-26 09:49:44', '0', null);

-- ----------------------------
-- Table structure for `xinfangs`
-- ----------------------------
DROP TABLE IF EXISTS `xinfangs`;
CREATE TABLE `xinfangs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '标题',
  `area_id` int(11) DEFAULT NULL COMMENT '区域id',
  `desc` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cover` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '封面',
  `minPrice` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '租金',
  `huxing` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '户型室',
  `mianji` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '面积',
  `fitType` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '装修类型',
  `fukuanfangshi` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '付款方式',
  `floor` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '楼层',
  `zonglouceng` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '总楼层',
  `xiaoqu` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '小区名称',
  `mapr` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '坐标1',
  `mapl` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '地图坐标2',
  `updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改时间',
  `created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `tage` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `mianji_id` int(10) DEFAULT NULL,
  `huxing_id` int(11) DEFAULT NULL,
  `yongtu_id` int(10) DEFAULT NULL,
  `jiage_id` int(10) DEFAULT NULL,
  `view_count` int(11) DEFAULT NULL,
  `piclist` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '轮播图集',
  `dianti` char(11) CHARACTER SET utf8 DEFAULT NULL COMMENT '有无电梯',
  `address` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '具体地址',
  `tel` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '电话',
  `lxr` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '联系人',
  `chaoxiang` varchar(255) CHARACTER SET ujis DEFAULT NULL COMMENT '朝向',
  `zhuangxiu` varchar(255) CHARACTER SET ucs2 DEFAULT NULL COMMENT '装修',
  `niandai` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '年代',
  `kfs` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '开发商',
  `wuye` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '物业公司',
  `kpsj` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '开盘时间',
  `rzsj` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '入住时间',
  `zhandi` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '占地面积',
  `jzmj` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '建筑面积',
  `wyf` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '物业费',
  `rongji` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '容积率',
  `lvhua` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '绿化率',
  `tcw` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '停车位',
  `tcwb` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '停车位比',
  `chanqian` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '产权年限',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of xinfangs
-- ----------------------------
INSERT INTO `xinfangs` VALUES ('2', '12313', '1', '123131231', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539161872443Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', null, null, null, null, null, null, null, null, '114.925129', '25.835956', '2018-10-10 17:00:13', '2018-09-26 16:49:45', '1', '1,2', '1', '1', '1', '1', '100', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539161872443Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xinfangs` VALUES ('3', '12313', '1', '123131231', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539162050586Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', null, null, null, null, null, null, null, null, '114.942951', '25.82633', '2018-10-10 17:00:55', '2018-09-26 16:50:23', '1', '1,2', '1', '1', '1', '1', '100', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539162050586Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xinfangs` VALUES ('6', '新房测试', '1', '新房测试新房测试', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '1400', null, '100', null, '12123', '123123', null, '中海国际', '114.909894', '25.839078', '2018-10-08 01:09:28', '2018-09-27 14:37:53', '1', '随时看房', '1', '1', '1', '1', '100', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg,https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538889607844577de998-44fb-45e5-91ab-13d4cbe0488d.jpg.600x450.jpg', '电梯房', '赣州市章贡区嘉福金融中心对面', '15216118772', '曾女士', '南北', '精装修', '2008', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xinfangs` VALUES ('5', '13123', '1', '1213', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539161966216Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', null, null, null, null, '12123', null, null, null, '114.931166', '25.830493', '2018-10-10 16:59:31', '2018-09-26 17:40:07', '1', '11,1231231', '1', '1', '1', '1', '100', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539161966216Y5201538889592143324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xinfangs` VALUES ('7', '新房测试', '1', '小区是2020年建成，钢混结构，电梯房，地采暖。', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538888762896324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg', '100000', null, '120', null, '按揭', '2楼', null, '城市家佳园', '114.956462', '25.858328', '2018-10-10 18:39:43', '2018-09-27 14:38:03', '1', '随时看房', '1', '2', '2', '1', '11', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538888762896324ed2ea-f5e1-4976-9259-04d38d97e718.jpg.600x450.jpg,https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201538888792301577de998-44fb-45e5-91ab-13d4cbe0488d.jpg.600x450.jpg', '电梯房', '金鹏·怡和园3栋1', '15216118772', '曾女士', '南北', '精装修', '2008', '江西开华地产', '江西开源物业', '2018年1月', '2019年1月', '1111万平米', '1211万平米', '3000元/年', '1.11', '60%', '222', '1/2', '70年');
INSERT INTO `xinfangs` VALUES ('10', '1231312', '2', '1221312', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539010775731head_bg.jpg', '1231', null, null, null, null, null, null, '12313', '114.929153', '25.827371', '2018-10-10 18:39:37', '2018-10-08 22:59:42', '1', '12213', '1', '1', '2', '1', '11', 'https://aiyusan.oss-cn-shenzhen.aliyuncs.com/Y5201539010775731head_bg.jpg', null, '111', null, null, null, '123', null, '1213', '123123', '12313', '123', '123', '123', '123', '1231', '1231', '123', '123', '123');

-- ----------------------------
-- Table structure for `yongtu`
-- ----------------------------
DROP TABLE IF EXISTS `yongtu`;
CREATE TABLE `yongtu` (
  `yongtu_id` int(11) NOT NULL AUTO_INCREMENT,
  `yongtu_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `updated_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改时间',
  `created_at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `is_del` int(11) DEFAULT '0',
  PRIMARY KEY (`yongtu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of yongtu
-- ----------------------------
INSERT INTO `yongtu` VALUES ('1', '办公', '2018-09-26 14:54:16', null, '0');
INSERT INTO `yongtu` VALUES ('2', '住家', '2018-09-26 14:54:49', null, '0');
INSERT INTO `yongtu` VALUES ('3', '厂房', '2018-09-30 18:00:10', null, '0');