From 08f054130f5a57e2928e129131e7609271ec7f40 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Tue, 24 Feb 2015 16:36:27 -0800
Subject: require access token to view, query, or join directories in private
 realms, if the realm is so configured.

---
 install/schema_mysql.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 247b33814..da78d9c61 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1256,6 +1256,7 @@ CREATE TABLE IF NOT EXISTS `site` (
   `site_sellpage` char(255) NOT NULL DEFAULT '',
   `site_location` char(255) NOT NULL DEFAULT '',
   `site_realm` char(255) NOT NULL DEFAULT '',
+  `site_valid` smallint NOT NULL DEFAULT '0',
   PRIMARY KEY (`site_url`),
   KEY `site_flags` (`site_flags`),
   KEY `site_update` (`site_update`),
@@ -1264,7 +1265,8 @@ CREATE TABLE IF NOT EXISTS `site` (
   KEY `site_access` (`site_access`),
   KEY `site_sellpage` (`site_sellpage`),
   KEY `site_pull` (`site_pull`),
-  KEY `site_realm` (`site_realm`)
+  KEY `site_realm` (`site_realm`),
+  KEY `site_valid` (`site_valid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
-- 
cgit v1.2.3


From 011ccd57f62335c915b5ac75e20c45a36a64a888 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 4 Mar 2015 17:56:07 -0800
Subject: add queue priority

---
 install/schema_mysql.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index da78d9c61..4e481f5c0 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -940,6 +940,7 @@ CREATE TABLE IF NOT EXISTS `outq` (
   `outq_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `outq_notify` mediumtext NOT NULL,
   `outq_msg` mediumtext NOT NULL,
+  `outq_priority` smallint NOT NULL DEFAULT '0',
   PRIMARY KEY (`outq_hash`),
   KEY `outq_account` (`outq_account`),
   KEY `outq_channel` (`outq_channel`),
@@ -947,7 +948,8 @@ CREATE TABLE IF NOT EXISTS `outq` (
   KEY `outq_created` (`outq_created`),
   KEY `outq_updated` (`outq_updated`),
   KEY `outq_async` (`outq_async`),
-  KEY `outq_delivered` (`outq_delivered`)
+  KEY `outq_delivered` (`outq_delivered`),
+  KEY `outq_priority` (`outq_priority`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
-- 
cgit v1.2.3


From 9d1df58759b4eff9439c12d081ba5e1264f900a3 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Tue, 10 Mar 2015 18:55:56 -0700
Subject: sql optimisation for affinity searches. A new index was added which
 wasn't added retro-actively to existing DBs as an update. It isn't clear if
 this helps sites any more than just restricting the abook table to certain
 channel_id's is (and this field is already indexed).

---
 install/schema_mysql.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 4e481f5c0..3567085ce 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -33,7 +33,8 @@ CREATE TABLE IF NOT EXISTS `abook` (
   KEY `abook_profile` (`abook_profile`),
   KEY `abook_dob` (`abook_dob`),
   KEY `abook_connected` (`abook_connected`),
-  KEY `abook_rating` (`abook_rating`)
+  KEY `abook_rating` (`abook_rating`),
+  KEY `abook_channel_closeness` (`book_channel`,`abook_closeness`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
-- 
cgit v1.2.3


From 6537a65053f456870e6f03cdb5bca9a9907426eb Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Sun, 15 Mar 2015 15:36:01 -0700
Subject: mysql schema typo, do the install check for store before chcking
 smarty, as that is where the dir is created, change install doc to point to
 install/schema_xxxxx.sql instead of database.sql

---
 install/schema_mysql.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 3567085ce..b3f992500 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -34,7 +34,7 @@ CREATE TABLE IF NOT EXISTS `abook` (
   KEY `abook_dob` (`abook_dob`),
   KEY `abook_connected` (`abook_connected`),
   KEY `abook_rating` (`abook_rating`),
-  KEY `abook_channel_closeness` (`book_channel`,`abook_closeness`)
+  KEY `abook_channel_closeness` (`abook_channel`,`abook_closeness`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
-- 
cgit v1.2.3

