diff options
| author | Julian Maurice <julian.maurice@biblibre.com> | 2018-08-09 19:45:51 +0200 |
|---|---|---|
| committer | Julian Maurice <julian.maurice@biblibre.com> | 2018-08-09 19:45:51 +0200 |
| commit | ae3ade0908bae350488260ee5d878a2ffbff605a (patch) | |
| tree | 747db7edaca2fcb6d3c23594437b995528790ced /app/Schema/Sql/mysql.sql | |
| parent | efd64d842d82404612baef58d9debe1af7515a66 (diff) | |
Allow to associate project categories to colors
The color is then used as background in the board and list views
Diffstat (limited to 'app/Schema/Sql/mysql.sql')
| -rw-r--r-- | app/Schema/Sql/mysql.sql | 1 |
1 files changed, 1 insertions, 0 deletions
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`), |