-- type main table
#
CREATE TABLE @typeMain@ (
   id @ID_TYPE@ @NOT_NULL@,
   name @VARCHAR_TYPE@(@VCSIZE_TYPENAME@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   super @VARCHAR_TYPE@(@VCSIZE_TYPENAME@) @VARCHAR_POSTFIX@ @NULL@,
   typeGroup @VARCHAR_TYPE@(@VCSIZE_TYPEGROUP@) @VARCHAR_POSTFIX@ @NULL@,
   classImpl @VARCHAR_TYPE@(@VCSIZE_TYPECLASS@) @VARCHAR_POSTFIX@ @NULL@,
   blueprintpath @VARCHAR_TYPE@(@VCSIZE_COMPPATH@) @VARCHAR_POSTFIX@ @NULL@,
   gui @VARCHAR_TYPE@(@VCSIZE_TYPECLASS@) @VARCHAR_POSTFIX@ @NULL@,
   icon @VARCHAR_TYPE@(@VCSIZE_TYPECLASS@) @VARCHAR_POSTFIX@ @NULL@,
   needsSecureTransfer @BIT_TYPE@ @NOT_NULL@,
   renderer @VARCHAR_TYPE@(128) @NULL@,
   content @VARCHAR_TYPE@(128) @NULL@,
   upgradeFlag numeric(1,0) @NOT_NULL@,
   primary key(name,id),
   unique(id),
   unique(name)
) @EXT_TABLE_OPTIONS@
#

-- type properties
#
CREATE TABLE @typeProps@ (
   typeId @ID_TYPE@ @NOT_NULL@,
   name @VARCHAR_TYPE@(@VCSIZE_PROPNAME@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   propertyType @VARCHAR_TYPE@(@VCSIZE_PROPTYPE@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   stringValue @VARCHAR_TYPE@(@VCSIZE_TYPECLASS@) @VARCHAR_POSTFIX@ @NULL@,
   numericValue numeric(20,6) @NULL@,
   isNumeric @BIT_TYPE@ @NOT_NULL@,
   propertyGroup @VARCHAR_TYPE@(@VCSIZE_PROPGROUP@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   isFinal @BIT_TYPE@ @NOT_NULL@,
   isRequired @BIT_TYPE@ @NOT_NULL@,
   inheritType @BIT_TYPE@ @NOT_NULL@,
   inheritMode @BIT_TYPE@ @NOT_NULL@,
   c_constraints @VARCHAR_TYPE@(@VCSIZE_TYPECLASS@) @VARCHAR_POSTFIX@ @NULL@,
   accessMode @VARCHAR_TYPE@(@VCSIZE_ACCESSMODE@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   FOREIGN KEY (typeId) REFERENCES @typeMain@(id),
   unique (typeId, name)
) @EXT_TABLE_OPTIONS@
#

-- index
#
CREATE @CLUSTERED_INDEX_TYPE@ @typeProps@_ind1 ON @typeProps@(typeId)
#

-- description table (one row per type/blueprint)
#
CREATE TABLE @description@ (
   typeId @ID_TYPE@,
   lang @VARCHAR_TYPE@(10) @NOT_NULL@,
   title @VARCHAR_TYPE@(50) @NULL@,
   description @BLOB_TYPE@ @NULL@,
   help @VARCHAR_TYPE@(255) @NULL@,
   FOREIGN KEY (typeId) REFERENCES @typeMain@(id)
) @EXT_TABLE_OPTIONS@
#