aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-06-08 16:55:17 -0700
committerredmatrix <redmatrix@redmatrix.me>2015-06-08 16:55:17 -0700
commit39f0e6fe622b2080bede823d19b36c9961c64f1d (patch)
treeb01cc44218380bd7e55647d48a59951cf58731ce /install/schema_mysql.sql
parent5b482c1daf1774b185df1e165d04df3de21fb730 (diff)
downloadvolse-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_mysql.sql')
-rw-r--r--install/schema_mysql.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 8e3d5a7b4..8aca3dff4 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1266,6 +1266,7 @@ CREATE TABLE IF NOT EXISTS `site` (
`site_location` char(255) NOT NULL DEFAULT '',
`site_realm` char(255) NOT NULL DEFAULT '',
`site_valid` smallint NOT NULL DEFAULT '0',
+ `site_dead` smallint NOT NULL DEFAULT '0',
PRIMARY KEY (`site_url`),
KEY `site_flags` (`site_flags`),
KEY `site_update` (`site_update`),
@@ -1275,7 +1276,8 @@ CREATE TABLE IF NOT EXISTS `site` (
KEY `site_sellpage` (`site_sellpage`),
KEY `site_pull` (`site_pull`),
KEY `site_realm` (`site_realm`),
- KEY `site_valid` (`site_valid`)
+ KEY `site_valid` (`site_valid`),
+ KEY `site_dead` (`site_dead`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------