/*
Navicat MySQL Data Transfer

Source Server         : 00-cluster
Source Server Version : 80019
Source Host           : 107.118.212.71:3306
Source Database       : intradb

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

Date: 2020-02-11 14:13:33
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for test_sum
-- ----------------------------
DROP TABLE IF EXISTS `test_sum`;
CREATE TABLE `test_sum` (
  `version` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `plant_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `material_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `material_group` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `over_61_day_qty` double DEFAULT NULL,
  `over_61_day_amount` double DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `year_month` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `forecast_amount` double DEFAULT NULL,
  `forecast_qty` double DEFAULT NULL,
  PRIMARY KEY (`version`,`plant_code`,`material_code`),
  KEY `key_1` (`plant_code`,`material_code`,`version`,`year_month`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of test_sum
-- ----------------------------
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-004609', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '970.17', '546477.25');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-004628', 'C012', 'G', '30350000', '45688.89', '2020-02-10 06:05:35', '202002', '45688.89', '30350000');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-004637', 'C012', 'G', '1914474', '4235.97', '2020-02-10 06:05:35', '202002', '8439.9', '3814474');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-005041', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-007285', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-009706', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-009946', 'C012', 'G', '6400000', '15414.4', '2020-02-10 06:05:35', '202002', '15414.4', '6400000');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-010326', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-010339', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-010375', 'C012', 'G', '19000000', '36417.3', '2020-02-10 06:05:35', '202002', '36417.3', '19000000');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-010808', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-010818', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011043', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '1928.62', '790060');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011102', 'C012', 'G', '528101.95', '1394.77', '2020-02-10 06:05:35', '202002', '1394.77', '528101.95');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011104', 'C012', 'G', '9440', '25', '2020-02-10 06:05:35', '202002', '25.01', '9440');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011224', 'C012', 'G', '175000', '467.48', '2020-02-10 06:05:35', '202002', '467.48', '175000');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011225', 'C012', 'G', '5210000', '13617.9', '2020-02-10 06:05:35', '202002', '13617.9', '5210000');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011255', 'C012', 'G', '850000', '2725.36', '2020-02-10 06:05:35', '202002', '2725.36', '850000');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011425', 'C012', 'G', '1000000', '3109', '2020-02-10 06:05:35', '202002', '3109', '1000000');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011463', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011475', 'C012', 'G', '5956481.4', '11369.14', '2020-02-10 06:05:35', '202002', '11369.13', '5956481.4');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011493', 'C012', 'G', '120990', '339.52', '2020-02-10 06:05:35', '202002', '339.53', '120990');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011494', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011533', 'C012', 'G', '28900000', '77686.09', '2020-02-10 06:05:35', '202002', '77686.09', '28900000');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011580', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011600', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011647', 'C012', 'G', '0', '0', '2020-02-10 06:05:35', '202002', '0', '0');
INSERT INTO `test_sum` VALUES ('20200210', 'P551', '0103-011648', 'C012', 'G', '500000', '1013.55', '2020-02-10 06:05:35', '202002', '1013.55', '500000');