Database table structure

Owned by Former user (Deleted)
Last updated: Oct 20, 2006Version comment
2 min read

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