From a1ecad89f575b7d8542eea75979b4c11bfa199d4 Mon Sep 17 00:00:00 2001
From: FChannel <>
Date: Fri, 30 Jul 2021 16:28:55 -0700
Subject: added removal of inactive instances from following/followers after
 24hrs

---
 databaseschema.psql | 13 +++++++++----
 1 file changed, 9 insertions(+), 4 deletions(-)

(limited to 'databaseschema.psql')

diff --git a/databaseschema.psql b/databaseschema.psql
index 67681cd..cf0d36b 100644
--- a/databaseschema.psql
+++ b/databaseschema.psql
@@ -92,7 +92,7 @@ anyOf varchar(100) default '',
 closed varchar(100) default '',
 origin varchar(100) default '',
 next varchar(100) default '',
-object varchar(100), 
+object varchar(100),
 prev varchar(100) default '',
 preview varchar(100) default '',
 result varchar(100) default '',
@@ -124,7 +124,7 @@ summary varchar(100) default '',
 totalItems varchar(100) default '',
 units varchar(100) default '',
 updated TIMESTAMP default NOW(),
-deleted TIMESTAMP default NULL, 
+deleted TIMESTAMP default NULL,
 width varchar(100) default '',
 subject varchar(100) default '',
 relationship varchar(100) default '',
@@ -159,7 +159,7 @@ anyOf varchar(100) default '',
 closed varchar(100) default '',
 origin varchar(100) default '',
 next varchar(100) default '',
-object varchar(100), 
+object varchar(100),
 prev varchar(100) default '',
 preview varchar(100) default '',
 result varchar(100) default '',
@@ -191,7 +191,7 @@ summary varchar(100) default '',
 totalItems varchar(100) default '',
 units varchar(100) default '',
 updated TIMESTAMP default NOW(),
-deleted TIMESTAMP default NULL, 
+deleted TIMESTAMP default NULL,
 width varchar(100) default '',
 subject varchar(100) default '',
 relationship varchar(100) default '',
@@ -237,4 +237,9 @@ ALTER TABLE actor ADD COLUMN IF NOT EXISTS autosubscribe boolean default false;
 CREATE TABLE IF NOT EXISTS bannedmedia(
 id serial primary key,
 hash varchar(200)
+);
+
+CREATE TABLE IF NOT EXISTS inactive(
+instance varchar(100) primary key,
+timestamp TIMESTAMP default NOW()
 );
\ No newline at end of file
-- 
cgit v1.2.3