| | |
| | | /*
|
| | | Navicat MySQL Data Transfer
|
| | |
|
| | | Source Server : 本地
|
| | | Source Server : server-150
|
| | | Source Server Type : MySQL
|
| | | Source Server Version : 80022
|
| | | Source Host : localhost:3306
|
| | | Source Server Version : 80019
|
| | | Source Host : 10.153.19.150:3306
|
| | | Source Schema : canadames
|
| | |
|
| | | Target Server Type : MySQL
|
| | | Target Server Version : 80022
|
| | | Target Server Version : 80019
|
| | | File Encoding : 65001
|
| | |
|
| | | Date: 05/09/2023 16:20:45
|
| | | Date: 11/09/2023 08:31:21
|
| | | */
|
| | |
|
| | | SET NAMES utf8mb4;
|
| | | SET FOREIGN_KEY_CHECKS = 0;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for alarmmg
|
| | | -- ----------------------------
|
| | | DROP TABLE IF EXISTS `alarmmg`;
|
| | | CREATE TABLE `alarmmg` (
|
| | | `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
| | | `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报警信息',
|
| | | `timeon` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
|
| | | `endTime` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 1337 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of alarmmg
|
| | | -- ----------------------------
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for category
|
| | |
| | | `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
|
| | | `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类' ROW_FORMAT = Dynamic;
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类' ROW_FORMAT = DYNAMIC;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of category
|
| | |
| | | `last_product_count_date` date NULL DEFAULT NULL,
|
| | | PRIMARY KEY (`id`) USING BTREE,
|
| | | UNIQUE INDEX `device_id_idx`(`device_id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of device
|
| | |
| | | `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
|
| | | `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of menu_list
|
| | |
| | | INSERT INTO `menu_list` VALUES (5, NULL, '权限管理', 'el-icon-collection-tag', 5, '', 1, '2021-11-28 14:30:27', '2021-11-28 15:06:04');
|
| | | INSERT INTO `menu_list` VALUES (6, NULL, '角色管理', 'el-icon-s-flag', 6, '', 1, '2021-11-28 14:30:27', '2021-11-28 15:06:04');
|
| | | INSERT INTO `menu_list` VALUES (7, 1, '用户列表', '', 7, 'user', 1, '2021-11-28 14:30:27', '2021-11-28 15:06:04');
|
| | | INSERT INTO `menu_list` VALUES (8, 9, '主页', 'el-icon-menu', 8, 'home', 1, '2023-09-08 10:56:12', '2023-09-08 11:02:36');
|
| | | INSERT INTO `menu_list` VALUES (9, NULL, '主页', 'el-icon-menu', 0, 'home', 1, '2023-09-08 10:43:34', '2023-09-08 11:02:32');
|
| | | INSERT INTO `menu_list` VALUES (11, 5, '权限列表', '', 11, 'power', 1, '2021-11-28 14:30:28', '2021-11-28 15:06:04');
|
| | | INSERT INTO `menu_list` VALUES (12, 6, '角色列表', '', 12, 'role', 1, '2021-11-28 14:30:28', '2021-11-28 15:06:04');
|
| | | INSERT INTO `menu_list` VALUES (49, 2, '报警信息', '', 49, 'Electrical/Action', 1, '2021-11-28 14:30:28', '2023-09-01 16:33:29');
|
| | | INSERT INTO `menu_list` VALUES (49, 2, '报警信息', '', 49, 'Electrical/alarm', 1, '2021-11-28 14:30:28', '2023-09-08 11:14:08');
|
| | | INSERT INTO `menu_list` VALUES (51, 2, 'I/O状态', NULL, 51, 'Electrical/State', 1, '2023-08-25 13:29:13', '2023-09-01 16:34:03');
|
| | | INSERT INTO `menu_list` VALUES (52, 2, '开关控制', NULL, 52, 'Electrical/Sign', 1, '2023-08-25 13:29:18', '2023-09-01 16:33:48');
|
| | | INSERT INTO `menu_list` VALUES (52, 2, '开关控制', NULL, 52, 'Electrical/action', 1, '2023-08-25 13:29:18', '2023-09-08 13:40:59');
|
| | | INSERT INTO `menu_list` VALUES (53, 2, '参数下发', NULL, 53, 'Electrical/Parameter', 1, '2023-08-25 13:29:22', '2023-09-01 16:32:29');
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for order_out
|
| | | -- ----------------------------
|
| | | DROP TABLE IF EXISTS `order_out`;
|
| | | CREATE TABLE `order_out` (
|
| | | `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
|
| | | `order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单号',
|
| | | `state` int NULL DEFAULT NULL COMMENT '状态(0:按此订单号出片,1结束出片)',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of order_out
|
| | | -- ----------------------------
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for permission
|
| | |
| | | `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
|
| | | `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限' ROW_FORMAT = Dynamic;
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限' ROW_FORMAT = DYNAMIC;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of permission
|
| | |
| | | `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
|
| | | `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic;
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = DYNAMIC;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of role
|
| | | -- ----------------------------
|
| | | INSERT INTO `role` VALUES (1, NULL, 'admin', '系统管理员', 1, '2021-01-10 22:49:17', '2021-03-29 15:19:15');
|
| | | INSERT INTO `role` VALUES (2, 1, 'user', '普通用户', 1, '2021-01-13 00:28:58', '2021-03-29 15:19:15');
|
| | | INSERT INTO `role` VALUES (2, 1, 'user2', '普通用户', 1, '2021-01-13 00:28:58', '2021-03-29 15:19:15');
|
| | | INSERT INTO `role` VALUES (5, 1, 'user3', '777', 1, '2023-08-24 10:02:58', '2023-08-28 14:28:22');
|
| | |
|
| | | -- ----------------------------
|
| | |
| | | `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
|
| | | `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = DYNAMIC;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of role_menu_list
|
| | |
| | | INSERT INTO `role_menu_list` VALUES (51, 2, 49, 1, '2023-08-28 15:14:27', '2023-08-28 15:53:34');
|
| | | INSERT INTO `role_menu_list` VALUES (52, 2, 1, 1, '2023-08-30 16:28:57', '2023-08-30 16:28:57');
|
| | | INSERT INTO `role_menu_list` VALUES (53, 2, 7, 1, '2023-08-30 16:29:05', '2023-08-30 16:29:05');
|
| | | INSERT INTO `role_menu_list` VALUES (54, 1, 9, 1, '2023-09-08 10:55:54', '2023-09-08 11:02:55');
|
| | | INSERT INTO `role_menu_list` VALUES (55, 1, 8, 1, '2023-09-08 10:56:45', '2023-09-08 11:01:43');
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for role_permission
|
| | |
| | | `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
|
| | | `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 76 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限' ROW_FORMAT = Dynamic;
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 76 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限' ROW_FORMAT = DYNAMIC;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of role_permission
|
| | |
| | | INSERT INTO `role_permission` VALUES (69, 2, 26, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54');
|
| | | INSERT INTO `role_permission` VALUES (70, 2, 27, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54');
|
| | | INSERT INTO `role_permission` VALUES (71, 2, 28, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54');
|
| | | INSERT INTO `role_permission` VALUES (72, 2, 30, 1, '2023-08-24 08:55:34', '2023-08-24 08:55:34');
|
| | | INSERT INTO `role_permission` VALUES (73, 2, 29, 1, '2023-08-24 08:56:15', '2023-08-28 15:33:14');
|
| | | INSERT INTO `role_permission` VALUES (72, 2, 30, 0, '2023-08-24 08:55:34', '2023-08-24 08:55:34');
|
| | | INSERT INTO `role_permission` VALUES (73, 2, 29, 0, '2023-08-24 08:56:15', '2023-08-28 15:33:14');
|
| | | INSERT INTO `role_permission` VALUES (74, 2, 1, 1, '2023-08-30 16:29:46', '2023-08-30 16:29:46');
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for storage_cage
|
| | | -- ----------------------------
|
| | | DROP TABLE IF EXISTS `storage_cage`;
|
| | | CREATE TABLE `storage_cage` (
|
| | | `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
|
| | | `glass_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '玻璃id',
|
| | | `order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单id',
|
| | | `cage` int NULL DEFAULT NULL COMMENT '笼子id',
|
| | | `cell` int NULL DEFAULT NULL COMMENT '格子id',
|
| | | `tier` int NULL DEFAULT NULL COMMENT '格子层id',
|
| | | `width` decimal(7, 2) NULL DEFAULT NULL COMMENT '格子宽',
|
| | | `glasswidth` decimal(7, 2) NULL DEFAULT NULL COMMENT '玻璃宽',
|
| | | `glassheight` decimal(7, 2) NULL DEFAULT NULL COMMENT '玻璃高',
|
| | | `state` int NULL DEFAULT NULL COMMENT '状态(0:无玻璃,1:有玻璃,2:进片中,3:出片中,4:调度中)',
|
| | | `coating` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '涂层',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 421 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of storage_cage
|
| | | -- ----------------------------
|
| | | INSERT INTO `storage_cage` VALUES (1, 'A001', 'A001', 1, 1, 1, 1760.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (2, 'A001', 'A001', 1, 1, 2, 1760.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (3, '0', NULL, 1, 2, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (4, '0', NULL, 1, 2, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (5, '0', NULL, 1, 3, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (6, '0', NULL, 1, 3, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (7, '0', NULL, 1, 4, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (8, '0', NULL, 1, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (9, '0', NULL, 1, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (10, '0', NULL, 1, 5, 2, 1600.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (11, '0', NULL, 1, 6, 1, 1600.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (12, NULL, NULL, 1, 6, 2, 1600.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (13, '3', 'A001', 1, 7, 1, 1600.00, 3.00, 5.00, 3, 'low-e');
|
| | | INSERT INTO `storage_cage` VALUES (14, '0', NULL, 1, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (15, '0', NULL, 1, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (16, '0', NULL, 1, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (17, '0', NULL, 1, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (18, '0', NULL, 1, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (19, '0', NULL, 1, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (20, '0', NULL, 1, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (21, '0', NULL, 1, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (22, '0', NULL, 1, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (23, '0', NULL, 1, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (24, '0', NULL, 1, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (25, '0', NULL, 1, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (26, '0', NULL, 1, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (27, '0', NULL, 1, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (28, '0', NULL, 1, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (29, '0', NULL, 1, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (30, '0', NULL, 1, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (31, '0', NULL, 1, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (32, '0', NULL, 1, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (33, '0', NULL, 1, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (34, '0', NULL, 1, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (35, '0', NULL, 1, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (36, '0', NULL, 1, 18, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (37, '0', NULL, 1, 19, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (38, '0', NULL, 1, 19, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (39, '0', NULL, 1, 20, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (40, '0', NULL, 1, 20, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (41, '0', NULL, 1, 21, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (42, '0', NULL, 1, 21, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (43, '0', NULL, 2, 1, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (44, '0', NULL, 2, 1, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (45, '0', NULL, 2, 2, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (46, '0', NULL, 2, 2, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (47, '0', NULL, 2, 3, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (48, '0', NULL, 2, 3, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (49, '0', 'A001', 2, 4, 1, 1550.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (50, '0', 'A001', 2, 4, 2, 1550.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (51, '0', NULL, 2, 5, 1, 1550.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (52, '0', NULL, 2, 5, 2, 1550.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (53, '0', NULL, 2, 6, 1, 1550.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (54, '0', NULL, 2, 6, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (55, '0', NULL, 2, 7, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (56, '0', NULL, 2, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (57, '0', NULL, 2, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (58, '0', NULL, 2, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (59, '0', NULL, 2, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (60, '0', NULL, 2, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (61, '0', NULL, 2, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (62, '0', NULL, 2, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (63, '0', NULL, 2, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (64, '0', NULL, 2, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (65, '0', NULL, 2, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (66, '0', NULL, 2, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (67, '0', NULL, 2, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (68, '0', NULL, 2, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (69, '0', NULL, 2, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (70, '0', NULL, 2, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (71, '0', NULL, 2, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (72, '0', NULL, 2, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (73, '0', NULL, 2, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (74, '0', NULL, 2, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (75, '0', NULL, 2, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (76, '0', NULL, 2, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (77, '0', NULL, 2, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (78, '0', NULL, 2, 18, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (79, '0', NULL, 2, 19, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (80, '0', NULL, 2, 19, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (81, '0', NULL, 2, 20, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (82, '0', NULL, 2, 20, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (83, '0', NULL, 2, 21, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (84, '0', NULL, 2, 21, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (85, '0', NULL, 3, 1, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (86, '0', NULL, 3, 1, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (87, '0', NULL, 3, 2, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (88, '0', 'A001', 3, 2, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (89, '0', 'A001', 3, 3, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (90, '0', 'A001', 3, 3, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (91, '0', 'A001', 3, 4, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (92, '0', 'A001', 3, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (93, '0', 'A001', 3, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (94, '0', 'A001', 3, 5, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (95, '0', NULL, 3, 6, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (96, '0', NULL, 3, 6, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (97, '0', NULL, 3, 7, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (98, '0', NULL, 3, 7, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (99, '0', NULL, 3, 8, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (100, '0', NULL, 3, 8, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (101, '0', NULL, 3, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (102, '0', NULL, 3, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (103, '0', NULL, 3, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (104, '0', NULL, 3, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (105, '0', NULL, 3, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (106, '0', NULL, 3, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (107, '0', NULL, 3, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (108, '0', NULL, 3, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (109, '0', NULL, 3, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (110, '0', NULL, 3, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (111, '0', NULL, 3, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (112, '0', NULL, 3, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (113, '0', NULL, 3, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (114, '0', NULL, 3, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (115, '0', NULL, 3, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (116, '0', NULL, 3, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (117, '0', NULL, 3, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (118, '0', NULL, 3, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (119, '0', NULL, 3, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (120, '0', NULL, 3, 18, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (121, '0', NULL, 3, 19, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (122, '0', NULL, 3, 19, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (123, '0', NULL, 3, 20, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (124, '0', NULL, 3, 20, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (125, '0', NULL, 3, 21, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (126, '0', NULL, 3, 21, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (127, '0', NULL, 4, 1, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (128, '0', NULL, 4, 1, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (129, '0', NULL, 4, 2, 1, 1550.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (130, '0', NULL, 4, 2, 2, 1550.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (131, '0', NULL, 4, 3, 1, 1550.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (132, '0', NULL, 4, 3, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (133, '0', NULL, 4, 4, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (134, '0', NULL, 4, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (135, '0', NULL, 4, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (136, '0', NULL, 4, 5, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (137, '0', NULL, 4, 6, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (138, '0', NULL, 4, 6, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (139, '0', NULL, 4, 7, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (140, '0', NULL, 4, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (141, '0', 'A001', 4, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (142, '0', 'A001', 4, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (143, '0', 'A001', 4, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (144, '0', 'A001', 4, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (145, '0', 'A001', 4, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (146, '0', 'A001', 4, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (147, '0', NULL, 4, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (148, '0', NULL, 4, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (149, '0', NULL, 4, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (150, '0', NULL, 4, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (151, '0', NULL, 4, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (152, '0', NULL, 4, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (153, '0', NULL, 4, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (154, '0', NULL, 4, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (155, '0', NULL, 4, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (156, '0', NULL, 4, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (157, '0', NULL, 4, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (158, '0', NULL, 4, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (159, '0', NULL, 4, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (160, '0', NULL, 4, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (161, '0', NULL, 4, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (162, '0', NULL, 4, 18, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (163, '0', NULL, 4, 19, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (164, '0', NULL, 4, 19, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (165, '0', NULL, 4, 20, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (166, '0', NULL, 4, 20, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (167, '0', NULL, 4, 21, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (168, '0', NULL, 4, 21, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (169, '0', NULL, 5, 1, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (170, '0', NULL, 5, 1, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (171, '0', NULL, 5, 2, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (172, '0', NULL, 5, 2, 2, 1550.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (173, '0', NULL, 5, 3, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (174, '0', NULL, 5, 3, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (175, '0', NULL, 5, 4, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (176, '0', NULL, 5, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (177, '0', NULL, 5, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (178, '0', NULL, 5, 5, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (179, '0', NULL, 5, 6, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (180, '0', NULL, 5, 6, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (181, '0', NULL, 5, 7, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (182, '0', NULL, 5, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (183, '0', NULL, 5, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (184, '0', NULL, 5, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (185, '0', NULL, 5, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (186, '0', NULL, 5, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (187, '0', NULL, 5, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (188, '0', NULL, 5, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (189, '0', NULL, 5, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (190, '0', NULL, 5, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (191, '0', NULL, 5, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (192, '0', NULL, 5, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (193, '0', NULL, 5, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (194, '0', NULL, 5, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (195, '0', NULL, 5, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (196, '0', NULL, 5, 14, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (197, '0', NULL, 5, 15, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (198, '0', NULL, 5, 15, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (199, '0', NULL, 5, 16, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (200, '0', NULL, 5, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (201, '0', NULL, 5, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (202, '0', NULL, 5, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (203, '0', NULL, 5, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (204, '0', NULL, 5, 18, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (205, '0', NULL, 5, 19, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (206, '0', NULL, 5, 19, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (207, '0', NULL, 5, 20, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (208, '0', NULL, 5, 20, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (209, '0', NULL, 5, 21, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (210, '0', NULL, 5, 21, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (211, '0', 'A001', 6, 1, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (212, '0', 'A002', 6, 1, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (213, '0', NULL, 6, 2, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (214, '0', NULL, 6, 2, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (215, '0', NULL, 6, 3, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (216, '0', NULL, 6, 3, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (217, '0', NULL, 6, 4, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (218, '0', NULL, 6, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (219, '0', NULL, 6, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (220, '0', NULL, 6, 5, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (221, '0', NULL, 6, 6, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (222, '0', NULL, 6, 6, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (223, '0', NULL, 6, 7, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (224, '0', NULL, 6, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (225, '0', NULL, 6, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (226, '0', NULL, 6, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (227, '0', NULL, 6, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (228, '0', NULL, 6, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (229, '0', NULL, 6, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (230, '0', NULL, 6, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (231, '0', NULL, 6, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (232, '0', NULL, 6, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (233, '0', NULL, 6, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (234, '0', NULL, 6, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (235, '0', NULL, 6, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (236, '0', NULL, 6, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (237, '0', NULL, 6, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (238, '0', NULL, 6, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (239, '0', NULL, 6, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (240, '0', NULL, 6, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (241, '0', NULL, 6, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (242, '0', NULL, 6, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (243, '0', NULL, 6, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (244, '0', NULL, 6, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (245, '0', NULL, 6, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (246, '0', NULL, 6, 18, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (247, '0', NULL, 6, 19, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (248, '0', NULL, 6, 19, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (249, '0', NULL, 6, 20, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (250, '0', NULL, 6, 20, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (251, '0', NULL, 6, 21, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (252, '0', NULL, 6, 21, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (253, '0', NULL, 7, 1, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (254, '0', NULL, 7, 1, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (255, '0', NULL, 7, 2, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (256, '0', NULL, 7, 2, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (257, '0', NULL, 7, 3, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (258, '0', NULL, 7, 3, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (259, '0', NULL, 7, 4, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (260, '0', NULL, 7, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (261, '0', NULL, 7, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (262, '0', NULL, 7, 5, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (263, '0', NULL, 7, 6, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (264, '0', NULL, 7, 6, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (265, '0', NULL, 7, 7, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (266, '0', NULL, 7, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (267, '0', NULL, 7, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (268, '0', NULL, 7, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (269, '0', NULL, 7, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (270, '0', NULL, 7, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (271, '0', NULL, 7, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (272, '0', NULL, 7, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (273, '0', NULL, 7, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (274, '0', NULL, 7, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (275, '0', NULL, 7, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (276, '0', NULL, 7, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (277, '0', NULL, 7, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (278, '0', NULL, 7, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (279, '0', NULL, 7, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (280, '0', NULL, 7, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (281, '0', NULL, 7, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (282, '0', NULL, 7, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (283, '0', NULL, 7, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (284, '0', NULL, 7, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (285, '0', NULL, 7, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (286, '0', NULL, 7, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (287, '0', NULL, 7, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (288, '0', NULL, 7, 18, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (289, '0', NULL, 7, 19, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (290, '0', NULL, 7, 19, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (291, '0', NULL, 7, 20, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (292, '0', NULL, 7, 20, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (293, '0', NULL, 7, 21, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (294, '0', NULL, 7, 21, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (295, '0', NULL, 8, 1, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (296, '0', NULL, 8, 1, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (297, '0', NULL, 8, 2, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (298, '0', NULL, 8, 2, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (299, '0', NULL, 8, 3, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (300, '0', NULL, 8, 3, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (301, '0', NULL, 8, 4, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (302, '0', NULL, 8, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (303, '0', NULL, 8, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (304, '0', NULL, 8, 5, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (305, '0', NULL, 8, 6, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (306, '0', NULL, 8, 6, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (307, '0', NULL, 8, 7, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (308, '0', NULL, 8, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (309, '0', NULL, 8, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (310, '0', NULL, 8, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (311, '0', NULL, 8, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (312, '0', NULL, 8, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (313, '0', NULL, 8, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (314, '0', NULL, 8, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (315, '0', NULL, 8, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (316, '0', NULL, 8, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (317, '0', NULL, 8, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (318, '0', NULL, 8, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (319, '0', NULL, 8, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (320, '0', NULL, 8, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (321, '0', NULL, 8, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (322, '0', NULL, 8, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (323, '0', NULL, 8, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (324, '0', NULL, 8, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (325, '0', NULL, 8, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (326, '0', NULL, 8, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (327, '0', NULL, 8, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (328, '0', NULL, 8, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (329, '0', NULL, 8, 18, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (330, '0', NULL, 8, 18, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (331, '0', NULL, 8, 19, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (332, '0', NULL, 8, 19, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (333, '0', NULL, 8, 20, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (334, '0', NULL, 8, 20, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (335, '0', NULL, 8, 21, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (336, '0', NULL, 8, 21, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (337, '0', NULL, 9, 1, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (338, '0', NULL, 9, 1, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (339, '0', NULL, 9, 2, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (340, '0', NULL, 9, 2, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (341, '0', NULL, 9, 3, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (342, '0', NULL, 9, 3, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (343, '0', NULL, 9, 4, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (344, '0', NULL, 9, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (345, '0', NULL, 9, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (346, '0', NULL, 9, 5, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (347, '0', NULL, 9, 6, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (348, '0', NULL, 9, 6, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (349, '0', NULL, 9, 7, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (350, '0', NULL, 9, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (351, '0', NULL, 9, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (352, '0', NULL, 9, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (353, '0', NULL, 9, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (354, '0', NULL, 9, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (355, '0', NULL, 9, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (356, '0', NULL, 9, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (357, '0', NULL, 9, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (358, '0', NULL, 9, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (359, '0', NULL, 9, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (360, '0', NULL, 9, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (361, '0', NULL, 9, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (362, '0', NULL, 9, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (363, '0', NULL, 9, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (364, '0', NULL, 9, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (365, '0', NULL, 9, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (366, '0', NULL, 9, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (367, '0', NULL, 9, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (368, '0', NULL, 9, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (369, '0', NULL, 9, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (370, '0', NULL, 9, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (371, '0', NULL, 9, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (372, '0', NULL, 9, 18, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (373, '0', NULL, 9, 19, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (374, '0', NULL, 9, 19, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (375, '0', NULL, 9, 20, 1, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (376, '0', NULL, 9, 20, 2, 1788.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (377, '0', NULL, 9, 21, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (378, '0', NULL, 9, 21, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (379, '0', NULL, 10, 1, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (380, '0', NULL, 10, 1, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (381, '0', NULL, 10, 2, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (382, '0', NULL, 10, 2, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (383, '0', NULL, 10, 3, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (384, '0', NULL, 10, 3, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (385, '0', NULL, 10, 4, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (386, '0', NULL, 10, 4, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (387, '0', NULL, 10, 5, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (388, '0', NULL, 10, 5, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (389, '0', NULL, 10, 6, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (390, '0', NULL, 10, 6, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (391, '0', NULL, 10, 7, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (392, '0', NULL, 10, 7, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (393, '0', NULL, 10, 8, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (394, '0', NULL, 10, 8, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (395, '0', NULL, 10, 9, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (396, '0', NULL, 10, 9, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (397, '0', NULL, 10, 10, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (398, '0', NULL, 10, 10, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (399, '0', NULL, 10, 11, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (400, '0', NULL, 10, 11, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (401, '0', NULL, 10, 12, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (402, '0', NULL, 10, 12, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (403, '0', NULL, 10, 13, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (404, '0', NULL, 10, 13, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (405, '0', NULL, 10, 14, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (406, '0', NULL, 10, 14, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (407, '0', NULL, 10, 15, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (408, '0', NULL, 10, 15, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (409, '0', NULL, 10, 16, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (410, '0', NULL, 10, 16, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (411, '0', NULL, 10, 17, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (412, '0', NULL, 10, 17, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (413, '0', NULL, 10, 18, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (414, '0', NULL, 10, 18, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (415, '0', NULL, 10, 19, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (416, '0', NULL, 10, 19, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (417, '0', NULL, 10, 20, 1, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (418, '0', NULL, 10, 20, 2, 1500.00, NULL, NULL, 1, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (419, '0', NULL, 10, 21, 1, 1500.00, NULL, NULL, 0, NULL);
|
| | | INSERT INTO `storage_cage` VALUES (420, '0', NULL, 10, 21, 2, 1500.00, NULL, NULL, 0, NULL);
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for storage_rack
|
| | |
| | | INSERT INTO `storage_rack` VALUES (491, 210, 1, NULL, NULL, NULL, 2, 10);
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for storage_task
|
| | | -- ----------------------------
|
| | | DROP TABLE IF EXISTS `storage_task`;
|
| | | CREATE TABLE `storage_task` (
|
| | | `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
|
| | | `task_type` int NULL DEFAULT NULL COMMENT '任务类型(0:进片,1:出片,2:调度)',
|
| | | `task_state` int NULL DEFAULT NULL COMMENT '任务状态(0:未完成,1:完成)',
|
| | | `shelf_rack` int NULL DEFAULT NULL COMMENT '开始位置',
|
| | | `load_rack` int NULL DEFAULT NULL COMMENT '结束位置',
|
| | | `start_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '任务开始时间',
|
| | | `finsh_time` datetime(0) NULL DEFAULT NULL COMMENT '任务结束时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of storage_task
|
| | | -- ----------------------------
|
| | | INSERT INTO `storage_task` VALUES (1, 0, 1, 6, 105, '2023-09-07 10:11:47', '2023-08-29 00:00:00');
|
| | | INSERT INTO `storage_task` VALUES (2, 1, 1, 7, 99, '2023-09-07 16:53:35', '2023-08-29 00:00:00');
|
| | | INSERT INTO `storage_task` VALUES (3, 2, 0, 26, 105, '2023-09-05 16:24:30', '2023-08-29 00:00:00');
|
| | |
|
| | | -- ----------------------------
|
| | | -- Table structure for user
|
| | | -- ----------------------------
|
| | | DROP TABLE IF EXISTS `user`;
|
| | |
| | | `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
|
| | | `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
|
| | | PRIMARY KEY (`id`) USING BTREE
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
|
| | |
|
| | | -- ----------------------------
|
| | | -- Records of user
|
| | |
| | | INSERT INTO `user` VALUES (1, 0, '', 0, 1, 'admin', 'b2f0c414a5ffb6944c424bc18ae3a8a0', NULL, NULL, NULL, 1, '2023-08-25 08:58:58', '2023-09-05 16:12:28');
|
| | | INSERT INTO `user` VALUES (2, 1, '1-', 1, 2, 'user1', '601b99523f82de29f87771d5f95accdc', 'user1@qq.com', NULL, NULL, 1, '2021-11-28 14:31:39', '2021-11-28 15:09:36');
|
| | | INSERT INTO `user` VALUES (3, 1, '1-', 1, 2, 'user2', 'f403c87893db29eb71b21905b57bbd0d', 'user2@qq.com', NULL, NULL, 1, '2021-11-28 14:31:39', '2021-11-28 15:09:36');
|
| | | INSERT INTO `user` VALUES (8, 1, '1-', 1, 5, 'yyyyy', 'fca7e8e6b2fca165de912bd617c8df3c', '2265557248@qq.com', NULL, NULL, 1, '2023-08-23 20:08:44', '2023-08-23 20:08:44');
|
| | | INSERT INTO `user` VALUES (9, 1, '1-', 1, 1, 'yttttttttttt', 'b2f0c414a5ffb6944c424bc18ae3a8a0', '666@qq.com', NULL, NULL, 1, '2023-08-23 20:35:32', '2023-08-23 20:35:32');
|
| | | INSERT INTO `user` VALUES (10, 1, '1-', 1, 2, '767655555', '500637c0d48b442a3be6d4fce12e0910', NULL, NULL, NULL, 1, '2023-08-23 20:42:58', '2023-08-23 20:42:58');
|
| | | INSERT INTO `user` VALUES (11, 1, '1-', 1, 5, 'uiuyiuy', 'e046c4175152aa3001d2c71c5bc1aee5', '767676767tt@qq.com', NULL, NULL, 1, '2023-08-23 20:43:42', '2023-08-23 20:43:42');
|