jtl_to_db_struct.sql

CREATE TABLE tests (
test_id NUMBER NOT NULL,
project VARCHAR(100),
environment VARCHAR(4000),
duration VARCHAR(100),
test_comment VARCHAR(4000),
start_date VARCHAR(100),
accepted VARCHAR(100),
CONSTRAINT test_id_pk PRIMARY KEY (test_id)
);

CREATE TABLE results (
test_id NUMBER NOT NULL,
time_stamp TIMESTAMP DEFAULT NULL,
elapsed NUMBER DEFAULT NULL,
latency NUMBER DEFAULT NULL,
success VARCHAR2(45) DEFAULT NULL,
label VARCHAR2(4000) DEFAULT NULL,
responsecode VARCHAR2(45) DEFAULT NULL,
responsemessage clob DEFAULT NULL,
threadname VARCHAR2(200) DEFAULT NULL,
datatype VARCHAR2(45) DEFAULT NULL,
bytes NUMBER DEFAULT NULL
);

CREATE SEQUENCE test_id_seq
    MINVALUE 1
    MAXVALUE 999999
    START WITH 1
    INCREMENT BY 1
    NOCACHE;