|
sl@0
|
1 |
# HeidiSQL Dump
|
|
sl@0
|
2 |
#
|
|
sl@0
|
3 |
# --------------------------------------------------------
|
|
sl@0
|
4 |
# Host: 4GBD02346
|
|
sl@0
|
5 |
# Database: performance
|
|
sl@0
|
6 |
# Server version: 5.1.43-community
|
|
sl@0
|
7 |
# Server OS: Win32
|
|
sl@0
|
8 |
# Target compatibility: ANSI SQL
|
|
sl@0
|
9 |
# HeidiSQL version: 4.0
|
|
sl@0
|
10 |
# Date/time: 2/16/2010 7:15:11 PM
|
|
sl@0
|
11 |
# --------------------------------------------------------
|
|
sl@0
|
12 |
|
|
sl@0
|
13 |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/
|
|
sl@0
|
14 |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/
|
|
sl@0
|
15 |
|
|
sl@0
|
16 |
|
|
sl@0
|
17 |
#
|
|
sl@0
|
18 |
# Database structure for database 'performance'
|
|
sl@0
|
19 |
#
|
|
sl@0
|
20 |
|
|
sl@0
|
21 |
CREATE DATABASE /*!32312 IF NOT EXISTS*/ "performance" /*!40100 DEFAULT CHARACTER SET ascii */;
|
|
sl@0
|
22 |
|
|
sl@0
|
23 |
USE "performance";
|
|
sl@0
|
24 |
|
|
sl@0
|
25 |
|
|
sl@0
|
26 |
#
|
|
sl@0
|
27 |
# Table structure for table 'jobsessionmap'
|
|
sl@0
|
28 |
#
|
|
sl@0
|
29 |
|
|
sl@0
|
30 |
CREATE TABLE /*!32312 IF NOT EXISTS*/ "jobsessionmap" (
|
|
sl@0
|
31 |
"iterator" int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
sl@0
|
32 |
"jobid" int(10) unsigned NOT NULL,
|
|
sl@0
|
33 |
"sessionid" bigint(20) unsigned NOT NULL,
|
|
sl@0
|
34 |
PRIMARY KEY ("iterator"),
|
|
sl@0
|
35 |
UNIQUE KEY "iterator" ("iterator")
|
|
sl@0
|
36 |
) AUTO_INCREMENT=6 COMMENT='Maps session identifiers to job identifiers';
|
|
sl@0
|
37 |
|
|
sl@0
|
38 |
|
|
sl@0
|
39 |
|
|
sl@0
|
40 |
#
|
|
sl@0
|
41 |
# Table structure for table 'testresultstable'
|
|
sl@0
|
42 |
#
|
|
sl@0
|
43 |
|
|
sl@0
|
44 |
CREATE TABLE /*!32312 IF NOT EXISTS*/ "testresultstable" (
|
|
sl@0
|
45 |
"iterator" int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Allows easy reference and ordering of data inserted. Autogenerated number during insertion.',
|
|
sl@0
|
46 |
"sessionid" bigint(20) unsigned NOT NULL COMMENT 'Random value, unique per test execution framework instance. First million reserved for compaction.',
|
|
sl@0
|
47 |
"testname" text NOT NULL COMMENT 'The testexecute framework test name should be used here to map a test result to the test case source code.',
|
|
sl@0
|
48 |
"testattribute" text NOT NULL COMMENT 'A given performance test may produce several attributes, e.g. framerate value, characters per second value. Each of these is a separate attribute.',
|
|
sl@0
|
49 |
"testunits" text NOT NULL COMMENT 'Numerical results have a unit. For example, this could be fps for frames per second, or MB/s for Megabits per second.',
|
|
sl@0
|
50 |
"testresultvalue" double unsigned NOT NULL COMMENT 'Numerical result value in the units specified in testunits',
|
|
sl@0
|
51 |
PRIMARY KEY ("iterator")
|
|
sl@0
|
52 |
) AUTO_INCREMENT=27 COMMENT='Raw test results from graphics package performance tests.';
|
|
sl@0
|
53 |
|
|
sl@0
|
54 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
|
|
sl@0
|
55 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/
|