diff options
author | Runxi Yu <me@runxiyu.org> | 2025-02-12 23:23:47 +0800 |
---|---|---|
committer | Runxi Yu <me@runxiyu.org> | 2025-02-12 23:23:47 +0800 |
commit | df384aca4ea164a9d63e40facf8ff10fa51f4321 (patch) | |
tree | 512c50e579ca78c76ba365efdc54cd0e9cc17dc6 /schema.sql | |
parent | router_http: Ensure module index has / (diff) | |
download | forge-df384aca4ea164a9d63e40facf8ff10fa51f4321.tar.gz forge-df384aca4ea164a9d63e40facf8ff10fa51f4321.tar.zst forge-df384aca4ea164a9d63e40facf8ff10fa51f4321.zip |
schema.sql: Reorder (or it'll error out)
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 14 |
1 files changed, 7 insertions, 7 deletions
@@ -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, |