From e9ee8fb4d2f10b67e241501f919b7cd8c0cc2d93 Mon Sep 17 00:00:00 2001 From: Ian C Date: Tue, 26 Mar 2024 22:53:04 +0000 Subject: Added GPL comments and changed to array for info on download table --- schema.sql | 21 ++++++++++++++++++--- 1 file changed, 18 insertions(+), 3 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 0d00ae2..fd98920 100644 --- a/schema.sql +++ b/schema.sql @@ -1,3 +1,19 @@ +-- download - the schema +-- Copyright (C) 2024 Ian Cowburn +-- +-- 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 . + 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 ); -- cgit v1.2.3