From a051dd5aab7465facd938a5afc81cdb420890f15 Mon Sep 17 00:00:00 2001
From: marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Thu, 8 Jan 2009 12:40:41 +0000
Subject: Closes #666: Added some extra indexes

git-svn-id: https://code.elgg.org/elgg/trunk@2543 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 9a6efd683..521cda27f 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -152,6 +152,8 @@ CREATE TABLE `prefix_users_entity` (
   KEY `password` (`password`),
   KEY `email` (`email`(50)),
   KEY `code` (`code`),
+  KEY `last_action` (`last_action`),
+  KEY `last_login` (`last_login`),
   FULLTEXT KEY `name` (`name`),
   FULLTEXT KEY (`name`,`username`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- 
cgit v1.2.3

