3 files changed, 5 insertions, 2 deletions
diff --git a/src/database/sql/fetch_problem.sql b/src/database/sql/fetch_problem.sql
new file mode 100644
index 0000000..f319c2f
--- /dev/null
+++ b/src/database/sql/fetch_problem.sql
@@ -0,0 +1 @@
+SELECT * FROM problem WHERE problem.id == ?1;
diff --git a/src/database/sql/initialize.sql b/src/database/sql/initialize.sql
index 72b7468..8c0f2ef 100644
--- a/src/database/sql/initialize.sql
+++ b/src/database/sql/initialize.sql
@@ -16,9 +16,10 @@ CREATE TABLE IF NOT EXISTS submission (
     id         INTEGER PRIMARY KEY,
     user_id    INTEGER NOT NULL,
     problem_id INTEGER NOT NULL,
-    code       TEXT NOT NULL,
     language   TEXT NOT NULL,
-    validated  INTEGER NOT NULL
+    details    TEXT NOT NULL,
+    code       TEXT NOT NULL
+    
 );
 
 INSERT INTO problem (title, description) VALUES (
diff --git a/src/database/sql/insert_submission.sql b/src/database/sql/insert_submission.sql
new file mode 100644
index 0000000..96df322
--- /dev/null
+++ b/src/database/sql/insert_submission.sql
@@ -0,0 +1 @@
+INSERT INTO submission (user_id, problem_id, language, details, code) VALUES (?1, ?2, ?3, ?4, ?5) RETURNING id;