· 7 years ago · Dec 21, 2018, 07:16 PM
1-- ----------------------------
2 -- Table structure for `OMENtmp`
3 -- ----------------------------
4 DROP TABLE IF EXISTS `OMENtmp`;
5 CREATE TABLE `OMENtmp` (
6 `id2` int(11) NOT NULL AUTO_INCREMENT,
7 `id` int(11) NOT NULL DEFAULT '0',
8 `stockplace` varchar(250) CHARACTER SET latin1 DEFAULT NULL,
9 `MCCSIDate` date DEFAULT NULL,
10 PRIMARY KEY (`id2`)
11 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
12
13 -- ----------------------------
14 -- Records of OMENtmp
15 -- ----------------------------
16 INSERT INTO `OMENtmp` VALUES ('1', '1825711', '%', '2018-12-21');
17 INSERT INTO `OMENtmp` VALUES ('2', '1824590', 'HK+TW+AX+KS+T', '2018-12-21');
18 INSERT INTO `OMENtmp` VALUES ('3', '1825710', '%', '2018-12-20');
19 INSERT INTO `OMENtmp` VALUES ('4', '1825136', 'DE+VI+PA+AS+BR+MC+MI+L+VX', '2018-12-20');
20 INSERT INTO `OMENtmp` VALUES ('5', '1824589', 'HK+TW+AX+KS+T', '2018-12-20');
21 INSERT INTO `OMENtmp` VALUES ('6', '1824039', 'US', '2018-12-20');
22 INSERT INTO `OMENtmp` VALUES ('7', '1825709', '%', '2018-12-19');
23 INSERT INTO `OMENtmp` VALUES ('8', '1825135', 'DE+VI+PA+AS+BR+MC+MI+L+VX', '2018-12-19');
24 INSERT INTO `OMENtmp` VALUES ('9', '1824588', 'HK+TW+AX+KS+T', '2018-12-19');
25 INSERT INTO `OMENtmp` VALUES ('10', '1824038', 'US', '2018-12-19');