diff options
| author | Joel Klinghed <the_jk@spawned.biz> | 2024-12-30 22:54:26 +0100 |
|---|---|---|
| committer | Joel Klinghed <the_jk@spawned.biz> | 2024-12-30 22:54:26 +0100 |
| commit | 48e199eff5fca8f5e4aa71a4091d3ae7acc82b9b (patch) | |
| tree | 7658a4b55b10293ead1f69e628e9c2731ce6b9f8 /server/migrations/eyeballs.sql | |
| parent | 74538f6e3050e67bd06916a111d55933108036d2 (diff) | |
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).
Diffstat (limited to 'server/migrations/eyeballs.sql')
| -rw-r--r-- | server/migrations/eyeballs.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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` |