if exists (select * from sysobjects where id = object_id(N'[dbo].[q_implements]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[q_implements]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_attribute]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_attribute]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_attributeconstraints]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_attributeconstraints]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_attributetag]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_attributetag]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_authors]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_cardinality]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_cardinality]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_category]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_category]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_clients]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_clients]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_complexitytypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_complexitytypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_connector]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_connector]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_connectorconstraint]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_connectorconstraint]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_connectortag]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_connectortag]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_connectortypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_connectortypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_constants]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_constants]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_constrainttypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_constrainttypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_datatypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_datatypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_diagram]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_diagram]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_diagramlinks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_diagramlinks]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_diagramobjects]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_diagramobjects]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_diagramtypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_diagramtypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_document]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_document]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_ecf]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_ecf]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_efforttypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_efforttypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_files]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_files]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_genopt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_genopt]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_glossary]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_glossary]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_html]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_html]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_image]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_image]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_implement]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_implement]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_issues]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_issues]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_lists]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_lists]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_mainttypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_mainttypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_method]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_method]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_metrictypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_metrictypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_object]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_object]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectconstraint]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectconstraint]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objecteffort]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objecteffort]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectfiles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectfiles]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectmetrics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectmetrics]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectproblems]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectproblems]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectproperties]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectproperties]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectrequires]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectrequires]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectresource]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectresource]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectrisks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectrisks]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objectscenarios]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objectscenarios]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objecttests]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objecttests]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objecttrx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objecttrx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_objecttypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_objecttypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_ocf]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_ocf]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_operation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_operation]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_operationparams]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_operationparams]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_operationposts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_operationposts]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_operationpres]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_operationpres]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_operationtag]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_operationtag]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_package]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_package]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_palette]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_palette]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_paletteitem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_paletteitem]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_phase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_phase]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_primitives]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_primitives]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_problemtypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_problemtypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_projectroles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_projectroles]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_propertytypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_propertytypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_requiretypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_requiretypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_resources]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_resources]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_risktypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_risktypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_roleconstraint]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_roleconstraint]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_rtf]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_rtf]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_rtfreport]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_rtfreport]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_rules]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_rules]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_scenariotypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_scenariotypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_script]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_script]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_secgroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_secgroup]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_secgrouppermission]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_secgrouppermission]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_seclocks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_seclocks]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_secpermission]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_secpermission]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_secpolicies]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_secpolicies]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_secuser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_secuser]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_secusergroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_secusergroup]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_secuserpermission]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_secuserpermission]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_snapshot]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_snapshot]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_statustypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_statustypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_stereotypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_stereotypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_taggedvalue]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_taggedvalue]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_tasks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_tasks]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_tcf]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_tcf]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_template]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_template]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_testclass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_testclass]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_testplans]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_testplans]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_testtypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_testtypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_trxtypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_trxtypes]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_umlpattern]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_umlpattern]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_version]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_version]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_xref]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_xref]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_xrefsystem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_xrefsystem]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[t_xrefuser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_xrefuser]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[usys_system]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[usys_system]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[usysOldTables]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[usysOldTables]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[usysQueries]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[usysQueries]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[usysTables]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[usysTables]
GO

CREATE TABLE [dbo].[t_attribute] (
	[Object_ID] [int] NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Scope] [nvarchar] (50) NULL ,
	[Stereotype] [nvarchar] (50) NULL ,
	[Containment] [nvarchar] (50) NULL ,
	[IsStatic] [int] NULL ,
	[IsCollection] [int] NULL ,
	[IsOrdered] [int] NULL ,
	[AllowDuplicates] [int] NULL ,
	[LowerBound] [nvarchar] (50) NULL ,
	[UpperBound] [nvarchar] (50) NULL ,
	[Container] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL ,
	[Derived] [nvarchar] (1) NULL ,
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Pos] [int] NULL ,
	[GenOption] [ntext] NULL ,
	[Length] [int] NULL ,
	[Precision] [int] NULL ,
	[Scale] [int] NULL ,
	[Const] [int] NULL ,
	[Style] [nvarchar] (255) NULL ,
	[Classifier] [nvarchar] (50) NULL ,
	[Default] [ntext] NULL ,
	[Type] [nvarchar] (255) NULL ,
	[ea_guid] [nvarchar] (50) NULL ,
	[StyleEx] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_attributeconstraints] (
	[Object_ID] [int] NULL ,
	[Constraint] [nvarchar] (255) NOT NULL ,
	[AttName] [nvarchar] (255) NULL ,
	[Type] [nvarchar] (255) NULL ,
	[Notes] [ntext] NULL ,
	[ID] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_attributetag] (
	[PropertyID] [int] IDENTITY (1, 1) NOT NULL ,
	[ElementID] [int] NULL ,
	[Property] [nvarchar] (255) NULL ,
	[VALUE] [nvarchar] (255) NULL ,
	[NOTES] [ntext] NULL ,
	[ea_guid] [nvarchar] (40) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_authors] (
	[AuthorName] [nvarchar] (255) NOT NULL ,
	[Roles] [nvarchar] (255) NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_cardinality] (
	[Cardinality] [nvarchar] (50) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_category] (
	[CategoryID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Type] [nvarchar] (255) NULL ,
	[NOTES] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_clients] (
	[Name] [nvarchar] (255) NOT NULL ,
	[Organisation] [nvarchar] (255) NULL ,
	[Phone1] [nvarchar] (50) NULL ,
	[Phone2] [nvarchar] (50) NULL ,
	[Mobile] [nvarchar] (50) NULL ,
	[Fax] [nvarchar] (50) NULL ,
	[Email] [nvarchar] (50) NULL ,
	[Roles] [nvarchar] (255) NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_complexitytypes] (
	[Complexity] [nvarchar] (50) NOT NULL ,
	[NumericWeight] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_connector] (
	[Connector_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Direction] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL ,
	[Connector_Type] [nvarchar] (50) NULL ,
	[SubType] [nvarchar] (50) NULL ,
	[SourceCard] [nvarchar] (50) NULL ,
	[SourceAccess] [nvarchar] (50) NULL ,
	[SourceElement] [nvarchar] (50) NULL ,
	[DestCard] [nvarchar] (50) NULL ,
	[DestAccess] [nvarchar] (50) NULL ,
	[DestElement] [nvarchar] (50) NULL ,
	[SourceRole] [nvarchar] (50) NULL ,
	[SourceRoleType] [nvarchar] (50) NULL ,
	[SourceRoleNote] [ntext] NULL ,
	[SourceContainment] [nvarchar] (50) NULL ,
	[SourceIsAggregate] [int] NULL ,
	[SourceIsOrdered] [int] NULL ,
	[SourceQualifier] [nvarchar] (50) NULL ,
	[DestRole] [nvarchar] (50) NULL ,
	[DestRoleType] [nvarchar] (50) NULL ,
	[DestRoleNote] [ntext] NULL ,
	[DestContainment] [nvarchar] (50) NULL ,
	[DestIsAggregate] [int] NULL ,
	[DestIsOrdered] [int] NULL ,
	[DestQualifier] [nvarchar] (50) NULL ,
	[Start_Object_ID] [int] NULL ,
	[End_Object_ID] [int] NULL ,
	[Top_Start_Label] [nvarchar] (50) NULL ,
	[Top_Mid_Label] [nvarchar] (50) NULL ,
	[Top_End_Label] [nvarchar] (50) NULL ,
	[Btm_Start_Label] [nvarchar] (50) NULL ,
	[Btm_Mid_Label] [nvarchar] (50) NULL ,
	[Btm_End_Label] [nvarchar] (50) NULL ,
	[Start_Edge] [int] NULL ,
	[End_Edge] [int] NULL ,
	[PtStartX] [int] NULL ,
	[PtStartY] [int] NULL ,
	[PtEndX] [int] NULL ,
	[PtEndY] [int] NULL ,
	[SeqNo] [int] NULL ,
	[HeadStyle] [int] NULL ,
	[LineStyle] [int] NULL ,
	[RouteStyle] [int] NULL ,
	[IsBold] [int] NULL ,
	[LineColor] [int] NULL ,
	[Stereotype] [nvarchar] (50) NULL ,
	[VirtualInheritance] [nvarchar] (1) NULL ,
	[LinkAccess] [nvarchar] (50) NULL ,
	[PDATA1] [ntext] NULL ,
	[PDATA2] [ntext] NULL ,
	[PDATA3] [ntext] NULL ,
	[PDATA4] [nvarchar] (255) NULL ,
	[PDATA5] [ntext] NULL ,
	[DiagramID] [int] NULL ,
	[ea_guid] [nvarchar] (40) NULL ,
	[SourceConstraint] [nvarchar] (255) NULL ,
	[DestConstraint] [nvarchar] (255) NULL ,
	[SourceIsNavigable] [int] NULL ,
	[DestIsNavigable] [int] NULL ,
	[IsRoot] [int] NULL ,
	[IsLeaf] [int] NULL ,
	[IsSpec] [int] NULL ,
	[SourceChangeable] [nvarchar] (12) NULL ,
	[DestChangeable] [nvarchar] (12) NULL ,
	[SourceTS] [nvarchar] (12) NULL ,
	[DestTS] [nvarchar] (12) NULL ,
	[StateFlags] [ntext] NULL ,
	[ActionFlags] [ntext] NULL ,
	[IsSignal] [int] NULL ,
	[IsStimulus] [int] NULL ,
	[DispatchAction] [text] NULL ,
	[Target2] [int] NULL ,
	[StyleEx] [ntext] NULL ,
	[SourceStereotype] [nvarchar] (255) NULL ,
	[DestStereotype] [nvarchar] (255) NULL ,
	[SourceStyle] [ntext] NULL ,
	[DestStyle] [ntext] NULL ,
	[EventFlags] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_connectorconstraint] (
	[ConnectorID] [int] NOT NULL ,
	[Constraint] [nvarchar] (255) NOT NULL ,
	[ConstraintType] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_connectortag] (
	[PropertyID] [int] IDENTITY (1, 1) NOT NULL ,
	[ElementID] [int] NULL ,
	[Property] [nvarchar] (255) NULL ,
	[VALUE] [nvarchar] (255) NULL ,
	[NOTES] [ntext] NULL ,
	[ea_guid] [nvarchar] (40) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_connectortypes] (
	[Connector_Type] [nvarchar] (50) NOT NULL ,
	[Description] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_constants] (
	[ConstantName] [nvarchar] (50) NOT NULL ,
	[ConstantValue] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_constrainttypes] (
	[Constraint] [nvarchar] (16) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_datatypes] (
	[Type] [nvarchar] (50) NULL ,
	[ProductName] [nvarchar] (50) NULL ,
	[DataType] [nvarchar] (50) NULL ,
	[Size] [int] NULL ,
	[MaxLen] [int] NULL ,
	[MaxPrec] [int] NULL ,
	[MaxScale] [int] NULL ,
	[DefaultLen] [int] NULL ,
	[DefaultPrec] [int] NULL ,
	[DefaultScale] [int] NULL ,
	[User] [int] NULL ,
	[PDATA1] [nvarchar] (255) NULL ,
	[PDATA2] [nvarchar] (255) NULL ,
	[PDATA3] [nvarchar] (255) NULL ,
	[PDATA4] [nvarchar] (255) NULL ,
	[HasLength] [nvarchar] (50) NULL ,
	[GenericType] [nvarchar] (255) NULL ,
	[DatatypeID] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_diagram] (
	[Diagram_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Package_ID] [int] NULL ,
	[ParentID] [int] NULL ,
	[Diagram_Type] [nvarchar] (50) NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Version] [nvarchar] (50) NULL ,
	[Author] [nvarchar] (255) NULL ,
	[ShowDetails] [int] NULL ,
	[Notes] [ntext] NULL ,
	[Stereotype] [nvarchar] (50) NULL ,
	[AttPub] [int] NULL ,
	[AttPri] [int] NULL ,
	[AttPro] [int] NULL ,
	[Orientation] [nvarchar] (1) NULL ,
	[cx] [int] NULL ,
	[cy] [int] NULL ,
	[Scale] [int] NULL ,
	[CreatedDate] [datetime] NULL ,
	[ModifiedDate] [datetime] NULL ,
	[HTMLPath] [nvarchar] (255) NULL ,
	[ShowForeign] [int] NULL ,
	[ShowBorder] [int] NULL ,
	[ShowPackageContents] [int] NULL ,
	[PDATA] [nvarchar] (255) NULL ,
	[Locked] [int] NULL ,
	[ea_guid] [nvarchar] (40) NULL ,
	[TPos] [int] NULL ,
	[Swimlanes] [nvarchar] (255) NULL ,
	[StyleEx] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_diagramlinks] (
	[DiagramID] [int] NULL ,
	[ConnectorID] [int] NULL ,
	[Geometry] [ntext] NULL ,
	[Style] [nvarchar] (255) NULL ,
	[Hidden] [int] NULL ,
	[Path] [nvarchar] (255) NULL ,
	[Instance_ID] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_diagramobjects] (
	[Diagram_ID] [int] NULL ,
	[Object_ID] [int] NULL ,
	[RectTop] [int] NULL ,
	[RectLeft] [int] NULL ,
	[RectRight] [int] NULL ,
	[RectBottom] [int] NULL ,
	[Sequence] [int] NULL ,
	[ObjectStyle] [nvarchar] (255) NULL ,
	[Instance_ID] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_diagramtypes] (
	[Diagram_Type] [nvarchar] (50) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Package_ID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_document] (
	[DocID] [nvarchar] (40) NOT NULL ,
	[DocName] [nvarchar] (100) NOT NULL ,
	[Notes] [nvarchar] (255) NULL ,
	[Style] [nvarchar] (255) NULL ,
	[ElementID] [nvarchar] (40) NOT NULL ,
	[ElementType] [nvarchar] (50) NOT NULL ,
	[StrContent] [ntext] NULL ,
	[BinContent] [image] NULL ,
	[DocType] [nvarchar] (100) NULL ,
	[Author] [nvarchar] (255) NULL ,
	[Version] [nvarchar] (50) NULL ,
	[IsActive] [int] NULL ,
	[Sequence] [int] NULL ,
	[DocDate] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_ecf] (
	[ECFID] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[Weight] [float] NULL ,
	[Value] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_efforttypes] (
	[EffortType] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (255) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_files] (
	[FileID] [nvarchar] (50) NOT NULL ,
	[AppliesTo] [nvarchar] (50) NOT NULL ,
	[Category] [nvarchar] (100) NOT NULL ,
	[Name] [nvarchar] (150) NOT NULL ,
	[File] [nvarchar] (255) NULL ,
	[Notes] [ntext] NULL ,
	[FileDate] [datetime] NULL ,
	[FileSize] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_genopt] (
	[AppliesTo] [nvarchar] (12) NULL ,
	[Option] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_glossary] (
	[Term] [nvarchar] (255) NULL ,
	[Type] [nvarchar] (255) NULL ,
	[Meaning] [ntext] NULL ,
	[GlossaryID] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_html] (
	[Type] [nvarchar] (50) NULL ,
	[Template] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_image] (
	[ImageID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Type] [nvarchar] (255) NULL ,
	[Image] [image] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_implement] (
	[Type] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_issues] (
	[Issue] [nvarchar] (255) NULL ,
	[IssueDate] [datetime] NULL ,
	[Owner] [nvarchar] (255) NULL ,
	[Status] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL ,
	[Resolver] [nvarchar] (255) NULL ,
	[DateResolved] [datetime] NULL ,
	[Resolution] [ntext] NULL ,
	[IssueID] [int] IDENTITY (1, 1) NOT NULL ,
	[Category] [nvarchar] (255) NULL ,
	[Priority] [nvarchar] (100) NULL ,
	[Severity] [nvarchar] (50) NULL ,
	[IssueType] [nvarchar] (100) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_lists] (
	[ListID] [nvarchar] (50) NOT NULL ,
	[Category] [nvarchar] (100) NOT NULL ,
	[Name] [nvarchar] (150) NOT NULL ,
	[NVal] [int] NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_mainttypes] (
	[MaintType] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_method] (
	[Object_ID] [int] NOT NULL ,
	[Name] [nvarchar] (255) NOT NULL ,
	[Scope] [nvarchar] (50) NULL ,
	[Type] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_metrictypes] (
	[Metric] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_object] (
	[Object_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Object_Type] [nvarchar] (255) NULL ,
	[Diagram_ID] [int] NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Alias] [nvarchar] (255) NULL ,
	[Author] [nvarchar] (255) NULL ,
	[Version] [nvarchar] (50) NULL ,
	[Note] [ntext] NULL ,
	[Package_ID] [int] NULL ,
	[Stereotype] [nvarchar] (255) NULL ,
	[NType] [int] NULL ,
	[Complexity] [nvarchar] (50) NULL ,
	[Effort] [int] NULL ,
	[Style] [nvarchar] (255) NULL ,
	[Backcolor] [int] NULL ,
	[BorderStyle] [int] NULL ,
	[BorderWidth] [int] NULL ,
	[Fontcolor] [int] NULL ,
	[Bordercolor] [int] NULL ,
	[CreatedDate] [datetime] NULL ,
	[ModifiedDate] [datetime] NULL ,
	[Status] [nvarchar] (50) NULL ,
	[Abstract] [nvarchar] (1) NULL ,
	[Tagged] [int] NULL ,
	[PDATA1] [varchar] (255) NULL ,
	[PDATA2] [ntext] NULL ,
	[PDATA3] [ntext] NULL ,
	[PDATA4] [ntext] NULL ,
	[PDATA5] [ntext] NULL ,
	[Concurrency] [nvarchar] (50) NULL ,
	[Visibility] [nvarchar] (50) NULL ,
	[Persistence] [nvarchar] (50) NULL ,
	[Cardinality] [nvarchar] (50) NULL ,
	[GenType] [nvarchar] (50) NULL ,
	[GenFile] [nvarchar] (255) NULL ,
	[Header1] [ntext] NULL ,
	[Header2] [ntext] NULL ,
	[Phase] [nvarchar] (50) NULL ,
	[Scope] [nvarchar] (25) NULL ,
	[GenOption] [ntext] NULL ,
	[GenLinks] [ntext] NULL ,
	[Classifier] [int] NULL ,
	[ea_guid] [nvarchar] (40) NULL ,
	[ParentID] [int] NULL ,
	[RunState] [ntext] NULL ,
	[Classifier_guid] [nvarchar] (40) NULL ,
	[TPos] [int] NULL ,
	[IsRoot] [int] NULL ,
	[IsLeaf] [int] NULL ,
	[IsSpec] [int] NULL ,
	[IsActive] [int] NULL ,
	[StateFlags] [ntext] NULL ,
	[PackageFlags] [ntext] NULL ,
	[Multiplicity] [nvarchar] (50) NULL ,
	[StyleEx] [ntext] NULL ,
	[EventFlags] [ntext] NULL ,
	[ActionFlags] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectconstraint] (
	[Object_ID] [int] NOT NULL ,
	[Constraint] [nvarchar] (255) NOT NULL ,
	[ConstraintType] [nvarchar] (30) NOT NULL ,
	[Weight] [float] NULL ,
	[Notes] [ntext] NULL ,
	[Status] [nvarchar] (50) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objecteffort] (
	[Object_ID] [int] NOT NULL ,
	[Effort] [nvarchar] (255) NOT NULL ,
	[EffortType] [nvarchar] (12) NULL ,
	[EValue] [float] NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectfiles] (
	[Object_ID] [int] NOT NULL ,
	[FileName] [nvarchar] (255) NOT NULL ,
	[Type] [nvarchar] (50) NULL ,
	[Note] [ntext] NULL ,
	[FileSize] [nvarchar] (255) NULL ,
	[FileDate] [nvarchar] (255) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectmetrics] (
	[Object_ID] [int] NOT NULL ,
	[Metric] [nvarchar] (255) NOT NULL ,
	[MetricType] [nvarchar] (12) NULL ,
	[EValue] [float] NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectproblems] (
	[Object_ID] [int] NOT NULL ,
	[Problem] [varchar] (255) NOT NULL ,
	[ProblemType] [varchar] (255) NOT NULL ,
	[DateReported] [datetime] NULL ,
	[Status] [nvarchar] (50) NULL ,
	[ProblemNotes] [ntext] NULL ,
	[ReportedBy] [nvarchar] (255) NULL ,
	[ResolvedBy] [nvarchar] (255) NULL ,
	[DateResolved] [datetime] NULL ,
	[Version] [nvarchar] (50) NULL ,
	[ResolverNotes] [ntext] NULL ,
	[Priority] [nvarchar] (100) NULL ,
	[Severity] [nvarchar] (50) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectproperties] (
	[PropertyID] [int] IDENTITY (1, 1) NOT NULL ,
	[Object_ID] [int] NULL ,
	[Property] [nvarchar] (255) NULL ,
	[Value] [nvarchar] (255) NULL ,
	[Notes] [ntext] NULL ,
	[ea_guid] [nvarchar] (40) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectrequires] (
	[ReqID] [int] IDENTITY (1, 1) NOT NULL ,
	[Object_ID] [int] NULL ,
	[Requirement] [nvarchar] (255) NULL ,
	[ReqType] [nvarchar] (255) NULL ,
	[Status] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL ,
	[Stability] [nvarchar] (50) NULL ,
	[Difficulty] [nvarchar] (50) NULL ,
	[Priority] [nvarchar] (50) NULL ,
	[LastUpdate] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectresource] (
	[Object_ID] [int] NOT NULL ,
	[Resource] [varchar] (255) NOT NULL ,
	[Role] [varchar] (255) NOT NULL ,
	[Time] [float] NULL ,
	[Notes] [ntext] NULL ,
	[PercentComplete] [smallint] NULL ,
	[DateStart] [datetime] NULL ,
	[DateEnd] [datetime] NULL ,
	[History] [ntext] NULL ,
	[ExpectedHours] [int] NULL ,
	[ActualHours] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectrisks] (
	[Object_ID] [int] NOT NULL ,
	[Risk] [nvarchar] (255) NOT NULL ,
	[RiskType] [nvarchar] (12) NULL ,
	[EValue] [float] NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objectscenarios] (
	[Object_ID] [int] NOT NULL ,
	[Scenario] [nvarchar] (255) NOT NULL ,
	[ScenarioType] [nvarchar] (12) NULL ,
	[EValue] [float] NULL ,
	[Notes] [ntext] NULL ,
	[XMLContent] [ntext] NULL ,
	[ea_guid] [nvarchar] (40) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objecttests] (
	[Object_ID] [int] NOT NULL ,
	[Test] [nvarchar] (255) NOT NULL ,
	[TestClass] [int] NOT NULL ,
	[TestType] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL ,
	[InputData] [ntext] NULL ,
	[AcceptanceCriteria] [ntext] NULL ,
	[Status] [nvarchar] (32) NULL ,
	[DateRun] [datetime] NULL ,
	[Results] [ntext] NULL ,
	[RunBy] [nvarchar] (255) NULL ,
	[CheckBy] [nvarchar] (255) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objecttrx] (
	[Object_ID] [int] NOT NULL ,
	[TRX] [nvarchar] (255) NOT NULL ,
	[TRXType] [nvarchar] (12) NOT NULL ,
	[Weight] [float] NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_objecttypes] (
	[Object_Type] [nvarchar] (50) NOT NULL ,
	[Description] [nvarchar] (255) NULL ,
	[DesignObject] [int] NOT NULL ,
	[ImageID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_ocf] (
	[ObjectType] [nvarchar] (50) NULL ,
	[ComplexityWeight] [float] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_operation] (
	[OperationID] [int] IDENTITY (1, 1) NOT NULL ,
	[Object_ID] [int] NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Scope] [nvarchar] (50) NULL ,
	[Type] [nvarchar] (255) NULL ,
	[ReturnArray] [nvarchar] (1) NULL ,
	[Stereotype] [nvarchar] (50) NULL ,
	[IsStatic] [nvarchar] (1) NULL ,
	[Concurrency] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL ,
	[Behaviour] [ntext] NULL ,
	[Abstract] [nvarchar] (1) NULL ,
	[GenOption] [ntext] NULL ,
	[Synchronized] [nvarchar] (1) NULL ,
	[Pos] [int] NULL ,
	[Const] [int] NULL ,
	[Style] [nvarchar] (255) NULL ,
	[Pure] [int] NULL ,
	[Throws] [nvarchar] (255) NULL ,
	[Classifier] [nvarchar] (50) NULL ,
	[Code] [ntext] NULL ,
	[IsRoot] [int] NULL ,
	[IsLeaf] [int] NULL ,
	[IsQuery] [int] NULL ,
	[StateFlags] [nvarchar] (255) NULL ,
	[ea_guid] [nvarchar] (50) NULL ,
	[StyleEx] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_operationparams] (
	[OperationID] [int] NOT NULL ,
	[Name] [nvarchar] (255) NOT NULL ,
	[Type] [nvarchar] (255) NULL ,
	[Default] [nvarchar] (255) NULL ,
	[Notes] [ntext] NULL ,
	[Pos] [int] NULL ,
	[Const] [int] NOT NULL ,
	[Style] [nvarchar] (255) NULL ,
	[Kind] [nvarchar] (12) NULL ,
	[Classifier] [nvarchar] (50) NULL ,
	[ea_guid] [nvarchar] (50) NULL ,
	[StyleEx] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_operationposts] (
	[OperationID] [int] NOT NULL ,
	[PostCondition] [nvarchar] (255) NOT NULL ,
	[Type] [nvarchar] (255) NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_operationpres] (
	[OperationID] [int] NOT NULL ,
	[PreCondition] [nvarchar] (255) NOT NULL ,
	[Type] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_operationtag] (
	[PropertyID] [int] IDENTITY (1, 1) NOT NULL ,
	[ElementID] [int] NULL ,
	[Property] [nvarchar] (255) NULL ,
	[VALUE] [nvarchar] (255) NULL ,
	[NOTES] [ntext] NULL ,
	[ea_guid] [nvarchar] (40) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_package] (
	[Package_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Parent_ID] [int] NULL ,
	[CreatedDate] [datetime] NULL ,
	[ModifiedDate] [datetime] NULL ,
	[Notes] [ntext] NULL ,
	[ea_guid] [nvarchar] (40) NULL ,
	[XMLPath] [nvarchar] (255) NULL ,
	[IsControlled] [int] NULL ,
	[LastLoadDate] [datetime] NULL ,
	[LastSaveDate] [datetime] NULL ,
	[Version] [nvarchar] (50) NULL ,
	[Protected] [int] NULL ,
	[PkgOwner] [nvarchar] (255) NULL ,
	[UMLVersion] [nvarchar] (50) NULL ,
	[UseDTD] [int] NULL ,
	[LogXML] [int] NULL ,
	[CodePath] [nvarchar] (255) NULL ,
	[Namespace] [nvarchar] (50) NULL ,
	[TPos] [int] NULL ,
	[PackageFlags] [nvarchar] (255) NULL ,
	[BatchSave] [int] NULL ,
	[BatchLoad] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_palette] (
	[PaletteID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Type] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_paletteitem] (
	[PaletteID] [int] NULL ,
	[ItemID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_phase] (
	[PhaseID] [varchar] (40) NOT NULL ,
	[PhaseName] [varchar] (100) NOT NULL ,
	[PhaseNotes] [ntext] NULL ,
	[PhaseStyle] [varchar] (255) NULL ,
	[StartDate] [datetime] NULL ,
	[EndDate] [datetime] NULL ,
	[PhaseContent] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_primitives] (
	[Datatype] [nvarchar] (50) NOT NULL ,
	[Description] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_problemtypes] (
	[ProblemType] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (255) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_projectroles] (
	[Role] [nvarchar] (255) NOT NULL ,
	[Description] [nvarchar] (255) NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_propertytypes] (
	[Property] [nvarchar] (50) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_requiretypes] (
	[Requirement] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_resources] (
	[Name] [nvarchar] (255) NOT NULL ,
	[Organisation] [nvarchar] (255) NULL ,
	[Phone1] [nvarchar] (50) NULL ,
	[Phone2] [nvarchar] (50) NULL ,
	[Mobile] [nvarchar] (50) NULL ,
	[Fax] [nvarchar] (50) NULL ,
	[Email] [nvarchar] (255) NULL ,
	[Roles] [nvarchar] (255) NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_risktypes] (
	[Risk] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_roleconstraint] (
	[ConnectorID] [int] NOT NULL ,
	[Constraint] [nvarchar] (255) NOT NULL ,
	[ConnectorEnd] [nvarchar] (50) NOT NULL ,
	[ConstraintType] [nvarchar] (12) NOT NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_rtf] (
	[Type] [nvarchar] (50) NULL ,
	[Template] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_rtfreport] (
	[TemplateID] [nvarchar] (200) NOT NULL ,
	[RootPackage] [int] NULL ,
	[Filename] [nvarchar] (255) NULL ,
	[Details] [int] NOT NULL ,
	[ProcessChildren] [int] NOT NULL ,
	[ShowDiagrams] [int] NOT NULL ,
	[Heading] [nvarchar] (255) NULL ,
	[Requirements] [int] NOT NULL ,
	[Associations] [int] NOT NULL ,
	[Scenarios] [int] NOT NULL ,
	[ChildDiagrams] [int] NOT NULL ,
	[Attributes] [int] NOT NULL ,
	[Methods] [int] NOT NULL ,
	[ImageType] [int] NULL ,
	[Paging] [int] NOT NULL ,
	[Intro] [ntext] NULL ,
	[Resources] [int] NOT NULL ,
	[Constraints] [int] NOT NULL ,
	[Tagged] [int] NOT NULL ,
	[ShowTag] [int] NOT NULL ,
	[ShowAlias] [int] NOT NULL ,
	[PDATA1] [nvarchar] (255) NULL ,
	[PDATA2] [nvarchar] (255) NULL ,
	[PDATA3] [nvarchar] (255) NULL ,
	[PDATA4] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_rules] (
	[RuleID] [nvarchar] (50) NOT NULL ,
	[RuleName] [nvarchar] (255) NOT NULL ,
	[RuleType] [nvarchar] (255) NOT NULL ,
	[RuleActive] [int] NULL ,
	[ErrorMsg] [nvarchar] (255) NULL ,
	[Flags] [nvarchar] (255) NULL ,
	[RuleOCL] [ntext] NULL ,
	[RuleXML] [ntext] NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_scenariotypes] (
	[ScenarioType] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_script] (
	[ScriptID] [int] IDENTITY (1, 1) NOT NULL ,
	[ScriptCategory] [nvarchar] (100) NULL ,
	[ScriptName] [nvarchar] (150) NULL ,
	[ScriptAuthor] [nvarchar] (255) NULL ,
	[Notes] [ntext] NULL ,
	[Script] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_secgroup] (
	[GroupID] [nvarchar] (40) NOT NULL ,
	[GroupName] [nvarchar] (32) NOT NULL ,
	[Description] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_secgrouppermission] (
	[GroupID] [nvarchar] (40) NOT NULL ,
	[PermissionID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_seclocks] (
	[UserID] [nvarchar] (40) NOT NULL ,
	[GroupID] [nvarchar] (40) NULL ,
	[EntityType] [nvarchar] (32) NOT NULL ,
	[EntityID] [nvarchar] (40) NOT NULL ,
	[Timestamp] [datetime] NOT NULL ,
	[LockType] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_secpermission] (
	[PermissionID] [int] NOT NULL ,
	[PermissionName] [nvarchar] (50) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_secpolicies] (
	[Property] [nvarchar] (100) NOT NULL ,
	[Value] [nvarchar] (255) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_secuser] (
	[UserID] [nvarchar] (40) NOT NULL ,
	[UserLogin] [nvarchar] (32) NOT NULL ,
	[FirstName] [nvarchar] (50) NOT NULL ,
	[Surname] [nvarchar] (50) NOT NULL ,
	[Department] [nvarchar] (50) NULL ,
	[Password] [nvarchar] (12) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_secusergroup] (
	[UserID] [nvarchar] (40) NOT NULL ,
	[GroupID] [nvarchar] (40) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_secuserpermission] (
	[UserID] [nvarchar] (40) NOT NULL ,
	[PermissionID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_snapshot] (
	[SnapshotID] [nvarchar] (50) NOT NULL ,
	[SeriesID] [nvarchar] (50) NOT NULL ,
	[Position] [int] NOT NULL ,
	[SnapshotName] [nvarchar] (100) NOT NULL ,
	[Notes] [ntext] NULL ,
	[Style] [nvarchar] (100) NULL ,
	[ElementID] [nvarchar] (50) NOT NULL ,
	[ElementType] [nvarchar] (50) NOT NULL ,
	[StrContent] [ntext] NULL ,
	[BinContent1] [image] NULL ,
	[BinContent2] [image] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_statustypes] (
	[Status] [nvarchar] (50) NULL ,
	[Description] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_stereotypes] (
	[Stereotype] [varchar] (255) NOT NULL ,
	[AppliesTo] [varchar] (255) NOT NULL ,
	[Description] [nvarchar] (255) NULL ,
	[MFEnabled] [int] NOT NULL ,
	[MFPath] [nvarchar] (255) NULL ,
	[Metafile] [image] NULL ,
	[Style] [ntext] NULL ,
	[ea_guid] [nvarchar] (50) NULL ,
	[VisualType] [varchar] (100) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_taggedvalue] (
	[PropertyID] [nvarchar] (50) NOT NULL ,
	[ElementID] [nvarchar] (50) NOT NULL ,
	[BaseClass] [nvarchar] (100) NOT NULL ,
	[TagValue] [ntext] NULL ,
	[Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_tasks] (
	[TaskID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[TaskType] [nvarchar] (255) NULL ,
	[NOTES] [ntext] NULL ,
	[Priority] [nvarchar] (255) NULL ,
	[Status] [nvarchar] (255) NULL ,
	[Owner] [nvarchar] (255) NULL ,
	[StartDate] [datetime] NULL ,
	[EndDate] [datetime] NULL ,
	[Phase] [nvarchar] (50) NULL ,
	[History] [ntext] NULL ,
	[Percent] [int] NULL ,
	[TotalTime] [int] NULL ,
	[ActualTime] [int] NULL ,
	[AssignedTo] [nvarchar] (255) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_tcf] (
	[TCFID] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[Weight] [float] NULL ,
	[Value] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_template] (
	[TemplateID] [nvarchar] (40) NOT NULL ,
	[TemplateType] [nvarchar] (50) NOT NULL ,
	[TemplateName] [nvarchar] (100) NOT NULL ,
	[Notes] [nvarchar] (255) NULL ,
	[Style] [nvarchar] (255) NULL ,
	[Template] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_testclass] (
	[TestClass] [nvarchar] (50) NOT NULL ,
	[Description] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_testplans] (
	[PlanID] [nvarchar] (50) NOT NULL ,
	[Category] [nvarchar] (100) NOT NULL ,
	[Name] [nvarchar] (150) NOT NULL ,
	[Author] [nvarchar] (255) NOT NULL ,
	[Notes] [ntext] NULL ,
	[TestPlan] [ntext] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_testtypes] (
	[TestType] [nvarchar] (12) NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_trxtypes] (
	[Description] [nvarchar] (50) NULL ,
	[NumericWeight] [float] NULL ,
	[Notes] [ntext] NULL ,
	[TRX] [nvarchar] (255) NULL ,
	[TRX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Style] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_umlpattern] (
	[PatternID] [int] IDENTITY (1, 1) NOT NULL ,
	[PatternCategory] [nvarchar] (100) NULL ,
	[PatternName] [nvarchar] (150) NULL ,
	[Style] [nvarchar] (250) NULL ,
	[Notes] [ntext] NULL ,
	[PatternXML] [ntext] NULL ,
	[Version] [nvarchar] (50) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_version] (
	[ElementID] [nvarchar] (50) NOT NULL ,
	[VersionID] [nvarchar] (255) NOT NULL ,
	[ElementType] [nvarchar] (100) NULL ,
	[Flags] [nvarchar] (255) NULL ,
	[ExternalFile] [nvarchar] (255) NULL ,
	[Notes] [nvarchar] (255) NULL ,
	[Owner] [nvarchar] (255) NULL ,
	[VersionDate] [datetime] NULL ,
	[Branch] [nvarchar] (255) NULL ,
	[ElementXML] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_xref] (
	[XrefID] [nvarchar] (255) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Type] [nvarchar] (255) NULL ,
	[Visibility] [nvarchar] (255) NULL ,
	[Namespace] [nvarchar] (255) NULL ,
	[Requirement] [nvarchar] (255) NULL ,
	[Constraint] [nvarchar] (255) NULL ,
	[Behavior] [nvarchar] (255) NULL ,
	[Partition] [nvarchar] (255) NULL ,
	[Description] [ntext] NULL ,
	[Client] [nvarchar] (255) NULL ,
	[Supplier] [nvarchar] (255) NULL ,
	[Link] [nvarchar] (255) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_xrefsystem] (
	[XrefID] [nvarchar] (255) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Type] [nvarchar] (255) NULL ,
	[Visibility] [nvarchar] (255) NULL ,
	[Namespace] [nvarchar] (255) NULL ,
	[Requirement] [nvarchar] (255) NULL ,
	[Constraint] [nvarchar] (255) NULL ,
	[Behavior] [nvarchar] (255) NULL ,
	[Partition] [nvarchar] (255) NULL ,
	[Description] [ntext] NULL ,
	[Client] [nvarchar] (255) NULL ,
	[Supplier] [nvarchar] (255) NULL ,
	[Link] [nvarchar] (255) NULL ,
	[ToolID] [nvarchar] (50) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[t_xrefuser] (
	[XrefID] [nvarchar] (255) NOT NULL ,
	[Name] [nvarchar] (255) NULL ,
	[Type] [nvarchar] (255) NULL ,
	[Visibility] [nvarchar] (255) NULL ,
	[Namespace] [nvarchar] (255) NULL ,
	[Requirement] [nvarchar] (255) NULL ,
	[Constraint] [nvarchar] (255) NULL ,
	[Behavior] [nvarchar] (255) NULL ,
	[Partition] [nvarchar] (255) NULL ,
	[Description] [ntext] NULL ,
	[Client] [nvarchar] (255) NULL ,
	[Supplier] [nvarchar] (255) NULL ,
	[Link] [nvarchar] (255) NULL ,
	[ToolID] [nvarchar] (50) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[usys_system] (
	[Property] [nvarchar] (50) NOT NULL ,
	[Value] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[usysOldTables] (
	[TableName] [nvarchar] (50) NULL ,
	[NewName] [nvarchar] (50) NULL ,
	[RelOrder] [int] NULL ,
	[FixCode] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[usysQueries] (
	[QueryName] [nvarchar] (50) NULL ,
	[NewName] [nvarchar] (50) NULL ,
	[FixCode] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[usysTables] (
	[TableName] [nvarchar] (50) NOT NULL ,
	[RelOrder] [int] NULL ,
	[DisplayName] [nvarchar] (50) NULL ,
	[FromVer] [nvarchar] (50) NULL ,
	[ToVer] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO



/****** Object:  View dbo.q_implements    Script Date: 29/09/2002 1:52:46 PM ******/

CREATE VIEW dbo.q_implements
AS
SELECT     TOP 100 PERCENT dbo.t_package.Package_ID, dbo.t_package.Name AS Package, dbo.t_connector.End_Object_ID AS ObjectID, 
                      Object_1.Name AS ObjectName, Object_1.Object_Type AS ObjectType, dbo.t_connector.Connector_Type AS Connector, 
                      dbo.t_object.Object_ID AS ImplementedByID, dbo.t_object.Name AS ImplementorName, dbo.t_object.Object_Type AS ImplementorType, 
                      dbo.t_objecttypes.DesignObject
FROM         dbo.t_objecttypes INNER JOIN
                      dbo.t_object ON dbo.t_objecttypes.Object_Type = dbo.t_object.Object_Type INNER JOIN
                      dbo.t_connector INNER JOIN
                      dbo.t_object Object_1 ON dbo.t_connector.End_Object_ID = Object_1.Object_ID INNER JOIN
                      dbo.t_package ON Object_1.Package_ID = dbo.t_package.Package_ID ON dbo.t_object.Object_ID = dbo.t_connector.Start_Object_ID
WHERE     (dbo.t_connector.Connector_Type = 'Realisation')
ORDER BY dbo.t_package.Package_ID




GO
SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO