From: Petr Pícha <ppicha@xxxxxxxxxxx>
In the database table issue, attributes isRegression, subComponent and
subSubComponent are specific to Bugzilla and have no counterpart in
other issue-tracking tools. Furthermore, attribute modifiedDate is obsolete
since the date of the last modification can be obtained by querying the
latest item of the issue_change table related the this issue. Remove these
attributes. Value changes of the corresponding fields are still stored
through data in issue- and field_change tables.
Signed-off-by: Petr Pícha <ppicha@xxxxxxxxxxx>
Signed-off-by: Wolfgang Mauerer <wolfgang.mauerer@xxxxxxxxxxxxxxxxx>
---
datamodel/codeface.mwb | Bin 61416 -> 61536 bytes
datamodel/codeface_schema.sql | 6 +-----
2 files changed, 1 insertion(+), 5 deletions(-)
diff --git a/datamodel/codeface.mwb b/datamodel/codeface.mwb
index d7a4285..f48fc5f 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 8a2e158..6c30dd0 100644
--- a/datamodel/codeface_schema.sql
+++ b/datamodel/codeface_schema.sql
@@ -1,5 +1,5 @@
-- MySQL Script generated by MySQL Workbench
--- 11/28/16 17:18:48
+-- 11/28/16 17:27:09
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
@@ -70,9 +70,7 @@ CREATE TABLE IF NOT EXISTS `codeface`.`issue` (
`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,
@@ -80,8 +78,6 @@ CREATE TABLE IF NOT EXISTS `codeface`.`issue` (
`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`
--
2.8.3