From 48e199eff5fca8f5e4aa71a4091d3ae7acc82b9b Mon Sep 17 00:00:00 2001 From: Joel Klinghed 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') 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