博客
关于我
强烈建议你试试无所不能的chatGPT，快点击我
Enterprise Architect Schema Script.InnoDB
阅读量：5256 次
发布时间：2019-06-14

本文共 47645 字，大约阅读时间需要 158 分钟。

#------------------------------------------------

# Enterprise Architect Schema Script
# DBMS:     MySQL InnoDB
# VERSION:  From 4.                        
# CREATED:  21/1/2010            
# EA BUILD: 852     
#------------------------------------------------

#

# Table structure for table `t_attribute`
#
DROP TABLE IF EXISTS `t_attribute`;
CREATE TABLE `t_attribute` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Name` varchar(255) NOT NULL,
  `Scope` varchar(50) DEFAULT NULL,
  `Stereotype` varchar(50) DEFAULT NULL,
  `Containment` varchar(50) DEFAULT NULL,
  `IsStatic` int(11) DEFAULT '0',
  `IsCollection` int(11) DEFAULT '0',
  `IsOrdered` int(11) DEFAULT '0',
  `AllowDuplicates` int(11) DEFAULT '0',
  `LowerBound` varchar(50) DEFAULT NULL,
  `UpperBound` varchar(50) DEFAULT NULL,
  `Container` varchar(50) DEFAULT NULL,
  `Notes` text,
  `Derived` char(1) DEFAULT NULL,
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Pos` int(11) DEFAULT NULL,
  `GenOption` text,
  `Length` int(11) DEFAULT NULL,
  `Precision` int(11) DEFAULT NULL,
  `Scale` int(11) DEFAULT NULL,
  `Const` int(11) DEFAULT NULL,
  `Style` varchar(255) DEFAULT NULL,
  `Classifier` varchar(50) DEFAULT NULL,
  `Default` text,
  `Type` varchar(255) DEFAULT NULL,
  `ea_guid` varchar(40) NOT NULL,
  `StyleEx` text,
  PRIMARY KEY (`ID`),
  UNIQUE INDEX `ux_attribute_eaguid` (`ea_guid`),
  INDEX `ix_attribute_Name` (`Name`),
  INDEX `ix_attribute_Object_ID` (`Object_ID`),
  INDEX `ix_attribute_Classifier` (`Classifier`),
  INDEX `ix_attribute_Type` (`Type`)
) ENGINE=InnoDB;

#

# Table structure for table `t_attributeconstraints`
#

DROP TABLE IF EXISTS `t_attributeconstraints`;

CREATE TABLE `t_attributeconstraints` (
  `Object_ID` int(11) DEFAULT '0',
  `Constraint` varchar(255) NOT NULL,
  `AttName` varchar(255) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Notes` text,
  `ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`Constraint`)
) ENGINE=InnoDB;

#

# Table structure for table `t_attributetag`
#

DROP TABLE IF EXISTS `t_attributetag`;

CREATE TABLE `t_attributetag` (
  `PropertyID` int(11) NOT NULL AUTO_INCREMENT,
  `ElementID` int(11) NOT NULL DEFAULT '0',
  `Property` varchar(255) DEFAULT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  `NOTES` text,
  `ea_guid` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`PropertyID`),
  INDEX `ix_attributetag_ElementID` (`ElementID`),
  INDEX `ix_attributetag_value` (`VALUE`)
) ENGINE=InnoDB;

#

# Table structure for table `t_authors`
#

DROP TABLE IF EXISTS `t_authors`;

CREATE TABLE `t_authors` (
  `AuthorName` varchar(255) NOT NULL,
  `Roles` varchar(255) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`AuthorName`)
) ENGINE=InnoDB;

#

# Table structure for table `t_cardinality`
#

DROP TABLE IF EXISTS `t_cardinality`;

CREATE TABLE `t_cardinality` (
  `Cardinality` varchar(50) NOT NULL,
  PRIMARY KEY (`Cardinality`)
) ENGINE=InnoDB;

#

# Table structure for table `t_category`
#

DROP TABLE IF EXISTS `t_category`;

CREATE TABLE `t_category` (
  `CategoryID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `NOTES` text,
  PRIMARY KEY (`CategoryID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_clients`
#

DROP TABLE IF EXISTS `t_clients`;

CREATE TABLE `t_clients` (
  `Name` varchar(255) NOT NULL,
  `Organisation` varchar(255) DEFAULT NULL,
  `Phone1` varchar(50) DEFAULT NULL,
  `Phone2` varchar(50) DEFAULT NULL,
  `Mobile` varchar(50) DEFAULT NULL,
  `Fax` varchar(50) DEFAULT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `Roles` varchar(255) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=InnoDB;

#

# Table structure for table `t_complexitytypes`
#

DROP TABLE IF EXISTS `t_complexitytypes`;

CREATE TABLE `t_complexitytypes` (
  `Complexity` varchar(50) NOT NULL,
  `NumericWeight` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Complexity`),
  INDEX `ix_complexitytypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_connector`
#

DROP TABLE IF EXISTS `t_connector`;

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

#

# Table structure for table `t_connectorconstraint`
#

DROP TABLE IF EXISTS `t_connectorconstraint`;

CREATE TABLE `t_connectorconstraint` (
  `ConnectorID` int(11) NOT NULL DEFAULT '0',
  `Constraint` varchar(255) NOT NULL,
  `ConstraintType` varchar(50) DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`ConnectorID`,`Constraint`),
  INDEX `ObjectConstraintConstraint` (`Constraint`),
  INDEX `ObjectID` (`ConnectorID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_connectortag`
#

DROP TABLE IF EXISTS `t_connectortag`;

CREATE TABLE `t_connectortag` (
  `PropertyID` int(11) NOT NULL AUTO_INCREMENT,
  `ElementID` int(11) NOT NULL DEFAULT '0',
  `Property` varchar(255) DEFAULT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  `NOTES` text,
  `ea_guid` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`PropertyID`),
  INDEX `ix_connectortag_ElementID` (`ElementID`),
  INDEX `ix_connectortag_Property` (`Property`),
  INDEX `ix_connectortag_VALUE` (`VALUE`)
) ENGINE=InnoDB;

#

# Table structure for table `t_connectortypes`
#

DROP TABLE IF EXISTS `t_connectortypes`;

CREATE TABLE `t_connectortypes` (
  `Connector_Type` varchar(50) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Connector_Type`)
) ENGINE=InnoDB;

#

# Table structure for table `t_constants`
#

DROP TABLE IF EXISTS `t_constants`;

CREATE TABLE `t_constants` (
  `ConstantName` varchar(50) NOT NULL,
  `ConstantValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ConstantName`)
) ENGINE=InnoDB;

#

# Table structure for table `t_constrainttypes`
#

DROP TABLE IF EXISTS `t_constrainttypes`;

CREATE TABLE `t_constrainttypes` (
  `Constraint` varchar(16) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`Constraint`)
) ENGINE=InnoDB;

#

# Table structure for table `t_datatypes`
#

DROP TABLE IF EXISTS `t_datatypes`;

CREATE TABLE `t_datatypes` (
  `Type` varchar(50) NOT NULL,
  `ProductName` varchar(50) NOT NULL,
  `DataType` varchar(50) NOT NULL,
  `Size` int(11) DEFAULT NULL,
  `MaxLen` int(11) DEFAULT NULL,
  `MaxPrec` int(11) DEFAULT NULL,
  `MaxScale` int(11) DEFAULT '0',
  `DefaultLen` int(11) DEFAULT NULL,
  `DefaultPrec` int(11) DEFAULT NULL,
  `DefaultScale` int(11) DEFAULT NULL,
  `User` int(11) DEFAULT NULL,
  `PDATA1` varchar(255) DEFAULT NULL,
  `PDATA2` varchar(255) DEFAULT NULL,
  `PDATA3` varchar(255) DEFAULT NULL,
  `PDATA4` varchar(255) DEFAULT NULL,
  `HasLength` varchar(50) DEFAULT NULL,
  `GenericType` varchar(255) DEFAULT NULL,
  `DatatypeID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`DatatypeID`),
  INDEX `ix_datatypes_ProductName` (`ProductName`),
  INDEX `ix_datatypes_Datatype` (`Datatype`)
) ENGINE=InnoDB;

#

# Table structure for table `t_diagram`
#

DROP TABLE IF EXISTS `t_diagram`;

CREATE TABLE `t_diagram` (
  `Diagram_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Package_ID` int(11) NOT NULL DEFAULT '1',
  `ParentID` int(11) NOT NULL DEFAULT '0',
  `Diagram_Type` varchar(50) NOT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Version` varchar(50) DEFAULT '1.0',
  `Author` varchar(255) DEFAULT NULL,
  `ShowDetails` int(11) DEFAULT '0',
  `Notes` text,
  `Stereotype` varchar(50) DEFAULT NULL,
  `AttPub` int(11) DEFAULT NULL,
  `AttPri` int(11) DEFAULT NULL,
  `AttPro` int(11) DEFAULT NULL,
  `Orientation` char(1) DEFAULT 'P',
  `cx` int(11) DEFAULT '0',
  `cy` int(11) DEFAULT '0',
  `Scale` int(11) DEFAULT '100',
  `CreatedDate` date DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  `HTMLPath` varchar(255) DEFAULT NULL,
  `ShowForeign` int(11) DEFAULT NULL,
  `ShowBorder` int(11) DEFAULT NULL,
  `ShowPackageContents` int(11) DEFAULT NULL,
  `PDATA` varchar(255) DEFAULT NULL,
  `Locked` int(11) DEFAULT NULL,
  `ea_guid` varchar(40) NOT NULL,
  `TPos` int(11) DEFAULT NULL,
  `Swimlanes` varchar(255) DEFAULT NULL,
  `StyleEx` text,
  PRIMARY KEY (`Diagram_ID`),
  UNIQUE INDEX `ux_diagram_eaguid` (`ea_guid`),
  UNIQUE INDEX `ux_diagram_Diagram_ID` (`Diagram_ID`),
  INDEX `ix_diagram_Diagram_Type` (`Diagram_Type`),
  INDEX `ix_diagram_Package_ID` (`Package_ID`),
  INDEX `ix_diagram_ParentID` (`ParentID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_diagramlinks`
#

DROP TABLE IF EXISTS `t_diagramlinks`;

CREATE TABLE `t_diagramlinks` (
  `DiagramID` int(11) NOT NULL DEFAULT '0',
  `ConnectorID` int(11) NOT NULL DEFAULT '0',
  `Geometry` text,
  `Style` varchar(255) DEFAULT NULL,
  `Hidden` int(11) DEFAULT NULL,
  `Path` varchar(255) DEFAULT NULL,
  `Instance_ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Instance_ID`),
  INDEX `ix_diagramlinks_DiagramID` (`DiagramID`),
  INDEX `ix_diagramlinks_ConnectorID` (`ConnectorID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_diagramobjects`
#

DROP TABLE IF EXISTS `t_diagramobjects`;

CREATE TABLE `t_diagramobjects` (
  `Diagram_ID` int(11) NOT NULL DEFAULT '0',
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `RectTop` int(11) DEFAULT '0',
  `RectLeft` int(11) DEFAULT '0',
  `RectRight` int(11) DEFAULT '0',
  `RectBottom` int(11) DEFAULT '0',
  `Sequence` int(11) DEFAULT '0',
  `ObjectStyle` varchar(255) DEFAULT NULL,
  `Instance_ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Instance_ID`),
  INDEX `ix_diagramobjects_DiagramID` (`Diagram_ID`),
  INDEX `ix_diagramobjects_ObjectID` (`Object_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_diagramtypes`
#

DROP TABLE IF EXISTS `t_diagramtypes`;

CREATE TABLE `t_diagramtypes` (
  `Diagram_Type` varchar(50) NOT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Package_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Diagram_Type`),
  INDEX `ix_diagramtypes_PackageID` (`Package_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_document`
#

DROP TABLE IF EXISTS `t_document`;

CREATE TABLE `t_document` (
  `DocID` varchar(40) NOT NULL,
  `DocName` varchar(100) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  `Style` varchar(255) DEFAULT NULL,
  `ElementID` varchar(40) NOT NULL,
  `ElementType` varchar(50) NOT NULL,
  `StrContent` text,
  `BinContent` longblob,
  `DocType` varchar(100) DEFAULT NULL,
  `Author` varchar(255) DEFAULT NULL,
  `Version` varchar(50) DEFAULT NULL,
  `IsActive` int(11) DEFAULT '1',
  `Sequence` int(11) DEFAULT '0',
  `DocDate` datetime DEFAULT NULL,
  PRIMARY KEY (`DocID`),
  INDEX `ix_document_ElementID` (`ElementID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_ecf`
#

DROP TABLE IF EXISTS `t_ecf`;

CREATE TABLE `t_ecf` (
  `ECFID` varchar(12) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `Weight` double NOT NULL DEFAULT '1',
  `Value` double DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ECFID`),
  INDEX `ix_ecf_Weight` (`Weight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_efforttypes`
#

DROP TABLE IF EXISTS `t_efforttypes`;

CREATE TABLE `t_efforttypes` (
  `EffortType` varchar(12) NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '0',
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`EffortType`),
  INDEX `ix_efforttypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_files`
#

DROP TABLE IF EXISTS `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) DEFAULT NULL,
  `Notes` text,
  `FileDate` datetime DEFAULT NULL,
  `FileSize` int(11) DEFAULT NULL,
  PRIMARY KEY (`FileID`)
) ENGINE=InnoDB;

#
# Table structure for table `t_genopt`
#

DROP TABLE IF EXISTS `t_genopt`;

CREATE TABLE `t_genopt` (
  `AppliesTo` varchar(12) DEFAULT NULL,
  `Option` text
) ENGINE=InnoDB;

#

# Table structure for table `t_glossary`
#

DROP TABLE IF EXISTS `t_glossary`;

CREATE TABLE `t_glossary` (
  `Term` varchar(255) NOT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Meaning` text,
  `GlossaryID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Term`),
  INDEX `ix_glossary_GlossaryID` (`GlossaryID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_html`
#

DROP TABLE IF EXISTS `t_html`;

CREATE TABLE `t_html` (
  `Type` varchar(50) DEFAULT NULL,
  `Template` text
) ENGINE=InnoDB;

#

# Table structure for table `t_image`
#

DROP TABLE IF EXISTS `t_image`;

CREATE TABLE `t_image` (
  `ImageID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Image` longblob,
  PRIMARY KEY (`ImageID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_implement`
#

DROP TABLE IF EXISTS `t_implement`;

CREATE TABLE `t_implement` (
  `Type` varchar(50) DEFAULT NULL
) ENGINE=InnoDB;

#

# Table structure for table `t_issues`
#

DROP TABLE IF EXISTS `t_issues`;

CREATE TABLE `t_issues` (
  `Issue` varchar(255) DEFAULT NULL,
  `IssueDate` datetime DEFAULT '0000-00-00 00:00:00',
  `Owner` varchar(255) DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `Notes` text,
  `Resolver` varchar(255) DEFAULT NULL,
  `DateResolved` datetime DEFAULT NULL,
  `Resolution` text,
  `IssueID` int(11) NOT NULL AUTO_INCREMENT,
  `Category` varchar(255) DEFAULT NULL,
  `Priority` varchar(50) DEFAULT NULL,
  `Severity` varchar(50) DEFAULT NULL,
  `IssueType` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`IssueID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_lists`
#

DROP TABLE IF EXISTS `t_lists`;

CREATE TABLE `t_lists` (
  `ListID` varchar(50) NOT NULL,
  `Category` varchar(100) NOT NULL,
  `Name` varchar(150) NOT NULL,
  `NVal` int(11) DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`ListID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_mainttypes`
#

DROP TABLE IF EXISTS `t_mainttypes`;

CREATE TABLE `t_mainttypes` (
  `MaintType` varchar(12) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '1',
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`MaintType`),
  INDEX `ix_mainttypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_method`
#

DROP TABLE IF EXISTS `t_method`;

CREATE TABLE `t_method` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Name` varchar(255) NOT NULL,
  `Scope` varchar(50) DEFAULT NULL,
  `Type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Object_ID`,`Name`),
  INDEX `ix_method_Object_ID` (`Object_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_metrictypes`
#

DROP TABLE IF EXISTS `t_metrictypes`;

CREATE TABLE `t_metrictypes` (
  `Metric` varchar(12) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '1',
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Metric`),
  INDEX `ix_metrictypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_object`
#

DROP TABLE IF EXISTS `t_object`;

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

  INDEX `ix_object_Package_ID` (`Package_ID`),

  INDEX `ix_object_Object_Type` (`Object_Type`), 
  INDEX `ix_object_Classifier` (`Classifier`),
  INDEX `ix_object_EventFlags` (`EventFlags`),
  INDEX `ix_object_Classifier_guid` (`Classifier_guid`),
  INDEX `ix_object_Name` (`Name`),
  INDEX `ix_object_NType` (`NType`), 
  INDEX `ix_object_ParentID` (`ParentID`),
  INDEX `ix_object_PDATA1` (`PDATA1`),
  INDEX `ix_object_PckgID_PD1_Classifier` (`Package_ID`,`PDATA1`,`Classifier`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectconstraint`
#

DROP TABLE IF EXISTS `t_objectconstraint`;

CREATE TABLE `t_objectconstraint` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Constraint` varchar(255) NOT NULL,
  `ConstraintType` varchar(30) NOT NULL,
  `Weight` double DEFAULT NULL,
  `Notes` text,
  `Status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Object_ID`,`ConstraintType`,`Constraint`),
  INDEX `ix_objectconstraint_Constraint` (`Constraint`),
  INDEX `ix_objectconstraint_ObjectID` (`Object_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objecteffort`
#

DROP TABLE IF EXISTS `t_objecteffort`;

CREATE TABLE `t_objecteffort` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Effort` varchar(255) NOT NULL,
  `EffortType` varchar(12) DEFAULT NULL,
  `EValue` double DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`Object_ID`,`Effort`),
  INDEX `ix_objecteffort_ObjectID` (`Object_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectfiles`
#

DROP TABLE IF EXISTS `t_objectfiles`;

CREATE TABLE `t_objectfiles` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `FileName` varchar(255) NOT NULL,
  `Type` varchar(50) DEFAULT NULL,
  `Note` text,
  `FileSize` varchar(255) DEFAULT NULL,
  `FileDate` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Object_ID`,`FileName`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectmetrics`
#

DROP TABLE IF EXISTS `t_objectmetrics`;

CREATE TABLE `t_objectmetrics` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Metric` varchar(255) NOT NULL,
  `MetricType` varchar(12) NOT NULL,
  `EValue` double DEFAULT '1',
  `Notes` text,
  PRIMARY KEY (`Object_ID`,`Metric`),
  INDEX `ix_objectmetrics_MetricType` (`MetricType`),
  INDEX `ix_objectmetrics_ObjectID` (`Object_ID`),
  INDEX `ix_objectmetrics_Metric` (`Metric`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectproblems`
#

DROP TABLE IF EXISTS `t_objectproblems`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_objectproblems` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Problem` varchar(255) NOT NULL,
  `ProblemType` varchar(255) NOT NULL,
  `DateReported` date DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `ProblemNotes` text,
  `ReportedBy` varchar(255) DEFAULT NULL,
  `ResolvedBy` varchar(255) DEFAULT NULL,
  `DateResolved` date DEFAULT NULL,
  `Version` varchar(50) DEFAULT NULL,
  `ResolverNotes` text,
  `Priority` varchar(50) DEFAULT NULL,
  `Severity` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Object_ID`,`ProblemType`,`Problem`),
  INDEX `ix_objectproblems_Object_ID` (`Object_ID`),
  INDEX `ix_objectproblems_Problem` (`Problem`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectproperties`
#

DROP TABLE IF EXISTS `t_objectproperties`;

CREATE TABLE `t_objectproperties` (
  `PropertyID` int(11) NOT NULL AUTO_INCREMENT,
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Property` varchar(255) DEFAULT NULL,
  `Value` varchar(255) DEFAULT NULL,
  `Notes` text,
  `ea_guid` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`PropertyID`),
  INDEX `ix_objectproperties_Object_ID` (`Object_ID`),
  INDEX `ix_objectproperties_Value` (`Value`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectrequires`
#

DROP TABLE IF EXISTS `t_objectrequires`;

CREATE TABLE `t_objectrequires` (
  `ReqID` int(11) NOT NULL AUTO_INCREMENT,
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Requirement` varchar(255) DEFAULT NULL,
  `ReqType` varchar(255) DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `Notes` text,
  `Stability` varchar(50) DEFAULT NULL,
  `Difficulty` varchar(50) DEFAULT NULL,
  `Priority` varchar(50) DEFAULT NULL,
  `LastUpdate` varchar(19) DEFAULT NULL,
  PRIMARY KEY (`ReqID`),
  INDEX `ix_objectrequires_Object_ID` (`Object_ID`),
  INDEX `ix_objectrequires_Requirement` (`Requirement`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectresource`
#

DROP TABLE IF EXISTS `t_objectresource`;

CREATE TABLE `t_objectresource` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Resource` varchar(255) NOT NULL,
  `Role` varchar(255) NOT NULL,
  `Time` double DEFAULT NULL,
  `Notes` text,
  `PercentComplete` smallint(6) DEFAULT '0',
  `DateStart` date DEFAULT NULL,
  `DateEnd` date DEFAULT NULL,
  `History` text,
  `ExpectedHours` int(11) DEFAULT '0',
  `ActualHours` int(11) DEFAULT '0',
  PRIMARY KEY (`Object_ID`,`Resource`,`Role`),
  INDEX `ix_objectresource_ObjectID` (`Object_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectrisks`
#

DROP TABLE IF EXISTS `t_objectrisks`;

CREATE TABLE `t_objectrisks` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Risk` varchar(255) NOT NULL,
  `RiskType` varchar(12) DEFAULT NULL,
  `EValue` double DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`Object_ID`,`Risk`),
  INDEX `ix_objectrisks_ObjectID` (`Object_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objectscenarios`
#

DROP TABLE IF EXISTS `t_objectscenarios`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_objectscenarios` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Scenario` varchar(255) NOT NULL,
  `ScenarioType` varchar(12) DEFAULT NULL,
  `EValue` double DEFAULT NULL,
  `Notes` text,
  `ea_guid` varchar(40) NOT NULL,
  `XMLContent` text,
  PRIMARY KEY (`Object_ID`,`Scenario`),
  INDEX `ix_objectscenarios_Object_ID` (`Object_ID`),
  INDEX `ix_objectscenarios_idevalscen` (`Object_ID`,`EValue`,`Scenario`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objecttests`
#

DROP TABLE IF EXISTS `t_objecttests`;

CREATE TABLE `t_objecttests` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Test` varchar(255) NOT NULL,
  `TestClass` int(11) NOT NULL DEFAULT '0',
  `TestType` varchar(50) DEFAULT NULL,
  `Notes` text,
  `InputData` text,
  `AcceptanceCriteria` text,
  `Status` varchar(32) DEFAULT NULL,
  `DateRun` date DEFAULT NULL,
  `Results` text,
  `RunBy` varchar(255) DEFAULT NULL,
  `CheckBy` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Object_ID`,`Test`,`TestClass`),
  INDEX `ix_objecttests_ObjectID` (`Object_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objecttrx`
#

DROP TABLE IF EXISTS `t_objecttrx`;

CREATE TABLE `t_objecttrx` (
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `TRX` varchar(255) NOT NULL,
  `TRXType` varchar(12) NOT NULL,
  `Weight` double DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`Object_ID`,`TRXType`,`TRX`),
  INDEX `ix_objecttrx_TRX` (`TRX`),
  INDEX `ix_objecttrx_ObjectID` (`Object_ID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_objecttypes`
#

DROP TABLE IF EXISTS `t_objecttypes`;

CREATE TABLE `t_objecttypes` (
  `Object_Type` varchar(50) NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `DesignObject` int(11) DEFAULT NULL,
  `ImageID` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Object_Type`),
  INDEX `ix_objecttypes_ImageID` (`ImageID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_ocf`
#

DROP TABLE IF EXISTS `t_ocf`;

CREATE TABLE `t_ocf` (
  `ObjectType` varchar(50) DEFAULT NULL,
  `ComplexityWeight` double DEFAULT NULL
) ENGINE=InnoDB;

#

# Table structure for table `t_operation`
#

DROP TABLE IF EXISTS `t_operation`;

CREATE TABLE `t_operation` (
  `OperationID` int(11) NOT NULL AUTO_INCREMENT,
  `Object_ID` int(11) NOT NULL DEFAULT '0',
  `Name` varchar(255) NOT NULL,
  `Scope` varchar(50) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `ReturnArray` char(1) DEFAULT NULL,
  `Stereotype` varchar(50) DEFAULT NULL,
  `IsStatic` char(1) DEFAULT NULL,
  `Concurrency` varchar(50) DEFAULT NULL,
  `Notes` text,
  `Behaviour` text,
  `Abstract` char(1) DEFAULT NULL,
  `GenOption` text,
  `Synchronized` char(1) DEFAULT NULL,
  `Pos` int(11) DEFAULT NULL,
  `Const` int(11) DEFAULT NULL,
  `Style` varchar(255) DEFAULT NULL,
  `Pure` int(11) DEFAULT NULL,
  `Throws` varchar(255) DEFAULT NULL,
  `Classifier` varchar(50) DEFAULT NULL,
  `Code` text,
  `IsRoot` int(11) DEFAULT NULL,
  `IsLeaf` int(11) DEFAULT NULL,
  `IsQuery` int(11) DEFAULT NULL,
  `StateFlags` varchar(255) DEFAULT NULL,
  `ea_guid` varchar(50) NOT NULL,
  `StyleEx` text,
  PRIMARY KEY (`OperationID`),
  UNIQUE INDEX `ux_operation_ea_guid` (`ea_guid`),
  INDEX `ix_operation_Name` (`Name`),
  INDEX `ix_operation_Object_ID` (`Object_ID`),
  INDEX `ix_operation_Classifier` (`Classifier`)
) ENGINE=InnoDB;

#

# Table structure for table `t_operationparams`
#

DROP TABLE IF EXISTS `t_operationparams`;

CREATE TABLE `t_operationparams` (
  `OperationID` int(11) NOT NULL DEFAULT '0',
  `Name` varchar(255) NOT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Default` varchar(255) DEFAULT NULL,
  `Notes` text,
  `Pos` int(11) NOT NULL DEFAULT '0',
  `Const` int(11) DEFAULT NULL,
  `Style` varchar(255) DEFAULT NULL,
  `Kind` varchar(12) DEFAULT NULL,
  `Classifier` varchar(50) DEFAULT NULL,
  `ea_guid` varchar(50) NOT NULL,
  `StyleEx` text,
  PRIMARY KEY (`OperationID`,`Name`),
  UNIQUE INDEX `ix_operationparams_ea_guid` (`ea_guid`),
  INDEX `ix_operationparams_OperationID` (`OperationID`),
  INDEX `ix_operationparams_OpID_Pos` (`OperationID`,`Pos`),
  INDEX `ix_operationparams_Classifier` (`Classifier`)
) ENGINE=InnoDB;

#

# Table structure for table `t_operationposts`
#

DROP TABLE IF EXISTS `t_operationposts`;

CREATE TABLE `t_operationposts` (
  `OperationID` int(11) NOT NULL DEFAULT '0',
  `PostCondition` varchar(255) NOT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`OperationID`,`PostCondition`),
  INDEX `ix_operationposts_OperationID` (`OperationID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_operationpres`
#

DROP TABLE IF EXISTS `t_operationpres`;

CREATE TABLE `t_operationpres` (
  `OperationID` int(11) NOT NULL DEFAULT '0',
  `PreCondition` varchar(255) NOT NULL,
  `Type` varchar(50) DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`OperationID`,`PreCondition`),
  INDEX `ix_operationpres_OperationID` (`OperationID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_operationtag`
#

DROP TABLE IF EXISTS `t_operationtag`;

CREATE TABLE `t_operationtag` (
  `PropertyID` int(11) NOT NULL AUTO_INCREMENT,
  `ElementID` int(11) NOT NULL DEFAULT '0',
  `Property` varchar(255) DEFAULT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  `NOTES` text,
  `ea_guid` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`PropertyID`),
  INDEX `ix_operationtag_ElementID` (`ElementID`),
  INDEX `ix_operationtag_VALUE` (`VALUE`)
) ENGINE=InnoDB;

#

# Table structure for table `t_package`
#

DROP TABLE IF EXISTS `t_package`;

CREATE TABLE `t_package` (
  `Package_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `Parent_ID` int(11) NOT NULL DEFAULT '0',
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `Notes` text,
  `ea_guid` varchar(40) NOT NULL,
  `XMLPath` varchar(255) DEFAULT NULL,
  `IsControlled` int(11) DEFAULT NULL,
  `LastLoadDate` datetime DEFAULT NULL,
  `LastSaveDate` datetime DEFAULT NULL,
  `Version` varchar(50) DEFAULT NULL,
  `Protected` int(11) DEFAULT NULL,
  `PkgOwner` varchar(255) DEFAULT NULL,
  `UMLVersion` varchar(50) DEFAULT NULL,
  `UseDTD` int(11) DEFAULT NULL,
  `LogXML` int(11) DEFAULT NULL,
  `CodePath` varchar(255) DEFAULT NULL,
  `Namespace` varchar(50) DEFAULT NULL,
  `TPos` int(11) DEFAULT NULL,
  `PackageFlags` varchar(255) DEFAULT NULL,
  `BatchSave` int(11) DEFAULT '0',
  `BatchLoad` int(11) DEFAULT '0',
  PRIMARY KEY (`Package_ID`),
  UNIQUE INDEX `ux_package_ea_guid` (`ea_guid`),
  INDEX `ix_package_ParentID` (`Parent_ID`),
  INDEX `ix_package_Name` (`Name`)
) ENGINE=InnoDB;

#

# Table structure for table `t_palette`
#

DROP TABLE IF EXISTS `t_palette`;

CREATE TABLE `t_palette` (
  `PaletteID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  INDEX `PaletteID` (`PaletteID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_paletteitem`
#

DROP TABLE IF EXISTS `t_paletteitem`;

CREATE TABLE `t_paletteitem` (
  `PaletteID` int(11) DEFAULT NULL,
  `ItemID` int(11) DEFAULT NULL
) ENGINE=InnoDB;

#

# Table structure for table `t_phase`
#

DROP TABLE IF EXISTS `t_phase`;

CREATE TABLE `t_phase` (
  `PhaseID` varchar(40) NOT NULL,
  `PhaseName` varchar(100) NOT NULL,
  `PhaseNotes` text,
  `PhaseStyle` varchar(255) DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `PhaseContent` text,
  PRIMARY KEY (`PhaseID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_primitives`
#

DROP TABLE IF EXISTS `t_primitives`;

CREATE TABLE `t_primitives` (
  `Datatype` varchar(50) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Datatype`)
) ENGINE=InnoDB;

#

# Table structure for table `t_problemtypes`
#

DROP TABLE IF EXISTS `t_problemtypes`;

CREATE TABLE `t_problemtypes` (
  `ProblemType` varchar(12) NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '1',
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ProblemType`),
  INDEX `ix_problemtypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_projectroles`
#

DROP TABLE IF EXISTS `t_projectroles`;

CREATE TABLE `t_projectroles` (
  `Role` varchar(255) NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`Role`)
) ENGINE=InnoDB;

#

# Table structure for table `t_propertytypes`
#

DROP TABLE IF EXISTS `t_propertytypes`;

CREATE TABLE `t_propertytypes` (
  `Property` varchar(50) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`Property`)
) ENGINE=InnoDB;

#

# Table structure for table `t_requiretypes`
#

DROP TABLE IF EXISTS `t_requiretypes`;

CREATE TABLE `t_requiretypes` (
  `Requirement` varchar(12) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '1',
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Requirement`),
  INDEX `ix_requiretypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_resources`
#

DROP TABLE IF EXISTS `t_resources`;

CREATE TABLE `t_resources` (
  `Name` varchar(255) NOT NULL,
  `Organisation` varchar(255) DEFAULT NULL,
  `Phone1` varchar(50) DEFAULT NULL,
  `Phone2` varchar(50) DEFAULT NULL,
  `Mobile` varchar(50) DEFAULT NULL,
  `Fax` varchar(50) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Roles` varchar(255) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=InnoDB;

#

# Table structure for table `t_risktypes`
#

DROP TABLE IF EXISTS `t_risktypes`;

CREATE TABLE `t_risktypes` (
  `Risk` varchar(12) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '0',
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Risk`),
  INDEX `ix_risktypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_roleconstraint`
#

DROP TABLE IF EXISTS `t_roleconstraint`;

CREATE TABLE `t_roleconstraint` (
  `ConnectorID` int(11) NOT NULL DEFAULT '0',
  `Constraint` varchar(255) NOT NULL,
  `ConnectorEnd` varchar(50) NOT NULL,
  `ConstraintType` varchar(12) NOT NULL,
  `Notes` text,
  PRIMARY KEY (`ConnectorID`,`Constraint`,`ConnectorEnd`,`ConstraintType`),
  INDEX `ix_roleconstraint_Constraint` (`Constraint`),
  INDEX `ix_roleconstraint_ConnectorID` (`ConnectorID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_rtf`
#

DROP TABLE IF EXISTS `t_rtf`;

CREATE TABLE `t_rtf` (
  `Type` varchar(50) DEFAULT NULL,
  `Template` text
) ENGINE=InnoDB;

#

# Table structure for table `t_rtfreport`
#

DROP TABLE IF EXISTS `t_rtfreport`;

CREATE TABLE `t_rtfreport` (
  `TemplateID` varchar(200) NOT NULL,
  `RootPackage` int(11) DEFAULT '0',
  `Filename` varchar(255) DEFAULT NULL,
  `Details` int(3) DEFAULT NULL,
  `ProcessChildren` int(3) DEFAULT NULL,
  `ShowDiagrams` int(3) DEFAULT NULL,
  `Heading` varchar(255) DEFAULT NULL,
  `Requirements` int(3) DEFAULT NULL,
  `Associations` int(3) DEFAULT NULL,
  `Scenarios` int(3) DEFAULT NULL,
  `ChildDiagrams` int(3) DEFAULT NULL,
  `Attributes` int(3) DEFAULT NULL,
  `Methods` int(3) DEFAULT NULL,
  `ImageType` int(11) DEFAULT '0',
  `Paging` int(3) DEFAULT NULL,
  `Intro` text,
  `Resources` int(3) DEFAULT NULL,
  `Constraints` int(3) DEFAULT NULL,
  `Tagged` int(3) DEFAULT NULL,
  `ShowTag` int(3) DEFAULT NULL,
  `ShowAlias` int(3) DEFAULT NULL,
  `PDATA1` varchar(255) DEFAULT NULL,
  `PDATA2` varchar(255) DEFAULT NULL,
  `PDATA3` varchar(255) DEFAULT NULL,
  `PDATA4` text,
  PRIMARY KEY (`TemplateID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_rules`
#

DROP TABLE IF EXISTS `t_rules`;

CREATE TABLE `t_rules` (
  `RuleID` varchar(50) NOT NULL,
  `RuleName` varchar(255) NOT NULL,
  `RuleType` varchar(255) NOT NULL,
  `RuleActive` int(11) NOT NULL DEFAULT '0',
  `ErrorMsg` varchar(255) DEFAULT NULL,
  `Flags` varchar(255) DEFAULT NULL,
  `RuleOCL` text,
  `RuleXML` text,
  `Notes` text,
  PRIMARY KEY (`RuleID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_scenariotypes`
#

DROP TABLE IF EXISTS `t_scenariotypes`;

CREATE TABLE `t_scenariotypes` (
  `ScenarioType` varchar(12) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '1',
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ScenarioType`),
  INDEX `ix_scenariotypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_script`
#

DROP TABLE IF EXISTS `t_script`;

CREATE TABLE `t_script` (
  `ScriptID` int(11) NOT NULL AUTO_INCREMENT,
  `ScriptCategory` varchar(100) DEFAULT NULL,
  `ScriptName` varchar(150) DEFAULT NULL,
  `ScriptAuthor` varchar(255) DEFAULT NULL,
  `Notes` text,
  `Script` text,
  PRIMARY KEY (`ScriptID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_secgroup`
#

DROP TABLE IF EXISTS `t_secgroup`;

CREATE TABLE `t_secgroup` (
  `GroupID` varchar(40) NOT NULL,
  `GroupName` varchar(32) NOT NULL,
  `Description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`GroupID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_secgrouppermission`
#

DROP TABLE IF EXISTS `t_secgrouppermission`;

CREATE TABLE `t_secgrouppermission` (
  `GroupID` varchar(40) NOT NULL,
  `PermissionID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`GroupID`,`PermissionID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_seclocks`
#

DROP TABLE IF EXISTS `t_seclocks`;

CREATE TABLE `t_seclocks` (
  `UserID` varchar(40) NOT NULL,
  `GroupID` varchar(40) DEFAULT NULL,
  `EntityType` varchar(32) NOT NULL,
  `EntityID` varchar(40) NOT NULL,
  `Timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `LockType` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`EntityID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_secpermission`
#

DROP TABLE IF EXISTS `t_secpermission`;

CREATE TABLE `t_secpermission` (
  `PermissionID` int(11) NOT NULL DEFAULT '0',
  `PermissionName` varchar(50) NOT NULL,
  PRIMARY KEY (`PermissionID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_secpolicies`
#

DROP TABLE IF EXISTS `t_secpolicies`;

CREATE TABLE `t_secpolicies` (
  `Property` varchar(100) NOT NULL,
  `Value` varchar(255) NOT NULL,
  PRIMARY KEY (`Property`)
) ENGINE=InnoDB;

#

# Table structure for table `t_secuser`
#

DROP TABLE IF EXISTS `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) DEFAULT NULL,
  `Password` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`UserID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_secusergroup`
#

DROP TABLE IF EXISTS `t_secusergroup`;

CREATE TABLE `t_secusergroup` (
  `UserID` varchar(40) NOT NULL,
  `GroupID` varchar(40) NOT NULL,
  PRIMARY KEY (`UserID`,`GroupID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_secuserpermission`
#

DROP TABLE IF EXISTS `t_secuserpermission`;

CREATE TABLE `t_secuserpermission` (
  `UserID` varchar(40) NOT NULL,
  `PermissionID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`UserID`,`PermissionID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_snapshot`
#

DROP TABLE IF EXISTS `t_snapshot`;

CREATE TABLE `t_snapshot` (
  `SnapshotID` varchar(40) NOT NULL,
  `SeriesID` varchar(40) NOT NULL,
  `Position` int(11) NOT NULL DEFAULT '0',
  `SnapshotName` varchar(100) NOT NULL,
  `Notes` text,
  `Style` varchar(255) NOT NULL,
  `ElementID` varchar(40) DEFAULT NULL,
  `ElementType` varchar(50) NOT NULL,
  `StrContent` text,
  `BinContent1` longblob,
  `BinContent2` longblob,
  PRIMARY KEY (`SnapshotID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_statustypes`
#

DROP TABLE IF EXISTS `t_statustypes`;

CREATE TABLE `t_statustypes` (
  `Status` varchar(50) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Status`)
) ENGINE=InnoDB;

#

# Table structure for table `t_stereotypes`
#

DROP TABLE IF EXISTS `t_stereotypes`;

CREATE TABLE `t_stereotypes` (
  `Stereotype` varchar(255) NOT NULL,
  `AppliesTo` varchar(255) NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `MFEnabled` int(11) DEFAULT NULL,
  `MFPath` varchar(255) DEFAULT NULL,
  `Metafile` longblob,
  `Style` text,
  `ea_guid` varchar(50) NOT NULL,
  `VisualType` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`AppliesTo`,`Stereotype`),
  INDEX `ix_stereotypes_Stereotype` (`Stereotype`)
) ENGINE=InnoDB;

#

# Table structure for table `t_taggedvalue`
#

DROP TABLE IF EXISTS `t_taggedvalue`;

CREATE TABLE `t_taggedvalue` (
  `PropertyID` varchar(40) NOT NULL,
  `ElementID` varchar(40) NOT NULL,
  `BaseClass` varchar(100) NOT NULL,
  `TagValue` text,
  `Notes` text,
  PRIMARY KEY (`PropertyID`),
  INDEX `ix_taggedvalue_ElementID` (`ElementID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_tasks`
#

DROP TABLE IF EXISTS `t_tasks`;

CREATE TABLE `t_tasks` (
  `TaskID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `TaskType` varchar(255) DEFAULT NULL,
  `NOTES` text,
  `Priority` varchar(255) DEFAULT NULL,
  `Status` varchar(255) DEFAULT NULL,
  `Owner` varchar(255) DEFAULT NULL,
  `StartDate` date DEFAULT NULL,
  `EndDate` date DEFAULT NULL,
  `Phase` varchar(50) DEFAULT NULL,
  `History` text,
  `Percent` int(11) DEFAULT NULL,
  `TotalTime` int(11) DEFAULT NULL,
  `ActualTime` int(11) DEFAULT NULL,
  `AssignedTo` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`TaskID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_tcf`
#

DROP TABLE IF EXISTS `t_tcf`;

CREATE TABLE `t_tcf` (
  `TCFID` varchar(12) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `Weight` double NOT NULL DEFAULT '1',
  `Value` double DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`TCFID`),
  INDEX `ix_tcf_Weight` (`Weight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_template`
#

DROP TABLE IF EXISTS `t_template`;

CREATE TABLE `t_template` (
  `TemplateID` varchar(40) NOT NULL,
  `TemplateType` varchar(50) NOT NULL,
  `TemplateName` varchar(100) NOT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  `Style` varchar(255) DEFAULT NULL,
  `Template` text,
  PRIMARY KEY (`TemplateID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_testclass`
#

DROP TABLE IF EXISTS `t_testclass`;

CREATE TABLE `t_testclass` (
  `TestClass` varchar(50) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`TestClass`)
) ENGINE=InnoDB;

#

# Table structure for table `t_testplans`
#

DROP TABLE IF EXISTS `t_testplans`;

CREATE TABLE `t_testplans` (
  `PlanID` varchar(50) NOT NULL,
  `Category` varchar(100) NOT NULL,
  `Name` varchar(150) NOT NULL,
  `Author` varchar(255) DEFAULT NULL,
  `Notes` text,
  `TestPlan` text,
  PRIMARY KEY (`PlanID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_testtypes`
#

DROP TABLE IF EXISTS `t_testtypes`;

CREATE TABLE `t_testtypes` (
  `TestType` varchar(12) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '1',
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`TestType`),
  INDEX `ix_testtypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_trxtypes`
#

DROP TABLE IF EXISTS `t_trxtypes`;

CREATE TABLE `t_trxtypes` (
  `TRX` varchar(255) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `NumericWeight` double NOT NULL DEFAULT '1',
  `Notes` text,
  `Style` text,
  `TRX_ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`TRX_ID`),
  INDEX `ix_trxtypes_NumericWeight` (`NumericWeight`)
) ENGINE=InnoDB;

#

# Table structure for table `t_umlpattern`
#

DROP TABLE IF EXISTS `t_umlpattern`;

CREATE TABLE `t_umlpattern` (
  `PatternID` int(4) NOT NULL AUTO_INCREMENT,
  `PatternCategory` varchar(100) DEFAULT NULL,
  `PatternName` varchar(150) NOT NULL,
  `Style` varchar(250) DEFAULT NULL,
  `Notes` text,
  `PatternXML` text NOT NULL,
  `Version` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`PatternID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_version`
#

DROP TABLE IF EXISTS `t_version`;

CREATE TABLE `t_version` (
  `ElementID` varchar(50) NOT NULL,
  `VersionID` varchar(255) NOT NULL,
  `ElementType` varchar(100) NOT NULL,
  `Flags` varchar(255) DEFAULT NULL,
  `ExternalFile` varchar(255) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  `Owner` varchar(255) DEFAULT NULL,
  `VersionDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Branch` varchar(255) DEFAULT NULL,
  `ElementXML` text,
  PRIMARY KEY (`ElementID`,`VersionID`),
  INDEX `ix_version_elementID` (`ElementID`)
) ENGINE=InnoDB;

#

# Table structure for table `t_xref`
#

DROP TABLE IF EXISTS `t_xref`;

CREATE TABLE `t_xref` (
  `XrefID` varchar(255) NOT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Type` varchar(255) NOT NULL,
  `Visibility` varchar(255) DEFAULT NULL,
  `Namespace` varchar(255) DEFAULT NULL,
  `Requirement` varchar(255) DEFAULT NULL,
  `Constraint` varchar(255) DEFAULT NULL,
  `Behavior` varchar(255) DEFAULT NULL,
  `Partition` varchar(255) DEFAULT NULL,
  `Description` text,
  `Client` varchar(255) DEFAULT NULL,
  `Supplier` varchar(255) DEFAULT NULL,
  `Link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`XrefID`),
  INDEX `ix_xref_Client` (`Client`),
  INDEX `ix_xref_Supplier` (`Supplier`),
  INDEX `ix_xref_Type` (`Type`),
  INDEX `ix_xref_Name` (`Name`)
) ENGINE=InnoDB;

#

# Table structure for table `t_xrefsystem`
#

DROP TABLE IF EXISTS `t_xrefsystem`;

CREATE TABLE `t_xrefsystem` (
  `XrefID` varchar(255) NOT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Type` varchar(255) NOT NULL,
  `Visibility` varchar(255) DEFAULT NULL,
  `Namespace` varchar(255) DEFAULT NULL,
  `Requirement` varchar(255) DEFAULT NULL,
  `Constraint` varchar(255) DEFAULT NULL,
  `Behavior` varchar(255) DEFAULT NULL,
  `Partition` varchar(255) DEFAULT NULL,
  `Description` text,
  `Client` varchar(255) DEFAULT NULL,
  `Supplier` varchar(255) DEFAULT NULL,
  `Link` varchar(255) DEFAULT NULL,
  `ToolID` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`XrefID`),
  INDEX `ix_xrefsystem_Client` (`Client`),
  INDEX `ix_xrefsystem_Supplier` (`Supplier`),
  INDEX `ix_xrefsystem_Type` (`Type`)
) ENGINE=InnoDB;

#

# Table structure for table `t_xrefuser`
#

DROP TABLE IF EXISTS `t_xrefuser`;

CREATE TABLE `t_xrefuser` (
  `XrefID` varchar(255) NOT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Type` varchar(255) NOT NULL,
  `Visibility` varchar(255) DEFAULT NULL,
  `Namespace` varchar(255) DEFAULT NULL,
  `Requirement` varchar(255) DEFAULT NULL,
  `Constraint` varchar(255) DEFAULT NULL,
  `Behavior` varchar(255) DEFAULT NULL,
  `Partition` varchar(255) DEFAULT NULL,
  `Description` text,
  `Client` varchar(255) DEFAULT NULL,
  `Supplier` varchar(255) DEFAULT NULL,
  `Link` varchar(255) DEFAULT NULL,
  `ToolID` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`XrefID`),
  INDEX `ix_refuser_Client` (`Client`),
  INDEX `ix_refuser_Supplier` (`Supplier`),
  INDEX `ix_refuser_Type` (`Type`)
) ENGINE=InnoDB;

#

# Table structure for table `usys_system`
#

DROP TABLE IF EXISTS `usys_system`;

CREATE TABLE `usys_system` (
  `Property` varchar(50) NOT NULL,
  `Value` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Property`)
) ENGINE=InnoDB;

#

# Table structure for table `usystables`
#

DROP TABLE IF EXISTS `usystables`;

CREATE TABLE `usystables` (
  `TableName` varchar(50) NOT NULL,
  `RelOrder` int(11) DEFAULT '0',
  `DisplayName` varchar(50) DEFAULT NULL,
  `FromVer` varchar(50) DEFAULT NULL,
  `ToVer` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`TableName`)
) ENGINE=InnoDB;

#

# Table structure for table `usysoldtables`
#

DROP TABLE IF EXISTS `usysoldtables`;

CREATE TABLE `usysoldtables` (
  `TableName` varchar(50) DEFAULT NULL,
  `NewName` varchar(50) DEFAULT NULL,
  `RelOrder` int(11) DEFAULT '0',
  `FixCode` int(11) DEFAULT NULL
) ENGINE=InnoDB;

#

# Table structure for table `usysqueries`
#

DROP TABLE IF EXISTS `usysqueries`;

CREATE TABLE `usysqueries` (
  `QueryName` varchar(50) DEFAULT NULL,
  `NewName` varchar(50) DEFAULT NULL,
  `FixCode` int(11) DEFAULT NULL
) ENGINE=InnoDB;

</PRE></BODY></HTML>

转载于:https://www.cnblogs.com/snben/archive/2012/09/06/2672790.html

你可能感兴趣的文章
WSGI的理解
查看>>
mui轮播组件，滑动选项卡、导航内容相互切换
查看>>
live555二次开发经验总结：RTSPClient客户端与RTSPServer服务器
查看>>
webpack项目在开发环境中使用静态css文件
查看>>
C语言文件操作函数大全
查看>>
服务器swap
查看>>
杀MYSQL SLEEP进程
查看>>
多个有序链表的合并
查看>>
C++对C语言的拓展（5）—— 函数重载和函数指针结合
查看>>
hdu 2031 杨辉三角
查看>>
详解两种C#自动实现DLL(OCX)控件注册的方法
查看>>
浅谈echo、print、var_dump()、print_r()的区别
查看>>
jQuery 知识积累
查看>>
Sublime Text 3中文乱码问题的解决（最有效）
查看>>
如何将json格式的string字符串转换为string数组
查看>>
c++三/五法则
查看>>
强人工智能之“全本的鹦鹉”
查看>>
spring事物配置，声明式事务管理和基于@Transactional注解的使用（转）
查看>>
【BZOJ3215/3216】[ZJOI2013]话旧/话旧2（组合数学，动态规划）
查看>>
原生JS例子
查看>>
喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！-- 愿君每日到此一游！
当前时间: 2024-11-25 02:54:53   当前IP: 3.145.62.36   联系邮箱:javaeecc@qq.com     Copyright © 2020 - 2022 baihongyu.com 京ICP备2021015314号-2
强烈建议你试试无所不能的CHAT-GPT，快点击我
强烈建议你试试无所不能的CHAT-GPT，快点击我