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
|
--
-- Table structure for table 'TESTCPU'
--
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)
) TYPE=MyISAM;
--
-- Table structure for table 'TESTOS'
--
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)
) TYPE=MyISAM;
--
-- Table structure for table 'TESTRESULTS'
--
CREATE TABLE TESTRUN (
TU_ID int(11) NOT NULL auto_increment,
TU_DATE timestamp(14) NOT NULL,
TU_CPU_FK int(11) NOT NULL,
TU_OS_FK int(11) NOT NULL,
TU_VERSION_FK int(11) NOT NULL,
PRIMARY KEY (TU_ID),
KEY TU_IDATE (TU_DATE),
UNIQUE TU_UNIQUE(TU_DATE,TU_CPU_FK,TU_OS_FK,TU_VERSION_FK)
) TYPE=MyISAM;
--
-- Table structure for table 'TESTRESULTS'
--
CREATE TABLE TESTRESULTS (
TR_ID int(11) NOT NULL auto_increment,
TR_TESTRUN_FK int(11) NOT NULL,
TR_TEST_FK int(11),
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),
INDEX I_TRTESTRUN (TR_TESTRUN_FK),
INDEX I_TRTEST (TR_TEST_FK)
) TYPE=MyISAM;
--
-- Table structure for table 'TESTS'
--
CREATE TABLE TESTS (
T_ID int(11) NOT NULL auto_increment,
T_NAME varchar(80) NOT NULL default '',
T_FULLNAME varchar(255) NOT NULL default '',
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 TESTNAME (T_NAME)
) TYPE=MyISAM;
--
-- Table structure for table 'TESTVERSION'
--
CREATE TABLE TESTVERSION (
TV_ID int(11) NOT NULL auto_increment,
TV_VERSION varchar(10) default NULL,
TV_RELEASEDATE timestamp(14) NOT NULL,
PRIMARY KEY (TV_ID),
UNIQUE KEY TR_INAME (TV_VERSION)
) TYPE=MyISAM;
|
