From 5fdb8223fc23a12945c00a66edbfc6ef299320f9 Mon Sep 17 00:00:00 2001 From: enahum Date: Mon, 24 Oct 2016 17:05:27 -0300 Subject: Add database indexes to timestamp columns (#4314) * Add database indexes to timestamp columns * add indexes to session table --- store/sql_user_store.go | 3 +++ 1 file changed, 3 insertions(+) (limited to 'store/sql_user_store.go') diff --git a/store/sql_user_store.go b/store/sql_user_store.go index 7904bdbfe..c1fb9b28d 100644 --- a/store/sql_user_store.go +++ b/store/sql_user_store.go @@ -55,6 +55,9 @@ func NewSqlUserStore(sqlStore *SqlStore) UserStore { func (us SqlUserStore) CreateIndexesIfNotExists() { us.CreateIndexIfNotExists("idx_users_email", "Users", "Email") + us.CreateIndexIfNotExists("idx_users_update_at", "Users", "UpdateAt") + us.CreateIndexIfNotExists("idx_users_create_at", "Users", "CreateAt") + us.CreateIndexIfNotExists("idx_users_delete_at", "Users", "DeleteAt") us.CreateFullTextIndexIfNotExists("idx_users_username_txt", "Users", USER_SEARCH_TYPE_USERNAME) us.CreateFullTextIndexIfNotExists("idx_users_all_names_txt", "Users", USER_SEARCH_TYPE_ALL) -- cgit v1.2.3-1-g7c22