schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

create table if not exists file_object
(
    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(64) not null references file_object(key),
    ip_address varchar(32) not null,
    user_agent varchar(256) not null,
    time timestamp not null
);