diff options
Diffstat (limited to 'app/Schema/Sql/mysql.sql')
| -rw-r--r-- | app/Schema/Sql/mysql.sql | 524 |
1 files changed, 524 insertions, 0 deletions
diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql new file mode 100644 index 00000000..a4e0a7ff --- /dev/null +++ b/app/Schema/Sql/mysql.sql @@ -0,0 +1,524 @@ + +/*!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 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; +DROP TABLE IF EXISTS `action_has_params`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `action_has_params` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `action_id` int(11) NOT NULL, + `name` varchar(50) NOT NULL, + `value` varchar(50) NOT NULL, + PRIMARY KEY (`id`), + KEY `action_id` (`action_id`), + CONSTRAINT `action_has_params_ibfk_1` FOREIGN KEY (`action_id`) REFERENCES `actions` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `actions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `actions` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `project_id` int(11) NOT NULL, + `event_name` varchar(50) NOT NULL, + `action_name` varchar(50) NOT NULL, + PRIMARY KEY (`id`), + KEY `project_id` (`project_id`), + CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `columns`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `columns` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` varchar(255) NOT NULL, + `position` int(11) NOT NULL, + `project_id` int(11) NOT NULL, + `task_limit` int(11) DEFAULT '0', + `description` text, + PRIMARY KEY (`id`), + UNIQUE KEY `idx_title_project` (`title`,`project_id`), + KEY `columns_project_idx` (`project_id`), + CONSTRAINT `columns_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `comments`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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` text, + `reference` varchar(50) DEFAULT '', + PRIMARY KEY (`id`), + KEY `user_id` (`user_id`), + KEY `comments_reference_idx` (`reference`), + KEY `comments_task_idx` (`task_id`), + CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `currencies`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `currencies` ( + `currency` char(3) NOT NULL, + `rate` float DEFAULT '0', + UNIQUE KEY `currency` (`currency`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `custom_filters`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `custom_filters` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `filter` varchar(100) NOT NULL, + `project_id` int(11) NOT NULL, + `user_id` int(11) NOT NULL, + `name` varchar(100) NOT NULL, + `is_shared` tinyint(1) DEFAULT '0', + PRIMARY KEY (`id`), + KEY `project_id` (`project_id`), + KEY `user_id` (`user_id`), + CONSTRAINT `custom_filters_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, + CONSTRAINT `custom_filters_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `files`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `files` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `name` varchar(255) NOT NULL, + `path` varchar(255) DEFAULT 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`), + CONSTRAINT `files_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `last_logins`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `last_logins` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `auth_type` varchar(25) DEFAULT NULL, + `user_id` int(11) DEFAULT NULL, + `ip` varchar(40) DEFAULT NULL, + `user_agent` varchar(255) DEFAULT NULL, + `date_creation` bigint(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `user_id` (`user_id`), + CONSTRAINT `last_logins_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `links`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `links` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `label` varchar(255) NOT NULL, + `opposite_id` int(11) DEFAULT '0', + PRIMARY KEY (`id`), + UNIQUE KEY `label` (`label`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `plugin_schema_versions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `plugin_schema_versions` ( + `plugin` varchar(80) NOT NULL, + `version` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`plugin`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `project_activities`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `project_activities` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `date_creation` bigint(20) DEFAULT NULL, + `event_name` varchar(50) NOT NULL, + `creator_id` int(11) DEFAULT NULL, + `project_id` int(11) DEFAULT NULL, + `task_id` int(11) DEFAULT NULL, + `data` text, + PRIMARY KEY (`id`), + KEY `creator_id` (`creator_id`), + KEY `project_id` (`project_id`), + KEY `task_id` (`task_id`), + CONSTRAINT `project_activities_ibfk_1` FOREIGN KEY (`creator_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, + CONSTRAINT `project_activities_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, + CONSTRAINT `project_activities_ibfk_3` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `project_daily_column_stats`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `project_daily_column_stats` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `day` char(10) 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`), + CONSTRAINT `project_daily_column_stats_ibfk_1` FOREIGN KEY (`column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, + CONSTRAINT `project_daily_column_stats_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `project_daily_stats`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `project_daily_stats` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `day` char(10) 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`), + CONSTRAINT `project_daily_stats_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `project_has_categories`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `project_has_categories` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `name` varchar(255) NOT NULL, + `project_id` int(11) NOT NULL, + `description` text, + PRIMARY KEY (`id`), + UNIQUE KEY `idx_project_category` (`project_id`,`name`), + KEY `categories_project_idx` (`project_id`), + CONSTRAINT `project_has_categories_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `project_has_users`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `project_has_users` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `project_id` int(11) NOT NULL, + `user_id` int(11) NOT NULL, + `is_owner` tinyint(1) DEFAULT '0', + PRIMARY KEY (`id`), + UNIQUE KEY `idx_project_user` (`project_id`,`user_id`), + KEY `user_id` (`user_id`), + CONSTRAINT `project_has_users_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, + CONSTRAINT `project_has_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `project_integrations`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `project_integrations` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `project_id` int(11) NOT NULL, + `hipchat` tinyint(1) DEFAULT '0', + `hipchat_api_url` varchar(255) DEFAULT 'https://api.hipchat.com', + `hipchat_room_id` varchar(255) DEFAULT NULL, + `hipchat_room_token` varchar(255) DEFAULT NULL, + `slack` tinyint(1) DEFAULT '0', + `slack_webhook_url` varchar(255) DEFAULT NULL, + `jabber` int(11) DEFAULT '0', + `jabber_server` varchar(255) DEFAULT '', + `jabber_domain` varchar(255) DEFAULT '', + `jabber_username` varchar(255) DEFAULT '', + `jabber_password` varchar(255) DEFAULT '', + `jabber_nickname` varchar(255) DEFAULT 'kanboard', + `jabber_room` varchar(255) DEFAULT '', + `slack_webhook_channel` varchar(255) DEFAULT '', + PRIMARY KEY (`id`), + UNIQUE KEY `project_id` (`project_id`), + CONSTRAINT `project_integrations_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `projects`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `projects` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `name` varchar(255) NOT NULL, + `is_active` tinyint(4) DEFAULT '1', + `token` varchar(255) DEFAULT NULL, + `last_modified` bigint(20) DEFAULT NULL, + `is_public` tinyint(1) DEFAULT '0', + `is_private` tinyint(1) DEFAULT '0', + `is_everybody_allowed` tinyint(1) DEFAULT '0', + `default_swimlane` varchar(200) DEFAULT 'Default swimlane', + `show_default_swimlane` int(11) DEFAULT '1', + `description` text, + `identifier` varchar(50) DEFAULT '', + `start_date` varchar(10) DEFAULT '', + `end_date` varchar(10) DEFAULT '', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`), + UNIQUE KEY `name_2` (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `remember_me`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `remember_me` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `user_id` int(11) DEFAULT NULL, + `ip` varchar(40) DEFAULT NULL, + `user_agent` varchar(255) DEFAULT NULL, + `token` varchar(255) DEFAULT NULL, + `sequence` varchar(255) DEFAULT NULL, + `expiration` int(11) DEFAULT NULL, + `date_creation` bigint(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `user_id` (`user_id`), + CONSTRAINT `remember_me_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `schema_version`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `schema_version` ( + `version` int(11) DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `settings`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `settings` ( + `option` varchar(100) NOT NULL, + `value` varchar(255) DEFAULT '', + PRIMARY KEY (`option`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `subtask_time_tracking`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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`), + CONSTRAINT `subtask_time_tracking_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, + CONSTRAINT `subtask_time_tracking_ibfk_2` FOREIGN KEY (`subtask_id`) REFERENCES `subtasks` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `subtasks`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `subtasks` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` varchar(255) 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`), + CONSTRAINT `subtasks_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `swimlanes`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `swimlanes` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `name` varchar(200) NOT NULL, + `position` int(11) DEFAULT '1', + `is_active` int(11) DEFAULT '1', + `project_id` int(11) DEFAULT NULL, + `description` text, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`,`project_id`), + KEY `swimlanes_project_idx` (`project_id`), + CONSTRAINT `swimlanes_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `task_has_links`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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`), + CONSTRAINT `task_has_links_ibfk_1` FOREIGN KEY (`link_id`) REFERENCES `links` (`id`) ON DELETE CASCADE, + CONSTRAINT `task_has_links_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE, + CONSTRAINT `task_has_links_ibfk_3` FOREIGN KEY (`opposite_task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `tasks`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `tasks` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` varchar(255) NOT NULL, + `description` text, + `date_creation` bigint(20) DEFAULT NULL, + `date_completed` bigint(20) DEFAULT NULL, + `date_due` bigint(20) DEFAULT NULL, + `color_id` varchar(50) 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(50) DEFAULT '', + `date_started` bigint(20) DEFAULT NULL, + `time_spent` float DEFAULT '0', + `time_estimated` float DEFAULT '0', + `swimlane_id` int(11) DEFAULT '0', + `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, + 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`), + CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, + CONSTRAINT `tasks_ibfk_2` FOREIGN KEY (`column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `transitions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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`), + CONSTRAINT `transitions_ibfk_1` FOREIGN KEY (`src_column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, + CONSTRAINT `transitions_ibfk_2` FOREIGN KEY (`dst_column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, + CONSTRAINT `transitions_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, + CONSTRAINT `transitions_ibfk_4` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, + CONSTRAINT `transitions_ibfk_5` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `user_has_notification_types`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `user_has_notification_types` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `user_id` int(11) NOT NULL, + `notification_type` varchar(50) DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `user_has_notification_types_user_idx` (`user_id`,`notification_type`), + CONSTRAINT `user_has_notification_types_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `user_has_notifications`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `user_has_notifications` ( + `user_id` int(11) NOT NULL, + `project_id` int(11) NOT NULL, + UNIQUE KEY `project_id` (`project_id`,`user_id`), + KEY `user_id` (`user_id`), + CONSTRAINT `user_has_notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, + CONSTRAINT `user_has_notifications_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `user_has_unread_notifications`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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` varchar(50) NOT NULL, + `event_data` text NOT NULL, + PRIMARY KEY (`id`), + KEY `user_id` (`user_id`), + CONSTRAINT `user_has_unread_notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `users`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `users` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `username` varchar(50) NOT NULL, + `password` varchar(255) DEFAULT NULL, + `is_admin` tinyint(4) DEFAULT '0', + `is_ldap_user` tinyint(1) DEFAULT '0', + `name` varchar(255) DEFAULT NULL, + `email` varchar(255) DEFAULT NULL, + `google_id` varchar(30) DEFAULT NULL, + `github_id` varchar(30) DEFAULT NULL, + `notifications_enabled` tinyint(1) DEFAULT '0', + `timezone` varchar(50) DEFAULT NULL, + `language` char(5) DEFAULT NULL, + `disable_login_form` tinyint(1) DEFAULT '0', + `twofactor_activated` tinyint(1) DEFAULT '0', + `twofactor_secret` char(16) DEFAULT NULL, + `token` varchar(255) DEFAULT '', + `notifications_filter` int(11) DEFAULT '4', + `nb_failed_login` int(11) DEFAULT '0', + `lock_expiration_date` bigint(20) DEFAULT NULL, + `is_project_admin` int(11) DEFAULT '0', + `gitlab_id` int(11) DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `users_username_idx` (`username`), + KEY `users_admin_idx` (`is_admin`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!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 */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$BBxt.HuQCFur7qhICY22i.A6OKyce0KGqmMEWq3JdGT4WcEKCBWP.', '1');INSERT INTO schema_version VALUES ('90'); |