From 48e199eff5fca8f5e4aa71a4091d3ae7acc82b9b Mon Sep 17 00:00:00 2001
From: Joel Klinghed <the_jk@spawned.biz>
Date: Mon, 30 Dec 2024 22:54:26 +0100
Subject: Add methods for modifying projects

While doing that I realized I had forgotten to declare maintainers
for projects. Also added default roles and changed so that review_users
only contains overrides, so that changes to the project users is
instantly applied to all reviews (unless there is an override).
---
 server/migrations/eyeballs.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'server/migrations/eyeballs.sql')

diff --git a/server/migrations/eyeballs.sql b/server/migrations/eyeballs.sql
index 9699e6c..aeb1470 100644
--- a/server/migrations/eyeballs.sql
+++ b/server/migrations/eyeballs.sql
@@ -14,6 +14,8 @@ CREATE TABLE IF NOT EXISTS users (
 CREATE TABLE IF NOT EXISTS project_users (
        project BIGINT UNSIGNED NOT NULL,
        user BIGINT UNSIGNED NOT NULL,
+       default_role TINYINT UNSIGNED NOT NULL,
+       maintainer BOOLEAN NOT NULL DEFAULT 0,
        PRIMARY KEY (project, user),
 
        CONSTRAINT `fk_project_users_project`
-- 
cgit v1.2.3-70-g09d2

