PC World 1998 October/PCWorld_1998-10_cd.bin/software/prehled/komix/DATA.Z/proj_create.dbt

Text File | 1997-06-27 | 13KB | 563 lines

# Template @(#)proj_create.dbt    /main/titanic/6 11 Jun 1997
# Copyright 1995 Westmount Technology
#
~[invoke db_util];
~[invoke db_types];

# Can't use ddl commands within transaction.  This script is always
# invoked from within a transaction, so commit current transaction.
#
commit tran;

~[invoke common_create];

create ~[table cell] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_diagram    ~[varchar 64],
    c_type        ~[varchar 20],
    c_row        ~[varchar 64],
    c_previous    ~[varchar 64],
    c_next        ~[varchar 64],
    c_width        ~[float]
);

create ~[table cnfphlinkl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table cnfphlink] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_configv    ~[varchar 64],
    c_phase        ~[varchar 64],
    c_phasev    ~[varchar 64],
    c_status    ~[smallint]
);

create ~[table compitr] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_diagram    ~[varchar 64],
    c_label        ~[varchar 64],
    c_component    ~[varchar 64],
    c_item        ~[varchar 64],
    c_qualref    ~[varchar 64],
    c_namebegin    ~[integer],
    c_namelen    ~[integer],
    c_scope        ~[smallint],
    c_itype        ~[varchar 20],
    c_qual        ~[varchar 64],
    c_labeltype    ~[varchar 20 1],
    c_comptype    ~[varchar 20 1],
    c_itemtype    ~[varchar 20 1]
);

create ~[table configl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table configvl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table configv] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_customfvlinkl ~[varchar 64],
    c_object    ~[varchar 64],
    c_basev        ~[varchar 64],
    c_versionnr    ~[varchar 20],
    c_status    ~[smallint],
    c_comments    ~[varchar 255],
    c_creator    ~[varchar 80],
    c_updator    ~[varchar 80],
    c_createtime    ~[integer],
    c_updatetime    ~[integer],
    c_freezetime    ~[integer],
    c_phasevlinkl    ~[varchar 64]
);

create ~[table config] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_customfl    ~[varchar 64],
    c_project    ~[varchar 64],
    c_name        ~[varchar 80],
    c_versionl    ~[varchar 64]
);

create ~[table conn] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_diagram    ~[varchar 64],
    c_type        ~[varchar 20],
    c_from        ~[varchar 64],
    c_to        ~[varchar 64],
    c_width        ~[float],
    c_endx        ~[float],
    c_endy        ~[float]
);

create ~[table cono] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_diagram    ~[varchar 64],
    c_type        ~[varchar 20],
    c_from        ~[varchar 64],
    c_x        ~[float],
    c_y        ~[float],
    c_sizex        ~[float],
    c_sizey        ~[float]
);

create ~[table extlinkl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table extlink] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_name        ~[varchar 80],
    c_type        ~[varchar 20],
    c_systemv    ~[varchar 64],
    c_path        ~[varchar 255]
);

create ~[table filel] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table filevl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table filev] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_object    ~[varchar 64],
    c_basev        ~[varchar 64],
    c_versionnr    ~[varchar 20],
    c_status    ~[smallint],
    c_comments    ~[varchar 255],
    c_creator    ~[varchar 80],
    c_updator    ~[varchar 80],
    c_createtime    ~[integer],
    c_updatetime    ~[integer],
    c_freezetime    ~[integer],
    c_config    ~[varchar 64],
    c_incorporate    ~[smallint] null,
    c_iscope    ~[smallint]
);

create ~[table file] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_system    ~[varchar 64],
    c_item        ~[varchar 64],
    c_type        ~[varchar 20],
    c_class        ~[smallint],
    c_versionl    ~[varchar 64],
    c_iscope    ~[smallint]
);

create ~[table groupl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table groupvl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table groupv] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_object    ~[varchar 64],
    c_basev        ~[varchar 64],
    c_versionnr    ~[varchar 20],
    c_status    ~[smallint],
    c_comments    ~[varchar 255],
    c_creator    ~[varchar 80],
    c_updator    ~[varchar 80],
    c_createtime    ~[integer],
    c_updatetime    ~[integer],
    c_freezetime    ~[integer],
    c_config    ~[varchar 64]
);

create ~[table group] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_system    ~[varchar 64],
    c_name        ~[varchar 80],
    c_versionl    ~[varchar 64],
    c_svdgrp    ~[varchar 64]
);

create ~[table grpfilink] (
    c_id        ~[varchar 64]    primary key,
    c_groupv    ~[varchar 64],
    c_file        ~[varchar 64]
);

create ~[table grpfilter] (
    c_id        ~[varchar 64]    primary key,
    c_groupv    ~[varchar 64],
    c_fltrtype    ~[smallint],
    c_namepat    ~[varchar 80 1],
    c_typepat    ~[varchar 80 1],
    c_propname    ~[varchar 80 1],
    c_proppat    ~[varchar 80 1]
);

create ~[table grpfisel] (
    c_id        ~[varchar 64]    primary key,
    c_groupv    ~[varchar 64],
    c_itemtype    ~[varchar 20],
    c_decompflags    ~[smallint],
    ~[literal c_filetypes]
);

create ~[table grpgrlink] (
    c_id        ~[varchar 64]    primary key,
    c_groupv    ~[varchar 64],
    c_subgroup    ~[varchar 64]
);

create ~[table grpitsel] (
    c_id        ~[varchar 64]    primary key,
    c_groupv    ~[varchar 64],
    c_filetype    ~[varchar 20],
    c_itemtype    ~[varchar 20],
    c_qualified    ~[smallint]
);

create ~[table item] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_name        ~[varchar 80],
    c_type        ~[varchar 20],
    c_qualifier    ~[varchar 64],
    c_project    ~[varchar 64],
    c_aliased    ~[varchar 64]
);

create ~[table label] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_diagram    ~[varchar 64],
    c_component    ~[varchar 64],
    c_type        ~[varchar 20],
    ~[literal c_value]
);

create ~[table mergelink] (
    c_id        ~[varchar 64]    primary key,
    c_fromv        ~[varchar 64],
    c_tov        ~[varchar 64],
    c_creator    ~[varchar 80],
    c_createtime    ~[integer],
    c_comments    ~[varchar 255]
);

create ~[table node] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_diagram    ~[varchar 64],
    c_type        ~[varchar 20],
    c_x        ~[float],
    c_y        ~[float],
    c_sizex        ~[float],
    c_sizey        ~[float]
);

create ~[table phasel] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table phasevl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table phasev] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_customfvlinkl ~[varchar 64],
    c_object    ~[varchar 64],
    c_basev        ~[varchar 64],
    c_versionnr    ~[varchar 20],
    c_status    ~[smallint],
    c_comments    ~[varchar 255],
    c_creator    ~[varchar 80],
    c_updator    ~[varchar 80],
    c_createtime    ~[integer],
    c_updatetime    ~[integer],
    c_freezetime    ~[integer],
    c_config    ~[varchar 64],
    c_systemvlinkl    ~[varchar 64]
);

create ~[table phase] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_customfl    ~[varchar 64],
    c_project    ~[varchar 64],
    c_name        ~[varchar 80],
        c_type          ~[varchar 20],
    c_previous    ~[varchar 64],
    c_next        ~[varchar 64],
    c_versionl    ~[varchar 64],
    c_systeml    ~[varchar 64]
);

create ~[table phsyslinkl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table phsyslink] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_phasev    ~[varchar 64],
    c_system    ~[varchar 64],
    c_systemv    ~[varchar 64],
    c_status    ~[smallint]
);

create ~[table row] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_diagram    ~[varchar 64],
    c_type        ~[varchar 20],
    c_previous    ~[varchar 64],
    c_next        ~[varchar 64],
    c_height    ~[float]
);

create ~[table segment] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_diagram    ~[varchar 64],
    c_type        ~[varchar 20],
    c_connector    ~[varchar 64],
    c_previous    ~[varchar 64],
    c_next        ~[varchar 64],
    c_startx    ~[float],
    c_starty    ~[float]
);

create ~[table sgrfilink] (
    c_id        ~[varchar 64]    primary key,
    c_svdgrpv    ~[varchar 64],
    c_filev        ~[varchar 64]
);

create ~[table svdgrpv] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_object    ~[varchar 64],
    c_versionnr    ~[integer],
    c_comments    ~[varchar 255],
    c_creator    ~[varchar 80],
    c_createtime    ~[integer],
    c_crpgrpv    ~[varchar 64 1]
);

create ~[table svdgrp] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_system    ~[varchar 64],
    c_name        ~[varchar 80],
    c_group        ~[varchar 64],
    c_crpgrp    ~[varchar 64 1]
);

create ~[table syscplinkl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table syscplink] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_systemv    ~[varchar 64],
    c_crpgrpv    ~[varchar 64]
);

create ~[table sysfilinkl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table sysfilink] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_systemv    ~[varchar 64],
    c_file        ~[varchar 64],
    c_filev        ~[varchar 64],
    c_status    ~[smallint]
);

create ~[table sysfirefl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table sysfiref] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_name        ~[varchar 80],
    c_type        ~[varchar 20],
    c_systemv    ~[varchar 64],
    c_status    ~[smallint],
    c_configv    ~[varchar 64],
    c_reffile    ~[varchar 64],
    c_reffilev    ~[varchar 64 1]
);

create ~[table sysgrlinkl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table sysgrlink] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_systemv    ~[varchar 64],
    c_group        ~[varchar 64],
    c_groupv    ~[varchar 64],
    c_status    ~[smallint]
);

create ~[table systeml] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table systemvl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table systemv] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_customfvlinkl ~[varchar 64],
    c_object    ~[varchar 64],
    c_basev        ~[varchar 64],
    c_versionnr    ~[varchar 20],
    c_status    ~[smallint],
    c_comments    ~[varchar 255],
    c_creator    ~[varchar 80],
    c_updator    ~[varchar 80],
    c_createtime    ~[integer],
    c_updatetime    ~[integer],
    c_freezetime    ~[integer],
    c_config    ~[varchar 64],
    c_sysfilinkl    ~[varchar 64],
    c_sysfirefl    ~[varchar 64],
    c_extlinkl    ~[varchar 64],
    c_sysgrlinkl    ~[varchar 64],
    c_syscplinkl    ~[varchar 64],
    c_proprefl    ~[varchar 64],
    c_iscope    ~[smallint]
);

create ~[table system] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_customfl    ~[varchar 64],
    c_phase        ~[varchar 64],
    c_item        ~[varchar 64],
    c_type        ~[varchar 20],
    c_versionl    ~[varchar 64],
    c_filel        ~[varchar 64],
    c_groupl    ~[varchar 64],
    c_iscope    ~[smallint]
);

create ~[table wrkitem] (
    c_id        ~[varchar 64]    primary key nonclustered,
    c_owner        ~[varchar 64],
    c_item        ~[varchar 64],
    c_scope        ~[smallint],
    c_reused    ~[smallint],
    c_createtime    ~[integer],
    c_updatetime    ~[integer]
);

create ~[table proprefl] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_owner        ~[varchar 64],
    c_hasncacl    ~[smallint]
);

create ~[table fipropref] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_name        ~[varchar 80],
    c_type        ~[varchar 20],
    c_systemv    ~[varchar 64],
    c_status    ~[smallint],
    c_reffile    ~[varchar 64],
    c_reffilev    ~[varchar 64]
);

create ~[table itpropref] (
    c_id        ~[varchar 64]    primary key,
    c_hasacl    ~[smallint],
    c_name        ~[varchar 80],
    c_type        ~[varchar 20],
    c_systemv    ~[varchar 64],
    c_proprefst    ~[varchar 64],
    c_status    ~[smallint],
    c_refobject    ~[varchar 64],
    c_refitem    ~[varchar 64]
);

create ~[table proprefst] (
    c_id        ~[varchar 64]    primary key,
    c_propref    ~[varchar 64]
);


begin tran;

~[invoke proj_createind];