diff options
author | Melanie | 2009-12-28 23:47:58 +0000 |
---|---|---|
committer | Melanie | 2009-12-28 23:47:58 +0000 |
commit | 3249d5be9a7ef649b70cce1444a46cfb64796b16 (patch) | |
tree | be37c921671fad785eb1326bdb6c8fd9a25e32d7 /OpenSim/Data/MySQL/Resources/003_Presence.sql | |
parent | Add a migration to add the 3 new fields (diff) | |
download | opensim-SC-3249d5be9a7ef649b70cce1444a46cfb64796b16.zip opensim-SC-3249d5be9a7ef649b70cce1444a46cfb64796b16.tar.gz opensim-SC-3249d5be9a7ef649b70cce1444a46cfb64796b16.tar.bz2 opensim-SC-3249d5be9a7ef649b70cce1444a46cfb64796b16.tar.xz |
Add the indices to really make this table work
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/003_Presence.sql')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/003_Presence.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | CREATE UNIQUE INDEX SessionID ON Presence(SessionID); | ||
4 | CREATE INDEX UserID ON Presence(UserID); | ||
5 | |||
6 | COMMIT; | ||