diff options
| author | Julian Maurice <julian.maurice@biblibre.com> | 2018-08-09 21:35:11 +0200 |
|---|---|---|
| committer | Julian Maurice <julian.maurice@biblibre.com> | 2018-08-11 10:15:13 +0200 |
| commit | 9d4cd31e1aae02e9980932c67036fdfe574e3432 (patch) | |
| tree | 6fca71d93aaed9032a0d771a0b8111d79fdc99b6 /app/Schema/Sql | |
| parent | ae3ade0908bae350488260ee5d878a2ffbff605a (diff) | |
Allow to associate tags to colors
The color is then used as background in the board, list and task details
views
Diffstat (limited to 'app/Schema/Sql')
| -rw-r--r-- | app/Schema/Sql/mysql.sql | 1 | ||||
| -rw-r--r-- | app/Schema/Sql/postgres.sql | 3 |
2 files changed, 3 insertions, 1 deletions
diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql index b626013a..6bf6773f 100644 --- a/app/Schema/Sql/mysql.sql +++ b/app/Schema/Sql/mysql.sql @@ -522,6 +522,7 @@ CREATE TABLE `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, + `color_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `project_id` (`project_id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql index c0ea275b..68f78b27 100644 --- a/app/Schema/Sql/postgres.sql +++ b/app/Schema/Sql/postgres.sql @@ -927,7 +927,8 @@ ALTER SEQUENCE "swimlanes_id_seq" OWNED BY "swimlanes"."id"; CREATE TABLE "tags" ( "id" integer NOT NULL, "name" character varying(255) NOT NULL, - "project_id" integer NOT NULL + "project_id" integer NOT NULL, + "color_id" character varying(255) ); |