blob: 1b7e1ba94bb28444d64e20e46a75a6e1715e4349 [file] [log] [blame]
# This script creates EclipseLink performance tests database.
# MySQL version.
Create table LOADBUILD (
id int not null auto_increment,
lbtimestamp date,
lberrors int,
fatalErrors int,
loginChoice varchar(100),
os varchar(100),
toplink_version varchar(100),
jvm varchar(100),
machine varchar(100),
numberOfTests int,
lbuserName varchar(50),
primary key (id));
Create table RESULT (
id int not null auto_increment,
description varchar(2000),
exception varchar(2000),
name varchar(1000),
outcome varchar(100),
test_time int,
total_time int,
summaryId int,
lbuildId int,
primary key (id));
Create table SUMMARY (
id int not null auto_increment,
description varchar(2000),
setup_failures int,
errors int,
fatalErrors int,
name varchar(1000),
passed int,
problems int,
setupException varchar(2000),
total_time int,
totalTests int,
warnings int,
lbuildId int,
parentId int,
primary key (id));
ALTER TABLE RESULT ADD CONSTRAINT FK_RESULT_summaryId FOREIGN KEY (summaryId) REFERENCES SUMMARY (id);
ALTER TABLE RESULT ADD CONSTRAINT FK_RESULT_lbuildId FOREIGN KEY (lbuildId) REFERENCES LOADBUILD (id);
ALTER TABLE SUMMARY ADD CONSTRAINT FK_LOADBUILD_lbuildId FOREIGN KEY (lbuildId) REFERENCES LOADBUILD (id);
ALTER TABLE SUMMARY ADD CONSTRAINT FK_LOADBUILD_parentId FOREIGN KEY (parentId) REFERENCES SUMMARY (id);
CREATE INDEX IX_LOADBUILD_lbtimestamp ON LOADBUILD (lbtimestamp);
CREATE INDEX IX_LOADBUILD_loginChoice ON LOADBUILD (loginChoice);
CREATE INDEX IX_LOADBUILD_toplink_version ON LOADBUILD (toplink_version);
CREATE INDEX IX_LOADBUILD_machine ON LOADBUILD (machine);
CREATE INDEX IX_LOADBUILD_lbuserName ON LOADBUILD (lbuserName);
CREATE INDEX IX_RESULT_name ON RESULT (name);
CREATE INDEX IX_RESULT_summaryId ON RESULT (summaryId);
CREATE INDEX IX_RESULT_lbuildId ON RESULT (lbuildId);
CREATE INDEX IX_SUMMARY_lbuildId on SUMMARY (lbuildId);
CREATE INDEX IX_SUMMARY_name on SUMMARY (name);
CREATE INDEX IX_SUMMARY_parentId on SUMMARY (parentId);