-- sequence table
#
CREATE TABLE @sequence@(
   domain @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   currentcount numeric(20,0) @NOT_NULL@,
   primary key (domain)
) @EXT_TABLE_OPTIONS@
#
-- package
#
CREATE TABLE @package@(
   name @VARCHAR_TYPE@(100) @NOT_NULL@,
   version @VARCHAR_TYPE@(10) @NOT_NULL@,
   provider @VARCHAR_TYPE@(100),
   display @VARCHAR_TYPE@(250),
   readonly @BIT_TYPE@ @NOT_NULL@,
   primary key (name)
) @EXT_TABLE_OPTIONS@
#
#
CREATE TABLE @packageRequired@(
   name @VARCHAR_TYPE@(100) @NOT_NULL@,
   nameRequired @VARCHAR_TYPE@(100) @NOT_NULL@,
   versionRequired @VARCHAR_TYPE@(10) @NOT_NULL@,
   primary key(name,nameRequired)
) @EXT_TABLE_OPTIONS@
#
#
CREATE TABLE @cm@(
   id @ID_TYPE@ @NOT_NULL@,
   name @VARCHAR_TYPE@(255) @NOT_NULL@,
   cmmode numeric(3, 0) default 0 @NOT_NULL@,
   primary key (name),
   unique(id)
) @EXT_TABLE_OPTIONS@
#
-- cm access table
#
CREATE TABLE @cmaccess@ (
   cmId @ID_TYPE@ ,
   accessType @VARCHAR_TYPE@(@VCSIZE_ACCESSTYPE@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   accessMode @VARCHAR_TYPE@(@VCSIZE_ACCESSMODE@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   principalGroupId @VARCHAR_TYPE@(@VCSIZE_PRINCGROUP@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   principalId @VARCHAR_TYPE@(@VCSIZE_PRINC@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   FOREIGN KEY (cmId) REFERENCES @cm@(id)
) @EXT_TABLE_OPTIONS@
#
-- cm owner table
#
CREATE TABLE @cmowner@ (
   cmId @ID_TYPE@ ,
   principalGroupId @VARCHAR_TYPE@(@VCSIZE_PRINCGROUP@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   principalId @VARCHAR_TYPE@(@VCSIZE_PRINC@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   FOREIGN KEY (cmId) REFERENCES @cm@(id)
) @EXT_TABLE_OPTIONS@
#
#
create table @principal@(
   id @VARCHAR_TYPE@(@VCSIZE_PRINC@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   aliasid @VARCHAR_TYPE@(255) @NULL@,
   groupId @VARCHAR_TYPE@(@VCSIZE_PRINCGROUP@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   displayName @VARCHAR_TYPE@(255) @NULL@,
   password @VARCHAR_TYPE@(255) @NULL@,
   kind @INDEXABLE_BIT_TYPE@ @NOT_NULL@,
   active @BIT_TYPE@ @NOT_NULL@,
   primary key(id, groupId, kind)
) @EXT_TABLE_OPTIONS@
#
#
create table @userroles@(
   userId @VARCHAR_TYPE@(@VCSIZE_PRINC@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   userGroupId @VARCHAR_TYPE@(@VCSIZE_PRINCGROUP@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   roleId @VARCHAR_TYPE@(@VCSIZE_PRINC@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   roleGroupId @VARCHAR_TYPE@(@VCSIZE_PRINCGROUP@) @VARCHAR_POSTFIX@ @NOT_NULL@
) @EXT_TABLE_OPTIONS@
#
#
create table @events@(
   type numeric(3,0) @NOT_NULL@,
   path @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   eventtimestamp numeric(20,0) @NOT_NULL@
) @EXT_TABLE_OPTIONS@
#
#
create @INDEX_TYPE@ @events@_ind1 on @events@(eventtimestamp)
#
#
create table @privileges@(
   privilege @VARCHAR_TYPE@(@VCSIZE_COMPNAME@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   principalGroupId @VARCHAR_TYPE@(@VCSIZE_PRINCGROUP@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   principalId @VARCHAR_TYPE@(@VCSIZE_PRINC@) @VARCHAR_POSTFIX@ @NOT_NULL@
) @EXT_TABLE_OPTIONS@
#
#
create table @globaldata@(
   name @VARCHAR_TYPE@(@VCSIZE_COMPNAME@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   value @VARCHAR_TYPE@(@VCSIZE_COMPNAME@) @VARCHAR_POSTFIX@ @NOT_NULL@
)
#
#
insert into @globaldata@ values ('db_version', '100')
#
#
create table @archive@(
  id @ID_TYPE@ @NOT_NULL@,
  name @VARCHAR_TYPE@(@VCSIZE_COMPNAME@) @VARCHAR_POSTFIX@ @NOT_NULL@,
  dir @VARCHAR_TYPE@(@VCSIZE_COMPDIR@) @VARCHAR_POSTFIX@ @NOT_NULL@,
  removeInd numeric(1,0) @NOT_NULL@,
  typename @VARCHAR_TYPE@(@VCSIZE_TYPENAME@) @VARCHAR_POSTFIX@ @NULL@,
  lastModified numeric(20,0) @NOT_NULL@,
  modifiedByGroup @VARCHAR_TYPE@(@VCSIZE_PRINCGROUP@) @VARCHAR_POSTFIX@ @NOT_NULL@,
  modifiedById @VARCHAR_TYPE@(@VCSIZE_PRINC@) @VARCHAR_POSTFIX@ @NOT_NULL@,
  cm numeric(@VCSIZE_COMPMAN@,0) @NOT_NULL@,
  binaryLength numeric(10,0) @NULL@,
  binaryValue @BLOB_TYPE@ @NULL@,
  primary key (id)
) @EXT_TABLE_OPTIONS@
#