From: Petr Pícha <ppicha@xxxxxxxxxxx>
Attribute of table issue in the database storing the ID of
the issue in the source issue-tracking tool (server) is still
called bugId although the the table is not specifically designed
for bugs only but for issues generally. Renaming it to issueId
can result in misunderstanding that it stores Codeface ID of some
other issue. Rename the attribute to externalId to be less confusing
while referring to the ID of the issue in its source issue-tracking
tool (external to Codeface).
Signed-off-by: Petr Pícha <ppicha@xxxxxxxxxxx>
Signed-off-by: Wolfgang Mauerer <wolfgang.mauerer@xxxxxxxxxxxxxxxxx>
---
datamodel/codeface.mwb | Bin 62448 -> 62488 bytes
datamodel/codeface_schema.sql | 6 +++---
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/datamodel/codeface.mwb b/datamodel/codeface.mwb
index 8aa29a4..9edd33e 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 067617a..6660f6e 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:39:48
+-- 11/28/16 17:55:52
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
@@ -68,7 +68,7 @@ DROP TABLE IF EXISTS `codeface`.`issue` ;
CREATE TABLE IF NOT EXISTS `codeface`.`issue` (
`id` BIGINT NOT NULL AUTO_INCREMENT,
- `bugId` VARCHAR(45) NOT NULL,
+ `externalId` VARCHAR(45) NOT NULL,
`creationDate` DATETIME NOT NULL,
`url` VARCHAR(255) NULL DEFAULT NULL,
`status` VARCHAR(45) NOT NULL,
@@ -112,7 +112,7 @@ CREATE INDEX `issue_assignedTo_idx` ON `codeface`.`issue`
(`assignedTo` ASC);
CREATE INDEX `issue_projectId_idx` ON `codeface`.`issue` (`projectId` ASC);
-CREATE UNIQUE INDEX `bugId_UNIQUE` ON `codeface`.`issue` (`bugId` ASC);
+CREATE UNIQUE INDEX `externalId_UNIQUE` ON `codeface`.`issue` (`externalId`
ASC);
-- -----------------------------------------------------
--
2.8.3