schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
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
);