summaryrefslogtreecommitdiff
path: root/src/database/sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/database/sql')
-rw-r--r--src/database/sql/initialize.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/database/sql/initialize.sql b/src/database/sql/initialize.sql
index 065bac9..510c427 100644
--- a/src/database/sql/initialize.sql
+++ b/src/database/sql/initialize.sql
@@ -13,9 +13,9 @@ CREATE TABLE IF NOT EXISTS user (
CREATE TABLE IF NOT EXISTS submission (
id INTEGER PRIMARY KEY,
- problem_id INTEGER NOT NULL,
user_id INTEGER NOT NULL,
- language TEXT NOT NULL,
+ problem_id INTEGER NOT NULL,
code TEXT NOT NULL,
+ language TEXT NOT NULL,
validated INTEGER NOT NULL
);