----------------------------------------------
-- Drop tables
----------------------------------------------
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_attribute') DROP TABLE t_attribute
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_attributeconstraints') DROP TABLE t_attributeconstraints
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_attributetag') DROP TABLE t_attributetag
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_authors') DROP TABLE t_authors
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_cardinality') DROP TABLE t_cardinality
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_category') DROP TABLE t_category
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_clients') DROP TABLE t_clients
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_complexitytypes') DROP TABLE t_complexitytypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_connector') DROP TABLE t_connector
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_connectorconstraint') DROP TABLE t_connectorconstraint
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_connectortag') DROP TABLE t_connectortag
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_connectortypes') DROP TABLE t_connectortypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_constants') DROP TABLE t_constants
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_constrainttypes') DROP TABLE t_constrainttypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_datatypes') DROP TABLE t_datatypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_diagram') DROP TABLE t_diagram
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_diagramlinks') DROP TABLE t_diagramlinks
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_diagramobjects') DROP TABLE t_diagramobjects
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_diagramtypes') DROP TABLE t_diagramtypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_document') DROP TABLE t_document
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_ecf') DROP TABLE t_ecf
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_efforttypes') DROP TABLE t_efforttypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_files') DROP TABLE t_files
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_genopt') DROP TABLE t_genopt
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_glossary') DROP TABLE t_glossary
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_html') DROP TABLE t_html
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_image') DROP TABLE t_image
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_implement') DROP TABLE t_implement
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_issues') DROP TABLE t_issues
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_lists') DROP TABLE t_lists
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_mainttypes') DROP TABLE t_mainttypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_method') DROP TABLE t_method
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_metrictypes') DROP TABLE t_metrictypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_object') DROP TABLE t_object
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectconstraint') DROP TABLE t_objectconstraint
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objecteffort') DROP TABLE t_objecteffort
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectfiles') DROP TABLE t_objectfiles
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectmetrics') DROP TABLE t_objectmetrics
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectproblems') DROP TABLE t_objectproblems
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectproperties') DROP TABLE t_objectproperties
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectrequires') DROP TABLE t_objectrequires
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectresource') DROP TABLE t_objectresource
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectrisks') DROP TABLE t_objectrisks
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objectscenarios') DROP TABLE t_objectscenarios
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objecttests') DROP TABLE t_objecttests
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objecttrx') DROP TABLE t_objecttrx
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_objecttypes') DROP TABLE t_objecttypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_ocf') DROP TABLE t_ocf
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_operation') DROP TABLE t_operation
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_operationparams') DROP TABLE t_operationparams
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_operationposts') DROP TABLE t_operationposts
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_operationpres') DROP TABLE t_operationpres
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_operationtag') DROP TABLE t_operationtag
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_package') DROP TABLE t_package
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_palette') DROP TABLE t_palette
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_paletteitem') DROP TABLE t_paletteitem
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_phase') DROP TABLE t_phase
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_primitives') DROP TABLE t_primitives
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_problemtypes') DROP TABLE t_problemtypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_projectroles') DROP TABLE t_projectroles
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_propertytypes') DROP TABLE t_propertytypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_requiretypes') DROP TABLE t_requiretypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_resources') DROP TABLE t_resources
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_risktypes') DROP TABLE t_risktypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_roleconstraint') DROP TABLE t_roleconstraint
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_rtf') DROP TABLE t_rtf
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_rtfreport') DROP TABLE t_rtfreport
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_rules') DROP TABLE t_rules
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_scenariotypes') DROP TABLE t_scenariotypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_script') DROP TABLE t_script
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_secgroup') DROP TABLE t_secgroup
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_secgrouppermission') DROP TABLE t_secgrouppermission
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_seclocks') DROP TABLE t_seclocks
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_secpermission') DROP TABLE t_secpermission
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_secpolicies') DROP TABLE t_secpolicies
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_secuser') DROP TABLE t_secuser
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_secusergroup') DROP TABLE t_secusergroup
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_secuserpermission') DROP TABLE t_secuserpermission
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_snapshot') DROP TABLE t_snapshot
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_statustypes') DROP TABLE t_statustypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_stereotypes') DROP TABLE t_stereotypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_taggedvalue') DROP TABLE t_taggedvalue
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_tasks') DROP TABLE t_tasks
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_tcf') DROP TABLE t_tcf
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_template') DROP TABLE t_template
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_testclass') DROP TABLE t_testclass
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_testplans') DROP TABLE t_testplans
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_testtypes') DROP TABLE t_testtypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_trxtypes') DROP TABLE t_trxtypes
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_umlpattern') DROP TABLE t_umlpattern
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_version') DROP TABLE t_version
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_xref') DROP TABLE t_xref
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_xrefsystem') DROP TABLE t_xrefsystem
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 't_xrefuser') DROP TABLE t_xrefuser
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'usysOldTables') DROP TABLE usysOldTables
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'usysQueries') DROP TABLE usysQueries
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'usysTables') DROP TABLE usysTables
GO 
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'usys_system') DROP TABLE usys_system
GO 
 
----------------------------------------------
-- Create tables
----------------------------------------------
CREATE TABLE t_attribute (
	Object_ID int NULL DEFAULT 0 ,
	Name varchar (255) NULL ,
	Scope varchar (50) NULL ,
	Stereotype varchar (50) NULL ,
	Containment varchar (50) NULL ,
	IsStatic int NULL DEFAULT 0 ,
	IsCollection int NULL DEFAULT 0 ,
	IsOrdered int NULL DEFAULT 0 ,
	AllowDuplicates int NULL DEFAULT 0 ,
	LowerBound varchar (50) NULL ,
	UpperBound varchar (50) NULL ,
	Container varchar (50) NULL ,
	Notes text NULL ,
	Derived varchar (1) NULL ,
	ID int NOT NULL DEFAULT AUTOINCREMENT ,
	Pos int NULL ,
	GenOption text NULL ,
	Length int NULL ,
	"Precision" int NULL ,
	Scale int NULL ,
	Const int NULL ,
	Style varchar (255) NULL ,
	Classifier varchar (50) NULL ,
	"Default" text NULL ,
	Type varchar (255) NULL ,
	ea_guid varchar (50) NULL ,
	StyleEx text NULL 
) 
GO

CREATE TABLE t_attributeconstraints (
	Object_ID int NULL DEFAULT 0 ,
	"Constraint" varchar (255) NOT NULL ,
	AttName varchar (255) NULL ,
	Type varchar (255) NULL ,
	Notes text NULL ,
	ID int NOT NULL 
) 
GO

CREATE TABLE t_attributetag (
	PropertyID int NOT NULL DEFAULT AUTOINCREMENT ,
	ElementID int NULL ,
	Property varchar (255) NULL ,
	VALUE varchar (255) NULL ,
	NOTES text NULL ,
	ea_guid varchar (40) NULL 
) 
GO

CREATE TABLE t_authors (
	AuthorName varchar (255) NOT NULL ,
	Roles varchar (255) NULL ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_cardinality (
	Cardinality varchar (50) NOT NULL 
)
GO

CREATE TABLE t_category (
	CategoryID int NOT NULL DEFAULT AUTOINCREMENT ,
	Name varchar (255) NULL ,
	Type varchar (255) NULL ,
	NOTES text NULL 
) 
GO

CREATE TABLE t_clients (
	Name varchar (255) NOT NULL ,
	Organisation varchar (255) NULL ,
	Phone1 varchar (50) NULL ,
	Phone2 varchar (50) NULL ,
	Mobile varchar (50) NULL ,
	Fax varchar (50) NULL ,
	Email varchar (50) NULL ,
	Roles varchar (255) NULL ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_complexitytypes (
	Complexity varchar (50) NOT NULL ,
	NumericWeight int NULL DEFAULT 0  
)
GO

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

CREATE TABLE t_connectorconstraint (
	ConnectorID int NOT NULL DEFAULT 0 ,
	"Constraint" varchar (255) NOT NULL ,
	ConstraintType varchar (50) NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_connectortag (
	PropertyID int NOT NULL DEFAULT AUTOINCREMENT ,
	ElementID int NULL ,
	Property varchar (255) NULL ,
	VALUE varchar (255) NULL ,
	NOTES text NULL ,
	ea_guid varchar (40) NULL 
) 
GO

CREATE TABLE t_connectortypes (
	Connector_Type varchar (50) NOT NULL ,
	Description varchar (50) NULL 
)
GO

CREATE TABLE t_constants (
	ConstantName varchar (50) NOT NULL ,
	ConstantValue varchar (255) NULL 
)
GO

CREATE TABLE t_constrainttypes (
	"Constraint" varchar (16) NOT NULL ,
	Description varchar (50) NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_datatypes (
	Type varchar (50) NULL ,
	ProductName varchar (50) NULL ,
	DataType varchar (50) NULL ,
	Size int NULL ,
	MaxLen int NULL ,
	MaxPrec int NULL ,
	MaxScale int NULL DEFAULT 0 ,
	DefaultLen int NULL ,
	DefaultPrec int NULL ,
	DefaultScale int NULL ,
	"User" int NULL ,
	PDATA1 varchar (255) NULL ,
	PDATA2 varchar (255) NULL ,
	PDATA3 varchar (255) NULL ,
	PDATA4 varchar (255) NULL ,
	HasLength varchar (50) NULL ,
	GenericType varchar (255) NULL ,
	DatatypeID int NOT NULL DEFAULT AUTOINCREMENT 
)
GO

CREATE TABLE t_diagram (
	Diagram_ID int NOT NULL DEFAULT AUTOINCREMENT ,
	Package_ID int NULL DEFAULT 1 ,
	ParentID int NULL DEFAULT 0 ,
	Diagram_Type varchar (50) NULL ,
	Name varchar (255) NULL ,
	Version varchar (50) NULL DEFAULT '1.0' ,
	Author varchar (255) NULL ,
	ShowDetails int NULL DEFAULT 0 ,
	Notes text NULL ,
	Stereotype varchar (50) NULL ,
	AttPub int NOT NULL DEFAULT 1 ,
	AttPri int NOT NULL DEFAULT 1 ,
	AttPro int NOT NULL DEFAULT 1 ,
	Orientation varchar (1) NULL DEFAULT 'P' ,
	cx int NULL DEFAULT 0 ,
	cy int NULL DEFAULT 0 ,
	Scale int NULL DEFAULT 100 ,
	CreatedDate datetime NULL DEFAULT getdate() ,
	ModifiedDate datetime NULL DEFAULT getdate() ,
	HTMLPath varchar (255) NULL ,
	ShowForeign int NOT NULL DEFAULT 1 ,
	ShowBorder int NOT NULL DEFAULT 1 ,
	ShowPackageContents int NOT NULL DEFAULT 1 ,
	PDATA varchar (255) NULL ,
	Locked int NOT NULL DEFAULT 0 ,
	ea_guid varchar (40) NULL ,
	TPos int NULL ,
	Swimlanes varchar (255) NULL ,
	StyleEx text NULL 
) 
GO

CREATE TABLE t_diagramlinks (
	DiagramID int NULL ,
	ConnectorID int NULL ,
	Geometry text NULL ,
	Style varchar (255) NULL ,
	Hidden int NOT NULL DEFAULT 0 ,
	Path varchar (255) NULL ,
	Instance_ID int NOT NULL DEFAULT AUTOINCREMENT 
) 
GO

CREATE TABLE t_diagramobjects (
	Diagram_ID int NULL DEFAULT 0 ,
	Object_ID int NULL DEFAULT 0 ,
	RectTop int NULL DEFAULT 0 ,
	RectLeft int NULL DEFAULT 0 ,
	RectRight int NULL DEFAULT 0 ,
	RectBottom int NULL DEFAULT 0 ,
	Sequence int NULL DEFAULT 0 ,
	ObjectStyle varchar (255) NULL ,
	Instance_ID int NOT NULL DEFAULT AUTOINCREMENT 
)
GO

CREATE TABLE t_diagramtypes (
	Diagram_Type varchar (50) NOT NULL ,
	Name varchar (255) NULL ,
	Package_ID int NULL DEFAULT 0 
)
GO

CREATE TABLE t_document (
	DocID varchar (40) NOT NULL ,
	DocName varchar (100) NOT NULL ,
	Notes varchar (255) NULL ,
	Style varchar (255) NULL ,
	ElementID varchar (40) NOT NULL ,
	ElementType varchar (50) NOT NULL ,
	StrContent text NULL ,
	BinContent image NULL ,
	DocType varchar (100) NULL ,
	Author varchar (255) NULL ,
	Version varchar (50) NULL ,
	IsActive int NULL DEFAULT 1 ,
	Sequence int NULL DEFAULT 0 ,
	DocDate datetime NULL 
) 
GO

CREATE TABLE t_ecf (
	ECFID varchar (12) NOT NULL ,
	Description varchar (50) NULL ,
	Weight float NULL DEFAULT 1 ,
	Value float NULL DEFAULT 0 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_efforttypes (
	EffortType varchar (12) NOT NULL ,
	Description varchar (255) NULL ,
	NumericWeight float NULL DEFAULT 0 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_files (
	FileID varchar (50) NOT NULL ,
	AppliesTo varchar (50) NOT NULL ,
	Category varchar (100) NOT NULL ,
	Name varchar (150) NOT NULL ,
	File varchar (255) NULL ,
	Notes text NULL ,
	FileDate datetime NULL ,
	FileSize int NULL 
) 
GO

CREATE TABLE t_genopt (
	AppliesTo varchar (12) NULL ,
	"Option" text NULL 
) 
GO

CREATE TABLE t_glossary (
	Term varchar (255) NULL ,
	Type varchar (255) NULL ,
	Meaning text NULL ,
	GlossaryID int NOT NULL DEFAULT AUTOINCREMENT 
) 
GO

CREATE TABLE t_html (
	Type varchar (50) NULL ,
	Template text NULL 
) 
GO

CREATE TABLE t_image (
	ImageID int NOT NULL DEFAULT AUTOINCREMENT ,
	Name varchar (255) NULL ,
	Type varchar (255) NULL ,
	Image image NULL 
) 
GO

CREATE TABLE t_implement (
	Type varchar (50) NULL 
)
GO

CREATE TABLE t_issues (
	Issue varchar (255) NULL ,
	IssueDate datetime NULL ,
	Owner varchar (255) NULL ,
	Status varchar (50) NULL ,
	Notes text NULL ,
	Resolver varchar (255) NULL ,
	DateResolved datetime NULL ,
	Resolution text NULL ,
	IssueID int NOT NULL DEFAULT AUTOINCREMENT ,
	Category varchar (255) NULL ,
	Priority varchar (100) NULL ,
	Severity varchar (50) NULL ,
	IssueType varchar (100) NULL 
) 
GO

CREATE TABLE t_lists (
	ListID varchar (50) NOT NULL ,
	Category varchar (100) NOT NULL ,
	Name varchar (150) NOT NULL ,
	NVal int NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_mainttypes (
	MaintType varchar (12) NOT NULL ,
	Description varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_method (
	Object_ID int NOT NULL DEFAULT 0 ,
	Name varchar (255) NOT NULL ,
	Scope varchar (50) NULL ,
	Type varchar (50) NULL 
)
GO

CREATE TABLE t_metrictypes (
	Metric varchar (12) NOT NULL ,
	Description varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes varchar (255) NULL 
)
GO

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

CREATE TABLE t_objectconstraint (
	Object_ID int NOT NULL DEFAULT 0 ,
	"Constraint" varchar (255) NOT NULL ,
	ConstraintType varchar (30) NOT NULL ,
	Weight float NULL DEFAULT 0 ,
	Notes text NULL ,
	Status varchar (50) NULL 
) 
GO

CREATE TABLE t_objecteffort (
	Object_ID int NOT NULL DEFAULT 0 ,
	Effort varchar (255) NOT NULL ,
	EffortType varchar (12) NULL ,
	EValue float NULL DEFAULT 0 ,
	Notes text NULL 
) 
GO

CREATE TABLE t_objectfiles (
	Object_ID int NOT NULL DEFAULT 0 ,
	FileName varchar (255) NOT NULL ,
	Type varchar (50) NULL ,
	Note text NULL ,
	FileSize varchar (255) NULL ,
	FileDate varchar (255) NULL 
) 
GO

CREATE TABLE t_objectmetrics (
	Object_ID int NOT NULL DEFAULT 0 ,
	Metric varchar (255) NOT NULL ,
	MetricType varchar (12) NULL ,
	EValue float NULL DEFAULT 1 ,
	Notes text NULL 
) 
GO

CREATE TABLE t_objectproblems (
	Object_ID int NOT NULL DEFAULT 0 ,
	Problem varchar (255) NOT NULL ,
	ProblemType varchar (255) NOT NULL ,
	DateReported datetime NULL ,
	Status varchar (50) NULL ,
	ProblemNotes text NULL ,
	ReportedBy varchar (255) NULL ,
	ResolvedBy varchar (255) NULL ,
	DateResolved datetime NULL ,
	Version varchar (50) NULL ,
	ResolverNotes text NULL ,
	Priority varchar (100) NULL ,
	Severity varchar (50) NULL 
) 
GO

CREATE TABLE t_objectproperties (
	PropertyID int NOT NULL DEFAULT AUTOINCREMENT ,
	Object_ID int NULL DEFAULT 0 ,
	Property varchar (255) NULL ,
	Value varchar (255) NULL ,
	Notes text NULL ,
	ea_guid varchar (40) NULL 
) 
GO

CREATE TABLE t_objectrequires (
	ReqID int NOT NULL DEFAULT AUTOINCREMENT ,
	Object_ID int NULL DEFAULT 0 ,
	Requirement varchar (255) NULL ,
	ReqType varchar (255) NULL ,
	Status varchar (50) NULL ,
	Notes text NULL ,
	Stability varchar (50) NULL ,
	Difficulty varchar (50) NULL ,
	Priority varchar (50) NULL ,
	LastUpdate datetime NULL DEFAULT getdate()
) 
GO

CREATE TABLE t_objectresource (
	Object_ID int NOT NULL DEFAULT 0 ,
	"Resource" varchar (255) NOT NULL ,
	Role varchar (255) NOT NULL ,
	"Time" float NULL DEFAULT 0 ,
	Notes text NULL ,
	PercentComplete smallint NULL DEFAULT 0 ,
	DateStart datetime NULL ,
	DateEnd datetime NULL ,
	History text NULL ,
	ExpectedHours int NULL ,
	ActualHours int NULL 
) 
GO

CREATE TABLE t_objectrisks (
	Object_ID int NOT NULL DEFAULT 0 ,
	Risk varchar (255) NOT NULL ,
	RiskType varchar (12) NULL ,
	EValue float NULL DEFAULT 0 ,
	Notes text NULL 
) 
GO

CREATE TABLE t_objectscenarios (
	Object_ID int NOT NULL DEFAULT 0 ,
	Scenario varchar (255) NOT NULL ,
	ScenarioType varchar (12) NULL ,
	EValue float NULL DEFAULT 0 ,
	Notes text NULL ,
	XMLContent text NULL ,
	ea_guid varchar (40) NULL 
) 
GO

CREATE TABLE t_objecttests (
	Object_ID int NOT NULL DEFAULT 0 ,
	Test varchar (255) NOT NULL ,
	TestClass int NOT NULL DEFAULT 0 ,
	TestType varchar (50) NULL ,
	Notes text NULL ,
	InputData text NULL ,
	AcceptanceCriteria text NULL ,
	Status varchar (32) NULL ,
	DateRun datetime NULL DEFAULT getdate() ,
	Results text NULL ,
	RunBy varchar (255) NULL ,
	CheckBy varchar (255) NULL 
) 
GO

CREATE TABLE t_objecttrx (
	Object_ID int NOT NULL DEFAULT 0 ,
	TRX varchar (255) NOT NULL ,
	TRXType varchar (12) NOT NULL ,
	Weight float NULL DEFAULT 0 ,
	Notes text NULL 
) 
GO

CREATE TABLE t_objecttypes (
	Object_Type varchar (50) NOT NULL ,
	Description varchar (255) NULL ,
	DesignObject int NOT NULL DEFAULT 0 ,
	ImageID int NULL DEFAULT 0 
)
GO

CREATE TABLE t_ocf (
	ObjectType varchar (50) NULL ,
	ComplexityWeight float NULL DEFAULT 0
)
GO

CREATE TABLE t_operation (
	OperationID int NOT NULL DEFAULT AUTOINCREMENT ,
	Object_ID int NULL DEFAULT 0 ,
	Name varchar (255) NULL ,
	Scope varchar (50) NULL ,
	Type varchar (255) NULL ,
	ReturnArray varchar (1) NULL ,
	Stereotype varchar (50) NULL ,
	IsStatic varchar (1) NULL ,
	Concurrency varchar (50) NULL ,
	Notes text NULL ,
	Behaviour text NULL ,
	Abstract varchar (1) NULL ,
	GenOption text NULL ,
	Synchronized varchar (1) NULL ,
	Pos int NULL ,
	Const int NULL ,
	Style varchar (255) NULL ,
	Pure int NOT NULL DEFAULT 0 ,
	Throws varchar (255) NULL ,
	Classifier varchar (50) NULL ,
	Code text NULL ,
	IsRoot int NOT NULL DEFAULT 0 ,
	IsLeaf int NOT NULL DEFAULT 0 ,
	IsQuery int NOT NULL DEFAULT 0 ,
	StateFlags varchar (255) NULL ,
	ea_guid varchar (50) NULL ,
	StyleEx text NULL 
) 
GO

CREATE TABLE t_operationparams (
	OperationID int NOT NULL DEFAULT 0 ,
	Name varchar (255) NOT NULL ,
	Type varchar (255) NULL ,
	"Default" varchar (255) NULL ,
	Notes text NULL ,
	Pos int NULL ,
	Const int NOT NULL DEFAULT 0 ,
	Style varchar (255) NULL ,
	Kind varchar (12) NULL ,
	Classifier varchar (50) NULL ,
	ea_guid varchar (50) NULL ,
	StyleEx text NULL 
) 
GO

CREATE TABLE t_operationposts (
	OperationID int NOT NULL DEFAULT 0 ,
	PostCondition varchar (255) NOT NULL ,
	Type varchar (255) NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_operationpres (
	OperationID int NOT NULL DEFAULT 0 ,
	PreCondition varchar (255) NOT NULL ,
	Type varchar (50) NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_operationtag (
	PropertyID int NOT NULL DEFAULT AUTOINCREMENT ,
	ElementID int NULL ,
	Property varchar (255) NULL ,
	VALUE varchar (255) NULL ,
	NOTES text NULL ,
	ea_guid varchar (40) NULL 
) 
GO

CREATE TABLE t_package (
	Package_ID int NOT NULL DEFAULT AUTOINCREMENT ,
	Name varchar (255) NULL ,
	Parent_ID int NULL DEFAULT 0 ,
	CreatedDate datetime NULL DEFAULT getdate() ,
	ModifiedDate datetime NULL DEFAULT getdate() ,
	Notes text NULL ,
	ea_guid varchar (40) NULL ,
	XMLPath varchar (255) NULL ,
	IsControlled int NOT NULL DEFAULT 0 ,
	LastLoadDate datetime NULL ,
	LastSaveDate datetime NULL ,
	Version varchar (50) NULL ,
	Protected int NOT NULL DEFAULT 0 ,
	PkgOwner varchar (255) NULL ,
	UMLVersion varchar (50) NULL ,
	UseDTD int NOT NULL DEFAULT 0 ,
	LogXML int NOT NULL DEFAULT 0 ,
	CodePath varchar (255) NULL ,
	Namespace varchar (50) NULL ,
	TPos int NULL ,
	PackageFlags varchar (255) NULL ,
	BatchSave int NULL ,
	BatchLoad int NULL 
) 
GO

CREATE TABLE t_palette (
	PaletteID int NOT NULL DEFAULT AUTOINCREMENT ,
	Name varchar (255) NULL ,
	Type varchar (255) NULL 
)
GO

CREATE TABLE t_paletteitem (
	PaletteID int NULL ,
	ItemID int NULL 
)
GO

CREATE TABLE t_phase (
	PhaseID varchar (40) NOT NULL ,
	PhaseName varchar (100) NOT NULL ,
	PhaseNotes text NULL ,
	PhaseStyle varchar (255) NULL ,
	StartDate datetime NULL ,
	EndDate datetime NULL ,
	PhaseContent text NULL 
) 
GO

CREATE TABLE t_primitives (
	Datatype varchar (50) NOT NULL ,
	Description varchar (50) NULL 
)
GO

CREATE TABLE t_problemtypes (
	ProblemType varchar (12) NOT NULL ,
	Description varchar (255) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_projectroles (
	Role varchar (255) NOT NULL ,
	Description varchar (255) NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_propertytypes (
	Property varchar (50) NOT NULL ,
	Description varchar (50) NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_requiretypes (
	Requirement varchar (12) NOT NULL ,
	Description varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_resources (
	Name varchar (255) NOT NULL ,
	Organisation varchar (255) NULL ,
	Phone1 varchar (50) NULL ,
	Phone2 varchar (50) NULL ,
	Mobile varchar (50) NULL ,
	Fax varchar (50) NULL ,
	Email varchar (255) NULL ,
	Roles varchar (255) NULL ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_risktypes (
	Risk varchar (12) NOT NULL ,
	Description varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 0 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_roleconstraint (
	ConnectorID int NOT NULL DEFAULT 0 ,
	"Constraint" varchar (255) NOT NULL ,
	ConnectorEnd varchar (50) NOT NULL ,
	ConstraintType varchar (12) NOT NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_rtf (
	Type varchar (50) NULL ,
	Template text NULL 
) 
GO

CREATE TABLE t_rtfreport (
	TemplateID varchar (200) NOT NULL ,
	RootPackage int NULL DEFAULT 0 ,
	Filename varchar (255) NULL ,
	Details int NOT NULL DEFAULT 0 ,
	ProcessChildren int NOT NULL DEFAULT 0 ,
	ShowDiagrams int NOT NULL DEFAULT 0 ,
	Heading varchar (255) NULL ,
	Requirements int NOT NULL DEFAULT 0 ,
	Associations int NOT NULL DEFAULT 0 ,
	Scenarios int NOT NULL DEFAULT 0 ,
	ChildDiagrams int NOT NULL DEFAULT 0 ,
	Attributes int NOT NULL DEFAULT 0 ,
	Methods int NOT NULL DEFAULT 0 ,
	ImageType int NULL DEFAULT 0 ,
	Paging int NOT NULL DEFAULT 0 ,
	Intro text NULL ,
	Resources int NOT NULL DEFAULT 1 ,
	Constraints int NOT NULL DEFAULT 1 ,
	Tagged int NOT NULL DEFAULT 0 ,
	ShowTag int NOT NULL DEFAULT 0 ,
	ShowAlias int NOT NULL DEFAULT 0 ,
	PDATA1 varchar (255) NULL ,
	PDATA2 varchar (255) NULL ,
	PDATA3 varchar (255) NULL ,
	PDATA4 text NULL 
) 
GO

CREATE TABLE t_rules (
	RuleID varchar (50) NOT NULL ,
	RuleName varchar (255) NOT NULL ,
	RuleType varchar (255) NOT NULL ,
	RuleActive int NULL ,
	ErrorMsg varchar (255) NULL ,
	Flags varchar (255) NULL ,
	RuleOCL text NULL ,
	RuleXML text NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_scenariotypes (
	ScenarioType varchar (12) NOT NULL ,
	Description varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_script (
	ScriptID int NOT NULL DEFAULT AUTOINCREMENT ,
	ScriptCategory varchar (100) NULL ,
	ScriptName varchar (150) NULL ,
	ScriptAuthor varchar (255) NULL ,
	Notes text NULL ,
	Script text NULL 
) 
GO

CREATE TABLE t_secgroup (
	GroupID varchar (40) NOT NULL ,
	GroupName varchar (32) NOT NULL ,
	Description varchar (100) NULL 
)
GO

CREATE TABLE t_secgrouppermission (
	GroupID varchar (40) NOT NULL ,
	PermissionID int NOT NULL 
)
GO

CREATE TABLE t_seclocks (
	UserID varchar (40) NOT NULL ,
	GroupID varchar (40) NULL ,
	EntityType varchar (32) NOT NULL ,
	EntityID varchar (40) NOT NULL ,
	Timestamp datetime NOT NULL ,
	LockType varchar (255) NULL 
)
GO

CREATE TABLE t_secpermission (
	PermissionID int NOT NULL ,
	PermissionName varchar (50) NOT NULL 
)
GO

CREATE TABLE t_secpolicies (
	Property varchar (100) NOT NULL ,
	Value varchar (255) NOT NULL 
)
GO

CREATE TABLE t_secuser (
	UserID varchar (40) NOT NULL ,
	UserLogin varchar (32) NOT NULL ,
	FirstName varchar (50) NOT NULL ,
	Surname varchar (50) NOT NULL ,
	Department varchar (50) NULL ,
	Password varchar (12) NULL 
)
GO

CREATE TABLE t_secusergroup (
	UserID varchar (40) NOT NULL ,
	GroupID varchar (40) NOT NULL 
)
GO

CREATE TABLE t_secuserpermission (
	UserID varchar (40) NOT NULL ,
	PermissionID int NOT NULL 
)
GO

CREATE TABLE t_snapshot (
	SnapshotID varchar (50) NOT NULL ,
	SeriesID varchar (50) NOT NULL ,
	Position int NOT NULL ,
	SnapshotName varchar (100) NOT NULL ,
	Notes text NULL ,
	Style varchar (100) NULL ,
	ElementID varchar (50) NOT NULL ,
	ElementType varchar (50) NOT NULL ,
	StrContent text NULL ,
	BinContent1 image NULL ,
	BinContent2 image NULL 
) 
GO

CREATE TABLE t_statustypes (
	Status varchar (50) NULL ,
	Description varchar (50) NULL 
)
GO

CREATE TABLE t_stereotypes (
	Stereotype varchar (255) NOT NULL ,
	AppliesTo varchar (255) NOT NULL ,
	Description varchar (255) NULL ,
	MFEnabled int NOT NULL DEFAULT 0 ,
	MFPath varchar (255) NULL ,
	Metafile image NULL ,
	Style text NULL ,
	ea_guid varchar (50) NULL ,
	VisualType varchar (100) NULL 
) 
GO

CREATE TABLE t_taggedvalue (
	PropertyID varchar (50) NOT NULL ,
	ElementID varchar (50) NOT NULL ,
	BaseClass varchar (100) NOT NULL ,
	TagValue text NULL ,
	Notes text NULL 
) 
GO

CREATE TABLE t_tasks (
	TaskID int NOT NULL DEFAULT AUTOINCREMENT ,
	Name varchar (255) NULL ,
	TaskType varchar (255) NULL ,
	NOTES text NULL ,
	Priority varchar (255) NULL ,
	Status varchar (255) NULL ,
	Owner varchar (255) NULL ,
	StartDate datetime NULL ,
	EndDate datetime NULL ,
	Phase varchar (50) NULL ,
	History text NULL ,
	Percent int NULL ,
	TotalTime int NULL ,
	ActualTime int NULL ,
	AssignedTo varchar (255) NULL 
) 
GO

CREATE TABLE t_tcf (
	TCFID varchar (12) NOT NULL ,
	Description varchar (50) NULL ,
	Weight float NULL DEFAULT 1 ,
	Value float NULL DEFAULT 0 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_template (
	TemplateID varchar (40) NOT NULL ,
	TemplateType varchar (50) NOT NULL ,
	TemplateName varchar (100) NOT NULL ,
	Notes varchar (255) NULL ,
	Style varchar (255) NULL ,
	Template text NULL 
) 
GO

CREATE TABLE t_testclass (
	TestClass varchar (50) NOT NULL ,
	Description varchar (50) NULL 
)
GO

CREATE TABLE t_testplans (
	PlanID varchar (50) NOT NULL ,
	Category varchar (100) NOT NULL ,
	Name varchar (150) NOT NULL ,
	Author varchar (255) NOT NULL ,
	Notes text NULL ,
	TestPlan text NOT NULL 
) 
GO

CREATE TABLE t_testtypes (
	TestType varchar (12) NOT NULL ,
	Description varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes varchar (255) NULL 
)
GO

CREATE TABLE t_trxtypes (
	Description varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes text NULL ,
	TRX varchar (255) NULL ,
	TRX_ID int NOT NULL DEFAULT AUTOINCREMENT ,
	Style text NULL 
) 
GO

CREATE TABLE t_umlpattern (
	PatternID int NOT NULL DEFAULT AUTOINCREMENT ,
	PatternCategory varchar (100) NULL ,
	PatternName varchar (150) NULL ,
	Style varchar (250) NULL ,
	Notes text NULL ,
	PatternXML text NULL ,
	Version varchar (50) NULL 
) 
GO

CREATE TABLE t_version (
	ElementID varchar (50) NOT NULL ,
	VersionID varchar (255) NOT NULL ,
	ElementType varchar (100) NULL ,
	Flags varchar (255) NULL ,
	ExternalFile varchar (255) NULL ,
	Notes varchar (255) NULL ,
	Owner varchar (255) NULL ,
	VersionDate datetime NULL ,
	Branch varchar (255) NULL ,
	ElementXML text NULL 
) 
GO

CREATE TABLE t_xref (
	XrefID varchar (255) NOT NULL ,
	Name varchar (255) NULL ,
	Type varchar (255) NULL ,
	Visibility varchar (255) NULL ,
	Namespace varchar (255) NULL ,
	Requirement varchar (255) NULL ,
	"Constraint" varchar (255) NULL ,
	Behavior varchar (255) NULL ,
	Partition varchar (255) NULL ,
	Description text NULL ,
	Client varchar (255) NULL ,
	Supplier varchar (255) NULL ,
	Link varchar (255) NULL 
) 
GO

CREATE TABLE t_xrefsystem (
	XrefID varchar (255) NOT NULL ,
	Name varchar (255) NULL ,
	Type varchar (255) NULL ,
	Visibility varchar (255) NULL ,
	Namespace varchar (255) NULL ,
	Requirement varchar (255) NULL ,
	"Constraint" varchar (255) NULL ,
	Behavior varchar (255) NULL ,
	Partition varchar (255) NULL ,
	Description text NULL ,
	Client varchar (255) NULL ,
	Supplier varchar (255) NULL ,
	Link varchar (255) NULL ,
	ToolID varchar (50) NULL 
) 
GO

CREATE TABLE t_xrefuser (
	XrefID varchar (255) NOT NULL ,
	Name varchar (255) NULL ,
	Type varchar (255) NULL ,
	Visibility varchar (255) NULL ,
	Namespace varchar (255) NULL ,
	Requirement varchar (255) NULL ,
	"Constraint" varchar (255) NULL ,
	Behavior varchar (255) NULL ,
	Partition varchar (255) NULL ,
	Description text NULL ,
	Client varchar (255) NULL ,
	Supplier varchar (255) NULL ,
	Link varchar (255) NULL ,
	ToolID varchar (50) NULL 
) 
GO

CREATE TABLE usysOldTables (
	TableName varchar (50) NULL ,
	NewName varchar (50) NULL ,
	RelOrder int NULL DEFAULT 0 ,
	FixCode int NOT NULL DEFAULT 0 
)
GO

CREATE TABLE usysQueries (
	QueryName varchar (50) NULL ,
	NewName varchar (50) NULL ,
	FixCode int NOT NULL 
)
GO

CREATE TABLE usysTables (
	TableName varchar (50) NOT NULL ,
	RelOrder int NULL DEFAULT 0 ,
	DisplayName varchar (50) NULL ,
	FromVer varchar (50) NULL ,
	ToVer varchar (50) NULL 
)
GO

CREATE TABLE usys_system (
	[Property] varchar (50) NOT NULL ,
	[Value] varchar (50) NULL 
)
GO

ALTER TABLE t_files ADD 
	CONSTRAINT PK_t_files PRIMARY KEY 
	(
		FileID
	)  
GO

ALTER TABLE t_lists ADD 
	CONSTRAINT PK_t_lists PRIMARY KEY 
	(
		ListID
	) 
GO

ALTER TABLE t_phase ADD 
	CONSTRAINT PK_t_phase PRIMARY KEY  
	(
		PhaseID
	) 
GO

ALTER TABLE t_rules ADD 
	CONSTRAINT PK_t_rules PRIMARY KEY  CLUSTERED 
	(
		RuleID
	) 
GO

ALTER TABLE t_snapshot ADD 
	CONSTRAINT PK_t_snapshot PRIMARY KEY  CLUSTERED 
	(
		SnapshotID
	) 
GO

ALTER TABLE t_taggedvalue ADD 
	CONSTRAINT PK_t_taggedvalue PRIMARY KEY  CLUSTERED 
	(
		PropertyID
	) 
GO

ALTER TABLE t_testplans ADD 
	CONSTRAINT PK_t_testplans PRIMARY KEY  CLUSTERED 
	(
		PlanID) 
GO

ALTER TABLE t_umlpattern ADD 
	CONSTRAINT PK_t_umlpattern PRIMARY KEY  CLUSTERED 
	(
		PatternID
	) 
GO

ALTER TABLE t_version ADD 
	CONSTRAINT PK_t_version PRIMARY KEY  CLUSTERED 
	(
		ElementID,
		VersionID
	) 
GO

ALTER TABLE t_attribute ADD 
	CONSTRAINT aaaaat_attribute_PK PRIMARY KEY  NONCLUSTERED 
	(
		ID
	) 
GO

ALTER TABLE t_attributeconstraints ADD 
	CONSTRAINT aaaaat_attributeconstraints_PK PRIMARY KEY  NONCLUSTERED 
	(
		ID,
		"Constraint"
	) 
GO

ALTER TABLE t_attributetag ADD 
	CONSTRAINT aaaaat_attributetag_PK PRIMARY KEY  NONCLUSTERED 
	(
		PropertyID
	) 
GO

ALTER TABLE t_authors ADD 
	CONSTRAINT aaaaat_authors_PK PRIMARY KEY  NONCLUSTERED 
	(
		AuthorName
	) 
GO

ALTER TABLE t_cardinality ADD 
	CONSTRAINT aaaaat_cardinality_PK PRIMARY KEY  NONCLUSTERED 
	(
		Cardinality
	) 
GO

ALTER TABLE t_category ADD 
	CONSTRAINT aaaaat_category_PK PRIMARY KEY  NONCLUSTERED 
	(
		CategoryID
	) 
GO

ALTER TABLE t_clients ADD 
	CONSTRAINT aaaaat_clients_PK PRIMARY KEY  NONCLUSTERED 
	(
		Name
	) 
GO

ALTER TABLE t_complexitytypes ADD 
	CONSTRAINT aaaaat_complexitytypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		Complexity
	) 
GO

ALTER TABLE t_connector ADD 
	CONSTRAINT aaaaat_connector_PK PRIMARY KEY  NONCLUSTERED 
	(
		Connector_ID
	) 
GO

ALTER TABLE t_connectorconstraint ADD 
	CONSTRAINT aaaaat_connectorconstraint_PK PRIMARY KEY  NONCLUSTERED 
	(
		ConnectorID,
		"Constraint"
	) 
GO

ALTER TABLE t_connectortag ADD 
	CONSTRAINT aaaaat_connectortag_PK PRIMARY KEY  NONCLUSTERED 
	(
		PropertyID
	) 
GO

ALTER TABLE t_connectortypes ADD 
	CONSTRAINT aaaaat_connectortypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		Connector_Type
	) 
GO

ALTER TABLE t_constants ADD 
	CONSTRAINT aaaaat_constants_PK PRIMARY KEY  NONCLUSTERED 
	(
		ConstantName
	) 
GO

ALTER TABLE t_constrainttypes ADD 
	CONSTRAINT aaaaat_constrainttypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		"Constraint"
	) 
GO

ALTER TABLE t_datatypes ADD 
	CONSTRAINT aaaaat_datatypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		DatatypeID
	) 
GO

ALTER TABLE t_diagram ADD 
	CONSTRAINT aaaaat_diagram_PK PRIMARY KEY  NONCLUSTERED 
	(
		Diagram_ID
	) 
GO

ALTER TABLE t_diagramlinks ADD 
	CONSTRAINT aaaaat_diagramlinks_PK PRIMARY KEY  NONCLUSTERED 
	(
		Instance_ID
	) 
GO

ALTER TABLE t_diagramobjects ADD 
	CONSTRAINT aaaaat_diagramobjects_PK PRIMARY KEY  NONCLUSTERED 
	(
		Instance_ID
	) 
GO

ALTER TABLE t_diagramtypes ADD 
	CONSTRAINT aaaaat_diagramtypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		Diagram_Type
	) 
GO

ALTER TABLE t_document ADD 
	CONSTRAINT aaaaat_document_PK PRIMARY KEY  NONCLUSTERED 
	(
		DocID
	) 
GO

ALTER TABLE t_ecf ADD 
	CONSTRAINT aaaaat_ecf_PK PRIMARY KEY  NONCLUSTERED 
	(
		ECFID
	) 
GO

ALTER TABLE t_efforttypes ADD 
	CONSTRAINT aaaaat_efforttypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		EffortType
	) 
GO

ALTER TABLE t_glossary ADD 
	CONSTRAINT aaaaat_glossary_PK PRIMARY KEY  NONCLUSTERED 
	(
		GlossaryID
	) 
GO

ALTER TABLE t_issues ADD 
	CONSTRAINT aaaaat_issues_PK PRIMARY KEY  NONCLUSTERED 
	(
		IssueID
	) 
GO

ALTER TABLE t_mainttypes ADD 	
	CONSTRAINT aaaaat_mainttypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		MaintType
	) 
GO

ALTER TABLE t_method ADD 	
	CONSTRAINT aaaaat_method_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		Name
	) 
GO

ALTER TABLE t_metrictypes ADD 
	CONSTRAINT aaaaat_metrictypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		Metric
	) 
GO

ALTER TABLE t_object ADD 
	CONSTRAINT aaaaat_object_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID
	) 
GO

ALTER TABLE t_objectconstraint ADD 
	CONSTRAINT aaaaat_objectconstraint_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		ConstraintType,
		"Constraint"
	) 
GO

ALTER TABLE t_objecteffort ADD 
	CONSTRAINT aaaaat_objecteffort_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		Effort
	) 
GO

ALTER TABLE t_objectfiles ADD 
	CONSTRAINT aaaaat_objectfiles_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		FileName
	) 
GO

ALTER TABLE t_objectmetrics ADD 
	CONSTRAINT aaaaat_objectmetrics_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		Metric
	) 
GO

ALTER TABLE t_objectproblems ADD 
	CONSTRAINT aaaaat_objectproblems_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		ProblemType,
		Problem
	) 
GO

ALTER TABLE t_objectproperties ADD 	
	CONSTRAINT aaaaat_objectproperties_PK PRIMARY KEY  NONCLUSTERED 
	(
		PropertyID
	) 
GO

ALTER TABLE t_objectrequires ADD 
	CONSTRAINT aaaaat_objectrequires_PK PRIMARY KEY  NONCLUSTERED 
	(
		ReqID
	) 
GO

ALTER TABLE t_objectresource ADD 
	CONSTRAINT aaaaat_objectresource_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		"Resource",
		Role
	) 
GO

ALTER TABLE t_objectrisks ADD 
	CONSTRAINT aaaaat_objectrisks_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		Risk
	) 
GO

ALTER TABLE t_objectscenarios ADD 
	CONSTRAINT aaaaat_objectscenarios_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		Scenario
	) 
GO

ALTER TABLE t_objecttests ADD 
	CONSTRAINT aaaaat_objecttests_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		Test,
		TestClass
	) 
GO

ALTER TABLE t_objecttrx ADD 
	CONSTRAINT aaaaat_objecttrx_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_ID,
		TRXType,
		TRX
	) 
GO

ALTER TABLE t_objecttypes ADD 
	CONSTRAINT aaaaat_objecttypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		Object_Type
	) 
GO

ALTER TABLE t_operation ADD 
	CONSTRAINT aaaaat_operation_PK PRIMARY KEY  NONCLUSTERED 
	(
		OperationID
	) 
GO

ALTER TABLE t_operationparams ADD 
	CONSTRAINT aaaaat_operationparams_PK PRIMARY KEY  NONCLUSTERED 
	(
		OperationID,
		Name
	) 
GO

ALTER TABLE t_operationposts ADD 
	CONSTRAINT aaaaat_operationposts_PK PRIMARY KEY  NONCLUSTERED 
	(
		OperationID,
		PostCondition
	) 
GO

ALTER TABLE t_operationpres ADD 
	CONSTRAINT aaaaat_operationpres_PK PRIMARY KEY  NONCLUSTERED 
	(
		OperationID,
		PreCondition
	) 
GO

ALTER TABLE t_operationtag ADD 
	CONSTRAINT aaaaat_operationtag_PK PRIMARY KEY  NONCLUSTERED 
	(
		PropertyID
	) 
GO

ALTER TABLE t_package ADD 
	CONSTRAINT aaaaat_package_PK PRIMARY KEY  NONCLUSTERED 
	(
		Package_ID
	) 
GO

ALTER TABLE t_primitives ADD 
	CONSTRAINT aaaaat_primitives_PK PRIMARY KEY  NONCLUSTERED 
	(
		Datatype
	) 
GO

ALTER TABLE t_problemtypes ADD 
	CONSTRAINT aaaaat_problemtypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		ProblemType
	) 
GO

ALTER TABLE t_projectroles ADD 
	CONSTRAINT aaaaat_projectroles_PK PRIMARY KEY  NONCLUSTERED 
	(
		Role
	) 
GO

ALTER TABLE t_propertytypes ADD 
	CONSTRAINT aaaaat_propertytypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		Property
	) 
GO

ALTER TABLE t_requiretypes ADD 
	CONSTRAINT aaaaat_requiretypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		Requirement
	) 
GO

ALTER TABLE t_resources ADD 
	CONSTRAINT aaaaat_resources_PK PRIMARY KEY  NONCLUSTERED 
	(
		Name
	) 
GO

ALTER TABLE t_risktypes ADD 
	CONSTRAINT aaaaat_risktypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		Risk
	) 
GO

ALTER TABLE t_roleconstraint ADD 
	CONSTRAINT aaaaat_roleconstraint_PK PRIMARY KEY  NONCLUSTERED 
	(
		ConnectorID,
		"Constraint",
		ConnectorEnd,
		ConstraintType
	) 
GO

ALTER TABLE t_rtfreport ADD 
	CONSTRAINT aaaaat_rtfreport_PK PRIMARY KEY  NONCLUSTERED 
	(
		TemplateID
	) 
GO

ALTER TABLE t_scenariotypes ADD 
	CONSTRAINT aaaaat_scenariotypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		ScenarioType
	) 
GO

ALTER TABLE t_secgroup ADD 
	CONSTRAINT aaaaat_secgroup_PK PRIMARY KEY  NONCLUSTERED 
	(
		GroupID
	) 
GO

ALTER TABLE t_secgrouppermission ADD 
	CONSTRAINT aaaaat_secgrouppermission_PK PRIMARY KEY  NONCLUSTERED 
	(
		GroupID,
		PermissionID
	) 
GO

ALTER TABLE t_seclocks ADD 
	CONSTRAINT aaaaat_seclocks_PK PRIMARY KEY  NONCLUSTERED 
	(
		EntityID
	) 
GO

ALTER TABLE t_secpermission ADD 
	CONSTRAINT aaaaat_secpermission_PK PRIMARY KEY  NONCLUSTERED 
	(
		PermissionID
	) 
GO

ALTER TABLE t_secpolicies ADD 
	CONSTRAINT aaaaat_secpolicies_PK PRIMARY KEY  NONCLUSTERED 
	(
		Property
	) 
GO

ALTER TABLE t_secuser ADD 
	CONSTRAINT aaaaat_secuser_PK PRIMARY KEY  NONCLUSTERED 
	(
		UserID
	) 
GO

ALTER TABLE t_secusergroup ADD 
	CONSTRAINT aaaaat_secusergroup_PK PRIMARY KEY  NONCLUSTERED 
	(
		UserID,
		GroupID
	) 
GO

ALTER TABLE t_secuserpermission ADD 
	CONSTRAINT aaaaat_secuserpermission_PK PRIMARY KEY  NONCLUSTERED 
	(
		UserID,
		PermissionID
	) 
GO

ALTER TABLE t_stereotypes ADD 
	CONSTRAINT aaaaat_stereotypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		AppliesTo,
		Stereotype
	) 
GO

ALTER TABLE t_tasks ADD 
	CONSTRAINT aaaaat_tasks_PK PRIMARY KEY  NONCLUSTERED 
	(
		TaskID
	) 
GO

ALTER TABLE t_tcf ADD 
	CONSTRAINT aaaaat_tcf_PK PRIMARY KEY  NONCLUSTERED 
	(
		TCFID
	) 
GO

ALTER TABLE t_template ADD 
	CONSTRAINT aaaaat_template_PK PRIMARY KEY  NONCLUSTERED 
	(
		TemplateID
	) 
GO

ALTER TABLE t_testclass ADD 
	CONSTRAINT aaaaat_testclass_PK PRIMARY KEY  NONCLUSTERED 
	(
		TestClass
	) 
GO

ALTER TABLE t_testtypes ADD 
	CONSTRAINT aaaaat_testtypes_PK PRIMARY KEY  NONCLUSTERED 
	(
		TestType
	) 
GO

ALTER TABLE t_trxtypes ADD CONSTRAINT aaaaat_trxtypes_PK PRIMARY KEY  NONCLUSTERED (TRX_ID) 
GO

ALTER TABLE t_xref ADD CONSTRAINT aaaaat_xref_PK PRIMARY KEY  NONCLUSTERED (XrefID) 
GO

ALTER TABLE usysTables ADD CONSTRAINT aaaaausysTables_PK PRIMARY KEY  NONCLUSTERED (TableName) 
GO

ALTER TABLE usys_system ADD CONSTRAINT aaaaausys_system_PK PRIMARY KEY  NONCLUSTERED (Property) 
GO

CREATE INDEX idx_t_attribute_Name ON t_attribute(Name)
GO

CREATE INDEX idx_t_attribute_Object_ID ON t_attribute(Object_ID)
GO

CREATE INDEX idx_t_attributetag_ElementID ON t_attributetag(ElementID)
GO

CREATE INDEX idx_NumericWeight_t_complexitytypes ON t_complexitytypes(NumericWeight)
GO

CREATE INDEX idx_t_connector_Connector_Type ON t_connector(Connector_Type)
GO

CREATE INDEX idx_t_connector_Start_Object_ID ON t_connector(Start_Object_ID)
GO

CREATE INDEX idx_t_connector_End_Object_ID ON t_connector(End_Object_ID)
GO

CREATE INDEX idx_t_connector_Connector_ID ON t_connector(Connector_ID)
GO

CREATE INDEX idx_t_connector_DiagramID ON t_connector(DiagramID)
GO

CREATE UNIQUE INDEX idx_t_connector_ea_guid ON t_connector(ea_guid)
GO

CREATE INDEX idx_t_connector_styylex ON t_connector(StyleEx)
GO

CREATE INDEX idx_t_connectorconstraint_Constraint ON t_connectorconstraint("Constraint")
GO

CREATE INDEX idx_t_connectorconstraint_ConnectorID ON t_connectorconstraint(ConnectorID)
GO

CREATE INDEX idx_t_connectortag ON t_connectortag(ElementID)
GO

CREATE INDEX idx_t_diagram_Diagram_ID ON t_diagram(Diagram_ID)
GO

CREATE INDEX idx_t_diagram_Diagram_Type ON t_diagram(Diagram_Type)
GO

 CREATE  UNIQUE  INDEX idx_t_diagram_ea_guid ON t_diagram(ea_guid)
GO

CREATE INDEX idx_t_diagram_Package_ID ON t_diagram(Package_ID)
GO

CREATE INDEX idx_t_diagram_ParentID ON t_diagram(ParentID)
GO

CREATE INDEX idx_t_diagramlinks_ConnectorID ON t_diagramlinks(ConnectorID)
GO

CREATE INDEX idx_t_diagramlinks_DiagramID ON t_diagramlinks(DiagramID)
GO

CREATE INDEX idx_t_diagramobjects ON t_diagramobjects(Diagram_ID)
GO

CREATE INDEX DiagramID ON t_diagramobjects(Diagram_ID)
GO

CREATE INDEX ObjectID ON t_diagramobjects(Object_ID)
GO

CREATE INDEX PackageDiagramTypes ON t_diagramtypes(Package_ID)
GO

CREATE INDEX PackageID ON t_diagramtypes(Package_ID)
GO

CREATE INDEX IX_t_document ON t_document(ElementID)
GO

CREATE INDEX NumericWeight ON t_ecf(Weight)
GO

CREATE INDEX NumericWeight ON t_efforttypes(NumericWeight)
GO

CREATE INDEX NumericWeight ON t_mainttypes(NumericWeight)
GO

CREATE INDEX "{1E62D3A8-F3CF-4E2A-B0A0-A7266C98C7DB}" ON t_method(Object_ID)
GO

CREATE INDEX Object_ID ON t_method(Object_ID)
GO

CREATE INDEX NumericWeight ON t_metrictypes(NumericWeight)
GO

 CREATE  UNIQUE  INDEX IDX_GUID ON t_object(ea_guid)
GO

CREATE INDEX Package_ID ON t_object(Package_ID)
GO

CREATE INDEX PackageObject ON t_object(Package_ID)
GO

CREATE INDEX PD1 ON t_object(PDATA1)
GO

CREATE INDEX PID ON t_object(ParentID)
GO

CREATE INDEX CGD ON t_object(Classifier_guid)
GO

CREATE INDEX CID ON t_object(Classifier)
GO

CREATE INDEX NTP ON t_object(NType)
GO

CREATE INDEX GNL ON t_object(GenLinks)
GO

CREATE INDEX ObjectConstraintConstraint ON t_objectconstraint("Constraint")
GO

CREATE INDEX ObjectID ON t_objectconstraint(Object_ID)
GO

CREATE INDEX ObjectID ON t_objecteffort(Object_ID)
GO

CREATE INDEX "{4284C791-A819-44C8-B0AD-41BCCD533E6A}" ON t_objectmetrics(MetricType)
GO

CREATE INDEX ObjectID ON t_objectmetrics(Object_ID)
GO

CREATE INDEX ObjectMetricsMetric ON t_objectmetrics(Metric)
GO

CREATE INDEX ObjectID ON t_objectproblems(Object_ID)
GO

CREATE INDEX ObjectRequiresRequirement ON t_objectproblems(Problem)
GO

CREATE INDEX Object_ID ON t_objectproperties(Object_ID)
GO

CREATE INDEX ObjectID ON t_objectrequires(Object_ID)
GO

CREATE INDEX ObjectRequiresRequirement ON t_objectrequires(Requirement)
GO

CREATE INDEX ReqID ON t_objectrequires(ReqID)
GO

CREATE INDEX ObjectID ON t_objectresource(Object_ID)
GO

CREATE INDEX ObjectID ON t_objectrisks(Object_ID)
GO

CREATE INDEX ObjectID ON t_objectscenarios(Object_ID)
GO

CREATE INDEX ObjectID ON t_objecttests(Object_ID)
GO

CREATE INDEX ObjectConstraintConstraint ON t_objecttrx(TRX)
GO

CREATE INDEX ObjectID ON t_objecttrx(Object_ID)
GO

CREATE INDEX ImageID ON t_objecttypes(ImageID)
GO

CREATE INDEX Name ON t_operation(Name)
GO

CREATE INDEX Object_ID ON t_operation(Object_ID)
GO

CREATE INDEX OperationID ON t_operation(OperationID)
GO

CREATE INDEX OperationID ON t_operationparams(OperationID)
GO

CREATE INDEX Param ON t_operationparams(OperationID, Pos)
GO

CREATE INDEX OperationID ON t_operationposts(OperationID)
GO

CREATE INDEX OperationID ON t_operationpres(OperationID)
GO

CREATE INDEX ElementKey ON t_operationtag(ElementID)
GO

 CREATE  UNIQUE  INDEX IDX_GUID ON t_package(ea_guid)
GO

CREATE INDEX Package_ID ON t_package(Package_ID)
GO

CREATE INDEX ParentID ON t_package(Parent_ID)
GO

CREATE INDEX PkgNME ON t_package(Name)
GO

CREATE INDEX NumericWeight ON t_problemtypes(NumericWeight)
GO

CREATE INDEX NumericWeight ON t_requiretypes(NumericWeight)
GO

CREATE INDEX NumericWeight ON t_risktypes(NumericWeight)
GO

CREATE INDEX ObjectConstraintConstraint ON t_roleconstraint("Constraint")
GO

CREATE INDEX ObjectID ON t_roleconstraint(ConnectorID)
GO

CREATE INDEX RTFReportID ON t_rtfreport(TemplateID)
GO

CREATE INDEX NumericWeight ON t_scenariotypes(NumericWeight)
GO

CREATE INDEX NumericWeight ON t_tcf(Weight)
GO

CREATE INDEX NumericWeight ON t_testtypes(NumericWeight)
GO

CREATE INDEX NumericWeight ON t_trxtypes(NumericWeight)
GO

CREATE INDEX IX_t_version ON t_version(ElementID)
GO

CREATE INDEX XRefClient ON t_xref(Client)
GO

CREATE INDEX XRefSupplier ON t_xref(Supplier)
GO

CREATE INDEX XRefType ON t_xref(Type)
GO

CREATE INDEX XRefNME ON t_xref(Name)
GO