dm-v2.com/Mysql/dm_7in6_com.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50617
Source Host           : localhost:3306
Source Database       : dm_7in6_com

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

Date: 2018-07-28 16:30:42
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `qcode_company`
-- ----------------------------
DROP TABLE IF EXISTS `qcode_company`;
CREATE TABLE `qcode_company` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(20) DEFAULT NULL COMMENT '生产厂商名称',
  `postcode` tinyint(6) DEFAULT NULL COMMENT '邮政编码',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `company_addres` varchar(40) DEFAULT NULL COMMENT '生产厂商地址',
  `stauts` tinyint(1) DEFAULT NULL COMMENT '生产厂商状态（1:正常；2：异常）',
  `addtime` int(11) DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qcode_company
-- ----------------------------

-- ----------------------------
-- Table structure for `qcode_label_config`
-- ----------------------------
DROP TABLE IF EXISTS `qcode_label_config`;
CREATE TABLE `qcode_label_config` (
  `id` tinyint(2) NOT NULL AUTO_INCREMENT,
  `label_type` tinyint(1) DEFAULT NULL COMMENT '标签类型（1：大标签2：小标签）',
  `totalnum` int(6) DEFAULT '120000' COMMENT '总张数',
  `bagnum` int(3) DEFAULT '98' COMMENT '包数',
  `paller_number` int(4) DEFAULT '1' COMMENT '托盘编号',
  `print_num` tinyint(2) DEFAULT '3' COMMENT '批量打印个数',
  `present_num` tinyint(3) DEFAULT NULL COMMENT '当前版号',
  `mixture_num` tinyint(3) DEFAULT NULL COMMENT '混板编号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qcode_label_config
-- ----------------------------

-- ----------------------------
-- Table structure for `qcode_print`
-- ----------------------------
DROP TABLE IF EXISTS `qcode_print`;
CREATE TABLE `qcode_print` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(40) DEFAULT NULL COMMENT '生产厂商名称',
  `company_info` varchar(50) DEFAULT NULL COMMENT '生产厂商地址邮编以及电话',
  `customer_name` varchar(20) DEFAULT NULL COMMENT '客户名称',
  `product_name` varchar(20) DEFAULT NULL COMMENT '产品名称',
  `product_num` varchar(20) DEFAULT NULL COMMENT '产品编号',
  `product_size` varchar(20) DEFAULT NULL COMMENT '产品规则',
  `totalnum` int(6) DEFAULT NULL COMMENT '总张数',
  `pallercount` tinyint(4) DEFAULT NULL COMMENT '配盘数量',
  `pallernum` tinyint(4) DEFAULT NULL COMMENT '当前的托盘数量',
  `labelcode` varchar(70) DEFAULT NULL COMMENT '标签代码',
  `standnum` varchar(20) DEFAULT NULL COMMENT '标准号',
  `product_batch` varchar(20) DEFAULT NULL COMMENT '生产批号',
  `pack_time` int(11) DEFAULT NULL COMMENT '包装日期',
  `qr_code` varchar(70) DEFAULT NULL COMMENT '二维码参数',
  `lable_type` tinyint(1) DEFAULT NULL COMMENT '标签类型（1:大标签2：小标签）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qcode_print
-- ----------------------------

-- ----------------------------
-- Table structure for `qcode_product`
-- ----------------------------
DROP TABLE IF EXISTS `qcode_product`;
CREATE TABLE `qcode_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(40) DEFAULT NULL COMMENT '产品名称',
  `product_size` varchar(20) DEFAULT NULL COMMENT '产品规格',
  `product_num` varchar(70) DEFAULT NULL COMMENT '产品编号',
  `product_batch` varchar(40) DEFAULT NULL COMMENT '生产批次',
  `label_type` tinyint(1) DEFAULT NULL COMMENT '标签类型（1:大标签；2：小标签）',
  `pack_time` int(11) DEFAULT NULL COMMENT '包装日期',
  `print_time` int(11) DEFAULT NULL COMMENT '打印日期',
  `repeatnum` tinyint(3) DEFAULT NULL COMMENT '补打次数',
  `labelcode` varchar(80) DEFAULT NULL COMMENT '标签代码',
  `repeat_time` int(11) DEFAULT NULL COMMENT '最近补打时间',
  `status` tinyint(1) DEFAULT NULL COMMENT '产品状态（1:未关联；2：已关联）',
  `versoin` varchar(40) DEFAULT NULL COMMENT '版本号',
  `standnum` varchar(30) DEFAULT NULL COMMENT '标准号 ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qcode_product
-- ----------------------------

-- ----------------------------
-- 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=9 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');
INSERT INTO `qr_admin_access` VALUES ('5', '7', '2', '1506062800', '1506062800', '0', '1');
INSERT INTO `qr_admin_access` VALUES ('6', '8', '3', '1506063863', '1506063863', '0', '1');
INSERT INTO `qr_admin_access` VALUES ('7', '9', '2', '1506065584', '1506065584', '0', '1');
INSERT INTO `qr_admin_access` VALUES ('8', '10', '2', '1511775677', '1511775677', '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=4 DEFAULT CHARSET=utf8 COMMENT='插件表';

-- ----------------------------
-- Records of qr_admin_addon
-- ----------------------------
INSERT INTO `qr_admin_addon` VALUES ('2', 'ModelConfigEditor', '模型配置器', '用于编辑已有模块的配置', 'null', 'yangweijie', '0.3', '0', '0', '1504590409', '1504590409', '0', '1');
INSERT INTO `qr_admin_addon` VALUES ('3', 'RocketToTop', '小火箭返回顶部', '小火箭返回顶部', '{\"status\":\"1\"}', 'OpenCMF', '1.3.0', '0', '0', '1505876954', '1505876954', '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=24 DEFAULT CHARSET=utf8 COMMENT='系统配置表';

-- ----------------------------
-- Records of qr_admin_config
-- ----------------------------
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 ('11', '文件上传大小', 'UPLOAD_FILE_SIZE', '10', '2', 'num', '', '文件上传大小单位：MB', '1428681031', '1428681031', '1', '1');
INSERT INTO `qr_admin_config` VALUES ('12', '图片上传大小', 'UPLOAD_IMAGE_SIZE', '50', '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', 'aliyun', '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:部署', '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', '0', '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');

-- ----------------------------
-- 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\",\"65\",\"66\",\"71\",\"61\",\"69\",\"70\",\"74\",\"78\"]}', '1504752936', '1506059248', '0', '1');
INSERT INTO `qr_admin_group` VALUES ('3', '1', '中烟', 'fa-arrow-circle-o-up', '{\"Admin\":[\"58\",\"60\",\"71\",\"61\",\"69\",\"70\",\"74\",\"76\",\"77\",\"78\"]}', '1504752959', '1506059238', '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\":{\"id\":\"3\",\"pid\":\"2\",\"title\":\"\\u7cfb\\u7edf\\u8bbe\\u7f6e\",\"url\":\"Admin\\/Config\\/group\",\"icon\":\"fa fa-th-list\"},\"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\":\"\\u56fe\\u7247\\u7ba1\\u7406\",\"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\":\"\\u6570\\u636e\\u6821\\u9a8c\",\"url\":\"Admin\\/Qr\\/UploadVerify\",\"icon\":\"fa fa-arrow-circle-o-up\"},\"60\":{\"id\":\"60\",\"pid\":\"58\",\"title\":\"\\u7533\\u8bf7\\u6279\\u6b21\",\"url\":\"Admin\\/ApplyBatch\\/index\",\"icon\":\"fa fa-align-right\"},\"61\":{\"id\":\"61\",\"pid\":\"58\",\"title\":\"\\u4efb\\u52a1\\u6d88\\u606f\",\"url\":\"Admin\\/ApplyBatch\\/applylist\",\"icon\":\"fa fa-indent\"},\"65\":{\"id\":\"65\",\"pid\":\"59\",\"title\":\"\\u4e0a\\u4f20\\u6587\\u4ef6\",\"url\":\"Admin\\/Qr\\/UploadTemp\",\"icon\":\"fa \"},\"66\":{\"id\":\"66\",\"pid\":\"59\",\"title\":\"\\u8868\\u5355\\u63d0\\u4ea4\",\"url\":\"Admin\\/Qr\\/Upload\",\"icon\":\"fa \"},\"67\":{\"pid\":\"2\",\"title\":\"\\u7801\\u5305\\u7ba1\\u7406\",\"url\":\"Admin\\/Qr\\/fileList\",\"icon\":\"fa fa-question-circle\",\"id\":\"67\"},\"69\":{\"pid\":\"61\",\"title\":\"\\u4efb\\u52a1\\u8be6\\u60c5\",\"url\":\"Admin\\/ApplyBatch\\/taskdetail\",\"icon\":\"fa \",\"id\":\"69\"},\"70\":{\"id\":\"70\",\"pid\":\"61\",\"title\":\"\\u4efb\\u52a1\\u5217\\u8868\",\"url\":\"Admin\\/ApplyBatch\\/tasklist\",\"icon\":\"fa \"},\"71\":{\"id\":\"71\",\"pid\":\"60\",\"title\":\"\\u6279\\u6b21\\u63d0\\u4ea4\",\"url\":\"Admin\\/ApplyBatch\\/applyform\",\"icon\":\"fa \"},\"74\":{\"pid\":\"61\",\"title\":\"\\u4e0b\\u8f7d\\u7801\\u5305\",\"url\":\"Admin\\/ApplyBatch\\/downloadzip\",\"icon\":\"fa \",\"id\":\"74\"},\"76\":{\"id\":\"76\",\"pid\":\"61\",\"title\":\"\\u7533\\u8bf7\\u8865\\u5355\",\"url\":\"Admin\\/ApplyBatch\\/addtaskindex\",\"icon\":\"fa \"},\"77\":{\"pid\":\"61\",\"title\":\"\\u8865\\u5355\\u8868\\u5355\",\"url\":\"Admin\\/ApplyBatch\\/addTaskForm\",\"icon\":\"fa \",\"id\":\"77\"},\"78\":{\"pid\":\"61\",\"title\":\"\\u6279\\u6b21\\u5217\\u8868\",\"url\":\"Admin\\/ApplyBatch\\/applylist\",\"icon\":\"fa \",\"id\":\"78\"},\"79\":{\"pid\":\"59\",\"title\":\"\\u6279\\u6b21\\u8be6\\u60c5\",\"url\":\"Admin\\/Qr\\/getBachInfo\",\"icon\":\"fa \",\"id\":\"79\"},\"80\":{\"id\":\"80\",\"pid\":\"58\",\"title\":\"\\u6fc0\\u6d3b\\u5217\\u8868\",\"url\":\"Admin\\/Activatelist\\/index\",\"icon\":\"fa fa-th-list\"},\"81\":{\"id\":\"81\",\"pid\":\"80\",\"title\":\"\\u589e\\u52a0\\u6fc0\\u6d3b\\u6279\\u6b21\",\"url\":\"Admin\\/Activatelist\\/add\",\"icon\":\"fa fa-plus-circle\"},\"82\":{\"id\":\"82\",\"pid\":\"1\",\"title\":\"\\u6761\\u5f62\\u7801\",\"url\":\"\",\"icon\":\"fa-barcode\"},\"83\":{\"id\":\"83\",\"pid\":\"82\",\"title\":\"\\u5927\\u4ef6\",\"url\":\"Admin\\/Bar\\/large\",\"icon\":\"fa fa-print\"},\"84\":{\"id\":\"84\",\"pid\":\"82\",\"title\":\"\\u5c0f\\u4ef6\",\"url\":\"Admin\\/Bar\\/small\",\"icon\":\"fa fa-print\"},\"85\":{\"id\":\"85\",\"pid\":\"82\",\"title\":\"\\u4ea7\\u54c1\\u914d\\u7f6e\",\"url\":\"Admin\\/Bar\\/product\",\"icon\":\"fa fa-cogs\"},\"86\":{\"id\":\"86\",\"pid\":\"1\",\"title\":\"\\u4e8c\\u7ef4\\u7801\",\"url\":\"\",\"icon\":\"fa fa-qrcode\"},\"87\":{\"id\":\"87\",\"pid\":\"86\",\"title\":\"\\u5927\\u4ef6\",\"url\":\"Admin\\/Qcode\\/large\",\"icon\":\"fa fa-print\"},\"88\":{\"id\":\"88\",\"pid\":\"86\",\"title\":\"\\u5c0f\\u4ef6\",\"url\":\"Admin\\/Qcode\\/small\",\"icon\":\"fa fa-print\"},\"89\":{\"id\":\"89\",\"pid\":\"86\",\"title\":\"\\u4ea7\\u54c1\\u914d\\u7f6e\",\"url\":\"Admin\\/Qcode\\/product\",\"icon\":\"fa fa-cogs\"}}', '1', '1438651748', '1532758754', '0', '1');

-- ----------------------------
-- 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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='文件上传表';

-- ----------------------------
-- Records of qr_admin_upload
-- ----------------------------
INSERT INTO `qr_admin_upload` VALUES ('5', '1', '404_1.gif', '/Uploads/2017-09-19/59c08de3456f1.gif', '', 'gif', '839155', 'edfd40a2d78d92d466484529d799a6c1', '44384b55662e5c6416fa30c381d0ddaba5a03449', 'Local', '0', '1505791459', '1505791459', '0', '0', '1');
INSERT INTO `qr_admin_upload` VALUES ('6', '1', 'meinonglogo.png', '/Uploads/2017-09-20/59c1dd3c6bb03.png', '', 'png', '17801', 'a238c1fbc6c4bc7144966ea9c4c83080', '7d6158019d17fd7bb5c822111e3a5053a8913644', 'Local', '0', '1505877308', '1505877308', '0', '0', '1');

-- ----------------------------
-- 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=11 DEFAULT CHARSET=utf8 COMMENT='用户账号表';

-- ----------------------------
-- Records of qr_admin_user
-- ----------------------------
INSERT INTO `qr_admin_user` VALUES ('1', '1', '超级管理员', 'admin', 'c6866fbbe60906a7524e2d8121a18b12', '1@qq.com', '0', '15669966908', '0', '4', '0', '0.00', '0', 'admin', '1438651748', '1505876759', '1', '');
INSERT INTO `qr_admin_user` VALUES ('2', '1', '浙江美浓易盒包装科技有限公司', 'meinong', 'c6866fbbe60906a7524e2d8121a18b12', '14906570@qq.com', '1', '13958052363', '1', '6', '0', '0.00', '2130706433', '', '1504766374', '1505879821', '1', '');
INSERT INTO `qr_admin_user` VALUES ('3', '1', '浙江中烟', 'zjzy', 'c6866fbbe60906a7524e2d8121a18b12', 'zy@qq.com', '0', '13022222222', '0', '0', '0', '0.00', '2130706433', 'admin', '1504766662', '1505876739', '1', '');
INSERT INTO `qr_admin_user` VALUES ('4', '1', 'GAD', 'system', 'e6e7693db07443e3dddba3bab4606c86', '6@163.com', '0', '18655057865', '0', '3', '0', '0.00', '2105028283', 'admin', '1505722464', '1505722464', '1', '');
INSERT INTO `qr_admin_user` VALUES ('5', '1', '上帝', 'systemmm', 'e6e7693db07443e3dddba3bab4606c86', '1@163.com', '0', '18644949987', '0', '4', '0', '0.00', '2105028283', 'admin', '1505722733', '1505722733', '1', '');
INSERT INTO `qr_admin_user` VALUES ('6', '1', '湖北京华彩印有限公司', 'jinhua', '580b10c2f4f04b481ce4e660e650ac1a', '1508318765@qq.com', '1', '18158717303', '1', '0', '0', '0.00', '2105028283', 'admin', '1505878202', '1505878202', '1', '');
INSERT INTO `qr_admin_user` VALUES ('7', '1', '阿里云印刷厂', 'hgz', 'ee4ce4ba3d1ff65af3c47dfd3ca14b14', '888@qq.com', '0', '18268889990', '0', '0', '0', '0.00', '2130706433', 'admin', '1506062800', '1506065905', '1', '');
INSERT INTO `qr_admin_user` VALUES ('8', '1', '河南中烟', 'hnzy', 'c6866fbbe60906a7524e2d8121a18b12', '496277208@qq.com', '0', '15538033019', '0', '0', '0', '0.00', '2130706433', 'admin', '1506063840', '1506063840', '1', '');
INSERT INTO `qr_admin_user` VALUES ('9', '1', '河南亲亲印刷厂', 'qinqin', 'c6866fbbe60906a7524e2d8121a18b12', '496@qq.com', '0', '15538033111', '0', '0', '0', '0.00', '2130706433', 'admin', '1506065521', '1506065521', '1', '');
INSERT INTO `qr_admin_user` VALUES ('10', '1', '河南桐裕印务有限公司', 'hntyyw', 'c6866fbbe60906a7524e2d8121a18b12', '123123@qq.com', '0', '13000000000', '0', '0', '0', '0.00', '1942485054', 'admin', '1511775645', '1511775645', '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 '备注',
  `owner_id` int(11) NOT NULL COMMENT '中烟id',
  `printer_id` int(11) NOT NULL COMMENT '印刷厂id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- 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,
  `bach_id` int(11) NOT NULL COMMENT '批次id',
  `product_id` int(11) NOT NULL COMMENT '产品id',
  `num` float NOT NULL COMMENT '需求数量',
  `is_verif` tinyint(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=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- 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=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qr_box_type
-- ----------------------------
INSERT INTO `qr_box_type` VALUES ('1', '条盒');
INSERT INTO `qr_box_type` VALUES ('2', '小包');

-- ----------------------------
-- Table structure for `qr_codes`
-- ----------------------------
DROP TABLE IF EXISTS `qr_codes`;
CREATE TABLE `qr_codes` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(120) NOT NULL COMMENT '码',
  `varify_code` varchar(6) NOT NULL COMMENT '验证码',
  `bach_id` int(11) NOT NULL COMMENT '批次id',
  `tasks_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` tinyint(1) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`) USING BTREE COMMENT '对code字段设置唯一索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- 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=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qr_factory
-- ----------------------------
INSERT INTO `qr_factory` VALUES ('1', '郑州卷烟厂');
INSERT INTO `qr_factory` VALUES ('2', '安阳卷烟厂');
INSERT INTO `qr_factory` VALUES ('3', '周口卷烟厂');

-- ----------------------------
-- Table structure for `qr_file_log`
-- ----------------------------
DROP TABLE IF EXISTS `qr_file_log`;
CREATE TABLE `qr_file_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` int(10) NOT NULL,
  `filename` varchar(50) NOT NULL COMMENT '文件名',
  `path` varchar(255) NOT NULL COMMENT '路径+文件',
  `url` varchar(255) NOT NULL COMMENT '路径',
  `success_num` int(11) NOT NULL COMMENT '成功条数',
  `error_num` int(11) NOT NULL COMMENT '失败条数 ',
  `total` int(11) NOT NULL COMMENT '总条数',
  `batch_id` int(11) NOT NULL COMMENT '批次号',
  `creator` varchar(20) NOT NULL COMMENT '创建者',
  `task_id` int(11) NOT NULL COMMENT '任务id',
  `status` tinyint(1) NOT NULL COMMENT '0 未完全验证 1 完全验证',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qr_file_log
-- ----------------------------

-- ----------------------------
-- 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 '产品主图',
  `factory_id` int(11) NOT NULL COMMENT '中烟工厂id',
  `add_time` int(11) NOT NULL COMMENT '添加时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  `status` tinyint(1) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qr_product
-- ----------------------------
INSERT INTO `qr_product` VALUES ('1', '金丝路', '', '1', '0', '0', '0');
INSERT INTO `qr_product` VALUES ('2', '小黄金', '', '2', '0', '0', '0');

-- ----------------------------
-- Table structure for `qr_product_box_type`
-- ----------------------------
DROP TABLE IF EXISTS `qr_product_box_type`;
CREATE TABLE `qr_product_box_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(5) NOT NULL COMMENT '产品id表',
  `box_type_id` int(5) NOT NULL COMMENT '盒型id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qr_product_box_type
-- ----------------------------
INSERT INTO `qr_product_box_type` VALUES ('1', '1', '1');
INSERT INTO `qr_product_box_type` VALUES ('2', '1', '2');
INSERT INTO `qr_product_box_type` VALUES ('3', '2', '1');
INSERT INTO `qr_product_box_type` VALUES ('4', '2', '2');

-- ----------------------------
-- 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` tinyint(1) NOT NULL COMMENT '是否需要验证码',
  `printer_id` int(11) NOT NULL COMMENT '印刷厂id',
  `owner_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` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态（0：码包生成中，1：待印刷厂下载  2:印刷厂校验中 3.码包校验完成）',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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