/*
Navicat MySQL Data Transfer

Source Server         : 旧版 localhost
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : yyms

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

Date: 2019-11-15 17:09:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `cg_admin`
-- ----------------------------
DROP TABLE IF EXISTS `cg_admin`;
CREATE TABLE `cg_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户名',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `logintime` datetime NOT NULL COMMENT '上次登录时间',
  `loginip` varchar(50) NOT NULL COMMENT '登录IP',
  `role_id` tinyint(2) NOT NULL COMMENT '所属权限组 关联role',
  `status` tinyint(1) NOT NULL COMMENT '状态 1|启用 0|禁用',
  `createtime` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员表';

-- ----------------------------
-- Records of cg_admin
-- ----------------------------
INSERT INTO `cg_admin` VALUES ('1', 'admin', '$2y$10$YAIJwCzcSmm7xOwZg9KSkenU9Z7ktjCd67Hj2ALFLH0veIumghK3q', '2019-11-15 13:12:01', '127.0.0.1', '1', '1', '2019-03-04 17:19:28');
INSERT INTO `cg_admin` VALUES ('2', 'cgAdmin', '$2y$10$wvh8kufXBRDVezsVRQLIxeVQqg00lOvyGJP2pQW/F44.rbQFoiUXq', '2019-11-11 11:17:38', '127.0.0.1', '1', '1', '2019-11-11 10:18:10');

-- ----------------------------
-- Table structure for `cg_adv`
-- ----------------------------
DROP TABLE IF EXISTS `cg_adv`;
CREATE TABLE `cg_adv` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL COMMENT '广告位ID',
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '广告名称',
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '图片地址',
  `sort` smallint(5) NOT NULL DEFAULT '1' COMMENT '排序',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `createtime` datetime NOT NULL COMMENT '创建时间',
  `language_id` int(11) DEFAULT NULL COMMENT '关联language表',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='广告管理';

-- ----------------------------
-- Records of cg_adv
-- ----------------------------
INSERT INTO `cg_adv` VALUES ('1', '5', 'banner', '//47.111.25.203/tpyy/uploads/20191115/9f44dc78100f2c6d6d4ab16b32017c48.png', '1', '1', '2019-11-15 13:12:59', null);
INSERT INTO `cg_adv` VALUES ('2', '6', 'banner2', '//47.111.25.203/tpyy/uploads/20191115/c799de51ae68bd03bf2cb44c33691c6f.png', '1', '1', '2019-11-15 13:13:13', null);
INSERT INTO `cg_adv` VALUES ('3', '5', 'banner2', '//47.111.25.203/tpyy/uploads/20191115/923a7a118ed51218999cb1e266cb8ee7.png', '1', '1', '2019-11-15 13:13:41', null);
INSERT INTO `cg_adv` VALUES ('4', '5', 'banner3', '//47.111.25.203/tpyy/uploads/20191115/44760e1997735ded0f5e2651c88df56c.png', '1', '1', '2019-11-15 13:13:54', null);

-- ----------------------------
-- Table structure for `cg_adv_position`
-- ----------------------------
DROP TABLE IF EXISTS `cg_adv_position`;
CREATE TABLE `cg_adv_position` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
  `language_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='广告位管理';

-- ----------------------------
-- Records of cg_adv_position
-- ----------------------------
INSERT INTO `cg_adv_position` VALUES ('6', '手机端幻灯片', '1');
INSERT INTO `cg_adv_position` VALUES ('5', '电脑端幻灯片', '1');

-- ----------------------------
-- Table structure for `cg_article`
-- ----------------------------
DROP TABLE IF EXISTS `cg_article`;
CREATE TABLE `cg_article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned NOT NULL COMMENT '分类ID',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
  `shorttitle` varchar(100) NOT NULL DEFAULT '' COMMENT '副标题',
  `thumb` varchar(150) NOT NULL DEFAULT '' COMMENT '缩略图',
  `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '摘要描述',
  `author` varchar(30) NOT NULL DEFAULT '',
  `type` varchar(50) NOT NULL DEFAULT '3',
  `content` text COMMENT '内容',
  `click` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '点击数',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1回收站',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `sort` int(10) unsigned NOT NULL DEFAULT '1',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL,
  `delete_time` datetime DEFAULT NULL,
  `language_id` int(11) DEFAULT '3',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `cid` (`cid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cg_article
-- ----------------------------
INSERT INTO `cg_article` VALUES ('1', '22', '故障排除说明1', '', '', '', '', '', '3', '<p><strong>故障排除说明1故障排除说明1故障排除说明1故障排除说明1故障排除说明1故障排除说明1故障排除说明1故障排除说明1故障排除说明1</strong><br/></p>', '3249', '1', '1', '1', '2019-11-14 14:32:15', '2019-11-14 14:32:15', null, '1');
INSERT INTO `cg_article` VALUES ('2', '22', '​故障排除说明2', '', '', '', '', '', '3', '<p>故障排除说明2故障排除说明2故障排除说明2故障排除说明2故障排除说明2故障排除说明2故障排除说明2故障排除说明2故障排除说明2</p>', '7021', '1', '1', '1', '2019-11-14 14:32:32', '2019-11-14 14:32:32', null, '1');
INSERT INTO `cg_article` VALUES ('3', '22', '​故障排除说明3', '', '', '', '', '', '3', '<p>故障排除说明3故障排除说明3故障排除说明3故障排除说明3故障排除说明3故障排除说明3故障排除说明3故障排除说明3故障排除说明3故障排除说明3故障排除说明3故障排除说明3</p>', '2811', '1', '1', '1', '2019-11-14 14:32:46', '2019-11-14 14:32:46', null, '1');
INSERT INTO `cg_article` VALUES ('4', '22', '​故障排除说明4', '', '', '', '', '', '3', '<p>故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4故障排除说明4</p>', '3419', '1', '1', '1', '2019-11-14 14:32:59', '2019-11-14 14:32:59', null, '1');
INSERT INTO `cg_article` VALUES ('5', '23', '常见问题处理1', '', '', '', '', '', '3', '<p>常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1常见问题处理1</p>', '1605', '1', '1', '1', '2019-11-14 14:33:16', '2019-11-14 14:33:16', null, '1');
INSERT INTO `cg_article` VALUES ('6', '23', '常见问题处理2', '', '', '', '', '', '3', '<p>常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2常见问题处理2</p>', '5027', '1', '1', '1', '2019-11-14 14:33:28', '2019-11-14 14:33:28', null, '1');
INSERT INTO `cg_article` VALUES ('7', '23', '常见问题处理3', '', '', '', '', '', '3', '<p>常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3常见问题处理3</p>', '9159', '1', '1', '1', '2019-11-14 14:33:41', '2019-11-14 14:33:41', null, '1');
INSERT INTO `cg_article` VALUES ('8', '23', '常见问题处理4', '', '', '', '', '', '3', '<p>常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4常见问题处理4</p>', '7089', '1', '1', '1', '2019-11-14 14:33:52', '2019-11-14 14:33:52', null, '1');
INSERT INTO `cg_article` VALUES ('9', '3', '我们的人', '', '', '', '', '', '3', '<p style=\"margin-top:0;margin-bottom:24px;background:rgb(255,255,255)\"><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">我们</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">员工拥有超过</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">多</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">年的</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">自动化行业经验</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">，我们拥有的专业知识和技能为您</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">振动盘送料系统</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">提供支持。我们的工程人员平均拥有</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\">10</span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">年以上的行业经验，并在机械和电气设计方面采用了最新技术。我们使用</span>3D<span style=\"font-family:宋体\">建模技术设计每个</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">设备</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">，以确保每个制造的组件都可以按其要求进行装配和运行。使用基于设计的制造方法，</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">让</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">我们的客户可以放心，他们</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">最终</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">的设计</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">图</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">就是最终</span></span><span style=\";font-family:宋体;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">设备</span></span><span style=\";font-family:Arial;color:rgb(64,64,64);font-size:14px\"><span style=\"font-family:宋体\">的外观。</span></span></p><p><br/></p>', '8691', '1', '1', '1', '2019-11-15 09:44:24', '2019-11-15 09:45:35', '2019-11-15 09:45:35', '1');
INSERT INTO `cg_article` VALUES ('11', '24', ' 我们的人', '', '', '', '', '', '3', '<p>&nbsp;我们的人&nbsp;我们的人&nbsp;我们的人&nbsp;我们的人</p>', '1171', '1', '1', '1', '2019-11-15 09:48:52', '2019-11-15 09:48:52', null, '1');

-- ----------------------------
-- Table structure for `cg_category`
-- ----------------------------
DROP TABLE IF EXISTS `cg_category`;
CREATE TABLE `cg_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '栏目分类名称',
  `catpic` varchar(150) NOT NULL DEFAULT '',
  `catlogo` varchar(150) DEFAULT NULL,
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类',
  `modelid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属模型',
  `title` varchar(50) NOT NULL DEFAULT '',
  `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字',
  `template_list` varchar(60) NOT NULL DEFAULT '',
  `template_show` varchar(60) NOT NULL DEFAULT '',
  `template_page` varchar(60) DEFAULT NULL,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '显示',
  `sort` smallint(6) NOT NULL DEFAULT '100' COMMENT '排序',
  `content` longtext,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL,
  `delete_time` datetime DEFAULT NULL,
  `language_id` int(11) NOT NULL DEFAULT '3',
  `ename` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='栏目分类表';

-- ----------------------------
-- Records of cg_category
-- ----------------------------
INSERT INTO `cg_category` VALUES ('1', '关于永研', '', null, '0', '2', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', null, '2019-11-14 10:39:27', '2019-11-15 09:51:13', null, '1', 'guanyuyongyan');
INSERT INTO `cg_category` VALUES ('2', '供料系统', '', null, '0', '3', '', '', '', 'lists_product.html', 'show_news.html', null, '1', '1', null, '2019-11-14 10:40:58', '2019-11-15 11:16:03', null, '1', 'gongliaoxitong');
INSERT INTO `cg_category` VALUES ('3', '应用领域', '', null, '0', '2', '', '', '', 'lists_value.html', 'show_news.html', null, '1', '1', null, '2019-11-14 10:41:09', '2019-11-15 11:41:02', null, '1', 'yingyonglingyu');
INSERT INTO `cg_category` VALUES ('4', '资料下载', '', null, '0', '3', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', null, '2019-11-14 10:41:24', '2019-11-14 13:32:41', null, '1', 'ziliaoxiazai');
INSERT INTO `cg_category` VALUES ('5', '故障排除', '', null, '0', '1', '', '', '', 'lists_problem.html', 'show_news.html', null, '1', '1', null, '2019-11-14 10:41:42', '2019-11-14 14:48:34', null, '1', 'guzhangpaichu');
INSERT INTO `cg_category` VALUES ('6', '永研服务', '', null, '0', '2', '', '', '', 'lists_value.html', 'show_news.html', null, '1', '1', '<p>永研服务永研服务永研服务永研服务永研服务永研服务永研服务永研服务永研服务永研服务永研服务永研服务永研服务永研服务永研服务</p>', '2019-11-14 10:41:55', '2019-11-15 11:47:54', null, '1', 'yongyanfuwu');
INSERT INTO `cg_category` VALUES ('7', '联系永研', '', null, '0', '2', '', '', '', 'lists_value.html', 'show_news.html', null, '1', '1', '<p>联系永研联系永研联系永研联系永研联系永研联系永研联系永研联系永研联系永研联系永研联系永研联系永研联系永研</p>', '2019-11-14 10:42:07', '2019-11-15 11:48:50', null, '1', 'lianxiyongyan');
INSERT INTO `cg_category` VALUES ('8', '振动盘及错位机构', '', null, '2', '3', '', '', '', 'lists_product.html', 'show_product.html', null, '1', '1', null, '2019-11-14 10:45:50', '2019-11-14 11:43:35', null, '1', 'zhendongpanjicuoweijigou');
INSERT INTO `cg_category` VALUES ('9', '推板机', '', null, '2', '3', '', '', '', 'lists_product.html', 'show_product.html', null, '1', '1', null, '2019-11-14 10:46:14', '2019-11-14 13:31:42', null, '1', 'tuibanji');
INSERT INTO `cg_category` VALUES ('10', '皮带料仓', '', null, '2', '3', '', '', '', 'lists_product.html', 'show_product.html', null, '1', '1', null, '2019-11-14 10:46:33', '2019-11-14 13:31:50', null, '1', 'pidailiaocang');
INSERT INTO `cg_category` VALUES ('11', '非标自动化组装机', '', null, '2', '3', '', '', '', 'lists_product.html', 'show_product.html', null, '1', '1', null, '2019-11-14 10:47:16', '2019-11-14 13:32:10', null, '1', 'feibiaozidonghuazuzhuangji');
INSERT INTO `cg_category` VALUES ('12', '离心机', '', null, '2', '3', '', '', '', 'lists_product.html', 'show_product.html', null, '1', '1', null, '2019-11-14 10:47:43', '2019-11-14 13:32:17', null, '1', 'lixinji');
INSERT INTO `cg_category` VALUES ('13', '提升机', '', null, '2', '3', '', '', '', 'lists_product.html', 'show_product.html', null, '1', '1', null, '2019-11-14 10:49:03', '2019-11-14 13:32:25', null, '1', 'tishengji');
INSERT INTO `cg_category` VALUES ('14', '直线式料仓', '', null, '2', '3', '', '', '', 'lists_product.html', 'show_product.html', null, '1', '1', null, '2019-11-14 10:49:24', '2019-11-14 13:32:32', null, '1', 'zhixianshiliaocang');
INSERT INTO `cg_category` VALUES ('15', '振动盘方案图', '', null, '4', '3', '', '', '', 'lists_download.html', 'show_news.html', null, '1', '1', null, '2019-11-14 13:33:20', '2019-11-14 15:31:20', null, '1', 'zhendongpanfangantu');
INSERT INTO `cg_category` VALUES ('16', '直阵图', '', null, '4', '3', '', '', '', 'lists_download.html', 'show_news.html', null, '1', '1', null, '2019-11-14 13:35:06', '2019-11-14 13:35:21', null, '1', 'zhizhentu');
INSERT INTO `cg_category` VALUES ('17', '提升机图', '', null, '4', '3', '', '', '', 'lists_download.html', 'show_news.html', null, '1', '1', null, '2019-11-14 13:35:47', '2019-11-14 15:35:20', null, '1', 'tishengjitu');
INSERT INTO `cg_category` VALUES ('18', '控制器说明书', '', null, '4', '3', '', '', '', 'lists_download.html', 'show_news.html', null, '1', '1', null, '2019-11-14 13:36:46', '2019-11-14 13:36:46', null, '1', 'kongzhiqishuomingshu');
INSERT INTO `cg_category` VALUES ('19', '圆阵图', '', null, '4', '1', '', '', '', 'lists_download.html', 'show_news.html', null, '1', '1', null, '2019-11-14 13:37:09', '2019-11-14 13:37:09', null, '1', 'yuanzhentu');
INSERT INTO `cg_category` VALUES ('20', '错位机构', '', null, '4', '3', '', '', '', 'lists_download.html', 'show_news.html', null, '1', '1', null, '2019-11-14 13:37:53', '2019-11-14 13:37:53', null, '1', 'cuoweijigou');
INSERT INTO `cg_category` VALUES ('21', '皮带料仓', '', null, '4', '1', '', '', '', 'lists_download.html', 'show_news.html', null, '1', '1', null, '2019-11-14 13:38:07', '2019-11-14 13:38:07', null, '1', 'pidailiaocang');
INSERT INTO `cg_category` VALUES ('22', '故障排除说明', '', null, '5', '1', '', '', '', 'lists_problem.html', 'show_news.html', null, '1', '1', null, '2019-11-14 14:30:28', '2019-11-14 14:30:28', null, '1', 'guzhangpaichushuoming');
INSERT INTO `cg_category` VALUES ('23', '常见问题处理', '', null, '5', '1', '', '', '', 'lists_problem.html', 'show_news.html', null, '1', '1', null, '2019-11-14 14:31:07', '2019-11-14 14:31:07', null, '1', 'changjianwentichuli');
INSERT INTO `cg_category` VALUES ('24', '为什么选择永研', '', null, '1', '2', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', '<p>&nbsp; &nbsp; &nbsp; &nbsp;我们知道您确定振动盘供应商是有很多选择，但是很多时候，没有足够的时间和精力来为您的项目选择合适的公司。尽管振动盘送料可能只是您整个设备中的一小部分，但如果它不能以正确的方向，足够的数量自动排序并输送到位，则最终会使您整个设备达不到CT要求而无法被验收。而选择永研，确保您自动化送料的稳定运行，让您五后顾之忧！</p><p>&nbsp; &nbsp; &nbsp; &nbsp;所以选择永研，就是选择了放心，选择了安心。<br/></p>', '2019-11-15 08:38:23', '2019-11-15 10:22:42', null, '1', 'weishimexuanzeyongyan');
INSERT INTO `cg_category` VALUES ('25', '我们的价值', '', null, '1', '2', '', '', '', 'lists_value.html', 'show_news.html', null, '1', '1', '<p style=\"margin-top:0;margin-bottom:0;margin-left:48px;vertical-align:baseline\"><span style=\"font-family: Symbol;font-size: 13px\"></span></p><p>● 在我们所做的所有事情中，我们都将客户放在我们思想的中心。以最稳定的性能，最安全的细节和爽心悦目的外观来超越客户的期望。<br/></p><p>● 在与业务相关的每个人的往来中，我们将以认真，开放和诚实的态度对待。</p><p>● 我们将重视那些为支持团队目标而努力的人。</p><p>● 考虑改善工作方式的方法是我们工作的重要组成部分。</p><p>● 我们将为出色完成的工作给予称赞。</p><p>● 我们将鼓励建设性的评论，希望从中受益。</p><p>● 我们的思维方式是不断寻找解决方案，而不是碰到困难就放弃。</p><p>● 我们的目标是享受我们的工作，让他人享受与我们的合作。</p><p>● 我们将始终保持警惕，为大家维护安全的工作环境。</p><p>● 我们将铭记自己的责任，以尽量减少对环境的影响。</p><p style=\"margin-top:0;margin-bottom:0;margin-left:48px;vertical-align:baseline\"><span style=\"font-family: Helvetica;font-size: 14px\"><span style=\"font-family:宋体\"></span></span><br/></p><p><br/></p>', '2019-11-15 08:38:54', '2019-11-15 11:13:35', null, '1', 'womendejiazhi');
INSERT INTO `cg_category` VALUES ('26', '我们的质量', '', null, '1', '2', '', '', '', 'lists_value.html', 'show_news.html', null, '1', '1', '<p>● 质量一直是永研的核心要素，每位员工都致力于为实现质量标准和客户满意度做出自己的个人贡献。</p><p>● 我们在前期评估时，会根据要求提供3D方案图，以便客户技术工程师在整机机构制图中装配到位，大大节省了技术工程师的制图时间。订单确认后，我们会按照最终3D图加工制造，在公司测试OK后，送到客户现场，可以直接安装。避免了很多因为尺寸不匹配而安装不到位的问题。节省了很多客户机器装配时间。为客户提升更多的竞争力。</p><p>● 我们保证在制造过程的每个步骤中不偷工减料，我们为客户提供了更大的安心，并确保我们的振动盘送料系统的最高稳定性！</p><p>● 我们的所有设备在进行FAT（工厂验收测试）和SAT（现场验收测试）之前均已在内部经过全面测试。我们的内部测试程序镜像每个客户的FAT要求。</p><p>● 我们多年来一直在振动盘自动化送料领域中追求卓越的性能，质量和稳定性，我们提供定制的自动化送料系统，并且由于我们先进的技术，使我们的客户也具有明显竞争优势。</p><p>● 我们明白，只有提供满足客户要求的高质量设备，才能取得长期的业务成功。</p><p><br/></p>', '2019-11-15 08:39:09', '2019-11-15 11:13:49', null, '1', 'womendezhiliang');
INSERT INTO `cg_category` VALUES ('27', '应用领域1', '', null, '3', '2', '', '', '', 'lists_value.html', 'show_news.html', null, '1', '1', '<p>应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1应用领域1</p>', '2019-11-15 11:41:17', '2019-11-15 11:42:50', null, '1', 'yingyonglingyu1');
INSERT INTO `cg_category` VALUES ('28', '应用领域2', '', null, '3', '2', '', '', '', 'lists_value.html', 'show_news.html', null, '1', '1', '<p>应用领域2应用领域2应用领域2应用领域2应用领域2应用领域2应用领域2应用领域2应用领域2应用领域2应用领域2应用领域2</p>', '2019-11-15 11:41:32', '2019-11-15 11:42:58', null, '1', 'yingyonglingyu2');
INSERT INTO `cg_category` VALUES ('29', '我们的服务', '', null, '0', '2', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', null, '2019-11-15 15:06:14', '2019-11-15 15:06:14', null, '1', 'womendefuwu');
INSERT INTO `cg_category` VALUES ('30', '设备保质期', '', null, '29', '2', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', '<p><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">&nbsp; &nbsp; 在</span></span><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">永研</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">，我们为我们的工作感到自豪，并希望将其传递给您，我们的客户。我们竭诚为您提供绝对最佳的</span></span><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">振动盘送料设备</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">，您可以放心使用我们的产品。从产品发货之日起，我们保证所有设备在</span>12<span style=\"font-family:宋体\">个月内不会出现材料和工艺缺陷。所有外包组件均受原始制造商的保修政策担保。</span></span></p><p><br/></p>', '2019-11-15 15:24:01', '2019-11-15 15:43:24', null, '1', 'shebeibaozhiqi');
INSERT INTO `cg_category` VALUES ('31', '零件更换', '', null, '29', '2', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', '<p><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">永研</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">提供了可更换的维修</span></span><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">零</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">件，如果您需要订购</span></span><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">，可与</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">我们联系</span></span><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">。</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">请填写以下表格，并提供尽可能多的有关您</span></span><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">设备</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">的信息（</span></span><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">图片或</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">型号，生产日期等）。这将帮助我们确保为您</span></span><span style=\";font-family:宋体;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">更换正确的定制振动盘组</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px;background:rgb(254,254,254)\"><span style=\"font-family:宋体\">件，并加快您的订单。</span></span></p><p><br/></p>', '2019-11-15 15:24:16', '2019-11-15 15:26:00', null, '1', 'lingjiangenghuan');
INSERT INTO `cg_category` VALUES ('32', '维修与保养', '', null, '29', '2', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', '<p style=\"margin-top: 7px;margin-bottom: 7px;background: rgb(254, 254, 254)\"><span style=\"font-size: 12px;\"><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">&nbsp; &nbsp; 厌倦了生产损失和不必要的停机时间？让</span><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">永研</span><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">帮助您降低运营成本。无论原始供应商或制造商如何，我们都会为</span><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">您</span><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">提供维修和现场服务。我们拥有一些业内知识最丰富，经验最丰富的技术人员，我们的维护和维修服务将帮助您升级</span><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">振动盘送料</span><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">系统并提高其运行效率。另外，在现场时，我们的技术人员还将培训</span><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">现场</span><span style=\"color: rgb(51, 51, 51); font-family: 宋体;\">的维护人员，以更好地了解设备的运行方式以及如何使系统以最大的效率运行。</span></span><span style=\";font-family:Helvetica;color:rgb(51,51,51);font-size:14px\"><span style=\"font-family:宋体\"></span>&nbsp;</span></p><p><br/></p>', '2019-11-15 15:24:37', '2019-11-15 15:42:14', null, '1', 'weixiuyubaoyang');
INSERT INTO `cg_category` VALUES ('33', '维修和保养信息', '', null, '29', '2', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', '<p>&nbsp; &nbsp; • 我们的技术人员通常会在您通知内的24小时内到现场，以减少停机时间并避免生产损失</p><p>&nbsp; &nbsp; •&nbsp;我司的维修和现场服务由技术熟练的技术人员提供。我们的现场维护技术人员是我们行业中经验最丰富的人</p><p>&nbsp; &nbsp; •&nbsp;在永研，每个送料系统都经过广泛的质量测试，以确保我们设备的稳定性</p><p>&nbsp; &nbsp; •&nbsp;我们的大部分维修和现场服务项目都涉及新进料机的改造，现有设备的升级以及其他类似工作</p>', '2019-11-15 15:55:25', '2019-11-15 16:33:23', null, '1', 'weixiuhebaoyangxinxi');
INSERT INTO `cg_category` VALUES ('34', '流程改进', '', null, '29', '2', '', '', '', 'lists_about.html', 'show_news.html', null, '1', '1', '<p>&nbsp; &nbsp; &nbsp; &nbsp;永研是一个基于解决方案的组织。我们想了解产品制造的整个过程，而不仅仅是需要我们支持的部分。通过花时间学习您的现场生产方式，我们能够开发创新的零件处理解决方案，从而改变您的生产线。无论您的业务目标是提高生产线速度，消除材料浪费或减少转换时间或是减少生产操作人员，我们的团队都将努力创建最简单的振动盘送料系统。</p><p><br/></p>', '2019-11-15 15:55:46', '2019-11-15 16:28:46', null, '1', 'liuchenggaijin');

-- ----------------------------
-- Table structure for `cg_config`
-- ----------------------------
DROP TABLE IF EXISTS `cg_config`;
CREATE TABLE `cg_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `group` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sort` smallint(5) NOT NULL DEFAULT '1',
  `language_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cg_config
-- ----------------------------
INSERT INTO `cg_config` VALUES ('1', 'sitename', '网站名称', '网站名称', 'config', '1', '1');
INSERT INTO `cg_config` VALUES ('2', 'siteurl', '网站域名', 'http://www.sipyc.com', 'config', '1', '1');
INSERT INTO `cg_config` VALUES ('3', 'sitetitle', '网站标题', '网站标题', 'config', '1', '1');
INSERT INTO `cg_config` VALUES ('4', 'sitekeyword', '网站关键词', '网站关键词', 'config', '1', '1');
INSERT INTO `cg_config` VALUES ('5', 'sitedescription', '网站描述', '网站描述', 'config', '1', '1');
INSERT INTO `cg_config` VALUES ('6', 'sitebeian', '备案号', '备案号', 'config', '1', '1');
INSERT INTO `cg_config` VALUES ('7', 'director', '联系人', '联系人', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('8', 'telephone', '联系电话', '0512-62656018', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('9', 'phone', '联系手机', '15051649592', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('10', 'wechat', '微信', 'wechat', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('11', 'fax', '传真', '0512-62656018', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('12', 'qq', '在线客服', '123456', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('13', 'email', '电子邮箱', 'yc@sipyc.com', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('14', 'fourzz', '400电话', '400000000', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('15', 'address', '地址', '苏州市吴中区东吴南路53号尹西工业园', 'contact', '1', '1');
INSERT INTO `cg_config` VALUES ('18', 'message', '底部备案信息', '', 'contact', '1', '1');

-- ----------------------------
-- Table structure for `cg_flink`
-- ----------------------------
DROP TABLE IF EXISTS `cg_flink`;
CREATE TABLE `cg_flink` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `logo` varchar(255) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '首页|内页',
  `sort` smallint(5) NOT NULL DEFAULT '1',
  `createtime` datetime NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cg_flink
-- ----------------------------

-- ----------------------------
-- Table structure for `cg_language`
-- ----------------------------
DROP TABLE IF EXISTS `cg_language`;
CREATE TABLE `cg_language` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `language` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '什么语言',
  `flag` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '国旗图',
  `Elanguage` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `Flanguage` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cg_language
-- ----------------------------
INSERT INTO `cg_language` VALUES ('1', '中文', null, 'Chinese', '中文');
INSERT INTO `cg_language` VALUES ('2', '英文', null, 'English', '英文');
INSERT INTO `cg_language` VALUES ('3', '繁体', null, 'Chinese', '繁體');

-- ----------------------------
-- Table structure for `cg_menu`
-- ----------------------------
DROP TABLE IF EXISTS `cg_menu`;
CREATE TABLE `cg_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL COMMENT '名称',
  `icon` varchar(255) NOT NULL COMMENT '图标',
  `href` varchar(255) NOT NULL COMMENT '地址',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 1|显示 0|隐藏',
  `is_auth` smallint(1) NOT NULL COMMENT '验证权限 1|是 0|否',
  `pid` int(11) NOT NULL COMMENT '上级ID',
  `sort` int(11) DEFAULT '1' COMMENT '排序',
  `createtime` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台菜单表';

-- ----------------------------
-- Records of cg_menu
-- ----------------------------
INSERT INTO `cg_menu` VALUES ('1', '扩展管理', 'layui-icon-set-fill', 'admin/menu/index', '1', '0', '0', '3', '2019-03-26 15:48:09');
INSERT INTO `cg_menu` VALUES ('2', '后台首页', '', 'admin/index/index', '0', '0', '1', '1', '2019-03-27 15:33:01');
INSERT INTO `cg_menu` VALUES ('3', '菜单管理', 'layui-icon-app', 'admin/menu/index', '1', '1', '1', '2', '2019-03-26 15:48:43');
INSERT INTO `cg_menu` VALUES ('4', '角色管理', 'layui-icon-user', 'admin/role/index', '1', '1', '1', '3', '2019-03-26 16:07:03');
INSERT INTO `cg_menu` VALUES ('5', '管理员', 'layui-icon-friends', 'admin/admin/index', '1', '1', '1', '4', '2019-03-26 16:11:08');
INSERT INTO `cg_menu` VALUES ('6', '欢迎页', '', 'admin/index/main', '0', '0', '2', '1', '2019-03-27 15:34:00');
INSERT INTO `cg_menu` VALUES ('7', '添加菜单', '', 'admin/menu/add', '0', '1', '3', '1', '2019-04-08 09:45:38');
INSERT INTO `cg_menu` VALUES ('8', '修改菜单信息', '', 'admin/menu/edit', '0', '1', '3', '2', '2019-03-26 15:52:31');
INSERT INTO `cg_menu` VALUES ('9', '修改菜单状态', '', 'admin/menu/changeStatus', '0', '1', '3', '3', '2019-04-09 10:21:37');
INSERT INTO `cg_menu` VALUES ('10', '修改验证权限', '', 'admin/menu/changeIs_auth', '0', '1', '3', '4', '2019-04-09 13:36:26');
INSERT INTO `cg_menu` VALUES ('11', '删除菜单', '', 'admin/menu/del', '0', '1', '3', '5', '2019-03-26 15:55:12');
INSERT INTO `cg_menu` VALUES ('12', '添加角色', '', 'admin/role/add', '0', '1', '4', '1', '2019-03-26 16:10:08');
INSERT INTO `cg_menu` VALUES ('13', '修改角色信息', '', 'admin/role/edit', '0', '1', '4', '2', '2019-04-08 10:15:49');
INSERT INTO `cg_menu` VALUES ('14', '修改角色状态', '', 'admin/role/changeStatus', '0', '1', '4', '3', '2019-04-09 13:58:50');
INSERT INTO `cg_menu` VALUES ('15', '删除角色', '', 'admin/role/del', '0', '1', '4', '4', '2019-03-26 16:10:34');
INSERT INTO `cg_menu` VALUES ('16', '添加管理员', '', 'admin/admin/add', '0', '1', '5', '1', '2019-03-26 16:12:23');
INSERT INTO `cg_menu` VALUES ('17', '修改管理员', '', 'admin/admin/edit', '0', '1', '5', '2', '2019-04-08 10:18:01');
INSERT INTO `cg_menu` VALUES ('18', '修改管理员状态', '', 'admin/admin/changeStatus', '0', '1', '5', '3', '2019-04-09 15:54:57');
INSERT INTO `cg_menu` VALUES ('19', '修改密码', '', 'admin/admin/changePwd', '0', '1', '5', '4', '2019-04-03 16:44:53');
INSERT INTO `cg_menu` VALUES ('20', '删除管理员', '', 'admin/admin/del', '0', '1', '5', '5', '2019-03-26 16:12:59');
INSERT INTO `cg_menu` VALUES ('21', '网站设置', 'layui-icon-set-fill', 'admin/config/index', '1', '1', '1', '6', '2019-04-10 13:34:33');
INSERT INTO `cg_menu` VALUES ('22', '修改参数', '', 'admin/config/edit', '0', '1', '21', '1', '2019-04-10 17:56:41');
INSERT INTO `cg_menu` VALUES ('23', '广告管理', 'layui-icon-picture', 'admin/adv/index', '1', '1', '1', '7', '2019-04-10 17:59:58');
INSERT INTO `cg_menu` VALUES ('24', '模块管理', '', 'admin/flink/index', '1', '0', '0', '2', '2019-04-10 18:00:43');
INSERT INTO `cg_menu` VALUES ('25', '友情链接', '', 'admin/flink/index', '1', '1', '24', '1', '2019-04-10 18:01:20');
INSERT INTO `cg_menu` VALUES ('26', '意向收集', '', 'admin/message/index', '1', '1', '24', '1', '2019-04-10 18:02:53');
INSERT INTO `cg_menu` VALUES ('27', '删除留言', '', 'admin/message/del', '0', '1', '26', '1', '2019-04-10 18:17:51');
INSERT INTO `cg_menu` VALUES ('28', '添加友情链接', '', 'admin/flink/add', '0', '1', '25', '1', '2019-04-10 18:18:28');
INSERT INTO `cg_menu` VALUES ('29', '修改友情链接', '', 'admin/flink/edit', '0', '1', '25', '1', '2019-04-10 18:21:58');
INSERT INTO `cg_menu` VALUES ('30', '修改友链状态', '', 'admin/flink/changeStatus', '0', '1', '25', '1', '2019-04-10 18:22:24');
INSERT INTO `cg_menu` VALUES ('31', '删除友情链接', '', 'admin/flink/del', '0', '1', '25', '1', '2019-04-10 18:22:47');
INSERT INTO `cg_menu` VALUES ('32', '添加广告位', '', 'admin/adv/positionAdd', '0', '1', '23', '1', '2019-04-12 09:06:19');
INSERT INTO `cg_menu` VALUES ('33', '修改广告位', '', 'admin/adv/positionEdit', '0', '1', '23', '2', '2019-04-12 09:07:23');
INSERT INTO `cg_menu` VALUES ('34', '删除广告位', '', 'admin/adv/positionDel', '0', '1', '23', '1', '2019-04-12 09:08:17');
INSERT INTO `cg_menu` VALUES ('35', '广告列表', '', 'admin/adv/advList', '0', '1', '23', '1', '2019-04-12 09:09:49');
INSERT INTO `cg_menu` VALUES ('36', '添加广告', '', 'admin/adv/advAdd', '0', '1', '23', '1', '2019-04-12 09:10:36');
INSERT INTO `cg_menu` VALUES ('37', '修改广告', '', 'admin/adv/advEdit', '0', '1', '23', '1', '2019-04-12 09:12:05');
INSERT INTO `cg_menu` VALUES ('38', '删除广告', '', 'admin/adv/advDel', '0', '1', '23', '1', '2019-04-12 09:16:07');
INSERT INTO `cg_menu` VALUES ('39', '修改广告排序', '', 'admin/adv/editSort', '0', '1', '23', '1', '2019-04-12 09:16:45');
INSERT INTO `cg_menu` VALUES ('40', '修改广告状态', '', 'admin/adv/changeStatus', '0', '1', '23', '1', '2019-04-12 09:17:12');
INSERT INTO `cg_menu` VALUES ('41', '修改菜单排序', '', 'admin/menu/editSort', '0', '1', '3', '3', '2019-04-12 10:03:50');
INSERT INTO `cg_menu` VALUES ('42', '内容管理', '', 'admin/topmenu/article', '1', '0', '0', '1', '2019-04-17 08:48:51');
INSERT INTO `cg_menu` VALUES ('43', '栏目管理', '', 'admin/category/index', '1', '1', '42', '1', '2019-04-17 08:50:34');
INSERT INTO `cg_menu` VALUES ('44', '添加栏目', '', 'admin/category/add', '0', '1', '43', '1', '2019-04-17 09:07:41');
INSERT INTO `cg_menu` VALUES ('45', '修改栏目', '', 'admin/category/edit', '0', '1', '43', '1', '2019-04-17 09:08:10');
INSERT INTO `cg_menu` VALUES ('46', '删除栏目', '', 'admin/category/del', '0', '1', '43', '1', '2019-04-17 09:08:41');
INSERT INTO `cg_menu` VALUES ('47', '内容管理', '', 'admin/topmenu/content', '1', '1', '42', '1', '2019-04-17 09:52:53');
INSERT INTO `cg_menu` VALUES ('56', '网站配置', 'layui-icon-util', 'admin/Deploy/index', '0', '1', '1', '1', '2019-08-12 09:56:59');
INSERT INTO `cg_menu` VALUES ('57', 'SEO设置', 'layui-icon-set-fill', 'admin/optimize/index', '1', '1', '1', '10', '2019-09-23 17:29:48');
INSERT INTO `cg_menu` VALUES ('58', '留言管理', '', 'admin/message/index', '1', '1', '26', '1', '2019-09-23 17:57:33');

-- ----------------------------
-- Table structure for `cg_message`
-- ----------------------------
DROP TABLE IF EXISTS `cg_message`;
CREATE TABLE `cg_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tel` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `delete_time` datetime DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `email` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cg_message
-- ----------------------------
INSERT INTO `cg_message` VALUES ('1', '卞云奇', '11', '2019-11-15 16:46:26', null, '12313', '111@qq.com');

-- ----------------------------
-- Table structure for `cg_model`
-- ----------------------------
DROP TABLE IF EXISTS `cg_model`;
CREATE TABLE `cg_model` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `tablename` varchar(30) NOT NULL DEFAULT '',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `template_category` varchar(60) NOT NULL DEFAULT '',
  `template_list` varchar(60) NOT NULL DEFAULT '',
  `template_show` varchar(60) NOT NULL DEFAULT '',
  `sort` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cg_model
-- ----------------------------
INSERT INTO `cg_model` VALUES ('1', '文章模型', '', 'article', '1', '', 'List_article.html', 'Show_article.html', '1');
INSERT INTO `cg_model` VALUES ('2', '单页模型', '', 'page', '1', '', 'List_page.html', 'Show_page.html', '2');
INSERT INTO `cg_model` VALUES ('3', '产品模型', '', 'product', '1', '', 'List_product.html', 'Show_product.html', '3');
INSERT INTO `cg_model` VALUES ('4', '图片模型', '', 'picture', '0', '', 'List_picture.html', 'Show_picture.html', '4');
INSERT INTO `cg_model` VALUES ('5', '软件下载模型', '', 'soft', '0', '', 'List_soft.html', 'Show_soft.html', '5');

-- ----------------------------
-- Table structure for `cg_product`
-- ----------------------------
DROP TABLE IF EXISTS `cg_product`;
CREATE TABLE `cg_product` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned NOT NULL COMMENT '分类ID',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
  `shorttitle` varchar(50) NOT NULL,
  `thumb` varchar(150) NOT NULL DEFAULT '' COMMENT '缩略图',
  `pictures` text COMMENT '图片地址',
  `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '摘要描述',
  `content` longtext COMMENT '内容',
  `click` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '点击数',
  `type` varchar(50) NOT NULL DEFAULT '3' COMMENT '允许评论',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1回收站',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `sort` int(10) unsigned NOT NULL DEFAULT '1',
  `params` text NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL,
  `delete_time` datetime DEFAULT NULL,
  `content1` longtext CHARACTER SET utf8 COLLATE utf8_bin,
  `language_id` int(11) DEFAULT '3',
  `files` text,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `cid` (`cid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cg_product
-- ----------------------------
INSERT INTO `cg_product` VALUES ('1', '8', '灯罩离心机', '', '//47.111.25.203/tpyy/uploads/20191114/11c65d565740a7462aa6469f0806e014.png', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/11c65d565740a7462aa6469f0806e014.png\"]', '灯罩离心机灯罩离心机', '灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机', '<p>灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机</p>', '7251', '3', '1', '1', '1', '[\"\"]', '2019-11-14 11:46:47', '2019-11-15 14:25:00', null, null, '1', null);
INSERT INTO `cg_product` VALUES ('2', '8', '灯罩离心机', '', '//47.111.25.203/tpyy/uploads/20191114/b5dd013c3eef298e47d29127b2362278.png', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/b5dd013c3eef298e47d29127b2362278.png\"]', '灯罩离心机', '', '<p><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span></p>', '6896', '3', '1', '1', '1', '[\"\"]', '2019-11-14 11:49:41', '2019-11-14 11:49:41', null, null, '1', null);
INSERT INTO `cg_product` VALUES ('3', '8', '灯罩离心机', '', '//47.111.25.203/tpyy/uploads/20191114/58c414ae5caf518fbe76bad3430528bf.png', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/58c414ae5caf518fbe76bad3430528bf.png\"]', '', '灯罩离心机', '<p><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span><span style=\"color: rgb(102, 102, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, Tahoma, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">灯罩离心机</span></p>', '2838', '3', '1', '1', '1', '[\"\"]', '2019-11-14 11:49:58', '2019-11-14 11:49:58', null, null, '1', null);
INSERT INTO `cg_product` VALUES ('4', '8', '灯罩离心机', '', '//47.111.25.203/tpyy/uploads/20191114/0d760fcc3a0fc164c84bb27a0dd9b081.png', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/0d760fcc3a0fc164c84bb27a0dd9b081.png\"]', '灯罩离心机', '灯罩离心机', '<p>灯罩离心机灯罩离心机灯罩离心机灯罩离心机</p>', '8642', '3', '1', '1', '1', '[\"\"]', '2019-11-14 13:07:31', '2019-11-14 13:10:58', null, null, '1', null);
INSERT INTO `cg_product` VALUES ('5', '8', '灯罩离心机', '', '//47.111.25.203/tpyy/uploads/20191114/1d97981c75c8572a99718c97753a5f12.png', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/1d97981c75c8572a99718c97753a5f12.png\"]', '灯罩离心机', '', '<p>灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机</p>', '6459', '3', '1', '1', '1', '[\"\"]', '2019-11-14 13:08:09', '2019-11-14 13:08:09', null, null, '1', null);
INSERT INTO `cg_product` VALUES ('6', '8', '灯罩离心机', '', '//47.111.25.203/tpyy/uploads/20191114/d6a916e1aff9f237f50f7b1ab05aa85b.png', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/d6a916e1aff9f237f50f7b1ab05aa85b.png\"]', '', '灯罩离心机', '<p>灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机</p>', '8102', '3', '1', '1', '1', '[\"\"]', '2019-11-14 13:08:18', '2019-11-14 13:08:47', null, null, '1', null);
INSERT INTO `cg_product` VALUES ('7', '8', '灯罩离心机', '', '//47.111.25.203/tpyy/uploads/20191114/92527feb06275dfc50a53106d8548bb8.png', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/92527feb06275dfc50a53106d8548bb8.png\"]', '', '描述描述描述描述描述描述描述描述', '<p>灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机灯罩离心机</p>', '4694', '3', '1', '1', '1', '[\"\"]', '2019-11-14 13:08:36', '2019-11-15 14:13:40', null, null, '1', null);
INSERT INTO `cg_product` VALUES ('8', '15', '振动1', '', '//47.111.25.203/tpyy/uploads/20191114/fc7dd45b803ab227a5f1a447defe8dc4.jpg', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/fc7dd45b803ab227a5f1a447defe8dc4.jpg\"]', '', '', '<p>振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1振动1</p>', '7761', '3', '1', '1', '1', '[\"\"]', '2019-11-14 16:43:50', '2019-11-14 17:29:01', null, null, '1', '//47.111.25.203/tpyy/uploads/20191114/5b89f7cc49c8215e480c34a10693b32d.sql');
INSERT INTO `cg_product` VALUES ('9', '15', '振动2', '', '//47.111.25.203/tpyy/uploads/20191114/9bdff1c61e94c955324df11ceb082059.jpg', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/9bdff1c61e94c955324df11ceb082059.jpg\"]', '', '', '<p>振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2振动2</p>', '1996', '3', '1', '1', '1', '[\"\"]', '2019-11-14 16:47:30', '2019-11-14 17:29:11', null, null, '1', '//47.111.25.203/tpyy/uploads/20191114/5b89f7cc49c8215e480c34a10693b32d.sql');
INSERT INTO `cg_product` VALUES ('10', '15', '振动3', '', '//47.111.25.203/tpyy/uploads/20191114/4f18371fcbec127dd2b2624dbc419e81.jpg', '[\"\\/\\///47.111.25.203/tpyy\\/uploads\\/20191114\\/4f18371fcbec127dd2b2624dbc419e81.jpg\"]', '', '', '', '9772', '3', '1', '1', '1', '[\"\"]', '2019-11-14 16:51:05', '2019-11-14 17:00:25', null, null, '1', '//47.111.25.203/tpyy/uploads/20191114/5b89f7cc49c8215e480c34a10693b32d.sql');

-- ----------------------------
-- Table structure for `cg_role`
-- ----------------------------
DROP TABLE IF EXISTS `cg_role`;
CREATE TABLE `cg_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 1|启用 0|禁用',
  `menu_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '授权菜单ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='角色表';

-- ----------------------------
-- Records of cg_role
-- ----------------------------
INSERT INTO `cg_role` VALUES ('1', '超级管理员', '1', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20');
