From 06600b2d434490a0eca709ce2f38b34ce64794e8 Mon Sep 17 00:00:00 2001 From: Ian C 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(-) 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