-- main table
#
CREATE TABLE @main@(
   id @ID_TYPE@ @NOT_NULL@,
   name @VARCHAR_TYPE@(255) @NOT_NULL@,
   description @VARCHAR_TYPE@(255) @NULL@,
   definition @VARCHAR_TYPE@(@VCSIZE_COMPDIR@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   owner @VARCHAR_TYPE@(@VCSIZE_COMPDIR@) @VARCHAR_POSTFIX@ @NULL@,
   creationtime numeric(19,0) @NOT_NULL@,
   finished @BIT_TYPE@ @NOT_NULL@,
   cm @ID_TYPE@ @NOT_NULL@,
   primary key (id)
) @EXT_TABLE_OPTIONS@
#
-- step
#
CREATE TABLE @step@(
   id @ID_TYPE@ @NOT_NULL@,
   wfid @ID_TYPE@ ,
   wfstepid @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   state numeric(2,0) @NOT_NULL@,
   returnCode @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NULL@,
   tries numeric(2,0) @NOT_NULL@,
   FOREIGN KEY (wfid) REFERENCES @main@(id),
   primary key (id)
) @EXT_TABLE_OPTIONS@
#
-- task
#
CREATE TABLE @task@(
   id @ID_TYPE@ @NOT_NULL@,
   stepid @ID_TYPE@ @NULL@,
   state numeric(2,0) @NOT_NULL@,
   primary key (id)
) @EXT_TABLE_OPTIONS@
#
-- task principal
#
CREATE TABLE @principal@(
   taskid @ID_TYPE@ ,
   principal @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   FOREIGN KEY (taskid) REFERENCES @task@(id),
   primary key (taskid, principal)
) @EXT_TABLE_OPTIONS@
#
-- task history
#
CREATE TABLE @history@(
   taskid @ID_TYPE@ ,
   actor @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   principal @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NULL@,
   state numeric(2,0) @NOT_NULL@,
   action numeric(2,0) @NOT_NULL@,
   changetime numeric(19,0) @NOT_NULL@,
   taskcomment @BLOB_TYPE@ @NULL@,
   FOREIGN KEY (taskid) REFERENCES @task@(id),
   primary key(taskid, changetime)
) @EXT_TABLE_OPTIONS@
#
#
CREATE @INDEX_TYPE@ @task@_stateind ON @task@(state)
#
#
CREATE @INDEX_TYPE@ @step@_stateind ON @step@(state)
#
#
CREATE @INDEX_TYPE@ @principal@_taskidind ON @principal@(taskid)
#