Database table structure
Introduction
The report generator needs a database. At present a Mysql database is used. Create a database Sakai and add the tables mentioned next.
In the Scripts directory sits dbh.conf that points here. If you want to change the database name then feel free.
Details
CREATE TABLE `sakai`.`basic_stats` ( `idbasic_stats` int(10) unsigned NOT NULL, `project` varchar(80) NOT NULL, `package` varchar(255) NOT NULL, `class` varchar(80) NOT NULL, `classsize` int(10) unsigned NOT NULL, `nolines` int(10) unsigned NOT NULL, `todo` int(10) unsigned NOT NULL, `imports` int(10) unsigned NOT NULL, PRIMARY KEY (`idbasic_stats`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `sakai`.`buglist` ( `LongMessage` varchar(500) default NULL, `shortMessage` varchar(200) default NULL, `priority` int(2) default NULL, `abbrev` varchar(40) default NULL, `uid` varchar(50) NOT NULL, `type` varchar(80) NOT NULL, `category` varchar(20) default NULL, PRIMARY KEY (`uid`), UNIQUE KEY `id` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `sakai`.`fact_description` ( `fid` int(10) unsigned NOT NULL, `name` varchar(45) NOT NULL, `description` varchar(255) NOT NULL, PRIMARY KEY (`fid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `sakai`.`facts` ( `id` int(10) unsigned NOT NULL auto_increment, `fid` int(10) unsigned NOT NULL, `run_no` int(10) unsigned NOT NULL, `project` varchar(255) default NULL, `class` varchar(255) default NULL, `total` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `sakai`.`pmd` ( `source_id` varchar(10) NOT NULL, `id` mediumint(8) unsigned NOT NULL, `local_id` mediumint(8) unsigned NOT NULL, `package` varchar(250) NOT NULL, `file` varchar(250) NOT NULL, `priority` smallint(6) unsigned NOT NULL, `line` mediumint(8) unsigned NOT NULL, `description` varchar(250) NOT NULL, `ruleset` varchar(100) NOT NULL, `rule` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `sakai`.`projects` ( `source_id` varchar(10) NOT NULL, `project` varchar(100) NOT NULL, `package` varchar(250) NOT NULL, PRIMARY KEY (`package`), UNIQUE KEY `id` (`package`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `sakai`.`qjpro` ( `id` mediumint(8) unsigned NOT NULL, `source_id` varchar(10) NOT NULL, `class` varchar(250) NOT NULL, `line` mediumint(8) unsigned NOT NULL, `local_id` mediumint(8) unsigned NOT NULL, `quality` varchar(250) NOT NULL, `priority` smallint(6) unsigned NOT NULL, `details` varchar(250) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `sakai`.`run_info` ( `rid` int(10) unsigned NOT NULL, `tag` varchar(45) NOT NULL, `hasCompiled` tinyint(1) NOT NULL, `started` datetime NOT NULL, `size_db` bigint(20) default NULL, PRIMARY KEY (`rid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `sakai`.`source` ( `source_id` varchar(10) NOT NULL, `description` varchar(250) NOT NULL, PRIMARY KEY (`source_id`), UNIQUE KEY `id` (`source_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1