schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

-- download - the schema
-- Copyright (C) 2024 Ian Cowburn <ianc@noddybox.co.uk>
-- 
-- This program is free software: you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation, either version 3 of the License, or
-- (at your option) any later version.
-- 
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
-- 
-- You should have received a copy of the GNU General Public License
-- along with this program.  If not, see <http://www.gnu.org/licenses/>.

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),
    info text[] not null,
    time timestamp with timezone not null
);