----------------------------------------------
-- Enterprise Architect Schema Script 
-- DBMS:     Adaptive Server Anywhere
--			 SQL Anywhere 
-- VERSION:  8 to 11                        
-- CREATED:  21/1/2010 			
-- EA BUILD: 852	  
----------------------------------------------
-- 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
----------------------------------------------
-- 
-- t_attribute
--
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 ,
	CONSTRAINT pk_attribute
	    PRIMARY KEY (ID)
) 
GO
CREATE INDEX ix_attribute_Name ON t_attribute(Name)
GO
CREATE INDEX ix_attribute_Object_ID ON t_attribute(Object_ID)
GO
CREATE INDEX ix_attribute_Classifier ON t_attribute(Classifier)
GO
CREATE UNIQUE INDEX ux_attribute_ea_guid ON t_attribute(ea_guid)
GO
CREATE INDEX ix_attribute_Type ON t_attribute(Type)
GO

-- 
-- t_attributeconstraints
--
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 ,
	CONSTRAINT pk_attributeconstraints  
	    PRIMARY KEY ("Constraint", ID)
) 
GO

--
-- t_attributetag
--
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 ,
	CONSTRAINT pk_attributetag
	    PRIMARY KEY (PropertyID)
) 
GO
CREATE INDEX ix_attributetag_ElementID ON t_attributetag(ElementID)
GO
CREATE INDEX ix_attributetag_VALUE ON t_attributetag(VALUE)
GO

--
-- t_authors
--
CREATE TABLE t_authors (
	AuthorName  varchar (255) NOT NULL ,
	Roles       varchar (255) NULL ,
	Notes       varchar (255) NULL ,
	CONSTRAINT pk_authors  
	    PRIMARY KEY (AuthorName)
)
GO

--
-- t_cardinality
--
CREATE TABLE t_cardinality (
	Cardinality varchar (50) NOT NULL ,
	CONSTRAINT pk_cardinality
	    PRIMARY KEY (Cardinality)
)
GO

--
-- t_category
--
CREATE TABLE t_category (
	CategoryID  int NOT NULL DEFAULT AUTOINCREMENT ,
	Name        varchar (255) NULL ,
	Type        varchar (255) NULL ,
	NOTES       text NULL ,
	CONSTRAINT pk_category
	    PRIMARY KEY (CategoryID)
) 
GO

--
-- t_clients
--
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 ,
	CONSTRAINT pk_clients
	    PRIMARY KEY (Name)
)
GO

--
-- t_complexitytypes
--
CREATE TABLE t_complexitytypes (
	Complexity    varchar (50) NOT NULL ,
	NumericWeight int NULL DEFAULT 0 ,
	CONSTRAINT pk_complexitytypes
	    PRIMARY KEY (Complexity) 
)
GO
CREATE INDEX ix_complexitytypes_NumericWeight ON t_complexitytypes(NumericWeight)
GO

--
-- t_connector
--
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 (255) 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 (255) 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         varchar(255) NULL ,
	IsSignal            int NOT NULL DEFAULT 0 ,
	IsStimulus          int NOT NULL DEFAULT 0 ,
	DispatchAction      varchar(255) NULL ,
	Target2             int NULL ,
	StyleEx             text NULL ,
	SourceStereotype    varchar (255) NULL ,
	DestStereotype      varchar (255) NULL ,
	SourceStyle         text NULL ,
	DestStyle           text NULL ,
	EventFlags          varchar(255) NULL,
	CONSTRAINT pk_connector 
	    PRIMARY KEY (Connector_ID) 
) 
GO
CREATE INDEX ix_connector_Connector_Type ON t_connector(Connector_Type)
GO
CREATE INDEX ix_connector_Start_Object_ID ON t_connector(Start_Object_ID)
GO
CREATE INDEX ix_connector_End_Object_ID ON t_connector(End_Object_ID)
GO
CREATE INDEX ix_connector_DiagramID ON t_connector(DiagramID)
GO
CREATE UNIQUE INDEX ux_connector_ea_guid ON t_connector(ea_guid)
GO
CREATE INDEX ix_connector_styylex ON t_connector(StyleEx)
GO
CREATE INDEX ix_connector_seqno ON t_connector(SeqNo)
GO
CREATE INDEX ix_connector_end_connid ON t_connector(End_Object_ID, Connector_ID)
GO
CREATE INDEX ix_connector_start_connid ON t_connector(Start_Object_ID, Connector_ID)
GO

--
-- t_connectorconstraint
--
CREATE TABLE t_connectorconstraint (
	ConnectorID     int NOT NULL DEFAULT 0 ,
	"Constraint"    varchar (255) NOT NULL ,
	ConstraintType  varchar (50) NULL ,
	Notes           text NULL,
	CONSTRAINT pk_connectorconstraint 
	    PRIMARY KEY (ConnectorID, "Constraint") 
) 
GO
CREATE INDEX ix_connectorconstraint_Constraint ON t_connectorconstraint("Constraint")
GO
CREATE INDEX ix_connectorconstraint_ConnectorID ON t_connectorconstraint(ConnectorID)
GO

--
-- t_connectortag
--
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 ,
	CONSTRAINT pk_connectortag  
	    PRIMARY KEY (PropertyID)
) 
GO
CREATE INDEX ix_connectortag_ElementID ON t_connectortag(ElementID)
GO
CREATE INDEX ix_connectortag_Property ON t_connectortag(Property)
GO
CREATE INDEX ix_connectortag_VALUE ON t_connectortag(VALUE)
GO

--
-- t_connectortypes
--
CREATE TABLE t_connectortypes (
	Connector_Type  varchar (50) NOT NULL ,
	Description     varchar (50) NULL ,
	CONSTRAINT pk_connectortypes  
	    PRIMARY KEY (Connector_Type)
)
GO

--
-- t_constants
--
CREATE TABLE t_constants (
	ConstantName  varchar (50) NOT NULL ,
	ConstantValue varchar (255) NULL ,
	CONSTRAINT pk_constants  
	    PRIMARY KEY (ConstantName),
)
GO

--
-- t_constrainttypes
--
CREATE TABLE t_constrainttypes (
	"Constraint" varchar (16) NOT NULL ,
	Description  varchar (50) NULL ,
	Notes        text NULL ,
	CONSTRAINT pk_constrainttypes  
	    PRIMARY KEY ("Constraint")
) 
GO

--
-- t_datatypes
--
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 ,
	CONSTRAINT pk_datatypes  
	    PRIMARY KEY (DatatypeID)
)
GO
CREATE INDEX ix_datatypes_ProductName ON t_datatypes(ProductName)
GO
CREATE INDEX ix_datatypes_Datatype ON t_datatypes(Datatype)
GO

--
-- t_diagram
--
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 ,
	CONSTRAINT pk_diagram  
	    PRIMARY KEY (Diagram_ID)
) 
GO
CREATE INDEX ix_diagram_Diagram_Type ON t_diagram(Diagram_Type)
GO
CREATE UNIQUE INDEX ux_t_diagram_ea_guid ON t_diagram(ea_guid)
GO
CREATE INDEX ix_diagram_Package_ID ON t_diagram(Package_ID)
GO
CREATE INDEX ix_diagram_ParentID ON t_diagram(ParentID)
GO

--
-- t_diagramlinks
--
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 ,
	CONSTRAINT pk_diagramlinks  
	    PRIMARY KEY (Instance_ID)
) 
GO
CREATE INDEX ix_t_diagramlinks_ConnectorID ON t_diagramlinks(ConnectorID)
GO
CREATE INDEX ix_diagramlinks_DiagramID ON t_diagramlinks(DiagramID)
GO

--
-- t_diagramobjects
--
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 ,
	CONSTRAINT pk_diagramobjects  
	    PRIMARY KEY (Instance_ID)
)
GO
CREATE INDEX ix_diagramobjects_DiagramID ON t_diagramobjects(Diagram_ID)
GO
CREATE INDEX ix_diagramobjects_ObjectID ON t_diagramobjects(Object_ID)
GO

--
-- t_diagramtypes
--
CREATE TABLE t_diagramtypes (
	Diagram_Type varchar (50) NOT NULL ,
	Name         varchar (255) NULL ,
	Package_ID   int NULL DEFAULT 0 ,
	CONSTRAINT pk_diagramtypes  
	    PRIMARY KEY (Diagram_Type)
)
GO

--
-- t_document
--
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 ,
	CONSTRAINT pk_document  
	    PRIMARY KEY (DocID)
) 
GO
CREATE INDEX ix_document_ElementID ON t_document(ElementID)
GO

--
-- t_ecf
--
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 ,
	CONSTRAINT pk_ecf  
	    PRIMARY KEY (ECFID)
)
GO
CREATE INDEX ix_ecf_Weight ON t_ecf(Weight)
GO

--
-- t_efforttypes
--
CREATE TABLE t_efforttypes (
	EffortType    varchar (12) NOT NULL ,
	Description   varchar (255) NULL ,
	NumericWeight float NULL DEFAULT 0 ,
	Notes         varchar (255) NULL ,
	CONSTRAINT pk_efforttypes  
	    PRIMARY KEY (EffortType)
)
GO
CREATE INDEX ix_efforttypes_NumericWeight ON t_efforttypes(NumericWeight)
GO

--
-- t_files
--
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 ,
	CONSTRAINT pk_files 
	    PRIMARY KEY (FileID)
) 
GO

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

--
-- t_glossary
--
CREATE TABLE t_glossary (
	Term        varchar (255) NULL ,
	Type        varchar (255) NULL ,
	Meaning     text NULL ,
	GlossaryID  int NOT NULL DEFAULT AUTOINCREMENT ,
	CONSTRAINT pk_glossary  
	    PRIMARY KEY (GlossaryID)
) 
GO

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

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

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

--
-- t_issues
--
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 (50) NULL ,
	Severity     varchar (50) NULL ,
	IssueType    varchar (100) NULL ,
	CONSTRAINT pk_issues  
	    PRIMARY KEY (IssueID)
) 
GO

--
-- t_lists
--
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 ,
	CONSTRAINT pk_lists  
	    PRIMARY KEY (ListID)
) 
GO

--
-- t_mainttypes
--
CREATE TABLE t_mainttypes (
	MaintType     varchar (12) NOT NULL ,
	Description   varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes         varchar (255) NULL ,
	CONSTRAINT pk_mainttypes  
	    PRIMARY KEY (MaintType)
)
GO
CREATE INDEX ix_mainttypes_NumericWeight ON t_mainttypes(NumericWeight)
GO

--
-- t_method
--
CREATE TABLE t_method (
	Object_ID int NOT NULL DEFAULT 0 ,
	Name      varchar (255) NOT NULL ,
	Scope     varchar (50) NULL ,
	Type      varchar (50) NULL ,
	CONSTRAINT pk_method  
	    PRIMARY KEY (Object_ID, Name),
)
GO
CREATE INDEX ix_method_Object_ID ON t_method(Object_ID)
GO

--
-- t_metrictypes
--
CREATE TABLE t_metrictypes (
	Metric        varchar (12) NOT NULL ,
	Description   varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes         varchar (255) NULL ,
	CONSTRAINT pk_metrictypes  
	    PRIMARY KEY (Metric)
)
GO
CREATE INDEX ix_metrictypes_NumericWeight ON t_metrictypes(NumericWeight)
GO

--
-- t_object
--
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          varchar(255) 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      varchar(255) NULL ,
	PackageFlags    varchar(255) NULL ,
	Multiplicity    varchar (50) NULL ,
	StyleEx         text NULL ,
	EventFlags      varchar(255) NULL ,
	ActionFlags     varchar(255) NULL ,
	CONSTRAINT pk_object  
	    PRIMARY KEY (Object_ID)
) 
GO
CREATE UNIQUE INDEX ux_object_ea_guid ON t_object(ea_guid)
GO
CREATE INDEX ix_object_Package_ID ON t_object(Package_ID)
GO
CREATE INDEX ix_object_PDATA1 ON t_object(PDATA1)
GO
CREATE INDEX ix_object_ParentID ON t_object(ParentID)
GO
CREATE INDEX ix_object_Classifier_guid ON t_object(Classifier_guid)
GO
CREATE INDEX ix_object_Classifier ON t_object(Classifier)
GO
CREATE INDEX ix_object_NType ON t_object(NType)
GO
CREATE INDEX ix_object_GenLinks ON t_object(GenLinks)
GO
CREATE INDEX ix_object_Name ON t_object(Name)
GO
CREATE INDEX ix_object_object_type ON t_object(Object_Type)
GO
CREATE INDEX ix_object_eventflags ON t_object(EventFlags)
GO
CREATE INDEX ix_object_pkgid_pd1_classifier ON t_object(Package_ID, PDATA1, Classifier)
GO

--
-- t_objectconstraint
--
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 ,
	CONSTRAINT pk_objectconstraint  
	    PRIMARY KEY (Object_ID, "Constraint", ConstraintType)
) 
GO
CREATE INDEX ix_objectconstraint_Constraint ON t_objectconstraint("Constraint")
GO
CREATE INDEX ix_objectconstraint_Object_ID ON t_objectconstraint(Object_ID)
GO

--
-- t_objecteffort
--
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 ,
	CONSTRAINT pk_objecteffort  
	    PRIMARY KEY (Object_ID, Effort)
) 
GO
CREATE INDEX ix_objecteffort_Object_ID ON t_objecteffort(Object_ID)
GO

--
-- t_objectfiles
--
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 ,
	CONSTRAINT pk_objectfiles  
	    PRIMARY KEY (Object_ID, FileName)
) 
GO

--
-- t_objectmetrics
--
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 ,
	CONSTRAINT pk_objectmetrics  
	    PRIMARY KEY (Object_ID, Metric)
) 
GO
CREATE INDEX ix_objectmetrics_MetricType ON t_objectmetrics(MetricType)
GO
CREATE INDEX ix_objectmetrics_Object_ID ON t_objectmetrics(Object_ID)
GO
CREATE INDEX ix_objectmetrics_Metric ON t_objectmetrics(Metric)
GO

--
-- t_objectproblems
--
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 (50) NULL ,
	Severity      varchar (50) NULL ,
	CONSTRAINT pk_objectproblems  
	    PRIMARY KEY (Object_ID, Problem, ProblemType)
) 
GO
CREATE INDEX ix_objectproblems_Object_ID ON t_objectproblems(Object_ID)
GO
CREATE INDEX ix_objectproblems_Problem ON t_objectproblems(Problem)
GO

--
-- t_objectproperties
--
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 ,
	CONSTRAINT pk_objectproperties  
	    PRIMARY KEY (PropertyID)
) 
GO
CREATE INDEX ix_objectproperties_Object_ID ON t_objectproperties(Object_ID)
GO
CREATE INDEX ix_objectproperties_Value ON t_objectproperties(Value)
GO

--
-- t_objectrequires
--
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() ,
	CONSTRAINT pk_objectrequires  
	    PRIMARY KEY (ReqID)
) 
GO
CREATE INDEX ix_objectrequires_Object_ID ON t_objectrequires(Object_ID)
GO
CREATE INDEX ix_objectrequires_Requirement ON t_objectrequires(Requirement)
GO

--
-- t_objectresource
--
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 ,
	CONSTRAINT pk_objectresource  
	    PRIMARY KEY (Object_ID, "Resource", Role)
) 
GO
CREATE INDEX ix_objectresource_Object_ID ON t_objectresource(Object_ID)
GO

--
-- t_objectrisks
--
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 ,
	CONSTRAINT pk_objectrisks  
	    PRIMARY KEY (Object_ID, Risk)
) 
GO
CREATE INDEX ix_objectrisks_Object_ID ON t_objectrisks(Object_ID)
GO

--
-- t_objectscenarios
--
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 ,
	CONSTRAINT pk_objectscenarios  
	    PRIMARY KEY (Object_ID, Scenario)
) 
GO
CREATE INDEX ix_objectscenarios_Object_ID ON t_objectscenarios(Object_ID)
GO
CREATE INDEX ix_objectscenarios_oidevalscen ON t_objectscenarios(Object_ID, EValue, Scenario)
GO

--
-- t_objecttests
--
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 ,
	CONSTRAINT pk_objecttests  
	    PRIMARY KEY (Object_ID, Test, TestClass)
) 
GO
CREATE INDEX ix_objecttests_Object_ID ON t_objecttests(Object_ID)
GO

--
-- t_objecttrx
--
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 ,
	CONSTRAINT pk_objecttrx  
	    PRIMARY KEY (Object_ID, TRX, TRXType)
) 
GO
CREATE INDEX ix_objecttrx_Object_ID ON t_objecttrx(Object_ID)
GO
CREATE INDEX ix_objecttrx_TRX ON t_objecttrx(TRX)
GO

--
-- t_objecttypes
--
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 ,
	CONSTRAINT pk_objecttypes  
	    PRIMARY KEY (Object_Type)
)
GO
CREATE INDEX ix_objectobjecttypes_ImageID ON t_objecttypes(ImageID)
GO

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

--
-- t_operation
--
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 ,
	CONSTRAINT pk_operation  
	    PRIMARY KEY (OperationID)
) 
GO
CREATE INDEX ix_operation_Name ON t_operation(Name)
GO
CREATE INDEX ix_operation_Object_ID ON t_operation(Object_ID)
GO
CREATE UNIQUE INDEX ux_operation_ea_guid ON t_operation(ea_guid)
GO

--
-- t_operationparams
--
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 ,
	CONSTRAINT pk_operationparams  
	    PRIMARY KEY (OperationID, Name)
) 
GO
CREATE INDEX ix_operationparams_OperationID ON t_operationparams(OperationID)
GO
CREATE INDEX ix_operationparams_OpID_Pos ON t_operationparams(OperationID, Pos)
GO
CREATE INDEX ix_operationparams_Classifier ON t_operationparams(Classifier)
GO
CREATE UNIQUE INDEX ux_operationparams_ea_guid ON t_operationparams(ea_guid)
GO

--
-- t_operationposts
--
CREATE TABLE t_operationposts (
	OperationID     int NOT NULL DEFAULT 0 ,
	PostCondition   varchar (255) NOT NULL ,
	Type            varchar (255) NULL ,
	Notes           text NULL ,
	CONSTRAINT pk_operationposts  
	    PRIMARY KEY (OperationID, PostCondition) 
) 
GO
CREATE INDEX ix_operationposts_OperationID ON t_operationposts(OperationID)
GO

--
-- t_operationpres
--
CREATE TABLE t_operationpres (
	OperationID  int NOT NULL DEFAULT 0 ,
	PreCondition varchar (255) NOT NULL ,
	Type         varchar (50) NULL ,
	Notes        text NULL ,
	CONSTRAINT pk_operationpres  
	    PRIMARY KEY (OperationID, PreCondition)
) 
GO
CREATE INDEX ix_operationpres_OperationID ON t_operationpres(OperationID)
GO

--
-- t_operationtag
--
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 ,
	CONSTRAINT pk_operationtag
	    PRIMARY KEY (PropertyID)
) 
GO
CREATE INDEX ix_operationtag_ElementIDID ON t_operationtag(ElementID)
GO
CREATE INDEX ix_operationtag_VALUE ON t_operationtag(VALUE)
GO

--
-- t_package
--
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 ,
	CONSTRAINT pk_package
	    PRIMARY KEY (Package_ID)
) 
GO
CREATE UNIQUE INDEX ux_package_ea_guid ON t_package(ea_guid)
GO
CREATE INDEX ix_package_ParentID ON t_package(Parent_ID)
GO
CREATE INDEX ix_package_Name ON t_package(Name)
GO

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

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

--
-- t_phase
--
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 ,
	CONSTRAINT pk_phase
	    PRIMARY KEY (PhaseID)
) 
GO

--
-- t_primitives
--
CREATE TABLE t_primitives (
	Datatype    varchar (50) NOT NULL ,
	Description varchar (50) NULL ,
	CONSTRAINT pk_primitives  
	    PRIMARY KEY (Datatype)
)
GO

--
-- t_problemtypes
--
CREATE TABLE t_problemtypes (
	ProblemType   varchar (12) NOT NULL ,
	Description   varchar (255) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes         varchar (255) NULL ,
	CONSTRAINT pk_problemtypes
	    PRIMARY KEY (ProblemType)
)
GO
CREATE INDEX ix_problemtypes_NumericWeight ON t_problemtypes(NumericWeight)
GO

--
-- t_projectroles
--
CREATE TABLE t_projectroles (
	Role        varchar (255) NOT NULL ,
	Description varchar (255) NULL ,
	Notes       text NULL ,
	CONSTRAINT pk_projectroles
	    PRIMARY KEY (Role)
) 
GO

--
-- t_propertytypes
--
CREATE TABLE t_propertytypes (
	Property    varchar (50) NOT NULL ,
	Description varchar (50) NULL ,
	Notes       text NULL ,
	CONSTRAINT pk_propertytypes
	    PRIMARY KEY (Property)
) 
GO

--
-- t_requiretypes
--
CREATE TABLE t_requiretypes (
	Requirement   varchar (12) NOT NULL ,
	Description   varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes         varchar (255) NULL ,
	CONSTRAINT pk_requiretypes
	    PRIMARY KEY (Requirement)
)
GO
CREATE INDEX ix_requiretypes_NumericWeight ON t_requiretypes(NumericWeight)
GO

--
-- t_resources
--
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 ,
	CONSTRAINT pk_resources
	    PRIMARY KEY (Name)
)
GO

--
-- t_risktypes
--
CREATE TABLE t_risktypes (
	Risk          varchar (12) NOT NULL ,
	Description   varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 0 ,
	Notes         varchar (255) NULL ,
	CONSTRAINT pk_risktypes
	    PRIMARY KEY (Risk)
)
GO
CREATE INDEX ix_risktypes_NumericWeight ON t_risktypes(NumericWeight)
GO

--
-- t_roleconstraint
--
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 ,
	CONSTRAINT pk_roleconstraint
	    PRIMARY KEY (ConnectorID, "Constraint", ConnectorEnd, ConstraintType)	
) 
GO
CREATE INDEX ix_roleconstraint_Constraint ON t_roleconstraint("Constraint")
GO
CREATE INDEX ix_roleconstraint_ConnectorID ON t_roleconstraint(ConnectorID)
GO

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

--
-- t_rtfreport
--
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 ,
	CONSTRAINT pk_rtfreport
	    PRIMARY KEY (TemplateID)	
) 
GO

--
-- t_rules
--
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 ,
	CONSTRAINT pk_rules
	    PRIMARY KEY (RuleID)
) 
GO

--
-- t_scenariotypes
--
CREATE TABLE t_scenariotypes (
	ScenarioType  varchar (12) NOT NULL ,
	Description   varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes         varchar (255) NULL ,
	CONSTRAINT pk_scenariotypes
	    PRIMARY KEY (ScenarioType)
)
GO
CREATE INDEX ix_scenariotypes_NumericWeight ON t_scenariotypes(NumericWeight)
GO

--
-- t_script
--
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

--
-- t_secgroup
--
CREATE TABLE t_secgroup (
	GroupID     varchar (40) NOT NULL ,
	GroupName   varchar (32) NOT NULL ,
	Description varchar (100) NULL ,
	CONSTRAINT pk_secgroup
	    PRIMARY KEY (GroupID)
)
GO

--
-- t_secgrouppermission
--
CREATE TABLE t_secgrouppermission (
	GroupID      varchar (40) NOT NULL ,
	PermissionID int NOT NULL ,
	CONSTRAINT pk_secgrouppermission
	    PRIMARY KEY (GroupID, PermissionID)
)
GO

--
-- t_seclocks
--
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 ,
	CONSTRAINT pk_seclocks
	    PRIMARY KEY (EntityID)
)
GO

--
-- t_secpermission
--
CREATE TABLE t_secpermission (
	PermissionID    int NOT NULL ,
	PermissionName  varchar (50) NOT NULL ,
	CONSTRAINT pk_secpermission
	    PRIMARY KEY (PermissionID)
)
GO

--
-- t_secpolicies
--
CREATE TABLE t_secpolicies (
	Property varchar (100) NOT NULL ,
	Value    varchar (255) NOT NULL ,
	CONSTRAINT pk_secpolicies
	    PRIMARY KEY (Property)
)
GO

--
-- t_secuser
--
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 ,
	CONSTRAINT pk_secuser
	    PRIMARY KEY (UserID)
)
GO

--
-- t_secusergroup
--
CREATE TABLE t_secusergroup (
	UserID  varchar (40) NOT NULL ,
	GroupID varchar (40) NOT NULL ,
	CONSTRAINT pk_secusergroup
	    PRIMARY KEY (UserID, GroupID)
)
GO

--
-- t_secuserpermission
--
CREATE TABLE t_secuserpermission (
	UserID       varchar (40) NOT NULL ,
	PermissionID int NOT NULL ,
	CONSTRAINT pk_secuserpermission
	    PRIMARY KEY (UserID, PermissionID)
)
GO

--
-- t_snapshot
--
CREATE TABLE t_snapshot (
	SnapshotID   varchar (40) NOT NULL ,
	SeriesID     varchar (40) NOT NULL ,
	Position int NOT NULL ,
	SnapshotName varchar (100) NOT NULL ,
	Notes        text NULL ,
	Style        varchar (255) NULL ,
	ElementID    varchar (40) NOT NULL ,
	ElementType  varchar (50) NOT NULL ,
	StrContent   text NULL ,
	BinContent1  image NULL ,
	BinContent2  image NULL ,
	CONSTRAINT pk_snapshot
	    PRIMARY KEY (SnapshotID)
) 
GO

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

--
-- t_stereotypes
--
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 ,
	CONSTRAINT pk_stereotypes
	    PRIMARY KEY (Stereotype, AppliesTo)
) 
GO
CREATE INDEX ix_stereotypes_Stereotype ON t_stereotypes(Stereotype)
GO

--
-- t_taggedvalue
--
CREATE TABLE t_taggedvalue (
	PropertyID varchar (40) NOT NULL ,
	ElementID  varchar (40) NOT NULL ,
	BaseClass  varchar (100) NOT NULL ,
	TagValue   text NULL ,
	Notes      text NULL ,
	CONSTRAINT pk_taggedvalue
	    PRIMARY KEY (PropertyID)
) 
GO
CREATE INDEX ix_taggedvalue_ElementID ON t_taggedvalue(ElementID)
GO

--
-- t_tasks
--
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 (100) NULL ,
	CONSTRAINT pk_tasks
	    PRIMARY KEY (TaskID)
) 
GO

--
-- t_tcf
--
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 ,
	CONSTRAINT pk_tcf
	    PRIMARY KEY (TCFID)
)
GO
CREATE INDEX ix_tcf_Weight ON t_tcf(Weight)
GO

--
-- t_template
--
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 ,
	CONSTRAINT pk_template
	    PRIMARY KEY (TemplateID)
) 
GO

--
-- t_testclass
--
CREATE TABLE t_testclass (
	TestClass   varchar (50) NOT NULL ,
	Description varchar (50) NULL ,
	CONSTRAINT pk_testclass
	    PRIMARY KEY (TestClass)
)
GO

--
-- t_testplans
--
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 ,
	CONSTRAINT pk_testplans
	    PRIMARY KEY (PlanID)
) 
GO

--
-- t_testtypes
--
CREATE TABLE t_testtypes (
	TestType      varchar (12) NOT NULL ,
	Description   varchar (50) NULL ,
	NumericWeight float NULL DEFAULT 1 ,
	Notes         varchar (255) NULL ,
	CONSTRAINT pk_testtypes
	    PRIMARY KEY (TestType)
)
GO
CREATE INDEX ix_testtypes_NumericWeight ON t_testtypes(NumericWeight)
GO

--
-- t_trxtypes
--
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 ,
	CONSTRAINT pk_trxtypes
	    PRIMARY KEY (TRX_ID)
) 
GO
CREATE INDEX ix_trxtypes_NumericWeight ON t_trxtypes(NumericWeight)
GO

--
-- t_umlpattern
--
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 ,
	CONSTRAINT pk_umlpattern
	    PRIMARY KEY (PatternID)	
) 
GO

--
-- t_version
--
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 ,
	CONSTRAINT pk_version
	    PRIMARY KEY (ElementID, VersionID)	
) 
GO
CREATE INDEX ix_version_ElementID ON t_version(ElementID)
GO

--
-- t_xref
--
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 ,
	CONSTRAINT pk_xref
	    PRIMARY KEY (XrefID)
) 
GO
CREATE INDEX ix_ref_Client ON t_xref(Client)
GO
CREATE INDEX ix_ref_Supplier ON t_xref(Supplier)
GO
CREATE INDEX ix_ref_Type ON t_xref(Type)
GO
CREATE INDEX ix_xref_Name ON t_xref(Name)
GO

--
-- t_xrefsystem
--
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 ,
	CONSTRAINT pk_xrefsystem
	    PRIMARY KEY (XrefID)
) 
GO
CREATE INDEX ix_xrefsystem_Client ON t_xrefsystem(Client)
GO
CREATE INDEX ix_xrefsystem_Supplier ON t_xrefsystem(Supplier)
GO
CREATE INDEX ix_xrefsystem_Type ON t_xrefsystem(Type)
GO

--
-- t_xrefuser
--
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 ,
	CONSTRAINT pk_xrefuser
	    PRIMARY KEY (XrefID)
) 
GO
CREATE INDEX ix_xrefuser_Client ON t_xrefuser(Client)
GO
CREATE INDEX ix_xrefuser_Supplier ON t_xrefuser(Supplier)
GO
CREATE INDEX ix_xrefuser_Type ON t_xrefuser(Type)
GO

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

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

--
-- usysTables
--
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 ,
	CONSTRAINT pk_usysTables
	    PRIMARY KEY (TableName)
)
GO

--
-- usys_system
--
CREATE TABLE usys_system (
	Property  varchar (50) NOT NULL ,
	Value     varchar (50) NULL ,
	CONSTRAINT pk_usys_system
	    PRIMARY KEY (Property)
)
GO