From e9ee8fb4d2f10b67e241501f919b7cd8c0cc2d93 Mon Sep 17 00:00:00 2001
From: Ian C <ianc@noddybox.co.uk>
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 <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
 );
-- 
cgit v1.2.3

