From c1a0132cab9a7426d765502fa8ccbcd1434a887e Mon Sep 17 00:00:00 2001 From: Roland Haeder Date: Mon, 18 Aug 2014 15:16:22 +0200 Subject: [PATCH] Added missing index declarations. Signed-off-by: Roland Haeder --- classes/User_username.php | 3 +++ plugins/Blog/classes/Blog_entry.php | 7 ++++--- 2 files changed, 7 insertions(+), 3 deletions(-) diff --git a/classes/User_username.php b/classes/User_username.php index d9f517c548..b252ee3156 100644 --- a/classes/User_username.php +++ b/classes/User_username.php @@ -30,6 +30,9 @@ class User_username extends Managed_DataObject 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'), ), 'primary key' => array('provider_name', 'username'), + 'indexes' => array( + 'user_id_idx' => array('user_id') + ), 'foreign keys' => array( 'user_username_user_id_fkey' => array('user', array('user_id' => 'id')), ), diff --git a/plugins/Blog/classes/Blog_entry.php b/plugins/Blog/classes/Blog_entry.php index 20bf4da83f..1f585dce4f 100644 --- a/plugins/Blog/classes/Blog_entry.php +++ b/plugins/Blog/classes/Blog_entry.php @@ -97,12 +97,13 @@ class Blog_entry extends Managed_DataObject 'unique keys' => array( 'blog_entry_uri_key' => array('uri'), ), - 'foreign keys' => array( - 'blog_entry_profile_id_fkey' => array('profile', array('profile_id' => 'id')), - ), 'indexes' => array( + 'blog_entry_profile_id_idx' => array('profile_id'), 'blog_entry_created_idx' => array('created') ), + 'foreign keys' => array( + 'blog_entry_profile_id_fkey' => array('profile', array('profile_id' => 'id')), + ), ); } -- 2.39.5