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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE TESTS (
T_ID int(11) NOT NULL auto_increment,
T_NAME varchar(40) default NULL,
T_CPU varchar(20) default NULL,
T_OS varchar(30) default NULL,
T_VERSION varchar(10) default NULL,
T_ADDDATE date NOT NULL default '0000-00-00',
T_GRAPH char(1) NOT NULL default '-',
T_INTERACTIVE char(1) NOT NULL default '-',
T_RESULT int(11) NOT NULL default '0',
T_FAIL char(1) NOT NULL default '-',
T_RECOMPILE char(1) NOT NULL default '-',
T_NORUN char(1) NOT NULL default '-',
T_NEEDLIBRARY char(1) NOT NULL default '-',
T_KNOWNRUNERROR int(11) NOT NULL default '0',
T_KNOWN char(1) NOT NULL default '-',
T_NOTE varchar(255) default NULL,
T_DESCRIPTION text,
T_SOURCE text,
T_OPTS varchar(255) default NULL,
PRIMARY KEY (T_ID),
UNIQUE KEY T_NAME (T_NAME)
);
CREATE TABLE TESTRESULTS (
TR_ID int(11) NOT NULL auto_increment,
TR_TESTRUN_FK int(11) NOT NULL default '0',
TR_TEST_FK int(11) default NULL,
TR_OK char(1) NOT NULL default '-',
TR_SKIP char(1) NOT NULL default '-',
TR_RESULT int(11) NOT NULL default '0',
TR_LOG text,
PRIMARY KEY (TR_ID),
UNIQUE KEY TR_TESTCOMP (TR_TESTRUN_FK,TR_TEST_FK),
KEY I_TRTESTRUN (TR_TESTRUN_FK),
KEY I_TRTEST (TR_TEST_FK)
);
CREATE TABLE TESTRUN (
TU_ID int(11) NOT NULL auto_increment,
TU_DATE timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
TU_CPU_FK int(11) NOT NULL default '0',
TU_OS_FK int(11) NOT NULL default '0',
TU_VERSION_FK int(11) NOT NULL default '0',
TU_CATEGORY_FK int(11) NOT NULL default '1',
TU_FAILEDTOCOMPILE int(11) NOT NULL default '0',
TU_SUCCESSFULLYFAILED int(11) NOT NULL default '0',
TU_FAILEDTOFAIL int(11) NOT NULL default '0',
TU_SUCCESFULLYCOMPILED int(11) NOT NULL default '0',
TU_FAILEDTORUN int(11) NOT NULL default '0',
TU_KNOWNPROBLEM int(11) NOT NULL default '0',
TU_SUCCESSFULLYRUN int(11) NOT NULL default '0',
TU_SKIPPEDGRAPHTEST int(11) NOT NULL default '0',
TU_SKIPPEDINTERACTIVETEST int(11) NOT NULL default '0',
TU_KNOWNBUG int(11) NOT NULL default '0',
TU_COMPILERVERIONTOOLOW int(11) NOT NULL default '0',
TU_COMPILERVERIONTOOHIGH int(11) NOT NULL default '0',
TU_OTHERCPU int(11) NOT NULL default '0',
TU_OTHERTARGET int(11) NOT NULL default '0',
TU_UNIT int(11) NOT NULL default '0',
TU_SKIPPINGRUNTEST int(11) NOT NULL default '0',
TU_SUBMITTER varchar(128) NOT NULL default '',
TU_MACHINE varchar(128) NOT NULL default '',
TU_COMMENT varchar(255) NOT NULL default '',
PRIMARY KEY (TU_ID),
UNIQUE KEY TU_OVERVIEW (TU_ID,TU_CPU_FK,TU_OS_FK,TU_VERSION_FK,TU_DATE),
KEY TU_IDATE (TU_DATE)
);
CREATE TABLE `TESTCATEGORY` (
TCAT_ID int(11) NOT NULL auto_increment,
TCAT_NAME varchar(20) default NULL,
PRIMARY KEY (`TCAT_ID`),
UNIQUE KEY `TCAT_NAME` (`TCAT_NAME`)
) AUTO_INCREMENT=3 ;
CREATE TABLE TESTOS (
TO_ID int(11) NOT NULL auto_increment,
TO_NAME varchar(10) default NULL,
PRIMARY KEY (`TO_ID`),
UNIQUE KEY `TR_INAME` (`TO_NAME`)
) AUTO_INCREMENT=18 ;
CREATE TABLE TESTVERSION (
TV_ID int(11) NOT NULL auto_increment,
TV_VERSION varchar(10) default NULL,
TV_RELEASEDATE timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (TV_ID),
UNIQUE KEY TR_INAME (TV_VERSION)
) AUTO_INCREMENT=7;
CREATE TABLE TESTCPU (
TC_ID int(11) NOT NULL auto_increment,
TC_NAME varchar(10) default NULL,
PRIMARY KEY (TC_ID),
UNIQUE KEY TC_INAME (TC_NAME)
) AUTO_INCREMENT=10 ;
INSERT INTO TESTCATEGORY VALUES (1, 'Compiler/RTL');
INSERT INTO TESTCATEGORY VALUES (2, 'DB');
INSERT INTO TESTCPU VALUES (1, 'i386');
INSERT INTO TESTCPU VALUES (6, 'arm');
INSERT INTO TESTCPU VALUES (3, 'm68k');
INSERT INTO TESTCPU VALUES (4, 'sparc');
INSERT INTO TESTCPU VALUES (5, 'powerpc');
INSERT INTO TESTCPU VALUES (7, 'x86_64');
INSERT INTO TESTCPU VALUES (8, 'All');
INSERT INTO TESTCPU VALUES (9, 'powerpc64');
INSERT INTO TESTOS VALUES (1, 'linux');
INSERT INTO TESTOS VALUES (2, 'win32');
INSERT INTO TESTOS VALUES (3, 'go32v2');
INSERT INTO TESTOS VALUES (4, 'os2');
INSERT INTO TESTOS VALUES (5, 'freebsd');
INSERT INTO TESTOS VALUES (6, 'netbsd');
INSERT INTO TESTOS VALUES (7, 'openbsd');
INSERT INTO TESTOS VALUES (8, 'amiga');
INSERT INTO TESTOS VALUES (9, 'atari');
INSERT INTO TESTOS VALUES (10, 'qnx');
INSERT INTO TESTOS VALUES (11, 'beos');
INSERT INTO TESTOS VALUES (12, 'solaris');
INSERT INTO TESTOS VALUES (13, 'darwin');
INSERT INTO TESTOS VALUES (14, 'macos');
INSERT INTO TESTOS VALUES (15, 'All');
INSERT INTO TESTOS VALUES (16, 'win64');
INSERT INTO TESTOS VALUES (17, 'wince');
INSERT INTO TESTVERSION VALUES (1, '2.0.4', '2006-08-22 22:38:20');
INSERT INTO TESTVERSION VALUES (2, '2.0.5', '2006-08-22 22:38:20');
INSERT INTO TESTVERSION VALUES (3, '2.3.1', '2007-03-04 23:40:07');
INSERT INTO TESTVERSION VALUES (4, '2.1.2', '2007-03-19 10:49:30');
INSERT INTO TESTVERSION VALUES (5, '2.1.3', '2007-03-19 10:49:47');
INSERT INTO TESTVERSION VALUES (6, '2.1.4', '2007-03-19 10:50:03');
|
