| 7 |
bannedIpHostMask varchar (255) |
bannedIpHostMask varchar (255) |
| 8 |
); |
); |
| 9 |
|
|
| 10 |
|
ALTER TABLE "prims" RENAME TO "__temp__prims"; |
| 11 |
|
CREATE TABLE "prims" ("UUID" varchar(255) PRIMARY KEY ,"RegionUUID" varchar(255),"CreationDate" integer,"Name" varchar(255),"SceneGroupID" varchar(255),"Text" varchar(255),"Description" varchar(255),"SitName" varchar(255),"TouchName" varchar(255),"ObjectFlags" integer,"CreatorID" varchar(255),"OwnerID" varchar(255),"GroupID" varchar(255),"LastOwnerID" varchar(255),"OwnerMask" integer,"NextOwnerMask" integer,"GroupMask" integer,"EveryoneMask" integer,"BaseMask" integer,"PositionX" float,"PositionY" float,"PositionZ" float,"GroupPositionX" float,"GroupPositionY" float,"GroupPositionZ" float,"VelocityX" float,"VelocityY" float,"VelocityZ" float,"AngularVelocityX" float,"AngularVelocityY" float,"AngularVelocityZ" float,"AccelerationX" float,"AccelerationY" float,"AccelerationZ" float,"RotationX" float,"RotationY" float,"RotationZ" float,"RotationW" float,"ClickAction" string,"SitTargetOffsetX" float,"SitTargetOffsetY" float,"SitTargetOffsetZ" float,"SitTargetOrientW" float,"SitTargetOrientX" float,"SitTargetOrientY" float,"SitTargetOrientZ" float); |
| 12 |
|
INSERT INTO "prims" SELECT "UUID","RegionUUID","CreationDate","Name","SceneGroupID","Text","Description","SitName","TouchName","ObjectFlags","CreatorID","OwnerID","GroupID","LastOwnerID","OwnerMask","NextOwnerMask","GroupMask","EveryoneMask","BaseMask","PositionX","PositionY","PositionZ","GroupPositionX","GroupPositionY","GroupPositionZ","VelocityX","VelocityY","VelocityZ","AngularVelocityX","AngularVelocityY","AngularVelocityZ","AccelerationX","AccelerationY","AccelerationZ","RotationX","RotationY","RotationZ","RotationW","ClickAction","SitTargetOffsetX","SitTargetOffsetY","SitTargetOffsetZ","SitTargetOrientW","SitTargetOrientX","SitTargetOrientY","SitTargetOrientZ" FROM "__temp__prims"; |
| 13 |
|
DROP TABLE "__temp__prims"; |
| 14 |
|
|
| 15 |
|
update prims |
| 16 |
|
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) |
| 17 |
|
where UUID not like '%-%'; |
| 18 |
|
|
| 19 |
|
update prims |
| 20 |
|
set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12) |
| 21 |
|
where RegionUUID not like '%-%'; |
| 22 |
|
|
| 23 |
|
update prims |
| 24 |
|
set SceneGroupID = substr(SceneGroupID, 1, 8) || "-" || substr(SceneGroupID, 9, 4) || "-" || substr(SceneGroupID, 13, 4) || "-" || substr(SceneGroupID, 17, 4) || "-" || substr(SceneGroupID, 21, 12) |
| 25 |
|
where SceneGroupID not like '%-%'; |
| 26 |
|
|
| 27 |
|
update prims |
| 28 |
|
set CreatorID = substr(CreatorID, 1, 8) || "-" || substr(CreatorID, 9, 4) || "-" || substr(CreatorID, 13, 4) || "-" || substr(CreatorID, 17, 4) || "-" || substr(CreatorID, 21, 12) |
| 29 |
|
where CreatorID not like '%-%'; |
| 30 |
|
|
| 31 |
|
update prims |
| 32 |
|
set OwnerID = substr(OwnerID, 1, 8) || "-" || substr(OwnerID, 9, 4) || "-" || substr(OwnerID, 13, 4) || "-" || substr(OwnerID, 17, 4) || "-" || substr(OwnerID, 21, 12) |
| 33 |
|
where OwnerID not like '%-%'; |
| 34 |
|
|
| 35 |
|
update prims |
| 36 |
|
set GroupID = substr(GroupID, 1, 8) || "-" || substr(GroupID, 9, 4) || "-" || substr(GroupID, 13, 4) || "-" || substr(GroupID, 17, 4) || "-" || substr(GroupID, 21, 12) |
| 37 |
|
where GroupID not like '%-%'; |
| 38 |
|
|
| 39 |
|
update prims |
| 40 |
|
set LastOwnerID = substr(LastOwnerID, 1, 8) || "-" || substr(LastOwnerID, 9, 4) || "-" || substr(LastOwnerID, 13, 4) || "-" || substr(LastOwnerID, 17, 4) || "-" || substr(LastOwnerID, 21, 12) |
| 41 |
|
where LastOwnerID not like '%-%'; |
| 42 |
|
|
| 43 |
COMMIT; |
COMMIT; |
Parent Directory
| 
Revision Log
| 
Patch
