ewr_label_config.sql 1.1 KB

123456789101112131415161718192021222324252627282930313233343536
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : localhost_3306
  4. Source Server Version : 50617
  5. Source Host : localhost:3306
  6. Source Database : dm_7in6_com
  7. Target Server Type : MYSQL
  8. Target Server Version : 50617
  9. File Encoding : 65001
  10. Date: 2018-07-28 12:40:48
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for `ewr_label_config`
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `ewr_label_config`;
  17. CREATE TABLE `ewr_label_config` (
  18. `id` tinyint(2) NOT NULL AUTO_INCREMENT,
  19. `label_type` tinyint(1) DEFAULT NULL COMMENT '标签类型(1:大标签2:小标签)',
  20. `totalnum` int(6) DEFAULT '120000' COMMENT '总张数',
  21. `bagnum` int(3) DEFAULT '98' COMMENT '包数',
  22. `paller_number` int(4) DEFAULT '1' COMMENT '托盘编号',
  23. `print_num` tinyint(2) DEFAULT '3' COMMENT '批量打印个数',
  24. `present_num` tinyint(3) DEFAULT NULL COMMENT '当前版号',
  25. `mixture_num` tinyint(3) DEFAULT NULL COMMENT '混板编号',
  26. PRIMARY KEY (`id`)
  27. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  28. -- ----------------------------
  29. -- Records of ewr_label_config
  30. -- ----------------------------