2 files changed, 3 insertions, 1 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`),
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)
 );