在使用Enterprise Architect進行模組化時,有時需要進行協同工作,這裡我們使用連接配接到資料庫伺服器功能。
下面就是資料庫的建表語句:
/* Create Tables */
CREATE TABLE `t_attribute`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Name` VARCHAR(255) NOT NULL,
`Scope` VARCHAR(50) ,
`Stereotype` VARCHAR(50) ,
`Containment` VARCHAR(50) ,
`IsStatic` INT DEFAULT 0,
`IsCollection` INT DEFAULT 0,
`IsOrdered` INT DEFAULT 0,
`AllowDuplicates` INT DEFAULT 0,
`LowerBound` VARCHAR(50) ,
`UpperBound` VARCHAR(50) ,
`Container` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
`Derived` CHAR(1) ,
`ID` INT NOT NULL AUTO_INCREMENT,
`Pos` INT ,
`GenOption` MEDIUMTEXT ,
`Length` INT ,
`Precision` INT ,
`Scale` INT ,
`Const` INT ,
`Style` VARCHAR(255) ,
`Classifier` VARCHAR(50) ,
`Default` MEDIUMTEXT ,
`Type` VARCHAR(255) ,
`ea_guid` VARCHAR(50) NOT NULL,
`StyleEx` MEDIUMTEXT ,
CONSTRAINT `pk_attribute` PRIMARY KEY (`ID` ASC),
CONSTRAINT `uq_attribute_eaguid` UNIQUE (`ea_guid` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_attribute`
ADD INDEX `ix_attribute_classifier` (`Classifier` ASC)
;
ALTER TABLE `t_attribute`
ADD INDEX `ix_attribute_name` (`Name` ASC)
;
ALTER TABLE `t_attribute`
ADD INDEX `ix_attribute_objectid` (`Object_ID` ASC)
;
ALTER TABLE `t_attribute`
ADD INDEX `ix_attribute_type` (`Type` ASC)
;
CREATE TABLE `t_attributeconstraints`
(
`Object_ID` INT DEFAULT 0,
`Constraint` VARCHAR(255) NOT NULL,
`AttName` VARCHAR(255) ,
`Type` VARCHAR(255) ,
`Notes` MEDIUMTEXT ,
`ID` INT NOT NULL DEFAULT 0,
CONSTRAINT `pk_attributeconstraints` PRIMARY KEY (`ID` ASC, `Constraint` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_attributeconstraints`
ADD INDEX `ix_attributeconstraints_objid` (`Object_ID` ASC)
;
CREATE TABLE `t_attributetag`
(
`PropertyID` INT NOT NULL AUTO_INCREMENT,
`ElementID` INT NOT NULL DEFAULT 0,
`Property` VARCHAR(255) ,
`VALUE` VARCHAR(255) ,
`NOTES` MEDIUMTEXT ,
`ea_guid` VARCHAR(40) ,
CONSTRAINT `pk_attributetag` PRIMARY KEY (`PropertyID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_attributetag`
ADD INDEX `ix_attributetag_elementid` (`ElementID` ASC)
;
ALTER TABLE `t_attributetag`
ADD INDEX `ix_attributetag_value` (`VALUE` ASC)
;
ALTER TABLE `t_attributetag`
ADD INDEX `ix_attributetag_property` (`Property` ASC)
;
ALTER TABLE `t_attributetag`
ADD INDEX `ix_attributetag_elementidprop` (`ElementID` ASC, `Property` ASC)
;
ALTER TABLE `t_attributetag`
ADD INDEX `ix_attributetag_eaguid` (`ea_guid` ASC)
;
CREATE TABLE `t_authors`
(
`AuthorName` VARCHAR(255) NOT NULL,
`Roles` VARCHAR(255) ,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_authors` PRIMARY KEY (`AuthorName` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_cardinality`
(
`Cardinality` VARCHAR(50) NOT NULL,
CONSTRAINT `pk_cardinality` PRIMARY KEY (`Cardinality` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_category`
(
`CategoryID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) ,
`Type` VARCHAR(255) ,
`NOTES` MEDIUMTEXT ,
CONSTRAINT `pk_category` PRIMARY KEY (`CategoryID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_clients`
(
`Name` VARCHAR(255) NOT NULL,
`Organisation` VARCHAR(255) ,
`Phone1` VARCHAR(50) ,
`Phone2` VARCHAR(50) ,
`Mobile` VARCHAR(50) ,
`Fax` VARCHAR(50) ,
`Email` VARCHAR(50) ,
`Roles` VARCHAR(255) ,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_clients` PRIMARY KEY (`Name` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_complexitytypes`
(
`Complexity` VARCHAR(50) NOT NULL,
`NumericWeight` INT NOT NULL DEFAULT 0,
CONSTRAINT `pk_complexitytypes` PRIMARY KEY (`Complexity` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_complexitytypes`
ADD INDEX `ix_complexitytypes_numweight` (`NumericWeight` ASC)
;
CREATE TABLE `t_connector`
(
`Connector_ID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) ,
`Direction` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
`Connector_Type` VARCHAR(50) NOT NULL,
`SubType` VARCHAR(50) ,
`SourceCard` VARCHAR(50) ,
`SourceAccess` VARCHAR(50) ,
`SourceElement` VARCHAR(50) ,
`DestCard` VARCHAR(50) ,
`DestAccess` VARCHAR(50) ,
`DestElement` VARCHAR(50) ,
`SourceRole` VARCHAR(255) ,
`SourceRoleType` VARCHAR(50) ,
`SourceRoleNote` MEDIUMTEXT ,
`SourceContainment` VARCHAR(50) ,
`SourceIsAggregate` INT DEFAULT 0,
`SourceIsOrdered` INT DEFAULT 0,
`SourceQualifier` VARCHAR(50) ,
`DestRole` VARCHAR(255) ,
`DestRoleType` VARCHAR(50) ,
`DestRoleNote` MEDIUMTEXT ,
`DestContainment` VARCHAR(50) ,
`DestIsAggregate` INT DEFAULT 0,
`DestIsOrdered` INT DEFAULT 0,
`DestQualifier` VARCHAR(50) ,
`Start_Object_ID` INT NOT NULL DEFAULT 0,
`End_Object_ID` INT NOT NULL DEFAULT 0,
`Top_Start_Label` VARCHAR(50) ,
`Top_Mid_Label` VARCHAR(50) ,
`Top_End_Label` VARCHAR(50) ,
`Btm_Start_Label` VARCHAR(50) ,
`Btm_Mid_Label` VARCHAR(50) ,
`Btm_End_Label` VARCHAR(50) ,
`Start_Edge` INT DEFAULT 0,
`End_Edge` INT DEFAULT 0,
`PtStartX` INT DEFAULT 0,
`PtStartY` INT DEFAULT 0,
`PtEndX` INT DEFAULT 0,
`PtEndY` INT DEFAULT 0,
`SeqNo` INT DEFAULT 0,
`HeadStyle` INT DEFAULT 0,
`LineStyle` INT DEFAULT 0,
`RouteStyle` INT DEFAULT 0,
`IsBold` INT DEFAULT 0,
`LineColor` INT DEFAULT 0,
`Stereotype` VARCHAR(50) ,
`VirtualInheritance` CHAR(1) ,
`LinkAccess` VARCHAR(50) ,
`PDATA1` VARCHAR(255) ,
`PDATA2` MEDIUMTEXT ,
`PDATA3` VARCHAR(255) ,
`PDATA4` VARCHAR(255) ,
`PDATA5` MEDIUMTEXT ,
`DiagramID` INT DEFAULT 0,
`ea_guid` VARCHAR(40) NOT NULL,
`SourceConstraint` VARCHAR(255) ,
`DestConstraint` VARCHAR(255) ,
`SourceIsNavigable` INT ,
`DestIsNavigable` INT ,
`IsRoot` INT ,
`IsLeaf` INT ,
`IsSpec` INT ,
`SourceChangeable` VARCHAR(12) ,
`DestChangeable` VARCHAR(12) ,
`SourceTS` VARCHAR(12) ,
`DestTS` VARCHAR(12) ,
`StateFlags` MEDIUMTEXT ,
`ActionFlags` VARCHAR(255) ,
`IsSignal` INT ,
`IsStimulus` INT ,
`DispatchAction` VARCHAR(255) ,
`Target2` INT ,
`StyleEx` MEDIUMTEXT ,
`SourceStereotype` VARCHAR(255) ,
`DestStereotype` VARCHAR(255) ,
`SourceStyle` MEDIUMTEXT ,
`DestStyle` MEDIUMTEXT ,
`EventFlags` VARCHAR(255) ,
CONSTRAINT `pk_connector` PRIMARY KEY (`Connector_ID` ASC),
CONSTRAINT `uq_connector_eaguid` UNIQUE (`ea_guid` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_connectortype` (`Connector_Type` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_diagramid` (`DiagramID` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_endobjidconnid` (`End_Object_ID` ASC, `Connector_ID` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_endobjectid` (`End_Object_ID` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_seqno` (`SeqNo` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_startobjidconnid` (`Start_Object_ID` ASC, `Connector_ID` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_startobjectid` (`Start_Object_ID` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_pdata1` (`PDATA1` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_subtype` (`SubType` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_styleex` (`StyleEx`(255) ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_pdata3` (`PDATA3` ASC)
;
ALTER TABLE `t_connector`
ADD INDEX `ix_connector_pdata5` (`PDATA5`(255) ASC)
;
CREATE TABLE `t_connectorconstraint`
(
`ConnectorID` INT NOT NULL DEFAULT 0,
`Constraint` VARCHAR(255) NOT NULL,
`ConstraintType` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_connectorconstraint` PRIMARY KEY (`ConnectorID` ASC, `Constraint` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_connectorconstraint`
ADD INDEX `ix_connectorconstraint_constr` (`Constraint` ASC)
;
ALTER TABLE `t_connectorconstraint`
ADD INDEX `ix_connectorconstraint_connid` (`ConnectorID` ASC)
;
CREATE TABLE `t_connectortag`
(
`PropertyID` INT NOT NULL AUTO_INCREMENT,
`ElementID` INT NOT NULL DEFAULT 0,
`Property` VARCHAR(255) ,
`VALUE` VARCHAR(255) ,
`NOTES` MEDIUMTEXT ,
`ea_guid` VARCHAR(40) ,
CONSTRAINT `pk_connectortag` PRIMARY KEY (`PropertyID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_connectortag`
ADD INDEX `ix_connectortag_elementid` (`ElementID` ASC)
;
ALTER TABLE `t_connectortag`
ADD INDEX `ix_connectortag_property` (`Property` ASC)
;
ALTER TABLE `t_connectortag`
ADD INDEX `ix_connectortag_value` (`VALUE` ASC)
;
ALTER TABLE `t_connectortag`
ADD INDEX `ix_connectortag_eaguid` (`ea_guid` ASC)
;
CREATE TABLE `t_connectortypes`
(
`Connector_Type` VARCHAR(50) NOT NULL,
`Description` VARCHAR(50) ,
CONSTRAINT `pk_connectortypes` PRIMARY KEY (`Connector_Type` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_constants`
(
`ConstantName` VARCHAR(50) NOT NULL,
`ConstantValue` VARCHAR(255) ,
CONSTRAINT `pk_constants` PRIMARY KEY (`ConstantName` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_constrainttypes`
(
`Constraint` VARCHAR(16) NOT NULL,
`Description` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_constrainttypes` PRIMARY KEY (`Constraint` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_datatypes`
(
`Type` VARCHAR(50) NOT NULL,
`ProductName` VARCHAR(50) NOT NULL,
`DataType` VARCHAR(50) NOT NULL,
`Size` INT ,
`MaxLen` INT ,
`MaxPrec` INT ,
`MaxScale` INT DEFAULT 0,
`DefaultLen` INT ,
`DefaultPrec` INT ,
`DefaultScale` INT ,
`User` INT ,
`PDATA1` VARCHAR(255) ,
`PDATA2` VARCHAR(255) ,
`PDATA3` VARCHAR(255) ,
`PDATA4` VARCHAR(255) ,
`HasLength` VARCHAR(50) ,
`GenericType` VARCHAR(255) ,
`DatatypeID` INT NOT NULL AUTO_INCREMENT,
CONSTRAINT `pk_datatypes` PRIMARY KEY (`DatatypeID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_datatypes`
ADD INDEX `ix_datatypes_datatype` (`DataType` ASC)
;
ALTER TABLE `t_datatypes`
ADD INDEX `ix_datatypes_productname` (`ProductName` ASC)
;
CREATE TABLE `t_diagram`
(
`Diagram_ID` INT NOT NULL AUTO_INCREMENT,
`Package_ID` INT NOT NULL DEFAULT 1,
`ParentID` INT NOT NULL DEFAULT 0,
`Diagram_Type` VARCHAR(50) NOT NULL,
`Name` VARCHAR(255) ,
`Version` VARCHAR(50) DEFAULT '1.0',
`Author` VARCHAR(255) ,
`ShowDetails` INT DEFAULT 0,
`Notes` MEDIUMTEXT ,
`Stereotype` VARCHAR(50) ,
`AttPub` INT ,
`AttPri` INT ,
`AttPro` INT ,
`Orientation` CHAR(1) DEFAULT 'P',
`cx` INT DEFAULT 0,
`cy` INT DEFAULT 0,
`Scale` INT DEFAULT 100,
`CreatedDate` DATETIME DEFAULT CURRENT_TIMESTAMP,
`ModifiedDate` DATETIME DEFAULT CURRENT_TIMESTAMP,
`HTMLPath` VARCHAR(255) ,
`ShowForeign` INT ,
`ShowBorder` INT ,
`ShowPackageContents` INT ,
`PDATA` VARCHAR(255) ,
`Locked` INT ,
`ea_guid` VARCHAR(40) NOT NULL,
`TPos` INT ,
`Swimlanes` VARCHAR(255) ,
`StyleEx` MEDIUMTEXT ,
CONSTRAINT `pk_diagram` PRIMARY KEY (`Diagram_ID` ASC),
CONSTRAINT `uq_diagram_eaguid` UNIQUE (`ea_guid` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_diagram`
ADD INDEX `ix_diagram_diagramtype` (`Diagram_Type` ASC)
;
ALTER TABLE `t_diagram`
ADD INDEX `ix_diagram_packageid` (`Package_ID` ASC)
;
ALTER TABLE `t_diagram`
ADD INDEX `ix_diagram_parentid` (`ParentID` ASC)
;
CREATE TABLE `t_diagramlinks`
(
`DiagramID` INT NOT NULL DEFAULT 0,
`ConnectorID` INT NOT NULL DEFAULT 0,
`Geometry` MEDIUMTEXT ,
`Style` VARCHAR(255) ,
`Hidden` INT ,
`Path` VARCHAR(255) ,
`Instance_ID` INT NOT NULL AUTO_INCREMENT,
CONSTRAINT `pk_diagramlinks` PRIMARY KEY (`Instance_ID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_diagramlinks`
ADD INDEX `ix_diagramlinks_connectorid` (`ConnectorID` ASC)
;
ALTER TABLE `t_diagramlinks`
ADD INDEX `ix_diagramlinks_diagramid` (`DiagramID` ASC)
;
CREATE TABLE `t_diagramobjects`
(
`Diagram_ID` INT NOT NULL DEFAULT 0,
`Object_ID` INT NOT NULL DEFAULT 0,
`RectTop` INT DEFAULT 0,
`RectLeft` INT DEFAULT 0,
`RectRight` INT DEFAULT 0,
`RectBottom` INT DEFAULT 0,
`Sequence` INT DEFAULT 0,
`ObjectStyle` VARCHAR(255) ,
`Instance_ID` INT NOT NULL AUTO_INCREMENT,
CONSTRAINT `pk_diagramobjects` PRIMARY KEY (`Instance_ID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_diagramobjects`
ADD INDEX `ix_diagramobjects_diagramid` (`Diagram_ID` ASC)
;
ALTER TABLE `t_diagramobjects`
ADD INDEX `ix_diagramobjects_objectid` (`Object_ID` ASC)
;
ALTER TABLE `t_diagramobjects`
ADD INDEX `ix_diagramobjects_sequence` (`Sequence` ASC)
;
CREATE TABLE `t_diagramtypes`
(
`Diagram_Type` VARCHAR(50) NOT NULL,
`Name` VARCHAR(255) ,
`Package_ID` INT NOT NULL DEFAULT 0,
CONSTRAINT `pk_diagramtypes` PRIMARY KEY (`Diagram_Type` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_diagramtypes`
ADD INDEX `ix_diagramtypes_packageid` (`Package_ID` ASC)
;
CREATE TABLE `t_document`
(
`DocID` VARCHAR(40) NOT NULL,
`DocName` VARCHAR(100) ,
`Notes` VARCHAR(255) ,
`Style` VARCHAR(255) ,
`ElementID` VARCHAR(40) NOT NULL,
`ElementType` VARCHAR(50) NOT NULL,
`StrContent` MEDIUMTEXT ,
`BinContent` LONGBLOB ,
`DocType` VARCHAR(100) ,
`Author` VARCHAR(255) ,
`Version` VARCHAR(50) ,
`IsActive` INT DEFAULT 1,
`Sequence` INT DEFAULT 0,
`DocDate` DATETIME ,
CONSTRAINT `pk_document` PRIMARY KEY (`DocID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_document`
ADD INDEX `ix_document_elementid` (`ElementID` ASC)
;
ALTER TABLE `t_document`
ADD INDEX `ix_document_doctype` (`DocType` ASC)
;
ALTER TABLE `t_document`
ADD INDEX `ix_document_style` (`Style` ASC)
;
ALTER TABLE `t_document`
ADD INDEX `ix_document_author` (`Author` ASC)
;
ALTER TABLE `t_document`
ADD INDEX `ix_document_version` (`Version` ASC)
;
CREATE TABLE `t_ecf`
(
`ECFID` VARCHAR(12) NOT NULL,
`Description` VARCHAR(50) ,
`Weight` DOUBLE NOT NULL DEFAULT 1,
`Value` DOUBLE ,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_ecf` PRIMARY KEY (`ECFID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_ecf`
ADD INDEX `ix_ecf_weight` (`Weight` ASC)
;
CREATE TABLE `t_efforttypes`
(
`EffortType` VARCHAR(12) NOT NULL,
`Description` VARCHAR(255) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 0,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_efforttypes` PRIMARY KEY (`EffortType` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_efforttypes`
ADD INDEX `ix_efforttypes_numericweight` (`NumericWeight` ASC)
;
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) ,
`Notes` MEDIUMTEXT ,
`FileDate` DATETIME ,
`FileSize` INT ,
CONSTRAINT `pk_files` PRIMARY KEY (`FileID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_files`
ADD INDEX `ix_files_appliesto` (`AppliesTo` ASC)
;
ALTER TABLE `t_files`
ADD INDEX `ix_files_appliestoname` (`AppliesTo` ASC, `Name` ASC)
;
ALTER TABLE `t_files`
ADD INDEX `ix_files_appliestonamesize` (`AppliesTo` ASC, `Name` ASC, `FileSize` ASC)
;
ALTER TABLE `t_files`
ADD INDEX `ix_files_appliestonamedatesize` (`AppliesTo` ASC, `Name` ASC, `FileDate` ASC, `FileSize` ASC)
;
ALTER TABLE `t_files`
ADD INDEX `ix_files_category` (`Category` ASC)
;
ALTER TABLE `t_files`
ADD INDEX `ix_files_filesize` (`FileSize` ASC)
;
ALTER TABLE `t_files`
ADD INDEX `ix_files_name` (`Name` ASC)
;
CREATE TABLE `t_genopt`
(
`AppliesTo` VARCHAR(12) ,
`Option` MEDIUMTEXT
)
ENGINE=INNODB
;
CREATE TABLE `t_glossary`
(
`Term` VARCHAR(255) NOT NULL,
`Type` VARCHAR(255) ,
`Meaning` MEDIUMTEXT ,
`GlossaryID` INT NOT NULL AUTO_INCREMENT,
CONSTRAINT `pk_glossary` PRIMARY KEY (`GlossaryID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_glossary`
ADD INDEX `ix_glossary_term` (`Term` ASC)
;
ALTER TABLE `t_glossary`
ADD INDEX `ix_glossary_type` (`Type` ASC)
;
CREATE TABLE `t_html`
(
`Type` VARCHAR(50) ,
`Template` MEDIUMTEXT
)
ENGINE=INNODB
;
CREATE TABLE `t_image`
(
`ImageID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) ,
`Type` VARCHAR(255) ,
`Image` LONGBLOB ,
CONSTRAINT `pk_image` PRIMARY KEY (`ImageID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_implement`
(
`Type` VARCHAR(50)
)
ENGINE=INNODB
;
CREATE TABLE `t_issues`
(
`Issue` VARCHAR(255) ,
`IssueDate` DATETIME DEFAULT CURRENT_TIMESTAMP,
`Owner` VARCHAR(255) ,
`Status` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
`Resolver` VARCHAR(255) ,
`DateResolved` DATETIME ,
`Resolution` MEDIUMTEXT ,
`IssueID` INT NOT NULL AUTO_INCREMENT,
`Category` VARCHAR(255) ,
`Priority` VARCHAR(50) ,
`Severity` VARCHAR(50) ,
`IssueType` VARCHAR(100) ,
CONSTRAINT `pk_issues` PRIMARY KEY (`IssueID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_lists`
(
`ListID` VARCHAR(50) NOT NULL,
`Category` VARCHAR(100) NOT NULL,
`Name` VARCHAR(150) NOT NULL,
`NVal` INT ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_lists` PRIMARY KEY (`ListID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_mainttypes`
(
`MaintType` VARCHAR(12) NOT NULL,
`Description` VARCHAR(50) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 1,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_mainttypes` PRIMARY KEY (`MaintType` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_mainttypes`
ADD INDEX `ix_mainttypes_numericweight` (`NumericWeight` ASC)
;
CREATE TABLE `t_method`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Name` VARCHAR(255) NOT NULL,
`Scope` VARCHAR(50) ,
`Type` VARCHAR(50) ,
CONSTRAINT `pk_method` PRIMARY KEY (`Object_ID` ASC, `Name` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_method`
ADD INDEX `ix_method_objectid` (`Object_ID` ASC)
;
CREATE TABLE `t_metrictypes`
(
`Metric` VARCHAR(12) NOT NULL,
`Description` VARCHAR(50) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 1,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_metrictypes` PRIMARY KEY (`Metric` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_metrictypes`
ADD INDEX `ix_metrictypes_numericweight` (`NumericWeight` ASC)
;
CREATE TABLE `t_object`
(
`Object_ID` INT NOT NULL AUTO_INCREMENT,
`Object_Type` VARCHAR(255) ,
`Diagram_ID` INT DEFAULT 0,
`Name` VARCHAR(255) ,
`Alias` VARCHAR(255) ,
`Author` VARCHAR(255) ,
`Version` VARCHAR(50) DEFAULT '1.0',
`Note` MEDIUMTEXT ,
`Package_ID` INT NOT NULL DEFAULT 0,
`Stereotype` VARCHAR(255) ,
`NType` INT DEFAULT 0,
`Complexity` VARCHAR(50) DEFAULT '2',
`Effort` INT DEFAULT 0,
`Style` VARCHAR(255) ,
`Backcolor` INT DEFAULT 0,
`BorderStyle` INT DEFAULT 0,
`BorderWidth` INT DEFAULT 0,
`Fontcolor` INT DEFAULT 0,
`Bordercolor` INT DEFAULT 0,
`CreatedDate` DATETIME ,
`ModifiedDate` DATETIME ,
`Status` VARCHAR(50) ,
`Abstract` CHAR(1) ,
`Tagged` INT DEFAULT 0,
`PDATA1` VARCHAR(255) ,
`PDATA2` MEDIUMTEXT ,
`PDATA3` MEDIUMTEXT ,
`PDATA4` MEDIUMTEXT ,
`PDATA5` VARCHAR(255) ,
`Concurrency` VARCHAR(50) ,
`Visibility` VARCHAR(50) ,
`Persistence` VARCHAR(50) ,
`Cardinality` VARCHAR(50) ,
`GenType` VARCHAR(50) ,
`GenFile` VARCHAR(255) ,
`Header1` MEDIUMTEXT ,
`Header2` MEDIUMTEXT ,
`Phase` VARCHAR(50) ,
`Scope` VARCHAR(25) ,
`GenOption` MEDIUMTEXT ,
`GenLinks` MEDIUMTEXT ,
`Classifier` INT ,
`ea_guid` VARCHAR(40) NOT NULL,
`ParentID` INT ,
`RunState` MEDIUMTEXT ,
`Classifier_guid` VARCHAR(40) ,
`TPos` INT ,
`IsRoot` INT ,
`IsLeaf` INT ,
`IsSpec` INT ,
`IsActive` INT ,
`StateFlags` VARCHAR(255) ,
`PackageFlags` VARCHAR(255) ,
`Multiplicity` VARCHAR(50) ,
`StyleEx` MEDIUMTEXT ,
`ActionFlags` VARCHAR(255) ,
`EventFlags` VARCHAR(255) ,
CONSTRAINT `pk_object` PRIMARY KEY (`Object_ID` ASC),
CONSTRAINT `uq_object_eaguid` UNIQUE (`ea_guid` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_classifier` (`Classifier` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_classifierguid` (`Classifier_guid` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_eventflags` (`EventFlags` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_name` (`Name` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_ntype` (`NType` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_objecttype` (`Object_Type` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_packageid` (`Package_ID` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_parentid` (`ParentID` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_pkgidpdata1class` (`Package_ID` ASC, `PDATA1` ASC, `Classifier` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_pdata1` (`PDATA1` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_genlinks` (`GenLinks`(100) ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_eaguidclassifier` (`ea_guid` ASC, `Classifier` ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_pdata2` (`PDATA2`(255) ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_pdata3` (`PDATA3`(255) ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_pdata4` (`PDATA4`(100) ASC)
;
ALTER TABLE `t_object`
ADD INDEX `ix_object_pdata5` (`PDATA5` ASC)
;
CREATE TABLE `t_objectconstraint`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Constraint` VARCHAR(255) NOT NULL,
`ConstraintType` VARCHAR(30) NOT NULL,
`Weight` DOUBLE ,
`Notes` MEDIUMTEXT ,
`Status` VARCHAR(50) ,
CONSTRAINT `pk_objectconstraint` PRIMARY KEY (`Object_ID` ASC, `ConstraintType` ASC, `Constraint` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objectconstraint`
ADD INDEX `ix_objectconstraint_constraint` (`Constraint` ASC)
;
ALTER TABLE `t_objectconstraint`
ADD INDEX `ix_objectconstraint_objectid` (`Object_ID` ASC)
;
CREATE TABLE `t_objecteffort`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Effort` VARCHAR(255) NOT NULL,
`EffortType` VARCHAR(12) ,
`EValue` DOUBLE ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_objecteffort` PRIMARY KEY (`Object_ID` ASC, `Effort` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objecteffort`
ADD INDEX `ix_objecteffort_objectid` (`Object_ID` ASC)
;
CREATE TABLE `t_objectfiles`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`FileName` VARCHAR(255) NOT NULL,
`Type` VARCHAR(50) ,
`Note` MEDIUMTEXT ,
`FileSize` VARCHAR(255) ,
`FileDate` VARCHAR(255) ,
CONSTRAINT `pk_objectfiles` PRIMARY KEY (`Object_ID` ASC, `FileName` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_objectmetrics`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Metric` VARCHAR(255) NOT NULL,
`MetricType` VARCHAR(12) NOT NULL,
`EValue` DOUBLE DEFAULT 1,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_objectmetrics` PRIMARY KEY (`Object_ID` ASC, `Metric` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objectmetrics`
ADD INDEX `ix_objectmetrics_metric` (`Metric` ASC)
;
ALTER TABLE `t_objectmetrics`
ADD INDEX `ix_objectmetrics_metrictype` (`MetricType` ASC)
;
ALTER TABLE `t_objectmetrics`
ADD INDEX `ix_objectmetrics_objectid` (`Object_ID` ASC)
;
CREATE TABLE `t_objectproblems`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Problem` VARCHAR(255) NOT NULL,
`ProblemType` VARCHAR(255) NOT NULL,
`DateReported` DATE ,
`Status` VARCHAR(50) ,
`ProblemNotes` MEDIUMTEXT ,
`ReportedBy` VARCHAR(255) ,
`ResolvedBy` VARCHAR(255) ,
`DateResolved` DATE ,
`Version` VARCHAR(50) ,
`ResolverNotes` MEDIUMTEXT ,
`Priority` VARCHAR(50) ,
`Severity` VARCHAR(50) ,
CONSTRAINT `pk_objectproblems` PRIMARY KEY (`Object_ID` ASC, `ProblemType` ASC, `Problem` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objectproblems`
ADD INDEX `ix_objectproblems_objectid` (`Object_ID` ASC)
;
ALTER TABLE `t_objectproblems`
ADD INDEX `ix_objectproblems_problem` (`Problem` ASC)
;
CREATE TABLE `t_objectproperties`
(
`PropertyID` INT NOT NULL AUTO_INCREMENT,
`Object_ID` INT NOT NULL DEFAULT 0,
`Property` VARCHAR(255) ,
`Value` VARCHAR(255) ,
`Notes` MEDIUMTEXT ,
`ea_guid` VARCHAR(40) ,
CONSTRAINT `pk_objectproperties` PRIMARY KEY (`PropertyID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objectproperties`
ADD INDEX `ix_objectproperties_objectid` (`Object_ID` ASC)
;
ALTER TABLE `t_objectproperties`
ADD INDEX `ix_objectproperties_value` (`Value` ASC)
;
ALTER TABLE `t_objectproperties`
ADD INDEX `ix_objectproperties_property` (`Property` ASC)
;
ALTER TABLE `t_objectproperties`
ADD INDEX `ix_objectproperties_objidprop` (`Object_ID` ASC, `Property` ASC)
;
ALTER TABLE `t_objectproperties`
ADD INDEX `ix_objectproperties_eaguid` (`ea_guid` ASC)
;
CREATE TABLE `t_objectrequires`
(
`ReqID` INT NOT NULL AUTO_INCREMENT,
`Object_ID` INT NOT NULL DEFAULT 0,
`Requirement` VARCHAR(255) ,
`ReqType` VARCHAR(255) ,
`Status` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
`Stability` VARCHAR(50) ,
`Difficulty` VARCHAR(50) ,
`Priority` VARCHAR(50) ,
`LastUpdate` VARCHAR(19) ,
CONSTRAINT `pk_objectrequires` PRIMARY KEY (`ReqID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objectrequires`
ADD INDEX `ix_objectrequires_objectid` (`Object_ID` ASC)
;
ALTER TABLE `t_objectrequires`
ADD INDEX `ix_objectrequires_requirement` (`Requirement` ASC)
;
CREATE TABLE `t_objectresource`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Resource` VARCHAR(255) NOT NULL,
`Role` VARCHAR(255) NOT NULL,
`Time` DOUBLE ,
`Notes` MEDIUMTEXT ,
`PercentComplete` SMALLINT DEFAULT 0,
`DateStart` DATE ,
`DateEnd` DATE ,
`History` MEDIUMTEXT ,
`ExpectedHours` INT DEFAULT 0,
`ActualHours` INT DEFAULT 0,
CONSTRAINT `pk_objectresource` PRIMARY KEY (`Object_ID` ASC, `Resource` ASC, `Role` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objectresource`
ADD INDEX `ix_objectresource_objectid` (`Object_ID` ASC)
;
CREATE TABLE `t_objectrisks`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Risk` VARCHAR(255) NOT NULL,
`RiskType` VARCHAR(12) ,
`EValue` DOUBLE ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_objectrisks` PRIMARY KEY (`Object_ID` ASC, `Risk` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objectrisks`
ADD INDEX `ix_objectrisks_objectid` (`Object_ID` ASC)
;
CREATE TABLE `t_objectscenarios`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`Scenario` VARCHAR(255) NOT NULL,
`ScenarioType` VARCHAR(12) ,
`EValue` DOUBLE ,
`Notes` MEDIUMTEXT ,
`ea_guid` VARCHAR(40) NOT NULL,
`XMLContent` MEDIUMTEXT ,
CONSTRAINT `pk_objectscenarios` PRIMARY KEY (`Object_ID` ASC, `Scenario` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objectscenarios`
ADD INDEX `ix_objectscenarios_oidevalscen` (`Object_ID` ASC, `EValue` ASC, `Scenario` ASC)
;
ALTER TABLE `t_objectscenarios`
ADD INDEX `ix_objectscenarios_objectid` (`Object_ID` ASC)
;
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) ,
`Notes` MEDIUMTEXT ,
`InputData` MEDIUMTEXT ,
`AcceptanceCriteria` MEDIUMTEXT ,
`Status` VARCHAR(32) ,
`DateRun` DATE ,
`Results` MEDIUMTEXT ,
`RunBy` VARCHAR(255) ,
`CheckBy` VARCHAR(255) ,
CONSTRAINT `pk_objecttests` PRIMARY KEY (`Object_ID` ASC, `Test` ASC, `TestClass` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objecttests`
ADD INDEX `ix_objecttests_objectid` (`Object_ID` ASC)
;
ALTER TABLE `t_objecttests`
ADD INDEX `ix_objecttests_objidtclassstat` (`Object_ID` ASC, `TestClass` ASC, `Status` ASC)
;
CREATE TABLE `t_objecttrx`
(
`Object_ID` INT NOT NULL DEFAULT 0,
`TRX` VARCHAR(255) NOT NULL,
`TRXType` VARCHAR(12) NOT NULL,
`Weight` DOUBLE ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_objecttrx` PRIMARY KEY (`Object_ID` ASC, `TRXType` ASC, `TRX` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objecttrx`
ADD INDEX `ix_objecttrx_objectid` (`Object_ID` ASC)
;
ALTER TABLE `t_objecttrx`
ADD INDEX `ix_objecttrx_trx` (`TRX` ASC)
;
CREATE TABLE `t_objecttypes`
(
`Object_Type` VARCHAR(50) NOT NULL,
`Description` VARCHAR(255) ,
`DesignObject` INT ,
`ImageID` SMALLINT NOT NULL DEFAULT 0,
CONSTRAINT `pk_objecttypes` PRIMARY KEY (`Object_Type` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_objecttypes`
ADD INDEX `ix_objecttypes_imageid` (`ImageID` ASC)
;
CREATE TABLE `t_ocf`
(
`ObjectType` VARCHAR(50) ,
`ComplexityWeight` DOUBLE
)
ENGINE=INNODB
;
CREATE TABLE `t_operation`
(
`OperationID` INT NOT NULL AUTO_INCREMENT,
`Object_ID` INT NOT NULL DEFAULT 0,
`Name` VARCHAR(255) NOT NULL,
`Scope` VARCHAR(50) ,
`Type` VARCHAR(255) ,
`ReturnArray` CHAR(1) ,
`Stereotype` VARCHAR(50) ,
`IsStatic` CHAR(1) ,
`Concurrency` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
`Behaviour` MEDIUMTEXT ,
`Abstract` CHAR(1) ,
`GenOption` MEDIUMTEXT ,
`Synchronized` CHAR(1) ,
`Pos` INT ,
`Const` INT ,
`Style` VARCHAR(255) ,
`Pure` INT ,
`Throws` VARCHAR(255) ,
`Classifier` VARCHAR(50) ,
`Code` MEDIUMTEXT ,
`IsRoot` INT ,
`IsLeaf` INT ,
`IsQuery` INT ,
`StateFlags` VARCHAR(255) ,
`ea_guid` VARCHAR(50) NOT NULL,
`StyleEx` MEDIUMTEXT ,
CONSTRAINT `pk_operation` PRIMARY KEY (`OperationID` ASC),
CONSTRAINT `uq_operation_eaguid` UNIQUE (`ea_guid` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_operation`
ADD INDEX `ix_operation_classifier` (`Classifier` ASC)
;
ALTER TABLE `t_operation`
ADD INDEX `ix_operation_name` (`Name` ASC)
;
ALTER TABLE `t_operation`
ADD INDEX `ix_operation_objectid` (`Object_ID` ASC)
;
ALTER TABLE `t_operation`
ADD INDEX `ix_operation_objectidopid` (`Object_ID` ASC, `OperationID` ASC)
;
CREATE TABLE `t_operationparams`
(
`OperationID` INT NOT NULL DEFAULT 0,
`Name` VARCHAR(255) NOT NULL,
`Type` VARCHAR(255) ,
`Default` VARCHAR(255) ,
`Notes` MEDIUMTEXT ,
`Pos` INT NOT NULL DEFAULT 0,
`Const` INT ,
`Style` VARCHAR(255) ,
`Kind` VARCHAR(12) ,
`Classifier` VARCHAR(50) ,
`ea_guid` VARCHAR(50) NOT NULL,
`StyleEx` MEDIUMTEXT ,
CONSTRAINT `pk_operationparams` PRIMARY KEY (`OperationID` ASC, `Name` ASC),
CONSTRAINT `uq_operationparams_eaguid` UNIQUE (`ea_guid` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_operationparams`
ADD INDEX `ix_operationparams_classifier` (`Classifier` ASC)
;
ALTER TABLE `t_operationparams`
ADD INDEX `ix_operationparams_operationid` (`OperationID` ASC)
;
ALTER TABLE `t_operationparams`
ADD INDEX `ix_operationparams_opidpos` (`OperationID` ASC, `Pos` ASC)
;
CREATE TABLE `t_operationposts`
(
`OperationID` INT NOT NULL DEFAULT 0,
`PostCondition` VARCHAR(255) NOT NULL,
`Type` VARCHAR(255) ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_operationposts` PRIMARY KEY (`OperationID` ASC, `PostCondition` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_operationposts`
ADD INDEX `ix_operationposts_operationid` (`OperationID` ASC)
;
CREATE TABLE `t_operationpres`
(
`OperationID` INT NOT NULL DEFAULT 0,
`PreCondition` VARCHAR(255) NOT NULL,
`Type` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_operationpres` PRIMARY KEY (`OperationID` ASC, `PreCondition` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_operationpres`
ADD INDEX `ix_operationpres_operationid` (`OperationID` ASC)
;
CREATE TABLE `t_operationtag`
(
`PropertyID` INT NOT NULL AUTO_INCREMENT,
`ElementID` INT NOT NULL DEFAULT 0,
`Property` VARCHAR(255) ,
`VALUE` VARCHAR(255) ,
`NOTES` MEDIUMTEXT ,
`ea_guid` VARCHAR(40) ,
CONSTRAINT `pk_operationtag` PRIMARY KEY (`PropertyID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_operationtag`
ADD INDEX `ix_operationtag_elementid` (`ElementID` ASC)
;
ALTER TABLE `t_operationtag`
ADD INDEX `ix_operationtag_value` (`VALUE` ASC)
;
ALTER TABLE `t_operationtag`
ADD INDEX `ix_operationtag_property` (`Property` ASC)
;
ALTER TABLE `t_operationtag`
ADD INDEX `ix_operationtag_elementidprop` (`ElementID` ASC, `Property` ASC)
;
ALTER TABLE `t_operationtag`
ADD INDEX `ix_operationtag_eaguid` (`ea_guid` ASC)
;
CREATE TABLE `t_package`
(
`Package_ID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) ,
`Parent_ID` INT NOT NULL DEFAULT 0,
`CreatedDate` DATETIME ,
`ModifiedDate` DATETIME ,
`Notes` MEDIUMTEXT ,
`ea_guid` VARCHAR(40) NOT NULL,
`XMLPath` VARCHAR(255) ,
`IsControlled` INT ,
`LastLoadDate` DATETIME ,
`LastSaveDate` DATETIME ,
`Version` VARCHAR(50) ,
`Protected` INT ,
`PkgOwner` VARCHAR(255) ,
`UMLVersion` VARCHAR(50) ,
`UseDTD` INT ,
`LogXML` INT ,
`CodePath` VARCHAR(255) ,
`Namespace` VARCHAR(50) ,
`TPos` INT ,
`PackageFlags` VARCHAR(255) ,
`BatchSave` INT DEFAULT 0,
`BatchLoad` INT DEFAULT 0,
CONSTRAINT `pk_package` PRIMARY KEY (`Package_ID` ASC),
CONSTRAINT `uq_package_eaguid` UNIQUE (`ea_guid` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_package`
ADD INDEX `ix_package_name` (`Name` ASC)
;
ALTER TABLE `t_package`
ADD INDEX `ix_package_parentid` (`Parent_ID` ASC)
;
CREATE TABLE `t_palette`
(
`PaletteID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) ,
`Type` VARCHAR(255) ,
CONSTRAINT `pk_palette` PRIMARY KEY (`PaletteID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_paletteitem`
(
`PaletteID` INT ,
`ItemID` INT
)
ENGINE=INNODB
;
CREATE TABLE `t_phase`
(
`PhaseID` VARCHAR(40) NOT NULL,
`PhaseName` VARCHAR(100) NOT NULL,
`PhaseNotes` MEDIUMTEXT ,
`PhaseStyle` VARCHAR(255) ,
`StartDate` DATETIME ,
`EndDate` DATETIME ,
`PhaseContent` MEDIUMTEXT ,
CONSTRAINT `pk_phase` PRIMARY KEY (`PhaseID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_primitives`
(
`Datatype` VARCHAR(50) NOT NULL,
`Description` VARCHAR(50) ,
CONSTRAINT `pk_primitives` PRIMARY KEY (`Datatype` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_problemtypes`
(
`ProblemType` VARCHAR(12) NOT NULL,
`Description` VARCHAR(255) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 1,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_problemtypes` PRIMARY KEY (`ProblemType` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_problemtypes`
ADD INDEX `ix_problemtypes_numericweight` (`NumericWeight` ASC)
;
CREATE TABLE `t_projectroles`
(
`Role` VARCHAR(255) NOT NULL,
`Description` VARCHAR(255) ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_projectroles` PRIMARY KEY (`Role` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_propertytypes`
(
`Property` VARCHAR(50) NOT NULL,
`Description` VARCHAR(50) ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_propertytypes` PRIMARY KEY (`Property` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_requiretypes`
(
`Requirement` VARCHAR(12) NOT NULL,
`Description` VARCHAR(50) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 1,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_requiretypes` PRIMARY KEY (`Requirement` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_requiretypes`
ADD INDEX `ix_requiretypes_numericweight` (`NumericWeight` ASC)
;
CREATE TABLE `t_resources`
(
`Name` VARCHAR(255) NOT NULL,
`Organisation` VARCHAR(255) ,
`Phone1` VARCHAR(50) ,
`Phone2` VARCHAR(50) ,
`Mobile` VARCHAR(50) ,
`Fax` VARCHAR(50) ,
`Email` VARCHAR(255) ,
`Roles` VARCHAR(255) ,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_resources` PRIMARY KEY (`Name` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_risktypes`
(
`Risk` VARCHAR(12) NOT NULL,
`Description` VARCHAR(50) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 0,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_risktypes` PRIMARY KEY (`Risk` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_risktypes`
ADD INDEX `ix_risktypes_numericweight` (`NumericWeight` ASC)
;
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` MEDIUMTEXT ,
CONSTRAINT `pk_roleconstraint` PRIMARY KEY (`ConnectorID` ASC, `Constraint` ASC, `ConnectorEnd` ASC, `ConstraintType` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_roleconstraint`
ADD INDEX `ix_roleconstraint_connectorid` (`ConnectorID` ASC)
;
ALTER TABLE `t_roleconstraint`
ADD INDEX `ix_roleconstraint_constraint` (`Constraint` ASC)
;
CREATE TABLE `t_rtf`
(
`Type` VARCHAR(50) ,
`Template` MEDIUMTEXT
)
ENGINE=INNODB
;
CREATE TABLE `t_rtfreport`
(
`TemplateID` VARCHAR(200) NOT NULL,
`RootPackage` INT DEFAULT 0,
`Filename` VARCHAR(255) ,
`Details` INT ,
`ProcessChildren` INT ,
`ShowDiagrams` INT ,
`Heading` VARCHAR(255) ,
`Requirements` INT ,
`Associations` INT ,
`Scenarios` INT ,
`ChildDiagrams` INT ,
`Attributes` INT ,
`Methods` INT ,
`ImageType` INT DEFAULT 0,
`Paging` INT ,
`Intro` MEDIUMTEXT ,
`Resources` INT ,
`Constraints` INT ,
`Tagged` INT ,
`ShowTag` INT ,
`ShowAlias` INT ,
`PDATA1` VARCHAR(255) ,
`PDATA2` VARCHAR(255) ,
`PDATA3` VARCHAR(255) ,
`PDATA4` MEDIUMTEXT ,
CONSTRAINT `pk_rtfreport` PRIMARY KEY (`TemplateID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_rules`
(
`RuleID` VARCHAR(50) NOT NULL,
`RuleName` VARCHAR(255) NOT NULL,
`RuleType` VARCHAR(255) NOT NULL,
`RuleActive` INT NOT NULL DEFAULT 0,
`ErrorMsg` VARCHAR(255) ,
`Flags` VARCHAR(255) ,
`RuleOCL` MEDIUMTEXT ,
`RuleXML` MEDIUMTEXT ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_rules` PRIMARY KEY (`RuleID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_scenariotypes`
(
`ScenarioType` VARCHAR(12) NOT NULL,
`Description` VARCHAR(50) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 1,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_scenariotypes` PRIMARY KEY (`ScenarioType` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_scenariotypes`
ADD INDEX `ix_scenariotypes_numericweight` (`NumericWeight` ASC)
;
CREATE TABLE `t_script`
(
`ScriptID` INT NOT NULL AUTO_INCREMENT,
`ScriptCategory` VARCHAR(100) ,
`ScriptName` VARCHAR(150) ,
`ScriptAuthor` VARCHAR(255) ,
`Notes` MEDIUMTEXT ,
`Script` MEDIUMTEXT ,
CONSTRAINT `pk_script` PRIMARY KEY (`ScriptID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_script`
ADD INDEX `ix_script_scriptcategory` (`ScriptCategory` ASC)
;
CREATE TABLE `t_secgroup`
(
`GroupID` VARCHAR(40) NOT NULL,
`GroupName` VARCHAR(32) NOT NULL,
`Description` VARCHAR(100) ,
CONSTRAINT `pk_secgroup` PRIMARY KEY (`GroupID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_secgrouppermission`
(
`GroupID` VARCHAR(40) NOT NULL,
`PermissionID` INT NOT NULL DEFAULT 0,
CONSTRAINT `pk_secgrouppermission` PRIMARY KEY (`GroupID` ASC, `PermissionID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_seclocks`
(
`UserID` VARCHAR(40) NOT NULL,
`GroupID` VARCHAR(40) ,
`EntityType` VARCHAR(32) NOT NULL,
`EntityID` VARCHAR(40) NOT NULL,
`Timestamp` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`LockType` VARCHAR(255) ,
CONSTRAINT `pk_seclocks` PRIMARY KEY (`EntityID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_seclocks`
ADD INDEX `ix_seclocks_entityiduserid` (`EntityID` ASC, `UserID` ASC)
;
ALTER TABLE `t_seclocks`
ADD INDEX `ix_seclocks_entityidtype` (`EntityID` ASC, `EntityType` ASC)
;
ALTER TABLE `t_seclocks`
ADD INDEX `ix_seclocks_entityidusrtype` (`EntityID` ASC, `UserID` ASC, `EntityType` ASC)
;
ALTER TABLE `t_seclocks`
ADD INDEX `ix_seclocks_groupid` (`GroupID` ASC)
;
ALTER TABLE `t_seclocks`
ADD INDEX `ix_seclocks_groupiduserid` (`GroupID` ASC, `UserID` ASC)
;
CREATE TABLE `t_secpermission`
(
`PermissionID` INT NOT NULL DEFAULT 0,
`PermissionName` VARCHAR(50) NOT NULL,
CONSTRAINT `pk_secpermission` PRIMARY KEY (`PermissionID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_secpolicies`
(
`Property` VARCHAR(100) NOT NULL,
`Value` VARCHAR(255) NOT NULL,
CONSTRAINT `pk_secpolicies` PRIMARY KEY (`Property` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_secuser`
(
`UserID` VARCHAR(40) NOT NULL,
`UserLogin` VARCHAR(255) NOT NULL,
`FirstName` VARCHAR(50) NOT NULL,
`Surname` VARCHAR(50) NOT NULL,
`Department` VARCHAR(50) ,
`Password` VARCHAR(12) ,
CONSTRAINT `pk_secuser` PRIMARY KEY (`UserID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_secusergroup`
(
`UserID` VARCHAR(40) NOT NULL,
`GroupID` VARCHAR(40) NOT NULL,
CONSTRAINT `pk_secusergroup` PRIMARY KEY (`UserID` ASC, `GroupID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_secuserpermission`
(
`UserID` VARCHAR(40) NOT NULL,
`PermissionID` INT NOT NULL DEFAULT 0,
CONSTRAINT `pk_secuserpermission` PRIMARY KEY (`UserID` ASC, `PermissionID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_snapshot`
(
`SnapshotID` VARCHAR(40) NOT NULL,
`SeriesID` VARCHAR(40) NOT NULL,
`Position` INT NOT NULL DEFAULT 0,
`SnapshotName` VARCHAR(100) NOT NULL,
`Notes` MEDIUMTEXT ,
`Style` VARCHAR(255) NOT NULL,
`ElementID` VARCHAR(40) ,
`ElementType` VARCHAR(50) NOT NULL,
`StrContent` MEDIUMTEXT ,
`BinContent1` LONGBLOB ,
`BinContent2` LONGBLOB ,
CONSTRAINT `pk_snapshot` PRIMARY KEY (`SnapshotID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_snapshot`
ADD INDEX `ix_snapshot_position` (`Position` ASC)
;
ALTER TABLE `t_snapshot`
ADD INDEX `ix_snapshot_seriesid` (`SeriesID` ASC)
;
CREATE TABLE `t_statustypes`
(
`Status` VARCHAR(50) NOT NULL,
`Description` VARCHAR(50) ,
CONSTRAINT `pk_statustypes` PRIMARY KEY (`Status` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_stereotypes`
(
`Stereotype` VARCHAR(255) NOT NULL,
`AppliesTo` VARCHAR(255) NOT NULL,
`Description` VARCHAR(255) ,
`MFEnabled` INT ,
`MFPath` VARCHAR(255) ,
`Metafile` LONGBLOB ,
`Style` MEDIUMTEXT ,
`ea_guid` VARCHAR(50) ,
`VisualType` VARCHAR(100) ,
CONSTRAINT `pk_stereotypes` PRIMARY KEY (`AppliesTo` ASC, `Stereotype` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_stereotypes`
ADD INDEX `ix_stereotypes_stereotype` (`Stereotype` ASC)
;
ALTER TABLE `t_stereotypes`
ADD INDEX `ix_stereotypes_eaguid` (`ea_guid` ASC)
;
CREATE TABLE `t_taggedvalue`
(
`PropertyID` VARCHAR(40) NOT NULL,
`ElementID` VARCHAR(40) NOT NULL,
`BaseClass` VARCHAR(100) NOT NULL,
`TagValue` MEDIUMTEXT ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_taggedvalue` PRIMARY KEY (`PropertyID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_taggedvalue`
ADD INDEX `ix_taggedvalue_elementid` (`ElementID` ASC)
;
CREATE TABLE `t_tasks`
(
`TaskID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) ,
`TaskType` VARCHAR(255) ,
`NOTES` MEDIUMTEXT ,
`Priority` VARCHAR(255) ,
`Status` VARCHAR(255) ,
`Owner` VARCHAR(255) ,
`StartDate` DATE ,
`EndDate` DATE ,
`Phase` VARCHAR(50) ,
`History` MEDIUMTEXT ,
`Percent` INT ,
`TotalTime` INT ,
`ActualTime` INT ,
`AssignedTo` VARCHAR(100) ,
CONSTRAINT `pk_tasks` PRIMARY KEY (`TaskID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_tcf`
(
`TCFID` VARCHAR(12) NOT NULL,
`Description` VARCHAR(50) ,
`Weight` DOUBLE NOT NULL DEFAULT 1,
`Value` DOUBLE ,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_tcf` PRIMARY KEY (`TCFID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_tcf`
ADD INDEX `ix_tcf_weight` (`Weight` ASC)
;
CREATE TABLE `t_template`
(
`TemplateID` VARCHAR(40) NOT NULL,
`TemplateType` VARCHAR(50) NOT NULL,
`TemplateName` VARCHAR(100) NOT NULL,
`Notes` VARCHAR(255) ,
`Style` VARCHAR(255) ,
`Template` MEDIUMTEXT ,
CONSTRAINT `pk_template` PRIMARY KEY (`TemplateID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_testclass`
(
`TestClass` VARCHAR(50) NOT NULL,
`Description` VARCHAR(50) ,
CONSTRAINT `pk_testclass` PRIMARY KEY (`TestClass` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_testplans`
(
`PlanID` VARCHAR(50) NOT NULL,
`Category` VARCHAR(100) NOT NULL,
`Name` VARCHAR(150) NOT NULL,
`Author` VARCHAR(255) ,
`Notes` MEDIUMTEXT ,
`TestPlan` MEDIUMTEXT ,
CONSTRAINT `pk_testplans` PRIMARY KEY (`PlanID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_testtypes`
(
`TestType` VARCHAR(12) NOT NULL,
`Description` VARCHAR(50) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 1,
`Notes` VARCHAR(255) ,
CONSTRAINT `pk_testtypes` PRIMARY KEY (`TestType` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_testtypes`
ADD INDEX `ix_testtypes_numericweight` (`NumericWeight` ASC)
;
CREATE TABLE `t_trxtypes`
(
`TRX` VARCHAR(255) NOT NULL,
`Description` VARCHAR(50) ,
`NumericWeight` DOUBLE NOT NULL DEFAULT 1,
`Notes` MEDIUMTEXT ,
`Style` MEDIUMTEXT ,
`TRX_ID` INT NOT NULL AUTO_INCREMENT,
CONSTRAINT `pk_trxtypes` PRIMARY KEY (`TRX_ID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_trxtypes`
ADD INDEX `ix_trxtypes_description` (`Description` ASC)
;
ALTER TABLE `t_trxtypes`
ADD INDEX `ix_trxtypes_numericweight` (`NumericWeight` ASC)
;
ALTER TABLE `t_trxtypes`
ADD INDEX `ix_trxtypes_trx` (`TRX` ASC)
;
CREATE TABLE `t_umlpattern`
(
`PatternID` INT NOT NULL AUTO_INCREMENT,
`PatternCategory` VARCHAR(100) ,
`PatternName` VARCHAR(150) NOT NULL,
`Style` VARCHAR(255) ,
`Notes` MEDIUMTEXT ,
`PatternXML` MEDIUMTEXT NOT NULL,
`Version` VARCHAR(50) ,
CONSTRAINT `pk_umlpattern` PRIMARY KEY (`PatternID` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `t_version`
(
`ElementID` VARCHAR(50) NOT NULL,
`VersionID` VARCHAR(255) NOT NULL,
`ElementType` VARCHAR(100) NOT NULL,
`Flags` VARCHAR(255) ,
`ExternalFile` VARCHAR(255) ,
`Notes` VARCHAR(255) ,
`Owner` VARCHAR(255) ,
`VersionDate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`Branch` VARCHAR(255) ,
`ElementXML` MEDIUMTEXT ,
CONSTRAINT `pk_version` PRIMARY KEY (`ElementID` ASC, `VersionID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_version`
ADD INDEX `ix_version_elementid` (`ElementID` ASC)
;
CREATE TABLE `t_xref`
(
`XrefID` VARCHAR(255) NOT NULL,
`Name` VARCHAR(255) ,
`Type` VARCHAR(255) NOT NULL,
`Visibility` VARCHAR(255) ,
`Namespace` VARCHAR(255) ,
`Requirement` VARCHAR(255) ,
`Constraint` VARCHAR(255) ,
`Behavior` VARCHAR(255) ,
`Partition` VARCHAR(255) ,
`Description` MEDIUMTEXT ,
`Client` VARCHAR(255) ,
`Supplier` VARCHAR(255) ,
`Link` VARCHAR(255) ,
CONSTRAINT `pk_xref` PRIMARY KEY (`XrefID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_xref`
ADD INDEX `ix_xref_client` (`Client` ASC)
;
ALTER TABLE `t_xref`
ADD INDEX `ix_xref_name` (`Name` ASC)
;
ALTER TABLE `t_xref`
ADD INDEX `ix_xref_supplier` (`Supplier` ASC)
;
ALTER TABLE `t_xref`
ADD INDEX `ix_xref_type` (`Type` ASC)
;
ALTER TABLE `t_xref`
ADD INDEX `ix_xref_nametype` (`Name` ASC, `Type` ASC)
;
CREATE TABLE `t_xrefsystem`
(
`XrefID` VARCHAR(255) NOT NULL,
`Name` VARCHAR(255) ,
`Type` VARCHAR(255) NOT NULL,
`Visibility` VARCHAR(255) ,
`Namespace` VARCHAR(255) ,
`Requirement` VARCHAR(255) ,
`Constraint` VARCHAR(255) ,
`Behavior` VARCHAR(255) ,
`Partition` VARCHAR(255) ,
`Description` MEDIUMTEXT ,
`Client` VARCHAR(255) ,
`Supplier` VARCHAR(255) ,
`Link` VARCHAR(255) ,
`ToolID` VARCHAR(50) ,
CONSTRAINT `pk_xrefsystem` PRIMARY KEY (`XrefID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_xrefsystem`
ADD INDEX `ix_xrefsystem_client` (`Client` ASC)
;
ALTER TABLE `t_xrefsystem`
ADD INDEX `ix_xrefsystem_supplier` (`Supplier` ASC)
;
ALTER TABLE `t_xrefsystem`
ADD INDEX `ix_xrefsystem_type` (`Type` ASC)
;
CREATE TABLE `t_xrefuser`
(
`XrefID` VARCHAR(255) NOT NULL,
`Name` VARCHAR(255) ,
`Type` VARCHAR(255) NOT NULL,
`Visibility` VARCHAR(255) ,
`Namespace` VARCHAR(255) ,
`Requirement` VARCHAR(255) ,
`Constraint` VARCHAR(255) ,
`Behavior` VARCHAR(255) ,
`Partition` VARCHAR(255) ,
`Description` MEDIUMTEXT ,
`Client` VARCHAR(255) ,
`Supplier` VARCHAR(255) ,
`Link` VARCHAR(255) ,
`ToolID` VARCHAR(50) ,
CONSTRAINT `pk_xrefuser` PRIMARY KEY (`XrefID` ASC)
)
ENGINE=INNODB
;
ALTER TABLE `t_xrefuser`
ADD INDEX `ix_xrefuser_client` (`Client` ASC)
;
ALTER TABLE `t_xrefuser`
ADD INDEX `ix_xrefuser_supplier` (`Supplier` ASC)
;
ALTER TABLE `t_xrefuser`
ADD INDEX `ix_xrefuser_type` (`Type` ASC)
;
CREATE TABLE `usys_schema`
(
`V1558` VARCHAR(255) NOT NULL,
CONSTRAINT `PK_usys_schema` PRIMARY KEY (`V1558` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `usys_system`
(
`Property` VARCHAR(50) NOT NULL,
`Value` VARCHAR(50) ,
CONSTRAINT `pk_usyssystem` PRIMARY KEY (`Property` ASC)
)
ENGINE=INNODB
;
CREATE TABLE `usysoldtables`
(
`TableName` VARCHAR(50) ,
`NewName` VARCHAR(50) ,
`RelOrder` INT DEFAULT 0,
`FixCode` INT
)
ENGINE=INNODB
;
CREATE TABLE `usysqueries`
(
`QueryName` VARCHAR(50) ,
`NewName` VARCHAR(50) ,
`FixCode` INT
)
ENGINE=INNODB
;
CREATE TABLE `usystables`
(
`TableName` VARCHAR(50) NOT NULL,
`RelOrder` INT DEFAULT 0,
`DisplayName` VARCHAR(50) ,
`FromVer` VARCHAR(50) ,
`ToVer` VARCHAR(50) ,
CONSTRAINT `pk_usystables` PRIMARY KEY (`TableName` ASC)
)
ENGINE=INNODB
;
SET FOREIGN_KEY_CHECKS=1
;