aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2015-03-11 01:03:30 -0700
committerfriendica <info@friendica.com>2015-03-11 01:03:30 -0700
commita40c19d19d31bba3fe037a9778c521461e2b0290 (patch)
tree8c09cefac7bfb25360c19f212b02b0f46a79480e /install
parentbfd123c59a61be1d667648263aa44c4a9e14a5fc (diff)
parent0014cf4ff232328c3e3d0993eb8e9893a7c16f54 (diff)
downloadvolse-hubzilla-a40c19d19d31bba3fe037a9778c521461e2b0290.tar.gz
volse-hubzilla-a40c19d19d31bba3fe037a9778c521461e2b0290.tar.bz2
volse-hubzilla-a40c19d19d31bba3fe037a9778c521461e2b0290.zip
Merge branch 'master' into openid
Diffstat (limited to 'install')
-rw-r--r--install/schema_mysql.sql3
-rw-r--r--install/schema_postgres.sql1
2 files changed, 3 insertions, 1 deletions
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;
-- --------------------------------------------------------
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 20285a352..bc72be445 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -29,6 +29,7 @@ CREATE TABLE "abook" (
create index "abook_dob" on abook ("abook_dob");
create index "abook_connected" on abook ("abook_connected");
create index "abook_rating" on abook ("abook_rating");
+ create index "abook_channel_closeness" on abook ("abook_channel", "abook_closeness");
CREATE TABLE "account" (
"account_id" serial NOT NULL,