diff options
author | Ian C <ianc@noddybox.co.uk> | 2024-03-01 12:04:04 +0000 |
---|---|---|
committer | Ian C <ianc@noddybox.co.uk> | 2024-03-01 12:04:04 +0000 |
commit | 980cd05307434da6aa5ac94ec930953f078cf5a0 (patch) | |
tree | 3b0d8ca219d9eefc280575e4066cc206f0a58722 /schema.sql |
Initial version of database schema
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql new file mode 100644 index 0000000..7839bf2 --- /dev/null +++ b/schema.sql @@ -0,0 +1,14 @@ +create table if not exists file_object +( + key varchar(32) not null primary key, + mime_type varchar(64), + data bytea +); + +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 +); |