From 06600b2d434490a0eca709ce2f38b34ce64794e8 Mon Sep 17 00:00:00 2001
From: Ian C <ianc@noddybox.co.uk>
Date: Sun, 3 Mar 2024 15:59:50 +0000
Subject: Added file_name to file_object and made everything not null

---
 schema.sql | 15 ++++++++-------
 1 file changed, 8 insertions(+), 7 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 7839bf2..84a9008 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,14 +1,15 @@
 create table if not exists file_object
 (
-    key varchar(32) not null primary key,
-    mime_type varchar(64),
-    data bytea
+    key varchar(64) not null primary key,
+    mime_type varchar(64) not null,
+    file_name varchar(64) not null,
+    data bytea not null
 );
 
 create table if not exists download
 (
-    key varchar(32) not null references file_object(key),
-    ip_address varchar(32),
-    user_agent varchar(128),
-    time timestamp
+    key varchar(64) not null references file_object(key),
+    ip_address varchar(32) not null,
+    user_agent varchar(128) not null,
+    time timestamp not null
 );
-- 
cgit v1.2.3

