diff options
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 |