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 | |
| parent | Add a migration to add the 3 new fields (diff) | |
| download | opensim-SC_OLD-3249d5be9a7ef649b70cce1444a46cfb64796b16.zip opensim-SC_OLD-3249d5be9a7ef649b70cce1444a46cfb64796b16.tar.gz opensim-SC_OLD-3249d5be9a7ef649b70cce1444a46cfb64796b16.tar.bz2 opensim-SC_OLD-3249d5be9a7ef649b70cce1444a46cfb64796b16.tar.xz | |
Add the indices to really make this table work
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
| -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; | ||