Merge pull request #170 from mattermost/mm-1420

Fixes mm-1420 adding initial support for postgres

1 files changed, 3 insertions, 3 deletions

diff --git a/store/sql_audit_store.go b/store/sql_audit_store.go
index dd9312007..a595d50e2 100644
--- a/store/sql_audit_store.go
+++ b/store/sql_audit_store.go
@@ -31,7 +31,7 @@ func (s SqlAuditStore) UpgradeSchemaIfNeeded() {
 }
 
 func (s SqlAuditStore) CreateIndexesIfNotExists() {
-	s.CreateIndexIfNotExists("idx_user_id", "Audits", "UserId")
+	s.CreateIndexIfNotExists("idx_audits_user_id", "Audits", "UserId")
 }
 
 func (s SqlAuditStore) Save(audit *model.Audit) StoreChannel {
@@ -73,8 +73,8 @@ func (s SqlAuditStore) Get(user_id string, limit int) StoreChannel {
 		}
 
 		var audits model.Audits
-		if _, err := s.GetReplica().Select(&audits, "SELECT * FROM Audits WHERE UserId = ? ORDER BY CreateAt DESC LIMIT ?",
-			user_id, limit); err != nil {
+		if _, err := s.GetReplica().Select(&audits, "SELECT * FROM Audits WHERE UserId = :user_id ORDER BY CreateAt DESC LIMIT :limit",
+			map[string]interface{}{"user_id": user_id, "limit": limit}); err != nil {
 			result.Err = model.NewAppError("SqlAuditStore.Get", "We encounted an error finding the audits", "user_id="+user_id)
 		} else {
 			result.Data = audits