tko/create_db

BEGIN TRANSACTION;

-- kernel versions
CREATE TABLE kversions (
kversion INTEGER PRIMARY KEY,
kversion_hash VARCHAR(35),		-- Hash of base + all patches
base VARCHAR(30),			-- Base version without patches
printable VARCHAR(100)			-- Full version with patches
);

-- main jobs table
CREATE TABLE jobs (
job_idx INTEGER PRIMARY KEY,		-- index number
tag VARCHAR(30),			-- job key
machine VARCHAR(20)			-- machine name
);

-- One entry per patch used, anywhere
CREATE TABLE patches (
kversion INTEGER,			-- index number
name VARCHAR(80),			-- short name
url VARCHAR(300),			-- full URL
hash VARCHAR(35)
);

-- test functional results
CREATE TABLE tests (
test_idx INTEGER PRIMARY KEY,		-- index number
job_idx INTEGER,			-- ref to job table
test VARCHAR(30),			-- name of test
subdir VARCHAR(60),			-- subdirectory name
kversion INTEGER,			-- kernel version test was AGAINST
status INTEGER,				-- test status
reason VARCHAR(100)			-- reason for test status
);

-- test functional results
CREATE TABLE test_attributes (
test_idx INTEGER,			-- ref to test table
attribute VARCHAR(30),			-- attribute name (e.g. 'throughput')
value VARCHAR(100)			-- attribute value
);

-- test functional results
CREATE TABLE iteration_result(
test_idx INTEGER,			-- ref to test table
iteration INTEGER,			-- integer
attribute VARCHAR(30),			-- attribute name (e.g. 'throughput')
value FLOAT				-- attribute value (eg 700.1)
);

-- test performance results
CREATE TABLE results (
job_idx INTEGER,			-- ref to job table
test VARCHAR(30),			-- name of test
subdir VARCHAR(60) PRIMARY KEY,		-- subdirectory name
kversion INTEGER			-- kernel version test was AGAINST
);

-- status key
CREATE TABLE status (
status INTEGER PRIMARY KEY,		-- numerical status
description VARCHAR(10)			-- status word
);

COMMIT;