/soc/2015/igor.gajowiak/chatlog: d7008f4e1915: Created indexes o...

Igor Gajowiak igor.gajowiak at gmail.com
Sat Jul 25 19:02:58 EDT 2015


Changeset: d7008f4e1915c4ec017d08f7cbed15cac816961e
Author:	 Igor Gajowiak <igor.gajowiak at gmail.com>
Date:	 2015-07-26 01:02 +0200
Branch:	 default
URL: https://hg.pidgin.im/soc/2015/igor.gajowiak/chatlog/rev/d7008f4e1915

Description:

Created indexes on author and recipient columns.

diffstat:

 libpurple/plugins/log/logsqlite.c |  2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diffs (12 lines):

diff --git a/libpurple/plugins/log/logsqlite.c b/libpurple/plugins/log/logsqlite.c
--- a/libpurple/plugins/log/logsqlite.c
+++ b/libpurple/plugins/log/logsqlite.c
@@ -298,6 +298,8 @@ sqlitelog_create_tables(sqlite3 *db_hand
 		"AccountId INTEGER NOT NULL,"
 		"FOREIGN KEY(AccountId) REFERENCES Accounts(Id)); "
 
+		"CREATE INDEX AuthorIndex ON Messages (Author); "
+		"CREATE INDEX RecipientIndex ON Messages (Recipient); "
 		"CREATE INDEX SeenIndex ON Messages (Seen); "
 		"CREATE INDEX SendIndex ON Messages (Send); "
 		"CREATE INDEX MsgTimeIndex ON Messages (MsgTime); "



More information about the Commits mailing list