ut_grid.tab

-- 09/2002 PBA initial version

-- Patch72 607131 
-- Create table
create table UT_GRID
(
  PACKAGE        VARCHAR2(100),
  PROGNAME       VARCHAR2(100),
  OVERLOAD       NUMBER,
  TCNAME         VARCHAR2(100),
  MESSAGE        VARCHAR2(2000) not null,
  ARGLIST        VARCHAR2(2000),
  RETURN_VALUE   VARCHAR2(2000),
  ASSERTION_TYPE VARCHAR2(100)
);
-- Add comments to the columns 
comment on column UT_GRID.PACKAGE
  is 'This is the name of the package to be tested.';
comment on column UT_GRID.PROGNAME
  is 'This is the name of the subprogram to be tested.';
comment on column UT_GRID.OVERLOAD
  is 'This is the version of the subprogram where overloaded versions exist. (You may have to look in the data dictionary to work this out).';
comment on column UT_GRID.TCNAME
  is 'The name of the test case.';
comment on column UT_GRID.MESSAGE
  is 'The message to be used in the assertion code.';
comment on column UT_GRID.ARGLIST
  is 'The list of arguments to be passed to the subprogram.';
comment on column UT_GRID.RETURN_VALUE
  is 'The return value to be checked against.';
comment on column UT_GRID.ASSERTION_TYPE
  is 'The type of assertion to be used. Currently this is ignored unless it contains ''EQ'' of ''ISNULL''.';

-- Create/Recreate primary, unique and foreign key constraints 
alter table UT_GRID
  add constraint UK_MESSAGE unique (MESSAGE);

REM  2.1
alter table ut_grid add owner varchar2(30);