From 980cd05307434da6aa5ac94ec930953f078cf5a0 Mon Sep 17 00:00:00 2001
From: Ian C <ianc@noddybox.co.uk>
Date: Fri, 1 Mar 2024 12:04:04 +0000
Subject: Initial version of database schema

---
 schema.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 schema.sql

(limited to 'schema.sql')

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
+);
-- 
cgit v1.2.3

