From e6d3eeb7c055a2941600f048697298b0e77b2e2c Mon Sep 17 00:00:00 2001 From: Daniel Hader Date: Sat, 30 May 2026 18:28:16 -0500 Subject: admin account registration as part of server init --- src/database/sql/initialize.sql | 3 ++- src/database/sql/insert_user.sql | 2 +- 2 files changed, 3 insertions(+), 2 deletions(-) (limited to 'src/database/sql') diff --git a/src/database/sql/initialize.sql b/src/database/sql/initialize.sql index 1c2a40f..72b7468 100644 --- a/src/database/sql/initialize.sql +++ b/src/database/sql/initialize.sql @@ -8,7 +8,8 @@ CREATE TABLE IF NOT EXISTS user ( id INTEGER PRIMARY KEY, email TEXT UNIQUE NOT NULL, username TEXT UNIQUE NOT NULL, - password_hash TEXT NOT NULL + password_hash TEXT NOT NULL, + is_admin INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS submission ( diff --git a/src/database/sql/insert_user.sql b/src/database/sql/insert_user.sql index 6b67678..6017cf5 100644 --- a/src/database/sql/insert_user.sql +++ b/src/database/sql/insert_user.sql @@ -1 +1 @@ -INSERT INTO user (email, username, password_hash) VALUES (?1, ?2, ?3) RETURNING id; +INSERT INTO user (email, username, password_hash, is_admin) VALUES (?1, ?2, ?3, ?4) RETURNING id; -- cgit v1.2.3