Server IP : 66.29.132.124 / Your IP : 18.224.44.233 Web Server : LiteSpeed System : Linux business141.web-hosting.com 4.18.0-553.lve.el8.x86_64 #1 SMP Mon May 27 15:27:34 UTC 2024 x86_64 User : wavevlvu ( 1524) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /var/softaculous/kanboard/ |
Upload File : |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 utf8 */; -- -- Database: `kanboard1243` -- -- -------------------------------------------------------- -- -- Table structure for table `actions` -- CREATE TABLE `actions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `event_name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `action_name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `project_id` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `action_has_params` -- CREATE TABLE `action_has_params` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_id` int(11) NOT NULL, `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `action_id` (`action_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `columns` -- CREATE TABLE `columns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `position` int(11) NOT NULL, `project_id` int(11) NOT NULL, `task_limit` int(11) DEFAULT '0', `description` mediumtext COLLATE utf8mb4_unicode_ci, `hide_in_dashboard` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_title_project` (`title`,`project_id`), KEY `columns_project_idx` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `column_has_move_restrictions` -- CREATE TABLE `column_has_move_restrictions` ( `restriction_id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `src_column_id` int(11) NOT NULL, `dst_column_id` int(11) NOT NULL, `only_assigned` tinyint(1) DEFAULT '0', PRIMARY KEY (`restriction_id`), UNIQUE KEY `role_id` (`role_id`,`src_column_id`,`dst_column_id`), KEY `project_id` (`project_id`), KEY `src_column_id` (`src_column_id`), KEY `dst_column_id` (`dst_column_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `column_has_restrictions` -- CREATE TABLE `column_has_restrictions` ( `restriction_id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `column_id` int(11) NOT NULL, `rule` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`restriction_id`), UNIQUE KEY `role_id` (`role_id`,`column_id`,`rule`), KEY `project_id` (`project_id`), KEY `column_id` (`column_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `comments` -- CREATE TABLE `comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `task_id` int(11) NOT NULL, `user_id` int(11) DEFAULT '0', `date_creation` bigint(20) DEFAULT NULL, `comment` mediumtext COLLATE utf8mb4_unicode_ci, `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '', `date_modification` bigint(20) DEFAULT NULL, `visibility` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'app-user', PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `comments_reference_idx` (`reference`), KEY `comments_task_idx` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- CREATE TABLE `currencies` ( `currency` char(3) COLLATE utf8mb4_unicode_ci NOT NULL, `rate` float DEFAULT '0', UNIQUE KEY `currency` (`currency`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `custom_filters` -- CREATE TABLE `custom_filters` ( `id` int(11) NOT NULL AUTO_INCREMENT, `filter` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `is_shared` tinyint(1) DEFAULT '0', `append` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `project_id` (`project_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `external_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `group_has_users` -- CREATE TABLE `group_has_users` ( `group_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, UNIQUE KEY `group_id` (`group_id`,`user_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `invites` -- CREATE TABLE `invites` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`email`,`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `last_logins` -- CREATE TABLE `last_logins` ( `id` int(11) NOT NULL AUTO_INCREMENT, `auth_type` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_creation` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `links` -- CREATE TABLE `links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `label` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `opposite_id` int(11) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `label` (`label`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=12 ; -- -- Dumping data for table `links` -- INSERT INTO `links` VALUES (1, 'relates to', 0), (2, 'blocks', 3), (3, 'is blocked by', 2), (4, 'duplicates', 5), (5, 'is duplicated by', 4), (6, 'is a parent of', 7), (7, 'is a child of', 6), (8, 'is a milestone of', 9), (9, 'targets milestone', 8), (10, 'is fixed by', 11), (11, 'fixes', 10); -- -------------------------------------------------------- -- -- Table structure for table `password_reset` -- CREATE TABLE `password_reset` ( `token` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, `date_expiration` int(11) NOT NULL, `date_creation` int(11) NOT NULL, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, PRIMARY KEY (`token`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `plugin_schema_versions` -- CREATE TABLE `plugin_schema_versions` ( `plugin` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `version` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`plugin`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `predefined_task_descriptions` -- CREATE TABLE `predefined_task_descriptions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `project_id` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `projects` -- CREATE TABLE `projects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(4) DEFAULT '1', `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_modified` bigint(20) DEFAULT NULL, `is_public` tinyint(1) DEFAULT '0', `is_private` tinyint(1) DEFAULT '0', `description` mediumtext COLLATE utf8mb4_unicode_ci, `identifier` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '', `start_date` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '', `end_date` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '', `owner_id` int(11) DEFAULT '0', `priority_default` int(11) DEFAULT '0', `priority_start` int(11) DEFAULT '0', `priority_end` int(11) DEFAULT '3', `email` mediumtext COLLATE utf8mb4_unicode_ci, `predefined_email_subjects` mediumtext COLLATE utf8mb4_unicode_ci, `per_swimlane_task_limits` int(11) NOT NULL DEFAULT '0', `task_limit` int(11) DEFAULT '0', `enable_global_tags` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `project_activities` -- CREATE TABLE `project_activities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date_creation` bigint(20) DEFAULT NULL, `event_name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `creator_id` int(11) DEFAULT NULL, `project_id` int(11) DEFAULT NULL, `task_id` int(11) DEFAULT NULL, `data` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `creator_id` (`creator_id`), KEY `project_id` (`project_id`), KEY `task_id` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `project_daily_column_stats` -- CREATE TABLE `project_daily_column_stats` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` char(10) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, `column_id` int(11) NOT NULL, `total` int(11) NOT NULL DEFAULT '0', `score` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `project_daily_column_stats_idx` (`day`,`project_id`,`column_id`), KEY `column_id` (`column_id`), KEY `project_id` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `project_daily_stats` -- CREATE TABLE `project_daily_stats` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` char(10) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, `avg_lead_time` int(11) NOT NULL DEFAULT '0', `avg_cycle_time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `project_daily_stats_idx` (`day`,`project_id`), KEY `project_id` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `project_has_categories` -- CREATE TABLE `project_has_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, `description` mediumtext COLLATE utf8mb4_unicode_ci, `color_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_project_category` (`project_id`,`name`), KEY `categories_project_idx` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `project_has_files` -- CREATE TABLE `project_has_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `path` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `is_image` tinyint(1) DEFAULT '0', `size` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `date` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `project_id` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `project_has_groups` -- CREATE TABLE `project_has_groups` ( `group_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, UNIQUE KEY `group_id` (`group_id`,`project_id`), KEY `project_id` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `project_has_metadata` -- CREATE TABLE `project_has_metadata` ( `project_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `changed_by` int(11) NOT NULL DEFAULT '0', `changed_on` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `project_id` (`project_id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `project_has_notification_types` -- CREATE TABLE `project_has_notification_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `notification_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `project_id` (`project_id`,`notification_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `project_has_roles` -- CREATE TABLE `project_has_roles` ( `role_id` int(11) NOT NULL AUTO_INCREMENT, `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, PRIMARY KEY (`role_id`), UNIQUE KEY `project_id` (`project_id`,`role`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `project_has_users` -- CREATE TABLE `project_has_users` ( `project_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, UNIQUE KEY `idx_project_user` (`project_id`,`user_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `project_role_has_restrictions` -- CREATE TABLE `project_role_has_restrictions` ( `restriction_id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `rule` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`restriction_id`), UNIQUE KEY `role_id` (`role_id`,`rule`), KEY `project_id` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `remember_me` -- CREATE TABLE `remember_me` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sequence` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `expiration` int(11) DEFAULT NULL, `date_creation` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `schema_version` -- CREATE TABLE `schema_version` ( `version` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `schema_version` -- INSERT INTO `schema_version` VALUES (139); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `expire_at` int(11) NOT NULL, `data` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `option` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci, `changed_by` int(11) NOT NULL DEFAULT '0', `changed_on` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`option`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` VALUES ('api_token', '[[api_token]]', 0, 0), ('application_currency', 'USD', 0, 0), ('application_date_format', 'm/d/Y', 0, 0), ('application_language', '[[language]]', 0, 0), ('application_stylesheet', '', 0, 0), ('application_timezone', 'UTC', 0, 0), ('application_url', '', 0, 0), ('board_columns', '', 0, 0), ('board_highlight_period', '172800', 0, 0), ('board_private_refresh_interval', '10', 0, 0), ('board_public_refresh_interval', '60', 0, 0), ('calendar_project_tasks', 'date_started', 0, 0), ('calendar_user_subtasks_time_tracking', '0', 0, 0), ('calendar_user_tasks', 'date_started', 0, 0), ('cfd_include_closed_tasks', '1', 0, 0), ('default_color', 'yellow', 0, 0), ('integration_gravatar', '0', 0, 0), ('password_reset', '1', 0, 0), ('project_categories', '', 0, 0), ('subtask_restriction', '0', 0, 0), ('subtask_time_tracking', '1', 0, 0), ('webhook_token', '[[webhook_token]]', 0, 0), ('webhook_url', '', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `subtasks` -- CREATE TABLE `subtasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `status` int(11) DEFAULT '0', `time_estimated` float DEFAULT NULL, `time_spent` float DEFAULT NULL, `task_id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `position` int(11) DEFAULT '1', PRIMARY KEY (`id`), KEY `subtasks_task_idx` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `subtask_time_tracking` -- CREATE TABLE `subtask_time_tracking` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `subtask_id` int(11) NOT NULL, `start` bigint(20) DEFAULT NULL, `end` bigint(20) DEFAULT NULL, `time_spent` float DEFAULT '0', PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `subtask_id` (`subtask_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `swimlanes` -- CREATE TABLE `swimlanes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `position` int(11) DEFAULT '1', `is_active` int(11) DEFAULT '1', `project_id` int(11) DEFAULT NULL, `description` mediumtext COLLATE utf8mb4_unicode_ci, `task_limit` int(11) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`project_id`), KEY `swimlanes_project_idx` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, `color_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `project_id` (`project_id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tasks` -- CREATE TABLE `tasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `description` mediumtext COLLATE utf8mb4_unicode_ci, `date_creation` bigint(20) DEFAULT NULL, `date_completed` bigint(20) DEFAULT NULL, `date_due` bigint(20) DEFAULT NULL, `color_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `project_id` int(11) NOT NULL, `column_id` int(11) NOT NULL, `owner_id` int(11) DEFAULT '0', `position` int(11) DEFAULT NULL, `score` int(11) DEFAULT NULL, `is_active` tinyint(4) DEFAULT '1', `category_id` int(11) DEFAULT '0', `creator_id` int(11) DEFAULT '0', `date_modification` int(11) DEFAULT '0', `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '', `date_started` bigint(20) DEFAULT NULL, `time_spent` float DEFAULT '0', `time_estimated` float DEFAULT '0', `swimlane_id` int(11) NOT NULL, `date_moved` bigint(20) DEFAULT NULL, `recurrence_status` int(11) NOT NULL DEFAULT '0', `recurrence_trigger` int(11) NOT NULL DEFAULT '0', `recurrence_factor` int(11) NOT NULL DEFAULT '0', `recurrence_timeframe` int(11) NOT NULL DEFAULT '0', `recurrence_basedate` int(11) NOT NULL DEFAULT '0', `recurrence_parent` int(11) DEFAULT NULL, `recurrence_child` int(11) DEFAULT NULL, `priority` int(11) DEFAULT '0', `external_provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `external_uri` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_task_active` (`is_active`), KEY `column_id` (`column_id`), KEY `tasks_reference_idx` (`reference`), KEY `tasks_project_idx` (`project_id`), KEY `tasks_swimlane_ibfk_1` (`swimlane_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `task_has_external_links` -- CREATE TABLE `task_has_external_links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `link_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `dependency` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `url` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `date_creation` int(11) NOT NULL, `date_modification` int(11) NOT NULL, `task_id` int(11) NOT NULL, `creator_id` int(11) DEFAULT '0', PRIMARY KEY (`id`), KEY `task_id` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `task_has_files` -- CREATE TABLE `task_has_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `path` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `is_image` tinyint(1) DEFAULT '0', `task_id` int(11) NOT NULL, `date` bigint(20) DEFAULT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `size` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `files_task_idx` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `task_has_links` -- CREATE TABLE `task_has_links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `link_id` int(11) NOT NULL, `task_id` int(11) NOT NULL, `opposite_task_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `task_has_links_unique` (`link_id`,`task_id`,`opposite_task_id`), KEY `opposite_task_id` (`opposite_task_id`), KEY `task_has_links_task_index` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `task_has_metadata` -- CREATE TABLE `task_has_metadata` ( `task_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `changed_by` int(11) NOT NULL DEFAULT '0', `changed_on` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `task_id` (`task_id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `task_has_tags` -- CREATE TABLE `task_has_tags` ( `task_id` int(11) NOT NULL, `tag_id` int(11) NOT NULL, UNIQUE KEY `tag_id` (`tag_id`,`task_id`), KEY `task_id` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `transitions` -- CREATE TABLE `transitions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, `task_id` int(11) NOT NULL, `src_column_id` int(11) NOT NULL, `dst_column_id` int(11) NOT NULL, `date` bigint(20) DEFAULT NULL, `time_spent` int(11) DEFAULT '0', PRIMARY KEY (`id`), KEY `src_column_id` (`src_column_id`), KEY `dst_column_id` (`dst_column_id`), KEY `transitions_task_index` (`task_id`), KEY `transitions_project_index` (`project_id`), KEY `transitions_user_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_ldap_user` tinyint(1) DEFAULT '0', `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `google_id` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `github_id` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notifications_enabled` tinyint(1) DEFAULT '0', `timezone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `language` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `disable_login_form` tinyint(1) DEFAULT '0', `twofactor_activated` tinyint(1) DEFAULT '0', `twofactor_secret` char(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `notifications_filter` int(11) DEFAULT '4', `nb_failed_login` int(11) DEFAULT '0', `lock_expiration_date` bigint(20) DEFAULT NULL, `gitlab_id` int(11) DEFAULT NULL, `role` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'app-user', `is_active` tinyint(1) DEFAULT '1', `avatar_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `api_access_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `filter` mediumtext COLLATE utf8mb4_unicode_ci, `theme` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'light', PRIMARY KEY (`id`), UNIQUE KEY `users_username_idx` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES (1, '[[admin_username]]', '[[admin_pass]]', 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, NULL, '', 4, 0, 0, NULL, 'app-admin', 1, NULL, NULL, NULL, 'light'); -- -------------------------------------------------------- -- -- Table structure for table `user_has_metadata` -- CREATE TABLE `user_has_metadata` ( `user_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `changed_by` int(11) NOT NULL DEFAULT '0', `changed_on` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `user_id` (`user_id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `user_has_notifications` -- CREATE TABLE `user_has_notifications` ( `user_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, UNIQUE KEY `user_has_notifications_unique_idx` (`user_id`,`project_id`), KEY `user_has_notifications_ibfk_2` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `user_has_notification_types` -- CREATE TABLE `user_has_notification_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `notification_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_has_notification_types_user_idx` (`user_id`,`notification_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `user_has_unread_notifications` -- CREATE TABLE `user_has_unread_notifications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `date_creation` bigint(20) NOT NULL, `event_name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `event_data` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -- Constraints for dumped tables -- -- -- Constraints for table `actions` -- ALTER TABLE `actions` ADD CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `action_has_params` -- ALTER TABLE `action_has_params` ADD CONSTRAINT `action_has_params_ibfk_1` FOREIGN KEY (`action_id`) REFERENCES `actions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `columns` -- ALTER TABLE `columns` ADD CONSTRAINT `columns_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `column_has_move_restrictions` -- ALTER TABLE `column_has_move_restrictions` ADD CONSTRAINT `column_has_move_restrictions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `column_has_move_restrictions_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `project_has_roles` (`role_id`) ON DELETE CASCADE, ADD CONSTRAINT `column_has_move_restrictions_ibfk_3` FOREIGN KEY (`src_column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `column_has_move_restrictions_ibfk_4` FOREIGN KEY (`dst_column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE; -- -- Constraints for table `column_has_restrictions` -- ALTER TABLE `column_has_restrictions` ADD CONSTRAINT `column_has_restrictions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `column_has_restrictions_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `project_has_roles` (`role_id`) ON DELETE CASCADE, ADD CONSTRAINT `column_has_restrictions_ibfk_3` FOREIGN KEY (`column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE; -- -- Constraints for table `comments` -- ALTER TABLE `comments` ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `custom_filters` -- ALTER TABLE `custom_filters` ADD CONSTRAINT `custom_filters_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `custom_filters_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `group_has_users` -- ALTER TABLE `group_has_users` ADD CONSTRAINT `group_has_users_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `group_has_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `last_logins` -- ALTER TABLE `last_logins` ADD CONSTRAINT `last_logins_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `password_reset` -- ALTER TABLE `password_reset` ADD CONSTRAINT `password_reset_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `predefined_task_descriptions` -- ALTER TABLE `predefined_task_descriptions` ADD CONSTRAINT `predefined_task_descriptions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_activities` -- ALTER TABLE `project_activities` ADD CONSTRAINT `project_activities_ibfk_1` FOREIGN KEY (`creator_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_activities_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_activities_ibfk_3` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_daily_column_stats` -- ALTER TABLE `project_daily_column_stats` ADD CONSTRAINT `project_daily_column_stats_ibfk_1` FOREIGN KEY (`column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_daily_column_stats_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_daily_stats` -- ALTER TABLE `project_daily_stats` ADD CONSTRAINT `project_daily_stats_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_has_categories` -- ALTER TABLE `project_has_categories` ADD CONSTRAINT `project_has_categories_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_has_files` -- ALTER TABLE `project_has_files` ADD CONSTRAINT `project_has_files_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_has_groups` -- ALTER TABLE `project_has_groups` ADD CONSTRAINT `project_has_groups_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_has_groups_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_has_metadata` -- ALTER TABLE `project_has_metadata` ADD CONSTRAINT `project_has_metadata_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_has_notification_types` -- ALTER TABLE `project_has_notification_types` ADD CONSTRAINT `project_has_notification_types_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_has_roles` -- ALTER TABLE `project_has_roles` ADD CONSTRAINT `project_has_roles_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_has_users` -- ALTER TABLE `project_has_users` ADD CONSTRAINT `project_has_users_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_has_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_role_has_restrictions` -- ALTER TABLE `project_role_has_restrictions` ADD CONSTRAINT `project_role_has_restrictions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_role_has_restrictions_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `project_has_roles` (`role_id`) ON DELETE CASCADE; -- -- Constraints for table `remember_me` -- ALTER TABLE `remember_me` ADD CONSTRAINT `remember_me_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `subtasks` -- ALTER TABLE `subtasks` ADD CONSTRAINT `subtasks_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `subtask_time_tracking` -- ALTER TABLE `subtask_time_tracking` ADD CONSTRAINT `subtask_time_tracking_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `subtask_time_tracking_ibfk_2` FOREIGN KEY (`subtask_id`) REFERENCES `subtasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `swimlanes` -- ALTER TABLE `swimlanes` ADD CONSTRAINT `swimlanes_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `tasks` -- ALTER TABLE `tasks` ADD CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `tasks_ibfk_2` FOREIGN KEY (`column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `tasks_swimlane_ibfk_1` FOREIGN KEY (`swimlane_id`) REFERENCES `swimlanes` (`id`) ON DELETE CASCADE; -- -- Constraints for table `task_has_external_links` -- ALTER TABLE `task_has_external_links` ADD CONSTRAINT `task_has_external_links_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `task_has_files` -- ALTER TABLE `task_has_files` ADD CONSTRAINT `task_has_files_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `task_has_links` -- ALTER TABLE `task_has_links` ADD CONSTRAINT `task_has_links_ibfk_1` FOREIGN KEY (`link_id`) REFERENCES `links` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `task_has_links_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `task_has_links_ibfk_3` FOREIGN KEY (`opposite_task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `task_has_metadata` -- ALTER TABLE `task_has_metadata` ADD CONSTRAINT `task_has_metadata_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `task_has_tags` -- ALTER TABLE `task_has_tags` ADD CONSTRAINT `task_has_tags_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `task_has_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transitions` -- ALTER TABLE `transitions` ADD CONSTRAINT `transitions_ibfk_1` FOREIGN KEY (`src_column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transitions_ibfk_2` FOREIGN KEY (`dst_column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transitions_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transitions_ibfk_4` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transitions_ibfk_5` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `user_has_metadata` -- ALTER TABLE `user_has_metadata` ADD CONSTRAINT `user_has_metadata_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `user_has_notifications` -- ALTER TABLE `user_has_notifications` ADD CONSTRAINT `user_has_notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `user_has_notifications_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `user_has_notification_types` -- ALTER TABLE `user_has_notification_types` ADD CONSTRAINT `user_has_notification_types_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `user_has_unread_notifications` -- ALTER TABLE `user_has_unread_notifications` ADD CONSTRAINT `user_has_unread_notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; /*!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 */;