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_webhook_store.go | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'store/sql_webhook_store.go') diff --git a/store/sql_webhook_store.go b/store/sql_webhook_store.go index 7c267064b..1e1740796 100644 --- a/store/sql_webhook_store.go +++ b/store/sql_webhook_store.go @@ -44,6 +44,14 @@ func (s SqlWebhookStore) CreateIndexesIfNotExists() { s.CreateIndexIfNotExists("idx_incoming_webhook_user_id", "IncomingWebhooks", "UserId") s.CreateIndexIfNotExists("idx_incoming_webhook_team_id", "IncomingWebhooks", "TeamId") s.CreateIndexIfNotExists("idx_outgoing_webhook_team_id", "OutgoingWebhooks", "TeamId") + + s.CreateIndexIfNotExists("idx_incoming_webhook_update_at", "IncomingWebhooks", "UpdateAt") + s.CreateIndexIfNotExists("idx_incoming_webhook_create_at", "IncomingWebhooks", "CreateAt") + s.CreateIndexIfNotExists("idx_incoming_webhook_delete_at", "IncomingWebhooks", "DeleteAt") + + s.CreateIndexIfNotExists("idx_outgoing_webhook_update_at", "OutgoingWebhooks", "UpdateAt") + s.CreateIndexIfNotExists("idx_outgoing_webhook_create_at", "OutgoingWebhooks", "CreateAt") + s.CreateIndexIfNotExists("idx_outgoing_webhook_delete_at", "OutgoingWebhooks", "DeleteAt") } func (s SqlWebhookStore) SaveIncoming(webhook *model.IncomingWebhook) StoreChannel { -- cgit v1.2.3-1-g7c22