From ae3ade0908bae350488260ee5d878a2ffbff605a Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Thu, 9 Aug 2018 19:45:51 +0200 Subject: Allow to associate project categories to colors The color is then used as background in the board and list views --- app/Schema/Sql/mysql.sql | 1 + app/Schema/Sql/postgres.sql | 3 ++- 2 files changed, 3 insertions(+), 1 deletion(-) (limited to 'app/Schema/Sql') diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql index fba959a9..b626013a 100644 --- a/app/Schema/Sql/mysql.sql +++ b/app/Schema/Sql/mysql.sql @@ -294,6 +294,7 @@ CREATE TABLE `project_has_categories` ( `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`), diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql index 5a2224fb..c0ea275b 100644 --- a/app/Schema/Sql/postgres.sql +++ b/app/Schema/Sql/postgres.sql @@ -542,7 +542,8 @@ CREATE TABLE "project_has_categories" ( "id" integer NOT NULL, "name" character varying(255) NOT NULL, "project_id" integer NOT NULL, - "description" "text" + "description" "text", + "color_id" character varying(255) ); -- cgit v1.2.3