dm-v2.com/Mysql/2017-9-9.sql

/*
Navicat MySQL Data Transfer

Source Server         : 二维码项目
Source Server Version : 50540
Source Host           : 192.168.1.56:3306
Source Database       : smoke

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

Date: 2017-09-09 17:55:16
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for qr_add_code_log
-- ----------------------------
DROP TABLE IF EXISTS `qr_add_code_log`;
CREATE TABLE `qr_add_code_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Bach_id` int(11) NOT NULL COMMENT '批次id',
  `Printer_id` int(11) NOT NULL COMMENT '上传者',
  `success_num` int(11) NOT NULL COMMENT '成功的数量',
  `failures_num` int(11) NOT NULL COMMENT '失败的数量',
  `quality` int(11) NOT NULL COMMENT '上传数量',
  `Add_time` int(11) NOT NULL COMMENT '添加时间戳',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qr_add_code_log
-- ----------------------------

-- ----------------------------
-- Table structure for qr_admin_access
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_access`;
CREATE TABLE `qr_admin_access` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `group` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '管理员用户组',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='后台管理员与用户组对应关系表';

-- ----------------------------
-- Records of qr_admin_access
-- ----------------------------
INSERT INTO `qr_admin_access` VALUES ('1', '1', '1', '1438651748', '1438651748', '0', '1');
INSERT INTO `qr_admin_access` VALUES ('3', '2', '2', '1504766867', '1504766867', '0', '1');
INSERT INTO `qr_admin_access` VALUES ('4', '3', '3', '1504766903', '1504766903', '0', '1');

-- ----------------------------
-- Table structure for qr_admin_addon
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_addon`;
CREATE TABLE `qr_admin_addon` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(32) DEFAULT NULL COMMENT '插件名或标识',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '中文名',
  `description` text NOT NULL COMMENT '插件描述',
  `config` text COMMENT '配置',
  `author` varchar(32) NOT NULL DEFAULT '' COMMENT '作者',
  `version` varchar(8) NOT NULL DEFAULT '' COMMENT '版本号',
  `adminlist` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否有后台列表',
  `type` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '插件类型',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '安装时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `sort` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='插件表';

-- ----------------------------
-- Records of qr_admin_addon
-- ----------------------------
INSERT INTO `qr_admin_addon` VALUES ('1', 'RocketToTop', '小火箭返回顶部', '小火箭返回顶部', '{\"status\":\"1\"}', 'OpenCMF', '1.3.0', '0', '0', '1476718525', '1476718525', '0', '0');
INSERT INTO `qr_admin_addon` VALUES ('2', 'ModelConfigEditor', '模型配置器', '用于编辑已有模块的配置', 'null', 'yangweijie', '0.3', '0', '0', '1504590409', '1504590409', '0', '1');

-- ----------------------------
-- Table structure for qr_admin_config
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_config`;
CREATE TABLE `qr_admin_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '配置标题',
  `name` varchar(32) DEFAULT NULL COMMENT '配置名称',
  `value` text NOT NULL COMMENT '配置值',
  `group` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '配置分组',
  `type` varchar(16) NOT NULL DEFAULT '' COMMENT '配置类型',
  `options` varchar(255) NOT NULL DEFAULT '' COMMENT '配置额外值',
  `tip` varchar(100) NOT NULL DEFAULT '' COMMENT '配置说明',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='系统配置表';

-- ----------------------------
-- Records of qr_admin_config
-- ----------------------------
INSERT INTO `qr_admin_config` VALUES ('1', '站点开关', 'TOGGLE_WEB_SITE', '0', '1', 'select', '0:关闭\r\n1:开启', '站点关闭后将不能访问', '1378898976', '1406992386', '1', '1');
INSERT INTO `qr_admin_config` VALUES ('2', '网站标题', 'WEB_SITE_TITLE', '7in6 二维码系统', '1', 'text', '', '网站标题前台显示标题', '1378898976', '1379235274', '2', '1');
INSERT INTO `qr_admin_config` VALUES ('3', '网站口号', 'WEB_SITE_SLOGAN', '7in6 二维码系统', '1', 'text', '', '网站口号、宣传标语、一句话介绍', '1434081649', '1434081649', '3', '1');
INSERT INTO `qr_admin_config` VALUES ('4', '网站LOGO', 'WEB_SITE_LOGO', '', '1', 'picture', '', '网站LOGO', '1407003397', '1407004692', '4', '1');
INSERT INTO `qr_admin_config` VALUES ('5', '网站反色LOGO', 'WEB_SITE_LOGO_INVERSE', '', '1', 'picture', '', '匹配深色背景上的LOGO', '1476700797', '1476700797', '5', '1');
INSERT INTO `qr_admin_config` VALUES ('6', '网站描述', 'WEB_SITE_DESCRIPTION', '7in6 二维码系统', '1', 'textarea', '', '网站搜索引擎描述', '1378898976', '1379235841', '6', '1');
INSERT INTO `qr_admin_config` VALUES ('7', '网站关键字', 'WEB_SITE_KEYWORD', '7in6 二维码系统', '1', 'textarea', '', '网站搜索引擎关键字', '1378898976', '1381390100', '7', '1');
INSERT INTO `qr_admin_config` VALUES ('8', '版权信息', 'WEB_SITE_COPYRIGHT', '7in6 二维码系统', '1', 'text', '', '设置在网站底部显示的版权信息，如“版权所有 © 2014-2015 科斯克网络科技”', '1406991855', '1406992583', '8', '1');
INSERT INTO `qr_admin_config` VALUES ('9', '网站备案号', 'WEB_SITE_ICP', '', '1', 'text', '', '设置在网站底部显示的备案号，如“苏ICP备1502009号\"', '1378900335', '1415983236', '9', '1');
INSERT INTO `qr_admin_config` VALUES ('10', '站点统计', 'WEB_SITE_STATISTICS', '', '1', 'textarea', '', '支持百度、Google、cnzz等所有Javascript的统计代码', '1378900335', '1415983236', '10', '1');
INSERT INTO `qr_admin_config` VALUES ('11', '文件上传大小', 'UPLOAD_FILE_SIZE', '10', '2', 'num', '', '文件上传大小单位：MB', '1428681031', '1428681031', '1', '1');
INSERT INTO `qr_admin_config` VALUES ('12', '图片上传大小', 'UPLOAD_IMAGE_SIZE', '100', '2', 'num', '', '图片上传大小单位：MB', '1428681071', '1504838281', '2', '1');
INSERT INTO `qr_admin_config` VALUES ('13', '后台多标签', 'ADMIN_TABS', '0', '2', 'radio', '0:关闭\r\n1:开启', '', '1453445526', '1453445526', '3', '1');
INSERT INTO `qr_admin_config` VALUES ('14', '分页数量', 'ADMIN_PAGE_ROWS', '10', '2', 'num', '', '分页时每页的记录数', '1434019462', '1434019481', '4', '1');
INSERT INTO `qr_admin_config` VALUES ('15', '后台主题', 'ADMIN_THEME', 'admin', '2', 'select', 'admin:默认主题\r\naliyun:阿里云风格', '后台界面主题', '1436678171', '1436690570', '5', '1');
INSERT INTO `qr_admin_config` VALUES ('16', '导航分组', 'NAV_GROUP_LIST', 'top:顶部导航\r\nmain:主导航\r\nbottom:底部导航', '2', 'array', '', '导航分组', '1458382037', '1458382061', '6', '1');
INSERT INTO `qr_admin_config` VALUES ('17', '配置分组', 'CONFIG_GROUP_LIST', '1:基本\r\n2:系统\r\n3:开发\r\n4:部署\r\n5:二维码校验\r\n6:二维码上传', '2', 'array', '', '配置分组', '1379228036', '1504837473', '7', '1');
INSERT INTO `qr_admin_config` VALUES ('18', '开发模式', 'DEVELOP_MODE', '1', '3', 'select', '1:开启\r\n0:关闭', '开发模式下会显示菜单管理、配置管理、数据字典等开发者工具', '1432393583', '1432393583', '1', '1');
INSERT INTO `qr_admin_config` VALUES ('19', '是否显示页面Trace', 'SHOW_PAGE_TRACE', '1', '3', 'select', '0:关闭\r\n1:开启', '是否显示页面Trace信息', '1387165685', '1387165685', '2', '1');
INSERT INTO `qr_admin_config` VALUES ('21', 'URL模式', 'URL_MODEL', '3', '4', 'select', '1:PATHINFO模式\r\n2:REWRITE模式\r\n3:兼容模式', '', '1438423248', '1438423248', '1', '1');
INSERT INTO `qr_admin_config` VALUES ('22', '默认模块', 'DEFAULT_MODULE', '', '4', 'select', 'callback:D(\'Admin/Module\')->getNameList', '', '1471458914', '1471458914', '4', '1');
INSERT INTO `qr_admin_config` VALUES ('23', '默认模块布局', 'DEFAULT_MODULE_LAYOUT', '0', '4', 'radio', '1:开启\r\n0:关闭', '启用默认模块的布局layout全局生效', '1481267362', '1481267389', '4', '1');
INSERT INTO `qr_admin_config` VALUES ('26', '扫码类型', 'TYPE', '0', '5', 'radio', '0:二维码\r\n1:二维码+数字验证码', '', '1504940936', '1504941087', '0', '1');
INSERT INTO `qr_admin_config` VALUES ('27', '上传文件', 'QR_UPLOAD_VERIFY', '', '5', 'file', '', '', '1504941027', '1504948459', '0', '1');
INSERT INTO `qr_admin_config` VALUES ('28', '上传码包', 'QR_UPLOAD', '', '6', 'file', '', '', '1504948387', '1504948387', '0', '1');

-- ----------------------------
-- Table structure for qr_admin_group
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_group`;
CREATE TABLE `qr_admin_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '部门ID',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级部门ID',
  `title` varchar(31) NOT NULL DEFAULT '' COMMENT '部门名称',
  `icon` varchar(31) NOT NULL DEFAULT '' COMMENT '图标',
  `menu_auth` text NOT NULL COMMENT '权限列表',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='部门信息表';

-- ----------------------------
-- Records of qr_admin_group
-- ----------------------------
INSERT INTO `qr_admin_group` VALUES ('1', '0', '超级管理员', '', '', '1426881003', '1427552428', '0', '1');
INSERT INTO `qr_admin_group` VALUES ('2', '1', '印刷厂', 'fa-th-large', '{\"Admin\":[\"58\",\"59\",\"61\",\"62\"]}', '1504752936', '1504773116', '0', '1');
INSERT INTO `qr_admin_group` VALUES ('3', '1', '中烟', 'fa-arrow-circle-o-up', '{\"Admin\":[\"58\",\"60\",\"61\",\"62\"]}', '1504752959', '1504766829', '0', '1');

-- ----------------------------
-- Table structure for qr_admin_hook
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_hook`;
CREATE TABLE `qr_admin_hook` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '钩子ID',
  `name` varchar(32) DEFAULT NULL COMMENT '钩子名称',
  `description` text NOT NULL COMMENT '描述',
  `addons` varchar(255) NOT NULL DEFAULT '' COMMENT '钩子挂载的插件',
  `type` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '类型',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='钩子表';

-- ----------------------------
-- Records of qr_admin_hook
-- ----------------------------
INSERT INTO `qr_admin_hook` VALUES ('1', 'AdminIndex', '后台首页小工具', '后台首页小工具,ModelConfigEditor', '1', '1446522155', '1446522155', '1');
INSERT INTO `qr_admin_hook` VALUES ('2', 'FormBuilderExtend', 'FormBuilder类型扩展Builder', '', '1', '1447831268', '1447831268', '1');
INSERT INTO `qr_admin_hook` VALUES ('3', 'UploadFile', '上传文件钩子', '', '1', '1407681961', '1407681961', '1');
INSERT INTO `qr_admin_hook` VALUES ('4', 'PageHeader', '页面header钩子，一般用于加载插件CSS文件和代码', '', '1', '1407681961', '1407681961', '1');
INSERT INTO `qr_admin_hook` VALUES ('5', 'PageFooter', '页面footer钩子，一般用于加载插件CSS文件和代码', 'RocketToTop', '1', '1407681961', '1407681961', '1');
INSERT INTO `qr_admin_hook` VALUES ('6', 'CommonHook', '通用钩子，自定义用途，一般用来定制特殊功能', '', '1', '1456147822', '1456147822', '1');

-- ----------------------------
-- Table structure for qr_admin_module
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_module`;
CREATE TABLE `qr_admin_module` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(31) DEFAULT NULL COMMENT '名称',
  `title` varchar(63) NOT NULL DEFAULT '' COMMENT '标题',
  `logo` varchar(63) NOT NULL DEFAULT '' COMMENT '图片图标',
  `icon` varchar(31) NOT NULL DEFAULT '' COMMENT '字体图标',
  `icon_color` varchar(7) NOT NULL DEFAULT '' COMMENT '字体图标颜色',
  `description` varchar(127) NOT NULL DEFAULT '' COMMENT '描述',
  `developer` varchar(31) NOT NULL DEFAULT '' COMMENT '开发者',
  `version` varchar(7) NOT NULL DEFAULT '' COMMENT '版本',
  `user_nav` text NOT NULL COMMENT '个人中心导航',
  `config` text NOT NULL COMMENT '配置',
  `admin_menu` text NOT NULL COMMENT '菜单节点',
  `is_system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许卸载',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='模块功能表';

-- ----------------------------
-- Records of qr_admin_module
-- ----------------------------
INSERT INTO `qr_admin_module` VALUES ('1', 'Admin', '系统', '', 'fa fa-cog', '#3CA6F1', '核心系统', 'xtj', '1.1.0', '', '', '{\"1\":{\"pid\":\"0\",\"title\":\"\\u7cfb\\u7edf\",\"icon\":\"fa fa-cog\",\"level\":\"system\",\"id\":\"1\"},\"2\":{\"pid\":\"1\",\"title\":\"\\u7cfb\\u7edf\\u529f\\u80fd\",\"icon\":\"fa fa-folder-open-o\",\"id\":\"2\"},\"3\":{\"pid\":\"2\",\"title\":\"\\u7cfb\\u7edf\\u8bbe\\u7f6e\",\"icon\":\"fa fa-wrench\",\"url\":\"Admin\\/Config\\/group\",\"id\":\"3\"},\"4\":{\"pid\":\"3\",\"title\":\"\\u4fee\\u6539\\u8bbe\\u7f6e\",\"url\":\"Admin\\/Config\\/groupSave\",\"id\":\"4\"},\"6\":{\"pid\":\"5\",\"title\":\"\\u65b0\\u589e\",\"url\":\"Admin\\/Nav\\/add\",\"id\":\"6\"},\"7\":{\"pid\":\"5\",\"title\":\"\\u7f16\\u8f91\",\"url\":\"Admin\\/Nav\\/edit\",\"id\":\"7\"},\"8\":{\"pid\":\"5\",\"title\":\"\\u8bbe\\u7f6e\\u72b6\\u6001\",\"url\":\"Admin\\/Nav\\/setStatus\",\"id\":\"8\"},\"13\":{\"pid\":\"2\",\"title\":\"\\u914d\\u7f6e\\u7ba1\\u7406\",\"icon\":\"fa fa-cogs\",\"url\":\"Admin\\/Config\\/index\",\"id\":\"13\"},\"14\":{\"pid\":\"13\",\"title\":\"\\u65b0\\u589e\",\"url\":\"Admin\\/Config\\/add\",\"id\":\"14\"},\"15\":{\"pid\":\"13\",\"title\":\"\\u7f16\\u8f91\",\"url\":\"Admin\\/Config\\/edit\",\"id\":\"15\"},\"16\":{\"pid\":\"13\",\"title\":\"\\u8bbe\\u7f6e\\u72b6\\u6001\",\"url\":\"Admin\\/Config\\/setStatus\",\"id\":\"16\"},\"17\":{\"id\":\"17\",\"pid\":\"2\",\"title\":\"\\u4e0a\\u4f20\\u65e5\\u5fd7\",\"url\":\"Admin\\/Upload\\/index\",\"icon\":\"fa fa-upload\"},\"18\":{\"pid\":\"17\",\"title\":\"\\u4e0a\\u4f20\\u6587\\u4ef6\",\"url\":\"Admin\\/Upload\\/upload\",\"id\":\"18\"},\"19\":{\"pid\":\"17\",\"title\":\"\\u5220\\u9664\\u6587\\u4ef6\",\"url\":\"Admin\\/Upload\\/delete\",\"id\":\"19\"},\"20\":{\"pid\":\"17\",\"title\":\"\\u8bbe\\u7f6e\\u72b6\\u6001\",\"url\":\"Admin\\/Upload\\/setStatus\",\"id\":\"20\"},\"21\":{\"pid\":\"17\",\"title\":\"\\u4e0b\\u8f7d\\u8fdc\\u7a0b\\u56fe\\u7247\",\"url\":\"Admin\\/Upload\\/downremoteimg\",\"id\":\"21\"},\"22\":{\"pid\":\"17\",\"title\":\"\\u6587\\u4ef6\\u6d4f\\u89c8\",\"url\":\"Admin\\/Upload\\/fileManager\",\"id\":\"22\"},\"23\":{\"pid\":\"1\",\"title\":\"\\u7cfb\\u7edf\\u6743\\u9650\",\"icon\":\"fa fa-folder-open-o\",\"id\":\"23\"},\"24\":{\"pid\":\"23\",\"title\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"icon\":\"fa fa-user\",\"url\":\"Admin\\/User\\/index\",\"id\":\"24\"},\"25\":{\"pid\":\"24\",\"title\":\"\\u65b0\\u589e\",\"url\":\"Admin\\/User\\/add\",\"id\":\"25\"},\"26\":{\"pid\":\"24\",\"title\":\"\\u7f16\\u8f91\",\"url\":\"Admin\\/User\\/edit\",\"id\":\"26\"},\"27\":{\"pid\":\"24\",\"title\":\"\\u8bbe\\u7f6e\\u72b6\\u6001\",\"url\":\"Admin\\/User\\/setStatus\",\"id\":\"27\"},\"28\":{\"pid\":\"23\",\"title\":\"\\u7ba1\\u7406\\u5458\\u7ba1\\u7406\",\"icon\":\"fa fa-lock\",\"url\":\"Admin\\/Access\\/index\",\"id\":\"28\"},\"29\":{\"pid\":\"28\",\"title\":\"\\u65b0\\u589e\",\"url\":\"Admin\\/Access\\/add\",\"id\":\"29\"},\"30\":{\"pid\":\"28\",\"title\":\"\\u7f16\\u8f91\",\"url\":\"Admin\\/Access\\/edit\",\"id\":\"30\"},\"31\":{\"pid\":\"28\",\"title\":\"\\u8bbe\\u7f6e\\u72b6\\u6001\",\"url\":\"Admin\\/Access\\/setStatus\",\"id\":\"31\"},\"32\":{\"pid\":\"23\",\"title\":\"\\u7528\\u6237\\u7ec4\\u7ba1\\u7406\",\"icon\":\"fa fa-sitemap\",\"url\":\"Admin\\/Group\\/index\",\"id\":\"32\"},\"33\":{\"pid\":\"32\",\"title\":\"\\u65b0\\u589e\",\"url\":\"Admin\\/Group\\/add\",\"id\":\"33\"},\"34\":{\"pid\":\"32\",\"title\":\"\\u7f16\\u8f91\",\"url\":\"Admin\\/Group\\/edit\",\"id\":\"34\"},\"35\":{\"pid\":\"32\",\"title\":\"\\u8bbe\\u7f6e\\u72b6\\u6001\",\"url\":\"Admin\\/Group\\/setStatus\",\"id\":\"35\"},\"36\":{\"pid\":\"1\",\"title\":\"\\u6269\\u5c55\\u4e2d\\u5fc3\",\"icon\":\"fa fa-folder-open-o\",\"id\":\"36\"},\"44\":{\"pid\":\"36\",\"title\":\"\\u529f\\u80fd\\u6a21\\u5757\",\"icon\":\"fa fa-th-large\",\"url\":\"Admin\\/Module\\/index\",\"id\":\"44\"},\"45\":{\"pid\":\"44\",\"title\":\"\\u5b89\\u88c5\",\"url\":\"Admin\\/Module\\/install\",\"id\":\"45\"},\"46\":{\"pid\":\"44\",\"title\":\"\\u5378\\u8f7d\",\"url\":\"Admin\\/Module\\/uninstall\",\"id\":\"46\"},\"47\":{\"pid\":\"44\",\"title\":\"\\u66f4\\u65b0\\u4fe1\\u606f\",\"url\":\"Admin\\/Module\\/updateInfo\",\"id\":\"47\"},\"48\":{\"pid\":\"44\",\"title\":\"\\u8bbe\\u7f6e\\u72b6\\u6001\",\"url\":\"Admin\\/Module\\/setStatus\",\"id\":\"48\"},\"49\":{\"pid\":\"36\",\"title\":\"\\u63d2\\u4ef6\\u7ba1\\u7406\",\"icon\":\"fa fa-th\",\"url\":\"Admin\\/Addon\\/index\",\"id\":\"49\"},\"50\":{\"pid\":\"49\",\"title\":\"\\u5b89\\u88c5\",\"url\":\"Admin\\/Addon\\/install\",\"id\":\"50\"},\"51\":{\"pid\":\"49\",\"title\":\"\\u5378\\u8f7d\",\"url\":\"Admin\\/Addon\\/uninstall\",\"id\":\"51\"},\"52\":{\"pid\":\"49\",\"title\":\"\\u8fd0\\u884c\",\"url\":\"Admin\\/Addon\\/execute\",\"id\":\"52\"},\"53\":{\"pid\":\"49\",\"title\":\"\\u8bbe\\u7f6e\",\"url\":\"Admin\\/Addon\\/config\",\"id\":\"53\"},\"54\":{\"pid\":\"49\",\"title\":\"\\u540e\\u53f0\\u7ba1\\u7406\",\"url\":\"Admin\\/Addon\\/adminList\",\"id\":\"54\"},\"55\":{\"pid\":\"54\",\"title\":\"\\u65b0\\u589e\\u6570\\u636e\",\"url\":\"Admin\\/Addon\\/adminAdd\",\"id\":\"55\"},\"56\":{\"pid\":\"54\",\"title\":\"\\u7f16\\u8f91\\u6570\\u636e\",\"url\":\"Admin\\/Addon\\/adminEdit\",\"id\":\"56\"},\"57\":{\"pid\":\"54\",\"title\":\"\\u8bbe\\u7f6e\\u72b6\\u6001\",\"url\":\"Admin\\/Addon\\/setStatus\",\"id\":\"57\"},\"58\":{\"id\":\"58\",\"pid\":\"1\",\"title\":\"\\u4e8c\\u7ef4\\u7801\",\"url\":\"\",\"icon\":\"fa fa-folder-open-o\"},\"59\":{\"id\":\"59\",\"pid\":\"58\",\"title\":\"\\u4e8c\\u7ef4\\u7801\\u6821\\u9a8c\",\"url\":\"Admin\\/Qr\\/UploadVerify\",\"icon\":\"fa fa-arrow-circle-o-up\"},\"60\":{\"pid\":\"58\",\"title\":\"\\u7533\\u8bf7\\u6279\\u6b21\",\"url\":\"\",\"icon\":\"fa fa-align-right\",\"id\":\"60\"},\"61\":{\"pid\":\"58\",\"title\":\"\\u4efb\\u52a1\\u6d88\\u606f\",\"url\":\"\",\"icon\":\"fa fa-indent\",\"id\":\"61\"},\"62\":{\"pid\":\"58\",\"title\":\"\\u7cfb\\u7edf\\u6d88\\u606f\",\"url\":\"\",\"icon\":\"fa fa-times-circle-o\",\"id\":\"62\"},\"63\":{\"pid\":\"58\",\"title\":\"\\u4e8c\\u7ef4\\u7801\\u4e0a\\u4f20\",\"url\":\"Admin\\/Qr\\/upload\",\"icon\":\"fa fa-forward\",\"id\":\"63\"}}', '1', '1438651748', '1504948467', '0', '1');

-- ----------------------------
-- Table structure for qr_admin_post
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_post`;
CREATE TABLE `qr_admin_post` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `cid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
  `title` varchar(127) NOT NULL DEFAULT '' COMMENT '标题',
  `cover` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '封面',
  `abstract` varchar(255) DEFAULT '' COMMENT '摘要',
  `content` text COMMENT '内容',
  `view_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阅读',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章列表';

-- ----------------------------
-- Records of qr_admin_post
-- ----------------------------

-- ----------------------------
-- Table structure for qr_admin_upload
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_upload`;
CREATE TABLE `qr_admin_upload` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'UID',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '文件路径',
  `url` varchar(255) DEFAULT NULL COMMENT '文件链接',
  `ext` char(4) NOT NULL DEFAULT '' COMMENT '文件类型',
  `size` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `md5` char(32) DEFAULT NULL COMMENT '文件md5',
  `sha1` char(40) DEFAULT NULL COMMENT '文件sha1编码',
  `location` varchar(15) NOT NULL DEFAULT '' COMMENT '文件存储位置',
  `download` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下载次数',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `type` tinyint(1) NOT NULL COMMENT '1 二维码 2二维码+验证码',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件上传表';

-- ----------------------------
-- Records of qr_admin_upload
-- ----------------------------

-- ----------------------------
-- Table structure for qr_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `qr_admin_user`;
CREATE TABLE `qr_admin_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'UID',
  `user_type` int(11) NOT NULL DEFAULT '1' COMMENT '用户类型',
  `nickname` varchar(63) DEFAULT NULL COMMENT '昵称',
  `username` varchar(31) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(63) NOT NULL DEFAULT '' COMMENT '密码',
  `email` varchar(63) NOT NULL DEFAULT '' COMMENT '邮箱',
  `email_bind` tinyint(1) NOT NULL DEFAULT '0' COMMENT '邮箱验证',
  `mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号',
  `mobile_bind` tinyint(1) NOT NULL DEFAULT '0' COMMENT '邮箱验证',
  `avatar` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '头像',
  `score` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
  `money` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `reg_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
  `reg_type` varchar(15) NOT NULL DEFAULT '' COMMENT '注册方式',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态',
  `printer_code` varchar(32) NOT NULL COMMENT '印刷厂编码',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户账号表';

-- ----------------------------
-- Records of qr_admin_user
-- ----------------------------
INSERT INTO `qr_admin_user` VALUES ('1', '1', '超级管理员', 'admin', '5b89b803c0190044c136ee9f9ebee014', '', '0', '', '0', '0', '0', '0.00', '0', 'admin', '1438651748', '1438651748', '1', '');
INSERT INTO `qr_admin_user` VALUES ('2', '1', 'hgz', 'hgz', 'ee4ce4ba3d1ff65af3c47dfd3ca14b14', '8585@qq.com', '0', '15669966909', '0', '1', '0', '0.00', '2130706433', '', '1504766374', '1504778528', '1', '');
INSERT INTO `qr_admin_user` VALUES ('3', '1', 'gentle', 'gentle', 'e6e7693db07443e3dddba3bab4606c86', 'gentle@qq.com', '0', '13022222222', '0', '0', '0', '0.00', '2130706433', 'admin', '1504766662', '1504835829', '1', '');

-- ----------------------------
-- Table structure for qr_bach
-- ----------------------------
DROP TABLE IF EXISTS `qr_bach`;
CREATE TABLE `qr_bach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '批次名称',
  `add_time` int(11) NOT NULL COMMENT '添加时间戳',
  `update_time` int(11) NOT NULL COMMENT '更新时间戳',
  `audit_time` int(11) NOT NULL COMMENT '审核时间戳',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qr_bach
-- ----------------------------

-- ----------------------------
-- Table structure for qr_bach_product
-- ----------------------------
DROP TABLE IF EXISTS `qr_bach_product`;
CREATE TABLE `qr_bach_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Product_id` int(11) NOT NULL COMMENT '产品id',
  `num` int(11) NOT NULL COMMENT '需求数量',
  `Is_verif` bit(1) NOT NULL COMMENT '是否验证',
  `add_time` int(11) NOT NULL COMMENT '添加时间戳',
  `update_time` int(11) NOT NULL COMMENT '更新时间戳',
  `remark` text NOT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qr_bach_product
-- ----------------------------

-- ----------------------------
-- Table structure for qr_box_type
-- ----------------------------
DROP TABLE IF EXISTS `qr_box_type`;
CREATE TABLE `qr_box_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '盒型',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qr_box_type
-- ----------------------------

-- ----------------------------
-- Table structure for qr_codes
-- ----------------------------
DROP TABLE IF EXISTS `qr_codes`;
CREATE TABLE `qr_codes` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `code` int(11) NOT NULL COMMENT '码',
  `verification` varchar(20) NOT NULL COMMENT '验证码',
  `bach_id` int(11) NOT NULL COMMENT '任务id',
  `product_id` int(11) NOT NULL COMMENT '产品id',
  `printer_id` int(11) NOT NULL COMMENT '用户id(印刷厂)',
  `add_time` int(11) NOT NULL COMMENT '添加时间戳',
  `update_time` int(11) NOT NULL COMMENT '更新时间戳',
  `active_time` int(11) NOT NULL COMMENT '激活时间戳',
  `delete_time` int(11) NOT NULL COMMENT '删除时间（不物理删除）',
  `Status` bit(1) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qr_codes
-- ----------------------------

-- ----------------------------
-- Table structure for qr_factory
-- ----------------------------
DROP TABLE IF EXISTS `qr_factory`;
CREATE TABLE `qr_factory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '中烟名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qr_factory
-- ----------------------------

-- ----------------------------
-- Table structure for qr_product
-- ----------------------------
DROP TABLE IF EXISTS `qr_product`;
CREATE TABLE `qr_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '产品名称',
  `image` varchar(255) NOT NULL COMMENT '产品主图',
  `box_type_id` int(11) NOT NULL COMMENT '盒型id',
  `factory_id` int(11) NOT NULL COMMENT '中烟工厂id',
  `add_time` int(11) NOT NULL COMMENT '添加时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  `status` bit(1) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qr_product
-- ----------------------------
INSERT INTO `qr_product` VALUES ('1', '红旗渠', '', '1', '1', '0', '0', '\0');

-- ----------------------------
-- Table structure for qr_task
-- ----------------------------
DROP TABLE IF EXISTS `qr_task`;
CREATE TABLE `qr_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '订单编号',
  `factory_id` int(11) NOT NULL COMMENT '中烟工厂id ',
  `bach_id` int(11) NOT NULL COMMENT '批次号',
  `product_id` int(11) NOT NULL COMMENT '产品id',
  `quality` float NOT NULL COMMENT '数量(万张)',
  `redundancy` float NOT NULL COMMENT '冗码量',
  `checked_num` float NOT NULL COMMENT '已校验数量',
  `wrong_num` float NOT NULL COMMENT '错码数',
  `Is_verif` bit(1) NOT NULL COMMENT '是否需要验证码',
  `printer_id` int(11) NOT NULL COMMENT '印刷厂id',
  `auditor_id` int(11) NOT NULL COMMENT '审核者id',
  `add_time` int(11) NOT NULL COMMENT '添加时间戳',
  `update_time` int(11) NOT NULL COMMENT '更新时间戳',
  `audit_time` int(11) NOT NULL COMMENT '审核时间戳',
  `status` bit(1) NOT NULL COMMENT '状态（0：印刷厂校验中 ，1：已通知 ）',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qr_task
-- ----------------------------