From dd92564d221f35fc4fc7bb449c6d24cc4743247b Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Wed, 11 Apr 2018 12:03:38 -0700 Subject: Increase text fields length in several tables --- app/Schema/Postgres.php | 30 +++++++++++++++++++++++++++++- 1 file changed, 29 insertions(+), 1 deletion(-) (limited to 'app/Schema/Postgres.php') 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) { -- cgit v1.2.3