From: Petr Pícha <ppicha@xxxxxxxxxxx>
Database table cc_list stores people associated with an issue
(apart from the author and the asignee) who are to be informed
by email of any change applied to the issue. In common issue-tracking
tool terminology, these people are called "watchers" of the issue.
Rename table cc_list to watcher_list to better comply with the
common terminology.
Signed-off-by: Petr Pícha <ppicha@xxxxxxxxxxx>
Signed-off-by: Wolfgang Mauerer <wolfgang.mauerer@xxxxxxxxxxxxxxxxx>
---
datamodel/codeface.mwb | Bin 61237 -> 61416 bytes
datamodel/codeface_schema.sql | 16 ++++++++--------
2 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/datamodel/codeface.mwb b/datamodel/codeface.mwb
index 3df77be..d7a4285 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 e59e6a9..8a2e158 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:10:02
+-- 11/28/16 17:18:48
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
@@ -271,28 +271,28 @@ CREATE INDEX `mailThreadId_idx` ON
`codeface`.`thread_responses` (`mailThreadId`
-- -----------------------------------------------------
--- Table `codeface`.`cc_list`
+-- Table `codeface`.`watcher_list`
-- -----------------------------------------------------
-DROP TABLE IF EXISTS `codeface`.`cc_list` ;
+DROP TABLE IF EXISTS `codeface`.`watcher_list` ;
-CREATE TABLE IF NOT EXISTS `codeface`.`cc_list` (
+CREATE TABLE IF NOT EXISTS `codeface`.`watcher_list` (
`issueId` BIGINT NOT NULL,
`who` BIGINT NOT NULL,
- CONSTRAINT `cclist_issueId`
+ CONSTRAINT `watcher_list_issue`
FOREIGN KEY (`issueId`)
REFERENCES `codeface`.`issue` (`id`)
ON DELETE CASCADE
ON UPDATE CASCADE,
- CONSTRAINT `cclist_who`
+ CONSTRAINT `watcher_list_who`
FOREIGN KEY (`who`)
REFERENCES `codeface`.`person` (`id`)
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;
-CREATE INDEX `cclist_issueId_idx` ON `codeface`.`cc_list` (`issueId` ASC);
+CREATE INDEX `watcher_list_issue_idx` ON `codeface`.`watcher_list` (`issueId`
ASC);
-CREATE INDEX `cclist_who_idx` ON `codeface`.`cc_list` (`who` ASC);
+CREATE INDEX `watcher_list_who_idx` ON `codeface`.`watcher_list` (`who` ASC);
-- -----------------------------------------------------
--
2.8.3