Initial version of database schema

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
+);