From 8b1036819422049d81bca3384259ac2f74e7a27a Mon Sep 17 00:00:00 2001
From: Brett Profitt <brett.profitt@gmail.com>
Date: Wed, 18 Apr 2012 20:31:26 -0700
Subject: Fixes #4291. Removing the unique index on user and site guids in the
 users_apisessions table.

---
 ...12041801-1.8.3-multiple_user_tokens-852225f7fd89f6c5.php | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 engine/lib/upgrades/2012041801-1.8.3-multiple_user_tokens-852225f7fd89f6c5.php

(limited to 'engine/lib/upgrades/2012041801-1.8.3-multiple_user_tokens-852225f7fd89f6c5.php')

diff --git a/engine/lib/upgrades/2012041801-1.8.3-multiple_user_tokens-852225f7fd89f6c5.php b/engine/lib/upgrades/2012041801-1.8.3-multiple_user_tokens-852225f7fd89f6c5.php
new file mode 100644
index 000000000..07732f261
--- /dev/null
+++ b/engine/lib/upgrades/2012041801-1.8.3-multiple_user_tokens-852225f7fd89f6c5.php
@@ -0,0 +1,13 @@
+<?php
+/**
+ * Elgg 1.8.3 upgrade 2012041801
+ * multiple_user_tokens
+ *
+ * Fixes http://trac.elgg.org/ticket/4291
+ * Removes the unique index on users_apisessions for user_guid and site_guid
+ */
+
+$db_prefix = elgg_get_config('dbprefix');
+$q = "ALTER TABLE {$db_prefix}users_apisessions DROP INDEX user_guid,
+	ADD INDEX user_guid (user_guid, site_guid)";
+update_data($q);
\ No newline at end of file
-- 
cgit v1.2.3