v1.1.2.sql 1.3 KB

1234567891011121314151617181920212223
  1. SET FOREIGN_KEY_CHECKS=0;
  2. CREATE TABLE IF NOT EXISTS `lacew_mi_prod`.`t_machine_calculation` (
  3. `calculation_id` int(11) NOT NULL AUTO_INCREMENT,
  4. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  5. `affair_id` int(11) NOT NULL,
  6. `tagIds` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  7. `calculation_condition` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  8. `call_time` datetime(0) NOT NULL,
  9. `calculation_key` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  10. `calculation_time` datetime(0) NOT NULL ,
  11. `calculation_time2` datetime(0) NOT NULL ,
  12. `product_id` int(11) NOT NULL DEFAULT 0,
  13. `single_weight` decimal(22, 2) NULL DEFAULT 0.00 ,
  14. `pipe_weight` decimal(22, 2) NULL DEFAULT 0.00 ,
  15. `machine_horse` bigint(22) NULL DEFAULT NULL,
  16. `pan_head_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  17. PRIMARY KEY (`calculation_id`, `data_id`) USING BTREE,
  18. INDEX `call_time`(`call_time`) USING BTREE,
  19. INDEX ` calculation_value`(`affair_id`, `calculation_key`, `calculation_condition`, `calculation_time`, `product_id`, `tagIds`, `calculation_time2`) USING BTREE
  20. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  21. SET FOREIGN_KEY_CHECKS=1;