create table simple_test_case (
       CASEID integer not null,
       SHORTDESC varchar(255) not null,
       PRIMARY KEY (CASEID),
       UNIQUE (CASEID));

create table case_setup (
       CASEID integer not null,
       SEQUENCE integer not null,
       STEPTEXT varchar(255) not null,
       PRIMARY KEY (CASEID, SEQUENCE),
       FOREIGN KEY (CASEID) REFERENCES simple_test_case);

create table case_result (
       CASEID integer not null,
       SEQUENCE integer not null,
       RESULTTEXT varchar(255) not null,
       PRIMARY KEY (CASEID, SEQUENCE),
       FOREIGN KEY (CASEID) REFERENCES simple_test_case);