home *** CD-ROM | disk | FTP | other *** search
- # Template @(#)common_create.dbt 1.5 26 Apr 1996
- # Copyright 1995 Westmount Technology
- #
-
- #
- # Create tables common to corporate and projects.
- #
- create ~[table controlc] (
- c_id ~[varchar 64] primary key,
- c_hasacl ~[smallint],
- c_classid ~[varchar 80],
- c_name ~[varchar 80],
- c_actions ~[smallint],
- c_level ~[varchar 64]
- );
-
- create ~[table customf] (
- c_id ~[varchar 64] primary key,
- c_hasacl ~[smallint],
- c_level ~[varchar 64],
- c_name ~[varchar 80],
- c_type ~[varchar 20],
- c_versionl ~[varchar 64]
- );
-
- create ~[table customfl] (
- c_id ~[varchar 64] primary key,
- c_hasacl ~[smallint],
- c_owner ~[varchar 64],
- c_hasncacl ~[smallint]
- );
-
- create ~[table customfv] (
- 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 64],
- c_createtime ~[integer],
- c_updatetime ~[integer],
- c_freezetime ~[integer]
- );
-
- create ~[table customfvl] (
- c_id ~[varchar 64] primary key,
- c_hasacl ~[smallint],
- c_owner ~[varchar 64],
- c_hasncacl ~[smallint]
- );
-
- create ~[table lvlcflink] (
- c_id ~[varchar 64] primary key,
- c_hasacl ~[smallint],
- c_levelv ~[varchar 64],
- c_customf ~[varchar 64],
- c_customfv ~[varchar 64]
- );
-
- create ~[table lvlcflinkl] (
- c_id ~[varchar 64] primary key,
- c_hasacl ~[smallint],
- c_owner ~[varchar 64],
- c_hasncacl ~[smallint]
- );
-
- create ~[table propitr] (
- c_id ~[varchar 64] primary key nonclustered,
- c_object ~[varchar 64],
- c_property ~[varchar 64],
- c_item ~[varchar 64],
- c_namebegin ~[integer],
- c_namelen ~[integer],
- c_scope ~[smallint],
- c_itype ~[varchar 20],
- c_qual ~[varchar 64]
- );
-
- create ~[table propval] (
- c_id ~[varchar 64] primary key nonclustered,
- c_diagram ~[varchar 64],
- c_object ~[varchar 64],
- c_name ~[varchar 80],
- ~[literal c_value]
- );
-
- create ~[table roleright] (
- c_id ~[varchar 64] primary key,
- c_object ~[varchar 64],
- c_role ~[varchar 64],
- c_type ~[smallint],
- c_allowed ~[smallint],
- c_prohibited ~[smallint]
- );
-
- create ~[table usrolink] (
- c_id ~[varchar 64] primary key,
- c_user ~[varchar 64],
- c_role ~[varchar 64],
- c_level ~[varchar 64],
- c_linkuse ~[smallint]
- );
-