Increase text fields length in several tables

5 files changed, 118 insertions, 62 deletions

diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index b73ce8c0..6adcaec1 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -8,7 +8,35 @@ use PDO;
 use Kanboard\Core\Security\Token;
 use Kanboard\Core\Security\Role;
 
-const VERSION = 128;
+const VERSION = 129;
+
+function version_129(PDO $pdo)
+{
+    $pdo->exec('ALTER TABLE `projects` MODIFY `name` TEXT NOT NULL');
+    $pdo->exec('ALTER TABLE `projects` MODIFY `email` TEXT');
+    $pdo->exec('ALTER TABLE `action_has_params` MODIFY `name` TEXT NOT NULL');
+    $pdo->exec('ALTER TABLE `action_has_params` MODIFY `value` TEXT NOT NULL');
+    $pdo->exec('ALTER TABLE `actions` MODIFY `event_name` TEXT NOT NULL');
+    $pdo->exec('ALTER TABLE `actions` MODIFY `action_name` TEXT NOT NULL');
+    $pdo->exec("ALTER TABLE `comments` MODIFY `reference` VARCHAR(255) DEFAULT ''");
+    $pdo->exec("ALTER TABLE `custom_filters` MODIFY `filter` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `custom_filters` MODIFY `name` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `groups` MODIFY `name` VARCHAR(255) NOT NULL");
+    $pdo->exec("ALTER TABLE `project_activities` MODIFY `event_name` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `project_has_files` MODIFY `name` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `project_has_files` MODIFY `path` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `subtasks` MODIFY `title` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `swimlanes` MODIFY `name` VARCHAR(255) NOT NULL");
+    $pdo->exec("ALTER TABLE `task_has_external_links` MODIFY `title` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `task_has_external_links` MODIFY `url` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `task_has_files` MODIFY `name` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `task_has_files` MODIFY `path` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `tasks` MODIFY `title` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `tasks` MODIFY `reference` VARCHAR(255) DEFAULT ''");
+    $pdo->exec("ALTER TABLE `user_has_unread_notifications` MODIFY `event_name` TEXT NOT NULL");
+    $pdo->exec("ALTER TABLE `users` MODIFY `username` VARCHAR(255) NOT NULL");
+    $pdo->exec("ALTER TABLE `users` MODIFY `filter` TEXT");
+}
 
 function version_128(PDO $pdo)
 {
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index 50ea4850..598ea115 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -8,7 +8,35 @@ use PDO;
 use Kanboard\Core\Security\Token;
 use Kanboard\Core\Security\Role;
 
-const VERSION = 107;
+const VERSION = 108;
+
+function version_108(PDO $pdo)
+{
+    $pdo->exec('ALTER TABLE "projects" ALTER COLUMN "name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "projects" ALTER COLUMN "email" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "action_has_params" ALTER COLUMN "name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "action_has_params" ALTER COLUMN "value" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "actions" ALTER COLUMN "event_name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "actions" ALTER COLUMN "action_name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "comments" ALTER COLUMN "reference" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "custom_filters" ALTER COLUMN "filter" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "custom_filters" ALTER COLUMN "name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "groups" ALTER COLUMN "name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "project_activities" ALTER COLUMN "event_name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "project_has_files" ALTER COLUMN "name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "project_has_files" ALTER COLUMN "path" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "subtasks" ALTER COLUMN "title" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "swimlanes" ALTER COLUMN "name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "task_has_external_links" ALTER COLUMN "title" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "task_has_external_links" ALTER COLUMN "url" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "task_has_files" ALTER COLUMN "name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "task_has_files" ALTER COLUMN "path" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "tasks" ALTER COLUMN "title" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "tasks" ALTER COLUMN "reference" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "user_has_unread_notifications" ALTER COLUMN "event_name" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "users" ALTER COLUMN "username" TYPE TEXT');
+    $pdo->exec('ALTER TABLE "users" ALTER COLUMN "filter" TYPE TEXT');
+}
 
 function version_107(PDO $pdo)
 {
diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql
index 199fd797..3113b4e6 100644
--- a/app/Schema/Sql/mysql.sql
+++ b/app/Schema/Sql/mysql.sql
@@ -15,8 +15,8 @@ DROP TABLE IF EXISTS `action_has_params`;
 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,
+  `name` text NOT NULL,
+  `value` text 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
@@ -28,8 +28,8 @@ DROP TABLE IF EXISTS `actions`;
 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(255) DEFAULT NULL,
+  `event_name` text NOT NULL,
+  `action_name` text NOT NULL,
   PRIMARY KEY (`id`),
   KEY `project_id` (`project_id`),
   CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
@@ -100,7 +100,7 @@ CREATE TABLE `comments` (
   `user_id` int(11) DEFAULT '0',
   `date_creation` bigint(20) DEFAULT NULL,
   `comment` text,
-  `reference` varchar(50) DEFAULT '',
+  `reference` varchar(255) DEFAULT '',
   `date_modification` bigint(20) DEFAULT NULL,
   PRIMARY KEY (`id`),
   KEY `user_id` (`user_id`),
@@ -123,10 +123,10 @@ DROP TABLE IF EXISTS `custom_filters`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `custom_filters` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `filter` varchar(100) NOT NULL,
+  `filter` text NOT NULL,
   `project_id` int(11) NOT NULL,
   `user_id` int(11) NOT NULL,
-  `name` varchar(100) NOT NULL,
+  `name` text NOT NULL,
   `is_shared` tinyint(1) DEFAULT '0',
   `append` tinyint(1) DEFAULT '0',
   PRIMARY KEY (`id`),
@@ -154,7 +154,7 @@ DROP TABLE IF EXISTS `groups`;
 CREATE TABLE `groups` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `external_id` varchar(255) DEFAULT '',
-  `name` varchar(100) NOT NULL,
+  `name` varchar(255) NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `name` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -239,7 +239,7 @@ DROP TABLE IF EXISTS `project_activities`;
 CREATE TABLE `project_activities` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `date_creation` bigint(20) DEFAULT NULL,
-  `event_name` varchar(50) NOT NULL,
+  `event_name` text NOT NULL,
   `creator_id` int(11) DEFAULT NULL,
   `project_id` int(11) DEFAULT NULL,
   `task_id` int(11) DEFAULT NULL,
@@ -306,8 +306,8 @@ DROP TABLE IF EXISTS `project_has_files`;
 CREATE TABLE `project_has_files` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `project_id` int(11) NOT NULL,
-  `name` varchar(255) NOT NULL,
-  `path` varchar(255) NOT NULL,
+  `name` text NOT NULL,
+  `path` text NOT NULL,
   `is_image` tinyint(1) DEFAULT '0',
   `size` int(11) NOT NULL DEFAULT '0',
   `user_id` int(11) NOT NULL DEFAULT '0',
@@ -400,7 +400,7 @@ DROP TABLE IF EXISTS `projects`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `projects` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `name` varchar(255) NOT NULL,
+  `name` text NOT NULL,
   `is_active` tinyint(4) DEFAULT '1',
   `token` varchar(255) DEFAULT NULL,
   `last_modified` bigint(20) DEFAULT NULL,
@@ -414,7 +414,7 @@ CREATE TABLE `projects` (
   `priority_default` int(11) DEFAULT '0',
   `priority_start` int(11) DEFAULT '0',
   `priority_end` int(11) DEFAULT '3',
-  `email` varchar(255) DEFAULT NULL,
+  `email` text,
   `predefined_email_subjects` text,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -486,7 +486,7 @@ DROP TABLE IF EXISTS `subtasks`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `subtasks` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `title` varchar(255) NOT NULL,
+  `title` text NOT NULL,
   `status` int(11) DEFAULT '0',
   `time_estimated` float DEFAULT NULL,
   `time_spent` float DEFAULT NULL,
@@ -503,7 +503,7 @@ DROP TABLE IF EXISTS `swimlanes`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `swimlanes` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `name` varchar(200) NOT NULL,
+  `name` varchar(255) NOT NULL,
   `position` int(11) DEFAULT '1',
   `is_active` int(11) DEFAULT '1',
   `project_id` int(11) DEFAULT NULL,
@@ -532,8 +532,8 @@ CREATE TABLE `task_has_external_links` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `link_type` varchar(100) NOT NULL,
   `dependency` varchar(100) NOT NULL,
-  `title` varchar(255) NOT NULL,
-  `url` varchar(255) NOT NULL,
+  `title` text NOT NULL,
+  `url` text NOT NULL,
   `date_creation` int(11) NOT NULL,
   `date_modification` int(11) NOT NULL,
   `task_id` int(11) NOT NULL,
@@ -548,8 +548,8 @@ DROP TABLE IF EXISTS `task_has_files`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `task_has_files` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `name` varchar(255) NOT NULL,
-  `path` varchar(255) DEFAULT NULL,
+  `name` text NOT NULL,
+  `path` text NOT NULL,
   `is_image` tinyint(1) DEFAULT '0',
   `task_id` int(11) NOT NULL,
   `date` bigint(20) DEFAULT NULL,
@@ -607,7 +607,7 @@ DROP TABLE IF EXISTS `tasks`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `tasks` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `title` varchar(255) NOT NULL,
+  `title` text NOT NULL,
   `description` text,
   `date_creation` bigint(20) DEFAULT NULL,
   `date_completed` bigint(20) DEFAULT NULL,
@@ -622,7 +622,7 @@ CREATE TABLE `tasks` (
   `category_id` int(11) DEFAULT '0',
   `creator_id` int(11) DEFAULT '0',
   `date_modification` int(11) DEFAULT '0',
-  `reference` varchar(50) DEFAULT '',
+  `reference` varchar(255) DEFAULT '',
   `date_started` bigint(20) DEFAULT NULL,
   `time_spent` float DEFAULT '0',
   `time_estimated` float DEFAULT '0',
@@ -718,7 +718,7 @@ 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_name` text NOT NULL,
   `event_data` text NOT NULL,
   PRIMARY KEY (`id`),
   KEY `user_id` (`user_id`),
@@ -730,7 +730,7 @@ DROP TABLE IF EXISTS `users`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `users` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `username` varchar(50) NOT NULL,
+  `username` varchar(255) NOT NULL,
   `password` varchar(255) DEFAULT NULL,
   `is_ldap_user` tinyint(1) DEFAULT '0',
   `name` varchar(255) DEFAULT NULL,
@@ -752,7 +752,7 @@ CREATE TABLE `users` (
   `is_active` tinyint(1) DEFAULT '1',
   `avatar_path` varchar(255) DEFAULT NULL,
   `api_access_token` varchar(255) DEFAULT NULL,
-  `filter` varchar(255) DEFAULT NULL,
+  `filter` text,
   PRIMARY KEY (`id`),
   UNIQUE KEY `users_username_idx` (`username`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -776,7 +776,7 @@ CREATE TABLE `users` (
 
 LOCK TABLES `settings` WRITE;
 /*!40000 ALTER TABLE `settings` DISABLE KEYS */;
-INSERT INTO `settings` VALUES ('api_token','36e88ee4ad58bc71a7879d8cadac15142fdd25550f4910b8ec8c7525730c',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','99225408c1094eead14b25dbe9f7254ec233bd54aea02b8dff7e7d25ae50',0,0),('webhook_url','',0,0);
+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);
 /*!40000 ALTER TABLE `settings` ENABLE KEYS */;
 UNLOCK TABLES;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -805,4 +805,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$j/bvk6WblIHAyAJEBXLgBeoOjJ1oHsuA0VTUf85lRYOJ4czssCuI6', 'app-admin');INSERT INTO schema_version VALUES ('127');
+INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$eu5txjAlmBRZYmAcWjHAx.BSCIYL6RMTIyrIWG4eqWFtf62DCJPWy', 'app-admin');INSERT INTO schema_version VALUES ('129');
diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql
index e43248c3..5a2224fb 100644
--- a/app/Schema/Sql/postgres.sql
+++ b/app/Schema/Sql/postgres.sql
@@ -2,8 +2,8 @@
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 9.6.4
--- Dumped by pg_dump version 9.6.4
+-- Dumped from database version 9.6.3
+-- Dumped by pg_dump version 9.6.3
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
@@ -33,8 +33,8 @@ SET default_with_oids = false;
 CREATE TABLE "action_has_params" (
     "id" integer NOT NULL,
     "action_id" integer NOT NULL,
-    "name" character varying(50) NOT NULL,
-    "value" character varying(50) NOT NULL
+    "name" "text" NOT NULL,
+    "value" "text" NOT NULL
 );
 
 
@@ -64,8 +64,8 @@ ALTER SEQUENCE "action_has_params_id_seq" OWNED BY "action_has_params"."id";
 CREATE TABLE "actions" (
     "id" integer NOT NULL,
     "project_id" integer NOT NULL,
-    "event_name" character varying(50) NOT NULL,
-    "action_name" character varying(255) NOT NULL
+    "event_name" "text" NOT NULL,
+    "action_name" "text" NOT NULL
 );
 
 
@@ -197,7 +197,7 @@ CREATE TABLE "comments" (
     "user_id" integer DEFAULT 0,
     "date_creation" bigint NOT NULL,
     "comment" "text",
-    "reference" character varying(50) DEFAULT ''::character varying,
+    "reference" "text" DEFAULT ''::character varying,
     "date_modification" bigint
 );
 
@@ -237,10 +237,10 @@ CREATE TABLE "currencies" (
 
 CREATE TABLE "custom_filters" (
     "id" integer NOT NULL,
-    "filter" character varying(100) NOT NULL,
+    "filter" "text" NOT NULL,
     "project_id" integer NOT NULL,
     "user_id" integer NOT NULL,
-    "name" character varying(100) NOT NULL,
+    "name" "text" NOT NULL,
     "is_shared" boolean DEFAULT false,
     "append" boolean DEFAULT false
 );
@@ -282,7 +282,7 @@ CREATE TABLE "group_has_users" (
 CREATE TABLE "groups" (
     "id" integer NOT NULL,
     "external_id" character varying(255) DEFAULT ''::character varying,
-    "name" character varying(100) NOT NULL
+    "name" "text" NOT NULL
 );
 
 
@@ -442,7 +442,7 @@ ALTER SEQUENCE "predefined_task_descriptions_id_seq" OWNED BY "predefined_task_d
 CREATE TABLE "project_activities" (
     "id" integer NOT NULL,
     "date_creation" bigint NOT NULL,
-    "event_name" character varying(50) NOT NULL,
+    "event_name" "text" NOT NULL,
     "creator_id" integer,
     "project_id" integer,
     "task_id" integer,
@@ -572,8 +572,8 @@ ALTER SEQUENCE "project_has_categories_id_seq" OWNED BY "project_has_categories"
 CREATE TABLE "project_has_files" (
     "id" integer NOT NULL,
     "project_id" integer NOT NULL,
-    "name" character varying(255) NOT NULL,
-    "path" character varying(255) NOT NULL,
+    "name" "text" NOT NULL,
+    "path" "text" NOT NULL,
     "is_image" boolean DEFAULT false,
     "size" integer DEFAULT 0 NOT NULL,
     "user_id" integer DEFAULT 0 NOT NULL,
@@ -732,7 +732,7 @@ ALTER SEQUENCE "project_role_has_restrictions_restriction_id_seq" OWNED BY "proj
 
 CREATE TABLE "projects" (
     "id" integer NOT NULL,
-    "name" character varying(255) NOT NULL,
+    "name" "text" NOT NULL,
     "is_active" boolean DEFAULT true,
     "token" character varying(255),
     "last_modified" bigint DEFAULT 0,
@@ -746,7 +746,7 @@ CREATE TABLE "projects" (
     "priority_default" integer DEFAULT 0,
     "priority_start" integer DEFAULT 0,
     "priority_end" integer DEFAULT 3,
-    "email" character varying(255),
+    "email" "text",
     "predefined_email_subjects" "text"
 );
 
@@ -876,7 +876,7 @@ ALTER SEQUENCE "subtask_time_tracking_id_seq" OWNED BY "subtask_time_tracking"."
 
 CREATE TABLE "subtasks" (
     "id" integer NOT NULL,
-    "title" character varying(255) NOT NULL,
+    "title" "text" NOT NULL,
     "status" smallint DEFAULT 0,
     "time_estimated" double precision DEFAULT 0,
     "time_spent" double precision DEFAULT 0,
@@ -892,7 +892,7 @@ CREATE TABLE "subtasks" (
 
 CREATE TABLE "swimlanes" (
     "id" integer NOT NULL,
-    "name" character varying(200) NOT NULL,
+    "name" "text" NOT NULL,
     "position" integer DEFAULT 1,
     "is_active" boolean DEFAULT true,
     "project_id" integer,
@@ -957,8 +957,8 @@ CREATE TABLE "task_has_external_links" (
     "id" integer NOT NULL,
     "link_type" character varying(100) NOT NULL,
     "dependency" character varying(100) NOT NULL,
-    "title" character varying(255) NOT NULL,
-    "url" character varying(255) NOT NULL,
+    "title" "text" NOT NULL,
+    "url" "text" NOT NULL,
     "date_creation" integer NOT NULL,
     "date_modification" integer NOT NULL,
     "task_id" integer NOT NULL,
@@ -991,8 +991,8 @@ ALTER SEQUENCE "task_has_external_links_id_seq" OWNED BY "task_has_external_link
 
 CREATE TABLE "task_has_files" (
     "id" integer NOT NULL,
-    "name" character varying(255) NOT NULL,
-    "path" character varying(255),
+    "name" "text" NOT NULL,
+    "path" "text",
     "is_image" boolean DEFAULT false,
     "task_id" integer NOT NULL,
     "date" bigint DEFAULT 0 NOT NULL,
@@ -1099,7 +1099,7 @@ CREATE TABLE "task_has_tags" (
 
 CREATE TABLE "tasks" (
     "id" integer NOT NULL,
-    "title" character varying(255) NOT NULL,
+    "title" "text" NOT NULL,
     "description" "text",
     "date_creation" bigint,
     "color_id" character varying(255),
@@ -1114,7 +1114,7 @@ CREATE TABLE "tasks" (
     "category_id" integer DEFAULT 0,
     "creator_id" integer DEFAULT 0,
     "date_modification" integer DEFAULT 0,
-    "reference" character varying(50) DEFAULT ''::character varying,
+    "reference" "text" DEFAULT ''::character varying,
     "date_started" bigint,
     "time_spent" double precision DEFAULT 0,
     "time_estimated" double precision DEFAULT 0,
@@ -1248,7 +1248,7 @@ CREATE TABLE "user_has_unread_notifications" (
     "id" integer NOT NULL,
     "user_id" integer NOT NULL,
     "date_creation" bigint NOT NULL,
-    "event_name" character varying(50) NOT NULL,
+    "event_name" "text" NOT NULL,
     "event_data" "text" NOT NULL
 );
 
@@ -1278,7 +1278,7 @@ ALTER SEQUENCE "user_has_unread_notifications_id_seq" OWNED BY "user_has_unread_
 
 CREATE TABLE "users" (
     "id" integer NOT NULL,
-    "username" character varying(50) NOT NULL,
+    "username" "text" NOT NULL,
     "password" character varying(255),
     "is_ldap_user" boolean DEFAULT false,
     "name" character varying(255),
@@ -1300,7 +1300,7 @@ CREATE TABLE "users" (
     "is_active" boolean DEFAULT true,
     "avatar_path" character varying(255),
     "api_access_token" character varying(255) DEFAULT NULL::character varying,
-    "filter" character varying(255) DEFAULT NULL::character varying
+    "filter" "text" DEFAULT NULL::character varying
 );
 
 
@@ -2624,8 +2624,8 @@ ALTER TABLE ONLY "user_has_unread_notifications"
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 9.6.4
--- Dumped by pg_dump version 9.6.4
+-- Dumped from database version 9.6.3
+-- Dumped by pg_dump version 9.6.3
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
@@ -2645,8 +2645,8 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_high
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_public_refresh_interval', '60', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_private_refresh_interval', '10', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_columns', '', 0, 0);
-INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', '1ff45d3f47d1dc00a9bd51a335d2fe705714e4c4073d486c2c8e6e161c28', 0, 0);
-INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '261e6e871a415183978e3a25f65ddb63c93e680931bef4c6b1728ed1a07c', 0, 0);
+INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', '60a9320b2835f6fa01f6ec445212e3eb6d919887a81a0414d9928d908315', 0, 0);
+INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '5713f6ffb5fdef788497bf45e43cedaeff565135f8ad3a5015ab338f5251', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_language', 'en_US', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_timezone', 'UTC', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_url', '', 0, 0);
@@ -2674,8 +2674,8 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('password_r
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 9.6.4
--- Dumped by pg_dump version 9.6.4
+-- Dumped from database version 9.6.3
+-- Dumped by pg_dump version 9.6.3
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
@@ -2715,4 +2715,4 @@ SELECT pg_catalog.setval('links_id_seq', 11, true);
 -- PostgreSQL database dump complete
 --
 
-INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$j/bvk6WblIHAyAJEBXLgBeoOjJ1oHsuA0VTUf85lRYOJ4czssCuI6', 'app-admin');INSERT INTO schema_version VALUES ('106');
+INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$eu5txjAlmBRZYmAcWjHAx.BSCIYL6RMTIyrIWG4eqWFtf62DCJPWy', 'app-admin');INSERT INTO schema_version VALUES ('108');
diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php
index aced61e0..99731452 100644
--- a/app/Schema/Sqlite.php
+++ b/app/Schema/Sqlite.php
@@ -12,7 +12,7 @@ const VERSION = 118;
 
 function version_118(PDO $pdo)
 {
-    $pdo->exec('ALTER TABLE users ADD COLUMN filter VARCHAR(255) DEFAULT NULL');
+    $pdo->exec('ALTER TABLE users ADD COLUMN filter TEXT');
 }
 
 function version_117(PDO $pdo)