From d94c9eb68e65d53f09bf3dd26ec4d61d245882ad Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Thu, 8 Aug 2024 20:33:40 +0900
Subject: feat(backend): add `code_hash` to `submissions` table

---
 backend/schema.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'backend/schema.sql')

diff --git a/backend/schema.sql b/backend/schema.sql
index 74d1202..64642bc 100644
--- a/backend/schema.sql
+++ b/backend/schema.sql
@@ -59,6 +59,7 @@ CREATE TABLE submissions (
     user_id       INT       NOT NULL,
     code          TEXT      NOT NULL,
     code_size     INT       NOT NULL,
+    code_hash     CHAR(32)  NOT NULL,
     created_at    TIMESTAMP NOT NULL DEFAULT NOW(),
     CONSTRAINT fk_game_id FOREIGN KEY(game_id) REFERENCES games(game_id),
     CONSTRAINT fk_user_id FOREIGN KEY(user_id) REFERENCES users(user_id)
-- 
cgit v1.3.1

