From 2f46ab50969a1541417944952c9bb5a948ec7ec1 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Tue, 15 Jul 2008 20:06:58 +0000
Subject: add migration for SceneGroupID to char(36) plus add an index.  This
 should actually speed up deletes substantially, especially for large regions,
 as this was a table scan before.

---
 OpenSim/Data/MySQL/Resources/011_RegionStore.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/011_RegionStore.sql

(limited to 'OpenSim/Data/MySQL/Resources/011_RegionStore.sql')

diff --git a/OpenSim/Data/MySQL/Resources/011_RegionStore.sql b/OpenSim/Data/MySQL/Resources/011_RegionStore.sql
new file mode 100644
index 0000000..ab01969
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/011_RegionStore.sql
@@ -0,0 +1,9 @@
+BEGIN;
+
+ALTER TABLE prims change SceneGroupID SceneGroupIDold varchar(255);
+ALTER TABLE prims add SceneGroupID char(36);
+UPDATE prims set SceneGroupID = SceneGroupIDold;
+ALTER TABLE prims drop SceneGroupIDold;
+ALTER TABLE prims add index prims_scenegroupid(SceneGroupID);
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1

