/* 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 -- ----------------------------