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.sql14
1 files changed, 7 insertions, 7 deletions
diff --git a/src/database/sql/initialize.sql b/src/database/sql/initialize.sql
index 8c0f2ef..3569fd5 100644
--- a/src/database/sql/initialize.sql
+++ b/src/database/sql/initialize.sql
@@ -13,13 +13,13 @@ CREATE TABLE IF NOT EXISTS user (
);
CREATE TABLE IF NOT EXISTS submission (
- id INTEGER PRIMARY KEY,
- user_id INTEGER NOT NULL,
- problem_id INTEGER NOT NULL,
- language TEXT NOT NULL,
- details TEXT NOT NULL,
- code TEXT NOT NULL
-
+ id INTEGER PRIMARY KEY,
+ user_id INTEGER NOT NULL,
+ problem_id INTEGER NOT NULL,
+ language TEXT NOT NULL,
+ details TEXT NOT NULL,
+ code TEXT NOT NULL,
+ code_length INTEGER NOT NULL
);
INSERT INTO problem (title, description) VALUES (