3 # --------------------------------------------------------
5 # Database: performance
6 # Server version: 5.1.43-community
8 # Target compatibility: ANSI SQL
9 # HeidiSQL version: 4.0
10 # Date/time: 2/16/2010 7:15:11 PM
11 # --------------------------------------------------------
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;*/
18 # Database structure for database 'performance'
21 CREATE DATABASE /*!32312 IF NOT EXISTS*/ "performance" /*!40100 DEFAULT CHARACTER SET ascii */;
27 # Table structure for table 'jobsessionmap'
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';
41 # Table structure for table 'testresultstable'
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.';
54 /*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
55 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/