From 39f0e6fe622b2080bede823d19b36c9961c64f1d Mon Sep 17 00:00:00 2001
From: redmatrix <redmatrix@redmatrix.me>
Date: Mon, 8 Jun 2015 16:55:17 -0700
Subject: add site_dead flag to prevent delivery to dead sites. Allow sys
 channel webpages to be viewed even if site is configured "block public".

---
 install/schema_postgres.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'install/schema_postgres.sql')

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,
-- 
cgit v1.2.3

