2 files changed, 3 insertions, 2 deletions
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;