From c65ea0b97b2dc6fcefa0d2da489f32bdd7d05b65 Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 5 Sep 2013 22:00:06 -0700 Subject: public site list (will take a few days to populate, assuming folks have updated their site access policy which old sites do not have) --- install/database.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'install/database.sql') 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`), -- cgit v1.2.3