-- Migration cAccess
#
create table @globaldata@(
   name @VARCHAR_TYPE@(@VCSIZE_COMPNAME@) @VARCHAR_POSTFIX@ @NOT_NULL@,
   value @VARCHAR_TYPE@(@VCSIZE_COMPNAME@) @VARCHAR_POSTFIX@ @NOT_NULL@
) @EXT_TABLE_OPTIONS@
#
#
insert into @globaldata@ values ('db_version', '100')
#
#
alter table @cm@ add
  cmmode numeric(3, 0) default 0 not null
#
#
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@
#