Revize c9d1085d

#10648 refaktor potřebných změn v DB skriptech a konfiguračních services a controlleru + přehození umístění db skriptů

db/db.app_metadata_createTable.sql

@@ -1 @@
-if not exists (select * from sysobjects where name='app_metadata' and xtype='U')
-
-    create table app_metadata (
-        id int identity(1, 1),
-        appDataKey nvarchar(255),
-        appDataValue nvarchar(max)
-    )
-
-    go
-
-insert into app_metadata (appDataKey, appDataValue)
-    values
-        ('basics', N'[
-          {
-            "version": "1.0.0",
-            "authors": [
-              {
-                "name": "Ondřej Váně",
-                "email": "[e-mail]"
-              }
-            ],
-            "description": "This application is used to detect presence of anti-patterns in project management tools data. Seven selected anti-patterns are implemented in this application."
-          },
-          {
-            "version": "1.1.0",
-            "authors": [
-              {
-                "name": "Ondřej Váně",
-                "email": "[e-mail]"
-              }
-            ],
-            "description": "This application is used to detect presence of anti-patterns in project management tools data. Seven selected anti-patterns are implemented in this application."
-          },
-          {
-            "version": "1.2.0",
-            "authors": [
-              {
-                "name": "Petr Štěpánek",
-                "email": "[e-mail]"
-              }
-            ],
-            "description": "This application is used to detect presence of anti-patterns in project management tools data. Ten selected anti-patterns are implemented in this application."
-          },
-          {
-            "version": "2.0.0",
-            "authors": [
-              {
-                "name": "Petr Štěpánek",
-                "email": "[e-mail]"
-              },
-              {
-                "name": "Petr Urban",
-                "email": "[e-mail]"
-              },
-              {
-                "name": "Jiří Trefil",
-                "email": "[e-mail]"
-              },
-              {
-                "name": "Václav Hrabík",
-                "email": "[e-mail]"
-              }
-            ],
-            "description": "TODO"
-          }
-        ]')
-

db/spade-config.sql

@@ -1 @@
-USE spade;
-SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

db/spade-configurations.sql

@@ -1 @@
-use [authspade];
-begin transaction create_enviroment
-if not exists (select * from sysobjects where name='configurations' and xtype='U')
-create table configurations (
-	id int identity(1, 1),
-	configHash nvarchar(255),
-	config nvarchar(max) not null,
-	isDefault char(1) not null,
-	PRIMARY KEY(id)
-);
-
-if not exists (select * from sysobjects where name='users' and xtype='U')
-create table users(
-id int identity(1,1),
-email nvarchar(255) not null,
-name nvarchar(255) not null,
-password varchar(255) not null
-PRIMARY KEY(id)
-);
---declare @userId as int
-insert into users(email,name,password) values('[e-mail]','default','2747CABBB481A433679F6DC8AAE833DD1B64452778B97E2729BD3C54DEDE0886')
---set @userId = (select id from users where name='default')
---rozkladova tabulka mapujici uzivatele a k nemu asociovane konfigurace
-if not exists (select * from sysobjects where name='user_configurations' and xtype='U')
-create table user_configurations (
-	userId int not null,
-	configId int not null,
-    configurationName nvarchar(255) not null,
-	foreign key(userId) references users(id),
-	foreign key(configId) references configurations(id),
-	primary key(userId,configId)
-)
-
-insert into configurations (config, isDefault) values (
-	'{
-    "configuration": [
-        {
-            "antiPattern": "TooLongSprint",
-            "thresholds": [
-                {
-                    "thresholdName": "maxIterationLength",
-                    "value": "21"
-                },
-                {
-                    "thresholdName": "maxNumberOfTooLongIterations",
-                    "value": "0"
-                }
-            ]
-        },
-        {
-            "antiPattern": "VaryingSprintLength",
-            "thresholds": [
-                {
-                    "thresholdName": "maxDaysDifference",
-                    "value": "7"
-                },
-                {
-                    "thresholdName": "maxIterationChanged",
-                    "value": "1"
-                }
-            ]
-        },
-        {
-            "antiPattern": "BusinessAsUsual",
-            "thresholds": [
-                {
-                    "thresholdName": "divisionOfIterationsWithRetrospective",
-                    "value": "66.66f"
-                },
-                {
-                    "thresholdName": "searchSubstringsWithRetrospective",
-                    "value": "%retr%||%revi%||%week%scrum%"
-                }
-            ]
-        },
-        {
-            "antiPattern": "SpecifyNothing",
-            "thresholds": [
-                {
-                    "thresholdName": "minNumberOfWikiPagesWithSpecification",
-                    "value": "1"
-                },
-                {
-                    "thresholdName": "minNumberOfActivitiesWithSpecification",
-                    "value": "1"
-                },
-                {
-                    "thresholdName": "minAvgLengthOfActivityDescription",
-                    "value": "150"
-                },
-                {
-                    "thresholdName": "searchSubstringsWithProjectSpecification",
-                    "value": "%dsp%||%specifikace%||%specification%||%vize%proj%||%vize%produ%"
-                }
-            ]
-        },
-        {
-            "antiPattern": "RoadToNowhere",
-            "thresholds": [
-                {
-                    "thresholdName": "minNumberOfWikiPagesWithProjectPlan",
-                    "value": "1"
-                },
-                {
-                    "thresholdName": "minNumberOfActivitiesWithProjectPlan",
-                    "value": "1"
-                },
-                {
-                    "thresholdName": "searchSubstringsWithProjectPlan",
-                    "value": "%pl�n projektu%||%project plan%||%plan project%||%projektov� pl�n%"
-                }
-            ]
-        },
-        {
-            "antiPattern": "LongOrNonExistentFeedbackLoops",
-            "thresholds": [
-                {
-                    "thresholdName": "divisionOfIterationsWithFeedbackLoop",
-                    "value": "50.00f"
-                },
-                {
-                    "thresholdName": "maxGapBetweenFeedbackLoopRate",
-                    "value": "2f"
-                },
-                {
-                    "thresholdName": "searchSubstringsWithFeedbackLoop",
-                    "value": "%sch�z%z�kazn�k%||%p�edveden�%z�kazn�k%||%z�kazn%demo%||%sch�z%zadavat%||%inform%sch�z%||%z�kazn%||%zadavatel%"
-                }
-            ]
-        },
-        {
-            "antiPattern": "NinetyNinetyRule",
-            "thresholds": [
-                {
-                    "thresholdName": "maxDivisionRange",
-                    "value": "1.25f"
-                },
-                {
-                    "thresholdName": "maxBadDivisionLimit",
-                    "value": "2"
-                }
-            ]
-        },
-        {
-            "antiPattern": "UnknownPoster",
-            "thresholds": [
-                {
-                    "thresholdName": "searchSubstringsInvalidNames",
-                    "value": "%unknown%||%anonym%"
-                }
-            ]
-        },
-        {
-            "antiPattern": "BystanderApathy",
-            "thresholds": [
-                {
-                    "thresholdName": "searchSubstringsInvalidContributors",
-                    "value": "%dependabot%"
-                },
-                {
-                    "thresholdName": "maximumPercentageOfTasksWithoutTeamwork",
-                    "value": "30f"
-                }
-            ]
-        },
-        {
-            "antiPattern": "YetAnotherProgrammer",
-            "thresholds": [
-                {
-                    "thresholdName": "maxNumberOfNewContributors",
-                    "value": "5"
-                },
-                {
-                    "thresholdName": "numberOfFirstMonthsWithoutDetection",
-                    "value": "2"
-                }
-            ]
-        }
-    ]
-}',
-	'Y'
-
-
-)
-insert into user_configurations(userId,configId,configurationName) values (1,1,'default config')
-
-commit

db/spade-views.sql

@@ -1 @@
--- phpMyAdmin SQL Dump
--- version 5.0.4deb2
--- https://www.phpmyadmin.net/
---
--- Host: localhost
--- Generation Time: May 10, 2022 at 05:24 PM
--- Server version: 10.5.15-MariaDB-0+deb11u1
--- PHP Version: 7.4.28
-
-SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
-START TRANSACTION;
-
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8mb4 */;
-
---
--- Database: `spade`
---
-USE `spade`;
-
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `artifactView`
--- (See below for the actual view)
---
-CREATE TABLE `artifactView` (
-`name` varchar(255)
-,`description` longtext
-,`created` datetime
-,`url` varchar(255)
-,`id` bigint(20)
-,`artifactClass` varchar(255)
-,`mimeType` varchar(255)
-,`size` bigint(20)
-,`authorId` bigint(20)
-,`authorName` varchar(255)
-,`projectId` bigint(20)
-);
-
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `commitedConfigView`
--- (See below for the actual view)
---
-CREATE TABLE `commitedConfigView` (
-`id` bigint(20)
-,`type` varchar(31)
-,`name` varchar(255)
-,`description` longtext
-,`created` datetime
-,`authorId` bigint(20)
-,`authorName` varchar(255)
-,`relationName` varchar(255)
-,`relatedId` bigint(20)
-,`relatedName` varchar(255)
-,`projectId` bigint(20)
-,`committed` datetime
-);
-
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `commitView`
--- (See below for the actual view)
---
-CREATE TABLE `commitView` (
-`id` bigint(20)
-,`type` varchar(31)
-,`name` varchar(255)
-,`description` longtext
-,`created` datetime
-,`authorId` bigint(20)
-,`authorName` varchar(255)
-,`relationName` varchar(255)
-,`relatedId` bigint(20)
-,`relatedName` varchar(255)
-,`projectId` bigint(20)
-,`committed` datetime
-,`isRelease` bit(1)
-,`tag` varchar(255)
-,`branch` varchar(255)
-,`main` bit(1)
-);
-
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `configurationView`
--- (See below for the actual view)
---
-CREATE TABLE `configurationView` (
-`id` bigint(20)
-,`type` varchar(31)
-,`name` varchar(255)
-,`description` longtext
-,`created` datetime
-,`authorId` bigint(20)
-,`authorName` varchar(255)
-,`relationName` varchar(255)
-,`relatedId` bigint(20)
-,`relatedName` varchar(255)
-,`projectId` bigint(20)
-);
-
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `fieldChangeView`
--- (See below for the actual view)
---
-CREATE TABLE `fieldChangeView` (
-`id` bigint(20)
-,`type` varchar(31)
-,`name` varchar(255)
-,`description` longtext
-,`created` datetime
-,`authorId` bigint(20)
-,`authorName` varchar(255)
-,`relationName` varchar(255)
-,`relatedId` bigint(20)
-,`relatedName` varchar(255)
-,`projectId` bigint(20)
-,`changeName` varchar(255)
-,`changeDesc` longtext
-,`itemId` bigint(20)
-,`itemType` varchar(31)
-,`itemName` varchar(255)
-,`itemDesc` longtext
-,`itemCreated` datetime
-,`field` varchar(255)
-,`newValue` longtext
-,`oldValue` longtext
-);
-
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `personView`
--- (See below for the actual view)
---
-CREATE TABLE `personView` (
-`id` bigint(20)
-,`name` varchar(255)
-,`projectId` bigint(20)
-);
-
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `personWithRolesView`
--- (See below for the actual view)
---
-CREATE TABLE `personWithRolesView` (
-`id` bigint(20)
-,`name` varchar(255)
-,`role` varchar(255)
-,`roleClass` varchar(255)
-,`roleSuperClass` varchar(255)
-,`projectId` bigint(20)
-);
-
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `workUnitView`
--- (See below for the actual view)
---
-CREATE TABLE `workUnitView` (
-`id` bigint(20)
-,`name` varchar(255)
-,`description` longtext
-,`created` datetime
-,`dueDate` date
-,`estimatedTime` double
-,`progress` int(11)
-,`spentTime` double
-,`startDate` date
-,`projectId` bigint(20)
-,`authorId` bigint(20)
-,`authorName` varchar(255)
-,`assigneeId` bigint(20)
-,`assigneeName` varchar(255)
-,`activityName` varchar(255)
-,`activityDesc` longtext
-,`activityEndDate` date
-,`activityStartDate` date
-,`iterationName` varchar(255)
-,`iterationDesc` longtext
-,`iterationStartDate` date
-,`iterationEndDate` date
-,`iterationCreated` datetime
-,`phaseName` varchar(255)
-,`phaseDesc` longtext
-,`phaseStartDate` date
-,`phaseEndDate` date
-,`phaseCreated` datetime
-,`priorityName` varchar(255)
-,`priorityDesc` longtext
-,`prioClass` varchar(255)
-,`prioSuperClass` varchar(255)
-,`severityName` varchar(255)
-,`severityDesc` longtext
-,`severityClass` varchar(255)
-,`severitySuperClass` varchar(255)
-,`resolutionName` varchar(255)
-,`resolutionDescription` longtext
-,`resolutionClass` varchar(255)
-,`resolutionSuperClass` varchar(255)
-,`statusName` varchar(255)
-,`statusDescription` longtext
-,`statusClass` varchar(255)
-,`statusSuperClass` varchar(255)
-,`wuTypeName` varchar(255)
-,`wuTypeDescription` longtext
-,`wuTypeClass` varchar(255)
-,`categoryName` varchar(255)
-,`categoryDesc` longtext
-);
-
--- --------------------------------------------------------
-
---
--- Structure for view `artifactView`
---
-DROP TABLE IF EXISTS `artifactView`;
-
-CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `artifactView`  AS SELECT `wi`.`name` AS `name`, `wi`.`description` AS `description`, `wi`.`created` AS `created`, `wi`.`url` AS `url`, `a`.`id` AS `id`, `a`.`artifactClass` AS `artifactClass`, `a`.`mimeType` AS `mimeType`, `a`.`size` AS `size`, `p`.`id` AS `authorId`, `p`.`name` AS `authorName`, `p`.`projectId` AS `projectId` FROM ((`work_item` `wi` join `artifact` `a` on(`a`.`id` = `wi`.`id`)) join `personView` `p` on(`p`.`id` = `wi`.`authorId`)) ;
-
--- --------------------------------------------------------
-
---
--- Structure for view `commitedConfigView`
---
-DROP TABLE IF EXISTS `commitedConfigView`;
-
-CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `commitedConfigView`  AS SELECT `c`.`id` AS `id`, `c`.`type` AS `type`, `c`.`name` AS `name`, `c`.`description` AS `description`, `c`.`created` AS `created`, `c`.`authorId` AS `authorId`, `c`.`authorName` AS `authorName`, `c`.`relationName` AS `relationName`, `c`.`relatedId` AS `relatedId`, `c`.`relatedName` AS `relatedName`, `c`.`projectId` AS `projectId`, `cc`.`committed` AS `committed` FROM (`configurationView` `c` join `committed_configuration` `cc` on(`c`.`id` = `cc`.`id`)) ;
-
--- --------------------------------------------------------
-
---
--- Structure for view `commitView`
---
-DROP TABLE IF EXISTS `commitView`;
-
-CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `commitView`  AS SELECT `cc`.`id` AS `id`, `cc`.`type` AS `type`, `cc`.`name` AS `name`, `cc`.`description` AS `description`, `cc`.`created` AS `created`, `cc`.`authorId` AS `authorId`, `cc`.`authorName` AS `authorName`, `cc`.`relationName` AS `relationName`, `cc`.`relatedId` AS `relatedId`, `cc`.`relatedName` AS `relatedName`, `cc`.`projectId` AS `projectId`, `cc`.`committed` AS `committed`, `cm`.`isRelease` AS `isRelease`, `tg`.`name` AS `tag`, `br`.`name` AS `branch`, `br`.`isMain` AS `main` FROM ((((`commitedConfigView` `cc` join `commit` `cm` on(`cc`.`id` = `cm`.`id`)) left join `tag` `tg` on(`cm`.`id` = `tg`.`configurationId`)) join `configuration_branch` `cfbr` on(`cfbr`.`configurationId` = `cm`.`id`)) join `branch` `br` on(`br`.`id` = `cfbr`.`branchId`)) ;
-
--- --------------------------------------------------------
-
---
--- Structure for view `configurationView`
---
-DROP TABLE IF EXISTS `configurationView`;
-
-CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `configurationView`  AS SELECT `wi`.`id` AS `id`, `wi`.`workItemType` AS `type`, `wi`.`name` AS `name`, `wi`.`description` AS `description`, `wi`.`created` AS `created`, `author`.`id` AS `authorId`, `author`.`name` AS `authorName`, `cpr`.`name` AS `relationName`, `related`.`id` AS `relatedId`, `related`.`name` AS `relatedName`, `c`.`projectId` AS `projectId` FROM ((((`work_item` `wi` join `configuration` `c` on(`c`.`id` = `wi`.`id`)) join `personView` `author` on(`author`.`id` = `wi`.`authorId`)) left join `configuration_person_relation` `cpr` on(`cpr`.`configurationId` = `c`.`id`)) left join `personView` `related` on(`cpr`.`personId` = `related`.`id`)) ;
-
--- --------------------------------------------------------
-
---
--- Structure for view `fieldChangeView`
---
-DROP TABLE IF EXISTS `fieldChangeView`;
-
-CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `fieldChangeView`  AS SELECT `conf`.`id` AS `id`, `conf`.`type` AS `type`, `conf`.`name` AS `name`, `conf`.`description` AS `description`, `conf`.`created` AS `created`, `conf`.`authorId` AS `authorId`, `conf`.`authorName` AS `authorName`, `conf`.`relationName` AS `relationName`, `conf`.`relatedId` AS `relatedId`, `conf`.`relatedName` AS `relatedName`, `conf`.`projectId` AS `projectId`, `wchange`.`name` AS `changeName`, `wchange`.`description` AS `changeDesc`, `item`.`id` AS `itemId`, `item`.`workItemType` AS `itemType`, `item`.`name` AS `itemName`, `item`.`description` AS `itemDesc`, `item`.`created` AS `itemCreated`, `fc`.`name` AS `field`, `fc`.`newValue` AS `newValue`, `fc`.`oldValue` AS `oldValue` FROM ((((`configurationView` `conf` left join `configuration_change` `cfc` on(`cfc`.`configurationId` = `conf`.`id`)) left join `work_item_change` `wchange` on(`wchange`.`id` = `cfc`.`changeId`)) left join `field_change` `fc` on(`fc`.`workItemChangeId` = `wchange`.`id`)) join `work_item` `item` on(`wchange`.`workItemId` = `item`.`id`)) ;
-
--- --------------------------------------------------------
-
---
--- Structure for view `personView`
---
-DROP TABLE IF EXISTS `personView`;
-
-CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `personView`  AS SELECT `p`.`id` AS `id`, `p`.`name` AS `name`, `p`.`projectId` AS `projectId` FROM `person` AS `p` ;
-
--- --------------------------------------------------------
-
---
--- Structure for view `personWithRolesView`
---
-DROP TABLE IF EXISTS `personWithRolesView`;
-
-CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `personWithRolesView`  AS SELECT `p`.`id` AS `id`, `p`.`name` AS `name`, `r`.`name` AS `role`, `rc`.`class` AS `roleClass`, `rc`.`superClass` AS `roleSuperClass`, `p`.`projectId` AS `projectId` FROM (((`person` `p` join `person_role` `pr` on(`pr`.`personId` = `p`.`id`)) join `role` `r` on(`r`.`id` = `pr`.`roleId`)) join `role_classification` `rc` on(`rc`.`id` = `r`.`classId`)) ;
-
--- --------------------------------------------------------
-
---
--- Structure for view `workUnitView`
---
-DROP TABLE IF EXISTS `workUnitView`;
-
-CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `workUnitView`  AS SELECT `wi`.`id` AS `id`, `wi`.`name` AS `name`, `wi`.`description` AS `description`, `wi`.`created` AS `created`, `wu`.`dueDate` AS `dueDate`, `wu`.`estimatedTime` AS `estimatedTime`, `wu`.`progress` AS `progress`, `wu`.`spentTime` AS `spentTime`, `wu`.`startDate` AS `startDate`, `wu`.`projectId` AS `projectId`, `author`.`id` AS `authorId`, `author`.`name` AS `authorName`, `assignee`.`id` AS `assigneeId`, `assignee`.`name` AS `assigneeName`, `ac`.`name` AS `activityName`, `ac`.`description` AS `activityDesc`, `ac`.`endDate` AS `activityEndDate`, `ac`.`startDate` AS `activityStartDate`, `it`.`name` AS `iterationName`, `it`.`description` AS `iterationDesc`, `it`.`startDate` AS `iterationStartDate`, `it`.`endDate` AS `iterationEndDate`, `it`.`created` AS `iterationCreated`, `ph`.`name` AS `phaseName`, `ph`.`description` AS `phaseDesc`, `ph`.`startDate` AS `phaseStartDate`, `ph`.`endDate` AS `phaseEndDate`, `ph`.`created` AS `phaseCreated`, `pr`.`name` AS `priorityName`, `pr`.`description` AS `priorityDesc`, `prcl`.`class` AS `prioClass`, `prcl`.`superClass` AS `prioSuperClass`, `ser`.`name` AS `severityName`, `ser`.`description` AS `severityDesc`, `sercl`.`class` AS `severityClass`, `sercl`.`superClass` AS `severitySuperClass`, `res`.`name` AS `resolutionName`, `res`.`description` AS `resolutionDescription`, `rescl`.`class` AS `resolutionClass`, `rescl`.`superClass` AS `resolutionSuperClass`, `st`.`name` AS `statusName`, `st`.`description` AS `statusDescription`, `stcl`.`class` AS `statusClass`, `stcl`.`superClass` AS `statusSuperClass`, `wt`.`name` AS `wuTypeName`, `wt`.`description` AS `wuTypeDescription`, `wtcl`.`class` AS `wuTypeClass`, `ct`.`name` AS `categoryName`, `ct`.`description` AS `categoryDesc` FROM ((((((((((((((((((`work_item` `wi` join `work_unit` `wu` on(`wu`.`id` = `wi`.`id`)) join `personView` `author` on(`wi`.`authorId` = `author`.`id`)) join `personView` `assignee` on(`assignee`.`id` = `wu`.`assigneeId`)) left join `activity` `ac` on(`wu`.`activityId` = `ac`.`id`)) left join `iteration` `it` on(`wu`.`iterationId` = `it`.`id`)) left join `phase` `ph` on(`wu`.`phaseId` = `ph`.`id`)) join `priority` `pr` on(`pr`.`id` = `wu`.`priorityId`)) join `priority_classification` `prcl` on(`prcl`.`id` = `pr`.`classId`)) join `severity` `ser` on(`ser`.`id` = `wu`.`severityId`)) join `severity_classification` `sercl` on(`sercl`.`id` = `ser`.`classId`)) left join `resolution` `res` on(`res`.`id` = `wu`.`resolutionId`)) left join `resolution_classification` `rescl` on(`rescl`.`id` = `res`.`classId`)) join `status` `st` on(`st`.`id` = `wu`.`statusId`)) join `status_classification` `stcl` on(`stcl`.`id` = `st`.`classId`)) join `wu_type` `wt` on(`wt`.`id` = `wu`.`wuTypeId`)) join `wu_type_classification` `wtcl` on(`wtcl`.`id` = `wt`.`classId`)) left join `work_unit_category` `wuc` on(`wuc`.`workUnitId` = `wu`.`id`)) left join `category` `ct` on(`ct`.`id` = `wuc`.`categoryId`)) ;
-COMMIT;
-
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

db/spade.sql

@@ -1 @@
--- phpMyAdmin SQL Dump
--- version 5.0.4deb2
--- https://www.phpmyadmin.net/
---
--- Host: localhost
--- Generation Time: May 10, 2022 at 05:20 PM
--- Server version: 10.5.15-MariaDB-0+deb11u1
--- PHP Version: 7.4.28
-
-SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
-START TRANSACTION;
-
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8mb4 */;
-
---
--- Database: `spade`
---
-CREATE DATABASE IF NOT EXISTS `spade` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-USE `spade`;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `activity`
---
-
-CREATE TABLE `activity` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `endDate` date DEFAULT NULL,
-  `startDate` date DEFAULT NULL,
-  `superProjectId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `artifact`
---
-
-CREATE TABLE `artifact` (
-  `artifactClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `mimeType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `size` bigint(20) NOT NULL,
-  `id` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `branch`
---
-
-CREATE TABLE `branch` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `isMain` bit(1) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `category`
---
-
-CREATE TABLE `category` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `commit`
---
-
-CREATE TABLE `commit` (
-  `identifier` varchar(7) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `isRelease` bit(1) NOT NULL,
-  `id` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `committed_configuration`
---
-
-CREATE TABLE `committed_configuration` (
-  `committed` datetime DEFAULT NULL,
-  `id` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `competency`
---
-
-CREATE TABLE `competency` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `configuration`
---
-
-CREATE TABLE `configuration` (
-  `id` bigint(20) NOT NULL,
-  `projectId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `configuration_branch`
---
-
-CREATE TABLE `configuration_branch` (
-  `configurationId` bigint(20) NOT NULL,
-  `branchId` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `configuration_change`
---
-
-CREATE TABLE `configuration_change` (
-  `configurationId` bigint(20) NOT NULL,
-  `changeId` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `configuration_person_relation`
---
-
-CREATE TABLE `configuration_person_relation` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `personId` bigint(20) DEFAULT NULL,
-  `configurationId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `criterion`
---
-
-CREATE TABLE `criterion` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `field_change`
---
-
-CREATE TABLE `field_change` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `newValue` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `oldValue` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `workItemChangeId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `group_member`
---
-
-CREATE TABLE `group_member` (
-  `groupId` bigint(20) NOT NULL,
-  `memberId` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `identity`
---
-
-CREATE TABLE `identity` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `personId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `iteration`
---
-
-CREATE TABLE `iteration` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `endDate` date DEFAULT NULL,
-  `startDate` date DEFAULT NULL,
-  `created` datetime DEFAULT NULL,
-  `superProjectId` bigint(20) DEFAULT NULL,
-  `configurationId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `milestone`
---
-
-CREATE TABLE `milestone` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `milestone_criterion`
---
-
-CREATE TABLE `milestone_criterion` (
-  `milestoneId` bigint(20) NOT NULL,
-  `criterionId` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `people_group`
---
-
-CREATE TABLE `people_group` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `person`
---
-
-CREATE TABLE `person` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `projectId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `person_competency`
---
-
-CREATE TABLE `person_competency` (
-  `personId` bigint(20) NOT NULL,
-  `competencyId` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `person_role`
---
-
-CREATE TABLE `person_role` (
-  `personId` bigint(20) NOT NULL,
-  `roleId` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `phase`
---
-
-CREATE TABLE `phase` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `endDate` date DEFAULT NULL,
-  `startDate` date DEFAULT NULL,
-  `created` datetime DEFAULT NULL,
-  `superProjectId` bigint(20) DEFAULT NULL,
-  `configurationId` bigint(20) DEFAULT NULL,
-  `milestoneId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `priority`
---
-
-CREATE TABLE `priority` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `classId` bigint(20) DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `priority_classification`
---
-
-CREATE TABLE `priority_classification` (
-  `id` bigint(20) NOT NULL,
-  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `superClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `priority_classification`
---
-
-INSERT INTO `priority_classification` (`id`, `class`, `superClass`) VALUES
-(1, 'UNASSIGNED', 'UNASSIGNED'),
-(2, 'LOWEST', 'LOW'),
-(3, 'LOW', 'LOW'),
-(4, 'NORMAL', 'NORMAL'),
-(5, 'HIGH', 'HIGH'),
-(6, 'HIGHEST', 'HIGH');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `program`
---
-
-CREATE TABLE `program` (
-  `programClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `id` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `project`
---
-
-CREATE TABLE `project` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `endDate` date DEFAULT NULL,
-  `startDate` date DEFAULT NULL,
-  `superProjectId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `project_instance`
---
-
-CREATE TABLE `project_instance` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `projectId` bigint(20) DEFAULT NULL,
-  `toolInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `relation`
---
-
-CREATE TABLE `relation` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `classId` bigint(20) DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `relation_classification`
---
-
-CREATE TABLE `relation_classification` (
-  `id` bigint(20) NOT NULL,
-  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `superClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `relation_classification`
---
-
-INSERT INTO `relation_classification` (`id`, `class`, `superClass`) VALUES
-(1, 'UNASSIGNED', 'UNASSIGNED'),
-(2, 'DUPLICATES', 'SIMILARITY'),
-(3, 'DUPLICATEDBY', 'SIMILARITY'),
-(4, 'BLOCKS', 'TEMPORAL'),
-(5, 'BLOCKEDBY', 'TEMPORAL'),
-(6, 'RELATESTO', 'GENERAL'),
-(7, 'PRECEDES', 'TEMPORAL'),
-(8, 'FOLLOWS', 'TEMPORAL'),
-(9, 'COPIEDFROM', 'SIMILARITY'),
-(10, 'COPIEDBY', 'SIMILARITY'),
-(11, 'CHILDOF', 'HIERARCHICAL'),
-(12, 'PARENTOF', 'HIERARCHICAL'),
-(13, 'CAUSES', 'CAUSAL'),
-(14, 'CAUSEDBY', 'CAUSAL'),
-(15, 'RESOLVES', 'CAUSAL'),
-(16, 'RESOLVEDBY', 'CAUSAL');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `resolution`
---
-
-CREATE TABLE `resolution` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `classId` bigint(20) DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `resolution_classification`
---
-
-CREATE TABLE `resolution_classification` (
-  `id` bigint(20) NOT NULL,
-  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `superClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `resolution_classification`
---
-
-INSERT INTO `resolution_classification` (`id`, `class`, `superClass`) VALUES
-(1, 'UNASSIGNED', 'UNASSIGNED'),
-(2, 'DUPLICATE', 'FINISHED'),
-(3, 'INVALID', 'FINISHED'),
-(4, 'WONTFIX', 'FINISHED'),
-(5, 'WORKSASDESIGNED', 'FINISHED'),
-(6, 'FIXED', 'FINISHED'),
-(7, 'FINISHED', 'FINISHED'),
-(8, 'INCOMPLETE', 'UNFINISHED'),
-(9, 'WORKSFORME', 'UNFINISHED'),
-(10, 'UNFINISHED', 'UNFINISHED');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `role`
---
-
-CREATE TABLE `role` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `classId` bigint(20) DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `role_classification`
---
-
-CREATE TABLE `role_classification` (
-  `id` bigint(20) NOT NULL,
-  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `superClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `role_classification`
---
-
-INSERT INTO `role_classification` (`id`, `class`, `superClass`) VALUES
-(1, 'UNASSIGNED', 'UNASSIGNED'),
-(2, 'NONMEMBER', 'NONMEMBER'),
-(3, 'MENTOR', 'STAKEHOLDER'),
-(4, 'STAKEHOLDER', 'STAKEHOLDER'),
-(5, 'PROJECTMANAGER', 'MANAGEMENT'),
-(6, 'TEAMMEMBER', 'TEAMMEMBER'),
-(7, 'ANALYST', 'TEAMMEMBER'),
-(8, 'DESIGNER', 'TEAMMEMBER'),
-(9, 'DEVELOPER', 'TEAMMEMBER'),
-(10, 'TESTER', 'TEAMMEMBER'),
-(11, 'DOCUMENTER', 'TEAMMEMBER');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `severity`
---
-
-CREATE TABLE `severity` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `classId` bigint(20) DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `severity_classification`
---
-
-CREATE TABLE `severity_classification` (
-  `id` bigint(20) NOT NULL,
-  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `superClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `severity_classification`
---
-
-INSERT INTO `severity_classification` (`id`, `class`, `superClass`) VALUES
-(1, 'UNASSIGNED', 'UNASSIGNED'),
-(2, 'TRIVIAL', 'MINOR'),
-(3, 'MINOR', 'MINOR'),
-(4, 'NORMAL', 'NORMAL'),
-(5, 'MAJOR', 'MAJOR'),
-(6, 'CRITICAL', 'MAJOR');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `status`
---
-
-CREATE TABLE `status` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `classId` bigint(20) DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `status_classification`
---
-
-CREATE TABLE `status_classification` (
-  `id` bigint(20) NOT NULL,
-  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `superClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `status_classification`
---
-
-INSERT INTO `status_classification` (`id`, `class`, `superClass`) VALUES
-(1, 'UNASSIGNED', 'UNASSIGNED'),
-(2, 'NEW', 'OPEN'),
-(3, 'OPEN', 'OPEN'),
-(4, 'ACCEPTED', 'OPEN'),
-(5, 'INPROGRESS', 'OPEN'),
-(6, 'RESOLVED', 'OPEN'),
-(7, 'VERIFIED', 'OPEN'),
-(8, 'DONE', 'CLOSED'),
-(9, 'CLOSED', 'CLOSED'),
-(10, 'INVALID', 'CLOSED'),
-(11, 'DELETED', 'CLOSED');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `tag`
---
-
-CREATE TABLE `tag` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `configurationId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `tool_instance`
---
-
-CREATE TABLE `tool_instance` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `tool` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `work_item`
---
-
-CREATE TABLE `work_item` (
-  `workItemType` varchar(31) COLLATE utf8_unicode_ci NOT NULL,
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `created` datetime DEFAULT NULL,
-  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `authorId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `work_item_change`
---
-
-CREATE TABLE `work_item_change` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `workItemId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `work_item_relation`
---
-
-CREATE TABLE `work_item_relation` (
-  `id` bigint(20) NOT NULL,
-  `rightItemId` bigint(20) DEFAULT NULL,
-  `relationId` bigint(20) DEFAULT NULL,
-  `leftItemId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `work_unit`
---
-
-CREATE TABLE `work_unit` (
-  `dueDate` date DEFAULT NULL,
-  `estimatedTime` double NOT NULL,
-  `number` int(11) NOT NULL,
-  `progress` int(11) NOT NULL,
-  `spentTime` double NOT NULL,
-  `startDate` date DEFAULT NULL,
-  `id` bigint(20) NOT NULL,
-  `activityId` bigint(20) DEFAULT NULL,
-  `assigneeId` bigint(20) DEFAULT NULL,
-  `iterationId` bigint(20) DEFAULT NULL,
-  `phaseId` bigint(20) DEFAULT NULL,
-  `priorityId` bigint(20) DEFAULT NULL,
-  `resolutionId` bigint(20) DEFAULT NULL,
-  `severityId` bigint(20) DEFAULT NULL,
-  `statusId` bigint(20) DEFAULT NULL,
-  `wuTypeId` bigint(20) DEFAULT NULL,
-  `projectId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `work_unit_category`
---
-
-CREATE TABLE `work_unit_category` (
-  `workUnitId` bigint(20) NOT NULL,
-  `categoryId` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `wu_type`
---
-
-CREATE TABLE `wu_type` (
-  `id` bigint(20) NOT NULL,
-  `externalId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
-  `classId` bigint(20) DEFAULT NULL,
-  `projectInstanceId` bigint(20) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `wu_type_classification`
---
-
-CREATE TABLE `wu_type_classification` (
-  `id` bigint(20) NOT NULL,
-  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `wu_type_classification`
---
-
-INSERT INTO `wu_type_classification` (`id`, `class`) VALUES
-(1, 'UNASSIGNED'),
-(2, 'BUG'),
-(3, 'ENHANCEMENT'),
-(4, 'FEATURE'),
-(5, 'TASK');
-
---
--- Indexes for dumped tables
---
-
---
--- Indexes for table `activity`
---
-ALTER TABLE `activity`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `FK_blqrry9wsm0foxy0mg00a0epk` (`superProjectId`);
-
---
--- Indexes for table `artifact`
---
-ALTER TABLE `artifact`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `branch`
---
-ALTER TABLE `branch`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `category`
---
-ALTER TABLE `category`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `FK_cpikjj79a9qmnxmo5unps4hsw` (`projectInstanceId`);
-
---
--- Indexes for table `commit`
---
-ALTER TABLE `commit`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `committed_configuration`
---
-ALTER TABLE `committed_configuration`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `competency`
---
-ALTER TABLE `competency`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `configuration`
---
-ALTER TABLE `configuration`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `FK_o7bmirglj65sjrcym8a1ywgwc` (`projectId`);
-
---
--- Indexes for table `configuration_branch`
---
-ALTER TABLE `configuration_branch`
-  ADD KEY `FK_kq1ppnqu72in7ciaiv0qfm7gq` (`branchId`),
-  ADD KEY `FK_bvbx76vbqrs4wkix8a4l64mgk` (`configurationId`);
-
---
--- Indexes for table `configuration_change`
---
-ALTER TABLE `configuration_change`
-  ADD UNIQUE KEY `UK_2vr3gl6l9t320r67yfspg8e16` (`changeId`),
-  ADD KEY `FK_b11yrb5xl6ea5lceca8r6eyaq` (`configurationId`);
-
---
--- Indexes for table `configuration_person_relation`
---
-ALTER TABLE `configuration_person_relation`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `FK_bannhsxpvu262ewrp6aval67i` (`personId`),
-  ADD KEY `FK_miwxanxtv7gt3knvsflwncix7` (`configurationId`);
-
---
--- Indexes for table `criterion`
---
-ALTER TABLE `criterion`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `field_change`
---
-ALTER TABLE `field_change`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `FK_mpcn64kubumdcj69467wdexg6` (`workItemChangeId`);
-
---
--- Indexes for table `group_member`
---
-ALTER TABLE `group_member`
-  ADD KEY `FK_67y4ufvw9p8w6mt4cp7bwa972` (`memberId`),
-  ADD KEY `FK_g639kt1nekbaykgg0pwy8ips8` (`groupId`);
-
---
--- Indexes for table `identity`
---
-ALTER TABLE `identity`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `FK_ocuj7jp17fw0qcow4o3f8e8o0` (`personId`);
-
---
--- Indexes for table `iteration`
---
-ALTER TABLE `iteration`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `FK_55okl4mwia1vo7n8q6dsbfr55` (`superProjectId`),
-  ADD KEY `FK_bid9cxxcrg3oufp2wc33j1h1e` (`configurationId`);
-
---
--- Indexes for table `milestone`
---
-ALTER TABLE `milestone`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `milestone_criterion`
---
-ALTER TABLE `milestone_criterion`
-  ADD KEY `FK_j65caq74d17bhsly89kylc3jk` (`criterionId`),
-  ADD KEY `FK_hahtmhvat46jgvqn41s98dxdl` (`milestoneId`);
-
---
--- Indexes for table `people_group`
---
-ALTER TABLE `people_group`
-  ADD PRIMARY KEY (`id`),
-  ADD KEY `FK_pif918vt32wbakh9vwaye6ib4` (`projectInstanceId`);
-
---