srdusr
aboutsummaryrefslogtreecommitdiffstats
path: root/crates/server/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'crates/server/migrations')
-rw-r--r--crates/server/migrations/0011_admin.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/crates/server/migrations/0011_admin.sql b/crates/server/migrations/0011_admin.sql
new file mode 100644
index 0000000..d2dda42
--- /dev/null
+++ b/crates/server/migrations/0011_admin.sql
@@ -0,0 +1,4 @@
+- Moderators are appointed by an administrator rather than by editing the
+- database by hand. The first administrator is named by TYPERPUNK_ADMIN_USERNAME
+- at startup, which is the only way in that does not require a running admin.
+ALTER TABLE users ADD COLUMN is_admin BOOLEAN NOT NULL DEFAULT FALSE;