1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
DROP DATABASE IF EXISTS issue_1152;
DROP DATABASE IF EXISTS issue_1152_archive;
CREATE DATABASE issue_1152;
CREATE DATABASE issue_1152_archive;
USE issue_1152;
CREATE TABLE `t` (
`LineTestID` bigint(19) unsigned NOT NULL AUTO_INCREMENT,
`JobCreatedTime` bigint(20) unsigned DEFAULT NULL,
`JobScheduledTime` bigint(20) unsigned DEFAULT NULL,
`JobStartTime` bigint(20) unsigned DEFAULT NULL,
-- `JobFinishTime` bigint(20) unsigned DEFAULT NULL,
-- `Priority` tinyint(3) unsigned DEFAULT NULL,
-- `JobType` tinyint(3) unsigned DEFAULT NULL,
-- `TerminationNumber` varchar(40) NOT NULL,
PRIMARY KEY (`LineTestID`)
-- KEY `index1` (`JobScheduledTime`,`TerminationNumber`)
) ENGINE=InnoDB;
INSERT INTO issue_1152.t VALUES
(null, 1, 2, 3),
(null, 2, 2, 3),
(null, 3, 2, 7),
(null, 4, 2, 3),
(null, 5, 2, 3),
(null, 6, 2, 3),
(null, 7, 2, 3),
(null, 8, 2, 3),
(null, 9, 2, 3),
(null, 10, 2, 3);
USE issue_1152_archive;
CREATE TABLE t (
`JobCreatedTime` bigint(20) unsigned DEFAULT NULL,
`JobScheduledTime` bigint(20) unsigned DEFAULT NULL,
`JobStartTime` bigint(20) unsigned DEFAULT NULL
-- `JobFinishTime` bigint(20) unsigned DEFAULT NULL,
-- `Priority` tinyint(3) unsigned DEFAULT NULL,
-- `JobType` tinyint(3) unsigned DEFAULT NULL,
-- `TerminationNumber` varchar(40) NOT NULL,
-- PRIMARY KEY (`LineTestID`),
-- KEY `index1` (`JobScheduledTime`,`TerminationNumber`)
) ENGINE=InnoDB;
|
