-- 
-- DATA BASE: `rth`
-- 

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `bug`
-- 

CREATE TABLE `bug` (
  `BugID` int(8) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned default NULL,
  `Category` int(8) unsigned default NULL,
  `Component` int(8) unsigned default NULL,
  `Priority` varchar(32) default NULL,
  `Severity` varchar(32) default NULL,
  `ClosedReasonCode` varchar(32) default NULL,
  `Status` varchar(64) default NULL,
  `Reporter` varchar(128) default NULL,
  `ReportedDate` varchar(19) default NULL,
  `AssignedTo` varchar(128) default NULL,
  `AssignedToDeveloper` varchar(128) default NULL,
  `Closed` char(1) default 'N',
  `ClosedDate` varchar(19) default NULL,
  `TestID` varchar(20) default NULL,
  `ReqID` varchar(20) default NULL,
  `FoundInRelease` varchar(32) default NULL,
  `AssignToRelease` varchar(32) default NULL,
  `ImplementedInRelease` varchar(32) default NULL,
  `DiscoveryPeriod` varchar(32) default NULL,
  `Summary` varchar(128) default NULL,
  `Description` text,
  PRIMARY KEY  (`BugID`),
  KEY `ProjectID` (`ProjectID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Extraindo dados da tabela `bug`
-- 

INSERT INTO `bug` VALUES (1, 1, 1, 3, 'High', 'Critical', '', 'New', 'admin', '2005-11-26 17:59:47', '', '', 'N', '', '8', '', '', '', '', 'Test', 'We have a big, big problem', 'I see London, I see France...\r\n\r\nThis can't be good.\r\n');
INSERT INTO `bug` VALUES (2, 1, 1, 1, 'High', 'Critical', '', 'New', 'admin', '2005-11-29 18:34:21', 'admin', '', 'N', '', '16', '', 'Release 1.0', '', '', 'Test', 'Found a big, big, bug', 'Houston, we have a problem');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `bugassoc`
-- 

CREATE TABLE `bugassoc` (
  `BugAssocID` int(8) unsigned NOT NULL auto_increment,
  `PrimaryID` int(8) unsigned default NULL,
  `SecondaryID` int(8) unsigned default NULL,
  `RelationshipType` char(1) default NULL,
  PRIMARY KEY  (`BugAssocID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `bugassoc`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `bugcategory`
-- 

CREATE TABLE `bugcategory` (
  `CategoryID` int(8) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned default NULL,
  `CategoryName` varchar(64) default NULL,
  PRIMARY KEY  (`CategoryID`),
  UNIQUE KEY `projectid` (`CategoryName`,`ProjectID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Extraindo dados da tabela `bugcategory`
-- 

INSERT INTO `bugcategory` VALUES (1, 1, 'Defect');
INSERT INTO `bugcategory` VALUES (2, 1, 'Data Change');
INSERT INTO `bugcategory` VALUES (3, 1, 'Enhancement');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `bugcomponent`
-- 

CREATE TABLE `bugcomponent` (
  `ComponentID` int(8) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned default NULL,
  `ComponentName` varchar(64) default NULL,
  PRIMARY KEY  (`ComponentID`),
  UNIQUE KEY `projectid` (`ComponentName`,`ProjectID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Extraindo dados da tabela `bugcomponent`
-- 

INSERT INTO `bugcomponent` VALUES (1, 1, 'E-mail');
INSERT INTO `bugcomponent` VALUES (2, 1, 'Requirements');
INSERT INTO `bugcomponent` VALUES (3, 1, 'Tests');
INSERT INTO `bugcomponent` VALUES (4, 1, 'Test Results');
INSERT INTO `bugcomponent` VALUES (5, 1, 'Defects');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `bughistory`
-- 

CREATE TABLE `bughistory` (
  `BugHistoryID` int(8) unsigned NOT NULL auto_increment,
  `BugID` int(8) unsigned default NULL,
  `DateModified` varchar(19) default NULL,
  `UserName` varchar(64) default NULL,
  `Field` varchar(64) default NULL,
  `OldValue` varchar(64) default NULL,
  `NewValue` varchar(64) default NULL,
  PRIMARY KEY  (`BugHistoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Extraindo dados da tabela `bughistory`
-- 

INSERT INTO `bughistory` VALUES (1, 1, '2005-11-26 17:59:47', 'admin', 'New Defect', '', '');
INSERT INTO `bughistory` VALUES (2, 2, '2005-11-29 18:34:21', 'admin', 'New Defect', '', '');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `bugmonitor`
-- 

CREATE TABLE `bugmonitor` (
  `BugMonitorID` int(11) unsigned NOT NULL auto_increment,
  `UserID` int(11) unsigned NOT NULL default '0',
  `BugID` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`BugMonitorID`),
  UNIQUE KEY `userid_bugid` (`UserID`,`BugID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `bugmonitor`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `bugnote`
-- 

CREATE TABLE `bugnote` (
  `BugNoteID` int(8) unsigned NOT NULL auto_increment,
  `BugID` int(8) unsigned default NULL,
  `Author` varchar(64) default NULL,
  `DateCreated` varchar(19) default NULL,
  `BugNoteDetail` text,
  PRIMARY KEY  (`BugNoteID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `bugnote`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `build`
-- 

CREATE TABLE `build` (
  `ReleaseID` int(8) unsigned NOT NULL default '0',
  `BuildID` int(8) unsigned NOT NULL auto_increment,
  `BuildName` varchar(20) default NULL,
  `Description` text NOT NULL,
  `DateReceived` varchar(19) NOT NULL default '',
  `DateFinished` varchar(19) NOT NULL default '',
  `Archive` char(1) NOT NULL default '',
  `DateCreated` varchar(19) NOT NULL default '',
  `LogTimeStamp` varchar(19) NOT NULL default '',
  PRIMARY KEY  (`BuildID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Extraindo dados da tabela `build`
-- 

INSERT INTO `build` VALUES (1, 1, 'Build 1.0', '', '2005-11-23 22:30:38', '2002-01-01 12:00:00', 'N', '2002-01-01 12:00:00', '2005-11-23 22:30:38');
INSERT INTO `build` VALUES (2, 2, 'Build Modulo 1.0', 'Build Modulo 1.0', '2007-02-27 10:40:36', '', 'N', '', '');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `discussion`
-- 

CREATE TABLE `discussion` (
  `DiscussionID` int(8) unsigned NOT NULL auto_increment,
  `ReqID` int(8) unsigned NOT NULL default '0',
  `Discussion` text,
  `Status` varchar(7) default NULL,
  `DiscSubject` varchar(255) default NULL,
  `Author` varchar(25) default NULL,
  `AssignTo` varchar(25) default NULL,
  `Date` varchar(19) default NULL,
  PRIMARY KEY  (`DiscussionID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `discussion`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `discussionpost`
-- 

CREATE TABLE `discussionpost` (
  `PostID` int(8) unsigned NOT NULL auto_increment,
  `DiscussionID` int(8) unsigned NOT NULL default '0',
  `Post` text,
  `Author` varchar(25) default NULL,
  `AssignTo` varchar(25) default NULL,
  `Date` varchar(19) default NULL,
  PRIMARY KEY  (`PostID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `discussionpost`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `feedback`
-- 

CREATE TABLE `feedback` (
  `FeedbackID` smallint(4) unsigned NOT NULL auto_increment,
  `Author` varchar(15) default NULL,
  `Comment` text,
  `Project` varchar(15) default NULL,
  `TimeStamp` varchar(19) default NULL,
  PRIMARY KEY  (`FeedbackID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `feedback`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `guichecktable`
-- 

CREATE TABLE `guichecktable` (
  `GuiCheckID` int(8) unsigned NOT NULL auto_increment,
  `GuiCheckNumber` int(3) unsigned default NULL,
  `IconCode` varchar(6) default NULL,
  `TS_UniqueRunID` varchar(14) default NULL,
  `ObjectName` varchar(50) default NULL,
  `ExpectedValue` varchar(50) default NULL,
  `ActualValue` varchar(50) default NULL,
  `Status` varchar(10) default NULL,
  PRIMARY KEY  (`GuiCheckID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `guichecktable`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `individualrundocs`
-- 

CREATE TABLE `individualrundocs` (
  `UniqueDocID` int(8) unsigned NOT NULL auto_increment,
  `TS_UniqueRunID` varchar(14) default '0',
  `TimeStamp` varchar(19) default NULL,
  `UploadedBy` varchar(50) default NULL,
  `FileName` varchar(255) default NULL,
  `DisplayName` varchar(150) default NULL,
  `Comments` varchar(255) default NULL,
  `Link` varchar(255) default NULL,
  PRIMARY KEY  (`UniqueDocID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `individualrundocs`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `issues`
-- 

CREATE TABLE `issues` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `Name` char(150) default NULL,
  `Priority` char(50) default NULL,
  `Status` char(50) default NULL,
  `Details` char(255) default NULL,
  `Owner` char(50) default NULL,
  `Timestamp` varchar(19) default NULL,
  `Type` char(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `issues`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `logs`
-- 

CREATE TABLE `logs` (
  `LogID` int(8) unsigned NOT NULL auto_increment,
  `SessionID` int(10) unsigned default NULL,
  `Deletion` char(1) default NULL,
  `Creation` char(1) default NULL,
  `Upload` char(1) default NULL,
  `TimeStamp` varchar(19) default NULL,
  `User` varchar(30) default NULL,
  `Page` varchar(50) default NULL,
  `Action` text,
  PRIMARY KEY  (`LogID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

-- 
-- Extraindo dados da tabela `logs`
-- 

INSERT INTO `logs` VALUES (1, 1132802461, 'N', 'Y', 'N', '2005-11-23 22:30:21', 'admin', 'CREATE RELEASE - DEMO', 'ADDED RELEASE Release 1.0');
INSERT INTO `logs` VALUES (2, 1132802461, 'N', 'Y', 'N', '2005-11-23 22:30:38', 'admin', 'ADD BUILD - DEMO', 'ADDED BUILD Build 1.0 TO RELEASE Release 1.0');
INSERT INTO `logs` VALUES (3, 1132802461, 'N', 'Y', 'N', '2005-11-23 22:37:05', 'admin', 'CREATE TEST - DEMO', 'ADDED TEST Demo_Test');
INSERT INTO `logs` VALUES (4, 1132802461, 'N', 'Y', 'N', '2005-11-23 22:38:26', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 1');
INSERT INTO `logs` VALUES (5, 1132802461, 'N', 'Y', 'N', '2005-11-23 22:40:23', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 1');
INSERT INTO `logs` VALUES (6, 1132802461, 'N', 'Y', 'N', '2005-11-23 22:41:29', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 1');
INSERT INTO `logs` VALUES (7, 1132802461, 'N', 'Y', 'N', '2005-11-23 22:44:31', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 1');
INSERT INTO `logs` VALUES (8, 1132802461, 'N', 'Y', 'N', '2005-11-23 22:49:23', 'admin', 'CREATE TEST - DEMO', 'ADDED TEST Demo_Test2');
INSERT INTO `logs` VALUES (9, 1132802461, 'N', 'Y', 'N', '2005-11-23 23:23:53', 'admin', 'ADD TESTSET - DEMO', 'ADDED TESTSET Regression to Build 1.0');
INSERT INTO `logs` VALUES (10, 1133304144, 'N', 'Y', 'N', '2005-11-29 17:59:53', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 2');
INSERT INTO `logs` VALUES (11, 1133304144, 'N', 'Y', 'N', '2005-11-29 18:00:43', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 2');
INSERT INTO `logs` VALUES (12, 1133304144, 'N', 'Y', 'N', '2005-11-29 18:01:32', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 2');
INSERT INTO `logs` VALUES (13, 1133304144, 'N', 'Y', 'N', '2005-11-29 18:02:09', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 2');
INSERT INTO `logs` VALUES (14, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:18:59', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 3');
INSERT INTO `logs` VALUES (15, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:18:59', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 3');
INSERT INTO `logs` VALUES (16, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:18:59', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 3');
INSERT INTO `logs` VALUES (17, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:18:59', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 3');
INSERT INTO `logs` VALUES (18, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:19:15', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 4');
INSERT INTO `logs` VALUES (19, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:19:15', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 4');
INSERT INTO `logs` VALUES (20, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:19:15', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 4');
INSERT INTO `logs` VALUES (21, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:19:15', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 4');
INSERT INTO `logs` VALUES (22, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:23:32', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 5');
INSERT INTO `logs` VALUES (23, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:23:32', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 5');
INSERT INTO `logs` VALUES (24, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:23:32', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 5');
INSERT INTO `logs` VALUES (25, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:23:32', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 5');
INSERT INTO `logs` VALUES (26, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:33:15', 'admin', 'CREATE TEST - DEMO', 'ADDED TEST Teste de Ponto de Referencia 1');
INSERT INTO `logs` VALUES (27, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:35:20', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 6');
INSERT INTO `logs` VALUES (28, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:36:42', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 6');
INSERT INTO `logs` VALUES (29, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:37:28', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 6');
INSERT INTO `logs` VALUES (30, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:37:53', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 6');
INSERT INTO `logs` VALUES (31, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:38:38', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 6');
INSERT INTO `logs` VALUES (32, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:40:16', 'admin', 'CREATE RELEASE - DEMO', 'ADDED RELEASE Release Nae SP 1.0');
INSERT INTO `logs` VALUES (33, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:40:36', 'admin', 'ADD BUILD - DEMO', 'ADDED BUILD Build Modulo 1.0 TO RELEASE Release Nae SP 1.0');
INSERT INTO `logs` VALUES (34, 1172581828, 'N', 'Y', 'N', '2007-02-27 10:41:15', 'admin', 'ADD TESTSET - DEMO', 'ADDED TESTSET Teste da 6a Feira 01 to Build Modulo 1.0');
INSERT INTO `logs` VALUES (35, 1172581828, 'N', 'Y', 'N', '2007-02-27 11:02:13', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 7');
INSERT INTO `logs` VALUES (36, 1172581828, 'N', 'Y', 'N', '2007-02-27 11:02:13', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 7');
INSERT INTO `logs` VALUES (37, 1172581828, 'N', 'Y', 'N', '2007-02-27 11:02:13', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 7');
INSERT INTO `logs` VALUES (38, 1172581828, 'N', 'Y', 'N', '2007-02-27 11:02:13', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 7');
INSERT INTO `logs` VALUES (39, 1172581828, 'N', 'Y', 'N', '2007-02-27 11:02:13', 'admin', 'copy_test.php - DEMO', 'ADDED TEST STEP TO TEST ID 7');
INSERT INTO `logs` VALUES (40, 1172581828, 'N', 'Y', 'N', '2007-02-27 11:05:04', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 7');
INSERT INTO `logs` VALUES (41, 1172581828, 'N', 'Y', 'N', '2007-02-27 11:06:42', 'admin', 'test_step_add_action.php - DEMO', 'ADDED TEST STEP TO TEST ID 7');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `manualdoctype`
-- 

CREATE TABLE `manualdoctype` (
  `ManualDocTypeID` smallint(4) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned default NULL,
  `ManualDocTypeName` varchar(50) default '0',
  PRIMARY KEY  (`ManualDocTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Extraindo dados da tabela `manualdoctype`
-- 

INSERT INTO `manualdoctype` VALUES (1, 1, 'Test Case');
INSERT INTO `manualdoctype` VALUES (2, 1, 'Rules Doc');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `manualtestdocs`
-- 

CREATE TABLE `manualtestdocs` (
  `ManualTestID` int(8) unsigned NOT NULL auto_increment,
  `TempestTestID` int(8) unsigned NOT NULL default '0',
  `DisplayName` varchar(150) default 'NULL',
  PRIMARY KEY  (`ManualTestID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Extraindo dados da tabela `manualtestdocs`
-- 

INSERT INTO `manualtestdocs` VALUES (1, 6, 'IPs.txt');
INSERT INTO `manualtestdocs` VALUES (2, 7, 'IPs.txt');
INSERT INTO `manualtestdocs` VALUES (3, 1, 'IPs.txt');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `manualtestdocs_version`
-- 

CREATE TABLE `manualtestdocs_version` (
  `VersionID` int(8) unsigned NOT NULL auto_increment,
  `ManualTestID` int(8) unsigned default NULL,
  `Version` decimal(4,2) default NULL,
  `TimeStamp` varchar(19) default NULL,
  `UploadedBy` varchar(50) default NULL,
  `FileName` varchar(150) default NULL,
  `Comments` text,
  `ManualDocTypeName` varchar(50) default NULL,
  PRIMARY KEY  (`VersionID`),
  KEY `manualtestid_timestamp` (`ManualTestID`,`TimeStamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Extraindo dados da tabela `manualtestdocs_version`
-- 

INSERT INTO `manualtestdocs_version` VALUES (1, 1, 1.00, '2007-02-27 10:33:45', NULL, 'SupportingTestDoc1172583225-IPs.txt', NULL, NULL);
INSERT INTO `manualtestdocs_version` VALUES (2, 2, 1.00, '2007-02-27 11:02:13', NULL, 'SupportingTestDoc1172584933-IPs.txt', NULL, NULL);
INSERT INTO `manualtestdocs_version` VALUES (3, 3, 1.00, '2007-03-21 10:33:09', NULL, 'SupportingTestDoc1174483989-IPs.txt', NULL, NULL);

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `news`
-- 

CREATE TABLE `news` (
  `project_id` int(6) unsigned NOT NULL default '0',
  `NewsID` int(8) unsigned NOT NULL auto_increment,
  `Subject` varchar(100) NOT NULL default '',
  `Body` text NOT NULL,
  `LastModified` varchar(19) NOT NULL default '',
  `Poster` varchar(20) NOT NULL default '',
  `Deleted` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`NewsID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Extraindo dados da tabela `news`
-- 

INSERT INTO `news` VALUES (2, 1, 'Projeto São Paulo - News', 'Seja bem vindo ao Projeto NAe Sao Paulo', '2007-03-27 09:44:46', 'molinari', 'N');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `release_tbl`
-- 

CREATE TABLE `release_tbl` (
  `project_id` int(8) unsigned NOT NULL default '0',
  `ReleaseID` int(8) unsigned NOT NULL auto_increment,
  `Archive` char(1) NOT NULL default 'N',
  `ReleaseName` varchar(20) NOT NULL default '',
  `Description` text NOT NULL,
  `DateReceived` varchar(19) NOT NULL default '',
  `DateCreated` varchar(19) NOT NULL default '',
  `LogTimeStamp` varchar(19) NOT NULL default '',
  `Platform` varchar(6) NOT NULL default '',
  `QASignoffDate` varchar(19) NOT NULL default '',
  `BASignoffDate` varchar(19) NOT NULL default '',
  `QASignoffBy` varchar(25) NOT NULL default '',
  `BASignoffBy` varchar(25) NOT NULL default '',
  `QASignoff` varchar(40) NOT NULL default '',
  `BASignoff` varchar(40) NOT NULL default '',
  `QASignoffComments` text NOT NULL,
  `BASignoffComments` text NOT NULL,
  PRIMARY KEY  (`ReleaseID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Extraindo dados da tabela `release_tbl`
-- 

INSERT INTO `release_tbl` VALUES (1, 1, 'N', 'Release 1.0', '', '2005-11-23 22:30:21', '2005-11-23 22:30:21', '2005-11-23 22:30:21', '', '', '', '', '', '', '', '', '');
INSERT INTO `release_tbl` VALUES (1, 2, 'N', 'Release Nae SP 1.0', 'Release Nae SP 1.0', '2007-02-27 10:40:16', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `requirement`
-- 

CREATE TABLE `requirement` (
  `project_id` int(8) unsigned NOT NULL default '0',
  `ReqID` int(8) unsigned NOT NULL auto_increment,
  `ReqName` varchar(255) NOT NULL default '',
  `AreaCovered` int(11) unsigned NOT NULL default '0',
  `Type` int(8) unsigned NOT NULL default '0',
  `RecordOrFile` char(1) NOT NULL default 'R',
  `UnTestable` char(1) default 'N',
  `LockedBy` varchar(25) NOT NULL default '',
  `LockedDate` varchar(25) NOT NULL default '',
  `Priority` varchar(25) default NULL,
  `Parent` int(8) unsigned NOT NULL default '0',
  `DateCreated` varchar(19) default NULL,
  `LogTimeStamp` varchar(19) default NULL,
  `LastUpdated` varchar(19) default NULL,
  PRIMARY KEY  (`ReqID`),
  UNIQUE KEY `projectid` (`ReqName`,`project_id`),
  KEY `parent` (`Parent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Extraindo dados da tabela `requirement`
-- 

INSERT INTO `requirement` VALUES (1, 1, 'Requirement_Record1', 3, 3, 'R', 'Y', '', '', 'High', 0, '2005-11-23 23:19:33', '2005-11-23 23:19:33', '2005-11-23 23:19:33');
INSERT INTO `requirement` VALUES (1, 2, 'Sub-Req1', 3, 3, 'R', 'Y', '', '', 'Medium', 1, '2005-11-23 23:19:33', '2005-11-23 23:19:34', '2005-11-23 23:19:33');
INSERT INTO `requirement` VALUES (1, 3, 'Sub-Req2', 3, 3, 'R', 'Y', '', '', 'Low', 1, '2005-11-23 23:19:33', '2005-11-23 23:19:37', '2005-11-23 23:19:33');
INSERT INTO `requirement` VALUES (1, 4, 'Criacao de Ponto de Referencia', 1, 2, 'R', 'N', '', '', 'Low', 0, NULL, NULL, NULL);

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `requirementareacoverage`
-- 

CREATE TABLE `requirementareacoverage` (
  `ReqAreaCoverageID` int(8) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned default NULL,
  `AreaCoverage` varchar(50) default NULL,
  PRIMARY KEY  (`ReqAreaCoverageID`),
  UNIQUE KEY `projectid` (`ProjectID`,`AreaCoverage`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Extraindo dados da tabela `requirementareacoverage`
-- 

INSERT INTO `requirementareacoverage` VALUES (1, 1, 'Requirements');
INSERT INTO `requirementareacoverage` VALUES (2, 1, 'Bugs');
INSERT INTO `requirementareacoverage` VALUES (3, 1, 'Tests');
INSERT INTO `requirementareacoverage` VALUES (4, 1, 'Test Results');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `requirementdocumenttype`
-- 

CREATE TABLE `requirementdocumenttype` (
  `ReqDocTypeID` smallint(4) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned NOT NULL default '0',
  `ReqDocTypeName` varchar(50) NOT NULL default '',
  `RootDocument` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`ReqDocTypeID`),
  UNIQUE KEY `projectid` (`ProjectID`,`ReqDocTypeName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Extraindo dados da tabela `requirementdocumenttype`
-- 

INSERT INTO `requirementdocumenttype` VALUES (1, 1, 'Use Case', 'N');
INSERT INTO `requirementdocumenttype` VALUES (2, 1, 'Func Spec', 'N');
INSERT INTO `requirementdocumenttype` VALUES (3, 1, 'Tech Spec', 'N');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `requirementfunctionality`
-- 

CREATE TABLE `requirementfunctionality` (
  `FunctionalityID` int(8) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned NOT NULL default '0',
  `FunctionalityName` varchar(50) NOT NULL default '0',
  PRIMARY KEY  (`FunctionalityID`),
  UNIQUE KEY `projectid` (`ProjectID`,`FunctionalityName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- 
-- Extraindo dados da tabela `requirementfunctionality`
-- 

INSERT INTO `requirementfunctionality` VALUES (1, 1, 'User Mgmt');
INSERT INTO `requirementfunctionality` VALUES (7, 1, 'Run Level');
INSERT INTO `requirementfunctionality` VALUES (8, 1, 'Permissions');
INSERT INTO `requirementfunctionality` VALUES (5, 1, 'Cron');
INSERT INTO `requirementfunctionality` VALUES (6, 1, 'Group Mgmt');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `requirementfunctionality_assoc`
-- 

CREATE TABLE `requirementfunctionality_assoc` (
  `RequirementFunctionality_AssocID` int(6) unsigned NOT NULL auto_increment,
  `RequirementID` int(6) unsigned NOT NULL default '0',
  `RequirementFunctionalityID` int(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (`RequirementFunctionality_AssocID`),
  UNIQUE KEY `reqid_reqfunctid` (`RequirementID`,`RequirementFunctionalityID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Extraindo dados da tabela `requirementfunctionality_assoc`
-- 

INSERT INTO `requirementfunctionality_assoc` VALUES (1, 1, 8);
INSERT INTO `requirementfunctionality_assoc` VALUES (2, 2, 7);
INSERT INTO `requirementfunctionality_assoc` VALUES (3, 3, 8);
INSERT INTO `requirementfunctionality_assoc` VALUES (4, 4, 1);

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `requirementnotifications`
-- 

CREATE TABLE `requirementnotifications` (
  `ReqNotifyID` int(8) unsigned NOT NULL auto_increment,
  `ReqID` int(8) unsigned NOT NULL default '0',
  `UserID` int(8) NOT NULL default '0',
  PRIMARY KEY  (`ReqNotifyID`),
  UNIQUE KEY `userid_reqid` (`UserID`,`ReqID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `requirementnotifications`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `requirementversion`
-- 

CREATE TABLE `requirementversion` (
  `ReqVersionID` int(8) unsigned NOT NULL auto_increment,
  `ReqID` int(8) unsigned NOT NULL default '0',
  `Version` varchar(5) NOT NULL default '',
  `Latest` char(1) NOT NULL default '',
  `TimeStamp` varchar(19) default NULL,
  `Author` varchar(50) NOT NULL default '',
  `FileName` varchar(150) NOT NULL default '',
  `ReasonForChange` text NOT NULL,
  `Status` varchar(25) NOT NULL default '',
  `AssignedTo` varchar(255) NOT NULL default '',
  `Detail` text NOT NULL,
  `LastUpdated` varchar(19) default NULL,
  `LastUpdatedBy` varchar(30) NOT NULL default '',
  `ReqOriginReqPro` varchar(20) NOT NULL,
  PRIMARY KEY  (`ReqVersionID`),
  KEY `ReqID` (`ReqID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Extraindo dados da tabela `requirementversion`
-- 

INSERT INTO `requirementversion` VALUES (1, 1, '1.0', 'Y', '2005-11-23 23:06:24', 'admin', '', '', 'New', '', 'System Shall not tip over and die when logging in...', '2005-11-23 23:06:24', 'admin', '');
INSERT INTO `requirementversion` VALUES (2, 2, '1.0', 'Y', '2005-11-23 23:08:35', 'admin', '', '', '', '', 'Creating a sub-requirement', '2005-11-23 23:08:35', 'admin', '');
INSERT INTO `requirementversion` VALUES (3, 3, '1.0', 'Y', '2005-11-23 23:14:24', 'admin', '', '', '', '', 'A second sub-requirement', '2005-11-23 23:14:24', 'admin', '');
INSERT INTO `requirementversion` VALUES (4, 4, '1.0', 'Y', '2007-02-27 10:29:52', 'admin', '', '', 'Approved', 'admin', 'Criacao de Ponto de Referencia....', '2007-02-27 10:29:51', 'admin', 'REQ0055');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `requirementversion_release_assoc`
-- 

CREATE TABLE `requirementversion_release_assoc` (
  `RequirementVersion_Release_AssocID` int(6) unsigned NOT NULL auto_increment,
  `RequirementVersionID` int(6) unsigned NOT NULL default '0',
  `ReleaseID` int(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (`RequirementVersion_Release_AssocID`),
  UNIQUE KEY `reqversionid_releaseid` (`RequirementVersionID`,`ReleaseID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Extraindo dados da tabela `requirementversion_release_assoc`
-- 

INSERT INTO `requirementversion_release_assoc` VALUES (1, 4, 2);

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `tempest_project`
-- 

CREATE TABLE `tempest_project` (
  `tempest_project_id` int(4) unsigned NOT NULL auto_increment,
  `use_files` char(1) NOT NULL default 'Y',
  `show_custom_1` char(1) NOT NULL default 'Y',
  `show_custom_2` char(1) NOT NULL default 'Y',
  `show_custom_3` char(1) NOT NULL default 'Y',
  `show_custom_4` char(1) NOT NULL default 'Y',
  `show_custom_5` char(1) default 'Y',
  `show_custom_6` char(1) default 'Y',
  `show_window` char(1) NOT NULL default 'Y',
  `show_object` char(1) NOT NULL default 'Y',
  `show_memory_stats` char(1) NOT NULL default 'Y',
  `show_priority` char(1) NOT NULL default 'Y',
  `show_test_input` char(1) NOT NULL default 'Y',
  `status` char(1) NOT NULL default 'Y',
  `date_created` varchar(19) default NULL,
  `project_name` varchar(50) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `req_upload_path` varchar(255) default NULL,
  `test_upload_path` varchar(255) default NULL,
  `test_run_upload_path` varchar(255) default NULL,
  `test_plan_upload_path` varchar(255) NOT NULL default '',
  `bug_url` varchar(255) default NULL,
  `deleted` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`tempest_project_id`),
  UNIQUE KEY `project_name` (`project_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Extraindo dados da tabela `tempest_project`
-- 

INSERT INTO `tempest_project` VALUES (1, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '2005-11-26 17:51:11', 'DEMO', 'The default demo project', './rth_file_upload/DEMO_req_docs/', './rth_file_upload/DEMO_test_docs/', './rth_file_upload/DEMO_test_run_docs/', './rth_file_upload/DEMO_test_plan_docs/', '', 'N');
INSERT INTO `tempest_project` VALUES (2, 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Projeto NAe Sao Paulo', '', './rth_file_upload/ProjetoNAeSaoPaulo_req_docs/', './rth_file_upload/ProjetoNAeSaoPaulo_test_docs/', './rth_file_upload/ProjetoNAeSaoPaulo_test_run_docs/', './rth_file_upload/ProjetoNAeSaoPaulo_test_plan_docs/', NULL, 'N');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `tempest_project_user_assoc`
-- 

CREATE TABLE `tempest_project_user_assoc` (
  `project_user_assoc_id` int(4) unsigned NOT NULL auto_increment,
  `tempest_project_id` int(4) unsigned NOT NULL default '0',
  `tempest_user_id` int(4) unsigned NOT NULL default '0',
  `delete_rights` char(1) default NULL,
  `email_testset` char(1) default NULL,
  `email_discussion` char(1) default NULL,
  `email_new_bug` char(1) NOT NULL default '',
  `email_update_bug` char(1) NOT NULL default '',
  `qa_tester` char(1) default NULL,
  `ba_owner` char(1) default NULL,
  `user_rights` varchar(25) default NULL,
  PRIMARY KEY  (`project_user_assoc_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- 
-- Extraindo dados da tabela `tempest_project_user_assoc`
-- 

INSERT INTO `tempest_project_user_assoc` VALUES (1, 1, 1, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '10');
INSERT INTO `tempest_project_user_assoc` VALUES (2, 1, 2, 'N', 'N', 'N', '', '', 'N', 'Y', '10');
INSERT INTO `tempest_project_user_assoc` VALUES (3, 1, 3, 'N', 'N', 'N', 'N', 'N', 'Y', 'N', '10');
INSERT INTO `tempest_project_user_assoc` VALUES (4, 1, 4, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'Y', '30');
INSERT INTO `tempest_project_user_assoc` VALUES (5, 2, 4, 'Y', 'Y', 'N', '', '', 'Y', 'Y', '30');
INSERT INTO `tempest_project_user_assoc` VALUES (6, 2, 1, 'Y', 'Y', 'N', '', '', 'Y', 'Y', '30');
INSERT INTO `tempest_project_user_assoc` VALUES (7, 1, 5, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'Y', '30');
INSERT INTO `tempest_project_user_assoc` VALUES (8, 2, 5, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'Y', '30');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `tempest_reset_password`
-- 

CREATE TABLE `tempest_reset_password` (
  `reset_id` int(11) NOT NULL auto_increment,
  `user` varchar(50) NOT NULL default '0',
  `reset_link` varchar(25) NOT NULL default '',
  `reset_used` char(1) NOT NULL default '',
  `expires` varchar(19) default NULL,
  PRIMARY KEY  (`reset_id`),
  UNIQUE KEY `reset_link` (`reset_link`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `tempest_reset_password`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `tempest_user`
-- 

CREATE TABLE `tempest_user` (
  `tempest_user_id` int(4) unsigned NOT NULL auto_increment,
  `password` varchar(32) NOT NULL default '',
  `username` varchar(20) default NULL,
  `first_name` varchar(20) NOT NULL default '',
  `last_name` varchar(20) NOT NULL default '',
  `phone` varchar(25) NOT NULL default '',
  `menu_prefs` varchar(39) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `tempest_admin` varchar(25) NOT NULL default '',
  `default_project` int(6) unsigned NOT NULL default '0',
  `deleted` char(1) NOT NULL default 'N',
  `email_on_new` char(1) NOT NULL default '',
  `email_on_assigned_to` char(1) NOT NULL default '',
  `email_on_feedback` char(1) NOT NULL default '',
  `email_on_resolved` char(1) NOT NULL default '',
  `email_on_closed` char(1) NOT NULL default '',
  `email_on_reopened` char(1) NOT NULL default '',
  `email_on_bugnote` char(1) NOT NULL default '',
  `email_on_status` char(1) NOT NULL default '',
  `email_on_priority` char(1) NOT NULL default '',
  PRIMARY KEY  (`tempest_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Extraindo dados da tabela `tempest_user`
-- 

INSERT INTO `tempest_user` VALUES (1, '5f4dcc3b5aa765d61d8327deb882cf99', 'admin', 'Big', 'Shot', '', '', 'gth2@users.sourceforge.net', 'Y', 1, 'N', '', '', '', '', '', '', '', '', '');
INSERT INTO `tempest_user` VALUES (2, 'b66c63a46b5a43eb5066cf6ac0b9f7ea', 'ba_owner', 'BA', 'Owner', '', '', 'user@domain.com', 'N', 1, 'N', '', '', '', '', '', '', '', '', '');
INSERT INTO `tempest_user` VALUES (3, 'cc0e9a92816eeed502687b0db4d546c9', 'qa_user', 'QA', 'User', '', '', 'user2@domain.com', 'N', 1, 'N', '', '', '', '', '', '', '', '', '');
INSERT INTO `tempest_user` VALUES (4, '0e561187d51609f59a35e1079f062c7a', 'molinari', 'Leonardo', 'Molinari', '', '', 'lm7k@yahoo.com.br', 'Y', 1, 'N', '', '', '', '', '', '', '', '', '');
INSERT INTO `tempest_user` VALUES (5, 'c16a4ff65bafbe8631a5f01cc127b2d7', 'gmb', 'G', 'Bertolini', '', '', 'gmbertolini@bol.com.br', 'Y', 2, 'N', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testarea`
-- 

CREATE TABLE `testarea` (
  `AreaTestedID` smallint(4) unsigned NOT NULL auto_increment,
  `project_id` int(8) unsigned NOT NULL default '0',
  `AreaTestedName` varchar(50) default '0',
  PRIMARY KEY  (`AreaTestedID`),
  UNIQUE KEY `projectid` (`AreaTestedName`,`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Extraindo dados da tabela `testarea`
-- 

INSERT INTO `testarea` VALUES (1, 1, 'Requirements');
INSERT INTO `testarea` VALUES (2, 1, 'Tests');
INSERT INTO `testarea` VALUES (3, 1, 'Test Results');
INSERT INTO `testarea` VALUES (4, 1, 'Bugs');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testenvironment`
-- 

CREATE TABLE `testenvironment` (
  `EnvironmentID` int(6) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned default NULL,
  `EnvironmentName` char(50) default NULL,
  PRIMARY KEY  (`EnvironmentID`),
  UNIQUE KEY `projectid` (`EnvironmentName`,`ProjectID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Extraindo dados da tabela `testenvironment`
-- 

INSERT INTO `testenvironment` VALUES (1, 1, 'Dev');
INSERT INTO `testenvironment` VALUES (2, 1, 'Prod');
INSERT INTO `testenvironment` VALUES (3, 1, 'QA');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testmachine`
-- 

CREATE TABLE `testmachine` (
  `MachineID` smallint(4) unsigned NOT NULL auto_increment,
  `ProjectID` int(8) unsigned default NULL,
  `MachineName` char(20) default NULL,
  `MachineLocation` char(25) default NULL,
  `MachineIPAddress` char(15) default NULL,
  PRIMARY KEY  (`MachineID`),
  KEY `projectid` (`ProjectID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `testmachine`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testplan`
-- 

CREATE TABLE `testplan` (
  `TestPlanID` int(8) unsigned NOT NULL auto_increment,
  `BuildID` int(8) unsigned default NULL,
  `TestPlanName` varchar(255) default NULL,
  PRIMARY KEY  (`TestPlanID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Extraindo dados da tabela `testplan`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testplanversion`
-- 

CREATE TABLE `testplanversion` (
  `TestPlanVersionID` int(8) unsigned NOT NULL auto_increment,
  `TestPlanID` int(8) unsigned default NULL,
  `Latest` char(1) default 'Y',
  `Version` char(3) default NULL,
  `UploadedDate` varchar(19) default NULL,
  `UploadedBy` varchar(30) default NULL,
  `FileName` varchar(255) default NULL,
  `Comments` varchar(255) default NULL,
  PRIMARY KEY  (`TestPlanVersionID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Extraindo dados da tabela `testplanversion`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testset`
-- 

CREATE TABLE `testset` (
  `TestSetID` int(8) unsigned NOT NULL auto_increment,
  `BuildID` int(8) unsigned NOT NULL default '0',
  `TestSetOrderBy` int(19) NOT NULL default '0',
  `Archive` char(3) NOT NULL default '',
  `DateCreated` varchar(19) NOT NULL default '2002-01-01 12:00:00',
  `SignOffDate` varchar(19) NOT NULL default '',
  `TestSetName` varchar(30) NOT NULL default '0',
  `SignOffBy` varchar(19) NOT NULL default '',
  `TestSetStatus` varchar(40) NOT NULL default '',
  `SignOffComments` varchar(255) NOT NULL default '',
  `Description` text NOT NULL,
  `UniqueID` varchar(15) NOT NULL default '',
  `TestSetType` varchar(30) default NULL,
  PRIMARY KEY  (`TestSetID`),
  KEY `buildid` (`BuildID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Extraindo dados da tabela `testset`
-- 

INSERT INTO `testset` VALUES (1, 1, 1, 'N', '2005-11-23 23:23:53', '', 'Regression', '', '', '', 'Our first ever test set', '', '');
INSERT INTO `testset` VALUES (2, 2, 1, 'N', '2007-02-27 10:41:15', '', 'Teste da 6a Feira 01', '', '', '', 'Teste da 6a Feira 01', '', NULL);

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testset_testsuite_assoc`
-- 

CREATE TABLE `testset_testsuite_assoc` (
  `TestSet_TestSuite_AssocID` int(8) unsigned NOT NULL auto_increment,
  `TestSetID` int(8) unsigned NOT NULL default '0',
  `TempestTestID` int(8) unsigned NOT NULL default '0',
  `Finished` smallint(1) unsigned default '0',
  `LogTimeStamp` varchar(19) default NULL,
  `root_cause` varchar(30) default NULL,
  `TestStatus` varchar(30) NOT NULL default 'Not Started',
  `AssignedTo` varchar(25) NOT NULL default '',
  `Comments` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`TestSet_TestSuite_AssocID`,`TestSetID`),
  KEY `tempesttestid_idx` (`TempestTestID`),
  KEY `testsetid` (`TestSetID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Extraindo dados da tabela `testset_testsuite_assoc`
-- 

INSERT INTO `testset_testsuite_assoc` VALUES (1, 1, 1, 0, '2005-11-29 15:11:43', '', 'Not Started', '', '');
INSERT INTO `testset_testsuite_assoc` VALUES (2, 1, 2, 0, '2005-11-29 18:26:33', 'Application Defect', 'Failed', 'admin', 'Failed on the final step');
INSERT INTO `testset_testsuite_assoc` VALUES (3, 2, 6, 1, '2007-02-27 10:43:58', '', 'Passed', 'admin', 'Tudo ok');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `teststatus`
-- 

CREATE TABLE `teststatus` (
  `TestStatusID` int(8) unsigned NOT NULL auto_increment,
  `project_id` int(8) unsigned NOT NULL default '0',
  `TestStatus` varchar(20) default NULL,
  PRIMARY KEY  (`TestStatusID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `teststatus`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `teststep`
-- 

CREATE TABLE `teststep` (
  `TestStepID` int(8) unsigned NOT NULL auto_increment,
  `TestID` int(8) unsigned default NULL,
  `TestVersionID` int(8) unsigned default NULL,
  `TestStep_Number` decimal(8,1) default NULL,
  `Action` text,
  `Inputs` text,
  `Expected_Result` text,
  `StepType` varchar(11) NOT NULL default '',
  PRIMARY KEY  (`TestStepID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

-- 
-- Extraindo dados da tabela `teststep`
-- 

INSERT INTO `teststep` VALUES (1, 1, 0, 2.0, 'Verify val_1 = 1', 'Person = my', 'val_1 = 1', 'N');
INSERT INTO `teststep` VALUES (8, 2, 0, 4.0, 'Click on the TestRunID link ', 'Link= Mxxxxxx', 'Verification page should appear.', 'N');
INSERT INTO `teststep` VALUES (2, 1, 0, 3.0, 'Verify val_2 = 1', 'Direction = left', 'val_2 = 1', 'N');
INSERT INTO `teststep` VALUES (7, 2, 0, 3.0, 'Click on the Results link for Demo_Test2', '', 'Test Run page should appear.', 'N');
INSERT INTO `teststep` VALUES (3, 1, 0, 4.0, 'Verify val_3 = 1', 'Place = foot', 'val_3 = 1', 'N');
INSERT INTO `teststep` VALUES (6, 2, 0, 2.0, 'Click the Latest Test Set hyperlink', 'id = 00001', 'Results page appears', 'N');
INSERT INTO `teststep` VALUES (4, 1, 0, 1.0, 'This is my action. I am running', ' By checking info step, this step appears in Red and is not a step with an\r\n expected Pass/Fail status.  It is merely informational', 'Expected: I will not fall on my face', 'N');
INSERT INTO `teststep` VALUES (5, 2, 0, 1.0, 'Enter login information and click Submit button', 'url = http://localhost/rth/login.php\r\nuser = admin\r\npword = password', 'Home page appears.', 'N');
INSERT INTO `teststep` VALUES (9, 3, NULL, 1.0, 'This is my action. I am running', ' By checking info step, this step appears in Red and is not a step with an\r\n expected Pass/Fail status.  It is merely informational', 'Expected: I will not fall on my face', 'N');
INSERT INTO `teststep` VALUES (10, 3, NULL, 2.0, 'Verify val_1 = 1', 'Person = my', 'val_1 = 1', 'N');
INSERT INTO `teststep` VALUES (11, 3, NULL, 3.0, 'Verify val_2 = 1', 'Direction = left', 'val_2 = 1', 'N');
INSERT INTO `teststep` VALUES (12, 3, NULL, 4.0, 'Verify val_3 = 1', 'Place = foot', 'val_3 = 1', 'N');
INSERT INTO `teststep` VALUES (13, 4, NULL, 1.0, 'This is my action. I am running', ' By checking info step, this step appears in Red and is not a step with an\r\n expected Pass/Fail status.  It is merely informational', 'Expected: I will not fall on my face', 'N');
INSERT INTO `teststep` VALUES (14, 4, NULL, 2.0, 'Verify val_1 = 1', 'Person = my', 'val_1 = 1', 'N');
INSERT INTO `teststep` VALUES (15, 4, NULL, 3.0, 'Verify val_2 = 1', 'Direction = left', 'val_2 = 1', 'N');
INSERT INTO `teststep` VALUES (16, 4, NULL, 4.0, 'Verify val_3 = 1', 'Place = foot', 'val_3 = 1', 'N');
INSERT INTO `teststep` VALUES (17, 5, NULL, 1.0, 'This is my action. I am running', ' By checking info step, this step appears in Red and is not a step with an\r\n expected Pass/Fail status.  It is merely informational', 'Expected: I will not fall on my face', 'N');
INSERT INTO `teststep` VALUES (18, 5, NULL, 2.0, 'Verify val_1 = 1', 'Person = my', 'val_1 = 1', 'N');
INSERT INTO `teststep` VALUES (19, 5, NULL, 3.0, 'Verify val_2 = 1', 'Direction = left', 'val_2 = 1', 'N');
INSERT INTO `teststep` VALUES (20, 5, NULL, 4.0, 'Verify val_3 = 1', 'Place = foot', 'val_3 = 1', 'N');
INSERT INTO `teststep` VALUES (21, 6, NULL, 1.0, 'Criar Ponto de Referencia, apertando botao.', '-', 'Botao selecionado', 'N');
INSERT INTO `teststep` VALUES (22, 6, NULL, 2.0, 'Entrar com coordenada X', '"X"', 'Dado preenchido OK na tela.', 'N');
INSERT INTO `teststep` VALUES (23, 6, NULL, 3.0, 'Entrar com coordenada Y', '"Y"', 'Dado preenchido OK na tela.', 'N');
INSERT INTO `teststep` VALUES (24, 6, NULL, 4.0, 'Clicar no ENTER', '-', 'Botao selecionado/clicado', 'N');
INSERT INTO `teststep` VALUES (25, 6, NULL, 5.0, 'Verificar criação do P.R.', '-', 'P.R. criado OK.', 'N');
INSERT INTO `teststep` VALUES (26, 7, NULL, 2.0, 'Criar Ponto de Referencia, apertando botao.', '-', 'Botao selecionado', 'N');
INSERT INTO `teststep` VALUES (27, 7, NULL, 3.0, 'Entrar com coordenada X', '"X" da linha do arquivo lido', 'Dado preenchido OK na tela.', 'N');
INSERT INTO `teststep` VALUES (28, 7, NULL, 4.0, 'Entrar com coordenada Y', '"Y" da linha do arquivo lido', 'Dado preenchido OK na tela.', 'N');
INSERT INTO `teststep` VALUES (29, 7, NULL, 5.0, 'Clicar no ENTER', '-', 'Botao selecionado/clicado', 'N');
INSERT INTO `teststep` VALUES (30, 7, NULL, 6.0, 'Verificar criação do P.R.', '-', 'P.R. criado OK.', 'N');
INSERT INTO `teststep` VALUES (31, 7, NULL, 1.0, 'Ler/obter dados das coordenadas X e Y no arquivo XPTO para todas as linhas do arquivo.', '-', 'Dado para cada linha lido OK.', 'N');
INSERT INTO `teststep` VALUES (32, 7, NULL, 1.1, 'Para cada linha do arquivo XPTO executar proximos passos.', '-', '-', 'N');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testsuite`
-- 

CREATE TABLE `testsuite` (
  `TempestTestID` int(8) unsigned NOT NULL auto_increment,
  `project_id` int(8) unsigned NOT NULL default '0',
  `Deleted` char(3) NOT NULL default '',
  `Archive` char(3) NOT NULL default '',
  `CodeReview` char(3) NOT NULL default '',
  `BA_Approval` char(3) NOT NULL default '',
  `Steps` char(3) NOT NULL default '',
  `Script` char(3) NOT NULL default '',
  `LoadRunner` char(3) NOT NULL default '',
  `AutoPass` char(1) NOT NULL default '',
  `Duration` varchar(5) NOT NULL default '',
  `Purpose` text NOT NULL,
  `TestSuiteName` varchar(150) NOT NULL default '',
  `TestType` varchar(50) NOT NULL default '',
  `AreaTested` varchar(50) NOT NULL default '',
  `BAOwner` varchar(25) NOT NULL default '',
  `Scripter` varchar(25) NOT NULL default '',
  `Tester` varchar(25) default NULL,
  `ApprovedForAuto` varchar(20) NOT NULL default '',
  `Priority` varchar(11) NOT NULL default '',
  `Status` varchar(30) NOT NULL default '',
  `DateCreated` varchar(19) default NULL,
  `Comments` varchar(255) NOT NULL default '',
  `AssignedTo` varchar(15) NOT NULL default '',
  `AssignedBy` varchar(15) NOT NULL default '',
  `DateAssigned` varchar(10) NOT NULL default '',
  `ExpDateComplete` varchar(10) NOT NULL default '',
  `ActDateComplete` varchar(10) NOT NULL default '',
  `BASignOff` varchar(10) NOT NULL default '',
  `SignOffBy` varchar(30) default NULL,
  `SignOffDate` varchar(10) default NULL,
  `LastUpdated` varchar(19) default NULL,
  `LastUpdatedBy` varchar(30) NOT NULL default '',
  `UniqueID` varchar(15) NOT NULL default '',
  `TestStepLinkID` int(8) default NULL,
  `State` char(3) default NULL,
  PRIMARY KEY  (`TempestTestID`),
  UNIQUE KEY `TestSuiteName` (`TestSuiteName`),
  KEY `areatested` (`AreaTested`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Extraindo dados da tabela `testsuite`
-- 

INSERT INTO `testsuite` VALUES (1, 1, 'N', 'N', '', '', 'YES', '', '', '', '', 'This test is intended to help new users to understand the system', 'Demo_Test', 'Regression', 'Bugs', '', 'admin', 'qa_user', '', 'High', 'New', '', '', '', '', '', '', '', '', '', '', '2005-11-23 22:37:05', 'admin', '', 0, '');
INSERT INTO `testsuite` VALUES (2, 1, 'N', 'N', '', '', 'YES', '', '', '', '', '', 'Demo_Test2', 'Regression', 'Bugs', 'ba_user', '', 'qa_user', '', 'Medium', 'New', '', '', '', '', '', '', '', '', '', '', '2005-11-23 22:53:50', 'admin', '', 0, '');
INSERT INTO `testsuite` VALUES (3, 1, 'N', 'N', '', '', 'YES', '', '', '', '', 'This test is intended to help new users to understand the system', 'Demo_Test18', 'Regression', 'Bugs', '', 'admin', 'qa_user', '', 'High', 'New', NULL, '', '', '', '', '', '', '', NULL, NULL, '2007-02-27 10:18:59', 'admin', '', NULL, NULL);
INSERT INTO `testsuite` VALUES (4, 1, 'N', 'N', '', '', 'YES', '', '', '', '', 'This test is intended to help new users to understand the system', 'Demo_Test1813', 'Regression', 'Bugs', '', 'admin', 'qa_user', '', 'High', 'New', NULL, '', '', '', '', '', '', '', NULL, NULL, '2007-02-27 10:19:15', 'admin', '', NULL, NULL);
INSERT INTO `testsuite` VALUES (5, 1, 'N', 'N', '', '', 'YES', '', '', '', '', 'This test is intended to help new users to understand the system', 'Demo_Test181324', 'Regression', 'Bugs', '', 'admin', 'qa_user', '', 'High', 'New', NULL, '', '', '', '', '', '', '', NULL, NULL, '2007-02-27 10:23:32', 'admin', '', NULL, NULL);
INSERT INTO `testsuite` VALUES (6, 1, 'N', 'N', '', '', 'YES', '', '', '', '20', 'Testar PF', 'Teste de Ponto de Referencia 1', 'Functional', 'Requirements', 'ba_owner', 'qa_user', 'admin', '', 'Low', 'New', NULL, '', 'admin', 'admin', '2007-02-27', '', '2007-02-28', '', NULL, NULL, '2007-02-27 10:33:15', 'admin', '', NULL, NULL);
INSERT INTO `testsuite` VALUES (7, 1, 'N', 'N', '', '', '', 'YES', '', '', '20', 'Testar PF ...', 'Teste de Ponto de Referencia Automatico 01', 'Functional', 'Requirements', 'ba_owner', 'qa_user', 'admin', '', 'Low', 'New', NULL, '', 'admin', 'admin', '2007-02-27', '', '2007-02-28', '', NULL, NULL, '2007-02-27 11:03:06', 'admin', '', NULL, NULL);

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testsuite_requirement_assoc`
-- 

CREATE TABLE `testsuite_requirement_assoc` (
  `TestSuite_Requirement_AssocID` int(8) unsigned NOT NULL auto_increment,
  `TempestTestID` int(8) unsigned NOT NULL default '0',
  `ReqID` int(8) unsigned NOT NULL default '0',
  `PercentCovered` int(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`TestSuite_Requirement_AssocID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Extraindo dados da tabela `testsuite_requirement_assoc`
-- 

INSERT INTO `testsuite_requirement_assoc` VALUES (1, 1, 1, 50);
INSERT INTO `testsuite_requirement_assoc` VALUES (2, 1, 2, 50);
INSERT INTO `testsuite_requirement_assoc` VALUES (3, 6, 4, 0);

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testsuiteresults`
-- 

CREATE TABLE `testsuiteresults` (
  `TestSuiteResultsID` int(8) unsigned NOT NULL auto_increment,
  `TestSetID` int(8) unsigned NOT NULL default '0',
  `project_id` int(8) unsigned NOT NULL default '0',
  `TempestTestID` int(8) unsigned NOT NULL default '0',
  `LogTimeStamp` varchar(19) default NULL,
  `TestStatus` varchar(30) NOT NULL default 'Not Started',
  `assigned_to` varchar(25) NOT NULL default '',
  `root_cause` varchar(25) NOT NULL default '',
  `test_run_comment` varchar(255) NOT NULL default '',
  `Started` smallint(1) unsigned NOT NULL default '0',
  `Finished` smallint(1) unsigned NOT NULL default '0',
  `CVSVersion` decimal(4,2) NOT NULL default '0.00',
  `CheckedForAutoPass` char(1) NOT NULL default '',
  `OS` varchar(20) NOT NULL default '',
  `SP` varchar(15) NOT NULL default '',
  `nNumberID` varchar(8) NOT NULL default '',
  `UserID` varchar(10) NOT NULL default '',
  `MachineName` varchar(50) NOT NULL default '',
  `TestSuite` varchar(150) NOT NULL default '',
  `TestPath` varchar(255) NOT NULL default '',
  `Environment` varchar(20) NOT NULL default '',
  `RunID` varchar(25) NOT NULL default '',
  `TS_UniqueRunID` varchar(14) NOT NULL default '0',
  `TimeStarted` varchar(19) NOT NULL default '',
  `TimeFinished` varchar(19) NOT NULL default '',
  PRIMARY KEY  (`TestSuiteResultsID`),
  KEY `TS_UniqueRunID` (`TS_UniqueRunID`),
  KEY `tempesttestid` (`TempestTestID`),
  KEY `testset_id` (`TestSetID`,`TS_UniqueRunID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- 
-- Extraindo dados da tabela `testsuiteresults`
-- 

INSERT INTO `testsuiteresults` VALUES (11, 1, 0, 2, '2005-11-29 18:03:17', 'Failed', 'admin', 'Application Defect', 'Test failed on final step', 1, 1, 0.00, '', 'Win2000', '', '', '', '', 'Demo_Test2', '', 'QA', '', 'M1133305397', '2005-11-29 18:01:17', '2005-11-29 18:03:17');
INSERT INTO `testsuiteresults` VALUES (12, 1, 0, 2, '2005-11-29 18:10:33', 'Failed', 'admin', 'Application Defect', 'Failed on the final step', 1, 1, 0.00, '', 'Win95', '', '', '', '', 'Demo_Test2', '', 'QA', '', 'M1133305833', '2005-11-29 18:08:33', '2005-11-29 18:10:33');
INSERT INTO `testsuiteresults` VALUES (13, 1, 0, 2, '2005-11-29 18:26:33', 'Failed', 'admin', 'Application Defect', 'Failed on the final step', 1, 1, 0.00, '', 'Win95', '', '', '', '', 'Demo_Test2', '', 'QA', '', 'M1133305986', '2005-11-29 18:24:33', '2005-11-29 18:26:33');
INSERT INTO `testsuiteresults` VALUES (14, 2, 0, 6, NULL, 'Passed', 'admin', '', 'Tudo ok', 1, 1, 0.00, '', 'XP', '', '', '', '', 'Teste de Ponto de Referencia 1', '', 'Dev', '', 'M1172583838432', '2007-02-27 10:42:58', '2007-02-27 10:43:58');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testtype`
-- 

CREATE TABLE `testtype` (
  `TestTypeID` int(6) unsigned NOT NULL auto_increment,
  `project_id` int(8) unsigned default NULL,
  `TestType` varchar(50) default NULL,
  PRIMARY KEY  (`TestTypeID`),
  UNIQUE KEY `projectid` (`TestType`,`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Extraindo dados da tabela `testtype`
-- 

INSERT INTO `testtype` VALUES (1, 1, 'Smoke');
INSERT INTO `testtype` VALUES (2, 1, 'Regression');
INSERT INTO `testtype` VALUES (3, 1, 'Performance');
INSERT INTO `testtype` VALUES (4, 1, 'Functional');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testversion`
-- 

CREATE TABLE `testversion` (
  `TestVersionID` int(8) unsigned NOT NULL auto_increment,
  `TempestTestID` int(8) unsigned default NULL,
  `Version` decimal(4,2) default NULL,
  `Latest` char(1) default NULL,
  `ActiveVersion` char(1) default NULL,
  `Comments` varchar(255) default NULL,
  `Status` varchar(25) NOT NULL default '',
  `AssignedTo` varchar(30) NOT NULL default '',
  `BASignOff` varchar(10) NOT NULL default '',
  `SignOffBy` varchar(30) NOT NULL default '',
  `Creator` varchar(30) NOT NULL default '',
  `DateCreated` varchar(19) NOT NULL default '',
  PRIMARY KEY  (`TestVersionID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Extraindo dados da tabela `testversion`
-- 

INSERT INTO `testversion` VALUES (1, 1, 1.00, 'Y', 'Y', '', 'New', '', '', '', 'admin', '2005-11-23 22:37:05');
INSERT INTO `testversion` VALUES (2, 2, 1.00, 'Y', 'Y', '', 'New', '', '', '', 'admin', '2005-11-23 22:49:23');
INSERT INTO `testversion` VALUES (3, 3, 1.00, 'Y', 'Y', '', 'New', '', '', '', 'admin', '2007-02-27 10:18:59');
INSERT INTO `testversion` VALUES (4, 4, 1.00, 'Y', 'Y', '', 'New', '', '', '', 'admin', '2007-02-27 10:19:15');
INSERT INTO `testversion` VALUES (5, 5, 1.00, 'Y', 'Y', '', 'New', '', '', '', 'admin', '2007-02-27 10:23:32');
INSERT INTO `testversion` VALUES (6, 6, 1.00, 'Y', 'Y', '...', 'New', '', '', '', 'admin', '2007-02-27 10:33:15');
INSERT INTO `testversion` VALUES (7, 7, 1.00, 'Y', 'Y', '', 'New', '', '', '', 'admin', '2007-02-27 11:02:13');

-- --------------------------------------------------------

-- 
-- Estrutura da tabela `testworkflow`
-- 

CREATE TABLE `testworkflow` (
  `UniqueTestID` int(8) unsigned NOT NULL auto_increment,
  `Complete` char(1) NOT NULL default 'N',
  `TestName` varchar(150) default NULL,
  `BAToCreateTC` varchar(30) default NULL,
  `BACreateDateComp` varchar(10) default NULL,
  `QAToReviewTC` varchar(30) default NULL,
  `QAReviewDateComp` varchar(10) default NULL,
  `QAAutomated` varchar(30) default NULL,
  `QAAutoDateStart` varchar(10) default NULL,
  `QAAutoDateExp` varchar(10) default NULL,
  `QAAutoDateComp` varchar(10) default NULL,
  `BAToApprove` varchar(30) default NULL,
  `BAApprovalDate` varchar(10) default NULL,
  `Comments` varchar(255) default NULL,
  PRIMARY KEY  (`UniqueTestID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Extraindo dados da tabela `testworkflow`
-- 


-- --------------------------------------------------------

-- 
-- Estrutura da tabela `verifyresults`
-- 

CREATE TABLE `verifyresults` (
  `VerifyResultsID` int(11) unsigned NOT NULL auto_increment,
  `LogTimeStamp` varchar(19) default NULL,
  `TestStatus` varchar(6) NOT NULL default '',
  `LineNumber` int(5) unsigned NOT NULL default '0',
  `defect_id` int(8) unsigned NOT NULL default '0',
  `TotalPhyMem` int(11) unsigned NOT NULL default '0',
  `FreePhyMem` int(11) unsigned NOT NULL default '0',
  `TotalVirMem` int(11) unsigned NOT NULL default '0',
  `FreeVirMem` int(11) unsigned NOT NULL default '0',
  `CurMemUtil` int(11) unsigned NOT NULL default '0',
  `TotalPageFile` int(11) unsigned NOT NULL default '0',
  `FreePageFile` int(11) unsigned NOT NULL default '0',
  `Custom_5` char(2) default NULL,
  `Custom_3` varchar(8) NOT NULL default '',
  `Custom_1` varchar(13) NOT NULL default '',
  `Custom_2` varchar(20) NOT NULL default '',
  `Custom_6` varchar(20) NOT NULL default '',
  `Custom_4` varchar(20) NOT NULL default '',
  `ActualResult` varchar(255) NOT NULL default '',
  `Comment` varchar(255) NOT NULL default '',
  `Action` varchar(255) default NULL,
  `ExpectedResult` varchar(255) default NULL,
  `Window` varchar(100) NOT NULL default '',
  `Object` varchar(100) NOT NULL default '',
  `ObjType` varchar(25) default NULL,
  `StepNumber` varchar(25) default NULL,
  `TS_UniqueRunID` varchar(14) NOT NULL default '0',
  `TimeStamp` varchar(19) default NULL,
  PRIMARY KEY  (`VerifyResultsID`),
  KEY `teststatus` (`TestStatus`),
  KEY `ts_uniquerunid` (`TS_UniqueRunID`,`TestStatus`),
  KEY `defect` (`defect_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- 
-- Extraindo dados da tabela `verifyresults`
-- 

INSERT INTO `verifyresults` VALUES (13, '2005-11-29 18:26:33', 'Pass', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', 'Looks Good', '', 'Enter login information and click Submit button', 'Home page appears.', '', '', '', '1.0', 'M1133305986', '2005-11-29 18:13:06');
INSERT INTO `verifyresults` VALUES (14, '2005-11-29 18:26:33', 'Pass', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', 'A-okay', '', 'Click the Latest Test Set hyperlink', 'Results page appears', '', '', '', '2.0', 'M1133305986', '2005-11-29 18:13:06');
INSERT INTO `verifyresults` VALUES (15, '2005-11-29 18:26:33', 'Pass', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', 'Getting close', '', 'Click on the Results link for Demo_Test2', 'Test Run page should appear.', '', '', '', '3.0', 'M1133305986', '2005-11-29 18:13:06');
INSERT INTO `verifyresults` VALUES (16, '2005-11-29 18:26:33', 'Fail', 0, 2, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', 'Bomb! Again', 'This is a big problem with no workaround.  Adding a bug.', 'Click on the TestRunID link', 'Verification page should appear.', '', '', '', '4.0', 'M1133305986', '2005-11-29 18:13:06');
INSERT INTO `verifyresults` VALUES (17, '2007-02-27 10:43:58', 'Pass', 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', '', '', 'Criar Ponto de Referencia, apertando botao.', 'Botao selecionado', '', '', NULL, '1.0', 'M1172583838432', NULL);
INSERT INTO `verifyresults` VALUES (18, '2007-02-27 10:43:58', 'Pass', 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', '', '', 'Entrar com coordenada X', 'Dado preenchido OK na tela.', '', '', NULL, '2.0', 'M1172583838432', NULL);
INSERT INTO `verifyresults` VALUES (19, '2007-02-27 10:43:58', 'Pass', 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', '', '', 'Entrar com coordenada Y', 'Dado preenchido OK na tela.', '', '', NULL, '3.0', 'M1172583838432', NULL);
INSERT INTO `verifyresults` VALUES (20, '2007-02-27 10:43:58', 'Pass', 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', '', '', 'Clicar no ENTER', 'Botao selecionado/clicado', '', '', NULL, '4.0', 'M1172583838432', NULL);
INSERT INTO `verifyresults` VALUES (21, '2007-02-27 10:43:58', 'Pass', 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', 'OK 100%', '', 'Verificar criação do P.R.', 'P.R. criado OK.', '', '', NULL, '5.0', 'M1172583838432', NULL);