From: Petr Pícha <ppicha@xxxxxxxxxxx>
Layer "Bugtracking" in database model has a name not consistent with
its purpose. That is to store issutracking data generally, not
bugtracking data specifically. Rename to "Issuetracking" to better
describe the purpose of that part of the database.
Signed-off-by: Petr Pícha <ppicha@xxxxxxxxxxx>
Signed-off-by: Wolfgang Mauerer <wolfgang.mauerer@xxxxxxxxxxxxxxxxx>
---
datamodel/codeface.mwb | Bin 57596 -> 60510 bytes
datamodel/codeface_schema.sql | 632 +++++++++++++++++++++---------------------
2 files changed, 316 insertions(+), 316 deletions(-)
diff --git a/datamodel/codeface.mwb b/datamodel/codeface.mwb
index 9b728b1..bd5c01f 100644
Binary files a/datamodel/codeface.mwb and b/datamodel/codeface.mwb differ
diff --git a/datamodel/codeface_schema.sql b/datamodel/codeface_schema.sql
index 4b2d503..d32a139 100644
--- a/datamodel/codeface_schema.sql
+++ b/datamodel/codeface_schema.sql
@@ -1,5 +1,5 @@
-- MySQL Script generated by MySQL Workbench
--- Sun Jun 19 22:01:28 2016
+-- 11/28/16 15:52:22
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
@@ -24,14 +24,14 @@ USE `codeface` ;
DROP TABLE IF EXISTS `codeface`.`project` ;
CREATE TABLE IF NOT EXISTS `codeface`.`project` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `name` VARCHAR(255) NOT NULL COMMENT '',
- `analysisMethod` VARCHAR(45) NOT NULL COMMENT '',
- `analysisTime` DATETIME NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '')
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `name` VARCHAR(255) NOT NULL,
+ `analysisMethod` VARCHAR(45) NOT NULL,
+ `analysisTime` DATETIME NULL DEFAULT NULL,
+ PRIMARY KEY (`id`))
ENGINE = InnoDB;
-CREATE UNIQUE INDEX `name_UNIQUE` ON `codeface`.`project` (`name` ASC)
COMMENT '';
+CREATE UNIQUE INDEX `name_UNIQUE` ON `codeface`.`project` (`name` ASC);
-- -----------------------------------------------------
@@ -40,15 +40,15 @@ CREATE UNIQUE INDEX `name_UNIQUE` ON `codeface`.`project`
(`name` ASC) COMMENT
DROP TABLE IF EXISTS `codeface`.`person` ;
CREATE TABLE IF NOT EXISTS `codeface`.`person` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `name` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NULL
DEFAULT NULL COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `email1` VARCHAR(255) NOT NULL COMMENT '',
- `email2` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
- `email3` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
- `email4` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
- `email5` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `name` VARCHAR(255) CHARACTER SET 'utf8' NULL DEFAULT NULL,
+ `projectId` BIGINT NOT NULL,
+ `email1` VARCHAR(255) NOT NULL,
+ `email2` VARCHAR(255) NULL DEFAULT NULL,
+ `email3` VARCHAR(255) NULL DEFAULT NULL,
+ `email4` VARCHAR(255) NULL DEFAULT NULL,
+ `email5` VARCHAR(255) NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `person_projectId`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -56,9 +56,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`person` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `person_projectId_idx` ON `codeface`.`person` (`projectId` ASC)
COMMENT '';
+CREATE INDEX `person_projectId_idx` ON `codeface`.`person` (`projectId` ASC);
-CREATE UNIQUE INDEX `person_email_project_idx` ON `codeface`.`person`
(`projectId` ASC, `email1` ASC) COMMENT '';
+CREATE UNIQUE INDEX `person_email_project_idx` ON `codeface`.`person`
(`projectId` ASC, `email1` ASC);
-- -----------------------------------------------------
@@ -67,23 +67,23 @@ CREATE UNIQUE INDEX `person_email_project_idx` ON
`codeface`.`person` (`projectI
DROP TABLE IF EXISTS `codeface`.`issue` ;
CREATE TABLE IF NOT EXISTS `codeface`.`issue` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `bugId` VARCHAR(45) NOT NULL COMMENT '',
- `creationDate` DATETIME NOT NULL COMMENT '',
- `modifiedDate` DATETIME NULL DEFAULT NULL COMMENT '',
- `url` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
- `isRegression` INT(1) NULL DEFAULT 0 COMMENT '',
- `status` VARCHAR(45) NOT NULL COMMENT '',
- `resolution` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- `priority` VARCHAR(45) NOT NULL COMMENT '',
- `severity` VARCHAR(45) NOT NULL COMMENT '',
- `createdBy` BIGINT NOT NULL COMMENT '',
- `assignedTo` BIGINT NULL DEFAULT NULL COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `subComponent` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- `subSubComponent` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- `version` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `bugId` VARCHAR(45) NOT NULL,
+ `creationDate` DATETIME NOT NULL,
+ `modifiedDate` DATETIME NULL DEFAULT NULL,
+ `url` VARCHAR(255) NULL DEFAULT NULL,
+ `isRegression` INT(1) NULL DEFAULT 0,
+ `status` VARCHAR(45) NOT NULL,
+ `resolution` VARCHAR(45) NULL DEFAULT NULL,
+ `priority` VARCHAR(45) NOT NULL,
+ `severity` VARCHAR(45) NOT NULL,
+ `createdBy` BIGINT NOT NULL,
+ `assignedTo` BIGINT NULL DEFAULT NULL,
+ `projectId` BIGINT NOT NULL,
+ `subComponent` VARCHAR(45) NULL DEFAULT NULL,
+ `subSubComponent` VARCHAR(45) NULL DEFAULT NULL,
+ `version` VARCHAR(45) NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `issue_createdBy`
FOREIGN KEY (`createdBy`)
REFERENCES `codeface`.`person` (`id`)
@@ -101,13 +101,13 @@ CREATE TABLE IF NOT EXISTS `codeface`.`issue` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `issue_createdBy_idx` ON `codeface`.`issue` (`createdBy` ASC)
COMMENT '';
+CREATE INDEX `issue_createdBy_idx` ON `codeface`.`issue` (`createdBy` ASC);
-CREATE INDEX `issue_assignedTo_idx` ON `codeface`.`issue` (`assignedTo` ASC)
COMMENT '';
+CREATE INDEX `issue_assignedTo_idx` ON `codeface`.`issue` (`assignedTo` ASC);
-CREATE INDEX `issue_projectId_idx` ON `codeface`.`issue` (`projectId` ASC)
COMMENT '';
+CREATE INDEX `issue_projectId_idx` ON `codeface`.`issue` (`projectId` ASC);
-CREATE UNIQUE INDEX `bugId_UNIQUE` ON `codeface`.`issue` (`bugId` ASC)
COMMENT '';
+CREATE UNIQUE INDEX `bugId_UNIQUE` ON `codeface`.`issue` (`bugId` ASC);
-- -----------------------------------------------------
@@ -116,11 +116,11 @@ CREATE UNIQUE INDEX `bugId_UNIQUE` ON `codeface`.`issue`
(`bugId` ASC) COMMENT
DROP TABLE IF EXISTS `codeface`.`issue_comment` ;
CREATE TABLE IF NOT EXISTS `codeface`.`issue_comment` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `who` BIGINT NOT NULL COMMENT '',
- `fk_issueId` BIGINT NOT NULL COMMENT '',
- `commentDate` DATETIME NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `who` BIGINT NOT NULL,
+ `fk_issueId` BIGINT NOT NULL,
+ `commentDate` DATETIME NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `fk_issueId`
FOREIGN KEY (`fk_issueId`)
REFERENCES `codeface`.`issue` (`id`)
@@ -133,9 +133,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`issue_comment` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `fk_issueId_idx` ON `codeface`.`issue_comment` (`fk_issueId` ASC)
COMMENT '';
+CREATE INDEX `fk_issueId_idx` ON `codeface`.`issue_comment` (`fk_issueId` ASC);
-CREATE INDEX `issue_comment_who_idx` ON `codeface`.`issue_comment` (`who` ASC)
COMMENT '';
+CREATE INDEX `issue_comment_who_idx` ON `codeface`.`issue_comment` (`who` ASC);
-- -----------------------------------------------------
@@ -144,12 +144,12 @@ CREATE INDEX `issue_comment_who_idx` ON
`codeface`.`issue_comment` (`who` ASC)
DROP TABLE IF EXISTS `codeface`.`release_timeline` ;
CREATE TABLE IF NOT EXISTS `codeface`.`release_timeline` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `type` VARCHAR(45) NOT NULL COMMENT '',
- `tag` VARCHAR(45) NOT NULL COMMENT '',
- `date` DATETIME NULL DEFAULT NULL COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `type` VARCHAR(45) NOT NULL,
+ `tag` VARCHAR(45) NOT NULL,
+ `date` DATETIME NULL DEFAULT NULL,
+ `projectId` BIGINT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `release_project_ref`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -157,7 +157,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`release_timeline` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `release_project_ref_idx` ON `codeface`.`release_timeline`
(`projectId` ASC) COMMENT '';
+CREATE INDEX `release_project_ref_idx` ON `codeface`.`release_timeline`
(`projectId` ASC);
-- -----------------------------------------------------
@@ -166,12 +166,12 @@ CREATE INDEX `release_project_ref_idx` ON
`codeface`.`release_timeline` (`projec
DROP TABLE IF EXISTS `codeface`.`release_range` ;
CREATE TABLE IF NOT EXISTS `codeface`.`release_range` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `releaseStartId` BIGINT NOT NULL COMMENT '',
- `releaseEndId` BIGINT NOT NULL COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `releaseRCStartId` BIGINT NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `releaseStartId` BIGINT NOT NULL,
+ `releaseEndId` BIGINT NOT NULL,
+ `projectId` BIGINT NOT NULL,
+ `releaseRCStartId` BIGINT NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `releaseRange_releaseStartId`
FOREIGN KEY (`releaseStartId`)
REFERENCES `codeface`.`release_timeline` (`id`)
@@ -194,13 +194,13 @@ CREATE TABLE IF NOT EXISTS `codeface`.`release_range` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `releaseRange_releaseStartId_idx` ON `codeface`.`release_range`
(`releaseStartId` ASC) COMMENT '';
+CREATE INDEX `releaseRange_releaseStartId_idx` ON `codeface`.`release_range`
(`releaseStartId` ASC);
-CREATE INDEX `releaseRange_releaseEndId_idx` ON `codeface`.`release_range`
(`releaseEndId` ASC) COMMENT '';
+CREATE INDEX `releaseRange_releaseEndId_idx` ON `codeface`.`release_range`
(`releaseEndId` ASC);
-CREATE INDEX `releaseRange_projectId_idx` ON `codeface`.`release_range`
(`projectId` ASC) COMMENT '';
+CREATE INDEX `releaseRange_projectId_idx` ON `codeface`.`release_range`
(`projectId` ASC);
-CREATE INDEX `releaseRange_RCStartId_idx` ON `codeface`.`release_range`
(`releaseRCStartId` ASC) COMMENT '';
+CREATE INDEX `releaseRange_RCStartId_idx` ON `codeface`.`release_range`
(`releaseRCStartId` ASC);
-- -----------------------------------------------------
@@ -209,11 +209,11 @@ CREATE INDEX `releaseRange_RCStartId_idx` ON
`codeface`.`release_range` (`releas
DROP TABLE IF EXISTS `codeface`.`mailing_list` ;
CREATE TABLE IF NOT EXISTS `codeface`.`mailing_list` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `name` VARCHAR(128) NOT NULL COMMENT '',
- `description` VARCHAR(255) NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `projectId` BIGINT NOT NULL,
+ `name` VARCHAR(128) NOT NULL,
+ `description` VARCHAR(255) NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `mailing_lists_projectid`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -221,7 +221,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`mailing_list` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `mailing_lists_projectid_idx` ON `codeface`.`mailing_list`
(`projectId` ASC) COMMENT '';
+CREATE INDEX `mailing_lists_projectid_idx` ON `codeface`.`mailing_list`
(`projectId` ASC);
-- -----------------------------------------------------
@@ -230,17 +230,17 @@ CREATE INDEX `mailing_lists_projectid_idx` ON
`codeface`.`mailing_list` (`projec
DROP TABLE IF EXISTS `codeface`.`mail_thread` ;
CREATE TABLE IF NOT EXISTS `codeface`.`mail_thread` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `subject` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
- `createdBy` BIGINT NULL DEFAULT NULL COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `mlId` BIGINT NOT NULL COMMENT '',
- `mailThreadId` BIGINT NOT NULL COMMENT '',
- `creationDate` DATETIME NULL DEFAULT NULL COMMENT '',
- `numberOfAuthors` INT NOT NULL COMMENT '',
- `numberOfMessages` INT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `subject` VARCHAR(255) NULL DEFAULT NULL,
+ `createdBy` BIGINT NULL DEFAULT NULL,
+ `projectId` BIGINT NOT NULL,
+ `releaseRangeId` BIGINT NOT NULL,
+ `mlId` BIGINT NOT NULL,
+ `mailThreadId` BIGINT NOT NULL,
+ `creationDate` DATETIME NULL DEFAULT NULL,
+ `numberOfAuthors` INT NOT NULL,
+ `numberOfMessages` INT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `thread_createdBy`
FOREIGN KEY (`createdBy`)
REFERENCES `codeface`.`person` (`id`)
@@ -263,13 +263,13 @@ CREATE TABLE IF NOT EXISTS `codeface`.`mail_thread` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `mail_createdBy_idx` ON `codeface`.`mail_thread` (`createdBy`
ASC) COMMENT '';
+CREATE INDEX `mail_createdBy_idx` ON `codeface`.`mail_thread` (`createdBy`
ASC);
-CREATE INDEX `mail_projectId_idx` ON `codeface`.`mail_thread` (`projectId`
ASC) COMMENT '';
+CREATE INDEX `mail_projectId_idx` ON `codeface`.`mail_thread` (`projectId`
ASC);
-CREATE INDEX `mail_release_range_key_idx` ON `codeface`.`mail_thread`
(`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `mail_release_range_key_idx` ON `codeface`.`mail_thread`
(`releaseRangeId` ASC);
-CREATE INDEX `mail_mlId_idx` ON `codeface`.`mail_thread` (`mlId` ASC) COMMENT
'';
+CREATE INDEX `mail_mlId_idx` ON `codeface`.`mail_thread` (`mlId` ASC);
-- -----------------------------------------------------
@@ -278,9 +278,9 @@ CREATE INDEX `mail_mlId_idx` ON `codeface`.`mail_thread`
(`mlId` ASC) COMMENT '
DROP TABLE IF EXISTS `codeface`.`thread_responses` ;
CREATE TABLE IF NOT EXISTS `codeface`.`thread_responses` (
- `who` BIGINT NOT NULL COMMENT '',
- `mailThreadId` BIGINT NOT NULL COMMENT '',
- `mailDate` DATETIME NULL DEFAULT NULL COMMENT '',
+ `who` BIGINT NOT NULL,
+ `mailThreadId` BIGINT NOT NULL,
+ `mailDate` DATETIME NULL DEFAULT NULL,
CONSTRAINT `thread_responses_who`
FOREIGN KEY (`who`)
REFERENCES `codeface`.`person` (`id`)
@@ -293,9 +293,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`thread_responses` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `thread_responses_who_idx` ON `codeface`.`thread_responses`
(`who` ASC) COMMENT '';
+CREATE INDEX `thread_responses_who_idx` ON `codeface`.`thread_responses`
(`who` ASC);
-CREATE INDEX `mailThreadId_idx` ON `codeface`.`thread_responses`
(`mailThreadId` ASC) COMMENT '';
+CREATE INDEX `mailThreadId_idx` ON `codeface`.`thread_responses`
(`mailThreadId` ASC);
-- -----------------------------------------------------
@@ -304,8 +304,8 @@ CREATE INDEX `mailThreadId_idx` ON
`codeface`.`thread_responses` (`mailThreadId`
DROP TABLE IF EXISTS `codeface`.`cc_list` ;
CREATE TABLE IF NOT EXISTS `codeface`.`cc_list` (
- `issueId` BIGINT NOT NULL COMMENT '',
- `who` BIGINT NOT NULL COMMENT '',
+ `issueId` BIGINT NOT NULL,
+ `who` BIGINT NOT NULL,
CONSTRAINT `cclist_issueId`
FOREIGN KEY (`issueId`)
REFERENCES `codeface`.`issue` (`id`)
@@ -318,9 +318,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`cc_list` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `cclist_issueId_idx` ON `codeface`.`cc_list` (`issueId` ASC)
COMMENT '';
+CREATE INDEX `cclist_issueId_idx` ON `codeface`.`cc_list` (`issueId` ASC);
-CREATE INDEX `cclist_who_idx` ON `codeface`.`cc_list` (`who` ASC) COMMENT '';
+CREATE INDEX `cclist_who_idx` ON `codeface`.`cc_list` (`who` ASC);
-- -----------------------------------------------------
@@ -329,33 +329,33 @@ CREATE INDEX `cclist_who_idx` ON `codeface`.`cc_list`
(`who` ASC) COMMENT '';
DROP TABLE IF EXISTS `codeface`.`commit` ;
CREATE TABLE IF NOT EXISTS `codeface`.`commit` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `commitHash` VARCHAR(255) NOT NULL COMMENT '',
- `commitDate` DATETIME NOT NULL COMMENT '',
- `authorDate` DATETIME NOT NULL COMMENT '',
- `authorTimeOffset` INT NULL DEFAULT NULL COMMENT '',
- `authorTimezones` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
- `author` BIGINT NOT NULL COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `ChangedFiles` INT NULL DEFAULT NULL COMMENT '',
- `AddedLines` INT NULL DEFAULT NULL COMMENT '',
- `DeletedLines` INT NULL DEFAULT NULL COMMENT '',
- `DiffSize` INT NULL DEFAULT NULL COMMENT '',
- `CmtMsgLines` INT NULL DEFAULT NULL COMMENT '',
- `CmtMsgBytes` INT NULL DEFAULT NULL COMMENT '',
- `NumSignedOffs` INT NULL DEFAULT NULL COMMENT '',
- `NumTags` INT NULL DEFAULT NULL COMMENT '',
- `general` INT NULL DEFAULT NULL COMMENT '',
- `TotalSubsys` INT NULL DEFAULT NULL COMMENT '',
- `Subsys` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- `inRC` INT NULL DEFAULT NULL COMMENT '',
- `AuthorSubsysSimilarity` FLOAT NULL DEFAULT NULL COMMENT '',
- `AuthorTaggersSimilarity` FLOAT NULL DEFAULT NULL COMMENT '',
- `TaggersSubsysSimilarity` FLOAT NULL DEFAULT NULL COMMENT '',
- `releaseRangeId` BIGINT NULL DEFAULT NULL COMMENT '',
- `description` TEXT NULL COMMENT '',
- `corrective` TINYINT(1) NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `commitHash` VARCHAR(255) NOT NULL,
+ `commitDate` DATETIME NOT NULL,
+ `authorDate` DATETIME NOT NULL,
+ `authorTimeOffset` INT NULL DEFAULT NULL,
+ `authorTimezones` VARCHAR(255) NULL DEFAULT NULL,
+ `author` BIGINT NOT NULL,
+ `projectId` BIGINT NOT NULL,
+ `ChangedFiles` INT NULL DEFAULT NULL,
+ `AddedLines` INT NULL DEFAULT NULL,
+ `DeletedLines` INT NULL DEFAULT NULL,
+ `DiffSize` INT NULL DEFAULT NULL,
+ `CmtMsgLines` INT NULL DEFAULT NULL,
+ `CmtMsgBytes` INT NULL DEFAULT NULL,
+ `NumSignedOffs` INT NULL DEFAULT NULL,
+ `NumTags` INT NULL DEFAULT NULL,
+ `general` INT NULL DEFAULT NULL,
+ `TotalSubsys` INT NULL DEFAULT NULL,
+ `Subsys` VARCHAR(45) NULL DEFAULT NULL,
+ `inRC` INT NULL DEFAULT NULL,
+ `AuthorSubsysSimilarity` FLOAT NULL DEFAULT NULL,
+ `AuthorTaggersSimilarity` FLOAT NULL DEFAULT NULL,
+ `TaggersSubsysSimilarity` FLOAT NULL DEFAULT NULL,
+ `releaseRangeId` BIGINT NULL DEFAULT NULL,
+ `description` TEXT NULL,
+ `corrective` TINYINT(1) NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `commit_person`
FOREIGN KEY (`author`)
REFERENCES `codeface`.`person` (`id`)
@@ -373,11 +373,11 @@ CREATE TABLE IF NOT EXISTS `codeface`.`commit` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `commit_person_idx` ON `codeface`.`commit` (`author` ASC)
COMMENT '';
+CREATE INDEX `commit_person_idx` ON `codeface`.`commit` (`author` ASC);
-CREATE INDEX `commit_project_idx` ON `codeface`.`commit` (`projectId` ASC)
COMMENT '';
+CREATE INDEX `commit_project_idx` ON `codeface`.`commit` (`projectId` ASC);
-CREATE INDEX `commit_release_end_idx` ON `codeface`.`commit` (`releaseRangeId`
ASC) COMMENT '';
+CREATE INDEX `commit_release_end_idx` ON `codeface`.`commit` (`releaseRangeId`
ASC);
-- -----------------------------------------------------
@@ -386,11 +386,11 @@ CREATE INDEX `commit_release_end_idx` ON
`codeface`.`commit` (`releaseRangeId` A
DROP TABLE IF EXISTS `codeface`.`commit_communication` ;
CREATE TABLE IF NOT EXISTS `codeface`.`commit_communication` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `commitId` BIGINT NOT NULL COMMENT '',
- `who` BIGINT NOT NULL COMMENT '',
- `communicationType` INT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `commitId` BIGINT NOT NULL,
+ `who` BIGINT NOT NULL,
+ `communicationType` INT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `commitcom_commit`
FOREIGN KEY (`commitId`)
REFERENCES `codeface`.`commit` (`id`)
@@ -403,9 +403,9 @@ CREATE TABLE IF NOT EXISTS
`codeface`.`commit_communication` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `commtcom_commit_idx` ON `codeface`.`commit_communication`
(`commitId` ASC) COMMENT '';
+CREATE INDEX `commtcom_commit_idx` ON `codeface`.`commit_communication`
(`commitId` ASC);
-CREATE INDEX `commitcom_person_idx` ON `codeface`.`commit_communication`
(`who` ASC) COMMENT '';
+CREATE INDEX `commitcom_person_idx` ON `codeface`.`commit_communication`
(`who` ASC);
-- -----------------------------------------------------
@@ -414,10 +414,10 @@ CREATE INDEX `commitcom_person_idx` ON
`codeface`.`commit_communication` (`who`
DROP TABLE IF EXISTS `codeface`.`issue_duplicates` ;
CREATE TABLE IF NOT EXISTS `codeface`.`issue_duplicates` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `originalBugId` BIGINT NOT NULL COMMENT '',
- `duplicateBugId` BIGINT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `originalBugId` BIGINT NOT NULL,
+ `duplicateBugId` BIGINT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `original_issue_duplicate`
FOREIGN KEY (`originalBugId`)
REFERENCES `codeface`.`issue` (`id`)
@@ -430,9 +430,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`issue_duplicates` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `original_issue_duplicate_idx` ON `codeface`.`issue_duplicates`
(`originalBugId` ASC) COMMENT '';
+CREATE INDEX `original_issue_duplicate_idx` ON `codeface`.`issue_duplicates`
(`originalBugId` ASC);
-CREATE INDEX `duplicate_issue_duplicate_idx` ON `codeface`.`issue_duplicates`
(`duplicateBugId` ASC) COMMENT '';
+CREATE INDEX `duplicate_issue_duplicate_idx` ON `codeface`.`issue_duplicates`
(`duplicateBugId` ASC);
-- -----------------------------------------------------
@@ -441,10 +441,10 @@ CREATE INDEX `duplicate_issue_duplicate_idx` ON
`codeface`.`issue_duplicates` (`
DROP TABLE IF EXISTS `codeface`.`issue_dependencies` ;
CREATE TABLE IF NOT EXISTS `codeface`.`issue_dependencies` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `originalIssueId` BIGINT NOT NULL COMMENT '',
- `dependentIssueId` BIGINT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `originalIssueId` BIGINT NOT NULL,
+ `dependentIssueId` BIGINT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `dependent_original_issue`
FOREIGN KEY (`originalIssueId`)
REFERENCES `codeface`.`issue` (`id`)
@@ -457,9 +457,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`issue_dependencies` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `dependent_original_issue_idx` ON `codeface`.`issue_dependencies`
(`originalIssueId` ASC) COMMENT '';
+CREATE INDEX `dependent_original_issue_idx` ON `codeface`.`issue_dependencies`
(`originalIssueId` ASC);
-CREATE INDEX `dependent_dependent_issue_idx` ON
`codeface`.`issue_dependencies` (`dependentIssueId` ASC) COMMENT '';
+CREATE INDEX `dependent_dependent_issue_idx` ON
`codeface`.`issue_dependencies` (`dependentIssueId` ASC);
-- -----------------------------------------------------
@@ -468,14 +468,14 @@ CREATE INDEX `dependent_dependent_issue_idx` ON
`codeface`.`issue_dependencies`
DROP TABLE IF EXISTS `codeface`.`author_commit_stats` ;
CREATE TABLE IF NOT EXISTS `codeface`.`author_commit_stats` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `authorId` BIGINT NOT NULL COMMENT '',
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `added` INT NULL DEFAULT NULL COMMENT '',
- `deleted` INT NULL DEFAULT NULL COMMENT '',
- `total` INT NULL DEFAULT NULL COMMENT '',
- `numcommits` INT NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `authorId` BIGINT NOT NULL,
+ `releaseRangeId` BIGINT NOT NULL,
+ `added` INT NULL DEFAULT NULL,
+ `deleted` INT NULL DEFAULT NULL,
+ `total` INT NULL DEFAULT NULL,
+ `numcommits` INT NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `author_person_key`
FOREIGN KEY (`authorId`)
REFERENCES `codeface`.`person` (`id`)
@@ -488,9 +488,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`author_commit_stats`
(
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `author_person_key_idx` ON `codeface`.`author_commit_stats`
(`authorId` ASC) COMMENT '';
+CREATE INDEX `author_person_key_idx` ON `codeface`.`author_commit_stats`
(`authorId` ASC);
-CREATE INDEX `releaseRangeId_key_idx` ON `codeface`.`author_commit_stats`
(`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `releaseRangeId_key_idx` ON `codeface`.`author_commit_stats`
(`releaseRangeId` ASC);
-- -----------------------------------------------------
@@ -499,13 +499,13 @@ CREATE INDEX `releaseRangeId_key_idx` ON
`codeface`.`author_commit_stats` (`rele
DROP TABLE IF EXISTS `codeface`.`plots` ;
CREATE TABLE IF NOT EXISTS `codeface`.`plots` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `name` VARCHAR(45) NOT NULL COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `releaseRangeId` BIGINT NULL DEFAULT NULL COMMENT '',
- `labelx` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- `labely` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `name` VARCHAR(45) NOT NULL,
+ `projectId` BIGINT NOT NULL,
+ `releaseRangeId` BIGINT NULL DEFAULT NULL,
+ `labelx` VARCHAR(45) NULL DEFAULT NULL,
+ `labely` VARCHAR(45) NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `plot_project_ref`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -518,9 +518,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`plots` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `plot_project_ref_idx` ON `codeface`.`plots` (`projectId` ASC)
COMMENT '';
+CREATE INDEX `plot_project_ref_idx` ON `codeface`.`plots` (`projectId` ASC);
-CREATE INDEX `plot_releaseRangeId_ref_idx` ON `codeface`.`plots`
(`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `plot_releaseRangeId_ref_idx` ON `codeface`.`plots`
(`releaseRangeId` ASC);
-- -----------------------------------------------------
@@ -529,9 +529,9 @@ CREATE INDEX `plot_releaseRangeId_ref_idx` ON
`codeface`.`plots` (`releaseRangeI
DROP TABLE IF EXISTS `codeface`.`plot_bin` ;
CREATE TABLE IF NOT EXISTS `codeface`.`plot_bin` (
- `plotID` BIGINT NOT NULL COMMENT '',
- `type` VARCHAR(45) NOT NULL COMMENT '',
- `data` LONGBLOB NOT NULL COMMENT '',
+ `plotID` BIGINT NOT NULL,
+ `type` VARCHAR(45) NOT NULL,
+ `data` LONGBLOB NOT NULL,
CONSTRAINT `plot_bin_plot_ref`
FOREIGN KEY (`plotID`)
REFERENCES `codeface`.`plots` (`id`)
@@ -539,7 +539,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`plot_bin` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `plot_bin_plot_ref_idx` ON `codeface`.`plot_bin` (`plotID` ASC)
COMMENT '';
+CREATE INDEX `plot_bin_plot_ref_idx` ON `codeface`.`plot_bin` (`plotID` ASC);
-- -----------------------------------------------------
@@ -548,14 +548,14 @@ CREATE INDEX `plot_bin_plot_ref_idx` ON
`codeface`.`plot_bin` (`plotID` ASC) CO
DROP TABLE IF EXISTS `codeface`.`cluster` ;
CREATE TABLE IF NOT EXISTS `codeface`.`cluster` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `clusterNumber` INT NULL DEFAULT NULL COMMENT '',
- `clusterMethod` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- `dot` BIGINT NULL DEFAULT NULL COMMENT '',
- `svg` BIGINT NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `projectId` BIGINT NOT NULL,
+ `releaseRangeId` BIGINT NOT NULL,
+ `clusterNumber` INT NULL DEFAULT NULL,
+ `clusterMethod` VARCHAR(45) NULL DEFAULT NULL,
+ `dot` BIGINT NULL DEFAULT NULL,
+ `svg` BIGINT NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `project_cluster_ref`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -578,13 +578,13 @@ CREATE TABLE IF NOT EXISTS `codeface`.`cluster` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `project_cluster_ref_idx` ON `codeface`.`cluster` (`projectId`
ASC) COMMENT '';
+CREATE INDEX `project_cluster_ref_idx` ON `codeface`.`cluster` (`projectId`
ASC);
-CREATE INDEX `dot_plot_bin_data_idx` ON `codeface`.`cluster` (`dot` ASC)
COMMENT '';
+CREATE INDEX `dot_plot_bin_data_idx` ON `codeface`.`cluster` (`dot` ASC);
-CREATE INDEX `svg_plot_bin_data_ref_idx` ON `codeface`.`cluster` (`svg` ASC)
COMMENT '';
+CREATE INDEX `svg_plot_bin_data_ref_idx` ON `codeface`.`cluster` (`svg` ASC);
-CREATE INDEX `cluster_releaseRange_idx` ON `codeface`.`cluster`
(`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `cluster_releaseRange_idx` ON `codeface`.`cluster`
(`releaseRangeId` ASC);
-- -----------------------------------------------------
@@ -593,10 +593,10 @@ CREATE INDEX `cluster_releaseRange_idx` ON
`codeface`.`cluster` (`releaseRangeId
DROP TABLE IF EXISTS `codeface`.`cluster_user_mapping` ;
CREATE TABLE IF NOT EXISTS `codeface`.`cluster_user_mapping` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `personId` BIGINT NOT NULL COMMENT '',
- `clusterId` BIGINT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `personId` BIGINT NOT NULL,
+ `clusterId` BIGINT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `cluster_cluster_user_ref`
FOREIGN KEY (`clusterId`)
REFERENCES `codeface`.`cluster` (`id`)
@@ -609,9 +609,9 @@ CREATE TABLE IF NOT EXISTS
`codeface`.`cluster_user_mapping` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `cluster_cluster_user_ref_idx` ON
`codeface`.`cluster_user_mapping` (`clusterId` ASC) COMMENT '';
+CREATE INDEX `cluster_cluster_user_ref_idx` ON
`codeface`.`cluster_user_mapping` (`clusterId` ASC);
-CREATE INDEX `person_cluster_user_ref_idx` ON
`codeface`.`cluster_user_mapping` (`personId` ASC) COMMENT '';
+CREATE INDEX `person_cluster_user_ref_idx` ON
`codeface`.`cluster_user_mapping` (`personId` ASC);
-- -----------------------------------------------------
@@ -620,14 +620,14 @@ CREATE INDEX `person_cluster_user_ref_idx` ON
`codeface`.`cluster_user_mapping`
DROP TABLE IF EXISTS `codeface`.`issue_history` ;
CREATE TABLE IF NOT EXISTS `codeface`.`issue_history` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `changeDate` DATETIME NOT NULL COMMENT '',
- `field` VARCHAR(45) NOT NULL COMMENT '',
- `oldValue` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- `newValue` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- `who` BIGINT NOT NULL COMMENT '',
- `issueId` BIGINT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `changeDate` DATETIME NOT NULL,
+ `field` VARCHAR(45) NOT NULL,
+ `oldValue` VARCHAR(45) NULL DEFAULT NULL,
+ `newValue` VARCHAR(45) NULL DEFAULT NULL,
+ `who` BIGINT NOT NULL,
+ `issueId` BIGINT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `issue_history_issue_map`
FOREIGN KEY (`issueId`)
REFERENCES `codeface`.`issue` (`id`)
@@ -640,9 +640,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`issue_history` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `issue_history_issue_map_idx` ON `codeface`.`issue_history`
(`issueId` ASC) COMMENT '';
+CREATE INDEX `issue_history_issue_map_idx` ON `codeface`.`issue_history`
(`issueId` ASC);
-CREATE INDEX `issue_history_person_map_idx` ON `codeface`.`issue_history`
(`who` ASC) COMMENT '';
+CREATE INDEX `issue_history_person_map_idx` ON `codeface`.`issue_history`
(`who` ASC);
-- -----------------------------------------------------
@@ -651,11 +651,11 @@ CREATE INDEX `issue_history_person_map_idx` ON
`codeface`.`issue_history` (`who`
DROP TABLE IF EXISTS `codeface`.`url_info` ;
CREATE TABLE IF NOT EXISTS `codeface`.`url_info` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `type` VARCHAR(45) NOT NULL COMMENT '',
- `url` TEXT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `projectId` BIGINT NOT NULL,
+ `type` VARCHAR(45) NOT NULL,
+ `url` TEXT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `url_info_project`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -663,7 +663,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`url_info` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `url_info_project_idx` ON `codeface`.`url_info` (`projectId` ASC)
COMMENT '';
+CREATE INDEX `url_info_project_idx` ON `codeface`.`url_info` (`projectId` ASC);
-- -----------------------------------------------------
@@ -672,10 +672,10 @@ CREATE INDEX `url_info_project_idx` ON
`codeface`.`url_info` (`projectId` ASC)
DROP TABLE IF EXISTS `codeface`.`timeseries` ;
CREATE TABLE IF NOT EXISTS `codeface`.`timeseries` (
- `plotId` BIGINT NOT NULL COMMENT '',
- `time` DATETIME NOT NULL COMMENT '',
- `value` DOUBLE NOT NULL COMMENT '',
- `value_scaled` DOUBLE NULL DEFAULT NULL COMMENT '',
+ `plotId` BIGINT NOT NULL,
+ `time` DATETIME NOT NULL,
+ `value` DOUBLE NOT NULL,
+ `value_scaled` DOUBLE NULL DEFAULT NULL,
CONSTRAINT `plot_time_double_plot_ref`
FOREIGN KEY (`plotId`)
REFERENCES `codeface`.`plots` (`id`)
@@ -683,7 +683,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`timeseries` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `plot_time_double_plot_ref_idx` ON `codeface`.`timeseries`
(`plotId` ASC) COMMENT '';
+CREATE INDEX `plot_time_double_plot_ref_idx` ON `codeface`.`timeseries`
(`plotId` ASC);
-- -----------------------------------------------------
@@ -692,13 +692,13 @@ CREATE INDEX `plot_time_double_plot_ref_idx` ON
`codeface`.`timeseries` (`plotId
DROP TABLE IF EXISTS `codeface`.`freq_subjects` ;
CREATE TABLE IF NOT EXISTS `codeface`.`freq_subjects` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `mlId` BIGINT NOT NULL COMMENT '',
- `subject` TEXT NOT NULL COMMENT '',
- `count` INT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `projectId` BIGINT NOT NULL,
+ `releaseRangeId` BIGINT NOT NULL,
+ `mlId` BIGINT NOT NULL,
+ `subject` TEXT NOT NULL,
+ `count` INT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `freq_subects_project_ref`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -716,11 +716,11 @@ CREATE TABLE IF NOT EXISTS `codeface`.`freq_subjects` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `freq_subects_project_ref_idx` ON `codeface`.`freq_subjects`
(`projectId` ASC) COMMENT '';
+CREATE INDEX `freq_subects_project_ref_idx` ON `codeface`.`freq_subjects`
(`projectId` ASC);
-CREATE INDEX `freq_subjects_release_range_ref_idx` ON
`codeface`.`freq_subjects` (`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `freq_subjects_release_range_ref_idx` ON
`codeface`.`freq_subjects` (`releaseRangeId` ASC);
-CREATE INDEX `freq_subjects_mlId_ref_idx` ON `codeface`.`freq_subjects`
(`mlId` ASC) COMMENT '';
+CREATE INDEX `freq_subjects_mlId_ref_idx` ON `codeface`.`freq_subjects`
(`mlId` ASC);
-- -----------------------------------------------------
@@ -729,12 +729,12 @@ CREATE INDEX `freq_subjects_mlId_ref_idx` ON
`codeface`.`freq_subjects` (`mlId`
DROP TABLE IF EXISTS `codeface`.`thread_density` ;
CREATE TABLE IF NOT EXISTS `codeface`.`thread_density` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `num` DOUBLE NOT NULL COMMENT '',
- `density` DOUBLE NOT NULL COMMENT '',
- `type` VARCHAR(45) NOT NULL COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `num` DOUBLE NOT NULL,
+ `density` DOUBLE NOT NULL,
+ `type` VARCHAR(45) NOT NULL,
+ `projectId` BIGINT NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `project_thread_density_ref`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -742,7 +742,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`thread_density` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `project_thread_density_ref_idx` ON `codeface`.`thread_density`
(`projectId` ASC) COMMENT '';
+CREATE INDEX `project_thread_density_ref_idx` ON `codeface`.`thread_density`
(`projectId` ASC);
-- -----------------------------------------------------
@@ -751,11 +751,11 @@ CREATE INDEX `project_thread_density_ref_idx` ON
`codeface`.`thread_density` (`p
DROP TABLE IF EXISTS `codeface`.`pagerank` ;
CREATE TABLE IF NOT EXISTS `codeface`.`pagerank` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `technique` TINYINT NOT NULL COMMENT '',
- `name` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `releaseRangeId` BIGINT NOT NULL,
+ `technique` TINYINT NOT NULL,
+ `name` VARCHAR(45) NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `pagerank_releaserange`
FOREIGN KEY (`releaseRangeId`)
REFERENCES `codeface`.`release_range` (`id`)
@@ -763,7 +763,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`pagerank` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `pagerank_releaserange_idx` ON `codeface`.`pagerank`
(`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `pagerank_releaserange_idx` ON `codeface`.`pagerank`
(`releaseRangeId` ASC);
-- -----------------------------------------------------
@@ -772,10 +772,10 @@ CREATE INDEX `pagerank_releaserange_idx` ON
`codeface`.`pagerank` (`releaseRange
DROP TABLE IF EXISTS `codeface`.`pagerank_matrix` ;
CREATE TABLE IF NOT EXISTS `codeface`.`pagerank_matrix` (
- `pageRankId` BIGINT NOT NULL COMMENT '',
- `personId` BIGINT NOT NULL COMMENT '',
- `rankValue` DOUBLE NOT NULL COMMENT '',
- PRIMARY KEY (`pageRankId`, `personId`) COMMENT '',
+ `pageRankId` BIGINT NOT NULL,
+ `personId` BIGINT NOT NULL,
+ `rankValue` DOUBLE NOT NULL,
+ PRIMARY KEY (`pageRankId`, `personId`),
CONSTRAINT `pagerankMatrix_pagerank`
FOREIGN KEY (`pageRankId`)
REFERENCES `codeface`.`pagerank` (`id`)
@@ -788,9 +788,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`pagerank_matrix` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `pagerankMatrix_pagerank_idx` ON `codeface`.`pagerank_matrix`
(`pageRankId` ASC) COMMENT '';
+CREATE INDEX `pagerankMatrix_pagerank_idx` ON `codeface`.`pagerank_matrix`
(`pageRankId` ASC);
-CREATE INDEX `pagerankMatrix_person_idx` ON `codeface`.`pagerank_matrix`
(`personId` ASC) COMMENT '';
+CREATE INDEX `pagerankMatrix_person_idx` ON `codeface`.`pagerank_matrix`
(`personId` ASC);
-- -----------------------------------------------------
@@ -799,10 +799,10 @@ CREATE INDEX `pagerankMatrix_person_idx` ON
`codeface`.`pagerank_matrix` (`perso
DROP TABLE IF EXISTS `codeface`.`edgelist` ;
CREATE TABLE IF NOT EXISTS `codeface`.`edgelist` (
- `clusterId` BIGINT NOT NULL COMMENT '',
- `fromId` BIGINT NOT NULL COMMENT '',
- `toId` BIGINT NOT NULL COMMENT '',
- `weight` DOUBLE NOT NULL COMMENT '',
+ `clusterId` BIGINT NOT NULL,
+ `fromId` BIGINT NOT NULL,
+ `toId` BIGINT NOT NULL,
+ `weight` DOUBLE NOT NULL,
CONSTRAINT `edgelist_person_from`
FOREIGN KEY (`fromId`)
REFERENCES `codeface`.`person` (`id`)
@@ -820,11 +820,11 @@ CREATE TABLE IF NOT EXISTS `codeface`.`edgelist` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `edgelist_person_from_idx` ON `codeface`.`edgelist` (`fromId`
ASC) COMMENT '';
+CREATE INDEX `edgelist_person_from_idx` ON `codeface`.`edgelist` (`fromId`
ASC);
-CREATE INDEX `edgelist_person_to_idx` ON `codeface`.`edgelist` (`toId` ASC)
COMMENT '';
+CREATE INDEX `edgelist_person_to_idx` ON `codeface`.`edgelist` (`toId` ASC);
-CREATE INDEX `edgeList_cluster_idx` ON `codeface`.`edgelist` (`clusterId` ASC)
COMMENT '';
+CREATE INDEX `edgeList_cluster_idx` ON `codeface`.`edgelist` (`clusterId` ASC);
-- -----------------------------------------------------
@@ -833,12 +833,12 @@ CREATE INDEX `edgeList_cluster_idx` ON
`codeface`.`edgelist` (`clusterId` ASC)
DROP TABLE IF EXISTS `codeface`.`twomode_edgelist` ;
CREATE TABLE IF NOT EXISTS `codeface`.`twomode_edgelist` (
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `source` CHAR(7) NOT NULL COMMENT '',
- `mlId` BIGINT NOT NULL COMMENT '',
- `fromVert` BIGINT NOT NULL COMMENT '',
- `toVert` VARCHAR(255) NOT NULL COMMENT '',
- `weight` DOUBLE NOT NULL COMMENT '',
+ `releaseRangeId` BIGINT NOT NULL,
+ `source` CHAR(7) NOT NULL,
+ `mlId` BIGINT NOT NULL,
+ `fromVert` BIGINT NOT NULL,
+ `toVert` VARCHAR(255) NOT NULL,
+ `weight` DOUBLE NOT NULL,
CONSTRAINT `twomode_edgelist_releaseRange`
FOREIGN KEY (`releaseRangeId`)
REFERENCES `codeface`.`release_range` (`id`)
@@ -856,11 +856,11 @@ CREATE TABLE IF NOT EXISTS `codeface`.`twomode_edgelist` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `twomode_edgelist_releaseRange_idx` ON
`codeface`.`twomode_edgelist` (`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `twomode_edgelist_releaseRange_idx` ON
`codeface`.`twomode_edgelist` (`releaseRangeId` ASC);
-CREATE INDEX `twomode_edgelist_person_idx` ON `codeface`.`twomode_edgelist`
(`fromVert` ASC) COMMENT '';
+CREATE INDEX `twomode_edgelist_person_idx` ON `codeface`.`twomode_edgelist`
(`fromVert` ASC);
-CREATE INDEX `twomode_edgelist_mlId_idx` ON `codeface`.`twomode_edgelist`
(`mlId` ASC) COMMENT '';
+CREATE INDEX `twomode_edgelist_mlId_idx` ON `codeface`.`twomode_edgelist`
(`mlId` ASC);
-- -----------------------------------------------------
@@ -869,12 +869,12 @@ CREATE INDEX `twomode_edgelist_mlId_idx` ON
`codeface`.`twomode_edgelist` (`mlId
DROP TABLE IF EXISTS `codeface`.`twomode_vertices` ;
CREATE TABLE IF NOT EXISTS `codeface`.`twomode_vertices` (
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `source` CHAR(7) NOT NULL COMMENT '',
- `mlId` BIGINT NOT NULL COMMENT '',
- `name` VARCHAR(255) NOT NULL COMMENT '',
- `degree` DOUBLE NOT NULL COMMENT '',
- `type` SMALLINT NOT NULL COMMENT '',
+ `releaseRangeId` BIGINT NOT NULL,
+ `source` CHAR(7) NOT NULL,
+ `mlId` BIGINT NOT NULL,
+ `name` VARCHAR(255) NOT NULL,
+ `degree` DOUBLE NOT NULL,
+ `type` SMALLINT NOT NULL,
CONSTRAINT `twomode_vertices_releaseRange`
FOREIGN KEY (`releaseRangeId`)
REFERENCES `codeface`.`release_range` (`id`)
@@ -887,9 +887,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`twomode_vertices` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `twomode_vertices_releaseRange_idx` ON
`codeface`.`twomode_vertices` (`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `twomode_vertices_releaseRange_idx` ON
`codeface`.`twomode_vertices` (`releaseRangeId` ASC);
-CREATE INDEX `twomode_vertices_mlId_idx` ON `codeface`.`twomode_vertices`
(`mlId` ASC) COMMENT '';
+CREATE INDEX `twomode_vertices_mlId_idx` ON `codeface`.`twomode_vertices`
(`mlId` ASC);
-- -----------------------------------------------------
@@ -898,14 +898,14 @@ CREATE INDEX `twomode_vertices_mlId_idx` ON
`codeface`.`twomode_vertices` (`mlId
DROP TABLE IF EXISTS `codeface`.`initiate_response` ;
CREATE TABLE IF NOT EXISTS `codeface`.`initiate_response` (
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `mlId` BIGINT NOT NULL COMMENT '',
- `personId` BIGINT NOT NULL COMMENT '',
- `source` TINYINT NOT NULL COMMENT '',
- `responses` INT NULL DEFAULT NULL COMMENT '',
- `initiations` INT NULL DEFAULT NULL COMMENT '',
- `responses_received` INT NULL DEFAULT NULL COMMENT '',
- `deg` DOUBLE NULL DEFAULT NULL COMMENT '',
+ `releaseRangeId` BIGINT NOT NULL,
+ `mlId` BIGINT NOT NULL,
+ `personId` BIGINT NOT NULL,
+ `source` TINYINT NOT NULL,
+ `responses` INT NULL DEFAULT NULL,
+ `initiations` INT NULL DEFAULT NULL,
+ `responses_received` INT NULL DEFAULT NULL,
+ `deg` DOUBLE NULL DEFAULT NULL,
CONSTRAINT `initiate_response_releaseRange`
FOREIGN KEY (`releaseRangeId`)
REFERENCES `codeface`.`release_range` (`id`)
@@ -923,11 +923,11 @@ CREATE TABLE IF NOT EXISTS `codeface`.`initiate_response`
(
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `initiate_response_releaseRange_idx` ON
`codeface`.`initiate_response` (`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `initiate_response_releaseRange_idx` ON
`codeface`.`initiate_response` (`releaseRangeId` ASC);
-CREATE INDEX `initiate_response_person_idx` ON `codeface`.`initiate_response`
(`personId` ASC) COMMENT '';
+CREATE INDEX `initiate_response_person_idx` ON `codeface`.`initiate_response`
(`personId` ASC);
-CREATE INDEX `initiate_response_mlId_idx` ON `codeface`.`initiate_response`
(`mlId` ASC) COMMENT '';
+CREATE INDEX `initiate_response_mlId_idx` ON `codeface`.`initiate_response`
(`mlId` ASC);
-- -----------------------------------------------------
@@ -936,16 +936,16 @@ CREATE INDEX `initiate_response_mlId_idx` ON
`codeface`.`initiate_response` (`ml
DROP TABLE IF EXISTS `codeface`.`per_cluster_statistics` ;
CREATE TABLE IF NOT EXISTS `codeface`.`per_cluster_statistics` (
- `projectId` BIGINT NOT NULL COMMENT '',
- `releaseRangeId` BIGINT NOT NULL COMMENT '',
- `clusterId` BIGINT NOT NULL COMMENT '',
- `technique` TINYINT NOT NULL COMMENT '',
- `num_members` INT(11) NOT NULL COMMENT '',
- `added` INT(11) NOT NULL COMMENT '',
- `deleted` INT(11) NOT NULL COMMENT '',
- `total` INT(11) NOT NULL COMMENT '',
- `numcommits` INT(11) NOT NULL COMMENT '',
- `prank_avg` DOUBLE NOT NULL COMMENT '',
+ `projectId` BIGINT NOT NULL,
+ `releaseRangeId` BIGINT NOT NULL,
+ `clusterId` BIGINT NOT NULL,
+ `technique` TINYINT NOT NULL,
+ `num_members` INT(11) NOT NULL,
+ `added` INT(11) NOT NULL,
+ `deleted` INT(11) NOT NULL,
+ `total` INT(11) NOT NULL,
+ `numcommits` INT(11) NOT NULL,
+ `prank_avg` DOUBLE NOT NULL,
CONSTRAINT `per_cluster_statistics_projectId_ref`
FOREIGN KEY (`projectId`)
REFERENCES `codeface`.`project` (`id`)
@@ -958,9 +958,9 @@ CREATE TABLE IF NOT EXISTS
`codeface`.`per_cluster_statistics` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `fk_per_cluster_statistics_1_idx` ON
`codeface`.`per_cluster_statistics` (`projectId` ASC) COMMENT '';
+CREATE INDEX `fk_per_cluster_statistics_1_idx` ON
`codeface`.`per_cluster_statistics` (`projectId` ASC);
-CREATE INDEX `fk_per_cluster_statistics_1_idx1` ON
`codeface`.`per_cluster_statistics` (`releaseRangeId` ASC) COMMENT '';
+CREATE INDEX `fk_per_cluster_statistics_1_idx1` ON
`codeface`.`per_cluster_statistics` (`releaseRangeId` ASC);
-- -----------------------------------------------------
@@ -969,12 +969,12 @@ CREATE INDEX `fk_per_cluster_statistics_1_idx1` ON
`codeface`.`per_cluster_stati
DROP TABLE IF EXISTS `codeface`.`sloccount_ts` ;
CREATE TABLE IF NOT EXISTS `codeface`.`sloccount_ts` (
- `plotId` BIGINT NOT NULL COMMENT '',
- `time` DATETIME NOT NULL COMMENT '',
- `person_months` DOUBLE NOT NULL COMMENT '',
- `total_cost` DOUBLE NOT NULL COMMENT '',
- `schedule_months` DOUBLE NOT NULL COMMENT '',
- `avg_devel` DOUBLE NOT NULL COMMENT '',
+ `plotId` BIGINT NOT NULL,
+ `time` DATETIME NOT NULL,
+ `person_months` DOUBLE NOT NULL,
+ `total_cost` DOUBLE NOT NULL,
+ `schedule_months` DOUBLE NOT NULL,
+ `avg_devel` DOUBLE NOT NULL,
CONSTRAINT `sloccount_ts_plotid_ref`
FOREIGN KEY (`plotId`)
REFERENCES `codeface`.`plots` (`id`)
@@ -982,7 +982,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`sloccount_ts` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE UNIQUE INDEX `time_UNIQUE` ON `codeface`.`sloccount_ts` (`time` ASC)
COMMENT '';
+CREATE UNIQUE INDEX `time_UNIQUE` ON `codeface`.`sloccount_ts` (`time` ASC);
-- -----------------------------------------------------
@@ -991,12 +991,12 @@ CREATE UNIQUE INDEX `time_UNIQUE` ON
`codeface`.`sloccount_ts` (`time` ASC) COM
DROP TABLE IF EXISTS `codeface`.`understand_raw` ;
CREATE TABLE IF NOT EXISTS `codeface`.`understand_raw` (
- `plotId` BIGINT NOT NULL COMMENT '',
- `time` DATETIME NOT NULL COMMENT '',
- `kind` VARCHAR(30) NOT NULL COMMENT '',
- `name` VARCHAR(45) NULL COMMENT '',
- `variable` VARCHAR(45) NOT NULL COMMENT '',
- `value` DOUBLE NOT NULL COMMENT '',
+ `plotId` BIGINT NOT NULL,
+ `time` DATETIME NOT NULL,
+ `kind` VARCHAR(30) NOT NULL,
+ `name` VARCHAR(45) NULL,
+ `variable` VARCHAR(45) NOT NULL,
+ `value` DOUBLE NOT NULL,
CONSTRAINT `understand_raw_id_ref`
FOREIGN KEY (`plotId`)
REFERENCES `codeface`.`plots` (`id`)
@@ -1004,9 +1004,9 @@ CREATE TABLE IF NOT EXISTS `codeface`.`understand_raw` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `understand_raw_kind_idx` ON `codeface`.`understand_raw` (`kind`
ASC) COMMENT '';
+CREATE INDEX `understand_raw_kind_idx` ON `codeface`.`understand_raw` (`kind`
ASC);
-CREATE INDEX `understand_raw_plotId_idx` ON `codeface`.`understand_raw`
(`plotId` ASC) COMMENT '';
+CREATE INDEX `understand_raw_plotId_idx` ON `codeface`.`understand_raw`
(`plotId` ASC);
-- -----------------------------------------------------
@@ -1015,14 +1015,14 @@ CREATE INDEX `understand_raw_plotId_idx` ON
`codeface`.`understand_raw` (`plotId
DROP TABLE IF EXISTS `codeface`.`commit_dependency` ;
CREATE TABLE IF NOT EXISTS `codeface`.`commit_dependency` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `commitId` BIGINT NOT NULL COMMENT '',
- `file` VARCHAR(255) NOT NULL COMMENT '',
- `entityId` VARCHAR(255) NOT NULL COMMENT '',
- `entityType` VARCHAR(100) NOT NULL COMMENT '',
- `size` INT NULL COMMENT '',
- `impl` MEDIUMTEXT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `commitId` BIGINT NOT NULL,
+ `file` VARCHAR(255) NOT NULL,
+ `entityId` VARCHAR(255) NOT NULL,
+ `entityType` VARCHAR(100) NOT NULL,
+ `size` INT NULL,
+ `impl` MEDIUMTEXT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `fk_commit_dependency`
FOREIGN KEY (`commitId`)
REFERENCES `codeface`.`commit` (`id`)
@@ -1030,7 +1030,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`commit_dependency`
(
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `fk_1_idx` ON `codeface`.`commit_dependency` (`commitId` ASC)
COMMENT '';
+CREATE INDEX `fk_1_idx` ON `codeface`.`commit_dependency` (`commitId` ASC);
-- -----------------------------------------------------
@@ -1039,14 +1039,14 @@ CREATE INDEX `fk_1_idx` ON
`codeface`.`commit_dependency` (`commitId` ASC) COMM
DROP TABLE IF EXISTS `codeface`.`mail` ;
CREATE TABLE IF NOT EXISTS `codeface`.`mail` (
- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',
- `projectId` BIGINT NOT NULL COMMENT '',
- `threadId` BIGINT NOT NULL COMMENT '',
- `mlId` BIGINT NOT NULL COMMENT '',
- `author` BIGINT NOT NULL COMMENT '',
- `subject` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
- `creationDate` DATETIME NOT NULL COMMENT '',
- PRIMARY KEY (`id`) COMMENT '',
+ `id` BIGINT NOT NULL AUTO_INCREMENT,
+ `projectId` BIGINT NOT NULL,
+ `threadId` BIGINT NOT NULL,
+ `mlId` BIGINT NOT NULL,
+ `author` BIGINT NOT NULL,
+ `subject` VARCHAR(255) NULL DEFAULT NULL,
+ `creationDate` DATETIME NOT NULL,
+ PRIMARY KEY (`id`),
CONSTRAINT `mail_author`
FOREIGN KEY (`author`)
REFERENCES `codeface`.`person` (`id`)
@@ -1064,13 +1064,13 @@ CREATE TABLE IF NOT EXISTS `codeface`.`mail` (
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `mail_author_idx` ON `codeface`.`mail` (`author` ASC) COMMENT '';
+CREATE INDEX `mail_author_idx` ON `codeface`.`mail` (`author` ASC);
-CREATE INDEX `mail_projectId_idx` ON `codeface`.`mail` (`projectId` ASC)
COMMENT '';
+CREATE INDEX `mail_projectId_idx` ON `codeface`.`mail` (`projectId` ASC);
-CREATE INDEX `mail_mlId_idx` ON `codeface`.`mail` (`mlId` ASC) COMMENT '';
+CREATE INDEX `mail_mlId_idx` ON `codeface`.`mail` (`mlId` ASC);
-CREATE INDEX `mail_comp1_idx` ON `codeface`.`mail` (`mlId` ASC, `projectId`
ASC, `creationDate` ASC) COMMENT '';
+CREATE INDEX `mail_comp1_idx` ON `codeface`.`mail` (`mlId` ASC, `projectId`
ASC, `creationDate` ASC);
USE `codeface` ;
--
2.8.3
