OpenSim/Data/MySQL/Resources/011_RegionStore.sql


1
2
3
4
5
6
7
8
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;