server text sanitation, username/email filters, and code length measurement

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 (