summaryrefslogtreecommitdiff
path: root/src/database/sql/initialize.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/database/sql/initialize.sql')
-rw-r--r--src/database/sql/initialize.sql3
1 files changed, 2 insertions, 1 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 (