diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 21 |
1 files changed, 18 insertions, 3 deletions
@@ -1,3 +1,19 @@ +-- 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, @@ -9,7 +25,6 @@ create table if not exists file_object 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 + info text[] not null, + time timestamp with timezone not null ); |