/*
Navicat MySQL Data Transfer

Source Server         : 叭叭测试
Source Server Version : 50635
Source Host           : 116.62.62.90:3306
Source Database       : yiwugang

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

Date: 2020-06-08 10:22:51
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `yzn_addons`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_addons`;
CREATE TABLE `yzn_addons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(40) NOT NULL COMMENT '插件名或标识',
  `title` varchar(20) NOT NULL DEFAULT '' COMMENT '中文名',
  `description` text COMMENT '插件描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `config` text COMMENT '配置',
  `author` varchar(40) DEFAULT '' COMMENT '作者',
  `version` varchar(20) DEFAULT '' COMMENT '版本号',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装时间',
  `has_adminlist` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否有后台列表',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='插件表';

-- ----------------------------
-- Records of yzn_addons
-- ----------------------------
INSERT INTO `yzn_addons` VALUES ('2', 'database', '数据库备份', '简单的数据库备份', '1', '{\"path\":\"\\/Data\\/\",\"part\":\"20971520\",\"compress\":\"1\",\"level\":\"9\"}', '御宅男', '1.0.0', '1557797960', '1');
INSERT INTO `yzn_addons` VALUES ('3', 'returntop', '返回顶部', '回到顶部美化，随机或指定显示，100款样式，每天一种换，天天都用新样式', '1', '{\"random\":\"0\",\"current\":\"1\"}', '御宅男', '1.0.0', '1557797984', '0');

-- ----------------------------
-- Table structure for `yzn_admin`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_admin`;
CREATE TABLE `yzn_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
  `encrypt` char(6) NOT NULL DEFAULT '' COMMENT '加密因子',
  `last_login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后一次登录时间',
  `last_login_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后一次登录IP',
  `login_count` int(11) NOT NULL DEFAULT '0' COMMENT '登录次数',
  `add_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态（1正常 99系统禁用）',
  `token` varchar(100) NOT NULL DEFAULT '' COMMENT '令牌',
  `token_expires` int(11) NOT NULL DEFAULT '0' COMMENT '令牌失效时间',
  `nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '昵称',
  `roleid` int(11) NOT NULL DEFAULT '0' COMMENT '用户角色id',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '推荐人ID',
  `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户类型（1系统管理员 2经销商 3物业）',
  `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '商家ID',
  `park_id` int(11) NOT NULL DEFAULT '0' COMMENT '停车场ID',
  PRIMARY KEY (`id`),
  KEY `token` (`token`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='管理员';

-- ----------------------------
-- Records of yzn_admin
-- ----------------------------
INSERT INTO `yzn_admin` VALUES ('1', 'test1', '', '', '0', '', '0', '0', '0', '1', '', '0', '系统管理员', '0', '0', '1', '0', '0');
INSERT INTO `yzn_admin` VALUES ('2', 'test2', '', '', '0', '', '0', '0', '0', '1', '', '0', '经销商管理员', '0', '1', '2', '0', '0');
INSERT INTO `yzn_admin` VALUES ('3', 'admin', '769a872919bdaad708a1196735533a37', 'OMuq4G', '1591576883', '2130706433', '0', '0', '0', '1', '', '0', '物业管理员', '0', '2', '3', '2', '0');
INSERT INTO `yzn_admin` VALUES ('4', 'admin2', '2dcdb733fd9be5bdc78c7c6488cb05a5', 'Q1sC3Y', '1591428869', '2130706433', '0', '0', '0', '1', '', '0', '物业管理员2', '2', '2', '3', '2', '0');

-- ----------------------------
-- Table structure for `yzn_admin_log`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_admin_log`;
CREATE TABLE `yzn_admin_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `aid` int(11) NOT NULL DEFAULT '0' COMMENT '操作者ID',
  `park_id` int(11) NOT NULL DEFAULT '0' COMMENT '停车场ID',
  `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '物业ID',
  `act_type` varchar(255) NOT NULL DEFAULT '' COMMENT '操作类型(C：新建|R：读取|U：更新|D：删除|O：其他)',
  `cname` varchar(255) NOT NULL DEFAULT '' COMMENT '操作',
  `msg` varchar(5000) NOT NULL DEFAULT '' COMMENT '操作信息',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `ip` varchar(25) NOT NULL DEFAULT '' COMMENT 'IP地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
-- Records of yzn_admin_log
-- ----------------------------

-- ----------------------------
-- Table structure for `yzn_attachment`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_attachment`;
CREATE TABLE `yzn_attachment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `aid` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '管理员id',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `name` char(50) NOT NULL DEFAULT '' COMMENT '文件名',
  `module` char(15) NOT NULL DEFAULT '' COMMENT '模块名，由哪个模块上传的',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '文件路径',
  `thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图路径',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '文件链接',
  `mime` varchar(64) NOT NULL DEFAULT '' COMMENT '文件mime类型',
  `ext` char(4) NOT NULL DEFAULT '' COMMENT '文件类型',
  `size` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` char(40) NOT NULL DEFAULT '' COMMENT 'sha1 散列值',
  `driver` varchar(16) NOT NULL DEFAULT 'local' COMMENT '上传驱动',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `listorders` int(5) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `come_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '业务类型（1：网盘）',
  `is_share` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否公开',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=352 DEFAULT CHARSET=utf8 COMMENT='附件表';

-- ----------------------------
-- Records of yzn_attachment
-- ----------------------------
INSERT INTO `yzn_attachment` VALUES ('1', '1', '0', '20190111145119.png', 'links', 'images/20190514/1579e247dd9bbd932ff804540d3cfd17.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557816533', '1557816533', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('2', '1', '0', '20190111145119.png', 'links', 'images/20190516/1327613e3fa9c93bd4dd51dd284e2846.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557976755', '1557976755', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('3', '1', '0', '2222.png', 'links', 'images/20190516/931285f316f0008aae8e6c0749fc6f43.png', '', '', 'image/png', 'png', '16180', 'c8fc4cbafd72a10b8c4e13473371332b', '8ea3241637a452e41d098b52a94ba763e1bee383', 'local', '1557976877', '1557976877', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('4', '1', '0', '20190111145119.png', 'links', 'images/20190516/3c70eaaac68362d6b0ec9d7259577517.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557976911', '1557976911', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('5', '1', '0', '20190111145119.png', 'links', 'images/20190516/2c29e912b57fb64e5cb31c8ddd4eb542.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557977075', '1557977075', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('6', '1', '0', '20190111145119.png', 'admin', 'images/20190516/fc241219ebfe47bcca1727dbb342d983.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557995369', '1557995369', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('7', '1', '0', '20190111094752.png', '', 'images/20190516/e0a0a1788a9453df58fab02648eaeeda.png', '', '', 'image/png', 'png', '447610', 'da0136168e44be5ff8433f0a72caf312', '26f7bb6e595e545f9d2b8e17920064bdfff22289', 'local', '1557995410', '1557995410', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('8', '1', '0', '20190111094752.png', 'links', 'images/20190516/c9c043f387ae1b9f6af243730d282194.png', '', '', 'image/png', 'png', '447610', 'da0136168e44be5ff8433f0a72caf312', '26f7bb6e595e545f9d2b8e17920064bdfff22289', 'local', '1557995581', '1557995581', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('9', '1', '0', '20190111094752.png', 'links', 'images/20190516/8ab3536b6263d4365b003b45e64f3687.png', '', '', 'image/png', 'png', '447610', 'da0136168e44be5ff8433f0a72caf312', '26f7bb6e595e545f9d2b8e17920064bdfff22289', 'local', '1557995662', '1557995662', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('10', '1', '0', '20190111133310.png', 'cms', 'images/20190516/2a7f6d25547743d8359601585446d822.png', '', '', 'image/png', 'png', '154462', '509c0718c4d1dc7893c358e20c6480e6', 'fafa5b8599adf0f4d79a62137e4c33069cff9fad', 'local', '1557995918', '1557995918', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('11', '1', '0', '20190111145119.png', 'links', 'images/20190516/26579f9038b59647bde8696cb763c993.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557996893', '1557996893', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('12', '1', '0', '20190111145119.png', 'links', 'images/20190516/14c5c8f4ec68fbddcc80f737362bb60b.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557996997', '1557996997', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('13', '1', '0', '20190111145119.png', 'links', 'images/20190516/6e4b075c04ec4c826c146d0e80b1877f.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557997057', '1557997057', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('14', '1', '0', '20190111145119.png', 'links', 'images/20190516/8443fd4cf2553b2c96bbbe7cdb9ce7a6.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557997219', '1557997219', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('15', '1', '0', '20190408143817.png', 'links', 'images/20190516/c86910bf99a1356e4a46eb621fdea7cd.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1557997256', '1557997256', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('16', '1', '0', '20190408143817.png', 'links', 'images/20190516/39ef75885b544914287516d7586b7a75.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1557997299', '1557997299', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('17', '1', '0', '20190408143817.png', 'links', 'images/20190516/99382f7cb7ce7fe716a4b2627a5e8862.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1557997580', '1557997580', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('18', '1', '0', '20190111145119.png', 'links', 'images/20190516/edf1361ccc7c13838b8e9c22599cd8bf.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557997966', '1557997966', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('19', '1', '0', 'logo_unionpay.jpg', 'links', 'images/20190516/5e20033f7a66917c503b7c4150071640.jpg', '', '', 'image/jpeg', 'jpg', '18877', '21bc331d6cf72f7dc80798babe7da691', '0a271f28781ef011ca1664f71a168cf292b650fc', 'local', '1557997998', '1557997998', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('20', '1', '0', '20190111094752.png', 'links', 'images/20190516/d2bd023012335814ad2ccbed050a7f8e.png', '', '', 'image/png', 'png', '447610', 'da0136168e44be5ff8433f0a72caf312', '26f7bb6e595e545f9d2b8e17920064bdfff22289', 'local', '1557998240', '1557998240', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('21', '1', '0', '20190111133310.png', 'links', 'images/20190516/3d88003d96723d6a84348d83fbb3d838.png', '', '', 'image/png', 'png', '154462', '509c0718c4d1dc7893c358e20c6480e6', 'fafa5b8599adf0f4d79a62137e4c33069cff9fad', 'local', '1557998404', '1557998404', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('22', '1', '0', '20190111133310.png', 'links', 'images/20190516/95fa3643f375a4f40fe951ca4d2bb038.png', '', '', 'image/png', 'png', '154462', '509c0718c4d1dc7893c358e20c6480e6', 'fafa5b8599adf0f4d79a62137e4c33069cff9fad', 'local', '1557998453', '1557998453', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('23', '1', '0', '20190408143817.png', 'links', 'images/20190516/406472535029e5b805dd99083406f1d4.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1557998816', '1557998816', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('24', '1', '0', '20190408143817.png', 'links', 'images/20190516/98eb292a4b740ba9b17441a957fa9245.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1557998857', '1557998857', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('25', '1', '0', '20190408143817.png', 'links', 'images/20190516/191a9c37942927a952623f14d4e6d7c8.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1557998998', '1557998998', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('27', '1', '0', '微信图片_20190516110829.jpg', 'links', 'images/20190516/7938454e36bfd99322faaa76642042fa.jpg', '', '', 'image/jpeg', 'jpg', '486889', '99152d84ee196ecd0f93dfe61402b787', 'de5919df64bc2ffec2cd94fb737d319952380e9c', 'local', '1557999827', '1557999827', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('26', '1', '0', '20190111145119.png', 'admin', 'images/20190516/cdbbeea500392f28b993047327d37a07.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1557999694', '1557999694', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('28', '1', '0', '20190111094752.png', 'links', 'images/20190516/1d68854d0f48ad21be37685570b0b428.png', '', '', 'image/png', 'png', '447610', 'da0136168e44be5ff8433f0a72caf312', '26f7bb6e595e545f9d2b8e17920064bdfff22289', 'local', '1557999923', '1557999923', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('29', '1', '0', '20190111094752.png', 'links', 'images/20190516/2db1ddbbed1146885064bf55b3e0942b.png', '', '', 'image/png', 'png', '447610', 'da0136168e44be5ff8433f0a72caf312', '26f7bb6e595e545f9d2b8e17920064bdfff22289', 'local', '1558002037', '1558002037', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('30', '1', '0', '20190111094752.png', 'links', 'images/20190516/235abf484fa64328c32fc34222be54a4.png', '', '', 'image/png', 'png', '447610', 'da0136168e44be5ff8433f0a72caf312', '26f7bb6e595e545f9d2b8e17920064bdfff22289', 'local', '1558002155', '1558002155', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('31', '1', '0', '20190111094752.png', 'links', 'images/20190516/241e7a57b1425e6802b3873259c50cff.png', '', '', 'image/png', 'png', '433814', '104ce7543c377376a2d0aac178966ec7', '19c27edbf2641da48d63d69e3753b4fde808c715', 'local', '1558002583', '1558002583', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('32', '1', '0', '微信图片_20190516110825.jpg', 'links', 'images/20190516/f42ce84af8dea16c8f681cc4b5540995.jpg', '', '', 'image/jpeg', 'jpg', '267107', '77365bb271726f669482fece905967e9', '41d9902c484de0aa66e7366ad7082779fa098ef4', 'local', '1558002679', '1558002679', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('33', '1', '0', '20190408143817.png', 'links', 'images/20190517/88a680da9dad0275bd79dfc4a7bbd49e.png', '', '', 'image/png', 'png', '6368', '971e2abe95667e11e3ec968909f35130', '3d2d1a56db832b99c1f4060748304b1c7d0d727f', 'local', '1558055067', '1558055067', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('34', '1', '0', '20190111145119.png', 'admin', 'images/20190517/2046c951cb08b475da2c0d40bdcc5065.png', '', '', 'image/png', 'png', '4476', 'cce4928b2604bdd5c7241bdd3d57644e', 'c1900fab74c677428b13b96d55bd7db15fd027cc', 'local', '1558056194', '1558056194', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('35', '1', '0', '20190408143817.png', 'admin', 'images/20190517/6265990b786148944de1c1d8d90a5c6e.png', '', '', 'image/png', 'png', '6368', '971e2abe95667e11e3ec968909f35130', '3d2d1a56db832b99c1f4060748304b1c7d0d727f', 'local', '1558056271', '1558056271', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('36', '1', '0', '无车牌支付.txt', 'admin', 'files/20190517/9754dd30d62d954d64f966e6aefcade1.txt', '', '', 'text/plain', 'txt', '129', '97eb1e208a9adf99806bbf97ab225c2a', 'a23324119a18515e2f4aa6ff6fdeec44b86d0524', 'local', '1558056537', '1558056537', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('48', '1', '0', '111.jpg', 'admin', 'images/20190619/1ab9fdec49b99c41b06d62e97bbe000c.jpg', '', '', 'image/jpeg', 'jpg', '5652542', '6a2712b357b1ca223a9e47eacc6a013b', '978f788eb55ed5de86489b2604fc8096412307c0', 'local', '1560936330', '1560936330', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('49', '1', '0', '111.jpg', 'admin', 'images/20190619/bcb4ffd72f2f92ba11809b74d03d2bd1.jpg', '', '', 'image/jpeg', 'jpg', '5652542', '6a2712b357b1ca223a9e47eacc6a013b', '978f788eb55ed5de86489b2604fc8096412307c0', 'local', '1560936391', '1560936391', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('39', '1', '0', 'park权限.txt', 'admin', 'files/20190517/a72d4d9036b3eeff06d531d3001b8863.txt', '', '', 'text/plain', 'txt', '255', 'ea2010877d886e10e3d9e836917ab331', '3e890d6b7066d8f105b076b0eef2eb9043bf95b7', 'local', '1558056590', '1558056590', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('40', '1', '0', '停车场下发.txt', 'admin', 'files/20190517/59ff30617187e31212469fb8ef19188d.txt', '', '', 'text/plain', 'txt', '80', '00b050e959a97c030bd234c88879570f', '64daff5077aeb0252d5cc4a5ca6a8fa2c37a09aa', 'local', '1558056600', '1558056600', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('41', '1', '0', '停车场下发.txt', 'admin', 'files/20190517/4f21d7e7ed0d177866a289d5b40fb332.txt', '', '', 'text/plain', 'txt', '80', '00b050e959a97c030bd234c88879570f', '64daff5077aeb0252d5cc4a5ca6a8fa2c37a09aa', 'local', '1558057040', '1558057040', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('42', '1', '0', 'logo_unionpay.jpg', 'admin', 'images/20190530/da11840480ed722ac5aa9e1d37a72403.jpg', '', '', 'image/jpeg', 'jpg', '19779', 'e8e65acf61503e0532d2777e2eda890f', '7b43bf35ec5c42d1b04ba8349492aca03893e8d2', 'local', '1559197706', '1559197706', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('43', '1', '0', '20190111145119.png', '', 'images/20190604/15b5e4a188bf8cc53bf7e2904e1c9f29.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1559627035', '1559627035', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('44', '1', '0', '20190408143817.png', 'cms', 'images/20190604/1d46966ff89c3ae38e3a9f4c8258348a.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1559627562', '1559627562', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('45', '5', '0', '20190111145119.png', '', 'images/20190614/10fefa94afffeff8afcd2ada2c25b4d7.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1560486370', '1560486370', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('46', '5', '0', '20190111145119.png', '', 'images/20190614/767b322571ff0f4aa39e98c105612388.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1560486448', '1560486448', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('47', '5', '0', '6c7f914792773392fcda57bede20b0e2.mp4', 'cms', 'files/20190617/b8db458add47ccd4548cb86613834f73.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1560763650', '1560763650', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('56', '1', '0', 'QQ图片20180614134100.png', 'admin', 'images/20190620/2904403a7592def9277c0f14e4ebc443.png', '', '', 'image/png', 'png', '12897', '637156ffa91adaef25d185deacdbe549', 'ee244512bbebc76c2ef59ed71fefea0ee3fbed08', 'local', '1561021747', '1561021747', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('57', '1', '0', 'QQ图片20180614134100.png', 'admin', 'images/20190620/a9fd202b44cd23e08ad12ca04e074bfd.png', '', '', 'image/png', 'png', '12897', '637156ffa91adaef25d185deacdbe549', 'ee244512bbebc76c2ef59ed71fefea0ee3fbed08', 'local', '1561021755', '1561021755', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('58', '1', '0', 'park权限.txt', 'admin', 'files/20190620/bb2abd045225333ac1901c83916b8e44.txt', '', '', 'text/plain', 'txt', '255', 'ea2010877d886e10e3d9e836917ab331', '3e890d6b7066d8f105b076b0eef2eb9043bf95b7', 'local', '1561021787', '1561021787', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('244', '1', '0', '1.xls', 'admin', 'files/20190905/dc072f2f8663072f75106d9d88a94cfe.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1567667183', '1567667183', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('60', '1', '0', '20190408143817.png', 'admin', 'images/20190620/15e37c664849a0d66b3a1a986a47ce6f.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1561021968', '1561021968', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('61', '1', '0', '20190408143817.png', 'admin', 'images/20190620/d749e89507ea2cec7ca0346fb208b905.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1561022003', '1561022003', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('62', '1', '0', 'QQ图片20180614134100.png', 'admin', 'images/20190620/515217a8f0bc8a2b02dc25452150ffb0.png', '', '', 'image/png', 'png', '12897', '637156ffa91adaef25d185deacdbe549', 'ee244512bbebc76c2ef59ed71fefea0ee3fbed08', 'local', '1561022074', '1561022074', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('63', '1', '0', 'park权限.txt', 'admin', 'files/20190620/5dda1b0a9dc42fbc12552b56af2ccb2e.txt', '', '', 'text/plain', 'txt', '255', 'ea2010877d886e10e3d9e836917ab331', '3e890d6b7066d8f105b076b0eef2eb9043bf95b7', 'local', '1561022094', '1561022094', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('64', '1', '0', '20190408143817.png', 'admin', 'images/20190620/078830e192b9b7f509173347c2100423.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1561022236', '1561022236', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('65', '1', '0', 'park权限.txt', 'admin', 'files/20190620/3fe5fad97336e20e25a2fb01f8b238db.txt', '', '', 'text/plain', 'txt', '255', 'ea2010877d886e10e3d9e836917ab331', '3e890d6b7066d8f105b076b0eef2eb9043bf95b7', 'local', '1561022244', '1561022244', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('69', '1', '0', '20190111145119.png', 'admin', 'images/20190621/d60cfafb4a6ef98f9e3bb05e83eb424b.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1561085204', '1561085204', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('68', '1', '0', '20190111145119.png', 'admin', 'images/20190620/681176acd8df97e515d89cc8b10e01f3.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1561024684', '1561024684', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('70', '1', '0', '20190111145119.png', 'admin', 'images/20190621/89be89c0656082b8123f114539b07bec.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1561087205', '1561087205', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('71', '1', '0', '20190408143817.png', 'admin', 'images/20190621/bf24b719ecfc4aec9d9d0bd55744a452.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1561087294', '1561087294', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('72', '1', '0', '20190408143817.png', 'admin', 'images/20190621/6442aa169be4315c0b0a9ca5282b9295.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1561088589', '1561088589', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('73', '1', '0', '20190111145119.png', 'admin', 'images/20190621/709bee03696fb7ff3baf17dec3c4dc9c.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1561096450', '1561096450', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('74', '1', '0', '20190408143817.png', 'admin', 'images/20190621/864d045adf98a7123b66dfb0b5914f96.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1561096528', '1561096528', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('75', '1', '0', 'logo_unionpay.jpg', 'admin', 'images/20190621/3d919e119945620e0cb5fe4d63ea4cc9.jpg', '', '', 'image/jpeg', 'jpg', '18877', '21bc331d6cf72f7dc80798babe7da691', '0a271f28781ef011ca1664f71a168cf292b650fc', 'local', '1561096547', '1561096547', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('76', '1', '0', '20190408143817.png', 'admin', 'images/20190621/cda42bc1e43b776613507897e60a9b8a.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1561101911', '1561101911', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('77', '1', '0', '798e2dee52be554140d93f83e46bd6dd.jpg', 'admin', 'images/20190621/6f76acbdac648347e274ddd937b75b24.jpg', '', '', 'image/jpeg', 'jpg', '135722', '3efff8d5b61537631cbc4af56269c259', '7eca0ba45da827f4fd871b7315b5da02314e0049', 'local', '1561101945', '1561101945', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('78', '1', '0', '798e2dee52be554140d93f83e46bd6dd.jpg', 'admin', 'images/20190622/6d432d7587301e0ad5c12412b25dd098.jpg', '', '', 'image/jpeg', 'jpg', '135722', '3efff8d5b61537631cbc4af56269c259', '7eca0ba45da827f4fd871b7315b5da02314e0049', 'local', '1561183574', '1561183574', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('79', '1', '0', '798e2dee52be554140d93f83e46bd6dd.jpg', 'admin', 'images/20190622/b0b304c49452c54890ec0f24d08dd819.jpg', '', '', 'image/jpeg', 'jpg', '135722', '3efff8d5b61537631cbc4af56269c259', '7eca0ba45da827f4fd871b7315b5da02314e0049', 'local', '1561183985', '1561183985', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('80', '1', '0', '视频文件.mp4', 'admin', 'files/20190628/958d58466aa8b09ba40855b271121a44.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1561691641', '1561691641', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('81', '1', '0', 'QQ浏览器截图20190703151343.jpg', 'cms', 'images/20190703/869a5e5f04566a7836fab6895677c994.jpg', '', '', 'image/jpeg', 'jpg', '18928', '2800e1183b68a7e95209eea31d5f060a', 'bb23be06858950f4f7cc9ec5d8d290c910772c37', 'local', '1562138026', '1562138026', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('82', '8', '0', 'QQ浏览器截图20190703151343.jpg', 'cms', 'images/20190703/68fb1a3c5679a60bf2ad0cde213e34c2.jpg', '', '', 'image/jpeg', 'jpg', '18928', '2800e1183b68a7e95209eea31d5f060a', 'bb23be06858950f4f7cc9ec5d8d290c910772c37', 'local', '1562138472', '1562138472', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('83', '8', '0', '五百滩.xlsx', 'cms', 'files/20190704/bf26b559952284a9878bf56bd49820cf.xlsx', '', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.shee', 'xlsx', '10619', '43662367bc9497369322e505d621fa28', 'f6103a007ccd448b1d7ee2dede5db2e4ee7faea3', 'local', '1562230817', '1562230817', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('84', '8', '0', '五百滩.xlsx', 'cms', 'files/20190704/28bd966ba7d3c6dd9b8243917765a748.xlsx', '', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.shee', 'xlsx', '10619', '43662367bc9497369322e505d621fa28', 'f6103a007ccd448b1d7ee2dede5db2e4ee7faea3', 'local', '1562230872', '1562230872', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('85', '8', '0', '王菲-MV.mp4', 'cms', 'files/20190705/8748237ce94e18287b9bd2d6f4fde20c.mp4', '', '', 'video/mp4', 'mp4', '16454237', '4278e1b59c2f04b40e94b0ded9b08e08', '76693f73cf80644e67fe9b6084960208aa645c7f', 'local', '1562285308', '1562285308', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('86', '8', '0', '五百滩.xlsx', 'cms', 'files/20190705/2b115ee312b4e5910d995a33af79dd1d.xlsx', '', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.shee', 'xlsx', '10619', '43662367bc9497369322e505d621fa28', 'f6103a007ccd448b1d7ee2dede5db2e4ee7faea3', 'local', '1562286246', '1562286246', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('87', '8', '0', '五百滩.xlsx', 'cms', 'files/20190705/f0685a782105ceaa73f057c06c7669c6.xlsx', '', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.shee', 'xlsx', '10619', '43662367bc9497369322e505d621fa28', 'f6103a007ccd448b1d7ee2dede5db2e4ee7faea3', 'local', '1562286447', '1562286447', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('88', '8', '0', '王菲-MV.mp4', 'cms', 'files/20190705/c691666b8aafe1e702be82324693e003.mp4', '', '', 'video/mp4', 'mp4', '16454237', '4278e1b59c2f04b40e94b0ded9b08e08', '76693f73cf80644e67fe9b6084960208aa645c7f', 'local', '1562286756', '1562286756', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('89', '8', '0', 'QQ浏览器截图20190703151343.jpg', 'cms', 'images/20190705/0842e8e4d35b956cb5f95dacba51a72b.jpg', '', '', 'image/jpeg', 'jpg', '18928', '2800e1183b68a7e95209eea31d5f060a', 'bb23be06858950f4f7cc9ec5d8d290c910772c37', 'local', '1562286786', '1562286786', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('90', '8', '0', '王菲-MV.mp4', 'cms', 'files/20190705/bae64c9924f00ddd647fa4e1300f24a1.mp4', '', '', 'video/mp4', 'mp4', '16454237', '4278e1b59c2f04b40e94b0ded9b08e08', '76693f73cf80644e67fe9b6084960208aa645c7f', 'local', '1562286787', '1562286787', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('91', '2', '0', 'QQ浏览器截图20190703151343.jpg', '', 'images/20190705/8853c9a2413d1ef5a55f8f5dd5e92f12.jpg', '', '', 'image/jpeg', 'jpg', '18928', '2800e1183b68a7e95209eea31d5f060a', 'bb23be06858950f4f7cc9ec5d8d290c910772c37', 'local', '1562296449', '1562296449', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('92', '2', '0', 'QQ浏览器截图20190703151343.jpg', '', 'images/20190705/8f3e92b825f194208dd336a0b89fe90f.jpg', '', '', 'image/jpeg', 'jpg', '18928', '2800e1183b68a7e95209eea31d5f060a', 'bb23be06858950f4f7cc9ec5d8d290c910772c37', 'local', '1562296468', '1562296468', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('93', '10', '0', '登录界面1.png', '', 'images/20190708/7a2741b0f5aaab9c49d7b0745cc19e60.png', '', '', 'image/png', 'png', '750514', '1252e6cb5058b55f82252c4624715d0b', '43c139ef4c5dd64d232ef79940273fbc059927bb', 'local', '1562555251', '1562555251', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('94', '2', '0', '10256.xlsx', 'cms', 'files/20190708/2812ff458f8140afd431596ba7764a14.xlsx', '', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.shee', 'xlsx', '33167', '3ec21704315ab351376c1dba30616e4b', 'edafe79fdb57481f418ea8368583412492f2866c', 'local', '1562555317', '1562555317', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('95', '2', '0', '10256.xlsx', 'cms', 'files/20190708/f8b14745986ed85f8f917169b8e6ad16.xlsx', '', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.shee', 'xlsx', '33167', '3ec21704315ab351376c1dba30616e4b', 'edafe79fdb57481f418ea8368583412492f2866c', 'local', '1562555327', '1562555327', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('96', '2', '0', '银联扣款超过3秒记录.txt', 'cms', 'files/20190708/50216f4e8ed05ee43f48696d03b2f67f.txt', '', '', 'text/plain', 'txt', '3051', 'fe2e62382a670b332045d2122759d09c', 'ff206468d22412268e35878abf5570bf67880a00', 'local', '1562555333', '1562555333', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('97', '2', '0', '10256.xlsx', 'cms', 'files/20190708/c1292c5f9693a1002f37889367b8a997.xlsx', '', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.shee', 'xlsx', '33167', '3ec21704315ab351376c1dba30616e4b', 'edafe79fdb57481f418ea8368583412492f2866c', 'local', '1562555402', '1562555402', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('98', '2', '0', '银联扣款超过3秒记录.txt', 'cms', 'files/20190708/bfb1d4c8bbf4aef9b6890544b8801b4d.txt', '', '', 'text/plain', 'txt', '3051', 'fe2e62382a670b332045d2122759d09c', 'ff206468d22412268e35878abf5570bf67880a00', 'local', '1562555413', '1562555413', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('99', '10', '0', '海关项目修改清单0624(1).docx', 'admin', 'files/20190708/83393f90df7f71b25c3a21a6eeff6d44.docx', '', '', 'application/octet-stream', 'docx', '68450', '6306b333ae49793b519d6cd7281dec61', '97ff0812c0195cced3f2438eefde8c1c51817f37', 'local', '1562555501', '1562555501', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('100', '10', '0', '新建 XLSX 工作表.xlsx', 'admin', 'files/20190708/b0cab8dbdaf810c01492b397c6242c21.xlsx', '', '', 'application/octet-stream', 'xlsx', '9991', '29a6d39c8137f470d61a4b7a6fb202a2', '7f980b617fa10f09a201afa07f9bbe46efa298e9', 'local', '1562555637', '1562555637', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('101', '10', '0', '值班系统.xls', 'admin', 'files/20190708/a8a29171c1f57512f782a08e52455a52.xls', '', '', 'application/octet-stream', 'xls', '21504', '0706a2cf5d4b3e812df824d2b6cd7a1b', 'fd8a6874e951c7fe9f24aa1ea225e3d14d916288', 'local', '1562555650', '1562555650', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('102', '10', '0', '值班信息.png', '', 'images/20190708/239b6dbc60a781080de926f4ca35a6af.png', '', '', 'image/png', 'png', '206479', '4caccf15401a4237be67b1a57e58066f', 'f86a84dd39859a43644605dc442ab2c466c276b1', 'local', '1562555843', '1562555843', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('103', '9', '0', '新建 XLSX 工作表.xlsx', 'admin', 'files/20190708/cbb7eba3d012a773e2b1e010118d71eb.xlsx', '', '', 'application/octet-stream', 'xlsx', '9991', '29a6d39c8137f470d61a4b7a6fb202a2', '7f980b617fa10f09a201afa07f9bbe46efa298e9', 'local', '1562568673', '1562568673', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('104', '9', '0', '值班系统.xls', 'admin', 'files/20190708/05a5e6183214364fca75f96243ae00a1.xls', '', '', 'application/octet-stream', 'xls', '21504', '0706a2cf5d4b3e812df824d2b6cd7a1b', 'fd8a6874e951c7fe9f24aa1ea225e3d14d916288', 'local', '1562568673', '1562568673', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('105', '1', '0', 'logo.jpg', '', 'images/20190710/35f663c4c17b8ce11728477ff092a6b9.jpg', '', '', 'image/jpeg', 'jpg', '16383', '3d676ad49586650b03a3e16de1471a26', '685276ae20d647f6178ede0e0c588c95f5294b80', 'local', '1562731429', '1562731429', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('106', '1', '0', '新建文本文档.txt', 'admin', 'files/20190710/74e9b0daa5d0f503d2e81aa7c45e01d5.txt', '', '', 'text/plain', 'txt', '135', '9e9ecfd6fb70c512959bd5bde915e543', '81b0d02333145d11b6c8e528deaa7d1c18d7fefc', 'local', '1562731457', '1562731457', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('107', '1', '0', '值班系统.xls', 'admin', 'files/20190710/9af4fe87a88b035cc315270686cef4d9.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1562731457', '1562731457', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('108', '1', '0', 'logo.jpg', '', 'images/20190710/3f37a6ea9cb2c530debc54b58fafe150.jpg', '', '', 'image/jpeg', 'jpg', '16383', '3d676ad49586650b03a3e16de1471a26', '685276ae20d647f6178ede0e0c588c95f5294b80', 'local', '1562732936', '1562732936', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('109', '1', '0', '值班系统.xls', 'admin', 'files/20190710/871d52d96bf918a40d3c02ddf56e8142.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1562732970', '1562732970', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('110', '1', '0', '海关项目修改清单0624(1).docx', 'admin', 'files/20190710/c081cd0316958ab5abbf017ddb647908.docx', '', '', 'application/octet-stream', 'docx', '68450', '6306b333ae49793b519d6cd7281dec61', '97ff0812c0195cced3f2438eefde8c1c51817f37', 'local', '1562732971', '1562732971', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('111', '0', '4', 'https://p1.ssl.qhimg.com/t0151320b1d0fc50be8.png', 'admin', 'images/20190711/6a7da7c0d15028947ba0f042b543d3ea.png', '', '', 'image/png', 'png', '5471', '4fcbe239111201c3d78e23ae86147590', 'bb351704d0b98ca7530bfbe6863369d8d4799a74', 'local', '1562810636', '1562810636', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('112', '4', '0', '值班系统.xls', 'admin', 'files/20190711/ae1e0ff8098bfda7d0d6eee8b4ce8853.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1562810782', '1562810782', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('113', '4', '0', '值班系统.xls', 'admin', 'files/20190711/a34de85fc83fb2d80c33a67fcf07f031.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1562810916', '1562810916', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('114', '4', '0', '值班系统.xls', 'admin', 'files/20190711/653040210f6ffaf12c83b9d31d5858cb.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1562811717', '1562811717', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('115', '4', '0', '值班系统.xls', 'admin', 'files/20190711/c88ccdbd23b5abe76ac6baf1ac5236c5.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1562812478', '1562812478', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('116', '4', '0', '海关UI界面(3).zip', 'admin', 'files/20190711/49bc0baa80f2c82d8be0782b46c53f74.zip', '', '', 'application/x-zip-compressed', 'zip', '3559762', '257aa5c4c03206d7862ec91414cebf16', '40652927c690b36f4e40db5950a62b2728055045', 'local', '1562812795', '1562812795', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('117', '1', '0', '值班系统.xls', 'admin', 'files/20190711/d21742f37505ef15874d0efbae1013d1.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1562832617', '1562832617', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('118', '1', '0', '值班系统.xls', 'admin', 'files/20190711/97b24a0e297dd3bc74e03628cf1bca61.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1562833865', '1562833865', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('119', '4', '0', '24_save.png', 'admin', 'images/20190712/259c1adef0308e679464508aaac8c069.png', '', '', 'image/png', 'png', '895', '6bab367d69099d49685ba4b1e893b11b', '66faeaae682bc685dc781d7a6161aab30a6f90ce', 'local', '1562891722', '1562891722', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('120', '4', '0', '视频文件.mp4', 'admin', 'files/20190712/58208ad4aaaee2f5d2cc7388d597d0a5.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1562891732', '1562891732', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('121', '5', '0', 'file0001(1)(2)(3).jpg', '', 'images/20190713/58b33a49a3efadaf61bf41836be55975.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1562984040', '1562984040', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('122', '5', '0', 'file0001(1)(2)(3).jpg', '', 'images/20190713/fa7b5a8d8029187b176c968e11870ff6.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1562984056', '1562984056', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('123', '5', '0', 'V9._1100106221_20190404105135.rar', 'admin', 'files/20190713/61fd12f602fa012628990079a60c3a90.rar', '', '', 'application/octet-stream', 'rar', '84022564', '3eba3fc2d0e7ab168a0d0e70922b19c7', '8b3e9532971ba5caec754ae120946059d3ce45a8', 'local', '1562987871', '1562987871', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('124', '5', '0', '暂放.txt', 'admin', 'files/20190713/a5513ff0bab26d896fd472172243eac8.txt', '', '', 'text/plain', 'txt', '38', '485a88910a8495f4c6faef628532f883', '5e94524046075702b685c2acf7ba5220620fbabb', 'local', '1562993285', '1562993285', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('125', '5', '0', 'file0001(1)(2)(3).jpg', 'admin', 'images/20190713/3a5e7f11be6c593f2df67d9b6a50a8c2.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1562995166', '1562995166', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('126', '5', '0', '王菲-MV.mp4', 'admin', 'files/20190713/aa3abeefda6103c2b8386697bfbfb4b8.mp4', '', '', 'video/mp4', 'mp4', '16454237', '4278e1b59c2f04b40e94b0ded9b08e08', '76693f73cf80644e67fe9b6084960208aa645c7f', 'local', '1562995178', '1562995178', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('127', '4', '0', '值班信息.png', 'admin', 'images/20190716/c97377ce5f9e0b62f32539ce5a47a433.png', '', '', 'image/png', 'png', '206479', '4caccf15401a4237be67b1a57e58066f', 'f86a84dd39859a43644605dc442ab2c466c276b1', 'local', '1563258873', '1563258873', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('128', '1', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190719/577e7799f77a9ce72ccd22a11859def0.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563525011', '1563525011', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('129', '1', '0', '1579e247dd9bbd932ff804540d3cfd17.png', '', 'images/20190719/49e31875ac56511e126dc3303b151963.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563525020', '1563525020', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('130', '1', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190719/f0ea75e3c901acd4352ac0b5c876bd88.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563525208', '1563525208', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('131', '1', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190719/ac03aa29db4d5f01fc1ba7abe144bb91.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563526505', '1563526505', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('132', '4', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190719/de6720a15683764aa77f685a7fe896cd.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563527242', '1563527242', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('133', '5', '0', '石家庄海关监督销毁786吨进口霉变大豆.jpg', 'admin', 'images/20190719/e2ec0b7f6a6dfb0d3786613856be3848.jpg', '', '', 'image/jpeg', 'jpg', '317931', '629fd125b8a8d40bf8a35d3d5e0bca61', '2c69eb614b2d699e32657a0f1765c53944b6574b', 'local', '1563533100', '1563533100', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('134', '5', '0', 'image001(1).jpg', 'admin', 'images/20190719/415f22d67082033342dadfecf2943ba7.jpg', '', '', 'image/jpeg', 'jpg', '196693', 'd40e5e60944a25380b1165fc6c3c57e0', '5bdfd12610e74b7e3f49c35ee2973fdfe14b456e', 'local', '1563533112', '1563533112', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('135', '5', '0', 'fa7b5a8d8029187b176c968e11870ff6.jpg', 'admin', 'images/20190719/93ee13b788fd0ed1f797a30c21f3aeb7.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1563533118', '1563533118', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('136', '1', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190722/20a14b8bc5114aa1b737f59be5de946c.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563762299', '1563762299', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('137', '1', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190722/2ab6abea3b964f370afda3a52f82f01d.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563767465', '1563767465', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('138', '1', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190722/609dac5b0a8e8c94f2c3bc51de76420c.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563777529', '1563777529', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('139', '10', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190722/ac941698b155c83b029f1ba669e32384.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563785835', '1563785835', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('140', '9', '0', 'fa7b5a8d8029187b176c968e11870ff6.jpg', 'admin', 'images/20190722/64665e82a47d98a605f36f50eb14e83b.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1563786271', '1563786271', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('141', '4', '0', 'fa7b5a8d8029187b176c968e11870ff6.jpg', 'admin', 'images/20190723/15afa72107ca6ce26794edacbe9daba5.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1563842027', '1563842027', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('142', '4', '0', 'DSC_6502.JPG', 'admin', 'images/20190723/91b060f72a74dd4b3fac60b286fb284f.JPG', '', '', 'image/jpeg', 'JPG', '15343232', '661d70add8816045d3350cd8d33e2f03', '030e65854bc172b143320d32731373735b5c27bc', 'local', '1563846369', '1563846369', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('143', '4', '0', 'fa7b5a8d8029187b176c968e11870ff6.jpg', 'admin', 'images/20190723/1f3500ede3e389f1ab252fae800d89ce.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1563864179', '1563864179', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('144', '4', '0', 'fa7b5a8d8029187b176c968e11870ff6.jpg', 'admin', 'images/20190723/0241258d65e9ab435153d3d958c07151.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1563865087', '1563865087', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('145', '4', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190724/eb5f334ec663ce5f5b3465a904e265e1.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563950355', '1563950355', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('146', '307', '0', '新建 XLSX 工作表.xlsx', 'admin', 'files/20190724/a4b598c4e43c96ee969a10880ecf9e28.xlsx', '', '', 'application/octet-stream', 'xlsx', '9991', '29a6d39c8137f470d61a4b7a6fb202a2', '7f980b617fa10f09a201afa07f9bbe46efa298e9', 'local', '1563951753', '1563951753', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('147', '307', '0', '新建文本文档.txt', 'admin', 'files/20190724/44f7ee5b362a4aa7a88af40fd5099649.txt', '', '', 'text/plain', 'txt', '135', '9e9ecfd6fb70c512959bd5bde915e543', '81b0d02333145d11b6c8e528deaa7d1c18d7fefc', 'local', '1563951754', '1563951754', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('148', '4', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190724/1fd0cfa26fbb66676e8ea13522f13ad8.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563958630', '1563958630', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('149', '4', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190724/3fb4914e2050c70fe31cbfb2922942b0.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563958649', '1563958649', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('150', '4', '0', '1579e247dd9bbd932ff804540d3cfd17.png', 'admin', 'images/20190724/4816799f3488c6446e2ea989eb3c5c3f.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563958656', '1563958656', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('151', '4', '0', '视频文件.mp4', 'admin', 'files/20190724/abef53121aef51290ba5e73bc6891ab7.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1563958724', '1563958724', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('152', '4', '0', '视频文件.mp4', 'admin', 'files/20190724/c71c9ea2120baf8dc92a053383604ec8.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1563959283', '1563959283', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('153', '4', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190724/9845ae46b4c9f853ba620e48acd37cf1.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1563959292', '1563959292', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('154', '4', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190725/d622d08df5519d31839a3dbc41211b90.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1564043330', '1564043330', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('155', '4', '0', '视频文件.mp4', 'admin', 'files/20190725/6f02dc85556206817654c452e04bc5d4.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1564043338', '1564043338', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('156', '307', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190725/5565f9cfedd8935e4e91f3d32d7e7c1e.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1564043376', '1564043376', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('157', '1', '0', '1.xls', 'admin', 'files/20190725/eceb595322f37f5ac4b4d8f63b8158bd.xls', '', '', 'application/octet-stream', 'xls', '24576', '99132b9e935daf1d0dd9b0dd9ae1c4ed', '14093402808499eb8f02fd44825d83e319a725aa', 'local', '1564046431', '1564046431', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('158', '307', '0', '1.xls', 'admin', 'files/20190726/7c85c3f2d10de35d99ebaa70eb7b7429.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1564104390', '1564104390', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('159', '307', '0', '1.xls', 'admin', 'files/20190726/01262fe9c0b771e87c6fcd751881b340.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1564104535', '1564104535', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('160', '307', '0', '1.xls', 'admin', 'files/20190726/b7846f3d26862443bbd7c7dae331eb29.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1564105470', '1564105470', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('161', '169', '0', 'DSC_6502.JPG', 'admin', 'images/20190730/1a7083f77149aaf31cd2bb34bf3bc116.JPG', '', '', 'image/jpeg', 'JPG', '15343232', '661d70add8816045d3350cd8d33e2f03', '030e65854bc172b143320d32731373735b5c27bc', 'local', '1564473597', '1564473597', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('162', '169', '0', 'DSC_6502.JPG', 'admin', 'images/20190730/c8ef5d0e48005373e063a58120f94296.JPG', '', '', 'image/jpeg', 'JPG', '15343232', '661d70add8816045d3350cd8d33e2f03', '030e65854bc172b143320d32731373735b5c27bc', 'local', '1564473938', '1564473938', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('163', '169', '0', 'DSC_6502.JPG', 'admin', 'images/20190730/ae8c4df412d9baa0e7100d2f63254d43.JPG', '', '', 'image/jpeg', 'JPG', '15343232', '661d70add8816045d3350cd8d33e2f03', '030e65854bc172b143320d32731373735b5c27bc', 'local', '1564474560', '1564474560', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('164', '248', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190801/c75889b7e1442de8b624d336522eb98d.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1564650621', '1564650621', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('165', '248', '0', 'fa7b5a8d8029187b176c968e11870ff6.jpg', 'admin', 'images/20190801/00d194928b685b47a2e4c0d10d726125.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1564650621', '1564650621', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('166', '248', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190801/241d08d69026582907e7a364889e4dca.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1564651658', '1564651658', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('167', '248', '0', 'fa7b5a8d8029187b176c968e11870ff6.jpg', 'admin', 'images/20190801/afcc1ea6f87c671de57395556e0ec479.jpg', '', '', 'image/jpeg', 'jpg', '248545', 'fd543a2541b6073036ec5ed222a0e5ec', '07d692c03520b787ca0807dc7030c905d6503d23', 'local', '1564651658', '1564651658', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('168', '1', '0', '1.xls', 'admin', 'files/20190802/9098c76507e55c7aafc4c5adbe142029.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1564736000', '1564736000', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('169', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190803/fbe065dcc49977c6c2d5630098d67cc3.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1564799873', '1564799873', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('170', '169', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190803/a2a93cef996fd1926ca3d1fe67733251.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1564799896', '1564799896', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('171', '1', '0', '2531170_094852103000_2.jpg', 'admin', 'images/20190808/74c9f1cbc5e884b6928d5668345f09da.jpg', '', '', 'image/jpeg', 'jpg', '113270', '6fc68b0176537e0589a2b161ad65c24b', 'af6343f59066f1d81033f63b7059931b2f7cf65b', 'local', '1565228676', '1565228676', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('172', '169', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190808/7219e586482bedae2ee91695ff1b8c2f.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565245231', '1565245231', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('173', '290', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190808/6a1a9f6024f84ec7d19efa9118f424f5.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565250780', '1565250780', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('174', '172', '0', '视频文件.mp4', 'admin', 'files/20190812/e4f2c285eeef3fd876b3cde7c0566111.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1565597929', '1565597929', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('175', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190812/a3b2f7ad01fce82cb5e6f296331b4663.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565602288', '1565602288', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('176', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190812/961bce996a4dd8a9abe93ad75eebf91f.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565602868', '1565602868', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('177', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190812/0f2c396a233148d2ae83632479f9e6b9.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565602962', '1565602962', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('178', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190812/7c03c181988e483f6b741ff8cc06d1c6.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565603281', '1565603281', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('179', '1', '0', 'jianyuelansejianbiansebeijingsucai_5837751_small.j', 'admin', 'images/20190812/2769454fb97a2b9fc0aeec5df29f4f0e.jpg', '', '', 'image/jpeg', 'jpg', '16704', '7cc460c8458e5da2b1a4e5faab24f0fc', 'e242055bea65cebdcbb4c1b13d18073b6a4099a7', 'local', '1565606024', '1565606024', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('180', '1', '0', 'jianyuelansejianbiansebeijingsucai_5837751_small.j', '', 'images/20190812/89b0691dde65767b44972905faa6af7b.jpg', '', '', 'image/jpeg', 'jpg', '16704', '7cc460c8458e5da2b1a4e5faab24f0fc', 'e242055bea65cebdcbb4c1b13d18073b6a4099a7', 'local', '1565607085', '1565607085', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('181', '1', '0', '金华海关2.png', '', 'images/20190815/2d729f282bd4721aa050fb1a392c04d9.png', '', '', 'image/png', 'png', '1334582', '54903db4ea1ab9f4f10c6174e17e8190', '4680f6719fd7103cd04fe20315abd9c610a01ec0', 'local', '1565834990', '1565834990', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('182', '1', '0', '登录界面1.png', '', 'images/20190815/0f652754a76486158af7c81521d16f10.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565836148', '1565836148', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('183', '1', '0', '登录界面1.png', '', 'images/20190815/d80268833d0c3f339996498ca98bfd55.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565836552', '1565836552', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('184', '1', '0', '登录界面1.png', '', 'images/20190815/fc4325a9ec0aab6283d6b0203e7d7f16.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565836613', '1565836613', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('185', '1', '0', '登录界面1.png', '', 'images/20190815/48a41ac36acbd4652940c5a0261e1fda.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565836665', '1565836665', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('186', '1', '0', '登录界面1.png', '', 'images/20190815/98b23ff8a4cd71948230888df41cb183.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565836702', '1565836702', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('187', '1', '0', '登录界面1.png', '', 'images/20190815/4cd3936e68174ed2ab245489d687b349.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565836813', '1565836813', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('188', '1', '0', '登录界面1.png', '', 'images/20190815/6f1e1625329148248224501e9263c333.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565836915', '1565836915', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('189', '1', '0', '金华海关2.png', '', 'images/20190815/a16a0a34df7953d05721e368ee05f956.png', '', '', 'image/png', 'png', '1334582', '54903db4ea1ab9f4f10c6174e17e8190', '4680f6719fd7103cd04fe20315abd9c610a01ec0', 'local', '1565836923', '1565836923', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('190', '1', '0', '登录界面1.png', '', 'images/20190815/fccf43ed3d5e039594cd8e79b5a54593.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565837217', '1565837217', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('191', '1', '0', '登录界面1.png', '', 'images/20190815/3fe2607164d2f708e726d2c6e2fb6852.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565837295', '1565837295', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('192', '1', '0', '登录界面1.png', '', 'images/20190815/2008217bec26e042af0a8c0f4c8e0fba.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565838469', '1565838469', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('193', '1', '0', '登录界面1.png', '', 'images/20190815/12b770be9170f54f5c232f7ff0312b82.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565839029', '1565839029', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('194', '1', '0', '登录界面1.png', '', 'images/20190815/e3ecdaff170d2f97a3362d053fa5dfd8.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565839089', '1565839089', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('195', '1', '0', '登录界面1.png', '', 'images/20190815/c08bd6fe28241eaf99e11598dfdfbf05.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565839421', '1565839421', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('196', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190815/2680dbc1464476240589c46f8b66e538.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565839840', '1565839840', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('197', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190815/16d81c3e0474114518e2e8d51a9dc261.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565839856', '1565839856', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('198', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190815/eeb283420e1f3772710bc3e64cd43261.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565840036', '1565840036', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('199', '1', '0', '值班信息.png', '', 'images/20190815/20ffc1a351ba7efe0b62e29c2300a47f.png', '', '', 'image/png', 'png', '206479', '4caccf15401a4237be67b1a57e58066f', 'f86a84dd39859a43644605dc442ab2c466c276b1', 'local', '1565844658', '1565844658', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('200', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190815/cc4732786643fb9465c7051b95d271fb.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565844675', '1565844675', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('201', '1', '0', '视频文件.mp4', '', 'videos/20190815/dde9d5c3e21ce5a4c13b94727ae9dbaf.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1565845422', '1565845422', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('202', '1', '0', '登录界面1.png', '', 'images/20190815/df610f9316f32272ad15f1dbbc79d4ca.png', '', '', 'image/png', 'png', '50948', 'e8d07a8e0d19c5d21e5a858f68bee974', 'a8f1defc4a95b65615e25a54a2c6635091537ac9', 'local', '1565847571', '1565847571', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('203', '1', '0', 'top.gif', '', 'images/20190815/0a28cb1eb074603a56df1c27766b2c5e.gif', '', '', 'image/gif', 'gif', '4792245', 'ed2e4e6d8e6efe3f819874754569a989', '81cfa0ba41ce6da6dfade99cdd0b644d33947ee6', 'local', '1565858571', '1565858571', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('204', '1', '0', 'login_bg.png', '', 'images/20190815/5d26a8b3f1ef74ed0289860e0c1b5805.png', '', '', 'image/png', 'png', '1078392', 'd59dcb40bedf1d16e626870589b7f581', '793df94391b072bc96c5a3e19fee7c7330b27dbc', 'local', '1565859008', '1565859008', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('205', '1', '0', '1.jpg', '', 'images/20190815/fa853d5b6eee857407cd0c67a006cee9.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565859209', '1565859209', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('206', '1', '0', '2.jpg', '', 'images/20190815/9f0145654208b0c1788b941e4804ea1b.jpg', '', '', 'image/jpeg', 'jpg', '21379', 'ade8a6bd998ffb2c50850c6a508b34d5', 'd80b46a07341fda0d52e76664c602158adfedcd7', 'local', '1565859777', '1565859777', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('207', '1', '0', '1.jpg', '', 'images/20190815/f637db59ed358c0ffdb3d8065ac7045f.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565860062', '1565860062', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('208', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190815/99210be305e5045ad019764014c2dbc9.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565860301', '1565860301', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('209', '1', '0', '1.jpg', '', 'images/20190815/6145ac2809be7acf1c88df756eb86329.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565861787', '1565861787', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('210', '1', '0', '1.jpg', '', 'images/20190815/8f15e0810361d79cc914a1f9b444762e.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565862245', '1565862245', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('211', '1', '0', '1.jpg', '', 'images/20190815/21c1ff8375ee7a317ca022f4cf2f1ff8.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565862716', '1565862716', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('212', '1', '0', '1.jpg', '', 'images/20190815/a68d373d0912d47e7314117debe43869.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565862825', '1565862825', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('213', '1', '0', '1.jpg', '', 'images/20190815/c491fd6e1570c1963087520aaa7e6c52.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565862939', '1565862939', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('214', '1', '0', '1.jpg', '', 'images/20190815/ed60270f3529a37648d1862a50c77687.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565863094', '1565863094', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('215', '1', '0', '1.jpg', '', 'images/20190815/da038918751d930cb42b6f25d3eed8a9.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565863207', '1565863207', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('216', '1', '0', '1.jpg', '', 'images/20190815/0b8f903b411eb46fde81001263176b51.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565863286', '1565863286', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('217', '1', '0', '1.jpg', '', 'images/20190815/2da4e1f107356b9edc731df157daa13d.jpg', '', '', 'image/jpeg', 'jpg', '17475', '29e68ac71c1ea6b275f56951a6002c52', '3b2a3308b3c2bb051896ef9ef3d3a42370c94c8d', 'local', '1565863635', '1565863635', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('218', '259', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190816/a18c0b51c7699b03922db23de8603fb9.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1565946553', '1565946553', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('219', '1', '0', '修改.txt', 'admin', 'files/20190821/a1367a0868db9306fcf06c4ba6af9556.txt', '', '', 'text/plain', 'txt', '153', '332b997bf3c30195c84fb7f96738b797', '551697b1bc0f7c38c85d6537c10555e4a65e7f57', 'local', '1566351346', '1566351346', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('220', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190821/c97a9fb10ccdf6f05345b21fff84df18.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566353834', '1566353834', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('221', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190821/14948879797930289950ad59596ce097.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566358948', '1566358948', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('222', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190821/8d8d30cdedc54dc055c8efad8c165c77.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566359021', '1566359021', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('223', '1', '0', '1.xls', 'admin', 'files/20190821/9e26498c8a65e425cd1c49db9068a547.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1566359029', '1566359029', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('224', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190821/ed6b5fb4157346167d8be7bf636caae1.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566359115', '1566359115', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('225', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190821/578942f0118d2c9a295971f5f7c30504.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566359384', '1566359384', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('226', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190821/3da8bd797dd273e9f1a4e75399058b7f.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566363512', '1566363512', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('228', '1', '0', '1.xls', 'admin', 'files/20190821/d842781d6de4f4a24ab05b96e256bf31.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1566363644', '1566363644', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('229', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190821/c802780cca749d66edd15e2845ac7ecc.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566365747', '1566365747', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('230', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190821/38796792df249b869736efa37f05e0c0.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566365926', '1566365926', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('231', '1', '0', '1.xls', 'admin', 'files/20190821/2a534c21700ab23c3242e0bacad1bb92.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1566369746', '1566369746', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('232', '1', '0', '1.xls', 'admin', 'files/20190821/e76ba97fd32507faa9cca11249557048.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1566371665', '1566371665', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('233', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190821/f23ce4aff3200132a5c6adaab5951db1.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566373391', '1566373391', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('234', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'images/20190821/9ea35ba19d5207013b22d64a48debf91.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566373417', '1566373417', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('235', '1', '0', '1.xls', 'admin', 'files/20190821/cb2c6613d0a3661fd26fd9678dbea79c.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1566373423', '1566373423', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('236', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'http://localhost/images/20190821/4133e3d9c68cff690b7abff8c4bd6905.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'localhost', '1566373498', '1566373498', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('237', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'http://localhost/zfcms/public/uploads/images/20190821/28b3cf617311be06107d0251887fe0a2.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'localhost', '1566373818', '1566373818', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('238', '1', '0', '1.xls', 'admin', 'http://localhost/zfcms/public/uploads/files/20190821/889a115aae6aa213f84f3ad84a874492.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'localhost', '1566373852', '1566373852', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('239', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'http://116.62.62.90/zfcms/public/uploads/images/20190821/65365f178710455649f9f5fb76bc3c6a.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', '116.62.62.90', '1566375043', '1566375043', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('240', '1', '0', '1.xls', 'admin', 'http://116.62.62.90/zfcms/public/uploads/files/20190821/3961b2b24075f35cbd014d853c1d1794.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', '116.62.62.90', '1566375051', '1566375051', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('241', '1', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', '', 'http://116.62.62.90/zfcms/public/uploads/images/20190821/4e58d9a7fcae4e3a24d330b0cd3bbc8b.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', '116.62.62.90', '1566375157', '1566375157', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('242', '1', '0', '1.xls', 'admin', 'http://116.62.62.90/zfcms/public/uploads/files/20190821/adced018380b77952f595b8538688f82.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', '116.62.62.90', '1566375161', '1566375161', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('243', '169', '0', 'a1ba602c7e1d2ff60e1dffae5c0fc7df.png', 'admin', 'images/20190822/fc25c6673c58b6256b202f0fb36a276b.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1566438895', '1566438895', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('245', '1', '0', '1.xls', 'admin', 'files/20190905/f9676062a6d355b6b3cb3db0e11f284b.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1567667685', '1567667685', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('246', '1', '0', '1.xls', 'admin', 'files/20190905/08c1fe00a2e11e5a87aa948bbfa1be86.xls', '', '', 'application/octet-stream', 'xls', '24576', '2307db25bc162ac3b76c8b5ee33c2667', '016bf6a9ba90c74fd54aee24289e92eec6ca4d7e', 'local', '1567668167', '1567668167', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('247', '1', '0', '视频文件.mp4', 'admin', 'files/20190909/c97797a4b4643a6e820a3d2c3de5f93f.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1568020694', '1568020694', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('248', '1', '0', '3.jpg', 'admin', 'images/20190912/ebc14e2903a42b422f94adc3803c0c7a.jpg', '', '', 'image/jpeg', 'jpg', '1192233', '281feb429a40b5de2708c2f6be5db3f5', '2f392eb2e6c5022590d67b367f48b0cd78dae522', 'local', '1568256302', '1568256302', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('249', '1', '0', 'timg.jpg', 'admin', 'images/20190912/e220693057e68694492232fee53efc32.jpg', '', '', 'image/jpeg', 'jpg', '1344534', 'acce59469960b63882f9661357be50b6', '6479f701167db94e0b4d2e7129d5e4541e2a4dcf', 'local', '1568256306', '1568256306', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('251', '1', '0', 'timg (1).jpg', 'admin', 'images/20190912/39f25fd5397ab6fb0c448d1c41707c1a.jpg', '', '', 'image/jpeg', 'jpg', '925423', 'db2e21c736ebb52a037dec7a22f6aadc', '1ca3d39063d8af523115362cc8a3398aa1939053', 'local', '1568256373', '1568256373', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('252', '1', '0', '微信图片_20190906151835.jpg', 'admin', 'images/20190912/48e7f50a60ace109f03fb5efa159fee9.jpg', '', '', 'image/jpeg', 'jpg', '554969', '7e60e1f3a315a33c19dfd45cd93a7459', '04639378ee9df1b5663ee33a72bf0be152e73af1', 'local', '1568257456', '1568257456', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('253', '1', '0', '微信截图_20190912110401.png', 'admin', 'images/20190912/57920b0432a00a7ab4f78d9c524161b1.png', '', '', 'image/png', 'png', '124443', '2951ba923ec92cb40ce5b10822d53c5b', '4a1d6bd6f863570b5de54b193dfc5174460ec5a4', 'local', '1568257527', '1568257527', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('254', '172', '0', 'timg.jpg', 'admin', 'images/20190917/cdf461cb391e1ee482b4ae004200b038.jpg', '', '', 'image/jpeg', 'jpg', '203191', '860b66a4309d0cb889aea805694ce28d', '1cc4b50708a26f03a969cca78a922bd0241c8573', 'local', '1568705131', '1568705131', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('256', '1', '0', 'timg.jpg', 'admin', 'files/20190917/73923d6f5464e1ec203d1e868b2d8b2c.jpg', '', '', 'image/jpeg', 'jpg', '261462', '90d593159f1f4f948325bfd68ace67a1', '6f547d2a846d95601390dbbb22a2f556fbd55a89', 'local', '1568707594', '1568707594', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('260', '172', '0', '值班系统.xls', 'admin', 'files/20190917/213c819aeebc7ea2305aa6c0bb95d41d.xls', '', '', 'application/octet-stream', 'xls', '19456', '26fb89bdd7e80dbc86b8663d4b68cbb0', 'e2c7eae85f190047cfd67f6ce970bce30d0ce9d8', 'local', '1568709914', '1568709914', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('261', '172', '0', 'timg.jpg', 'admin', 'files/20190917/a37c57cc1187372d5960618fc9c4f453.jpg', '', '', 'image/jpeg', 'jpg', '261462', '90d593159f1f4f948325bfd68ace67a1', '6f547d2a846d95601390dbbb22a2f556fbd55a89', 'local', '1568709914', '1568709914', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('262', '169', '0', 'timg.jpg', 'admin', 'images/20190917/726b22ce66d0bbdff05e2b19660622f7.jpg', '', '', 'image/jpeg', 'jpg', '203191', '860b66a4309d0cb889aea805694ce28d', '1cc4b50708a26f03a969cca78a922bd0241c8573', 'local', '1568710391', '1568710391', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('263', '169', '0', 'timg.jpg', 'admin', 'images/20190917/8183c541d9b9590c428b61ff8d6a5183.jpg', '', '', 'image/jpeg', 'jpg', '203191', '860b66a4309d0cb889aea805694ce28d', '1cc4b50708a26f03a969cca78a922bd0241c8573', 'local', '1568710398', '1568710398', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('264', '169', '0', 'timg.jpg', 'admin', 'images/20190917/636ba0361d5e8f4aebe6cbebbb4509d1.jpg', '', '', 'image/jpeg', 'jpg', '203191', '860b66a4309d0cb889aea805694ce28d', '1cc4b50708a26f03a969cca78a922bd0241c8573', 'local', '1568711397', '1568711397', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('265', '169', '0', 'timg.jpg', 'admin', 'images/20190917/c56773ff53f1bb3c93627d6c7f568d50.jpg', '', '', 'image/jpeg', 'jpg', '203191', '860b66a4309d0cb889aea805694ce28d', '1cc4b50708a26f03a969cca78a922bd0241c8573', 'local', '1568711436', '1568711436', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('266', '169', '0', 'timg.jpg', 'admin', 'images/20190917/399bcf979f50842b534365a53d2786dc.jpg', '', '', 'image/jpeg', 'jpg', '203191', '860b66a4309d0cb889aea805694ce28d', '1cc4b50708a26f03a969cca78a922bd0241c8573', 'local', '1568711933', '1568711933', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('267', '1', '0', '土豆.jpg', 'admin', 'images/20190918/83d13bd09c23d435b38d075f25c48e57.jpg', '', '', 'image/jpeg', 'jpg', '21217', 'b95843803e258696d11660f1ab24cf01', '40271f966d07130a87dcfe22a2f4400514278c2e', 'local', '1568767323', '1568767323', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('269', '1', '0', '豆腐.jpg', 'admin', 'images/20190918/809900ac49cb1d416780de984246c75a.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1568767349', '1568767349', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('270', '1', '0', '鸡翅.jpg', 'admin', 'images/20190918/dd885ecde1f69cbb46eeb84864b069cf.jpg', '', '', 'image/jpeg', 'jpg', '30669', 'c467e68b3616007906fd28015310ba6b', '84c352e41521811ccb708e56d1fa8d5916275407', 'local', '1568767363', '1568767363', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('271', '1', '0', '豆腐.jpg', 'admin', 'images/20190918/d88a870ad6629f368463a93a118e4978.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1568767583', '1568767583', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('273', '1', '0', '豆腐.jpg', 'admin', 'images/20190918/44cc0c6d8ed65950511271217fb1700b.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1568767640', '1568767640', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('274', '1', '0', '豆腐.jpg', 'admin', 'images/20190918/05232a35e1ab79bd1c46d9d5615c0457.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1568767722', '1568767722', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('348', '1', '0', '1574040155124.bmp', '', 'images/20191226/e75003a4c359cd03de6da50256176d60.bmp', '', '', 'image/bmp', 'bmp', '82758', 'f045455ae15b6ce24d8503e9cb6901e0', 'e4e94f6ad1537517a31113f4c051d74c590ca815', 'local', '1577337358', '1577337358', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('312', '1', '0', '视频文件.mp4', 'admin', 'files/20190930/c99490f0365579d215297c2bdeb165a7.mp4', '', '', 'video/mp4', 'mp4', '1681378', '86663ea961ccab63046e9ff5d947fd06', '19a72305105f860cc303f8b24abd36c89e7facc7', 'local', '1569812903', '1569812903', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('313', '1', '0', '账号信息.txt', 'admin', 'files/20191008/ad97aa11d3d10a26ba235d62a439a2ae.txt', '', '', 'text/plain', 'txt', '370', '46bd9bcf6c5fa5cfa3ebe2fd676db966', '16cee70c6e1260e592365d2e22be707908e20966', 'local', '1570501298', '1570501298', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('314', '1', '0', '账号信息.txt', 'admin', 'files/20191008/791c6291f7c433c940717d35a36c1212.txt', '', '', 'text/plain', 'txt', '370', '46bd9bcf6c5fa5cfa3ebe2fd676db966', '16cee70c6e1260e592365d2e22be707908e20966', 'local', '1570501410', '1570501410', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('315', '1', '0', 'b1644ef98262c4c94cce147555a4098a.jpg', 'admin', 'images/20191029/e497acecee04ed8381187a0c6027de56.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1572332881', '1572332881', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('316', '1', '0', 'b1644ef98262c4c94cce147555a4098a.jpg', 'admin', 'images/20191029/4467a0fe9e094f0de7920d277a0c98d1.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1572333254', '1572333254', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('317', '169', '0', '豆腐.jpg', 'admin', 'images/20191108/dadd357d0fd2a4268a033eb4c85b91ef.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1573193409', '1573193409', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('318', '169', '0', '鸡翅.jpg', 'admin', 'images/20191108/0a482097d9c991c9de8557d832a47250.jpg', '', '', 'image/jpeg', 'jpg', '30669', 'c467e68b3616007906fd28015310ba6b', '84c352e41521811ccb708e56d1fa8d5916275407', 'local', '1573193409', '1573193409', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('319', '169', '0', '鸡翅.jpg', 'admin', 'images/20191108/29814a4958d1e19fb7f662d5db96044a.jpg', '', '', 'image/jpeg', 'jpg', '30669', 'c467e68b3616007906fd28015310ba6b', '84c352e41521811ccb708e56d1fa8d5916275407', 'local', '1573193430', '1573193430', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('320', '169', '0', '豆腐.jpg', 'admin', 'images/20191108/3883b123b9a5470426f5bda25307e7cf.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1573193430', '1573193430', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('321', '169', '0', '鸡翅.jpg', 'admin', 'images/20191108/e345192cde064c63f916873bc54b0b7f.jpg', '', '', 'image/jpeg', 'jpg', '30669', 'c467e68b3616007906fd28015310ba6b', '84c352e41521811ccb708e56d1fa8d5916275407', 'local', '1573193522', '1573193522', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('322', '1', '0', '豆腐.jpg', 'admin', 'images/20191108/e8a41093c6445ea5f8efd0d4445feaf7.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1573202680', '1573202680', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('323', '1', '0', '豆腐.jpg', 'admin', 'images/20191108/4a09490654a8023c155058191e2b159e.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1573202729', '1573202729', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('324', '169', '0', '豆腐.jpg', 'admin', 'images/20191108/be67d27d38ed4f63d1b3d974140bd4f9.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1573202821', '1573202821', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('325', '169', '0', '豆腐.jpg', 'admin', 'images/20191108/2428ae233eeab1aa08d2c6d6a6c172b1.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1573202843', '1573202843', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('326', '169', '0', '豆腐.jpg', 'admin', 'images/20191108/bdf096140da0976a8aa40cac21074704.jpg', '', '', 'image/jpeg', 'jpg', '9660', '9fccd6cbad58cfccbe03bb5d226befa2', '572ad5688c80ebad8606253da5b8f0e71b3692b5', 'local', '1573203171', '1573203171', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('327', '308', '0', '账号信息.txt', 'admin', 'files/20191111/7db7f96c8d7b93a54a3b4a327c3d0c86.txt', '', '', 'text/plain', 'txt', '370', '46bd9bcf6c5fa5cfa3ebe2fd676db966', '16cee70c6e1260e592365d2e22be707908e20966', 'local', '1573443087', '1573443087', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('328', '308', '0', '值班系统.xls', 'admin', 'files/20191111/0e5cea82cadc99bf2365231da9e81ab5.xls', '', '', 'application/octet-stream', 'xls', '19456', '26fb89bdd7e80dbc86b8663d4b68cbb0', 'e2c7eae85f190047cfd67f6ce970bce30d0ce9d8', 'local', '1573443127', '1573443127', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('342', '1', '0', '摄图网_500174600.jpg', 'admin', 'images/20191206/f76233dc8c8264eb7275b6904f77f36d.jpg', '', '', 'image/jpeg', 'jpg', '13577582', '8a45555d2326d5c82632fff5e3d7dd5a', '527689f42831bbf02ad7d1416bd6382f0b4ab234', 'local', '1575593314', '1575593314', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('330', '1', '0', '1579e247dd9bbd932ff804540d3cfd17.png', '', 'images/20191113/fa7e18bdf0c2e146961436b2801c2811.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1573623605', '1573623605', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('341', '1', '0', '123.jpg', 'admin', 'files/20191202/bbc2779c6ea4830bec37336d857a4c5b.jpg', '', '', 'image/jpeg', 'jpg', '41385', '5e9fd6c879ef3fcf5449817bb6d9a352', 'f18d3d2ae3ce0b05f6b813b7e243c644c28f343b', 'local', '1575274998', '1575274998', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('332', '169', '0', '4a09490654a8023c155058191e2b159e.jpg', 'admin', 'files/20191118/56252ed719a09d076c7dd2a877346b3c.jpg', '', '', 'image/jpeg', 'jpg', '10889', 'f2d2aa392327e96960b762bf5a89f18b', 'ff7b2a54573621b3e951926091aef552592ecd26', 'local', '1574039513', '1574039513', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('340', '1', '0', 'logo_unionpay.jpg', '', 'images/20191119/db61fb9b5d31181bd8ee3f0161ae3aec.jpg', '', '', 'image/jpeg', 'jpg', '18877', '21bc331d6cf72f7dc80798babe7da691', '0a271f28781ef011ca1664f71a168cf292b650fc', 'local', '1574147831', '1574147831', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('334', '1', '0', '1574040155124.bmp', 'admin', 'images/20191118/f0a2570318df7ffd73f001a5161301ad.bmp', '', '', 'image/bmp', 'bmp', '82758', 'f045455ae15b6ce24d8503e9cb6901e0', 'e4e94f6ad1537517a31113f4c051d74c590ca815', 'local', '1574040254', '1574040254', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('335', '1', '0', '1574040155124.bmp', 'admin', 'images/20191118/f89365082ce37512d03f7d998be47b51.bmp', '', '', 'image/bmp', 'bmp', '82758', 'f045455ae15b6ce24d8503e9cb6901e0', 'e4e94f6ad1537517a31113f4c051d74c590ca815', 'local', '1574040304', '1574040304', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('336', '1', '0', '微信截图_20191118092950.bmp', 'admin', 'images/20191118/88b10d8bf8deeeaf2241ace5f2e4844c.bmp', '', '', 'image/bmp', 'bmp', '6822774', '38beb70edcc9ce3b1a1da26c7d6a006c', '0388a555f4d25dc7e1ea1c2e9292adc993dff380', 'local', '1574040635', '1574040635', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('337', '1', '0', '微信截图_20191118093200.png', 'admin', 'images/20191118/94642a82a38d3cd6ae2786e430aec37f.png', '', '', 'image/png', 'png', '95316', 'e675d956946f78c591dcba93808f4d45', 'da7b40a7722a30e82a7a9d74b3bcff3f0e3e419f', 'local', '1574040755', '1574040755', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('338', '1', '0', '微信截图_20191118092950.bmp', 'admin', 'images/20191118/8dfcd56267aa51dff4ee1df9c032080b.bmp', '', '', 'image/bmp', 'bmp', '6822774', '38beb70edcc9ce3b1a1da26c7d6a006c', '0388a555f4d25dc7e1ea1c2e9292adc993dff380', 'local', '1574044004', '1574044004', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('343', '1', '0', '大数据优化.docx', 'admin', 'files/20191206/331598cdd2eec9689896afb9b7d4382a.docx', '', '', 'application/octet-stream', 'docx', '330275', '377de4810ad0ca599e165985c040ef47', '6d27db38e5c1f494d2715b79b8f3bfea72d09641', 'local', '1575594493', '1575594493', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('344', '1', '0', '新建 XLS 工作表 (2).xls', 'admin', 'files/20191206/287ef20e66af0e90114bae0567369d96.xls', '', '', 'application/octet-stream', 'xls', '18944', 'f75cbc1e8235897b556cdf2ac6b7d453', 'df536e2bffa7311a9625cae904985036a1963f41', 'local', '1575594544', '1575594544', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('345', '1', '0', '1574040155124.bmp', 'admin', 'images/20191206/d653fb9c5b3e6748e62f2a91dd55d855.bmp', '', '', 'image/bmp', 'bmp', '82758', 'f045455ae15b6ce24d8503e9cb6901e0', 'e4e94f6ad1537517a31113f4c051d74c590ca815', 'local', '1575596707', '1575596707', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('346', '1', '0', '新建 DOC 文档 (1).doc', 'admin', 'files/20191206/a40af9cb71c1c48fcec18a02896964c8.doc', '', '', 'application/octet-stream', 'doc', '9216', '080699ac023fc4e22b6f79197af39491', '54be1ee981c8e341401061458fc65ae17054cc99', 'local', '1575596739', '1575596739', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('347', '1', '0', '新建 DOC 文档 (1).doc', 'admin', 'files/20191206/ad40f9a1d717669f36acaee734ee58a2.doc', '', '', 'application/octet-stream', 'doc', '9216', '080699ac023fc4e22b6f79197af39491', '54be1ee981c8e341401061458fc65ae17054cc99', 'local', '1575598035', '1575598035', '100', '1', '0', '0');
INSERT INTO `yzn_attachment` VALUES ('349', '169', '0', '111', 'admin', 'images/20200318/611c35ab86c14814bfd912fe2a4b6cc6.bmp', '', '', 'image/bmp', 'bmp', '82758', 'f045455ae15b6ce24d8503e9cb6901e0', 'e4e94f6ad1537517a31113f4c051d74c590ca815', 'local', '1584518035', '1584518035', '100', '1', '1', '0');
INSERT INTO `yzn_attachment` VALUES ('350', '169', '0', 'www.png', 'admin', 'images/20200318/351ab63faedbbf2042f7d51d6bae9bd8.png', '', '', 'image/png', 'png', '3827', 'ba2e7e85154dcd5bd8d5c7164f771b17', 'dc47ef02b5ffc9af59271bee9d732b96e8db0c69', 'local', '1584518069', '1584518069', '100', '1', '1', '1');
INSERT INTO `yzn_attachment` VALUES ('351', '1', '0', 'admin', 'admin', 'images/20200318/c9a72688dd4fedc7cc92ae2de1f77b75.png', '', '', 'image/png', 'png', '4564', 'adb109ef68c3fe21b844181e9d42cd3a', 'd374be8236c3bc447c168c552b21f617ba99a121', 'local', '1584521860', '1584521860', '100', '1', '1', '1');

-- ----------------------------
-- Table structure for `yzn_auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_auth_group`;
CREATE TABLE `yzn_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `module` varchar(20) NOT NULL DEFAULT '' COMMENT '用户组所属模块',
  `type` tinyint(4) NOT NULL DEFAULT '3' COMMENT '角色类型（1:系统|2:经销商|3:物业）',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户组状态：为1正常，为0禁用,-1为删除',
  `rules` text NOT NULL COMMENT '用户组拥有的规则id，多个规则 , 隔开',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='权限组表';

-- ----------------------------
-- Records of yzn_auth_group
-- ----------------------------
INSERT INTO `yzn_auth_group` VALUES ('2', 'admin', '1', '物业管理员', '物业管理员', '1', '1,105,139,8,10,15,33,34,35,36');

-- ----------------------------
-- Table structure for `yzn_auth_rule`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_auth_rule`;
CREATE TABLE `yzn_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '规则所属module',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1-url;2-主菜单',
  `role_tyle` tinyint(4) NOT NULL DEFAULT '3' COMMENT '角色类型（1:系统|2:经销商|3:物业）',
  `name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `condition` varchar(300) NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`),
  KEY `module` (`module`,`status`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=334 DEFAULT CHARSET=utf8 COMMENT='规则表';

-- ----------------------------
-- Records of yzn_auth_rule
-- ----------------------------
INSERT INTO `yzn_auth_rule` VALUES ('1', 'admin', '2', '3', 'admin/index/index', '首页', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('3', 'admin', '1', '3', 'admin/config/index1', '系统配置', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('4', 'admin', '1', '3', 'admin/config/index', '配置管理', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('5', 'admin', '1', '3', 'admin/adminlog/deletelog', '删除日志', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('6', 'admin', '1', '3', 'admin/config/setting', '网站设置', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('7', 'admin', '1', '3', 'admin/menu/index', '菜单管理', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('8', 'admin', '1', '3', 'admin/manager/index1', '权限管理', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('9', 'admin', '1', '3', 'admin/manager/index', '管理员管理', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('10', 'admin', '1', '3', 'admin/authManager/index', '角色管理', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('11', 'admin', '1', '3', 'admin/manager/add', '添加管理员', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('12', 'admin', '1', '3', 'admin/manager/edit', '编辑管理员', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('13', 'admin', '1', '3', 'admin/adminlog/index', '管理日志', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('14', 'admin', '1', '3', 'admin/manager/del', '删除管理员', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('15', 'admin', '1', '3', 'admin/authManager/createGroup', '添加角色', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('16', 'admin', '1', '3', 'admin/menu/add', '新增菜单', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('17', 'admin', '1', '3', 'admin/menu/edit', '编辑菜单', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('18', 'admin', '1', '3', 'admin/menu/delete', '删除菜单', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('23', 'attachment', '1', '3', 'attachment/attachments/getUrlFile', '图片本地化', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('33', 'admin', '1', '3', 'admin/authManager/editGroup', '编辑角色', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('34', 'admin', '1', '3', 'admin/authManager/deleteGroup', '删除角色', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('35', 'admin', '1', '3', 'admin/authManager/access', '访问授权', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('36', 'admin', '1', '3', 'admin/authManager/writeGroup', '角色授权', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('41', 'cms', '1', '3', 'cms/cms/index2', '内容管理', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('42', 'cms', '1', '3', 'cms/cms/index', '管理内容', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('43', 'cms', '1', '3', 'cms/cms/panl', '面板', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('44', 'cms', '1', '3', 'cms/cms/public_categorys', '栏目列表', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('45', 'cms', '1', '3', 'cms/cms/classlist', '信息列表', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('46', 'cms', '1', '3', 'cms/cms/add', '添加', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('47', 'cms', '1', '3', 'cms/cms/edit', '编辑', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('48', 'cms', '1', '3', 'cms/cms/delete', '删除', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('49', 'cms', '1', '3', 'cms/cms/listorder', '排序', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('50', 'cms', '1', '3', 'cms/cms/setstate', '状态设置', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('55', 'cms', '1', '3', 'cms/category/index1', '相关设置', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('105', 'admin', '2', '3', 'admin/main/index', '控制面板', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('106', 'attachment', '1', '3', 'attachment/attachments/index', '附件管理', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('116', 'cms', '1', '3', 'cms/cms/remove', '批量移动', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('120', 'cms', '1', '3', 'cms/cms/examine', '审核', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('131', 'admin', '1', '3', 'admin/food/index', '菜品管理', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('133', 'admin', '1', '3', 'admin/food/add', '添加', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('134', 'admin', '1', '3', 'admin/food/edit', '编辑', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('135', 'admin', '1', '3', 'admin/food/delete', '删除', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('139', 'cms', '2', '3', 'cms/cms/index', '系统管理', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('178', 'admin', '2', '3', 'admin/manager/useredit', '资料修改', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('258', 'admin', '1', '3', 'admin/food/listorder', '排序', '-1', '');
INSERT INTO `yzn_auth_rule` VALUES ('331', 'admin', '1', '3', 'admin/config/add', '新增配置', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('332', 'admin', '1', '3', 'admin/config/edit', '编辑配置', '1', '');
INSERT INTO `yzn_auth_rule` VALUES ('333', 'admin', '1', '3', 'admin/config/del', '删除配置', '1', '');

-- ----------------------------
-- Table structure for `yzn_cache`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_cache`;
CREATE TABLE `yzn_cache` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `key` char(100) NOT NULL DEFAULT '' COMMENT '缓存KEY值',
  `name` char(100) NOT NULL DEFAULT '' COMMENT '名称',
  `module` char(20) NOT NULL DEFAULT '' COMMENT '模块名称',
  `model` char(30) NOT NULL DEFAULT '' COMMENT '模型名称',
  `action` char(30) NOT NULL DEFAULT '' COMMENT '方法名',
  `system` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否系统',
  PRIMARY KEY (`id`),
  KEY `ckey` (`key`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='缓存列队表';

-- ----------------------------
-- Records of yzn_cache
-- ----------------------------
INSERT INTO `yzn_cache` VALUES ('1', 'Config', '网站配置', 'admin', 'Config', 'config_cache', '1');
INSERT INTO `yzn_cache` VALUES ('2', 'Menu', '后台菜单', 'admin', 'Menu', 'menu_cache', '1');
INSERT INTO `yzn_cache` VALUES ('3', 'Module', '可用模块列表', 'admin', 'Module', 'module_cache', '1');
INSERT INTO `yzn_cache` VALUES ('4', 'Model', '模型列表', 'admin', 'Models', 'model_cache', '1');
INSERT INTO `yzn_cache` VALUES ('5', 'ModelField', '模型字段', 'admin', 'ModelField', 'model_field_cache', '1');
INSERT INTO `yzn_cache` VALUES ('6', 'Category', '栏目索引', 'cms', 'Category', 'category_cache', '0');
INSERT INTO `yzn_cache` VALUES ('7', 'Cms_Config', 'CMS配置', 'cms', 'Cms', 'cms_cache', '0');
INSERT INTO `yzn_cache` VALUES ('8', 'Member_Config', '会员配置', 'member', 'Member', 'member_cache', '0');
INSERT INTO `yzn_cache` VALUES ('9', 'Member_Group', '会员组', 'member', 'MemberGroup', 'membergroup_cache', '0');

-- ----------------------------
-- Table structure for `yzn_config`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_config`;
CREATE TABLE `yzn_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT '配置类型',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `group` varchar(32) NOT NULL DEFAULT '' COMMENT '配置分组',
  `options` varchar(255) NOT NULL DEFAULT '' COMMENT '配置项',
  `remark` varchar(100) NOT NULL DEFAULT '' COMMENT '配置说明',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `value` text COMMENT '配置值',
  `listorder` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`),
  KEY `type` (`type`),
  KEY `group` (`group`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='网站配置';

-- ----------------------------
-- Records of yzn_config
-- ----------------------------
INSERT INTO `yzn_config` VALUES ('1', 'web_site_icp', 'text', '备案信息', 'base', '', '', '1551244923', '1551244971', '1', '', '1');
INSERT INTO `yzn_config` VALUES ('2', 'web_site_statistics', 'textarea', '站点代码', 'base', '', '', '1551244957', '1551244957', '1', '', '100');
INSERT INTO `yzn_config` VALUES ('3', 'mail_type', 'radio', '邮件发送模式', 'email', '1:SMTP\r\n2:Mail', '', '1553652833', '1553652915', '1', '1', '1');
INSERT INTO `yzn_config` VALUES ('4', 'mail_smtp_host', 'text', '邮件服务器', 'email', '', '错误的配置发送邮件会导致服务器超时', '1553652889', '1553652917', '1', 'smtp.163.com', '2');
INSERT INTO `yzn_config` VALUES ('5', 'mail_smtp_port', 'text', '邮件发送端口', 'email', '', '不加密默认25,SSL默认465,TLS默认587', '1553653165', '1553653292', '1', '465', '3');
INSERT INTO `yzn_config` VALUES ('6', 'mail_auth', 'radio', '身份认证', 'email', '0:关闭\r\n1:开启', '', '1553658375', '1553658392', '1', '1', '4');
INSERT INTO `yzn_config` VALUES ('7', 'mail_smtp_user', 'text', '用户名', 'email', '', '', '1553653267', '1553658393', '1', '', '5');
INSERT INTO `yzn_config` VALUES ('8', 'mail_smtp_pass', 'text', '密码', 'email', '', '', '1553653344', '1553658394', '1', '', '6');
INSERT INTO `yzn_config` VALUES ('9', 'mail_verify_type', 'radio', '验证方式', 'email', '1:TLS\r\n2:SSL', '', '1553653426', '1553658395', '1', '2', '7');
INSERT INTO `yzn_config` VALUES ('10', 'mail_from', 'text', '发件人邮箱', 'email', '', '', '1553653500', '1553658397', '1', '', '8');
INSERT INTO `yzn_config` VALUES ('11', 'config_group', 'array', '配置分组', 'system', '', '', '1494408414', '1494408414', '1', 'base:基础\r\nsystem:系统\r\nupload:上传\r\ndevelop:开发', '0');
INSERT INTO `yzn_config` VALUES ('12', 'theme', 'text', '主题风格', 'system', '', '', '1541752781', '1541756888', '1', 'default123', '1');
INSERT INTO `yzn_config` VALUES ('13', 'admin_allow_ip', 'textarea', '后台禁止访问IP', 'system', '', '匹配IP段用\"*\"占位，如192.168.*.*，多个IP地址请用英文逗号\",\"分割', '1551244957', '1564122625', '1', '', '2');
INSERT INTO `yzn_config` VALUES ('14', 'upload_image_size', 'text', '图片上传大小限制', 'upload', '', '0为不限制大小，单位：kb', '1540457656', '1552436075', '1', '200', '2');
INSERT INTO `yzn_config` VALUES ('15', 'upload_image_ext', 'text', '允许上传的图片后缀', 'upload', '', '多个后缀用逗号隔开，不填写则不限制类型', '1540457657', '1552436074', '1', 'gif,jpg,jpeg,bmp,png', '1');
INSERT INTO `yzn_config` VALUES ('16', 'upload_file_size', 'text', '文件上传大小限制', 'upload', '', '0为不限制大小，单位：kb', '1540457658', '1552436078', '1', '200', '3');
INSERT INTO `yzn_config` VALUES ('17', 'upload_file_ext', 'text', '允许上传的文件后缀', 'upload', '', '多个后缀用逗号隔开，不填写则不限制类型', '1540457659', '1552436080', '1', 'doc,docx,xls,xlsx,ppt,pptx,pdf,wps,txt,rar,zip,gz,bz2,7z,mp4,jpg', '4');
INSERT INTO `yzn_config` VALUES ('18', 'upload_driver', 'radio', '上传驱动', 'upload', 'local:本地', '图片或文件上传驱动', '1541752781', '1552436085', '1', 'local', '9');
INSERT INTO `yzn_config` VALUES ('19', 'upload_thumb_water', 'switch', '添加水印', 'upload', '', '', '1552435063', '1552436080', '1', '1', '5');
INSERT INTO `yzn_config` VALUES ('20', 'upload_thumb_water_pic', 'image', '水印图片', 'upload', '', '只有开启水印功能才生效', '1552435183', '1552436081', '1', '26', '6');
INSERT INTO `yzn_config` VALUES ('21', 'upload_thumb_water_position', 'radio', '水印位置', 'upload', '1:左上角\r\n2:上居中\r\n3:右上角\r\n4:左居中\r\n5:居中\r\n6:右居中\r\n7:左下角\r\n8:下居中\r\n9:右下角', '只有开启水印功能才生效', '1552435257', '1552436082', '1', '5', '7');
INSERT INTO `yzn_config` VALUES ('22', 'upload_thumb_water_alpha', 'text', '水印透明度', 'upload', '', '请输入0~100之间的数字，数字越小，透明度越高', '1552435299', '1552436083', '1', '50', '8');
INSERT INTO `yzn_config` VALUES ('27', 'zwxx_type', 'array', '政务信息类别', 'develop', '', '', '1562724888', '1562724888', '1', '1:每日信息\r\n2:综合呈报\r\n3:海关要情\r\n4:每周工作状态\r\n5:月度工作要点\r\n6:工作快报\r\n7:信息公告', '100');
INSERT INTO `yzn_config` VALUES ('26', 'job_type', 'array', '职务', 'develop', '', '', '1560927726', '1562724523', '1', '关长:关长\r\n永康办主任:永康办主任\r\n调研员:调研员\r\n机关党委书记:机关党委书记\r\n副关长:副关长\r\n纪检监察特派员:纪检监察特派员\r\n科长:科长\r\n副科长:副科长\r\n主任科员:主任科员\r\n副主任科员:副主任科员\r\n科员:科员\r\n工人:工人\r\n见习:见习\r\n其他:其他\r\n局长:局长\r\n政委:政委\r\n副局长:副局长\r\n管理员:管理员', '100');
INSERT INTO `yzn_config` VALUES ('28', 'rule_type', 'array', '规章制度类型', 'develop', '', '', '1562725742', '1564799242', '1', '1:本关1\r\n', '100');
INSERT INTO `yzn_config` VALUES ('29', 'supervise_type', 'array', '督办类别', 'develop', '', '', '1562726805', '1591431973', '1', '1:工作督办\r\n2:其他督办', '100');
INSERT INTO `yzn_config` VALUES ('33', 'upload_img_url1', 'array', '远程图片服务器', 'upload', '', '', '1566367095', '1568707566', '1', '1:116.62.62.90/zfcms//index/index/uploadeimg', '100');

-- ----------------------------
-- Table structure for `yzn_fee_rules`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_fee_rules`;
CREATE TABLE `yzn_fee_rules` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '物业ID',
  `park_id` int(11) NOT NULL DEFAULT '0' COMMENT '停车场ID',
  `rule_name` varchar(20) NOT NULL DEFAULT '' COMMENT '规则名称',
  `toll_type` int(1) NOT NULL DEFAULT '0' COMMENT '收费类型',
  `rule_content` varchar(5000) NOT NULL DEFAULT '' COMMENT '规则内容',
  `add_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  `fee_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0：车位组收费规则',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收费规则';

-- ----------------------------
-- Records of yzn_fee_rules
-- ----------------------------

-- ----------------------------
-- Table structure for `yzn_field_type`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_field_type`;
CREATE TABLE `yzn_field_type` (
  `name` varchar(32) NOT NULL COMMENT '字段类型',
  `title` varchar(64) NOT NULL DEFAULT '' COMMENT '中文类型名',
  `listorder` int(4) NOT NULL DEFAULT '0' COMMENT '排序',
  `default_define` varchar(128) NOT NULL DEFAULT '' COMMENT '默认定义',
  `ifoption` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要设置选项',
  `ifstring` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否自由字符',
  `vrule` varchar(256) NOT NULL DEFAULT '' COMMENT '验证规则',
  PRIMARY KEY (`name`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='字段类型表';

-- ----------------------------
-- Records of yzn_field_type
-- ----------------------------
INSERT INTO `yzn_field_type` VALUES ('text', '输入框', '1', 'varchar(255) NOT NULL DEFAULT \'\'', '0', '1', '');
INSERT INTO `yzn_field_type` VALUES ('checkbox', '复选框', '2', 'varchar(32) NOT NULL DEFAULT \'\'', '1', '0', '');
INSERT INTO `yzn_field_type` VALUES ('textarea', '多行文本', '3', 'varchar(255) NOT NULL DEFAULT \'\'', '0', '1', '');
INSERT INTO `yzn_field_type` VALUES ('radio', '单选按钮', '4', 'tinyint(2) UNSIGNED NOT NULL DEFAULT \'0\'', '1', '0', 'isChsAlphaNum');
INSERT INTO `yzn_field_type` VALUES ('switch', '开关', '5', 'tinyint(2) UNSIGNED NOT NULL DEFAULT \'0\'', '0', '0', 'isBool');
INSERT INTO `yzn_field_type` VALUES ('array', '数组', '6', 'varchar(512) NOT NULL DEFAULT \'\'', '0', '0', '');
INSERT INTO `yzn_field_type` VALUES ('select', '下拉框', '7', 'tinyint(2) UNSIGNED NOT NULL DEFAULT \'0\'', '1', '0', 'isChsAlphaNum');
INSERT INTO `yzn_field_type` VALUES ('image', '单张图', '8', 'int(5) UNSIGNED NOT NULL DEFAULT \'0\'', '0', '0', 'isNumber');
INSERT INTO `yzn_field_type` VALUES ('tags', '标签', '10', 'varchar(255) NOT NULL DEFAULT \'\'', '0', '1', '');
INSERT INTO `yzn_field_type` VALUES ('number', '数字', '11', 'int(10) UNSIGNED NOT NULL DEFAULT \'0\'', '0', '0', 'isNumber');
INSERT INTO `yzn_field_type` VALUES ('datetime', '日期和时间', '12', 'int(11) UNSIGNED NOT NULL DEFAULT \'0\'', '0', '0', '');
INSERT INTO `yzn_field_type` VALUES ('Ueditor', '百度编辑器', '13', 'text NOT NULL', '0', '1', '');
INSERT INTO `yzn_field_type` VALUES ('images', '多张图', '9', 'varchar(256) NOT NULL DEFAULT \'\'', '0', '0', '');
INSERT INTO `yzn_field_type` VALUES ('color', '颜色值', '17', 'varchar(7) NOT NULL DEFAULT \'\'', '0', '0', '');
INSERT INTO `yzn_field_type` VALUES ('files', '多文件', '15', 'varchar(255) NOT NULL DEFAULT \'\'', '0', '0', '');
INSERT INTO `yzn_field_type` VALUES ('summernote', '简洁编辑器', '14', 'text NOT NULL', '0', '1', '');
INSERT INTO `yzn_field_type` VALUES ('file', '单文件', '16', 'int(5) UNSIGNED NOT NULL DEFAULT \'0\'', '0', '0', 'isNumber');

-- ----------------------------
-- Table structure for `yzn_hooks`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_hooks`;
CREATE TABLE `yzn_hooks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '钩子名称',
  `description` text NOT NULL COMMENT '描述',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '类型',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `addons` varchar(255) NOT NULL DEFAULT '' COMMENT '钩子挂载的插件 ''，''分割',
  `modules` varchar(255) NOT NULL DEFAULT '' COMMENT '钩子挂载的模块 ''，''分割',
  `system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否系统',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='插件和模块钩子';

-- ----------------------------
-- Records of yzn_hooks
-- ----------------------------
INSERT INTO `yzn_hooks` VALUES ('1', 'pageHeader', '页面header钩子，一般用于加载插件CSS文件和代码', '1', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('2', 'pageFooter', '页面footer钩子，一般用于加载插件JS文件和JS代码', '1', '1509174020', 'returntop', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('3', 'smsGet', '短信获取行为', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('4', 'smsSend', '短信发送行为', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('5', 'smsNotice', '短信发送通知', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('6', 'smsCheck', '检测短信验证是否正确', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('7', 'smsFlush', '清空短信验证行为', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('8', 'emsGet', '邮件获取行为', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('9', 'emsSend', '邮件发送行为', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('10', 'emsNotice', '邮件发送通知', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('11', 'emsCheck', '检测邮件验证是否正确', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('12', 'emsFlush', '清空邮件验证行为', '2', '1509174020', '', '', '1', '1');
INSERT INTO `yzn_hooks` VALUES ('13', 'BadwordReplace', '内容数据提交结束标签位', '1', '1557798093', '', 'badword', '0', '1');

-- ----------------------------
-- Table structure for `yzn_menu`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_menu`;
CREATE TABLE `yzn_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `icon` varchar(64) NOT NULL DEFAULT '' COMMENT '图标',
  `parentid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `app` char(20) NOT NULL DEFAULT '' COMMENT '应用标识',
  `controller` char(20) NOT NULL DEFAULT '' COMMENT '控制器标识',
  `action` char(20) NOT NULL DEFAULT '' COMMENT '方法标识',
  `parameter` char(255) NOT NULL DEFAULT '' COMMENT '附加参数',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `tip` varchar(255) NOT NULL DEFAULT '' COMMENT '提示',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否开发者可见',
  `listorder` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '排序ID',
  PRIMARY KEY (`id`),
  KEY `pid` (`parentid`)
) ENGINE=MyISAM AUTO_INCREMENT=362 DEFAULT CHARSET=utf8 COMMENT='后台菜单表';

-- ----------------------------
-- Records of yzn_menu
-- ----------------------------
INSERT INTO `yzn_menu` VALUES ('1', '首页', '', '0', 'admin', 'index', 'index', '', '0', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('2', '控制面板', '', '0', 'admin', 'main', 'index', '', '0', '', '0', '1');
INSERT INTO `yzn_menu` VALUES ('10', '系统配置', '', '56', 'admin', 'config', 'index1', '', '1', '', '0', '100');
INSERT INTO `yzn_menu` VALUES ('14', '菜单管理', '', '10', 'admin', 'menu', 'index', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('15', '权限管理', '', '56', 'admin', 'manager', 'index1', '', '1', '', '0', '99');
INSERT INTO `yzn_menu` VALUES ('17', '角色管理', '', '15', 'admin', 'authManager', 'index', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('22', '添加角色', '', '17', 'admin', 'authManager', 'createGroup', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('27', '新增菜单', '', '14', 'admin', 'menu', 'add', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('28', '编辑菜单', '', '14', 'admin', 'menu', 'edit', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('29', '删除菜单', '', '14', 'admin', 'menu', 'delete', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('48', '编辑角色', '', '17', 'admin', 'authManager', 'editGroup', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('49', '删除角色', '', '17', 'admin', 'authManager', 'deleteGroup', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('50', '访问授权', '', '17', 'admin', 'authManager', 'access', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('51', '角色授权', '', '17', 'admin', 'authManager', 'writeGroup', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('56', '系统管理', 'icon-setup', '0', 'cms', 'cms', 'index', '', '1', '', '0', '3');
INSERT INTO `yzn_menu` VALUES ('190', '资料修改', '', '0', 'admin', 'manager', 'useredit', '', '0', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('353', '配置管理', '', '10', 'admin', 'config', 'index', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('354', '网站设置', '', '10', 'admin', 'config', 'setting', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('355', '新增配置', '', '353', 'admin', 'config', 'add', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('356', '编辑配置', '', '353', 'admin', 'config', 'edit', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('357', '删除配置', '', '353', 'admin', 'config', 'del', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('358', '管理员管理', '', '15', 'admin', 'manager', 'index', '', '1', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('359', '添加管理员', '', '358', 'admin', 'manager', 'add', '', '0', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('360', '编辑管理员', '', '358', 'admin', 'manager', 'edit', '', '0', '', '0', '0');
INSERT INTO `yzn_menu` VALUES ('361', '删除管理员', '', '358', 'admin', 'manager', 'del', '', '0', '', '0', '0');

-- ----------------------------
-- Table structure for `yzn_merchants`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_merchants`;
CREATE TABLE `yzn_merchants` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '角色类型（1:经销商|2:物业）',
  `pid` int(10) NOT NULL DEFAULT '0' COMMENT '上级父元素',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名称',
  `contact` varchar(15) NOT NULL DEFAULT '' COMMENT '联系人',
  `admin_id` int(10) NOT NULL DEFAULT '0' COMMENT '管理员ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='经销商物业信息';

-- ----------------------------
-- Records of yzn_merchants
-- ----------------------------
INSERT INTO `yzn_merchants` VALUES ('1', '1', '0', '经销商', '', '2');
INSERT INTO `yzn_merchants` VALUES ('2', '2', '1', '物业', '', '3');

-- ----------------------------
-- Table structure for `yzn_module`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_module`;
CREATE TABLE `yzn_module` (
  `module` varchar(15) NOT NULL COMMENT '模块',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '模块名称',
  `sign` varchar(255) NOT NULL DEFAULT '' COMMENT '签名',
  `iscore` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '内置模块',
  `version` varchar(50) NOT NULL DEFAULT '' COMMENT '版本',
  `setting` mediumtext COMMENT '设置信息',
  `installtime` int(10) NOT NULL DEFAULT '0' COMMENT '安装时间',
  `updatetime` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `listorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否可用',
  PRIMARY KEY (`module`),
  KEY `sign` (`sign`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='已安装模块列表';

-- ----------------------------
-- Records of yzn_module
-- ----------------------------
INSERT INTO `yzn_module` VALUES ('cms', 'cms模块', 'b19cc279ed484c13c96c2f7142e2f437', '0', '1.0.0', 'a:3:{s:15:\"web_site_status\";i:1;s:12:\"site_keyword\";s:54:\"金华海关,管理系统,内容管理系统,CMS系统\";s:16:\"site_description\";s:24:\"金华海关管理系统\";}', '1557797773', '1557797773', '0', '1');
INSERT INTO `yzn_module` VALUES ('member', '会员模块', 'fcfe4d97f35d1f30df5d6018a84f74ba', '0', '1.0.0', 'a:5:{s:13:\"allowregister\";s:1:\"1\";s:14:\"registerverify\";s:1:\"0\";s:16:\"openverification\";s:1:\"1\";s:12:\"defualtpoint\";s:1:\"0\";s:13:\"defualtamount\";s:1:\"0\";}', '1557797896', '1557797896', '0', '1');
INSERT INTO `yzn_module` VALUES ('badword', '敏感词过滤模块', 'af8bd198b25e2845c94cebe7cd7e80e0', '0', '1.0.0', null, '1557798093', '1557798093', '0', '1');
INSERT INTO `yzn_module` VALUES ('links', '友情链接', '960c30f9b119fa6c39a4a31867441c82', '0', '1.0.0', null, '1557798101', '1557798101', '0', '1');
INSERT INTO `yzn_module` VALUES ('sitemap', 'sitemap网站地图', '2cd67448032301277ba60dda2c5f2740', '0', '1.0.0', null, '1557798108', '1557798108', '0', '1');

-- ----------------------------
-- Table structure for `yzn_order`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_order`;
CREATE TABLE `yzn_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plate_number` varchar(30) NOT NULL DEFAULT '' COMMENT '车牌号',
  `plate_color` tinyint(4) NOT NULL DEFAULT '0' COMMENT '车牌颜色（1：蓝牌|2：黄牌|3：黑牌|4：白牌|5：绿牌）',
  `car_type` varchar(30) NOT NULL DEFAULT '' COMMENT '车辆类型（temp:临时车|fix:月租车）',
  `area_id` int(11) NOT NULL DEFAULT '0' COMMENT '区域ID(无效)',
  `area_name` varchar(50) NOT NULL DEFAULT '' COMMENT '区域（无效）',
  `in_time` int(11) NOT NULL DEFAULT '0' COMMENT '入场时间',
  `in_channel_id` int(11) NOT NULL DEFAULT '0' COMMENT '入场车道号',
  `in_channel_name` varchar(30) NOT NULL DEFAULT '' COMMENT '入场道',
  `in_car_img` varchar(255) NOT NULL DEFAULT '' COMMENT '入场图片',
  `out_time` int(11) NOT NULL DEFAULT '0' COMMENT '出场时间',
  `out_channel_id` int(11) NOT NULL DEFAULT '0' COMMENT '出场车道号',
  `out_channel_name` varchar(30) NOT NULL DEFAULT '' COMMENT '出场道',
  `out_car_img` varchar(255) NOT NULL DEFAULT '' COMMENT '出场图片',
  `fee_should_pay` int(11) NOT NULL DEFAULT '0' COMMENT '应付金额',
  `fee_actual_ay` int(11) NOT NULL DEFAULT '0' COMMENT '总实收金额',
  `fee_by_coupon_off` int(11) NOT NULL DEFAULT '0' COMMENT '优惠金额',
  `fee_pre_pay` int(11) NOT NULL DEFAULT '0' COMMENT '已预缴金额',
  `coupon_type_name` varchar(30) NOT NULL DEFAULT '' COMMENT '优惠类型',
  `reason` varchar(30) NOT NULL DEFAULT '' COMMENT '原因',
  `order_status` varchar(30) NOT NULL DEFAULT '' COMMENT '订单状态（payed:支付完成|ing:进行中|finish:已经完成|feeing:待支付）',
  `finish_status` varchar(30) NOT NULL DEFAULT '' COMMENT '放行类型（endByHuman:强制结单|endByHand:手工结单开闸|inParkingAgain:再入场时结单|cashPay:现金支付|monthlyRentalTimeOut:月租自动重入场|zeroPay:需支付金额=0|normal:正常支付结单|exception:异常情况）',
  `last_operate_plate_acc_id` int(11) NOT NULL DEFAULT '0' COMMENT '最后经手人ID',
  `last_operate_plate_acc_name` varchar(30) NOT NULL DEFAULT '' COMMENT '最后经手人',
  `park_id` int(11) NOT NULL DEFAULT '0' COMMENT '停车场ID',
  PRIMARY KEY (`id`),
  KEY `order_status` (`order_status`) USING BTREE,
  KEY `plate_number` (`plate_number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='停车订单';

-- ----------------------------
-- Records of yzn_order
-- ----------------------------

-- ----------------------------
-- Table structure for `yzn_other_log`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_other_log`;
CREATE TABLE `yzn_other_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `aid` int(11) NOT NULL DEFAULT '0' COMMENT '操作者ID',
  `park_id` int(11) NOT NULL DEFAULT '0' COMMENT '停车场ID',
  `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '物业ID',
  `act_type` varchar(255) NOT NULL DEFAULT '' COMMENT '操作类型(Ctrl_Gate：道闸控制|Ctrl_Through：放行|Ctrl_Order：结单|Ctrl_PlateNumber：车牌)',
  `cname` varchar(255) NOT NULL DEFAULT '' COMMENT '操作',
  `msg` varchar(5000) NOT NULL DEFAULT '' COMMENT '操作信息',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `ip` varchar(25) NOT NULL DEFAULT '' COMMENT 'IP地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='放行日志';

-- ----------------------------
-- Records of yzn_other_log
-- ----------------------------

-- ----------------------------
-- Table structure for `yzn_park`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_park`;
CREATE TABLE `yzn_park` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `mch_id` int(10) NOT NULL DEFAULT '0' COMMENT '物业ID',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名称',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT '地址',
  `admin_id` int(10) NOT NULL DEFAULT '0' COMMENT '管理员ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='停车场';

-- ----------------------------
-- Records of yzn_park
-- ----------------------------

-- ----------------------------
-- Table structure for `yzn_payment_code`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_payment_code`;
CREATE TABLE `yzn_payment_code` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(20) NOT NULL DEFAULT '' COMMENT '支付方式代码',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '支付方式名称',
  `picurl` varchar(100) NOT NULL DEFAULT '' COMMENT '支付方式图标URL',
  `listorder` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '排序号码',
  `isview` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用，1是',
  `config` mediumtext NOT NULL COMMENT '账号信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='支付方式配置';

-- ----------------------------
-- Records of yzn_payment_code
-- ----------------------------
INSERT INTO `yzn_payment_code` VALUES ('1', 'cash', '余额', '', '0', '1', '');
INSERT INTO `yzn_payment_code` VALUES ('2', 'alipay', '支付宝', '', '0', '1', '');
INSERT INTO `yzn_payment_code` VALUES ('3', 'weixin', '微信', '', '0', '1', '');

-- ----------------------------
-- Table structure for `yzn_payment_notice`
-- ----------------------------
DROP TABLE IF EXISTS `yzn_payment_notice`;
CREATE TABLE `yzn_payment_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `park_id` int(11) NOT NULL DEFAULT '0' COMMENT '停车场ID',
  `notice_sn` varchar(30) NOT NULL DEFAULT '' COMMENT '支付单号',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '下单时间',
  `pay_time` int(11) NOT NULL DEFAULT '0' COMMENT '付款时间',
  `order_id` int(11) NOT NULL DEFAULT '0' COMMENT '关联的订单号ID',
  `is_paid` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已支付（0：未支付 1：已支付）',
  `merchants_id` int(11) NOT NULL DEFAULT '0' COMMENT '商家ID',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `payment_code` varchar(20) NOT NULL DEFAULT '' COMMENT '支付接口code',
  `remarks` varchar(50) NOT NULL DEFAULT '' COMMENT '付款单备注',
  `money` int(11) NOT NULL DEFAULT '0' COMMENT '应付金额',
  `coupon_id` int(11) NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  `coupon_price` int(11) NOT NULL DEFAULT '0' COMMENT '优惠券金额',
  `outer_notice_sn` varchar(255) NOT NULL DEFAULT '' COMMENT '支付平台的对帐号',
  `outer_buy_id` varchar(255) NOT NULL DEFAULT '' COMMENT '支付平台的账号',
  PRIMARY KEY (`id`),
  UNIQUE KEY `notice_sn` (`notice_sn`),
  KEY `is_paid` (`is_paid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='支付单表';

-- ----------------------------
-- Records of yzn_payment_notice
-- ----------------------------