feat: file bans

1 files changed, 11 insertions, 0 deletions

diff --git a/database.sql b/database.sql
index b7efa83..47f7ea6 100644
--- a/database.sql
+++ b/database.sql
@@ -16,4 +16,15 @@ CREATE TABLE IF NOT EXISTS file_metadata (
     height BIGINT,
     duration BIGINT,
     line_count BIGINT
+);
+
+CREATE TABLE IF NOT EXISTS hash_bans (
+    sha256 CHAR(64) PRIMARY KEY,
+    reason TEXT
+);
+
+CREATE TABLE IF NOT EXISTS file_bans (
+    id CHAR(32) NOT NULL PRIMARY KEY REFERENCES files(id) ON DELETE CASCADE,
+    hash_ban CHAR(64) NOT NULL REFERENCES hash_bans(sha256) ON DELETE CASCADE,
+    banned_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
\ No newline at end of file