/*
MySQL Backup
Source Host:           localhost
Source Server Version: 4.0.4-beta-max-nt
Source Database:       basemodel
Date:                  2002/11/05 14:39:05
*/

use basemodel ;
#----------------------------
# Table structure for 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),
   Stereotype varchar(50),
   Containment varchar(50),
   IsStatic int(11) default '0',
   IsCollection int(11) default '0',
   IsOrdered int(11) default '0',
   AllowDuplicates int(11) default '0',
   LowerBound varchar(50),
   UpperBound varchar(50),
   Container varchar(50),
   Notes text,
   Derived char(1),
   ID int(11) not null auto_increment,
   Pos int(11),
   GenOption text,
   `Length` int(11),
   `Precision` int(11),
   Scale int(11),
   Const int(11),
   Style varchar(255),
   Classifier varchar(50),
   `Default` text,
   `Type` varchar(255),
   ea_guid varchar(40) not null,
   StyleEx text,
   primary key (ID),
   unique ID (ID),
   index _D748CF3F_CD8D_4A32_BE6B_2AA1C5F121E2_ (Object_ID),
   index Name (Name),
   index Object_ID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   `Type` varchar(255),
   Notes text,
   ID int(11) not null default '0',
   primary key (ID, `Constraint`))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   VALUE varchar(255),
   NOTES text,
   ea_guid varchar(40),
   primary key (PropertyID),
   index ElementKey (ElementID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_authors
#----------------------------
drop table if exists t_authors;
create table t_authors (
   AuthorName varchar(255) not null,
   Roles varchar(255),
   Notes varchar(255),
   primary key (AuthorName))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_cardinality
#----------------------------
drop table if exists t_cardinality;
create table t_cardinality (
   Cardinality varchar(50) not null,
   primary key (Cardinality))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_category
#----------------------------
drop table if exists t_category;
create table t_category (
   CategoryID int(11) not null auto_increment,
   Name varchar(255),
   `Type` varchar(255),
   NOTES text,
   primary key (CategoryID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_clients
#----------------------------
drop table if exists t_clients;
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),
   primary key (Name))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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 NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_connector
#----------------------------
drop table if exists t_connector;
create table t_connector (
   Connector_ID int(11) not null auto_increment,
   Name varchar(255),
   Direction varchar(50),
   Notes text,
   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(50),
   SourceRoleType varchar(50),
   SourceRoleNote text,
   SourceContainment varchar(50),
   SourceIsAggregate int(11) default '0',
   SourceIsOrdered int(11) default '0',
   SourceQualifier varchar(50),
   DestRole varchar(50),
   DestRoleType varchar(50),
   DestRoleNote text,
   DestContainment varchar(50),
   DestIsAggregate int(11) default '0',
   DestIsOrdered int(11) default '0',
   DestQualifier varchar(50),
   Start_Object_ID int(11) not null default '0',
   End_Object_ID int(11) 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(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),
   VirtualInheritance char(1),
   LinkAccess varchar(50),
   PDATA1 varchar(255),
   PDATA2 varchar(255),
   PDATA3 varchar(255),
   PDATA4 varchar(255),
   PDATA5 varchar(255),
   DiagramID int(11) not null default '0',
   ea_guid varchar(40) not null,
   SourceConstraint varchar(255),
   DestConstraint varchar(255),
   SourceIsNavigable int(11),
   DestIsNavigable int(11),
   IsRoot int(11),
   IsLeaf int(11),
   IsSpec int(11),
   SourceChangeable varchar(12),
   DestChangeable varchar(12),
   SourceTS varchar(12),
   DestTS varchar(12),
   StateFlags varchar(255),
   ActionFlags varchar(255),
   IsSignal int(11),
   IsStimulus int(11),
   DispatchAction varchar(255),
   Target2 int(11),
   StyleEx text,
   SourceStereotype varchar(255),
   DestStereotype varchar(255),
   SourceStyle text,
   DestStyle text,
   EventFlags varchar(255),
   primary key (Connector_ID),
   unique IDX_GUID (ea_guid),
   unique Connector_ID (Connector_ID),
   index Connector_Type (Connector_Type),
   index DiagramID (DiagramID),
   index End_Object_ID (End_Object_ID),
   index Start_Object_ID (Start_Object_ID),
   index SeqNo (SeqNo))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Notes text,
   primary key (ConnectorID, `Constraint`),
   index ObjectConstraintConstraint (`Constraint`),
   index ObjectID (ConnectorID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   VALUE varchar(255),
   NOTES text,
   ea_guid varchar(40),
   primary key (PropertyID),
   index ElementKey (ElementID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_connectortypes
#----------------------------
drop table if exists t_connectortypes;
create table t_connectortypes (
   Connector_Type varchar(50) not null,
   Description varchar(50),
   primary key (Connector_Type))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_constants
#----------------------------
drop table if exists t_constants;
create table t_constants (
   ConstantName varchar(50) not null,
   ConstantValue varchar(255),
   primary key (ConstantName))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_constrainttypes
#----------------------------
drop table if exists t_constrainttypes;
create table t_constrainttypes (
   `Constraint` varchar(16) not null,
   Description varchar(50),
   Notes text,
   primary key (`Constraint`))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   MaxLen int(11),
   MaxPrec int(11),
   MaxScale int(11) default '0',
   DefaultLen int(11),
   DefaultPrec int(11),
   DefaultScale int(11),
   `User` int(11),
   PDATA1 varchar(255),
   PDATA2 varchar(255),
   PDATA3 varchar(255),
   PDATA4 varchar(255),
   HasLength varchar(50),
   GenericType varchar(255),
   DatatypeID int(11) not null auto_increment,
   primary key (DatatypeID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   `Version` varchar(50) default '1.0',
   Author varchar(255),
   ShowDetails int(11) default '0',
   Notes text,
   Stereotype varchar(50),
   AttPub int(11),
   AttPri int(11),
   AttPro int(11),
   Orientation char(1) default 'P',
   cx int(11) default '0',
   cy int(11) default '0',
   Scale int(11) default '100',
   CreatedDate date,
   ModifiedDate date,
   HTMLPath varchar(255),
   ShowForeign int(11),
   ShowBorder int(11),
   ShowPackageContents int(11),
   PDATA varchar(255),
   Locked int(11),
   ea_guid varchar(40) not null,
   TPos int(11),
   Swimlanes varchar(255),
   StyleEx text,
   primary key (Diagram_ID),
   unique IDX_GUID (ea_guid),
   unique Diagram_ID (Diagram_ID),
   index Diagram_Type (Diagram_Type),
   index Package_ID (Package_ID),
   index PackageDiagram (Package_ID),
   index ParentID (ParentID),
   index t_diagramtypest_diagram (Diagram_Type))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Hidden int(11),
   Path varchar(255),
   Instance_ID int(11) not null auto_increment,
   primary key (Instance_ID),
   index DiagramID (DiagramID),
   index ConnectorID (ConnectorID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Instance_ID int(11) not null auto_increment,
   primary key (Instance_ID),
   index DiagramID (Diagram_ID),
   index ObjectID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_diagramtypes
#----------------------------
drop table if exists t_diagramtypes;
create table t_diagramtypes (
   Diagram_Type varchar(50) not null,
   Name varchar(255),
   Package_ID int(11) not null default '0',
   primary key (Diagram_Type),
   index PackageDiagramTypes (Package_ID),
   index PackageID (Package_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_document
#----------------------------
drop table if exists t_document;
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 text,
   BinContent longblob,
   DocType varchar(100),
   Author varchar(255),
   `Version` varchar(50),
   IsActive int(11) default '1',
   Sequence int(11) default '0',
   DocDate datetime,
   primary key (DocID),
   index ElementID (ElementID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_ecf
#----------------------------
drop table if exists t_ecf;
create table t_ecf (
   ECFID varchar(12) not null,
   Description varchar(50),
   Weight double not null default '1',
   Value double,
   Notes varchar(255),
   primary key (ECFID),
   index NumericWeight (Weight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_efforttypes
#----------------------------
drop table if exists t_efforttypes;
create table t_efforttypes (
   EffortType varchar(12) not null,
   Description varchar(255),
   NumericWeight double not null default '0',
   Notes varchar(255),
   primary key (EffortType),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_files
#----------------------------
drop table if exists t_files;
create table t_files (
   FileID varchar(50) not null,
   AppliesTo varchar(100) not null,
   Category varchar(50) not null,
   Name varchar(150) not null,
   `File` varchar(255),
   Notes text,
   FileDate datetime,
   FileSize int(11),
   primary key (FileID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_genopt
#----------------------------
drop table if exists t_genopt;
create table t_genopt (
   AppliesTo varchar(12),
   `Option` text)
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_glossary
#----------------------------
drop table if exists t_glossary;
create table t_glossary (
   Term varchar(255) not null,
   `Type` varchar(255),
   Meaning text,
   GlossaryID int(11) not null auto_increment,
   primary key (Term),
   index GlossaryID (GlossaryID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_html
#----------------------------
drop table if exists t_html;
create table t_html (
   `Type` varchar(50),
   Template text)
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_image
#----------------------------
drop table if exists t_image;
create table t_image (
   ImageID int(11) not null auto_increment,
   Name varchar(255),
   `Type` varchar(255),
   Image longblob,
   primary key (ImageID),
   index ImageID (ImageID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_implement
#----------------------------
drop table if exists t_implement;
create table t_implement (
   `Type` varchar(50))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_issues
#----------------------------
drop table if exists t_issues;
create table t_issues (
   Issue varchar(255),
   IssueDate datetime default '0000-00-00 00:00:00',
   Owner varchar(255),
   `Status` varchar(255),
   Notes text,
   Resolver varchar(255),
   DateResolved datetime,
   Resolution text,
   IssueID int(11) not null auto_increment,
   Category varchar(255),
   Priority varchar(100),
   Severity varchar(50),
   IssueType varchar(100),
   primary key (IssueID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Notes text,
   primary key (ListID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_mainttypes
#----------------------------
drop table if exists t_mainttypes;
create table t_mainttypes (
   MaintType varchar(12) not null,
   Description varchar(50),
   NumericWeight double not null default '1',
   Notes varchar(255),
   primary key (MaintType),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   `Type` varchar(50),
   primary key (Object_ID, Name),
   index _1E62D3A8_F3CF_4E2A_B0A0_A7266C98C7DB_ (Object_ID),
   index Object_ID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_metrictypes
#----------------------------
drop table if exists t_metrictypes;
create table t_metrictypes (
   Metric varchar(12) not null,
   Description varchar(50),
   NumericWeight double not null default '1',
   Notes varchar(255),
   primary key (Metric),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_object
#----------------------------
drop table if exists t_object;
create table t_object (
   Object_ID int(11) not null auto_increment,
   Object_Type varchar(255),
   Diagram_ID int(11) default '0',
   Name varchar(255),
   Alias varchar(255),
   Author varchar(255),
   `Version` varchar(50) default '1.0',
   Note text,
   Package_ID int(11) not null default '0',
   Stereotype varchar(255),
   NType int(11) default '0',
   Complexity varchar(50) default '2',
   Effort int(11) default '0',
   Style varchar(255),
   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,
   ModifiedDate datetime,
   `Status` varchar(50),
   Abstract char(1),
   Tagged int(11) default '0',
   PDATA1 varchar(255),
   PDATA2 varchar(255),
   PDATA3 varchar(255),
   PDATA4 varchar(255),
   PDATA5 varchar(255),
   Concurrency varchar(50),
   Visibility varchar(50),
   Persistence varchar(50),
   Cardinality varchar(50),
   GenType varchar(50),
   GenFile varchar(255),
   Header1 text,
   Header2 text,
   Phase varchar(50),
   Scope varchar(25),
   GenOption text,
   GenLinks text,
   Classifier int(11),
   ea_guid varchar(40) not null,
   ParentID int(11),
   RunState text,
   Classifier_guid varchar(40),
   TPos int(11),
   IsRoot int(11),
   IsLeaf int(11),
   IsSpec int(11),
   IsActive int(11),
   StateFlags varchar(255),
   PackageFlags varchar(255),
   Multiplicity varchar(50),
   StyleEx text,
   ActionFlags varchar(255),
   EventFlags varchar(255),
   primary key (Object_ID),
   unique IDX_GUID (ea_guid),
   unique Object_ID (Object_ID),
   index Package_ID (Package_ID),
   index PackageObject (Package_ID),
   index Object_Type (Object_Type),
   index Classifier (Classifier))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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,
   Notes text,
   `Status` varchar(50),
   primary key (Object_ID, ConstraintType, `Constraint`),
   index ObjectConstraintConstraint (`Constraint`),
   index ObjectID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   EValue double,
   Notes text,
   primary key (Object_ID, Effort),
   index ObjectID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Note text,
   FileSize varchar(255),
   FileDate varchar(255),
   primary key (Object_ID, FileName))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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 _4284C791_A819_44C8_B0AD_41BCCD533E6A_ (MetricType),
   index ObjectID (Object_ID),
   index ObjectMetricsMetric (Metric))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_objectproblems
#----------------------------
drop table if exists t_objectproblems;
create table t_objectproblems (
   Object_ID int(11) not null default '0',
   Problem varchar(255) not null,
   ProblemType varchar(200) not null,
   DateReported date,
   `Status` varchar(50),
   ProblemNotes text,
   ReportedBy varchar(255),
   ResolvedBy varchar(255),
   DateResolved date,
   `Version` varchar(50),
   ResolverNotes text,
   Priority varchar(100),
   Severity varchar(50),
   primary key (Object_ID, ProblemType, Problem),
   index ObjectID (Object_ID),
   index ObjectRequiresRequirement (Problem))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Value varchar(255),
   Notes text,
   ea_guid varchar(40),
   primary key (PropertyID),
   index Object_ID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   ReqType varchar(255),
   `Status` varchar(50),
   Notes text,
   Stability varchar(50),
   Difficulty varchar(50),
   Priority varchar(50),
   LastUpdate varchar(19),
   primary key (ReqID),
   index ObjectID (Object_ID),
   index ObjectRequiresRequirement (Requirement),
   index ReqID (ReqID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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(200) not null,
   `Time` double,
   Notes text,
   PercentComplete smallint(6) default '0',
   DateStart date,
   DateEnd date,
   History text,
   ExpectedHours int(11) default '0',
   ActualHours int(11) default '0',
   primary key (Object_ID, Resource, Role),
   index ObjectID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   EValue double,
   Notes text,
   primary key (Object_ID, Risk),
   index ObjectID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_objectscenarios
#----------------------------
drop table if exists t_objectscenarios;
create table t_objectscenarios (
   Object_ID int(11) not null default '0',
   Scenario varchar(255) not null,
   ScenarioType varchar(12),
   EValue double,
   Notes text,
   ea_guid varchar(40) not null,
   XMLContent text,
   primary key (Object_ID, Scenario),
   index ObjectID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Notes text,
   InputData text,
   AcceptanceCriteria text,
   `Status` varchar(32),
   DateRun date,
   Results text,
   RunBy varchar(255),
   CheckBy varchar(255),
   primary key (Object_ID, Test, TestClass),
   index ObjectID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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,
   Notes text,
   primary key (Object_ID, TRXType, TRX),
   index ObjectConstraintConstraint (TRX),
   index ObjectID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_objecttypes
#----------------------------
drop table if exists t_objecttypes;
create table t_objecttypes (
   Object_Type varchar(50) not null,
   Description varchar(255),
   DesignObject int(11),
   ImageID smallint(6) not null default '0',
   primary key (Object_Type),
   index ImageID (ImageID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_ocf
#----------------------------
drop table if exists t_ocf;
create table t_ocf (
   ObjectType varchar(50),
   ComplexityWeight double)
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   `Type` varchar(255),
   ReturnArray char(1),
   Stereotype varchar(50),
   IsStatic char(1),
   Concurrency varchar(50),
   Notes text,
   Behaviour text,
   Abstract char(1),
   GenOption text,
   Synchronized char(1),
   Pos int(11),
   Const int(11),
   Style varchar(255),
   Pure int(11),
   Throws varchar(255),
   Classifier varchar(50),
   Code text,
   IsRoot int(11),
   IsLeaf int(11),
   IsQuery int(11),
   StateFlags varchar(255),
   ea_guid varchar(40) not null,
   StyleEx text,
   primary key (OperationID),
   unique OperationID (OperationID),
   index Name (Name),
   index Object_ID (Object_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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` varchar(255),
   Notes text,
   Pos int(11) not null default '0',
   Const int(11),
   Style varchar(255),
   Kind varchar(12),
   Classifier varchar(50),
   ea_guid varchar(40) not null,
   StyleEx text,
   primary key (OperationID, Name),
   index OperationID (OperationID),
   index Param (OperationID, Pos))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Notes text,
   primary key (OperationID, PostCondition),
   index OperationID (OperationID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Notes text,
   primary key (OperationID, PreCondition),
   index OperationID (OperationID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   VALUE varchar(255),
   NOTES text,
   ea_guid varchar(40),
   primary key (PropertyID),
   index ElementKey (ElementID))
   type=InnoDB comment="InnoDB free: 87040 kB";


#----------------------------
# Table structure for t_package
#----------------------------
drop table if exists t_package;
create table t_package (
   Package_ID int(11) not null auto_increment,
   Name varchar(255),
   Parent_ID int(11) not null default '0',
   CreatedDate datetime,
   ModifiedDate datetime,
   Notes text,
   ea_guid varchar(40) not null,
   XMLPath varchar(255),
   IsControlled int(11),
   LastLoadDate datetime,
   LastSaveDate datetime,
   `Version` varchar(50),
   Protected int(11),
   PkgOwner varchar(255),
   UMLVersion varchar(50),
   UseDTD int(11),
   LogXML int(11),
   CodePath varchar(255),
   Namespace varchar(50),
   TPos int(11),
   PackageFlags varchar(255),
   BatchSave int(11) default '0',
   BatchLoad int(11) default '0',
   primary key (Package_ID),
   unique IDX_GUID (ea_guid),
   unique Package_ID (Package_ID),
   index ParentID (Parent_ID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_palette
#----------------------------
drop table if exists t_palette;
create table t_palette (
   PaletteID int(11) not null auto_increment,
   Name varchar(255),
   `Type` varchar(255),
   index PaletteID (PaletteID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_paletteitem
#----------------------------
drop table if exists t_paletteitem;
create table t_paletteitem (
   PaletteID int(11),
   ItemID int(11))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   StartDate datetime,
   EndDate datetime,
   PhaseContent text,
   primary key (PhaseID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_primitives
#----------------------------
drop table if exists t_primitives;
create table t_primitives (
   Datatype varchar(50) not null,
   Description varchar(50),
   primary key (Datatype))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_problemtypes
#----------------------------
drop table if exists t_problemtypes;
create table t_problemtypes (
   ProblemType varchar(12) not null,
   Description varchar(255),
   NumericWeight double not null default '1',
   Notes varchar(255),
   primary key (ProblemType),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_projectroles
#----------------------------
drop table if exists t_projectroles;
create table t_projectroles (
   Role varchar(255) not null,
   Description varchar(255),
   Notes text,
   primary key (Role))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_propertytypes
#----------------------------
drop table if exists t_propertytypes;
create table t_propertytypes (
   Property varchar(50) not null,
   Description varchar(50),
   Notes text,
   primary key (Property))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_requiretypes
#----------------------------
drop table if exists t_requiretypes;
create table t_requiretypes (
   Requirement varchar(12) not null,
   Description varchar(50),
   NumericWeight double not null default '1',
   Notes varchar(255),
   primary key (Requirement),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_resources
#----------------------------
drop table if exists t_resources;
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),
   primary key (Name))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_risktypes
#----------------------------
drop table if exists t_risktypes;
create table t_risktypes (
   Risk varchar(12) not null,
   Description varchar(50),
   NumericWeight double not null default '0',
   Notes varchar(255),
   primary key (Risk),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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 ObjectConstraintConstraint (Constraint_),
   index ObjectID (ConnectorID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_rtf
#----------------------------
drop table if exists t_rtf;
create table t_rtf (
   `Type` varchar(50),
   Template text)
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Details int(3),
   ProcessChildren int(3),
   ShowDiagrams int(3),
   Heading varchar(255),
   Requirements int(3),
   Associations int(3),
   Scenarios int(3),
   ChildDiagrams int(3),
   Attributes int(3),
   Methods int(3),
   ImageType int(11) default '0',
   Paging int(3),
   Intro text,
   Resources int(3),
   Constraints int(3),
   Tagged int(3),
   ShowTag int(3),
   ShowAlias int(3),
   PDATA1 varchar(255),
   PDATA2 varchar(255),
   PDATA3 varchar(255),
   PDATA4 text,
   primary key (TemplateID),
   index RTFReportID (TemplateID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Flags varchar(255),
   RuleOCL text,
   RuleXML text,
   Notes text,
   primary key (RuleID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_scenariotypes
#----------------------------
drop table if exists t_scenariotypes;
create table t_scenariotypes (
   ScenarioType varchar(12) not null,
   Description varchar(50),
   NumericWeight double not null default '1',
   Notes varchar(255),
   primary key (ScenarioType),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_script
#----------------------------
drop table if exists t_script;
create table t_script (
   ScriptID int(11) not null auto_increment,
   ScriptCategory varchar(100),
   ScriptName varchar(150),
   ScriptAuthor varchar(255),
   Notes text,
   Script text,
   primary key (ScriptID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   primary key (GroupID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_seclocks
#----------------------------
drop table if exists t_seclocks;
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 '0000-00-00 00:00:00',
   LockType varchar(255),
   primary key (EntityID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   `Password` varchar(12),
   primary key (UserID),
   unique UserID (UserID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   ElementType varchar(50) not null,
   StrContent text,
   BinContent1 longblob,
   BinContent2 longblob,
   primary key (SnapshotID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_statustypes
#----------------------------
drop table if exists t_statustypes;
create table t_statustypes (
   `Status` varchar(50) not null,
   Description varchar(50),
   primary key (`Status`))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_stereotypes
#----------------------------
drop table if exists t_stereotypes;
create table t_stereotypes (
   Stereotype varchar(255) not null,
   AppliesTo varchar(200) not null,
   Description varchar(255),
   MFEnabled int(11),
   MFPath varchar(255),
   Metafile longblob,
   Style text,
   ea_guid varchar(40) not null,
   VisualType varchar(100),
   primary key (AppliesTo, Stereotype))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_taggedvalue
#----------------------------
drop table if exists t_taggedvalue;
create table t_taggedvalue (
   PropertyID varchar(40) not null,
   ElementID varchar(40) not null,
   BaseClass varchar(50) not null,
   TagValue text,
   Notes text,
   primary key (PropertyID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_tasks
#----------------------------
drop table if exists t_tasks;
create table t_tasks (
   TaskID int(11) not null auto_increment,
   Name varchar(255),
   TaskType varchar(255),
   NOTES text,
   Priority varchar(255),
   `Status` varchar(255),
   Owner varchar(255),
   StartDate date,
   EndDate date,
   Phase varchar(50),
   History text,
   Percent int(11),
   TotalTime int(11),
   ActualTime int(11),
   AssignedTo varchar(250),
   primary key (TaskID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_tcf
#----------------------------
drop table if exists t_tcf;
create table t_tcf (
   TCFID varchar(12) not null,
   Description varchar(50),
   Weight double not null default '1',
   Value double,
   Notes varchar(255),
   primary key (TCFID),
   index NumericWeight (Weight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   Style varchar(255),
   Template text,
   primary key (TemplateID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_testclass
#----------------------------
drop table if exists t_testclass;
create table t_testclass (
   TestClass varchar(50) not null,
   Description varchar(50),
   primary key (TestClass))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_testplans
#----------------------------
drop table if exists t_testplans;
create table t_testplans (
   PlanID varchar(50) not null,
   Category varchar(100) not null,
   Name varchar(100) not null,
   Author varchar(255),
   Notes text,
   TestPlan text,
   primary key (PlanID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_testtypes
#----------------------------
drop table if exists t_testtypes;
create table t_testtypes (
   TestType varchar(12) not null,
   Description varchar(50),
   NumericWeight double not null default '1',
   Notes varchar(255),
   primary key (TestType),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_trxtypes
#----------------------------
drop table if exists t_trxtypes;
create table t_trxtypes (
   TRX varchar(255) not null,
   Description varchar(50),
   NumericWeight double not null default '1',
   Notes text,
   Style text,
   TRX_ID int(11) not null auto_increment,
   primary key (TRX_ID),
   index NumericWeight (NumericWeight))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_umlpattern
#----------------------------
drop table if exists t_umlpattern;
create table t_umlpattern (
   PatternID int(4) not null auto_increment,
   PatternCategory varchar(100),
   PatternName varchar(150) not null,
   Style varchar(250),
   Notes text,
   PatternXML text not null,
   `Version` varchar(50),
   primary key (PatternID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for 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),
   ExternalFile varchar(255),
   Notes varchar(255),
   Owner varchar(255),
   VersionDate datetime not null default '0000-00-00 00:00:00',
   Branch varchar(255),
   ElementXML text,
   primary key (ElementID, VersionID))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_xref
#----------------------------
drop table if exists t_xref;
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 text,
   Client varchar(255),
   Supplier varchar(255),
   Link varchar(255),
   primary key (XrefID),
   index XRefClient (Client),
   index XRefSupplier (Supplier),
   index XRefType (`Type`))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_xrefsystem
#----------------------------
drop table if exists t_xrefsystem;
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 text,
   Client varchar(255),
   Supplier varchar(255),
   Link varchar(255),
   ToolID varchar(50),
   primary key (XrefID),
   index XRefClient (Client),
   index XRefSupplier (Supplier),
   index XRefType (`Type`))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for t_xrefuser
#----------------------------
drop table if exists t_xrefuser;
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 text,
   Client varchar(255),
   Supplier varchar(255),
   Link varchar(255),
   ToolID varchar(50),
   primary key (XrefID),
   index XRefClient (Client),
   index XRefSupplier (Supplier),
   index XRefType (`Type`))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for usys_system
#----------------------------
drop table if exists usys_system;
create table usys_system (
   Property varchar(50) not null,
   Value varchar(50),
   primary key (Property))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for usysoldtables
#----------------------------
drop table if exists usysoldtables;
create table usysoldtables (
   TableName varchar(50),
   NewName varchar(50),
   RelOrder int(11) default '0',
   FixCode int(11))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for usysqueries
#----------------------------
drop table if exists usysqueries;
create table usysqueries (
   QueryName varchar(50),
   NewName varchar(50),
   FixCode int(11))
   type=InnoDB comment="InnoDB free: 87040 kB";

#----------------------------
# Table structure for usystables
#----------------------------
drop table if exists usystables;
create table usystables (
   TableName varchar(50) not null,
   RelOrder int(11) default '0',
   DisplayName varchar(50),
   FromVer varchar(50),
   ToVer varchar(50),
   primary key (TableName))
   type=InnoDB comment="InnoDB free: 87040 kB";