aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRunxi Yu <me@runxiyu.org>2025-02-12 23:23:47 +0800
committerRunxi Yu <me@runxiyu.org>2025-02-12 23:23:47 +0800
commitdf384aca4ea164a9d63e40facf8ff10fa51f4321 (patch)
tree512c50e579ca78c76ba365efdc54cd0e9cc17dc6
parentrouter_http: Ensure module index has / (diff)
downloadforge-df384aca4ea164a9d63e40facf8ff10fa51f4321.tar.gz
forge-df384aca4ea164a9d63e40facf8ff10fa51f4321.tar.zst
forge-df384aca4ea164a9d63e40facf8ff10fa51f4321.zip
schema.sql: Reorder (or it'll error out)
Diffstat (limited to '')
-rw-r--r--schema.sql14
1 files changed, 7 insertions, 7 deletions
diff --git a/schema.sql b/schema.sql
index f90480d..fbd9ac8 100644
--- a/schema.sql
+++ b/schema.sql
@@ -44,6 +44,13 @@ CREATE TABLE emails (
content BYTEA NOT NULL
);
+CREATE TABLE users (
+ id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
+ username TEXT NOT NULL UNIQUE,
+ password_algorithm TEXT NOT NULL CHECK (password_algorithm in ('argon2id')),
+ password TEXT NOT NULL
+);
+
CREATE TABLE merge_requests (
id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
repo_id INTEGER NOT NULL REFERENCES repos(id) ON DELETE CASCADE,
@@ -55,13 +62,6 @@ CREATE TABLE merge_requests (
mailing_list_id INT UNIQUE REFERENCES mailing_lists(id) ON DELETE CASCADE
);
-CREATE TABLE users (
- id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
- username TEXT NOT NULL UNIQUE,
- password_algorithm TEXT NOT NULL CHECK (password_algorithm in ('argon2id')),
- password TEXT NOT NULL
-);
-
CREATE TABLE ssh_public_keys (
id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,