aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-09-05 22:00:06 -0700
committerfriendica <info@friendica.com>2013-09-05 22:00:06 -0700
commitc65ea0b97b2dc6fcefa0d2da489f32bdd7d05b65 (patch)
tree6b1e2faaa0a85aa9216d674ebecd48e0df049cd3 /install/database.sql
parentf8801185588a058a26c7aabd6be22ec27ee91b38 (diff)
downloadvolse-hubzilla-c65ea0b97b2dc6fcefa0d2da489f32bdd7d05b65.tar.gz
volse-hubzilla-c65ea0b97b2dc6fcefa0d2da489f32bdd7d05b65.tar.bz2
volse-hubzilla-c65ea0b97b2dc6fcefa0d2da489f32bdd7d05b65.zip
public site list (will take a few days to populate, assuming folks have updated their site access policy which old sites do not have)
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/install/database.sql b/install/database.sql
index 176b3610f..ce46149c4 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -818,11 +818,13 @@ CREATE TABLE IF NOT EXISTS `shares` (
CREATE TABLE IF NOT EXISTS `site` (
`site_url` char(255) NOT NULL,
+ `site_access` int(11) NOT NULL DEFAULT '0',
`site_flags` int(11) NOT NULL DEFAULT '0',
`site_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`site_directory` char(255) NOT NULL DEFAULT '',
`site_register` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`site_url`),
+ KEY `site_access` (`site_access`),
KEY `site_flags` (`site_flags`),
KEY `site_update` (`site_update`),
KEY `site_directory` (`site_directory`),