diff options
author | Frédéric Guillot <fred@kanboard.net> | 2018-10-10 20:17:19 -0700 |
---|---|---|
committer | Frédéric Guillot <fred@kanboard.net> | 2018-10-10 20:17:19 -0700 |
commit | 00228ac12fedaf436869289c7c114dc6f76dd14c (patch) | |
tree | 390f99b5abbfc009304853789b4e18ead25f972e /app/Schema | |
parent | a165f3acdbcb4f026ab1334bfc27002720d4836f (diff) |
Update ChangeLog and MySQL dump
Diffstat (limited to 'app/Schema')
-rw-r--r-- | app/Schema/Sql/mysql.sql | 106 |
1 files changed, 53 insertions, 53 deletions
diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql index 6bf6773f..ecc072dc 100644 --- a/app/Schema/Sql/mysql.sql +++ b/app/Schema/Sql/mysql.sql @@ -2,7 +2,7 @@ /*!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 */; + SET NAMES utf8mb4 ; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; @@ -11,7 +11,7 @@ /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `action_has_params` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_id` int(11) NOT NULL, @@ -24,7 +24,7 @@ CREATE TABLE `action_has_params` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `actions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, @@ -37,7 +37,7 @@ CREATE TABLE `actions` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `column_has_move_restrictions`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `column_has_move_restrictions` ( `restriction_id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, @@ -58,7 +58,7 @@ CREATE TABLE `column_has_move_restrictions` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `column_has_restrictions`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `column_has_restrictions` ( `restriction_id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, @@ -76,7 +76,7 @@ CREATE TABLE `column_has_restrictions` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `columns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -93,7 +93,7 @@ CREATE TABLE `columns` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `task_id` int(11) NOT NULL, @@ -111,7 +111,7 @@ CREATE TABLE `comments` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `currencies` ( `currency` char(3) COLLATE utf8mb4_unicode_ci NOT NULL, `rate` float DEFAULT '0', @@ -120,7 +120,7 @@ CREATE TABLE `currencies` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `custom_filters` ( `id` int(11) NOT NULL AUTO_INCREMENT, `filter` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, @@ -138,7 +138,7 @@ CREATE TABLE `custom_filters` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `group_has_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `group_has_users` ( `group_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, @@ -150,7 +150,7 @@ CREATE TABLE `group_has_users` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `external_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', @@ -161,7 +161,7 @@ CREATE TABLE `groups` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `invites`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `invites` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, @@ -171,7 +171,7 @@ CREATE TABLE `invites` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `last_logins` ( `id` int(11) NOT NULL AUTO_INCREMENT, `auth_type` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL, @@ -186,7 +186,7 @@ CREATE TABLE `last_logins` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `label` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -197,7 +197,7 @@ CREATE TABLE `links` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `password_reset`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `password_reset` ( `token` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, @@ -213,7 +213,7 @@ CREATE TABLE `password_reset` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `plugin_schema_versions` ( `plugin` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `version` int(11) NOT NULL DEFAULT '0', @@ -222,7 +222,7 @@ CREATE TABLE `plugin_schema_versions` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `predefined_task_descriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `predefined_task_descriptions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, @@ -235,7 +235,7 @@ CREATE TABLE `predefined_task_descriptions` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_activities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date_creation` bigint(20) DEFAULT NULL, @@ -255,7 +255,7 @@ CREATE TABLE `project_activities` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_daily_column_stats` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` char(10) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -273,7 +273,7 @@ CREATE TABLE `project_daily_column_stats` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_daily_stats` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` char(10) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -288,7 +288,7 @@ CREATE TABLE `project_daily_stats` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_has_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -303,7 +303,7 @@ CREATE TABLE `project_has_categories` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `project_has_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_has_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, @@ -320,7 +320,7 @@ CREATE TABLE `project_has_files` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `project_has_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_has_groups` ( `group_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, @@ -333,7 +333,7 @@ CREATE TABLE `project_has_groups` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `project_has_metadata`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_has_metadata` ( `project_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -346,7 +346,7 @@ CREATE TABLE `project_has_metadata` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `project_has_notification_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_has_notification_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, @@ -358,7 +358,7 @@ CREATE TABLE `project_has_notification_types` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `project_has_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_has_roles` ( `role_id` int(11) NOT NULL AUTO_INCREMENT, `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -370,7 +370,7 @@ CREATE TABLE `project_has_roles` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_has_users` ( `project_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, @@ -383,7 +383,7 @@ CREATE TABLE `project_has_users` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `project_role_has_restrictions`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `project_role_has_restrictions` ( `restriction_id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, @@ -398,7 +398,7 @@ CREATE TABLE `project_role_has_restrictions` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `projects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, @@ -422,7 +422,7 @@ CREATE TABLE `projects` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `remember_me` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, @@ -439,14 +439,14 @@ CREATE TABLE `remember_me` ( /*!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 */; + SET character_set_client = utf8mb4 ; 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 `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `sessions` ( `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `expire_at` int(11) NOT NULL, @@ -456,10 +456,10 @@ CREATE TABLE `sessions` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `settings` ( `option` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, - `value` mediumtext COLLATE utf8mb4_unicode_ci, + `value` text COLLATE utf8mb4_unicode_ci, `changed_by` int(11) NOT NULL DEFAULT '0', `changed_on` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`option`) @@ -467,7 +467,7 @@ CREATE TABLE `settings` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `subtask_time_tracking` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, @@ -484,7 +484,7 @@ CREATE TABLE `subtask_time_tracking` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `subtasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, @@ -501,7 +501,7 @@ CREATE TABLE `subtasks` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `swimlanes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -517,7 +517,7 @@ CREATE TABLE `swimlanes` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -529,7 +529,7 @@ CREATE TABLE `tags` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `task_has_external_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `task_has_external_links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `link_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -547,7 +547,7 @@ CREATE TABLE `task_has_external_links` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `task_has_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `task_has_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, @@ -564,7 +564,7 @@ CREATE TABLE `task_has_files` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `task_has_links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `link_id` int(11) NOT NULL, @@ -581,7 +581,7 @@ CREATE TABLE `task_has_links` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `task_has_metadata`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `task_has_metadata` ( `task_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -594,7 +594,7 @@ CREATE TABLE `task_has_metadata` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `task_has_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `task_has_tags` ( `task_id` int(11) NOT NULL, `tag_id` int(11) NOT NULL, @@ -606,7 +606,7 @@ CREATE TABLE `task_has_tags` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `tasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, @@ -653,7 +653,7 @@ CREATE TABLE `tasks` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `transitions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, @@ -678,7 +678,7 @@ CREATE TABLE `transitions` ( /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `user_has_metadata`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `user_has_metadata` ( `user_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -691,7 +691,7 @@ CREATE TABLE `user_has_metadata` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `user_has_notification_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, @@ -703,7 +703,7 @@ CREATE TABLE `user_has_notification_types` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `user_has_notifications` ( `user_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, @@ -715,7 +715,7 @@ CREATE TABLE `user_has_notifications` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `user_has_unread_notifications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, @@ -729,7 +729,7 @@ CREATE TABLE `user_has_unread_notifications` ( /*!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 */; + SET character_set_client = utf8mb4 ; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, @@ -741,7 +741,7 @@ CREATE TABLE `users` ( `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(5) 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, @@ -778,7 +778,7 @@ CREATE TABLE `users` ( LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; -INSERT INTO `settings` VALUES ('api_token','5e51f5e81b816fe52594c692abc6ab51c53024048953e0a312d378ebda7e',0,0),('application_currency','USD',0,0),('application_date_format','m/d/Y',0,0),('application_language','en_US',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','5739f13ff6db190c5983328d7bed8aff703b7e78236890e9030888194121',0,0),('webhook_url','',0,0); +INSERT INTO `settings` VALUES ('api_token','e9b892140931a1b5deb2ab4a5347a65b985ca766c79956e6733529697708',0,0),('application_currency','USD',0,0),('application_date_format','m/d/Y',0,0),('application_language','en_US',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','25b8b8204e355c76e47df6205abfad3925898eaa709a289342bbafa1df87',0,0),('webhook_url','',0,0); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -807,4 +807,4 @@ UNLOCK TABLES; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$wHAStAxKXclzpBY4hRwL0e/LMNpxB5o50qwtO6I4OtJjIfB4stZIO', 'app-admin');INSERT INTO schema_version VALUES ('130'); +INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$I5O18nLDOZ436DXzIRZal.ArrFe69gSMoegHDwV.8lChQHz6K4Kku', 'app-admin');INSERT INTO schema_version VALUES ('133'); |