-- relations table
#
CREATE TABLE @relations@   (
   sourcePath @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   sourceCM numeric(@VCSIZE_COMPMAN@,0) @NOT_NULL@,
   targetPath @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   targetDir @VARCHAR_TYPE@(@VCSIZE_COMPDIR@) @VARCHAR_POSTFIX@ @NULL@,
   targetName @VARCHAR_TYPE@(@VCSIZE_COMPNAME@) @VARCHAR_POSTFIX@ @NULL@
) @EXT_TABLE_OPTIONS@
#
#
CREATE @INDEX_TYPE@ @relations@_ind1 ON @relations@(targetPath)
#
#
CREATE @INDEX_TYPE@ @relations@_ind2 ON @relations@(sourcePath, sourceCM)
#