diff options
| author | FChannel <> | 2021-07-30 16:28:55 -0700 |
|---|---|---|
| committer | FChannel <> | 2021-07-30 16:28:55 -0700 |
| commit | a1ecad89f575b7d8542eea75979b4c11bfa199d4 (patch) | |
| tree | 6e06ae5cbd75cc527167a4033e5faa48b0f7939f /databaseschema.psql | |
| parent | 7c6ee8f4073a5b8fd9cc065f225c9f09f21ee4a1 (diff) | |
added removal of inactive instances from following/followers after 24hrs
Diffstat (limited to 'databaseschema.psql')
| -rw-r--r-- | databaseschema.psql | 13 |
1 files changed, 9 insertions, 4 deletions
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 |