diff options
author | AlexRa | 2010-05-01 17:43:10 +0300 |
---|---|---|
committer | AlexRa | 2010-05-18 22:16:06 +0300 |
commit | e4419c34c30e1cf6529ced125f0c05aed24644a4 (patch) | |
tree | b54d5aff69c63fefc27dea2b938c1838974d77ac /OpenSim/Data/MySQL/Resources/RegionStore.migrations | |
parent | Added MySqlMigrations.cs (supports stored proc/funcs) (diff) | |
download | opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.zip opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.gz opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.bz2 opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.xz |
Converted MySQL migration history to the new format
Replaced all NNN_StoreName.sql migration resources with a more
readable, single-file-per-store
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/RegionStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 806 |
1 files changed, 806 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations new file mode 100644 index 0000000..3dab67e --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -0,0 +1,806 @@ | |||
1 | | ||
2 | :VERSION 1 #--------------------- | ||
3 | |||
4 | BEGIN; | ||
5 | |||
6 | CREATE TABLE `prims` ( | ||
7 | `UUID` varchar(255) NOT NULL, | ||
8 | `RegionUUID` varchar(255) default NULL, | ||
9 | `ParentID` int(11) default NULL, | ||
10 | `CreationDate` int(11) default NULL, | ||
11 | `Name` varchar(255) default NULL, | ||
12 | `SceneGroupID` varchar(255) default NULL, | ||
13 | `Text` varchar(255) default NULL, | ||
14 | `Description` varchar(255) default NULL, | ||
15 | `SitName` varchar(255) default NULL, | ||
16 | `TouchName` varchar(255) default NULL, | ||
17 | `ObjectFlags` int(11) default NULL, | ||
18 | `CreatorID` varchar(255) default NULL, | ||
19 | `OwnerID` varchar(255) default NULL, | ||
20 | `GroupID` varchar(255) default NULL, | ||
21 | `LastOwnerID` varchar(255) default NULL, | ||
22 | `OwnerMask` int(11) default NULL, | ||
23 | `NextOwnerMask` int(11) default NULL, | ||
24 | `GroupMask` int(11) default NULL, | ||
25 | `EveryoneMask` int(11) default NULL, | ||
26 | `BaseMask` int(11) default NULL, | ||
27 | `PositionX` float default NULL, | ||
28 | `PositionY` float default NULL, | ||
29 | `PositionZ` float default NULL, | ||
30 | `GroupPositionX` float default NULL, | ||
31 | `GroupPositionY` float default NULL, | ||
32 | `GroupPositionZ` float default NULL, | ||
33 | `VelocityX` float default NULL, | ||
34 | `VelocityY` float default NULL, | ||
35 | `VelocityZ` float default NULL, | ||
36 | `AngularVelocityX` float default NULL, | ||
37 | `AngularVelocityY` float default NULL, | ||
38 | `AngularVelocityZ` float default NULL, | ||
39 | `AccelerationX` float default NULL, | ||
40 | `AccelerationY` float default NULL, | ||
41 | `AccelerationZ` float default NULL, | ||
42 | `RotationX` float default NULL, | ||
43 | `RotationY` float default NULL, | ||
44 | `RotationZ` float default NULL, | ||
45 | `RotationW` float default NULL, | ||
46 | `SitTargetOffsetX` float default NULL, | ||
47 | `SitTargetOffsetY` float default NULL, | ||
48 | `SitTargetOffsetZ` float default NULL, | ||
49 | `SitTargetOrientW` float default NULL, | ||
50 | `SitTargetOrientX` float default NULL, | ||
51 | `SitTargetOrientY` float default NULL, | ||
52 | `SitTargetOrientZ` float default NULL, | ||
53 | PRIMARY KEY (`UUID`) | ||
54 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
55 | |||
56 | CREATE TABLE `primshapes` ( | ||
57 | `UUID` varchar(255) NOT NULL, | ||
58 | `Shape` int(11) default NULL, | ||
59 | `ScaleX` float default NULL, | ||
60 | `ScaleY` float default NULL, | ||
61 | `ScaleZ` float default NULL, | ||
62 | `PCode` int(11) default NULL, | ||
63 | `PathBegin` int(11) default NULL, | ||
64 | `PathEnd` int(11) default NULL, | ||
65 | `PathScaleX` int(11) default NULL, | ||
66 | `PathScaleY` int(11) default NULL, | ||
67 | `PathShearX` int(11) default NULL, | ||
68 | `PathShearY` int(11) default NULL, | ||
69 | `PathSkew` int(11) default NULL, | ||
70 | `PathCurve` int(11) default NULL, | ||
71 | `PathRadiusOffset` int(11) default NULL, | ||
72 | `PathRevolutions` int(11) default NULL, | ||
73 | `PathTaperX` int(11) default NULL, | ||
74 | `PathTaperY` int(11) default NULL, | ||
75 | `PathTwist` int(11) default NULL, | ||
76 | `PathTwistBegin` int(11) default NULL, | ||
77 | `ProfileBegin` int(11) default NULL, | ||
78 | `ProfileEnd` int(11) default NULL, | ||
79 | `ProfileCurve` int(11) default NULL, | ||
80 | `ProfileHollow` int(11) default NULL, | ||
81 | `State` int(11) default NULL, | ||
82 | `Texture` longblob, | ||
83 | `ExtraParams` longblob, | ||
84 | PRIMARY KEY (`UUID`) | ||
85 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
86 | |||
87 | CREATE TABLE `primitems` ( | ||
88 | `itemID` varchar(255) NOT NULL, | ||
89 | `primID` varchar(255) default NULL, | ||
90 | `assetID` varchar(255) default NULL, | ||
91 | `parentFolderID` varchar(255) default NULL, | ||
92 | `invType` int(11) default NULL, | ||
93 | `assetType` int(11) default NULL, | ||
94 | `name` varchar(255) default NULL, | ||
95 | `description` varchar(255) default NULL, | ||
96 | `creationDate` bigint(20) default NULL, | ||
97 | `creatorID` varchar(255) default NULL, | ||
98 | `ownerID` varchar(255) default NULL, | ||
99 | `lastOwnerID` varchar(255) default NULL, | ||
100 | `groupID` varchar(255) default NULL, | ||
101 | `nextPermissions` int(11) default NULL, | ||
102 | `currentPermissions` int(11) default NULL, | ||
103 | `basePermissions` int(11) default NULL, | ||
104 | `everyonePermissions` int(11) default NULL, | ||
105 | `groupPermissions` int(11) default NULL, | ||
106 | PRIMARY KEY (`itemID`) | ||
107 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
108 | |||
109 | CREATE TABLE `terrain` ( | ||
110 | `RegionUUID` varchar(255) default NULL, | ||
111 | `Revision` int(11) default NULL, | ||
112 | `Heightfield` longblob | ||
113 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
114 | |||
115 | CREATE TABLE `land` ( | ||
116 | `UUID` varchar(255) NOT NULL, | ||
117 | `RegionUUID` varchar(255) default NULL, | ||
118 | `LocalLandID` int(11) default NULL, | ||
119 | `Bitmap` longblob, | ||
120 | `Name` varchar(255) default NULL, | ||
121 | `Description` varchar(255) default NULL, | ||
122 | `OwnerUUID` varchar(255) default NULL, | ||
123 | `IsGroupOwned` int(11) default NULL, | ||
124 | `Area` int(11) default NULL, | ||
125 | `AuctionID` int(11) default NULL, | ||
126 | `Category` int(11) default NULL, | ||
127 | `ClaimDate` int(11) default NULL, | ||
128 | `ClaimPrice` int(11) default NULL, | ||
129 | `GroupUUID` varchar(255) default NULL, | ||
130 | `SalePrice` int(11) default NULL, | ||
131 | `LandStatus` int(11) default NULL, | ||
132 | `LandFlags` int(11) default NULL, | ||
133 | `LandingType` int(11) default NULL, | ||
134 | `MediaAutoScale` int(11) default NULL, | ||
135 | `MediaTextureUUID` varchar(255) default NULL, | ||
136 | `MediaURL` varchar(255) default NULL, | ||
137 | `MusicURL` varchar(255) default NULL, | ||
138 | `PassHours` float default NULL, | ||
139 | `PassPrice` int(11) default NULL, | ||
140 | `SnapshotUUID` varchar(255) default NULL, | ||
141 | `UserLocationX` float default NULL, | ||
142 | `UserLocationY` float default NULL, | ||
143 | `UserLocationZ` float default NULL, | ||
144 | `UserLookAtX` float default NULL, | ||
145 | `UserLookAtY` float default NULL, | ||
146 | `UserLookAtZ` float default NULL, | ||
147 | `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
148 | PRIMARY KEY (`UUID`) | ||
149 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
150 | |||
151 | CREATE TABLE `landaccesslist` ( | ||
152 | `LandUUID` varchar(255) default NULL, | ||
153 | `AccessUUID` varchar(255) default NULL, | ||
154 | `Flags` int(11) default NULL | ||
155 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
156 | |||
157 | COMMIT; | ||
158 | |||
159 | :VERSION 2 #--------------------- | ||
160 | |||
161 | BEGIN; | ||
162 | |||
163 | CREATE index prims_regionuuid on prims(RegionUUID); | ||
164 | CREATE index primitems_primid on primitems(primID); | ||
165 | |||
166 | COMMIT; | ||
167 | |||
168 | :VERSION 3 #--------------------- | ||
169 | |||
170 | BEGIN; | ||
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=INNODB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
172 | COMMIT; | ||
173 | |||
174 | :VERSION 4 #--------------------- | ||
175 | |||
176 | BEGIN; | ||
177 | |||
178 | ALTER TABLE primitems add flags integer not null default 0; | ||
179 | |||
180 | COMMIT; | ||
181 | |||
182 | :VERSION 5 #--------------------- | ||
183 | BEGIN; | ||
184 | |||
185 | create 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 | |||
222 | COMMIT; | ||
223 | |||
224 | |||
225 | :VERSION 6 #--------------------- | ||
226 | |||
227 | BEGIN; | ||
228 | |||
229 | alter table landaccesslist ENGINE = InnoDB; | ||
230 | alter table migrations ENGINE = InnoDB; | ||
231 | alter table primitems ENGINE = InnoDB; | ||
232 | alter table prims ENGINE = InnoDB; | ||
233 | alter table primshapes ENGINE = InnoDB; | ||
234 | alter table regionsettings ENGINE = InnoDB; | ||
235 | alter table terrain ENGINE = InnoDB; | ||
236 | |||
237 | COMMIT; | ||
238 | |||
239 | :VERSION 7 #--------------------- | ||
240 | |||
241 | BEGIN; | ||
242 | |||
243 | ALTER TABLE prims change UUID UUIDold varchar(255); | ||
244 | ALTER TABLE prims change RegionUUID RegionUUIDold varchar(255); | ||
245 | ALTER TABLE prims change CreatorID CreatorIDold varchar(255); | ||
246 | ALTER TABLE prims change OwnerID OwnerIDold varchar(255); | ||
247 | ALTER TABLE prims change GroupID GroupIDold varchar(255); | ||
248 | ALTER TABLE prims change LastOwnerID LastOwnerIDold varchar(255); | ||
249 | ALTER TABLE prims add UUID char(36); | ||
250 | ALTER TABLE prims add RegionUUID char(36); | ||
251 | ALTER TABLE prims add CreatorID char(36); | ||
252 | ALTER TABLE prims add OwnerID char(36); | ||
253 | ALTER TABLE prims add GroupID char(36); | ||
254 | ALTER TABLE prims add LastOwnerID char(36); | ||
255 | UPDATE prims set UUID = UUIDold, RegionUUID = RegionUUIDold, CreatorID = CreatorIDold, OwnerID = OwnerIDold, GroupID = GroupIDold, LastOwnerID = LastOwnerIDold; | ||
256 | ALTER TABLE prims drop UUIDold; | ||
257 | ALTER TABLE prims drop RegionUUIDold; | ||
258 | ALTER TABLE prims drop CreatorIDold; | ||
259 | ALTER TABLE prims drop OwnerIDold; | ||
260 | ALTER TABLE prims drop GroupIDold; | ||
261 | ALTER TABLE prims drop LastOwnerIDold; | ||
262 | ALTER TABLE prims add constraint primary key(UUID); | ||
263 | ALTER TABLE prims add index prims_regionuuid(RegionUUID); | ||
264 | |||
265 | COMMIT; | ||
266 | |||
267 | :VERSION 8 #--------------------- | ||
268 | |||
269 | BEGIN; | ||
270 | |||
271 | ALTER TABLE primshapes change UUID UUIDold varchar(255); | ||
272 | ALTER TABLE primshapes add UUID char(36); | ||
273 | UPDATE primshapes set UUID = UUIDold; | ||
274 | ALTER TABLE primshapes drop UUIDold; | ||
275 | ALTER TABLE primshapes add constraint primary key(UUID); | ||
276 | |||
277 | COMMIT; | ||
278 | |||
279 | :VERSION 9 #--------------------- | ||
280 | |||
281 | BEGIN; | ||
282 | |||
283 | ALTER TABLE primitems change itemID itemIDold varchar(255); | ||
284 | ALTER TABLE primitems change primID primIDold varchar(255); | ||
285 | ALTER TABLE primitems change assetID assetIDold varchar(255); | ||
286 | ALTER TABLE primitems change parentFolderID parentFolderIDold varchar(255); | ||
287 | ALTER TABLE primitems change creatorID creatorIDold varchar(255); | ||
288 | ALTER TABLE primitems change ownerID ownerIDold varchar(255); | ||
289 | ALTER TABLE primitems change groupID groupIDold varchar(255); | ||
290 | ALTER TABLE primitems change lastOwnerID lastOwnerIDold varchar(255); | ||
291 | ALTER TABLE primitems add itemID char(36); | ||
292 | ALTER TABLE primitems add primID char(36); | ||
293 | ALTER TABLE primitems add assetID char(36); | ||
294 | ALTER TABLE primitems add parentFolderID char(36); | ||
295 | ALTER TABLE primitems add creatorID char(36); | ||
296 | ALTER TABLE primitems add ownerID char(36); | ||
297 | ALTER TABLE primitems add groupID char(36); | ||
298 | ALTER TABLE primitems add lastOwnerID char(36); | ||
299 | UPDATE primitems set itemID = itemIDold, primID = primIDold, assetID = assetIDold, parentFolderID = parentFolderIDold, creatorID = creatorIDold, ownerID = ownerIDold, groupID = groupIDold, lastOwnerID = lastOwnerIDold; | ||
300 | ALTER TABLE primitems drop itemIDold; | ||
301 | ALTER TABLE primitems drop primIDold; | ||
302 | ALTER TABLE primitems drop assetIDold; | ||
303 | ALTER TABLE primitems drop parentFolderIDold; | ||
304 | ALTER TABLE primitems drop creatorIDold; | ||
305 | ALTER TABLE primitems drop ownerIDold; | ||
306 | ALTER TABLE primitems drop groupIDold; | ||
307 | ALTER TABLE primitems drop lastOwnerIDold; | ||
308 | ALTER TABLE primitems add constraint primary key(itemID); | ||
309 | ALTER TABLE primitems add index primitems_primid(primID); | ||
310 | |||
311 | COMMIT; | ||
312 | |||
313 | :VERSION 10 #--------------------- | ||
314 | |||
315 | # 1 "010_RegionStore.sql" | ||
316 | # 1 "<built-in>" | ||
317 | # 1 "<command line>" | ||
318 | # 1 "010_RegionStore.sql" | ||
319 | BEGIN; | ||
320 | |||
321 | DELETE FROM regionsettings; | ||
322 | |||
323 | COMMIT; | ||
324 | |||
325 | |||
326 | :VERSION 11 #--------------------- | ||
327 | |||
328 | BEGIN; | ||
329 | |||
330 | ALTER TABLE prims change SceneGroupID SceneGroupIDold varchar(255); | ||
331 | ALTER TABLE prims add SceneGroupID char(36); | ||
332 | UPDATE prims set SceneGroupID = SceneGroupIDold; | ||
333 | ALTER TABLE prims drop SceneGroupIDold; | ||
334 | ALTER TABLE prims add index prims_scenegroupid(SceneGroupID); | ||
335 | |||
336 | COMMIT; | ||
337 | |||
338 | :VERSION 12 #--------------------- | ||
339 | |||
340 | BEGIN; | ||
341 | |||
342 | ALTER TABLE prims add index prims_parentid(ParentID); | ||
343 | |||
344 | COMMIT; | ||
345 | |||
346 | :VERSION 13 #--------------------- | ||
347 | begin; | ||
348 | |||
349 | drop table regionsettings; | ||
350 | |||
351 | CREATE TABLE `regionsettings` ( | ||
352 | `regionUUID` char(36) NOT NULL, | ||
353 | `block_terraform` int(11) NOT NULL, | ||
354 | `block_fly` int(11) NOT NULL, | ||
355 | `allow_damage` int(11) NOT NULL, | ||
356 | `restrict_pushing` int(11) NOT NULL, | ||
357 | `allow_land_resell` int(11) NOT NULL, | ||
358 | `allow_land_join_divide` int(11) NOT NULL, | ||
359 | `block_show_in_search` int(11) NOT NULL, | ||
360 | `agent_limit` int(11) NOT NULL, | ||
361 | `object_bonus` float NOT NULL, | ||
362 | `maturity` int(11) NOT NULL, | ||
363 | `disable_scripts` int(11) NOT NULL, | ||
364 | `disable_collisions` int(11) NOT NULL, | ||
365 | `disable_physics` int(11) NOT NULL, | ||
366 | `terrain_texture_1` char(36) NOT NULL, | ||
367 | `terrain_texture_2` char(36) NOT NULL, | ||
368 | `terrain_texture_3` char(36) NOT NULL, | ||
369 | `terrain_texture_4` char(36) NOT NULL, | ||
370 | `elevation_1_nw` float NOT NULL, | ||
371 | `elevation_2_nw` float NOT NULL, | ||
372 | `elevation_1_ne` float NOT NULL, | ||
373 | `elevation_2_ne` float NOT NULL, | ||
374 | `elevation_1_se` float NOT NULL, | ||
375 | `elevation_2_se` float NOT NULL, | ||
376 | `elevation_1_sw` float NOT NULL, | ||
377 | `elevation_2_sw` float NOT NULL, | ||
378 | `water_height` float NOT NULL, | ||
379 | `terrain_raise_limit` float NOT NULL, | ||
380 | `terrain_lower_limit` float NOT NULL, | ||
381 | `use_estate_sun` int(11) NOT NULL, | ||
382 | `fixed_sun` int(11) NOT NULL, | ||
383 | `sun_position` float NOT NULL, | ||
384 | `covenant` char(36) default NULL, | ||
385 | `Sandbox` tinyint(4) NOT NULL, | ||
386 | PRIMARY KEY (`regionUUID`) | ||
387 | ) ENGINE=InnoDB; | ||
388 | |||
389 | CREATE TABLE `estate_managers` ( | ||
390 | `EstateID` int(10) unsigned NOT NULL, | ||
391 | `uuid` char(36) NOT NULL, | ||
392 | KEY `EstateID` (`EstateID`) | ||
393 | ) ENGINE=InnoDB; | ||
394 | |||
395 | CREATE TABLE `estate_groups` ( | ||
396 | `EstateID` int(10) unsigned NOT NULL, | ||
397 | `uuid` char(36) NOT NULL, | ||
398 | KEY `EstateID` (`EstateID`) | ||
399 | ) ENGINE=InnoDB; | ||
400 | |||
401 | CREATE TABLE `estate_users` ( | ||
402 | `EstateID` int(10) unsigned NOT NULL, | ||
403 | `uuid` char(36) NOT NULL, | ||
404 | KEY `EstateID` (`EstateID`) | ||
405 | ) ENGINE=InnoDB; | ||
406 | |||
407 | CREATE TABLE `estateban` ( | ||
408 | `EstateID` int(10) unsigned NOT NULL, | ||
409 | `bannedUUID` varchar(36) NOT NULL, | ||
410 | `bannedIp` varchar(16) NOT NULL, | ||
411 | `bannedIpHostMask` varchar(16) NOT NULL, | ||
412 | `bannedNameMask` varchar(64) default NULL, | ||
413 | KEY `estateban_EstateID` (`EstateID`) | ||
414 | ) ENGINE=InnoDB; | ||
415 | |||
416 | CREATE TABLE `estate_settings` ( | ||
417 | `EstateID` int(10) unsigned NOT NULL auto_increment, | ||
418 | `EstateName` varchar(64) default NULL, | ||
419 | `AbuseEmailToEstateOwner` tinyint(4) NOT NULL, | ||
420 | `DenyAnonymous` tinyint(4) NOT NULL, | ||
421 | `ResetHomeOnTeleport` tinyint(4) NOT NULL, | ||
422 | `FixedSun` tinyint(4) NOT NULL, | ||
423 | `DenyTransacted` tinyint(4) NOT NULL, | ||
424 | `BlockDwell` tinyint(4) NOT NULL, | ||
425 | `DenyIdentified` tinyint(4) NOT NULL, | ||
426 | `AllowVoice` tinyint(4) NOT NULL, | ||
427 | `UseGlobalTime` tinyint(4) NOT NULL, | ||
428 | `PricePerMeter` int(11) NOT NULL, | ||
429 | `TaxFree` tinyint(4) NOT NULL, | ||
430 | `AllowDirectTeleport` tinyint(4) NOT NULL, | ||
431 | `RedirectGridX` int(11) NOT NULL, | ||
432 | `RedirectGridY` int(11) NOT NULL, | ||
433 | `ParentEstateID` int(10) unsigned NOT NULL, | ||
434 | `SunPosition` double NOT NULL, | ||
435 | `EstateSkipScripts` tinyint(4) NOT NULL, | ||
436 | `BillableFactor` float NOT NULL, | ||
437 | `PublicAccess` tinyint(4) NOT NULL, | ||
438 | PRIMARY KEY (`EstateID`) | ||
439 | ) ENGINE=InnoDB AUTO_INCREMENT=100; | ||
440 | |||
441 | CREATE TABLE `estate_map` ( | ||
442 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
443 | `EstateID` int(11) NOT NULL, | ||
444 | PRIMARY KEY (`RegionID`), | ||
445 | KEY `EstateID` (`EstateID`) | ||
446 | ) ENGINE=InnoDB; | ||
447 | |||
448 | commit; | ||
449 | |||
450 | :VERSION 14 #--------------------- | ||
451 | |||
452 | begin; | ||
453 | |||
454 | alter table estate_settings add column AbuseEmail varchar(255) not null; | ||
455 | |||
456 | alter table estate_settings add column EstateOwner varchar(36) not null; | ||
457 | |||
458 | commit; | ||
459 | |||
460 | |||
461 | :VERSION 15 #--------------------- | ||
462 | |||
463 | begin; | ||
464 | |||
465 | alter table estate_settings add column DenyMinors tinyint not null; | ||
466 | |||
467 | commit; | ||
468 | |||
469 | :VERSION 16 #--------------------- | ||
470 | |||
471 | BEGIN; | ||
472 | |||
473 | ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0; | ||
474 | ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0; | ||
475 | ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0; | ||
476 | ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0; | ||
477 | ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0; | ||
478 | ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
479 | ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0; | ||
480 | ALTER TABLE prims ADD COLUMN TextureAnimation blob; | ||
481 | ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0; | ||
482 | ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0; | ||
483 | ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0; | ||
484 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0; | ||
485 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0; | ||
486 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0; | ||
487 | ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0; | ||
488 | ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0; | ||
489 | ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0; | ||
490 | ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0; | ||
491 | ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0; | ||
492 | ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0; | ||
493 | ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0; | ||
494 | ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10; | ||
495 | ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0; | ||
496 | |||
497 | COMMIT; | ||
498 | |||
499 | |||
500 | :VERSION 17 #--------------------- | ||
501 | |||
502 | BEGIN; | ||
503 | |||
504 | ALTER TABLE prims ADD COLUMN ColorR integer not null default 0; | ||
505 | ALTER TABLE prims ADD COLUMN ColorG integer not null default 0; | ||
506 | ALTER TABLE prims ADD COLUMN ColorB integer not null default 0; | ||
507 | ALTER TABLE prims ADD COLUMN ColorA integer not null default 0; | ||
508 | ALTER TABLE prims ADD COLUMN ParticleSystem blob; | ||
509 | |||
510 | COMMIT; | ||
511 | |||
512 | |||
513 | :VERSION 18 #--------------------- | ||
514 | |||
515 | begin; | ||
516 | |||
517 | ALTER TABLE prims ADD COLUMN ClickAction tinyint NOT NULL default 0; | ||
518 | |||
519 | commit; | ||
520 | |||
521 | :VERSION 19 #--------------------- | ||
522 | |||
523 | begin; | ||
524 | |||
525 | ALTER TABLE prims ADD COLUMN Material tinyint NOT NULL default 3; | ||
526 | |||
527 | commit; | ||
528 | |||
529 | |||
530 | :VERSION 20 #--------------------- | ||
531 | |||
532 | begin; | ||
533 | |||
534 | ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0; | ||
535 | ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0; | ||
536 | |||
537 | commit; | ||
538 | |||
539 | :VERSION 21 #--------------------- | ||
540 | |||
541 | begin; | ||
542 | |||
543 | ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0; | ||
544 | ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0; | ||
545 | ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0; | ||
546 | |||
547 | commit; | ||
548 | |||
549 | |||
550 | :VERSION 22 #--------------------- | ||
551 | |||
552 | BEGIN; | ||
553 | |||
554 | ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
555 | ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0; | ||
556 | |||
557 | COMMIT; | ||
558 | |||
559 | :VERSION 23 #--------------------- | ||
560 | |||
561 | BEGIN; | ||
562 | |||
563 | ALTER TABLE prims ADD COLUMN LinkNumber integer not null default 0; | ||
564 | |||
565 | COMMIT; | ||
566 | |||
567 | :VERSION 24 #--------------------- | ||
568 | |||
569 | BEGIN; | ||
570 | |||
571 | alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL; | ||
572 | alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL; | ||
573 | alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL; | ||
574 | alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL; | ||
575 | alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL; | ||
576 | alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL; | ||
577 | alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL; | ||
578 | alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL; | ||
579 | alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL; | ||
580 | alter table regionsettings change column `water_height` `water_height` double NOT NULL; | ||
581 | alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL; | ||
582 | alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL; | ||
583 | alter table regionsettings change column `sun_position` `sun_position` double NOT NULL; | ||
584 | |||
585 | COMMIT; | ||
586 | |||
587 | |||
588 | :VERSION 25 #--------------------- | ||
589 | |||
590 | BEGIN; | ||
591 | |||
592 | alter table prims change column `PositionX` `PositionX` double default NULL; | ||
593 | alter table prims change column `PositionY` `PositionY` double default NULL; | ||
594 | alter table prims change column `PositionZ` `PositionZ` double default NULL; | ||
595 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; | ||
596 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; | ||
597 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; | ||
598 | alter table prims change column `VelocityX` `VelocityX` double default NULL; | ||
599 | alter table prims change column `VelocityY` `VelocityY` double default NULL; | ||
600 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; | ||
601 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; | ||
602 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; | ||
603 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; | ||
604 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; | ||
605 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; | ||
606 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; | ||
607 | alter table prims change column `RotationX` `RotationX` double default NULL; | ||
608 | alter table prims change column `RotationY` `RotationY` double default NULL; | ||
609 | alter table prims change column `RotationZ` `RotationZ` double default NULL; | ||
610 | alter table prims change column `RotationW` `RotationW` double default NULL; | ||
611 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; | ||
612 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; | ||
613 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; | ||
614 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; | ||
615 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; | ||
616 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; | ||
617 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; | ||
618 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; | ||
619 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; | ||
620 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; | ||
621 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; | ||
622 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; | ||
623 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; | ||
624 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; | ||
625 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; | ||
626 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; | ||
627 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; | ||
628 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; | ||
629 | |||
630 | alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0'; | ||
631 | alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0'; | ||
632 | alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0'; | ||
633 | |||
634 | COMMIT; | ||
635 | |||
636 | :VERSION 26 #--------------------- | ||
637 | |||
638 | begin; | ||
639 | |||
640 | alter table prims change column `PositionX` `PositionX` double default NULL; | ||
641 | alter table prims change column `PositionY` `PositionY` double default NULL; | ||
642 | alter table prims change column `PositionZ` `PositionZ` double default NULL; | ||
643 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; | ||
644 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; | ||
645 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; | ||
646 | alter table prims change column `VelocityX` `VelocityX` double default NULL; | ||
647 | alter table prims change column `VelocityY` `VelocityY` double default NULL; | ||
648 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; | ||
649 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; | ||
650 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; | ||
651 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; | ||
652 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; | ||
653 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; | ||
654 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; | ||
655 | alter table prims change column `RotationX` `RotationX` double default NULL; | ||
656 | alter table prims change column `RotationY` `RotationY` double default NULL; | ||
657 | alter table prims change column `RotationZ` `RotationZ` double default NULL; | ||
658 | alter table prims change column `RotationW` `RotationW` double default NULL; | ||
659 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; | ||
660 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; | ||
661 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; | ||
662 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; | ||
663 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; | ||
664 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; | ||
665 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; | ||
666 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; | ||
667 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; | ||
668 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; | ||
669 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; | ||
670 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; | ||
671 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; | ||
672 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; | ||
673 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; | ||
674 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; | ||
675 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; | ||
676 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; | ||
677 | |||
678 | commit; | ||
679 | |||
680 | :VERSION 27 #--------------------- | ||
681 | |||
682 | BEGIN; | ||
683 | |||
684 | ALTER TABLE prims DROP COLUMN ParentID; | ||
685 | |||
686 | COMMIT; | ||
687 | |||
688 | :VERSION 28 #--------------------- | ||
689 | |||
690 | BEGIN; | ||
691 | |||
692 | update terrain | ||
693 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
694 | where RegionUUID not like '%-%'; | ||
695 | |||
696 | |||
697 | update landaccesslist | ||
698 | set LandUUID = concat(substr(LandUUID, 1, 8), "-", substr(LandUUID, 9, 4), "-", substr(LandUUID, 13, 4), "-", substr(LandUUID, 17, 4), "-", substr(LandUUID, 21, 12)) | ||
699 | where LandUUID not like '%-%'; | ||
700 | |||
701 | update landaccesslist | ||
702 | set AccessUUID = concat(substr(AccessUUID, 1, 8), "-", substr(AccessUUID, 9, 4), "-", substr(AccessUUID, 13, 4), "-", substr(AccessUUID, 17, 4), "-", substr(AccessUUID, 21, 12)) | ||
703 | where AccessUUID not like '%-%'; | ||
704 | |||
705 | |||
706 | update prims | ||
707 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
708 | where UUID not like '%-%'; | ||
709 | |||
710 | update prims | ||
711 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
712 | where RegionUUID not like '%-%'; | ||
713 | |||
714 | update prims | ||
715 | set SceneGroupID = concat(substr(SceneGroupID, 1, 8), "-", substr(SceneGroupID, 9, 4), "-", substr(SceneGroupID, 13, 4), "-", substr(SceneGroupID, 17, 4), "-", substr(SceneGroupID, 21, 12)) | ||
716 | where SceneGroupID not like '%-%'; | ||
717 | |||
718 | update prims | ||
719 | set CreatorID = concat(substr(CreatorID, 1, 8), "-", substr(CreatorID, 9, 4), "-", substr(CreatorID, 13, 4), "-", substr(CreatorID, 17, 4), "-", substr(CreatorID, 21, 12)) | ||
720 | where CreatorID not like '%-%'; | ||
721 | |||
722 | update prims | ||
723 | set OwnerID = concat(substr(OwnerID, 1, 8), "-", substr(OwnerID, 9, 4), "-", substr(OwnerID, 13, 4), "-", substr(OwnerID, 17, 4), "-", substr(OwnerID, 21, 12)) | ||
724 | where OwnerID not like '%-%'; | ||
725 | |||
726 | update prims | ||
727 | set GroupID = concat(substr(GroupID, 1, 8), "-", substr(GroupID, 9, 4), "-", substr(GroupID, 13, 4), "-", substr(GroupID, 17, 4), "-", substr(GroupID, 21, 12)) | ||
728 | where GroupID not like '%-%'; | ||
729 | |||
730 | update prims | ||
731 | set LastOwnerID = concat(substr(LastOwnerID, 1, 8), "-", substr(LastOwnerID, 9, 4), "-", substr(LastOwnerID, 13, 4), "-", substr(LastOwnerID, 17, 4), "-", substr(LastOwnerID, 21, 12)) | ||
732 | where LastOwnerID not like '%-%'; | ||
733 | |||
734 | |||
735 | update primshapes | ||
736 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
737 | where UUID not like '%-%'; | ||
738 | |||
739 | |||
740 | update land | ||
741 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
742 | where UUID not like '%-%'; | ||
743 | |||
744 | update land | ||
745 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
746 | where RegionUUID not like '%-%'; | ||
747 | |||
748 | update land | ||
749 | set OwnerUUID = concat(substr(OwnerUUID, 1, 8), "-", substr(OwnerUUID, 9, 4), "-", substr(OwnerUUID, 13, 4), "-", substr(OwnerUUID, 17, 4), "-", substr(OwnerUUID, 21, 12)) | ||
750 | where OwnerUUID not like '%-%'; | ||
751 | |||
752 | update land | ||
753 | set GroupUUID = concat(substr(GroupUUID, 1, 8), "-", substr(GroupUUID, 9, 4), "-", substr(GroupUUID, 13, 4), "-", substr(GroupUUID, 17, 4), "-", substr(GroupUUID, 21, 12)) | ||
754 | where GroupUUID not like '%-%'; | ||
755 | |||
756 | update land | ||
757 | set MediaTextureUUID = concat(substr(MediaTextureUUID, 1, 8), "-", substr(MediaTextureUUID, 9, 4), "-", substr(MediaTextureUUID, 13, 4), "-", substr(MediaTextureUUID, 17, 4), "-", substr(MediaTextureUUID, 21, 12)) | ||
758 | where MediaTextureUUID not like '%-%'; | ||
759 | |||
760 | update land | ||
761 | set SnapshotUUID = concat(substr(SnapshotUUID, 1, 8), "-", substr(SnapshotUUID, 9, 4), "-", substr(SnapshotUUID, 13, 4), "-", substr(SnapshotUUID, 17, 4), "-", substr(SnapshotUUID, 21, 12)) | ||
762 | where SnapshotUUID not like '%-%'; | ||
763 | |||
764 | update land | ||
765 | set AuthbuyerID = concat(substr(AuthbuyerID, 1, 8), "-", substr(AuthbuyerID, 9, 4), "-", substr(AuthbuyerID, 13, 4), "-", substr(AuthbuyerID, 17, 4), "-", substr(AuthbuyerID, 21, 12)) | ||
766 | where AuthbuyerID not like '%-%'; | ||
767 | |||
768 | COMMIT; | ||
769 | |||
770 | :VERSION 29 #--------------------- | ||
771 | |||
772 | BEGIN; | ||
773 | |||
774 | ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0; | ||
775 | |||
776 | COMMIT; | ||
777 | |||
778 | :VERSION 30 #--------------------- | ||
779 | |||
780 | BEGIN; | ||
781 | |||
782 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_date varchar(20) default NULL; | ||
783 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_time varchar(20) default NULL; | ||
784 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_id varchar(64) default NULL; | ||
785 | |||
786 | COMMIT; | ||
787 | |||
788 | :VERSION 31 #--------------------- | ||
789 | |||
790 | BEGIN; | ||
791 | |||
792 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_date; | ||
793 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_time; | ||
794 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0; | ||
795 | |||
796 | COMMIT; | ||
797 | |||
798 | :VERSION 32 #--------------------- | ||
799 | |||
800 | BEGIN; | ||
801 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; | ||
802 | COMMIT; | ||
803 | |||
804 | |||
805 | |||
806 | |||