diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-06-08 16:55:17 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-06-08 16:55:17 -0700 |
| commit | 39f0e6fe622b2080bede823d19b36c9961c64f1d (patch) | |
| tree | b01cc44218380bd7e55647d48a59951cf58731ce /install/schema_postgres.sql | |
| parent | 5b482c1daf1774b185df1e165d04df3de21fb730 (diff) | |
| download | volse-hubzilla-39f0e6fe622b2080bede823d19b36c9961c64f1d.tar.gz volse-hubzilla-39f0e6fe622b2080bede823d19b36c9961c64f1d.tar.bz2 volse-hubzilla-39f0e6fe622b2080bede823d19b36c9961c64f1d.zip | |
add site_dead flag to prevent delivery to dead sites. Allow sys channel webpages to be viewed even if site is configured "block public".
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 48f3fe0fc..a68c7d12b 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -969,6 +969,7 @@ CREATE TABLE "site" ( "site_location" text NOT NULL DEFAULT '', "site_realm" text NOT NULL DEFAULT '', "site_valid" smallint NOT NULL DEFAULT '0', + "site_dead" smallint NOT NULL DEFAULT '0', PRIMARY KEY ("site_url") ); create index "site_flags" on site ("site_flags"); @@ -979,6 +980,7 @@ create index "site_access" on site ("site_access"); create index "site_sellpage" on site ("site_sellpage"); create index "site_realm" on site ("site_realm"); create index "site_valid" on site ("site_valid"); +create index "site_dead" on site ("site_dead"); CREATE TABLE "source" ( "src_id" serial NOT NULL, |