CREATE TABLE `findbugs_bugreport` (
  `id` int(11) NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL,
  `bugReportId` varchar(64) NOT NULL,
  `whoFiled` varchar(64) NOT NULL,
  `whenFiled` datetime NOT NULL,
  `status` varchar(64) default NULL,
  `assignedTo` varchar(64) default NULL,
  `componentId` varchar(64) default NULL,
  `componentName` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Keeps track of bugs filed against FindBugs issues'  ;

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

--
-- Table structure for table `findbugs_evaluation`
--

CREATE TABLE `findbugs_evaluation` (
  `id` int(11) NOT NULL auto_increment,
  `issueId` int(11) NOT NULL,
  `who` varchar(128) NOT NULL,
  `designation` varchar(16) NOT NULL,
  `comment` text NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `issueId` (`issueId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;

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

--
-- Table structure for table `findbugs_issue`
--

CREATE TABLE `findbugs_issue` (
  `id` int(11) NOT NULL auto_increment,
  `firstSeen` datetime NOT NULL,
  `lastSeen` datetime NOT NULL,
  `hash` varchar(32) NOT NULL,
  `bugPattern` varchar(80) NOT NULL,
  `priority` int(11) NOT NULL,
  `primaryClass` varchar(512) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;

CREATE TABLE `findbugs_invocation` (
  `id` int(11) NOT NULL auto_increment,
  `who` varchar(64) NOT NULL,
  `entryPoint` varchar(16) NOT NULL,
  `dataSource` varchar(16) NOT NULL,
  `fbVersion` varchar(16) NOT NULL,
  `initialSyncTime` int(11) NOT NULL,
  `numIssues` int(11) NOT NULL,
  `startTime` datetime NOT NULL,
  `endTime` datetime,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `findbugs_evaluation`
--
ALTER TABLE `findbugs_evaluation`
  ADD CONSTRAINT `findbugs_evaluation_ibfk_1` FOREIGN KEY (`issueId`) REFERENCES `findbugs_issue` (`id`) ON DELETE CASCADE;