1#-------------------------------------------------------- 2# Host: localhost Database: rth 3#-------------------------------------------------------- 4 5#SET sql_mode = 'ANSI'; 6 7# 8# Table structure for table 'bug' 9# 10 11CREATE TABLE `bug` ( 12 `BugID` int(8) unsigned NOT NULL auto_increment, 13 `ProjectID` int(8) unsigned default NULL, 14 `Category` int(8) unsigned default NULL, 15 `Component` int(8) unsigned default NULL, 16 `Priority` varchar(32) default NULL, 17 `Severity` varchar(32) default NULL, 18 `ClosedReasonCode` varchar(32) default NULL, 19 `Status` varchar(64) default NULL, 20 `Reporter` varchar(128) default NULL, 21 `ReportedDate` varchar(19) default NULL, 22 `AssignedTo` varchar(128) default NULL, 23 `AssignedToDeveloper` varchar(128) default NULL, 24 `Closed` char(1) default 'N', 25 `ClosedDate` varchar(19) default NULL, 26 `TestID` varchar(20) default NULL, 27 `ReqID` varchar(20) default NULL, 28 `FoundInRelease` varchar(32) default NULL, 29 `AssignToRelease` varchar(32) default NULL, 30 `ImplementedInRelease` varchar(32) default NULL, 31 `DiscoveryPeriod` varchar(32) default NULL, 32 `Summary` varchar(128) default NULL, 33 `Description` text, 34 PRIMARY KEY (`BugID`), 35 KEY `ProjectID` (`ProjectID`) 36) ENGINE=MyISAM DEFAULT CHARSET=utf8; 37 38 39 40# 41# Dumping data for table 'bug' 42# 43INSERT 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"); 44INSERT 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"); 45 46 47# 48# Table structure for table 'bugassoc' 49# 50 51CREATE TABLE `bugassoc` ( 52 `BugAssocID` int(8) unsigned NOT NULL auto_increment, 53 `PrimaryID` int(8) unsigned default NULL, 54 `SecondaryID` int(8) unsigned default NULL, 55 `RelationshipType` char(1) default NULL, 56 PRIMARY KEY (`BugAssocID`) 57) ENGINE=MyISAM DEFAULT CHARSET=utf8; 58 59 60 61# 62# Dumping data for table 'bugassoc' 63# 64 65 66# 67# Table structure for table 'bugcategory' 68# 69 70CREATE TABLE `bugcategory` ( 71 `CategoryID` int(8) unsigned NOT NULL auto_increment, 72 `ProjectID` int(8) unsigned default NULL, 73 `CategoryName` varchar(64) default NULL, 74 PRIMARY KEY (`CategoryID`), 75 UNIQUE KEY `projectid` (`CategoryName`,`ProjectID`) 76) ENGINE=MyISAM DEFAULT CHARSET=utf8; 77 78 79 80# 81# Dumping data for table 'bugcategory' 82# 83INSERT INTO bugcategory VALUES(1,1,"Defect"); 84INSERT INTO bugcategory VALUES(2,1,"Data Change"); 85INSERT INTO bugcategory VALUES(3,1,"Enhancement"); 86 87 88# 89# Table structure for table 'bugcomponent' 90# 91 92CREATE TABLE `bugcomponent` ( 93 `ComponentID` int(8) unsigned NOT NULL auto_increment, 94 `ProjectID` int(8) unsigned default NULL, 95 `ComponentName` varchar(64) default NULL, 96 PRIMARY KEY (`ComponentID`), 97 UNIQUE KEY `projectid` (`ComponentName`,`ProjectID`) 98) ENGINE=MyISAM DEFAULT CHARSET=utf8; 99 100 101 102# 103# Dumping data for table 'bugcomponent' 104# 105INSERT INTO bugcomponent VALUES(1,1,"E-mail"); 106INSERT INTO bugcomponent VALUES(2,1,"Requirements"); 107INSERT INTO bugcomponent VALUES(3,1,"Tests"); 108INSERT INTO bugcomponent VALUES(4,1,"Test Results"); 109INSERT INTO bugcomponent VALUES(5,1,"Defects"); 110 111 112# 113# Table structure for table 'bugfile' 114# 115 116CREATE TABLE `bugfile` ( 117 `BugFileID` int(8) unsigned NOT NULL auto_increment, 118 `BugID` int(8) unsigned default NULL, 119 `UploadedDate` varchar(19) default NULL, 120 `UploadedBy` varchar(30) default NULL, 121 `DisplayName` varchar(255) default NULL, 122 `BugFileName` varchar(255) default NULL, 123 PRIMARY KEY (`BugFileID`) 124) ENGINE=MyISAM DEFAULT CHARSET=utf8; 125 126 127# 128# Table structure for table 'bugfile' 129# 130 131 132# 133# Table structure for table 'bughistory' 134# 135 136CREATE TABLE `bughistory` ( 137 `BugHistoryID` int(8) unsigned NOT NULL auto_increment, 138 `BugID` int(8) unsigned default NULL, 139 `DateModified` varchar(19) default NULL, 140 `UserName` varchar(64) default NULL, 141 `Field` varchar(64) default NULL, 142 `OldValue` varchar(64) default NULL, 143 `NewValue` varchar(64) default NULL, 144 PRIMARY KEY (`BugHistoryID`) 145) ENGINE=MyISAM DEFAULT CHARSET=utf8; 146 147 148 149# 150# Dumping data for table 'bughistory' 151# 152INSERT INTO bughistory VALUES(1,1,"2005-11-26 17:59:47","admin","New Defect","",""); 153INSERT INTO bughistory VALUES(2,2,"2005-11-29 18:34:21","admin","New Defect","",""); 154 155 156# 157# Table structure for table 'bugmonitor' 158# 159 160CREATE TABLE `bugmonitor` ( 161 `BugMonitorID` int(11) unsigned NOT NULL auto_increment, 162 `UserID` int(11) unsigned NOT NULL default '0', 163 `BugID` int(11) unsigned NOT NULL default '0', 164 `Monitor` char(1) NOT NULL default 'N', 165 PRIMARY KEY (`BugMonitorID`), 166 UNIQUE KEY `userid_bugid` (`UserID`,`BugID`) 167) ENGINE=MyISAM DEFAULT CHARSET=utf8; 168 169 170 171# 172# Dumping data for table 'bugmonitor' 173# 174 175 176# 177# Table structure for table 'bugnote' 178# 179 180CREATE TABLE `bugnote` ( 181 `BugNoteID` int(8) unsigned NOT NULL auto_increment, 182 `BugID` int(8) unsigned default NULL, 183 `Author` varchar(64) default NULL, 184 `DateCreated` varchar(19) default NULL, 185 `BugNoteDetail` text, 186 PRIMARY KEY (`BugNoteID`) 187) ENGINE=MyISAM DEFAULT CHARSET=utf8; 188 189 190 191# 192# Dumping data for table 'bugnote' 193# 194 195 196# 197# Table structure for table 'build' 198# 199 200CREATE TABLE `build` ( 201 `ReleaseID` int(8) unsigned NOT NULL default '0', 202 `BuildID` int(8) unsigned NOT NULL auto_increment, 203 `BuildName` varchar(20) default NULL, 204 `Description` text, 205 `DateReceived` varchar(19) NOT NULL default '', 206 `DateFinished` varchar(19) NOT NULL default '', 207 `Archive` char(1) NOT NULL default '', 208 `DateCreated` varchar(19) NOT NULL default '', 209 `LogTimeStamp` varchar(19) NOT NULL default '', 210 PRIMARY KEY (`BuildID`) 211) ENGINE=MyISAM DEFAULT CHARSET=utf8; 212 213 214 215# 216# Dumping data for table 'build' 217# 218INSERT 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"); 219 220 221# 222# Table structure for table 'discussion' 223# 224 225CREATE TABLE `discussion` ( 226 `DiscussionID` int(8) unsigned NOT NULL auto_increment, 227 `ReqID` int(8) unsigned NOT NULL default '0', 228 `Discussion` text, 229 `Status` varchar(7) default NULL, 230 `DiscSubject` varchar(255) default NULL, 231 `Author` varchar(25) default NULL, 232 `AssignTo` varchar(25) default NULL, 233 `Date` varchar(19) default NULL, 234 PRIMARY KEY (`DiscussionID`) 235) ENGINE=MyISAM DEFAULT CHARSET=utf8; 236 237 238 239# 240# Dumping data for table 'discussion' 241# 242 243 244# 245# Table structure for table 'discussionpost' 246# 247 248CREATE TABLE `discussionpost` ( 249 `PostID` int(8) unsigned NOT NULL auto_increment, 250 `DiscussionID` int(8) unsigned NOT NULL default '0', 251 `Post` text, 252 `Author` varchar(25) default NULL, 253 `AssignTo` varchar(25) default NULL, 254 `Date` varchar(19) default NULL, 255 PRIMARY KEY (`PostID`) 256) ENGINE=MyISAM DEFAULT CHARSET=utf8; 257 258 259 260# 261# Dumping data for table 'discussionpost' 262# 263 264 265# 266# Table structure for table 'feedback' 267# 268 269CREATE TABLE `feedback` ( 270 `FeedbackID` smallint(4) unsigned NOT NULL auto_increment, 271 `Author` varchar(15) default NULL, 272 `Comment` text, 273 `Project` varchar(15) default NULL, 274 `TimeStamp` varchar(19) default NULL, 275 PRIMARY KEY (`FeedbackID`) 276) ENGINE=MyISAM DEFAULT CHARSET=utf8; 277 278 279 280# 281# Dumping data for table 'feedback' 282# 283 284# 285# Table structure for table 'function_tbl' 286# 287 288CREATE TABLE `function_tbl` ( 289 `function_id` int(8) unsigned NOT NULL auto_increment, 290 `date_created` varchar(19) NOT NULL default '', 291 `last_updated` varchar(19) NOT NULL default '', 292 `last_updated_by` varchar(30) NOT NULL default '', 293 `function_name` varchar(128) NOT NULL default '', 294 `description` varchar(255) default NULL, 295 PRIMARY KEY (`function_id`) 296) ENGINE=MyISAM DEFAULT CHARSET=utf8; 297 298 299# 300# Dumping data for table 'function_tbl' 301# 302 303# 304# Table structure for table 'guichecktable' 305# 306 307CREATE TABLE `guichecktable` ( 308 `GuiCheckID` int(8) unsigned NOT NULL auto_increment, 309 `GuiCheckNumber` int(3) unsigned default NULL, 310 `IconCode` varchar(6) default NULL, 311 `TS_UniqueRunID` varchar(14) default NULL, 312 `ObjectName` varchar(50) default NULL, 313 `ExpectedValue` varchar(50) default NULL, 314 `ActualValue` varchar(50) default NULL, 315 `Status` varchar(10) default NULL, 316 PRIMARY KEY (`GuiCheckID`) 317) ENGINE=MyISAM DEFAULT CHARSET=utf8; 318 319 320 321# 322# Dumping data for table 'guichecktable' 323# 324 325 326# 327# Table structure for table 'individualrundocs' 328# 329 330CREATE TABLE `individualrundocs` ( 331 `UniqueDocID` int(8) unsigned NOT NULL auto_increment, 332 `TS_UniqueRunID` varchar(14) default '0', 333 `TimeStamp` varchar(19) default NULL, 334 `UploadedBy` varchar(50) default NULL, 335 `FileName` varchar(255) default NULL, 336 `DisplayName` varchar(150) default NULL, 337 `Comments` varchar(255) default NULL, 338 `Link` varchar(255) default NULL, 339 PRIMARY KEY (`UniqueDocID`) 340) ENGINE=MyISAM DEFAULT CHARSET=utf8; 341 342 343 344# 345# Dumping data for table 'individualrundocs' 346# 347 348 349# 350# Table structure for table 'issues' 351# 352 353CREATE TABLE `issues` ( 354 `id` int(6) unsigned NOT NULL auto_increment, 355 `Name` char(150) default NULL, 356 `Priority` char(50) default NULL, 357 `Status` char(50) default NULL, 358 `Details` char(255) default NULL, 359 `Owner` char(50) default NULL, 360 `Timestamp` varchar(19) default NULL, 361 `Type` char(50) default NULL, 362 PRIMARY KEY (`id`) 363) ENGINE=MyISAM DEFAULT CHARSET=utf8; 364 365 366 367# 368# Dumping data for table 'issues' 369# 370 371 372# 373# Table structure for table 'logs' 374# 375 376CREATE TABLE `logs` ( 377 `LogID` int(8) unsigned NOT NULL auto_increment, 378 `SessionID` int(10) unsigned default NULL, 379 `Deletion` char(1) default NULL, 380 `Creation` char(1) default NULL, 381 `Upload` char(1) default NULL, 382 `TimeStamp` varchar(19) default NULL, 383 `User` varchar(30) default NULL, 384 `Page` varchar(50) default NULL, 385 `Action` text, 386 PRIMARY KEY (`LogID`) 387) ENGINE=MyISAM DEFAULT CHARSET=utf8; 388 389 390 391# 392# Dumping data for table 'logs' 393# 394INSERT INTO logs VALUES(1,"1132802461","N","Y","N","2005-11-23 22:30:21","admin","CREATE RELEASE - DEMO","ADDED RELEASE Release 1.0"); 395INSERT 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"); 396INSERT INTO logs VALUES(3,"1132802461","N","Y","N","2005-11-23 22:37:05","admin","CREATE TEST - DEMO","ADDED TEST Demo_Test"); 397INSERT 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"); 398INSERT 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"); 399INSERT 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"); 400INSERT 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"); 401INSERT INTO logs VALUES(8,"1132802461","N","Y","N","2005-11-23 22:49:23","admin","CREATE TEST - DEMO","ADDED TEST Demo_Test2"); 402INSERT 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"); 403INSERT 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"); 404INSERT 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"); 405INSERT 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"); 406INSERT 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"); 407 408 409# 410# Table structure for table 'manualdoctype' 411# 412 413CREATE TABLE `manualdoctype` ( 414 `ManualDocTypeID` smallint(4) unsigned NOT NULL auto_increment, 415 `ProjectID` int(8) unsigned default NULL, 416 `ManualDocTypeName` varchar(50) default '0', 417 PRIMARY KEY (`ManualDocTypeID`) 418) ENGINE=MyISAM DEFAULT CHARSET=utf8; 419 420 421 422# 423# Dumping data for table 'manualdoctype' 424# 425INSERT INTO manualdoctype VALUES(1,1,"Test Case"); 426INSERT INTO manualdoctype VALUES(2,1,"Rules Doc"); 427 428 429# 430# Table structure for table 'manualtestdocs' 431# 432 433CREATE TABLE `manualtestdocs` ( 434 `ManualTestID` int(8) unsigned NOT NULL auto_increment, 435 `TestID` int(8) unsigned NOT NULL default '0', 436 `DisplayName` varchar(150) default 'NULL', 437 PRIMARY KEY (`ManualTestID`) 438) ENGINE=MyISAM DEFAULT CHARSET=utf8; 439 440 441 442# 443# Dumping data for table 'manualtestdocs' 444# 445 446 447# 448# Table structure for table 'manualtestdocs_version' 449# 450 451CREATE TABLE `manualtestdocs_version` ( 452 `VersionID` int(8) unsigned NOT NULL auto_increment, 453 `ManualTestID` int(8) unsigned default NULL, 454 `Version` decimal(4,2) default NULL, 455 `TimeStamp` varchar(19) default NULL, 456 `UploadedBy` varchar(50) default NULL, 457 `FileName` varchar(150) default NULL, 458 `Comments` text, 459 `ManualDocTypeName` varchar(50) default NULL, 460 PRIMARY KEY (`VersionID`), 461 KEY `manualtestid_timestamp` (`ManualTestID`,`TimeStamp`) 462) ENGINE=MyISAM DEFAULT CHARSET=utf8; 463 464 465 466# 467# Dumping data for table 'manualtestdocs_version' 468# 469 470 471# 472# Table structure for table 'news' 473# 474 475CREATE TABLE `news` ( 476 `project_id` int(6) unsigned NOT NULL default '0', 477 `NewsID` int(8) unsigned NOT NULL auto_increment, 478 `Subject` varchar(100) NOT NULL default '', 479 `Body` text, 480 `LastModified` varchar(19) NOT NULL default '', 481 `Poster` varchar(20) NOT NULL default '', 482 `Deleted` char(1) NOT NULL default 'N', 483 PRIMARY KEY (`NewsID`) 484) ENGINE=MyISAM DEFAULT CHARSET=utf8; 485 486 487 488# 489# Dumping data for table 'news' 490# 491 492 493# 494# Table structure for table 'release_tbl' 495# 496 497CREATE TABLE `release_tbl` ( 498 `project_id` int(8) unsigned NOT NULL default '0', 499 `ReleaseID` int(8) unsigned NOT NULL auto_increment, 500 `Archive` char(1) NOT NULL default 'N', 501 `ReleaseName` varchar(20) NOT NULL default '', 502 `Description` text, 503 `DateReceived` varchar(19) NOT NULL default '', 504 `DateCreated` varchar(19) NOT NULL default '', 505 `LogTimeStamp` varchar(19) NOT NULL default '', 506 `Platform` varchar(6) NOT NULL default '', 507 `QASignoffDate` varchar(19) NOT NULL default '', 508 `BASignoffDate` varchar(19) NOT NULL default '', 509 `QASignoffBy` varchar(25) NOT NULL default '', 510 `BASignoffBy` varchar(25) NOT NULL default '', 511 `QASignoff` varchar(40) NOT NULL default '', 512 `BASignoff` varchar(40) NOT NULL default '', 513 `QASignoffComments` text, 514 `BASignoffComments` text, 515 PRIMARY KEY (`ReleaseID`) 516) ENGINE=MyISAM DEFAULT CHARSET=utf8; 517 518 519 520# 521# Dumping data for table 'release_tbl' 522# 523INSERT 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","","","","","","","","",""); 524 525 526# 527# Table structure for table 'requirement' 528# 529 530CREATE TABLE `requirement` ( 531 `project_id` int(8) unsigned NOT NULL default '0', 532 `ReqID` int(8) unsigned NOT NULL auto_increment, 533 `ReqName` varchar(255) NOT NULL default '', 534 `AreaCovered` int(11) unsigned NOT NULL default '0', 535 `Type` int(8) unsigned NOT NULL default '0', 536 `RecordOrFile` char(1) NOT NULL default 'R', 537 `UnTestable` char(1) default 'N', 538 `LockedBy` varchar(25) NOT NULL default '', 539 `LockedDate` varchar(25) NOT NULL default '', 540 `Priority` varchar(25) default NULL, 541 `Parent` int(8) unsigned NOT NULL default '0', 542 `DateCreated` varchar(19) default NULL, 543 `LogTimeStamp` varchar(19) default NULL, 544 `LastUpdated` varchar(19) default NULL, 545 PRIMARY KEY (`ReqID`), 546 UNIQUE KEY `projectid` (`ReqName`,`project_id`), 547 KEY `parent` (`Parent`) 548) ENGINE=MyISAM DEFAULT CHARSET=utf8; 549 550 551 552# 553# Dumping data for table 'requirement' 554# 555INSERT 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"); 556INSERT 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"); 557INSERT 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"); 558 559 560# 561# Table structure for table 'requirementareacoverage' 562# 563 564CREATE TABLE `requirementareacoverage` ( 565 `ReqAreaCoverageID` int(8) unsigned NOT NULL auto_increment, 566 `ProjectID` int(8) unsigned default NULL, 567 `AreaCoverage` varchar(50) default NULL, 568 PRIMARY KEY (`ReqAreaCoverageID`), 569 UNIQUE KEY `projectid` (`ProjectID`,`AreaCoverage`) 570) ENGINE=MyISAM DEFAULT CHARSET=utf8; 571 572 573 574# 575# Dumping data for table 'requirementareacoverage' 576# 577INSERT INTO requirementareacoverage VALUES(1,1,"Requirements"); 578INSERT INTO requirementareacoverage VALUES(2,1,"Bugs"); 579INSERT INTO requirementareacoverage VALUES(3,1,"Tests"); 580INSERT INTO requirementareacoverage VALUES(4,1,"Test Results"); 581 582 583# 584# Table structure for table 'requirementdocumenttype' 585# 586 587CREATE TABLE `requirementdocumenttype` ( 588 `ReqDocTypeID` smallint(4) unsigned NOT NULL auto_increment, 589 `ProjectID` int(8) unsigned NOT NULL default '0', 590 `ReqDocTypeName` varchar(50) NOT NULL default '', 591 `RootDocument` char(1) NOT NULL default 'N', 592 PRIMARY KEY (`ReqDocTypeID`), 593 UNIQUE KEY `projectid` (`ProjectID`,`ReqDocTypeName`) 594) ENGINE=MyISAM DEFAULT CHARSET=utf8; 595 596 597 598# 599# Dumping data for table 'requirementdocumenttype' 600# 601INSERT INTO requirementdocumenttype VALUES(1,1,"Use Case","N"); 602INSERT INTO requirementdocumenttype VALUES(2,1,"Func Spec","N"); 603INSERT INTO requirementdocumenttype VALUES(3,1,"Tech Spec","N"); 604 605 606# 607# Table structure for table 'requirementfunctionality' 608# 609 610CREATE TABLE `requirementfunctionality` ( 611 `FunctionalityID` int(8) unsigned NOT NULL auto_increment, 612 `ProjectID` int(8) unsigned NOT NULL default '0', 613 `FunctionalityName` varchar(50) NOT NULL default '0', 614 PRIMARY KEY (`FunctionalityID`), 615 UNIQUE KEY `projectid` (`ProjectID`,`FunctionalityName`) 616) ENGINE=MyISAM DEFAULT CHARSET=utf8; 617 618 619 620# 621# Dumping data for table 'requirementfunctionality' 622# 623INSERT INTO requirementfunctionality VALUES(1,1,"User Mgmt"); 624INSERT INTO requirementfunctionality VALUES(7,1,"Run Level"); 625INSERT INTO requirementfunctionality VALUES(8,1,"Permissions"); 626INSERT INTO requirementfunctionality VALUES(5,1,"Cron"); 627INSERT INTO requirementfunctionality VALUES(6,1,"Group Mgmt"); 628 629 630# 631# Table structure for table 'requirementfunctionality_assoc' 632# 633 634CREATE TABLE `requirementfunctionality_assoc` ( 635 `RequirementFunctionality_AssocID` int(6) unsigned NOT NULL auto_increment, 636 `RequirementID` int(6) unsigned NOT NULL default '0', 637 `RequirementFunctionalityID` int(6) unsigned NOT NULL default '0', 638 PRIMARY KEY (`RequirementFunctionality_AssocID`), 639 UNIQUE KEY `reqid_reqfunctid` (`RequirementID`,`RequirementFunctionalityID`) 640) ENGINE=MyISAM DEFAULT CHARSET=utf8; 641 642 643 644# 645# Dumping data for table 'requirementfunctionality_assoc' 646# 647INSERT INTO requirementfunctionality_assoc VALUES(1,1,8); 648INSERT INTO requirementfunctionality_assoc VALUES(2,2,7); 649INSERT INTO requirementfunctionality_assoc VALUES(3,3,8); 650 651 652# 653# Table structure for table 'requirementnotifications' 654# 655 656CREATE TABLE `requirementnotifications` ( 657 `ReqNotifyID` int(8) unsigned NOT NULL auto_increment, 658 `ReqID` int(8) unsigned NOT NULL default '0', 659 `UserID` int(8) NOT NULL default '0', 660 PRIMARY KEY (`ReqNotifyID`), 661 UNIQUE KEY `userid_reqid` (`UserID`,`ReqID`) 662) ENGINE=MyISAM DEFAULT CHARSET=utf8; 663 664 665 666# 667# Dumping data for table 'requirementnotifications' 668# 669 670 671# 672# Table structure for table 'requirementversion' 673# 674 675CREATE TABLE `requirementversion` ( 676 `ReqVersionID` int(8) unsigned NOT NULL auto_increment, 677 `ReqID` int(8) unsigned NOT NULL default '0', 678 `defect_id` int(8) unsigned NOT NULL default '0', 679 `Version` varchar(5) NOT NULL default '', 680 `Latest` char(1) NOT NULL default '', 681 `TimeStamp` varchar(19) default NULL, 682 `Author` varchar(50) NOT NULL default '', 683 `FileName` varchar(150) NOT NULL default '', 684 `ReasonForChange` text, 685 `Status` varchar(25) NOT NULL default '', 686 `AssignedTo` varchar(255) NOT NULL default '', 687 `Detail` text, 688 `LastUpdated` varchar(19) default NULL, 689 `LastUpdatedBy` varchar(30) NOT NULL default '', 690 PRIMARY KEY (`ReqVersionID`), 691 KEY `ReqID` (`ReqID`) 692) ENGINE=MyISAM DEFAULT CHARSET=utf8; 693 694 695 696# 697# Dumping data for table 'requirementversion' 698# 699INSERT INTO requirementversion VALUES(1,1,"1.0","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"); 700INSERT INTO requirementversion VALUES(2,2,"1.0","0","Y","2005-11-23 23:08:35","admin","","","","","Creating a sub-requirement","2005-11-23 23:08:35","admin"); 701INSERT INTO requirementversion VALUES(3,3,"1.0","0","Y","2005-11-23 23:14:24","admin","","","","","A second sub-requirement","2005-11-23 23:14:24","admin"); 702 703 704# 705# Table structure for table 'requirementversion_release_assoc' 706# 707 708CREATE TABLE `requirementversion_release_assoc` ( 709 `RequirementVersion_Release_AssocID` int(6) unsigned NOT NULL auto_increment, 710 `RequirementVersionID` int(6) unsigned NOT NULL default '0', 711 `ReleaseID` int(6) unsigned NOT NULL default '0', 712 PRIMARY KEY (`RequirementVersion_Release_AssocID`), 713 UNIQUE KEY `reqversionid_releaseid` (`RequirementVersionID`,`ReleaseID`) 714) ENGINE=MyISAM DEFAULT CHARSET=utf8; 715 716 717 718# 719# Dumping data for table 'requirementversion_release_assoc' 720# 721 722 723# 724# Table structure for table 'screen' 725# 726 727CREATE TABLE `screen` ( 728 `screen_id` int(8) unsigned NOT NULL auto_increment, 729 `project_id` int(8) unsigned NOT NULL, 730 `screen_order` DECIMAL(8,1) NOT NULL, 731 `screen_name` varchar(64) default NULL, 732 `screen_desc` varchar(255) default NULL, 733 PRIMARY KEY (`screen_id`) 734) ENGINE=MyISAM DEFAULT CHARSET=utf8; 735 736 737# 738# Dumping data for table 'screen' 739# 740 741 742CREATE TABLE `field_tbl` ( 743 `field_id` int(8) unsigned NOT NULL auto_increment, 744 `screen_id` int(8) unsigned NOT NULL, 745 `text_only` char(1), 746 `field_order` DECIMAL(8,1) NOT NULL, 747 `field_name` varchar(64) default NULL, 748 `field_desc` varchar(255) default NULL, 749 PRIMARY KEY (`field_id`) 750) ENGINE=MyISAM DEFAULT CHARSET=utf8; 751 752 753# 754# Dumping data for table 'field_tbl' 755# 756 757 758 759# 760# Table structure for table 'project' 761# 762 763CREATE TABLE `project` ( 764 `project_id` int(4) unsigned NOT NULL auto_increment, 765 `use_files` char(1) NOT NULL default 'Y', 766 `show_custom_1` char(1) NOT NULL default 'Y', 767 `show_custom_2` char(1) NOT NULL default 'Y', 768 `show_custom_3` char(1) NOT NULL default 'Y', 769 `show_custom_4` char(1) NOT NULL default 'Y', 770 `show_custom_5` char(1) default 'Y', 771 `show_custom_6` char(1) default 'Y', 772 `show_window` char(1) NOT NULL default 'Y', 773 `show_object` char(1) NOT NULL default 'Y', 774 `show_memory_stats` char(1) NOT NULL default 'Y', 775 `show_priority` char(1) NOT NULL default 'Y', 776 `show_test_input` char(1) NOT NULL default 'Y', 777 `status` char(1) NOT NULL default 'Y', 778 `date_created` varchar(19) default NULL, 779 `project_name` varchar(50) NOT NULL default '', 780 `description` varchar(255) NOT NULL default '', 781 `req_upload_path` varchar(255) default NULL, 782 `test_upload_path` varchar(255) default NULL, 783 `test_run_upload_path` varchar(255) default NULL, 784 `test_plan_upload_path` varchar(255) NOT NULL default '', 785 `defect_upload_path` varchar(255) NOT NULL default '', 786 `bug_url` varchar(255) default NULL, 787 `deleted` char(1) NOT NULL default 'N', 788 PRIMARY KEY (`project_id`), 789 UNIQUE KEY `project_name` (`project_name`) 790) ENGINE=MyISAM DEFAULT CHARSET=utf8; 791 792 793 794# 795# Dumping data for table 'project' 796# 797INSERT INTO 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/","./rth_file_upload/DEMO_defect_docs/","","N"); 798 799 800# 801# Table structure for table 'project_user_assoc' 802# 803 804CREATE TABLE `project_user_assoc` ( 805 `project_user_assoc_id` int(4) unsigned NOT NULL auto_increment, 806 `project_id` int(4) unsigned NOT NULL default '0', 807 `user_id` int(4) unsigned NOT NULL default '0', 808 `delete_rights` char(1) default NULL, 809 `email_testset` char(1) default NULL, 810 `email_discussion` char(1) default NULL, 811 `email_new_bug` char(1) NOT NULL default 'N', 812 `email_update_bug` char(1) NOT NULL default 'N', 813 `email_assigned_bug` char(1) NOT NULL default 'N', 814 `email_bugnote_bug` char(1) NOT NULL default 'N', 815 `email_status_bug` char(1) NOT NULL default 'N', 816 `qa_tester` char(1) default NULL, 817 `ba_owner` char(1) default NULL, 818 `user_rights` varchar(25) default NULL, 819 PRIMARY KEY (`project_user_assoc_id`) 820) ENGINE=MyISAM DEFAULT CHARSET=utf8; 821 822 823 824# 825# Dumping data for table 'project_user_assoc' 826# 827INSERT INTO project_user_assoc VALUES(1,1,1,"Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","10"); 828INSERT INTO project_user_assoc VALUES(2,1,2,"N","N","N","N","N","N","Y","Y","Y","Y","10"); 829INSERT INTO project_user_assoc VALUES(3,1,3,"N","N","N","N","N","Y","N","Y","Y","Y","10"); 830 831 832# 833# Table structure for table 'reset_password' 834# 835 836CREATE TABLE `reset_password` ( 837 `reset_id` int(11) NOT NULL auto_increment, 838 `user` varchar(50) NOT NULL default '0', 839 `reset_link` varchar(25) NOT NULL default '', 840 `reset_used` char(1) NOT NULL default '', 841 `expires` varchar(19) default NULL, 842 PRIMARY KEY (`reset_id`), 843 UNIQUE KEY `reset_link` (`reset_link`) 844) ENGINE=MyISAM DEFAULT CHARSET=utf8; 845 846 847 848# 849# Dumping data for table 'reset_password' 850# 851 852# 853# Table structure for table 'step_tbl' 854# 855 856CREATE TABLE `step_tbl` ( 857 `step_id` int(8) unsigned NOT NULL auto_increment, 858 `function_id` int(8) unsigned default NULL, 859 `step_number` decimal(8,1) default NULL, 860 `action` text, 861 `inputs` text, 862 `expected_result` text, 863 `step_type` varchar(11) NOT NULL default '', 864 PRIMARY KEY (`step_id`) 865) ENGINE=MyISAM DEFAULT CHARSET=utf8; 866 867# 868# Dumping data for table 'step_tbl' 869# 870 871 872 873# 874# Table structure for table 'testarea' 875# 876 877CREATE TABLE `testarea` ( 878 `AreaTestedID` smallint(4) unsigned NOT NULL auto_increment, 879 `project_id` int(8) unsigned NOT NULL default '0', 880 `AreaTestedName` varchar(50) default '0', 881 PRIMARY KEY (`AreaTestedID`), 882 UNIQUE KEY `projectid` (`AreaTestedName`,`project_id`) 883) ENGINE=MyISAM DEFAULT CHARSET=utf8; 884 885 886 887# 888# Dumping data for table 'testarea' 889# 890INSERT INTO testarea VALUES(1,1,"Requirements"); 891INSERT INTO testarea VALUES(2,1,"Tests"); 892INSERT INTO testarea VALUES(3,1,"Test Results"); 893INSERT INTO testarea VALUES(4,1,"Bugs"); 894 895 896# 897# Table structure for table 'testenvironment' 898# 899 900CREATE TABLE `testenvironment` ( 901 `EnvironmentID` int(6) unsigned NOT NULL auto_increment, 902 `ProjectID` int(8) unsigned default NULL, 903 `EnvironmentName` char(50) default NULL, 904 PRIMARY KEY (`EnvironmentID`), 905 UNIQUE KEY `projectid` (`EnvironmentName`,`ProjectID`) 906) ENGINE=MyISAM DEFAULT CHARSET=utf8; 907 908 909 910# 911# Dumping data for table 'testenvironment' 912# 913INSERT INTO testenvironment VALUES(1,1,"Dev"); 914INSERT INTO testenvironment VALUES(2,1,"Prod"); 915INSERT INTO testenvironment VALUES(3,1,"QA"); 916 917# 918# Table structure for table 'test_function_assoc' 919# 920 921CREATE TABLE `test_function_assoc` ( 922 `test_func_assoc_id` int(8) unsigned NOT NULL auto_increment, 923 `test_id` int(8) unsigned NOT NULL default '0', 924 `function_id` int(8) unsigned NOT NULL default '0', 925 `on_error` varchar(128) default NULL, 926 PRIMARY KEY (`test_func_assoc_id`) 927) ENGINE=MyISAM DEFAULT CHARSET=utf8; 928 929# 930# Dumping data for table 'test_function_assoc' 931# 932 933# 934# Table structure for table 'testmachine' 935# 936 937CREATE TABLE `testmachine` ( 938 `MachineID` smallint(4) unsigned NOT NULL auto_increment, 939 `ProjectID` int(8) unsigned default NULL, 940 `MachineName` char(20) default NULL, 941 `MachineLocation` char(25) default NULL, 942 `MachineIPAddress` char(15) default NULL, 943 PRIMARY KEY (`MachineID`), 944 KEY `projectid` (`ProjectID`) 945) ENGINE=MyISAM DEFAULT CHARSET=utf8; 946 947 948 949# 950# Dumping data for table 'testmachine' 951# 952 953 954# 955# Table structure for table 'testplan' 956# 957 958CREATE TABLE `testplan` ( 959 `TestPlanID` int(8) unsigned NOT NULL auto_increment, 960 `BuildID` int(8) unsigned default NULL, 961 `TestPlanName` varchar(255) default NULL, 962 PRIMARY KEY (`TestPlanID`) 963) ENGINE=MyISAM DEFAULT CHARSET=utf8; 964 965 966 967# 968# Dumping data for table 'testplan' 969# 970 971 972# 973# Table structure for table 'testplanversion' 974# 975 976CREATE TABLE `testplanversion` ( 977 `TestPlanVersionID` int(8) unsigned NOT NULL auto_increment, 978 `TestPlanID` int(8) unsigned default NULL, 979 `Latest` char(1) default 'Y', 980 `Version` char(3) default NULL, 981 `UploadedDate` varchar(19) default NULL, 982 `UploadedBy` varchar(30) default NULL, 983 `FileName` varchar(255) default NULL, 984 `Comments` varchar(255) default NULL, 985 PRIMARY KEY (`TestPlanVersionID`) 986) ENGINE=MyISAM DEFAULT CHARSET=utf8; 987 988 989 990# 991# Dumping data for table 'testplanversion' 992# 993 994 995# 996# Table structure for table 'testset' 997# 998 999CREATE TABLE `testset` ( 1000 `TestSetID` int(8) unsigned NOT NULL auto_increment, 1001 `BuildID` int(8) unsigned NOT NULL default '0', 1002 `TestSetOrderBy` int(19) NOT NULL default '0', 1003 `Archive` char(3) NOT NULL default '', 1004 `DateCreated` varchar(19) NOT NULL default '2002-01-01 12:00:00', 1005 `SignOffDate` varchar(19) NOT NULL default '', 1006 `TestSetName` varchar(30) NOT NULL default '0', 1007 `SignOffBy` varchar(19) NOT NULL default '', 1008 `TestSetStatus` varchar(40) NOT NULL default '', 1009 `SignOffComments` varchar(255) NOT NULL default '', 1010 `Description` text, 1011 `UniqueID` varchar(15) NOT NULL default '', 1012 `TestSetType` varchar(30) default NULL, 1013 `LockChangeDate` varchar(19) default '', 1014 `Locked` varchar(1) NOT NULL default 'N', 1015 `LockBy` varchar(25) default '', 1016 `LockComment` varchar(300) default '', 1017 PRIMARY KEY (`TestSetID`), 1018 KEY `buildid` (`BuildID`) 1019) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1020 1021 1022 1023# 1024# Dumping data for table 'testset' 1025# 1026INSERT INTO testset VALUES(1,1,1,"N","2005-11-23 23:23:53","","Regression","","","","Our first ever test set","","","","N","",""); 1027 1028 1029# 1030# Table structure for table 'testset_testsuite_assoc' 1031# 1032 1033CREATE TABLE `testset_testsuite_assoc` ( 1034 `TestSet_TestSuite_AssocID` int(8) unsigned NOT NULL auto_increment, 1035 `TestSetID` int(8) unsigned NOT NULL default '0', 1036 `TestID` int(8) unsigned NOT NULL default '0', 1037 `Finished` smallint(1) unsigned default '0', 1038 `LogTimeStamp` varchar(19) default NULL, 1039 `root_cause` varchar(30) default NULL, 1040 `TestStatus` varchar(30) NOT NULL default 'Not Started', 1041 `AssignedTo` varchar(25) NOT NULL default '', 1042 `Comments` varchar(255) NOT NULL default '', 1043 PRIMARY KEY (`TestSet_TestSuite_AssocID`,`TestSetID`), 1044 KEY `testid_idx` (`TestID`), 1045 KEY `testsetid` (`TestSetID`) 1046) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1047 1048 1049 1050# 1051# Dumping data for table 'testset_testsuite_assoc' 1052# 1053INSERT INTO testset_testsuite_assoc VALUES(1,1,1,0,"2005-11-29 15:11:43","","Not Started","",""); 1054INSERT INTO testset_testsuite_assoc VALUES(2,1,2,0,"2005-11-29 18:26:33","Application Defect","Failed","admin","Failed on the final step"); 1055 1056 1057# 1058# Table structure for table 'teststatus' 1059# 1060 1061CREATE TABLE `teststatus` ( 1062 `TestStatusID` int(8) unsigned NOT NULL auto_increment, 1063 `project_id` int(8) unsigned NOT NULL default '0', 1064 `TestStatus` varchar(20) default NULL, 1065 PRIMARY KEY (`TestStatusID`) 1066) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1067 1068 1069 1070# 1071# Dumping data for table 'teststatus' 1072# 1073 1074 1075# 1076# Table structure for table 'teststep' 1077# 1078 1079CREATE TABLE `teststep` ( 1080 `TestStepID` int(8) unsigned NOT NULL auto_increment, 1081 `TestID` int(8) unsigned default NULL, 1082 `TestVersionID` int(8) unsigned default NULL, 1083 `TestStep_Number` decimal(8,1) default NULL, 1084 `Action` text, 1085 `Inputs` text, 1086 `Expected_Result` text, 1087 `StepType` varchar(11) NOT NULL default '', 1088 PRIMARY KEY (`TestStepID`) 1089) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1090 1091 1092 1093# 1094# Dumping data for table 'teststep' 1095# 1096INSERT INTO teststep VALUES(1,1,0,"2.0","Verify val_1 = 1","Person = my","val_1 = 1","N"); 1097INSERT INTO teststep VALUES(8,2,0,"4.0","Click on the TestRunID link ","Link= Mxxxxxx","Verification page should appear.","N"); 1098INSERT INTO teststep VALUES(2,1,0,"3.0","Verify val_2 = 1","Direction = left","val_2 = 1","N"); 1099INSERT INTO teststep VALUES(7,2,0,"3.0","Click on the Results link for Demo_Test2","","Test Run page should appear.","N"); 1100INSERT INTO teststep VALUES(3,1,0,"4.0","Verify val_3 = 1","Place = foot","val_3 = 1","N"); 1101INSERT INTO teststep VALUES(6,2,0,"2.0","Click the Latest Test Set hyperlink","id = 00001","Results page appears","N"); 1102INSERT 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"); 1103INSERT 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"); 1104 1105 1106# 1107# Table structure for table 'testsuite' 1108# 1109 1110CREATE TABLE `testsuite` ( 1111 `TestID` int(8) unsigned NOT NULL auto_increment, 1112 `project_id` int(8) unsigned NOT NULL default '0', 1113 `Deleted` char(3) NOT NULL default '', 1114 `Archive` char(3) NOT NULL default '', 1115 `CodeReview` char(3) NOT NULL default '', 1116 `BA_Approval` char(3) NOT NULL default '', 1117 `Steps` char(3) NOT NULL default '', 1118 `Script` char(3) NOT NULL default '', 1119 `LoadRunner` char(3) NOT NULL default '', 1120 `AutoPass` char(1) NOT NULL default '', 1121 `email_ba_owner` CHAR(1) NOT NULL default 'N', 1122 `email_qa_owner` CHAR(1) NOT NULL default 'N', 1123 `Duration` varchar(5) NOT NULL default '', 1124 `Purpose` text, 1125 `TestSuiteName` varchar(150) NOT NULL default '', 1126 `TestType` varchar(50) NOT NULL default '', 1127 `AreaTested` varchar(50) NOT NULL default '', 1128 `BAOwner` varchar(25) NOT NULL default '', 1129 `Scripter` varchar(25) NOT NULL default '', 1130 `Tester` varchar(25) default NULL, 1131 `ApprovedForAuto` varchar(20) NOT NULL default '', 1132 `Priority` varchar(11) NOT NULL default '', 1133 `Status` varchar(30) NOT NULL default '', 1134 `DateCreated` varchar(19) default NULL, 1135 `Comments` varchar(255) NOT NULL default '', 1136 `AssignedTo` varchar(15) NOT NULL default '', 1137 `AssignedBy` varchar(15) NOT NULL default '', 1138 `DateAssigned` varchar(10) NOT NULL default '', 1139 `ExpDateComplete` varchar(10) NOT NULL default '', 1140 `ActDateComplete` varchar(10) NOT NULL default '', 1141 `BASignOff` varchar(10) NOT NULL default '', 1142 `SignOffBy` varchar(30) default NULL, 1143 `SignOffDate` varchar(10) default NULL, 1144 `LastUpdated` varchar(19) default NULL, 1145 `LastUpdatedBy` varchar(30) NOT NULL default '', 1146 `UniqueID` varchar(15) NOT NULL default '', 1147 `TestStepLinkID` int(8) default NULL, 1148 `State` char(3) default NULL, 1149 PRIMARY KEY (`TestID`), 1150 KEY `areatested` (`AreaTested`) 1151) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1152 1153 1154 1155# 1156# Dumping data for table 'testsuite' 1157# 1158INSERT INTO testsuite VALUES(1,1,"N","N","","","YES","","","","","N","N","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,""); 1159INSERT INTO testsuite VALUES(2,1,"N","N","","","YES","","","","","","N","N","Demo_Test2","Regression","Bugs","ba_user","","qa_user","","Medium","New","","","","","","","","","","","2005-11-23 22:53:50","admin","",0,""); 1160 1161 1162# 1163# Table structure for table 'testsuite_requirement_assoc' 1164# 1165 1166CREATE TABLE `testsuite_requirement_assoc` ( 1167 `TestSuite_Requirement_AssocID` int(8) unsigned NOT NULL auto_increment, 1168 `TestID` int(8) unsigned NOT NULL default '0', 1169 `ReqID` int(8) unsigned NOT NULL default '0', 1170 `PercentCovered` int(3) unsigned NOT NULL default '0', 1171 PRIMARY KEY (`TestSuite_Requirement_AssocID`) 1172) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1173 1174 1175 1176# 1177# Dumping data for table 'testsuite_requirement_assoc' 1178# 1179INSERT INTO testsuite_requirement_assoc VALUES(1,1,1,50); 1180INSERT INTO testsuite_requirement_assoc VALUES(2,1,2,50); 1181 1182 1183# 1184# Table structure for table 'testsuiteresults' 1185# 1186 1187CREATE TABLE `testsuiteresults` ( 1188 `TestSuiteResultsID` int(8) unsigned NOT NULL auto_increment, 1189 `TestSetID` int(8) unsigned NOT NULL default '0', 1190 `project_id` int(8) unsigned NOT NULL default '0', 1191 `TestID` int(8) unsigned NOT NULL default '0', 1192 `LogTimeStamp` varchar(19) default NULL, 1193 `TestStatus` varchar(30) NOT NULL default 'Not Started', 1194 `assigned_to` varchar(25) NOT NULL default '', 1195 `root_cause` varchar(25) NOT NULL default '', 1196 `test_run_comment` varchar(255) NOT NULL default '', 1197 `Started` smallint(1) unsigned NOT NULL default '0', 1198 `Finished` smallint(1) unsigned NOT NULL default '0', 1199 `CVSVersion` decimal(4,2) NOT NULL default '0.00', 1200 `CheckedForAutoPass` char(1) NOT NULL default '', 1201 `OS` varchar(20) NOT NULL default '', 1202 `SP` varchar(15) NOT NULL default '', 1203 `nNumberID` varchar(8) NOT NULL default '', 1204 `UserID` varchar(10) NOT NULL default '', 1205 `MachineName` varchar(50) NOT NULL default '', 1206 `TestSuite` varchar(150) NOT NULL default '', 1207 `TestPath` varchar(255) NOT NULL default '', 1208 `Environment` varchar(20) NOT NULL default '', 1209 `RunID` varchar(25) NOT NULL default '', 1210 `TS_UniqueRunID` varchar(14) NOT NULL default '0', 1211 `TimeStarted` varchar(19) NOT NULL default '', 1212 `TimeFinished` varchar(19) NOT NULL default '', 1213 PRIMARY KEY (`TestSuiteResultsID`), 1214 KEY `TS_UniqueRunID` (`TS_UniqueRunID`), 1215 KEY `testid` (`TestID`), 1216 KEY `testset_id` (`TestSetID`,`TS_UniqueRunID`) 1217) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1218 1219 1220 1221# 1222# Dumping data for table 'testsuiteresults' 1223# 1224INSERT 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"); 1225INSERT 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"); 1226INSERT 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"); 1227 1228 1229# 1230# Table structure for table 'testtype' 1231# 1232 1233CREATE TABLE `testtype` ( 1234 `TestTypeID` int(6) unsigned NOT NULL auto_increment, 1235 `project_id` int(8) unsigned default NULL, 1236 `TestType` varchar(50) default NULL, 1237 PRIMARY KEY (`TestTypeID`), 1238 UNIQUE KEY `projectid` (`TestType`,`project_id`) 1239) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1240 1241 1242 1243# 1244# Dumping data for table 'testtype' 1245# 1246INSERT INTO testtype VALUES(1,1,"Smoke"); 1247INSERT INTO testtype VALUES(2,1,"Regression"); 1248INSERT INTO testtype VALUES(3,1,"Performance"); 1249INSERT INTO testtype VALUES(4,1,"Functional"); 1250 1251 1252# 1253# Table structure for table 'testversion' 1254# 1255 1256CREATE TABLE `testversion` ( 1257 `TestVersionID` int(8) unsigned NOT NULL auto_increment, 1258 `TestID` int(8) unsigned default NULL, 1259 `Version` decimal(4,2) default NULL, 1260 `Latest` char(1) default NULL, 1261 `ActiveVersion` char(1) default NULL, 1262 `Comments` varchar(255) default NULL, 1263 `Status` varchar(25) NOT NULL default '', 1264 `AssignedTo` varchar(30) NOT NULL default '', 1265 `BASignOff` varchar(10) NOT NULL default '', 1266 `SignOffBy` varchar(30) NOT NULL default '', 1267 `Creator` varchar(30) NOT NULL default '', 1268 `DateCreated` varchar(19) NOT NULL default '', 1269 PRIMARY KEY (`TestVersionID`) 1270) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1271 1272 1273 1274# 1275# Dumping data for table 'testversion' 1276# 1277INSERT INTO testversion VALUES(1,1,"1.00","Y","Y","","New","","","","admin","2005-11-23 22:37:05"); 1278INSERT INTO testversion VALUES(2,2,"1.00","Y","Y","","New","","","","admin","2005-11-23 22:49:23"); 1279 1280 1281# 1282# Table structure for table 'testworkflow' 1283# 1284 1285CREATE TABLE `testworkflow` ( 1286 `UniqueTestID` int(8) unsigned NOT NULL auto_increment, 1287 `Complete` char(1) NOT NULL default 'N', 1288 `TestName` varchar(150) default NULL, 1289 `BAToCreateTC` varchar(30) default NULL, 1290 `BACreateDateComp` varchar(10) default NULL, 1291 `QAToReviewTC` varchar(30) default NULL, 1292 `QAReviewDateComp` varchar(10) default NULL, 1293 `QAAutomated` varchar(30) default NULL, 1294 `QAAutoDateStart` varchar(10) default NULL, 1295 `QAAutoDateExp` varchar(10) default NULL, 1296 `QAAutoDateComp` varchar(10) default NULL, 1297 `BAToApprove` varchar(30) default NULL, 1298 `BAApprovalDate` varchar(10) default NULL, 1299 `Comments` varchar(255) default NULL, 1300 PRIMARY KEY (`UniqueTestID`) 1301) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1302 1303 1304 1305# 1306# Dumping data for table 'testworkflow' 1307# 1308 1309# 1310# Table structure for table 'user' 1311# 1312 1313CREATE TABLE `user` ( 1314 `user_id` int(4) unsigned NOT NULL auto_increment, 1315 `password` varchar(32) NOT NULL default '', 1316 `username` varchar(20) default NULL, 1317 `first_name` varchar(20) NOT NULL default '', 1318 `last_name` varchar(20) NOT NULL default '', 1319 `phone` varchar(25) NOT NULL default '', 1320 `menu_prefs` varchar(39) NOT NULL default '', 1321 `email` varchar(50) NOT NULL default '', 1322 `user_admin` varchar(25) NOT NULL default '', 1323 `default_project` int(6) unsigned NOT NULL default '0', 1324 `deleted` char(1) NOT NULL default 'N', 1325 `email_on_new` char(1) NOT NULL default '', 1326 `email_on_assigned_to` char(1) NOT NULL default '', 1327 `email_on_feedback` char(1) NOT NULL default '', 1328 `email_on_resolved` char(1) NOT NULL default '', 1329 `email_on_closed` char(1) NOT NULL default '', 1330 `email_on_reopened` char(1) NOT NULL default '', 1331 `email_on_bugnote` char(1) NOT NULL default '', 1332 `email_on_status` char(1) NOT NULL default '', 1333 `email_on_priority` char(1) NOT NULL default '', 1334 PRIMARY KEY (`user_id`) 1335) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1336 1337 1338 1339# 1340# Dumping data for table 'user' 1341# 1342INSERT INTO user VALUES(1,"5f4dcc3b5aa765d61d8327deb882cf99","admin","Big","Shot","","","gth2@users.sourceforge.net","Y","1","N","","","","","","","","",""); 1343INSERT INTO user VALUES(2,"b66c63a46b5a43eb5066cf6ac0b9f7ea","ba_owner","BA","Owner","","","user@domain.com","N","1","N","","","","","","","","",""); 1344INSERT INTO user VALUES(3,"cc0e9a92816eeed502687b0db4d546c9","qa_user","QA","User","","","user2@domain.com","N","1","N","","","","","","","","",""); 1345 1346 1347 1348# 1349# Table structure for table 'verifyresults' 1350# 1351 1352CREATE TABLE `verifyresults` ( 1353 `VerifyResultsID` int(11) unsigned NOT NULL auto_increment, 1354 `LogTimeStamp` varchar(19) default NULL, 1355 `TestStatus` varchar(6) NOT NULL default '', 1356 `LineNumber` int(5) unsigned NOT NULL default '0', 1357 `defect_id` int(8) unsigned NOT NULL default '0', 1358 `TotalPhyMem` int(11) unsigned NOT NULL default '0', 1359 `FreePhyMem` int(11) unsigned NOT NULL default '0', 1360 `TotalVirMem` int(11) unsigned NOT NULL default '0', 1361 `FreeVirMem` int(11) unsigned NOT NULL default '0', 1362 `CurMemUtil` int(11) unsigned NOT NULL default '0', 1363 `TotalPageFile` int(11) unsigned NOT NULL default '0', 1364 `FreePageFile` int(11) unsigned NOT NULL default '0', 1365 `Custom_5` char(2) default NULL, 1366 `Custom_3` varchar(8) NOT NULL default '', 1367 `Custom_1` varchar(13) NOT NULL default '', 1368 `Custom_2` varchar(20) NOT NULL default '', 1369 `Custom_6` varchar(20) NOT NULL default '', 1370 `Custom_4` varchar(20) NOT NULL default '', 1371 `ActualResult` text NOT NULL default '', 1372 `Comment` varchar(255) NOT NULL default '', 1373 `Action` text default NULL, 1374 `ExpectedResult` text default NULL, 1375 `Window` varchar(100) NOT NULL default '', 1376 `Object` varchar(100) NOT NULL default '', 1377 `ObjType` varchar(25) default NULL, 1378 `StepNumber` varchar(25) default NULL, 1379 `TS_UniqueRunID` varchar(14) NOT NULL default '0', 1380 `TimeStamp` varchar(19) default NULL, 1381 PRIMARY KEY (`VerifyResultsID`), 1382 KEY `teststatus` (`TestStatus`), 1383 KEY `ts_uniquerunid` (`TS_UniqueRunID`,`TestStatus`), 1384 KEY `defect` (`defect_id`) 1385) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1386 1387 1388 1389# 1390# Dumping data for table 'verifyresults' 1391# 1392INSERT 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"); 1393INSERT 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"); 1394INSERT 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"); 1395INSERT 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");