From 3249d5be9a7ef649b70cce1444a46cfb64796b16 Mon Sep 17 00:00:00 2001
From: Melanie
Date: Mon, 28 Dec 2009 23:47:58 +0000
Subject: Add the indices to really make this table work

---
 OpenSim/Data/MySQL/Resources/003_Presence.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/003_Presence.sql

(limited to 'OpenSim/Data/MySQL/Resources/003_Presence.sql')

diff --git a/OpenSim/Data/MySQL/Resources/003_Presence.sql b/OpenSim/Data/MySQL/Resources/003_Presence.sql
new file mode 100644
index 0000000..0efefa8
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/003_Presence.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+CREATE UNIQUE INDEX SessionID ON Presence(SessionID);
+CREATE INDEX UserID ON Presence(UserID);
+
+COMMIT;
-- 
cgit v1.1

