|
1 # HeidiSQL Dump |
|
2 # |
|
3 # -------------------------------------------------------- |
|
4 # Host: 4GBD02346 |
|
5 # Database: performance |
|
6 # Server version: 5.1.43-community |
|
7 # Server OS: Win32 |
|
8 # Target compatibility: ANSI SQL |
|
9 # HeidiSQL version: 4.0 |
|
10 # Date/time: 2/16/2010 7:15:11 PM |
|
11 # -------------------------------------------------------- |
|
12 |
|
13 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/ |
|
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/ |
|
15 |
|
16 |
|
17 # |
|
18 # Database structure for database 'performance' |
|
19 # |
|
20 |
|
21 CREATE DATABASE /*!32312 IF NOT EXISTS*/ "performance" /*!40100 DEFAULT CHARACTER SET ascii */; |
|
22 |
|
23 USE "performance"; |
|
24 |
|
25 |
|
26 # |
|
27 # Table structure for table 'jobsessionmap' |
|
28 # |
|
29 |
|
30 CREATE TABLE /*!32312 IF NOT EXISTS*/ "jobsessionmap" ( |
|
31 "iterator" int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
32 "jobid" int(10) unsigned NOT NULL, |
|
33 "sessionid" bigint(20) unsigned NOT NULL, |
|
34 PRIMARY KEY ("iterator"), |
|
35 UNIQUE KEY "iterator" ("iterator") |
|
36 ) AUTO_INCREMENT=6 COMMENT='Maps session identifiers to job identifiers'; |
|
37 |
|
38 |
|
39 |
|
40 # |
|
41 # Table structure for table 'testresultstable' |
|
42 # |
|
43 |
|
44 CREATE TABLE /*!32312 IF NOT EXISTS*/ "testresultstable" ( |
|
45 "iterator" int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Allows easy reference and ordering of data inserted. Autogenerated number during insertion.', |
|
46 "sessionid" bigint(20) unsigned NOT NULL COMMENT 'Random value, unique per test execution framework instance. First million reserved for compaction.', |
|
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.', |
|
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.', |
|
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.', |
|
50 "testresultvalue" double unsigned NOT NULL COMMENT 'Numerical result value in the units specified in testunits', |
|
51 PRIMARY KEY ("iterator") |
|
52 ) AUTO_INCREMENT=27 COMMENT='Raw test results from graphics package performance tests.'; |
|
53 |
|
54 /*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/ |
|
55 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/ |