From ae3ade0908bae350488260ee5d878a2ffbff605a Mon Sep 17 00:00:00 2001
From: Julian Maurice <julian.maurice@biblibre.com>
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 +
 1 file changed, 1 insertion(+)

(limited to 'app/Schema/Sql/mysql.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`),
-- 
cgit v1.2.3

