Added GPL comments and changed to array for info on download table

1 files changed, 18 insertions, 3 deletions

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 <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
 );