diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-08 21:17:13 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-08 21:17:13 +0900 |
| commit | a100dc8ba76aaeda2229940c1743c33cc0ef84b5 (patch) | |
| tree | e2e48d8d92e2601d65e3ce7d794d8727026c14e0 /backend/schema.sql | |
| parent | bb62b6ff19d9f8008458d1c0ad0b8b76090f091e (diff) | |
| parent | 3b13a61123becc63823ab0c0941aaff2048b020e (diff) | |
| download | phperkaigi-2025-albatross-a100dc8ba76aaeda2229940c1743c33cc0ef84b5.tar.gz phperkaigi-2025-albatross-a100dc8ba76aaeda2229940c1743c33cc0ef84b5.tar.zst phperkaigi-2025-albatross-a100dc8ba76aaeda2229940c1743c33cc0ef84b5.zip | |
Merge branch 'feat/code-hash'
Diffstat (limited to 'backend/schema.sql')
| -rw-r--r-- | backend/schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
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) |