/soc/2015/igor.gajowiak/chatlog: d7008f4e1915: Created indexes o...
Igor Gajowiak <[email protected]>
| Newsgroups | gmane.comp.gnome.gaim.cvs |
|---|---|
| Message-ID | <[email protected]> |
Changeset: d7008f4e1915c4ec017d08f7cbed15cac816961e Author: Igor Gajowiak <[email protected]> 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); " _______________________________________________ Commits mailing list [email protected] https://pidgin.im/cgi-bin/mailman/listinfo/commits