a4stats: Create another index for the users table.

diff --git a/a4stats/a4stats_db.c b/a4stats/a4stats_db.c
index a4b2db076cbe8619e83e25b45c27de65a5baf979..ce7234d7f65db1d0f80ec17cad8589308a8124d2 100644 (file)
--- a/a4stats/a4stats_db.c
+++ b/a4stats/a4stats_db.c
@@ -47,6 +47,7 @@ static int a4stats_connectdb(void) {
 
   a4statsdb->squery(a4statsdb, "CREATE INDEX ? ON users (channelid)", "T", "users_channelid_index");
   a4statsdb->squery(a4statsdb, "CREATE UNIQUE INDEX ? ON users (channelid, account, accountid)", "T", "users_channelid_account_accountid_index");
+  a4statsdb->squery(a4statsdb, "CREATE INDEX ? ON users (channelid, lines)", "T", "users_channelid_lines_index");
 
   return 1;
 }