Testing Framework Tables – PostgreSQL
CREATE TABLE ut_users (
userid character varying(20) NOT NULL,
username character varying(100) NOT NULL,
userpwd character varying(200) NOT NULL,
userrole character varying(20),
userstatus character varying(1),
oldpwd character varying(200),
lastlogingtime date,
rememberme character varying(500),
useremail character varying(100),
CONSTRAINT pk_ut_users PRIMARY KEY (userid )
);
CREATE TABLE ut_module (
modulename character varying(20) NOT NULL,
moduledesc character varying(500),
CONSTRAINT pk_module PRIMARY KEY (modulename )
);
CREATE TABLE ut_usecase (
id integer NOT NULL,
modulename character varying(20),
usecasename character varying(200),
remarks character varying(2000),
modifiedby character varying(20),
modifieddt timestamp without time zone,
CONSTRAINT pk_ut_usecase PRIMARY KEY (id )
);
CREATE TABLE ut_usecase_cls (
ucid integer NOT NULL,
usecasename character varying(200) NOT NULL,
clsname character varying(200) NOT NULL,
modifiedby character varying(20) NOT NULL,
modifieddt timestamp without time zone NOT NULL,
CONSTRAINT pk_ut_cusecase_cls PRIMARY KEY (clsname )
);
CREATE TABLE ut_testcase (
id integer NOT NULL,
ucid integer,
tcstatus character varying(1),
tcname character varying(1000),
tcdesc character varying(8000),
tcjvclassname character varying(200),
tcjvmethod character varying(100),
tccreatedby character varying(20),
tccreationdate date,
lastexecuteddate date,
tcmodifiedby character varying(20),
tcmodifieddate date,
supportfilename character varying(200),
CONSTRAINT pk_ut_testcase PRIMARY KEY (id )
);
create index idx_ut_testcase_ucid on ut_testcase (ucid);
CREATE TABLE ut_testsuitehdr (
id integer NOT NULL,
tsname character varying(100) NOT NULL,
tsdesc character varying(2000),
createdby character varying(20),
createddt timestamp without time zone,
CONSTRAINT pk_ut_testsuitehdr PRIMARY KEY (id )
);
CREATE TABLE ut_testsuitedtl (
suiteid integer NOT NULL,
tcid integer NOT NULL,
executionorder integer,
CONSTRAINT pk_ut_testsuitedtl PRIMARY KEY (suiteid , tcid )
);
CREATE TABLE ut_tcrunhdr (
id integer NOT NULL,
rundate date NOT NULL,
runuser character varying(20) NOT NULL,
rungroupid character varying(100) NOT NULL,
finisheddate timestamp without time zone,
successcnt integer,
failurecnt integer,
remarks character varying(2000),
CONSTRAINT pk_ut_tcrunhdr PRIMARY KEY (id )
);
CREATE TABLE ut_tcrundtl (
id integer NOT NULL,
runhdrid integer NOT NULL,
tcid integer NOT NULL,
tccompstatus character varying(10) NOT NULL,
tcerrordtl character varying(2000),
screenshotflag character varying(1),
testmsg text,
CONSTRAINT pk_ut_tcrundtl PRIMARY KEY (id )
);
CREATE TABLE ut_tcrun_file (
id integer NOT NULL,
rundtlid integer NOT NULL,
filename character varying(200) NOT NULL,
remarks character varying(1000),
CONSTRAINT pk_ut_tcrun_file PRIMARY KEY (id )
);
CREATE TABLE ut_user_testsuite (
userid character varying(20) NOT NULL,
suiteid integer NOT NULL,
createddt timestamp without time zone NOT NULL,
CONSTRAINT pk_ut_user_testsuite PRIMARY KEY (userid , suiteid )
);
CREATE TABLE ut_user_usecase (
userid character varying(20) NOT NULL,
ucid integer NOT NULL,
createddt timestamp without time zone NOT NULL,
CONSTRAINT pk_ut_user_usecase PRIMARY KEY (userid , ucid )
);
SEQUENCES
CREATE SEQUENCE tcrundtl_image_seq ;
CREATE SEQUENCE tcrundtl_seq;
CREATE SEQUENCE tcrunhdr_seq;
CREATE SEQUENCE test_case_seq;
CREATE SEQUENCE testsuite_seq;
CREATE SEQUENCE use_case_seq;
ADMIN USER
insert into ut_users(userid, username, userpwd, userrole, userstatus)
values ('admin', 'admin', 'YWRtaW4=', 'A', 'A');
