aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/RegionStore.migrations
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/RegionStore.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/RegionStore.migrations1123
1 files changed, 321 insertions, 802 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index 834d249..fb7862a 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -1,354 +1,226 @@
1 1
2:VERSION 1 #--------------------- 2:VERSION 51 #---------------------
3 3
4BEGIN; 4BEGIN;
5 5
6CREATE TABLE `prims` ( 6CREATE TABLE IF NOT EXISTS `prims` (
7 `UUID` varchar(255) NOT NULL, 7 `CreationDate` int(11) DEFAULT NULL,
8 `RegionUUID` varchar(255) default NULL, 8 `Name` varchar(255) DEFAULT NULL,
9 `ParentID` int(11) default NULL, 9 `Text` varchar(255) DEFAULT NULL,
10 `CreationDate` int(11) default NULL, 10 `Description` varchar(255) DEFAULT NULL,
11 `Name` varchar(255) default NULL, 11 `SitName` varchar(255) DEFAULT NULL,
12 `SceneGroupID` varchar(255) default NULL, 12 `TouchName` varchar(255) DEFAULT NULL,
13 `Text` varchar(255) default NULL, 13 `ObjectFlags` int(11) DEFAULT NULL,
14 `Description` varchar(255) default NULL, 14 `OwnerMask` int(11) DEFAULT NULL,
15 `SitName` varchar(255) default NULL, 15 `NextOwnerMask` int(11) DEFAULT NULL,
16 `TouchName` varchar(255) default NULL, 16 `GroupMask` int(11) DEFAULT NULL,
17 `ObjectFlags` int(11) default NULL, 17 `EveryoneMask` int(11) DEFAULT NULL,
18 `CreatorID` varchar(255) default NULL, 18 `BaseMask` int(11) DEFAULT NULL,
19 `OwnerID` varchar(255) default NULL, 19 `PositionX` double DEFAULT NULL,
20 `GroupID` varchar(255) default NULL, 20 `PositionY` double DEFAULT NULL,
21 `LastOwnerID` varchar(255) default NULL, 21 `PositionZ` double DEFAULT NULL,
22 `OwnerMask` int(11) default NULL, 22 `GroupPositionX` double DEFAULT NULL,
23 `NextOwnerMask` int(11) default NULL, 23 `GroupPositionY` double DEFAULT NULL,
24 `GroupMask` int(11) default NULL, 24 `GroupPositionZ` double DEFAULT NULL,
25 `EveryoneMask` int(11) default NULL, 25 `VelocityX` double DEFAULT NULL,
26 `BaseMask` int(11) default NULL, 26 `VelocityY` double DEFAULT NULL,
27 `PositionX` float default NULL, 27 `VelocityZ` double DEFAULT NULL,
28 `PositionY` float default NULL, 28 `AngularVelocityX` double DEFAULT NULL,
29 `PositionZ` float default NULL, 29 `AngularVelocityY` double DEFAULT NULL,
30 `GroupPositionX` float default NULL, 30 `AngularVelocityZ` double DEFAULT NULL,
31 `GroupPositionY` float default NULL, 31 `AccelerationX` double DEFAULT NULL,
32 `GroupPositionZ` float default NULL, 32 `AccelerationY` double DEFAULT NULL,
33 `VelocityX` float default NULL, 33 `AccelerationZ` double DEFAULT NULL,
34 `VelocityY` float default NULL, 34 `RotationX` double DEFAULT NULL,
35 `VelocityZ` float default NULL, 35 `RotationY` double DEFAULT NULL,
36 `AngularVelocityX` float default NULL, 36 `RotationZ` double DEFAULT NULL,
37 `AngularVelocityY` float default NULL, 37 `RotationW` double DEFAULT NULL,
38 `AngularVelocityZ` float default NULL, 38 `SitTargetOffsetX` double DEFAULT NULL,
39 `AccelerationX` float default NULL, 39 `SitTargetOffsetY` double DEFAULT NULL,
40 `AccelerationY` float default NULL, 40 `SitTargetOffsetZ` double DEFAULT NULL,
41 `AccelerationZ` float default NULL, 41 `SitTargetOrientW` double DEFAULT NULL,
42 `RotationX` float default NULL, 42 `SitTargetOrientX` double DEFAULT NULL,
43 `RotationY` float default NULL, 43 `SitTargetOrientY` double DEFAULT NULL,
44 `RotationZ` float default NULL, 44 `SitTargetOrientZ` double DEFAULT NULL,
45 `RotationW` float default NULL, 45 `UUID` char(36) NOT NULL DEFAULT '',
46 `SitTargetOffsetX` float default NULL, 46 `RegionUUID` char(36) DEFAULT NULL,
47 `SitTargetOffsetY` float default NULL, 47 `CreatorID` varchar(255) NOT NULL DEFAULT '',
48 `SitTargetOffsetZ` float default NULL, 48 `OwnerID` char(36) DEFAULT NULL,
49 `SitTargetOrientW` float default NULL, 49 `GroupID` char(36) DEFAULT NULL,
50 `SitTargetOrientX` float default NULL, 50 `LastOwnerID` char(36) DEFAULT NULL,
51 `SitTargetOrientY` float default NULL, 51 `SceneGroupID` char(36) DEFAULT NULL,
52 `SitTargetOrientZ` float default NULL, 52 `PayPrice` int(11) NOT NULL DEFAULT '0',
53 PRIMARY KEY (`UUID`) 53 `PayButton1` int(11) NOT NULL DEFAULT '0',
54 `PayButton2` int(11) NOT NULL DEFAULT '0',
55 `PayButton3` int(11) NOT NULL DEFAULT '0',
56 `PayButton4` int(11) NOT NULL DEFAULT '0',
57 `LoopedSound` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
58 `LoopedSoundGain` double NOT NULL DEFAULT '0',
59 `TextureAnimation` blob,
60 `OmegaX` double NOT NULL DEFAULT '0',
61 `OmegaY` double NOT NULL DEFAULT '0',
62 `OmegaZ` double NOT NULL DEFAULT '0',
63 `CameraEyeOffsetX` double NOT NULL DEFAULT '0',
64 `CameraEyeOffsetY` double NOT NULL DEFAULT '0',
65 `CameraEyeOffsetZ` double NOT NULL DEFAULT '0',
66 `CameraAtOffsetX` double NOT NULL DEFAULT '0',
67 `CameraAtOffsetY` double NOT NULL DEFAULT '0',
68 `CameraAtOffsetZ` double NOT NULL DEFAULT '0',
69 `ForceMouselook` tinyint(4) NOT NULL DEFAULT '0',
70 `ScriptAccessPin` int(11) NOT NULL DEFAULT '0',
71 `AllowedDrop` tinyint(4) NOT NULL DEFAULT '0',
72 `DieAtEdge` tinyint(4) NOT NULL DEFAULT '0',
73 `SalePrice` int(11) NOT NULL DEFAULT '10',
74 `SaleType` tinyint(4) NOT NULL DEFAULT '0',
75 `ColorR` int(11) NOT NULL DEFAULT '0',
76 `ColorG` int(11) NOT NULL DEFAULT '0',
77 `ColorB` int(11) NOT NULL DEFAULT '0',
78 `ColorA` int(11) NOT NULL DEFAULT '0',
79 `ParticleSystem` blob,
80 `ClickAction` tinyint(4) NOT NULL DEFAULT '0',
81 `Material` tinyint(4) NOT NULL DEFAULT '3',
82 `CollisionSound` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
83 `CollisionSoundVolume` double NOT NULL DEFAULT '0',
84 `LinkNumber` int(11) NOT NULL DEFAULT '0',
85 `PassTouches` tinyint(4) NOT NULL DEFAULT '0',
86 `MediaURL` varchar(255) DEFAULT NULL,
87 `DynAttrs` text,
88 `PhysicsShapeType` tinyint(4) NOT NULL DEFAULT '0',
89 `Density` double NOT NULL DEFAULT '1000',
90 `GravityModifier` double NOT NULL DEFAULT '1',
91 `Friction` double NOT NULL DEFAULT '0.6',
92 `Restitution` double NOT NULL DEFAULT '0.5',
93 `KeyframeMotion` blob,
94 `AttachedPosX` double DEFAULT '0',
95 `AttachedPosY` double DEFAULT '0',
96 `AttachedPosZ` double DEFAULT '0',
97 PRIMARY KEY (`UUID`),
98 KEY `prims_regionuuid` (`RegionUUID`),
99 KEY `prims_scenegroupid` (`SceneGroupID`)
54) ENGINE=MyISAM DEFAULT CHARSET=latin1; 100) ENGINE=MyISAM DEFAULT CHARSET=latin1;
55 101
56CREATE TABLE `primshapes` ( 102CREATE TABLE IF NOT EXISTS `primshapes` (
57 `UUID` varchar(255) NOT NULL, 103 `Shape` int(11) DEFAULT NULL,
58 `Shape` int(11) default NULL, 104 `ScaleX` double NOT NULL DEFAULT '0',
59 `ScaleX` float default NULL, 105 `ScaleY` double NOT NULL DEFAULT '0',
60 `ScaleY` float default NULL, 106 `ScaleZ` double NOT NULL DEFAULT '0',
61 `ScaleZ` float default NULL, 107 `PCode` int(11) DEFAULT NULL,
62 `PCode` int(11) default NULL, 108 `PathBegin` int(11) DEFAULT NULL,
63 `PathBegin` int(11) default NULL, 109 `PathEnd` int(11) DEFAULT NULL,
64 `PathEnd` int(11) default NULL, 110 `PathScaleX` int(11) DEFAULT NULL,
65 `PathScaleX` int(11) default NULL, 111 `PathScaleY` int(11) DEFAULT NULL,
66 `PathScaleY` int(11) default NULL, 112 `PathShearX` int(11) DEFAULT NULL,
67 `PathShearX` int(11) default NULL, 113 `PathShearY` int(11) DEFAULT NULL,
68 `PathShearY` int(11) default NULL, 114 `PathSkew` int(11) DEFAULT NULL,
69 `PathSkew` int(11) default NULL, 115 `PathCurve` int(11) DEFAULT NULL,
70 `PathCurve` int(11) default NULL, 116 `PathRadiusOffset` int(11) DEFAULT NULL,
71 `PathRadiusOffset` int(11) default NULL, 117 `PathRevolutions` int(11) DEFAULT NULL,
72 `PathRevolutions` int(11) default NULL, 118 `PathTaperX` int(11) DEFAULT NULL,
73 `PathTaperX` int(11) default NULL, 119 `PathTaperY` int(11) DEFAULT NULL,
74 `PathTaperY` int(11) default NULL, 120 `PathTwist` int(11) DEFAULT NULL,
75 `PathTwist` int(11) default NULL, 121 `PathTwistBegin` int(11) DEFAULT NULL,
76 `PathTwistBegin` int(11) default NULL, 122 `ProfileBegin` int(11) DEFAULT NULL,
77 `ProfileBegin` int(11) default NULL, 123 `ProfileEnd` int(11) DEFAULT NULL,
78 `ProfileEnd` int(11) default NULL, 124 `ProfileCurve` int(11) DEFAULT NULL,
79 `ProfileCurve` int(11) default NULL, 125 `ProfileHollow` int(11) DEFAULT NULL,
80 `ProfileHollow` int(11) default NULL, 126 `State` int(11) DEFAULT NULL,
81 `State` int(11) default NULL,
82 `Texture` longblob, 127 `Texture` longblob,
83 `ExtraParams` longblob, 128 `ExtraParams` longblob,
84 PRIMARY KEY (`UUID`) 129 `UUID` char(36) NOT NULL DEFAULT '',
130 `Media` text,
131 `LastAttachPoint` int(4) NOT NULL DEFAULT '0',
132 PRIMARY KEY (`UUID`)
85) ENGINE=MyISAM DEFAULT CHARSET=latin1; 133) ENGINE=MyISAM DEFAULT CHARSET=latin1;
86 134
87CREATE TABLE `primitems` ( 135CREATE TABLE IF NOT EXISTS `primitems` (
88 `itemID` varchar(255) NOT NULL, 136 `invType` int(11) DEFAULT NULL,
89 `primID` varchar(255) default NULL, 137 `assetType` int(11) DEFAULT NULL,
90 `assetID` varchar(255) default NULL, 138 `name` varchar(255) DEFAULT NULL,
91 `parentFolderID` varchar(255) default NULL, 139 `description` varchar(255) DEFAULT NULL,
92 `invType` int(11) default NULL, 140 `creationDate` bigint(20) DEFAULT NULL,
93 `assetType` int(11) default NULL, 141 `nextPermissions` int(11) DEFAULT NULL,
94 `name` varchar(255) default NULL, 142 `currentPermissions` int(11) DEFAULT NULL,
95 `description` varchar(255) default NULL, 143 `basePermissions` int(11) DEFAULT NULL,
96 `creationDate` bigint(20) default NULL, 144 `everyonePermissions` int(11) DEFAULT NULL,
97 `creatorID` varchar(255) default NULL, 145 `groupPermissions` int(11) DEFAULT NULL,
98 `ownerID` varchar(255) default NULL, 146 `flags` int(11) NOT NULL DEFAULT '0',
99 `lastOwnerID` varchar(255) default NULL, 147 `itemID` char(36) NOT NULL DEFAULT '',
100 `groupID` varchar(255) default NULL, 148 `primID` char(36) DEFAULT NULL,
101 `nextPermissions` int(11) default NULL, 149 `assetID` char(36) DEFAULT NULL,
102 `currentPermissions` int(11) default NULL, 150 `parentFolderID` char(36) DEFAULT NULL,
103 `basePermissions` int(11) default NULL, 151 `CreatorID` varchar(255) NOT NULL DEFAULT '',
104 `everyonePermissions` int(11) default NULL, 152 `ownerID` char(36) DEFAULT NULL,
105 `groupPermissions` int(11) default NULL, 153 `groupID` char(36) DEFAULT NULL,
106 PRIMARY KEY (`itemID`) 154 `lastOwnerID` char(36) DEFAULT NULL,
155 PRIMARY KEY (`itemID`),
156 KEY `primitems_primid` (`primID`)
107) ENGINE=MyISAM DEFAULT CHARSET=latin1; 157) ENGINE=MyISAM DEFAULT CHARSET=latin1;
108 158
109CREATE TABLE `terrain` ( 159CREATE TABLE IF NOT EXISTS `terrain` (
110 `RegionUUID` varchar(255) default NULL, 160 `RegionUUID` varchar(255) DEFAULT NULL,
111 `Revision` int(11) default NULL, 161 `Revision` int(11) DEFAULT NULL,
112 `Heightfield` longblob 162 `Heightfield` longblob
113) ENGINE=MyISAM DEFAULT CHARSET=latin1; 163) ENGINE=MyISAM DEFAULT CHARSET=latin1;
114 164
115CREATE TABLE `land` ( 165CREATE TABLE IF NOT EXISTS `land` (
116 `UUID` varchar(255) NOT NULL, 166 `UUID` varchar(255) NOT NULL,
117 `RegionUUID` varchar(255) default NULL, 167 `RegionUUID` varchar(255) DEFAULT NULL,
118 `LocalLandID` int(11) default NULL, 168 `LocalLandID` int(11) DEFAULT NULL,
119 `Bitmap` longblob, 169 `Bitmap` longblob,
120 `Name` varchar(255) default NULL, 170 `Name` varchar(255) DEFAULT NULL,
121 `Description` varchar(255) default NULL, 171 `Description` varchar(255) DEFAULT NULL,
122 `OwnerUUID` varchar(255) default NULL, 172 `OwnerUUID` varchar(255) DEFAULT NULL,
123 `IsGroupOwned` int(11) default NULL, 173 `IsGroupOwned` int(11) DEFAULT NULL,
124 `Area` int(11) default NULL, 174 `Area` int(11) DEFAULT NULL,
125 `AuctionID` int(11) default NULL, 175 `AuctionID` int(11) DEFAULT NULL,
126 `Category` int(11) default NULL, 176 `Category` int(11) DEFAULT NULL,
127 `ClaimDate` int(11) default NULL, 177 `ClaimDate` int(11) DEFAULT NULL,
128 `ClaimPrice` int(11) default NULL, 178 `ClaimPrice` int(11) DEFAULT NULL,
129 `GroupUUID` varchar(255) default NULL, 179 `GroupUUID` varchar(255) DEFAULT NULL,
130 `SalePrice` int(11) default NULL, 180 `SalePrice` int(11) DEFAULT NULL,
131 `LandStatus` int(11) default NULL, 181 `LandStatus` int(11) DEFAULT NULL,
132 `LandFlags` int(11) default NULL, 182 `LandFlags` int(10) unsigned DEFAULT NULL,
133 `LandingType` int(11) default NULL, 183 `LandingType` int(11) DEFAULT NULL,
134 `MediaAutoScale` int(11) default NULL, 184 `MediaAutoScale` int(11) DEFAULT NULL,
135 `MediaTextureUUID` varchar(255) default NULL, 185 `MediaTextureUUID` varchar(255) DEFAULT NULL,
136 `MediaURL` varchar(255) default NULL, 186 `MediaURL` varchar(255) DEFAULT NULL,
137 `MusicURL` varchar(255) default NULL, 187 `MusicURL` varchar(255) DEFAULT NULL,
138 `PassHours` float default NULL, 188 `PassHours` float DEFAULT NULL,
139 `PassPrice` int(11) default NULL, 189 `PassPrice` int(11) DEFAULT NULL,
140 `SnapshotUUID` varchar(255) default NULL, 190 `SnapshotUUID` varchar(255) DEFAULT NULL,
141 `UserLocationX` float default NULL, 191 `UserLocationX` float DEFAULT NULL,
142 `UserLocationY` float default NULL, 192 `UserLocationY` float DEFAULT NULL,
143 `UserLocationZ` float default NULL, 193 `UserLocationZ` float DEFAULT NULL,
144 `UserLookAtX` float default NULL, 194 `UserLookAtX` float DEFAULT NULL,
145 `UserLookAtY` float default NULL, 195 `UserLookAtY` float DEFAULT NULL,
146 `UserLookAtZ` float default NULL, 196 `UserLookAtZ` float DEFAULT NULL,
147 `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', 197 `AuthbuyerID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
148 PRIMARY KEY (`UUID`) 198 `OtherCleanTime` int(11) NOT NULL DEFAULT '0',
199 `Dwell` int(11) NOT NULL DEFAULT '0',
200 `MediaType` varchar(32) NOT NULL DEFAULT 'none/none',
201 `MediaDescription` varchar(255) NOT NULL DEFAULT '',
202 `MediaSize` varchar(16) NOT NULL DEFAULT '0,0',
203 `MediaLoop` tinyint(1) NOT NULL DEFAULT '0',
204 `ObscureMusic` tinyint(1) NOT NULL DEFAULT '0',
205 `ObscureMedia` tinyint(1) NOT NULL DEFAULT '0',
206 PRIMARY KEY (`UUID`)
149) ENGINE=MyISAM DEFAULT CHARSET=utf8; 207) ENGINE=MyISAM DEFAULT CHARSET=utf8;
150 208
151CREATE TABLE `landaccesslist` ( 209CREATE TABLE IF NOT EXISTS `landaccesslist` (
152 `LandUUID` varchar(255) default NULL, 210 `LandUUID` varchar(255) DEFAULT NULL,
153 `AccessUUID` varchar(255) default NULL, 211 `AccessUUID` varchar(255) DEFAULT NULL,
154 `Flags` int(11) default NULL 212 `Flags` int(11) DEFAULT NULL,
213 `Expires` int(11) NOT NULL DEFAULT '0'
155) ENGINE=MyISAM DEFAULT CHARSET=latin1; 214) ENGINE=MyISAM DEFAULT CHARSET=latin1;
156 215
157COMMIT; 216CREATE TABLE IF NOT EXISTS `regionban` (
158 217 `regionUUID` varchar(36) NOT NULL,
159:VERSION 2 #--------------------- 218 `bannedUUID` varchar(36) NOT NULL,
160 219 `bannedIp` varchar(16) NOT NULL,
161BEGIN; 220 `bannedIpHostMask` varchar(16) NOT NULL
162 221) ENGINE=MyISAM DEFAULT CHARSET=utf8;
163CREATE index prims_regionuuid on prims(RegionUUID);
164CREATE index primitems_primid on primitems(primID);
165
166COMMIT;
167
168:VERSION 3 #---------------------
169
170BEGIN;
171 CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
172COMMIT;
173
174:VERSION 4 #---------------------
175
176BEGIN;
177
178ALTER TABLE primitems add flags integer not null default 0;
179
180COMMIT;
181
182:VERSION 5 #---------------------
183BEGIN;
184
185create table regionsettings (
186 regionUUID char(36) not null,
187 block_terraform integer not null,
188 block_fly integer not null,
189 allow_damage integer not null,
190 restrict_pushing integer not null,
191 allow_land_resell integer not null,
192 allow_land_join_divide integer not null,
193 block_show_in_search integer not null,
194 agent_limit integer not null,
195 object_bonus float not null,
196 maturity integer not null,
197 disable_scripts integer not null,
198 disable_collisions integer not null,
199 disable_physics integer not null,
200 terrain_texture_1 char(36) not null,
201 terrain_texture_2 char(36) not null,
202 terrain_texture_3 char(36) not null,
203 terrain_texture_4 char(36) not null,
204 elevation_1_nw float not null,
205 elevation_2_nw float not null,
206 elevation_1_ne float not null,
207 elevation_2_ne float not null,
208 elevation_1_se float not null,
209 elevation_2_se float not null,
210 elevation_1_sw float not null,
211 elevation_2_sw float not null,
212 water_height float not null,
213 terrain_raise_limit float not null,
214 terrain_lower_limit float not null,
215 use_estate_sun integer not null,
216 fixed_sun integer not null,
217 sun_position float not null,
218 covenant char(36),
219 primary key(regionUUID)
220);
221
222COMMIT;
223
224
225:VERSION 6 #---------------------
226
227BEGIN;
228
229alter table landaccesslist ENGINE = MyISAM;
230alter table migrations ENGINE = MyISAM;
231alter table primitems ENGINE = MyISAM;
232alter table prims ENGINE = MyISAM;
233alter table primshapes ENGINE = MyISAM;
234alter table regionsettings ENGINE = MyISAM;
235alter table terrain ENGINE = MyISAM;
236
237COMMIT;
238
239:VERSION 7 #---------------------
240
241BEGIN;
242
243ALTER TABLE prims change UUID UUIDold varchar(255);
244ALTER TABLE prims change RegionUUID RegionUUIDold varchar(255);
245ALTER TABLE prims change CreatorID CreatorIDold varchar(255);
246ALTER TABLE prims change OwnerID OwnerIDold varchar(255);
247ALTER TABLE prims change GroupID GroupIDold varchar(255);
248ALTER TABLE prims change LastOwnerID LastOwnerIDold varchar(255);
249ALTER TABLE prims add UUID char(36);
250ALTER TABLE prims add RegionUUID char(36);
251ALTER TABLE prims add CreatorID char(36);
252ALTER TABLE prims add OwnerID char(36);
253ALTER TABLE prims add GroupID char(36);
254ALTER TABLE prims add LastOwnerID char(36);
255UPDATE prims set UUID = UUIDold, RegionUUID = RegionUUIDold, CreatorID = CreatorIDold, OwnerID = OwnerIDold, GroupID = GroupIDold, LastOwnerID = LastOwnerIDold;
256ALTER TABLE prims drop UUIDold;
257ALTER TABLE prims drop RegionUUIDold;
258ALTER TABLE prims drop CreatorIDold;
259ALTER TABLE prims drop OwnerIDold;
260ALTER TABLE prims drop GroupIDold;
261ALTER TABLE prims drop LastOwnerIDold;
262ALTER TABLE prims add constraint primary key(UUID);
263ALTER TABLE prims add index prims_regionuuid(RegionUUID);
264
265COMMIT;
266
267:VERSION 8 #---------------------
268
269BEGIN;
270
271ALTER TABLE primshapes change UUID UUIDold varchar(255);
272ALTER TABLE primshapes add UUID char(36);
273UPDATE primshapes set UUID = UUIDold;
274ALTER TABLE primshapes drop UUIDold;
275ALTER TABLE primshapes add constraint primary key(UUID);
276
277COMMIT;
278
279:VERSION 9 #---------------------
280
281BEGIN;
282
283ALTER TABLE primitems change itemID itemIDold varchar(255);
284ALTER TABLE primitems change primID primIDold varchar(255);
285ALTER TABLE primitems change assetID assetIDold varchar(255);
286ALTER TABLE primitems change parentFolderID parentFolderIDold varchar(255);
287ALTER TABLE primitems change creatorID creatorIDold varchar(255);
288ALTER TABLE primitems change ownerID ownerIDold varchar(255);
289ALTER TABLE primitems change groupID groupIDold varchar(255);
290ALTER TABLE primitems change lastOwnerID lastOwnerIDold varchar(255);
291ALTER TABLE primitems add itemID char(36);
292ALTER TABLE primitems add primID char(36);
293ALTER TABLE primitems add assetID char(36);
294ALTER TABLE primitems add parentFolderID char(36);
295ALTER TABLE primitems add creatorID char(36);
296ALTER TABLE primitems add ownerID char(36);
297ALTER TABLE primitems add groupID char(36);
298ALTER TABLE primitems add lastOwnerID char(36);
299UPDATE primitems set itemID = itemIDold, primID = primIDold, assetID = assetIDold, parentFolderID = parentFolderIDold, creatorID = creatorIDold, ownerID = ownerIDold, groupID = groupIDold, lastOwnerID = lastOwnerIDold;
300ALTER TABLE primitems drop itemIDold;
301ALTER TABLE primitems drop primIDold;
302ALTER TABLE primitems drop assetIDold;
303ALTER TABLE primitems drop parentFolderIDold;
304ALTER TABLE primitems drop creatorIDold;
305ALTER TABLE primitems drop ownerIDold;
306ALTER TABLE primitems drop groupIDold;
307ALTER TABLE primitems drop lastOwnerIDold;
308ALTER TABLE primitems add constraint primary key(itemID);
309ALTER TABLE primitems add index primitems_primid(primID);
310
311COMMIT;
312
313:VERSION 10 #---------------------
314
315# 1 "010_RegionStore.sql"
316# 1 "<built-in>"
317# 1 "<command line>"
318# 1 "010_RegionStore.sql"
319BEGIN;
320
321DELETE FROM regionsettings;
322
323COMMIT;
324
325
326:VERSION 11 #---------------------
327
328BEGIN;
329
330ALTER TABLE prims change SceneGroupID SceneGroupIDold varchar(255);
331ALTER TABLE prims add SceneGroupID char(36);
332UPDATE prims set SceneGroupID = SceneGroupIDold;
333ALTER TABLE prims drop SceneGroupIDold;
334ALTER TABLE prims add index prims_scenegroupid(SceneGroupID);
335
336COMMIT;
337
338:VERSION 12 #---------------------
339
340BEGIN;
341
342ALTER TABLE prims add index prims_parentid(ParentID);
343
344COMMIT;
345
346:VERSION 13 #---------------------
347begin;
348
349drop table regionsettings;
350 222
351CREATE TABLE `regionsettings` ( 223CREATE TABLE IF NOT EXISTS `regionsettings` (
352 `regionUUID` char(36) NOT NULL, 224 `regionUUID` char(36) NOT NULL,
353 `block_terraform` int(11) NOT NULL, 225 `block_terraform` int(11) NOT NULL,
354 `block_fly` int(11) NOT NULL, 226 `block_fly` int(11) NOT NULL,
@@ -358,7 +230,7 @@ CREATE TABLE `regionsettings` (
358 `allow_land_join_divide` int(11) NOT NULL, 230 `allow_land_join_divide` int(11) NOT NULL,
359 `block_show_in_search` int(11) NOT NULL, 231 `block_show_in_search` int(11) NOT NULL,
360 `agent_limit` int(11) NOT NULL, 232 `agent_limit` int(11) NOT NULL,
361 `object_bonus` float NOT NULL, 233 `object_bonus` double NOT NULL,
362 `maturity` int(11) NOT NULL, 234 `maturity` int(11) NOT NULL,
363 `disable_scripts` int(11) NOT NULL, 235 `disable_scripts` int(11) NOT NULL,
364 `disable_collisions` int(11) NOT NULL, 236 `disable_collisions` int(11) NOT NULL,
@@ -367,360 +239,35 @@ CREATE TABLE `regionsettings` (
367 `terrain_texture_2` char(36) NOT NULL, 239 `terrain_texture_2` char(36) NOT NULL,
368 `terrain_texture_3` char(36) NOT NULL, 240 `terrain_texture_3` char(36) NOT NULL,
369 `terrain_texture_4` char(36) NOT NULL, 241 `terrain_texture_4` char(36) NOT NULL,
370 `elevation_1_nw` float NOT NULL, 242 `elevation_1_nw` double NOT NULL,
371 `elevation_2_nw` float NOT NULL, 243 `elevation_2_nw` double NOT NULL,
372 `elevation_1_ne` float NOT NULL, 244 `elevation_1_ne` double NOT NULL,
373 `elevation_2_ne` float NOT NULL, 245 `elevation_2_ne` double NOT NULL,
374 `elevation_1_se` float NOT NULL, 246 `elevation_1_se` double NOT NULL,
375 `elevation_2_se` float NOT NULL, 247 `elevation_2_se` double NOT NULL,
376 `elevation_1_sw` float NOT NULL, 248 `elevation_1_sw` double NOT NULL,
377 `elevation_2_sw` float NOT NULL, 249 `elevation_2_sw` double NOT NULL,
378 `water_height` float NOT NULL, 250 `water_height` double NOT NULL,
379 `terrain_raise_limit` float NOT NULL, 251 `terrain_raise_limit` double NOT NULL,
380 `terrain_lower_limit` float NOT NULL, 252 `terrain_lower_limit` double NOT NULL,
381 `use_estate_sun` int(11) NOT NULL, 253 `use_estate_sun` int(11) NOT NULL,
382 `fixed_sun` int(11) NOT NULL, 254 `fixed_sun` int(11) NOT NULL,
383 `sun_position` float NOT NULL, 255 `sun_position` double NOT NULL,
384 `covenant` char(36) default NULL, 256 `covenant` char(36) DEFAULT NULL,
385 `Sandbox` tinyint(4) NOT NULL, 257 `Sandbox` tinyint(4) NOT NULL,
386 PRIMARY KEY (`regionUUID`) 258 `sunvectorx` double NOT NULL DEFAULT '0',
387) ENGINE=MyISAM; 259 `sunvectory` double NOT NULL DEFAULT '0',
388 260 `sunvectorz` double NOT NULL DEFAULT '0',
389commit; 261 `loaded_creation_id` varchar(64) DEFAULT NULL,
390 262 `loaded_creation_datetime` int(10) unsigned NOT NULL DEFAULT '0',
391:VERSION 16 #--------------------- 263 `map_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
392 264 `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
393BEGIN; 265 `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
394 266 `covenant_datetime` int(10) unsigned NOT NULL DEFAULT '0',
395ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0; 267 PRIMARY KEY (`regionUUID`)
396ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0; 268) ENGINE=MyISAM DEFAULT CHARSET=utf8;
397ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0;
398ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0;
399ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0;
400ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000';
401ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0;
402ALTER TABLE prims ADD COLUMN TextureAnimation blob;
403ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0;
404ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0;
405ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0;
406ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0;
407ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0;
408ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0;
409ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0;
410ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0;
411ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0;
412ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0;
413ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0;
414ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0;
415ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0;
416ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10;
417ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0;
418
419COMMIT;
420
421
422:VERSION 17 #---------------------
423
424BEGIN;
425
426ALTER TABLE prims ADD COLUMN ColorR integer not null default 0;
427ALTER TABLE prims ADD COLUMN ColorG integer not null default 0;
428ALTER TABLE prims ADD COLUMN ColorB integer not null default 0;
429ALTER TABLE prims ADD COLUMN ColorA integer not null default 0;
430ALTER TABLE prims ADD COLUMN ParticleSystem blob;
431
432COMMIT;
433
434
435:VERSION 18 #---------------------
436
437begin;
438
439ALTER TABLE prims ADD COLUMN ClickAction tinyint NOT NULL default 0;
440
441commit;
442
443:VERSION 19 #---------------------
444
445begin;
446
447ALTER TABLE prims ADD COLUMN Material tinyint NOT NULL default 3;
448
449commit;
450
451
452:VERSION 20 #---------------------
453
454begin;
455
456ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0;
457ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0;
458
459commit;
460
461:VERSION 21 #---------------------
462
463begin;
464
465ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0;
466ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0;
467ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0;
468
469commit;
470
471
472:VERSION 22 #---------------------
473
474BEGIN;
475
476ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000';
477ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0;
478
479COMMIT;
480
481:VERSION 23 #---------------------
482
483BEGIN;
484
485ALTER TABLE prims ADD COLUMN LinkNumber integer not null default 0;
486
487COMMIT;
488
489:VERSION 24 #---------------------
490
491BEGIN;
492
493alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL;
494alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL;
495alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL;
496alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL;
497alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL;
498alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL;
499alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL;
500alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL;
501alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL;
502alter table regionsettings change column `water_height` `water_height` double NOT NULL;
503alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL;
504alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL;
505alter table regionsettings change column `sun_position` `sun_position` double NOT NULL;
506
507COMMIT;
508
509
510:VERSION 25 #---------------------
511
512BEGIN;
513
514alter table prims change column `PositionX` `PositionX` double default NULL;
515alter table prims change column `PositionY` `PositionY` double default NULL;
516alter table prims change column `PositionZ` `PositionZ` double default NULL;
517alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL;
518alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL;
519alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL;
520alter table prims change column `VelocityX` `VelocityX` double default NULL;
521alter table prims change column `VelocityY` `VelocityY` double default NULL;
522alter table prims change column `VelocityZ` `VelocityZ` double default NULL;
523alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL;
524alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL;
525alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL;
526alter table prims change column `AccelerationX` `AccelerationX` double default NULL;
527alter table prims change column `AccelerationY` `AccelerationY` double default NULL;
528alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL;
529alter table prims change column `RotationX` `RotationX` double default NULL;
530alter table prims change column `RotationY` `RotationY` double default NULL;
531alter table prims change column `RotationZ` `RotationZ` double default NULL;
532alter table prims change column `RotationW` `RotationW` double default NULL;
533alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL;
534alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL;
535alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL;
536alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL;
537alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL;
538alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL;
539alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL;
540alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0';
541alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0';
542alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0';
543alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0';
544alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0';
545alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0';
546alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0';
547alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0';
548alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0';
549alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0';
550alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0';
551
552alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0';
553alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0';
554alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0';
555
556COMMIT;
557
558:VERSION 26 #---------------------
559
560begin;
561
562alter table prims change column `PositionX` `PositionX` double default NULL;
563alter table prims change column `PositionY` `PositionY` double default NULL;
564alter table prims change column `PositionZ` `PositionZ` double default NULL;
565alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL;
566alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL;
567alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL;
568alter table prims change column `VelocityX` `VelocityX` double default NULL;
569alter table prims change column `VelocityY` `VelocityY` double default NULL;
570alter table prims change column `VelocityZ` `VelocityZ` double default NULL;
571alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL;
572alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL;
573alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL;
574alter table prims change column `AccelerationX` `AccelerationX` double default NULL;
575alter table prims change column `AccelerationY` `AccelerationY` double default NULL;
576alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL;
577alter table prims change column `RotationX` `RotationX` double default NULL;
578alter table prims change column `RotationY` `RotationY` double default NULL;
579alter table prims change column `RotationZ` `RotationZ` double default NULL;
580alter table prims change column `RotationW` `RotationW` double default NULL;
581alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL;
582alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL;
583alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL;
584alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL;
585alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL;
586alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL;
587alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL;
588alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0';
589alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0';
590alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0';
591alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0';
592alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0';
593alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0';
594alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0';
595alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0';
596alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0';
597alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0';
598alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0';
599
600commit;
601
602:VERSION 27 #---------------------
603
604BEGIN;
605
606ALTER TABLE prims DROP COLUMN ParentID;
607
608COMMIT;
609
610:VERSION 28 #---------------------
611
612BEGIN;
613
614update terrain
615 set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))
616 where RegionUUID not like '%-%';
617
618
619update landaccesslist
620 set LandUUID = concat(substr(LandUUID, 1, 8), "-", substr(LandUUID, 9, 4), "-", substr(LandUUID, 13, 4), "-", substr(LandUUID, 17, 4), "-", substr(LandUUID, 21, 12))
621 where LandUUID not like '%-%';
622
623update landaccesslist
624 set AccessUUID = concat(substr(AccessUUID, 1, 8), "-", substr(AccessUUID, 9, 4), "-", substr(AccessUUID, 13, 4), "-", substr(AccessUUID, 17, 4), "-", substr(AccessUUID, 21, 12))
625 where AccessUUID not like '%-%';
626
627
628update prims
629 set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))
630 where UUID not like '%-%';
631
632update prims
633 set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))
634 where RegionUUID not like '%-%';
635
636update prims
637 set SceneGroupID = concat(substr(SceneGroupID, 1, 8), "-", substr(SceneGroupID, 9, 4), "-", substr(SceneGroupID, 13, 4), "-", substr(SceneGroupID, 17, 4), "-", substr(SceneGroupID, 21, 12))
638 where SceneGroupID not like '%-%';
639
640update prims
641 set CreatorID = concat(substr(CreatorID, 1, 8), "-", substr(CreatorID, 9, 4), "-", substr(CreatorID, 13, 4), "-", substr(CreatorID, 17, 4), "-", substr(CreatorID, 21, 12))
642 where CreatorID not like '%-%';
643
644update prims
645 set OwnerID = concat(substr(OwnerID, 1, 8), "-", substr(OwnerID, 9, 4), "-", substr(OwnerID, 13, 4), "-", substr(OwnerID, 17, 4), "-", substr(OwnerID, 21, 12))
646 where OwnerID not like '%-%';
647
648update prims
649 set GroupID = concat(substr(GroupID, 1, 8), "-", substr(GroupID, 9, 4), "-", substr(GroupID, 13, 4), "-", substr(GroupID, 17, 4), "-", substr(GroupID, 21, 12))
650 where GroupID not like '%-%';
651
652update prims
653 set LastOwnerID = concat(substr(LastOwnerID, 1, 8), "-", substr(LastOwnerID, 9, 4), "-", substr(LastOwnerID, 13, 4), "-", substr(LastOwnerID, 17, 4), "-", substr(LastOwnerID, 21, 12))
654 where LastOwnerID not like '%-%';
655
656
657update primshapes
658 set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))
659 where UUID not like '%-%';
660
661
662update land
663 set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))
664 where UUID not like '%-%';
665
666update land
667 set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))
668 where RegionUUID not like '%-%';
669
670update land
671 set OwnerUUID = concat(substr(OwnerUUID, 1, 8), "-", substr(OwnerUUID, 9, 4), "-", substr(OwnerUUID, 13, 4), "-", substr(OwnerUUID, 17, 4), "-", substr(OwnerUUID, 21, 12))
672 where OwnerUUID not like '%-%';
673
674update land
675 set GroupUUID = concat(substr(GroupUUID, 1, 8), "-", substr(GroupUUID, 9, 4), "-", substr(GroupUUID, 13, 4), "-", substr(GroupUUID, 17, 4), "-", substr(GroupUUID, 21, 12))
676 where GroupUUID not like '%-%';
677
678update land
679 set MediaTextureUUID = concat(substr(MediaTextureUUID, 1, 8), "-", substr(MediaTextureUUID, 9, 4), "-", substr(MediaTextureUUID, 13, 4), "-", substr(MediaTextureUUID, 17, 4), "-", substr(MediaTextureUUID, 21, 12))
680 where MediaTextureUUID not like '%-%';
681
682update land
683 set SnapshotUUID = concat(substr(SnapshotUUID, 1, 8), "-", substr(SnapshotUUID, 9, 4), "-", substr(SnapshotUUID, 13, 4), "-", substr(SnapshotUUID, 17, 4), "-", substr(SnapshotUUID, 21, 12))
684 where SnapshotUUID not like '%-%';
685
686update land
687 set AuthbuyerID = concat(substr(AuthbuyerID, 1, 8), "-", substr(AuthbuyerID, 9, 4), "-", substr(AuthbuyerID, 13, 4), "-", substr(AuthbuyerID, 17, 4), "-", substr(AuthbuyerID, 21, 12))
688 where AuthbuyerID not like '%-%';
689
690COMMIT;
691
692:VERSION 29 #---------------------
693
694BEGIN;
695
696ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0;
697
698COMMIT;
699
700:VERSION 30 #---------------------
701
702BEGIN;
703
704ALTER TABLE regionsettings ADD COLUMN loaded_creation_date varchar(20) default NULL;
705ALTER TABLE regionsettings ADD COLUMN loaded_creation_time varchar(20) default NULL;
706ALTER TABLE regionsettings ADD COLUMN loaded_creation_id varchar(64) default NULL;
707
708COMMIT;
709
710:VERSION 31 #---------------------
711
712BEGIN;
713
714ALTER TABLE regionsettings DROP COLUMN loaded_creation_date;
715ALTER TABLE regionsettings DROP COLUMN loaded_creation_time;
716ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0;
717
718COMMIT;
719
720:VERSION 32
721 269
722BEGIN; 270CREATE TABLE IF NOT EXISTS `regionwindlight` (
723CREATE TABLE `regionwindlight` (
724 `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', 271 `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000',
725 `water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000', 272 `water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000',
726 `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000', 273 `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000',
@@ -779,172 +326,144 @@ CREATE TABLE `regionwindlight` (
779 `cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00', 326 `cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00',
780 `cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53', 327 `cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53',
781 `cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12', 328 `cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12',
782 `cloud_scroll_x` float(3,2) unsigned NOT NULL DEFAULT '0.20', 329 `cloud_scroll_x` float(4,2) NOT NULL DEFAULT '0.20',
783 `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', 330 `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
784 `cloud_scroll_y` float(3,2) unsigned NOT NULL DEFAULT '0.01', 331 `cloud_scroll_y` float(4,2) NOT NULL DEFAULT '0.01',
785 `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', 332 `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
786 `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1', 333 `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1',
787 PRIMARY KEY (`region_id`) 334 PRIMARY KEY (`region_id`)
788); 335) ENGINE=MyISAM DEFAULT CHARSET=utf8;
789
790
791:VERSION 33 #---------------------
792
793BEGIN;
794ALTER TABLE regionsettings ADD map_tile_ID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
795COMMIT;
796
797:VERSION 34 #---------------------
798
799BEGIN;
800ALTER TABLE `regionwindlight` CHANGE COLUMN `cloud_scroll_x` `cloud_scroll_x` FLOAT(4,2) NOT NULL DEFAULT '0.20' AFTER `cloud_detail_density`, CHANGE COLUMN `cloud_scroll_y` `cloud_scroll_y` FLOAT(4,2) NOT NULL DEFAULT '0.01' AFTER `cloud_scroll_x_lock`;
801COMMIT;
802
803:VERSION 35 #---------------------
804
805BEGIN;
806ALTER TABLE prims ADD COLUMN MediaURL varchar(255);
807ALTER TABLE primshapes ADD COLUMN Media TEXT;
808COMMIT;
809
810:VERSION 36 #---------------------
811
812BEGIN;
813ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none' ;
814ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT '';
815ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0';
816ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE;
817ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE;
818ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE;
819COMMIT;
820
821:VERSION 37 #---------------------
822
823BEGIN;
824
825ALTER TABLE `prims` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT '';
826ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT '';
827
828COMMIT;
829
830:VERSION 38 #---------------------
831
832BEGIN;
833
834alter table land ENGINE = MyISAM;
835alter table landaccesslist ENGINE = MyISAM;
836alter table migrations ENGINE = MyISAM;
837alter table primitems ENGINE = MyISAM;
838alter table prims ENGINE = MyISAM;
839alter table primshapes ENGINE = MyISAM;
840alter table regionban ENGINE = MyISAM;
841alter table regionsettings ENGINE = MyISAM;
842alter table terrain ENGINE = MyISAM;
843
844COMMIT;
845
846:VERSION 39 #--------------- Telehub support
847 336
848BEGIN;
849CREATE TABLE IF NOT EXISTS `spawn_points` ( 337CREATE TABLE IF NOT EXISTS `spawn_points` (
850 `RegionID` varchar(36) COLLATE utf8_unicode_ci NOT NULL, 338 `RegionID` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
851 `Yaw` float NOT NULL, 339 `Yaw` float NOT NULL,
852 `Pitch` float NOT NULL, 340 `Pitch` float NOT NULL,
853 `Distance` float NOT NULL, 341 `Distance` float NOT NULL,
854 KEY `RegionID` (`RegionID`) 342 KEY `RegionID` (`RegionID`)
855) ENGINE=MyISAM; 343) ENGINE=MyISAM DEFAULT CHARSET=utf8;
856 344
857ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL; 345CREATE TABLE IF NOT EXISTS `regionenvironment` (
858COMMIT; 346 `region_id` varchar(36) NOT NULL,
347 `llsd_settings` text NOT NULL,
348 PRIMARY KEY (`region_id`)
349) ENGINE=MyISAM DEFAULT CHARSET=utf8;
859 350
860:VERSION 40 #---------------- Parcels for sale 351CREATE TABLE IF NOT EXISTS `regionextra` (
352 `RegionID` char(36) NOT NULL,
353 `Name` varchar(32) NOT NULL,
354 `value` text,
355 PRIMARY KEY (`RegionID`,`Name`)
356) ENGINE=MyISAM DEFAULT CHARSET=utf8;
861 357
862BEGIN;
863ALTER TABLE `regionsettings` ADD COLUMN `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
864COMMIT; 358COMMIT;
865 359
866:VERSION 41 #---------------- Timed bans/access 360:VERSION 52 #---- avination fields
867 361
868BEGIN; 362BEGIN;
869ALTER TABLE `landaccesslist` ADD COLUMN `Expires` INTEGER NOT NULL DEFAULT 0;
870COMMIT;
871 363
872:VERSION 42 #--------------------- Region Covenant changed time 364ALTER TABLE `prims` ADD COLUMN `PassCollisions` tinyint(4) NOT NULL default '0';
365ALTER TABLE `prims` ADD COLUMN `Vehicle` TEXT default NULL;
366ALTER TABLE `regionsettings` ADD COLUMN `block_search` tinyint(4) NOT NULL default '0';
367ALTER TABLE `regionsettings` ADD COLUMN `casino` tinyint(4) NOT NULL default '0';
368ALTER TABLE `land` ADD COLUMN `SeeAVs` tinyint(4) NOT NULL default '1';
369ALTER TABLE `land` ADD COLUMN `AnyAVSounds` tinyint(4) NOT NULL default '1';
370ALTER TABLE `land` ADD COLUMN `GroupAVSounds` tinyint(4) NOT NULL default '1';
873 371
874BEGIN;
875ALTER TABLE regionsettings ADD COLUMN covenant_datetime int unsigned NOT NULL DEFAULT '0';
876COMMIT; 372COMMIT;
877 373
878:VERSION 43 #--------------------- 374:VERSION 53 #---- STATUS ROTATION axis locks
879 375
880BEGIN; 376BEGIN;
881 377
882ALTER TABLE `regionsettings` MODIFY COLUMN `TelehubObject` VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; 378ALTER TABLE `prims` ADD COLUMN `RotationAxisLocks` tinyint(4) NOT NULL default '0';
883 379
884COMMIT; 380COMMIT;
885 381
886:VERSION 44 #--------------------- Environment Settings 382:VERSION 54 #----- add baked terrain store
887 383
888BEGIN; 384BEGIN;
889 385
890CREATE TABLE `regionenvironment` ( 386CREATE TABLE IF NOT EXISTS `bakedterrain` (
891 `region_id` varchar(36) NOT NULL, 387 `RegionUUID` varchar(255) DEFAULT NULL,
892 `llsd_settings` TEXT NOT NULL, 388 `Revision` int(11) DEFAULT NULL,
893 PRIMARY KEY (`region_id`) 389 `Heightfield` longblob
894) ENGINE=MyISAM DEFAULT CHARSET=utf8; 390) ENGINE=MyISAM DEFAULT CHARSET=utf8;
895 391
896COMMIT; 392COMMIT;
897 393
898:VERSION 45 394:VERSION 55 #----- Increase float precision for windlight needed by scripts
899
900BEGIN;
901
902CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32) not null, `value` text, primary key(`RegionID`, `Name`));
903
904COMMIT;
905
906:VERSION 46 #---------------- Dynamic attributes
907 395
908BEGIN; 396BEGIN;
909 397
910ALTER TABLE prims ADD COLUMN DynAttrs TEXT; 398ALTER TABLE `regionwindlight`
911
912COMMIT;
913
914:VERSION 47 #---------------- Extra physics params
915
916BEGIN;
917 399
918ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0'; 400MODIFY `water_fog_density_exponent` float(9,7) unsigned NOT NULL DEFAULT '4.0',
919ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000'; 401MODIFY `underwater_fog_modifier` float(9,8) unsigned NOT NULL DEFAULT '0.25',
920ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1'; 402MODIFY `reflection_wavelet_scale_1` float(9,7) unsigned NOT NULL DEFAULT '2.0',
921ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6'; 403MODIFY `reflection_wavelet_scale_2` float(9,7) unsigned NOT NULL DEFAULT '2.0',
922ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5'; 404MODIFY `reflection_wavelet_scale_3` float(9,7) unsigned NOT NULL DEFAULT '2.0',
405MODIFY `fresnel_scale` float(9,8) unsigned NOT NULL DEFAULT '0.40',
406MODIFY `fresnel_offset` float(9,8) unsigned NOT NULL DEFAULT '0.50',
407MODIFY `refract_scale_above` float(9,8) unsigned NOT NULL DEFAULT '0.03',
408MODIFY `refract_scale_below` float(9,8) unsigned NOT NULL DEFAULT '0.20',
409MODIFY `blur_multiplier` float(9,8) unsigned NOT NULL DEFAULT '0.040',
410MODIFY `big_wave_direction_x` float(9,8) NOT NULL DEFAULT '1.05',
411MODIFY `big_wave_direction_y` float(9,8) NOT NULL DEFAULT '-0.42',
412MODIFY `little_wave_direction_x` float(9,8) NOT NULL DEFAULT '1.11',
413MODIFY `little_wave_direction_y` float(9,8) NOT NULL DEFAULT '-1.16',
414MODIFY `horizon_r` float(9,8) unsigned NOT NULL DEFAULT '0.25',
415MODIFY `horizon_g` float(9,8) unsigned NOT NULL DEFAULT '0.25',
416MODIFY `horizon_b` float(9,8) unsigned NOT NULL DEFAULT '0.32',
417MODIFY `horizon_i` float(9,8) unsigned NOT NULL DEFAULT '0.32',
418MODIFY `haze_horizon` float(9,8) unsigned NOT NULL DEFAULT '0.19',
419MODIFY `blue_density_r` float(9,8) unsigned NOT NULL DEFAULT '0.12',
420MODIFY `blue_density_g` float(9,8) unsigned NOT NULL DEFAULT '0.22',
421MODIFY `blue_density_b` float(9,8) unsigned NOT NULL DEFAULT '0.38',
422MODIFY `blue_density_i` float(9,8) unsigned NOT NULL DEFAULT '0.38',
423MODIFY `haze_density` float(9,8) unsigned NOT NULL DEFAULT '0.70',
424MODIFY `density_multiplier` float(9,8) unsigned NOT NULL DEFAULT '0.18',
425MODIFY `distance_multiplier` float(9,6) unsigned NOT NULL DEFAULT '0.8',
426MODIFY `sun_moon_color_r` float(9,8) unsigned NOT NULL DEFAULT '0.24',
427MODIFY `sun_moon_color_g` float(9,8) unsigned NOT NULL DEFAULT '0.26',
428MODIFY `sun_moon_color_b` float(9,8) unsigned NOT NULL DEFAULT '0.30',
429MODIFY `sun_moon_color_i` float(9,8) unsigned NOT NULL DEFAULT '0.30',
430MODIFY `sun_moon_position` float(9,8) unsigned NOT NULL DEFAULT '0.317',
431MODIFY `ambient_r` float(9,8) unsigned NOT NULL DEFAULT '0.35',
432MODIFY `ambient_g` float(9,8) unsigned NOT NULL DEFAULT '0.35',
433MODIFY `ambient_b` float(9,8) unsigned NOT NULL DEFAULT '0.35',
434MODIFY `ambient_i` float(9,8) unsigned NOT NULL DEFAULT '0.35',
435MODIFY `east_angle` float(9,8) unsigned NOT NULL DEFAULT '0.00',
436MODIFY `sun_glow_focus` float(9,8) unsigned NOT NULL DEFAULT '0.10',
437MODIFY `sun_glow_size` float(9,8) unsigned NOT NULL DEFAULT '1.75',
438MODIFY `scene_gamma` float(9,7) unsigned NOT NULL DEFAULT '1.00',
439MODIFY `star_brightness` float(9,8) unsigned NOT NULL DEFAULT '0.00',
440MODIFY `cloud_color_r` float(9,8) unsigned NOT NULL DEFAULT '0.41',
441MODIFY `cloud_color_g` float(9,8) unsigned NOT NULL DEFAULT '0.41',
442MODIFY `cloud_color_b` float(9,8) unsigned NOT NULL DEFAULT '0.41',
443MODIFY `cloud_color_i` float(9,8) unsigned NOT NULL DEFAULT '0.41',
444MODIFY `cloud_x` float(9,8) unsigned NOT NULL DEFAULT '1.00',
445MODIFY `cloud_y` float(9,8) unsigned NOT NULL DEFAULT '0.53',
446MODIFY `cloud_density` float(9,8) unsigned NOT NULL DEFAULT '1.00',
447MODIFY `cloud_coverage` float(9,8) unsigned NOT NULL DEFAULT '0.27',
448MODIFY `cloud_scale` float(9,8) unsigned NOT NULL DEFAULT '0.42',
449MODIFY `cloud_detail_x` float(9,8) unsigned NOT NULL DEFAULT '1.00',
450MODIFY `cloud_detail_y` float(9,8) unsigned NOT NULL DEFAULT '0.53',
451MODIFY `cloud_detail_density` float(9,8) unsigned NOT NULL DEFAULT '0.12',
452MODIFY `cloud_scroll_x` float(9,7) NOT NULL DEFAULT '0.20',
453MODIFY `cloud_scroll_y` float(9,7) NOT NULL DEFAULT '0.01';
923 454
924COMMIT; 455COMMIT;
925 456
926:VERSION 48 #---------------- Keyframes 457:VERSION 56 #----- Add RezzerID field in table prims
927 458
928BEGIN; 459BEGIN;
929 460
930ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob; 461ALTER TABLE `prims` ADD COLUMN `RezzerID` char(36) DEFAULT NULL;
931 462
932COMMIT; 463COMMIT;
933 464
934:VERSION 49 #--------------------- Save attachment info 465:VERSION 57 #----- Add physics inertia data
935 466
936BEGIN; 467BEGIN;
937ALTER TABLE prims ADD COLUMN AttachedPosX double default 0; 468ALTER TABLE `prims` ADD COLUMN `PhysInertia` TEXT default NULL;
938ALTER TABLE prims ADD COLUMN AttachedPosY double default 0;
939ALTER TABLE prims ADD COLUMN AttachedPosZ double default 0;
940ALTER TABLE primshapes ADD COLUMN LastAttachPoint int(4) not null default '0';
941COMMIT; 469COMMIT;
942
943:VERSION 50 #---- Change LandFlags to unsigned
944
945BEGIN;
946
947ALTER TABLE land CHANGE COLUMN LandFlags LandFlags int unsigned default null;
948
949COMMIT;
950