clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | vero | 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 | commit; |
||
390 | |||
391 | :VERSION 16 #--------------------- |
||
392 | |||
393 | BEGIN; |
||
394 | |||
395 | ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0; |
||
396 | ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0; |
||
397 | ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0; |
||
398 | ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0; |
||
399 | ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0; |
||
400 | ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000'; |
||
401 | ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0; |
||
402 | ALTER TABLE prims ADD COLUMN TextureAnimation blob; |
||
403 | ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0; |
||
404 | ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0; |
||
405 | ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0; |
||
406 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0; |
||
407 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0; |
||
408 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0; |
||
409 | ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0; |
||
410 | ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0; |
||
411 | ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0; |
||
412 | ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0; |
||
413 | ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0; |
||
414 | ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0; |
||
415 | ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0; |
||
416 | ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10; |
||
417 | ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0; |
||
418 | |||
419 | COMMIT; |
||
420 | |||
421 | |||
422 | :VERSION 17 #--------------------- |
||
423 | |||
424 | BEGIN; |
||
425 | |||
426 | ALTER TABLE prims ADD COLUMN ColorR integer not null default 0; |
||
427 | ALTER TABLE prims ADD COLUMN ColorG integer not null default 0; |
||
428 | ALTER TABLE prims ADD COLUMN ColorB integer not null default 0; |
||
429 | ALTER TABLE prims ADD COLUMN ColorA integer not null default 0; |
||
430 | ALTER TABLE prims ADD COLUMN ParticleSystem blob; |
||
431 | |||
432 | COMMIT; |
||
433 | |||
434 | |||
435 | :VERSION 18 #--------------------- |
||
436 | |||
437 | begin; |
||
438 | |||
439 | ALTER TABLE prims ADD COLUMN ClickAction tinyint NOT NULL default 0; |
||
440 | |||
441 | commit; |
||
442 | |||
443 | :VERSION 19 #--------------------- |
||
444 | |||
445 | begin; |
||
446 | |||
447 | ALTER TABLE prims ADD COLUMN Material tinyint NOT NULL default 3; |
||
448 | |||
449 | commit; |
||
450 | |||
451 | |||
452 | :VERSION 20 #--------------------- |
||
453 | |||
454 | begin; |
||
455 | |||
456 | ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0; |
||
457 | ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0; |
||
458 | |||
459 | commit; |
||
460 | |||
461 | :VERSION 21 #--------------------- |
||
462 | |||
463 | begin; |
||
464 | |||
465 | ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0; |
||
466 | ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0; |
||
467 | ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0; |
||
468 | |||
469 | commit; |
||
470 | |||
471 | |||
472 | :VERSION 22 #--------------------- |
||
473 | |||
474 | BEGIN; |
||
475 | |||
476 | ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'; |
||
477 | ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0; |
||
478 | |||
479 | COMMIT; |
||
480 | |||
481 | :VERSION 23 #--------------------- |
||
482 | |||
483 | BEGIN; |
||
484 | |||
485 | ALTER TABLE prims ADD COLUMN LinkNumber integer not null default 0; |
||
486 | |||
487 | COMMIT; |
||
488 | |||
489 | :VERSION 24 #--------------------- |
||
490 | |||
491 | BEGIN; |
||
492 | |||
493 | alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL; |
||
494 | alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL; |
||
495 | alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL; |
||
496 | alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL; |
||
497 | alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL; |
||
498 | alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL; |
||
499 | alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL; |
||
500 | alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL; |
||
501 | alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL; |
||
502 | alter table regionsettings change column `water_height` `water_height` double NOT NULL; |
||
503 | alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL; |
||
504 | alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL; |
||
505 | alter table regionsettings change column `sun_position` `sun_position` double NOT NULL; |
||
506 | |||
507 | COMMIT; |
||
508 | |||
509 | |||
510 | :VERSION 25 #--------------------- |
||
511 | |||
512 | BEGIN; |
||
513 | |||
514 | alter table prims change column `PositionX` `PositionX` double default NULL; |
||
515 | alter table prims change column `PositionY` `PositionY` double default NULL; |
||
516 | alter table prims change column `PositionZ` `PositionZ` double default NULL; |
||
517 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; |
||
518 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; |
||
519 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; |
||
520 | alter table prims change column `VelocityX` `VelocityX` double default NULL; |
||
521 | alter table prims change column `VelocityY` `VelocityY` double default NULL; |
||
522 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; |
||
523 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; |
||
524 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; |
||
525 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; |
||
526 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; |
||
527 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; |
||
528 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; |
||
529 | alter table prims change column `RotationX` `RotationX` double default NULL; |
||
530 | alter table prims change column `RotationY` `RotationY` double default NULL; |
||
531 | alter table prims change column `RotationZ` `RotationZ` double default NULL; |
||
532 | alter table prims change column `RotationW` `RotationW` double default NULL; |
||
533 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; |
||
534 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; |
||
535 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; |
||
536 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; |
||
537 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; |
||
538 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; |
||
539 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; |
||
540 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; |
||
541 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; |
||
542 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; |
||
543 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; |
||
544 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; |
||
545 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; |
||
546 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; |
||
547 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; |
||
548 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; |
||
549 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; |
||
550 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; |
||
551 | |||
552 | alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0'; |
||
553 | alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0'; |
||
554 | alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0'; |
||
555 | |||
556 | COMMIT; |
||
557 | |||
558 | :VERSION 26 #--------------------- |
||
559 | |||
560 | begin; |
||
561 | |||
562 | alter table prims change column `PositionX` `PositionX` double default NULL; |
||
563 | alter table prims change column `PositionY` `PositionY` double default NULL; |
||
564 | alter table prims change column `PositionZ` `PositionZ` double default NULL; |
||
565 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; |
||
566 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; |
||
567 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; |
||
568 | alter table prims change column `VelocityX` `VelocityX` double default NULL; |
||
569 | alter table prims change column `VelocityY` `VelocityY` double default NULL; |
||
570 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; |
||
571 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; |
||
572 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; |
||
573 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; |
||
574 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; |
||
575 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; |
||
576 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; |
||
577 | alter table prims change column `RotationX` `RotationX` double default NULL; |
||
578 | alter table prims change column `RotationY` `RotationY` double default NULL; |
||
579 | alter table prims change column `RotationZ` `RotationZ` double default NULL; |
||
580 | alter table prims change column `RotationW` `RotationW` double default NULL; |
||
581 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; |
||
582 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; |
||
583 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; |
||
584 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; |
||
585 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; |
||
586 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; |
||
587 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; |
||
588 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; |
||
589 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; |
||
590 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; |
||
591 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; |
||
592 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; |
||
593 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; |
||
594 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; |
||
595 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; |
||
596 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; |
||
597 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; |
||
598 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; |
||
599 | |||
600 | commit; |
||
601 | |||
602 | :VERSION 27 #--------------------- |
||
603 | |||
604 | BEGIN; |
||
605 | |||
606 | ALTER TABLE prims DROP COLUMN ParentID; |
||
607 | |||
608 | COMMIT; |
||
609 | |||
610 | :VERSION 28 #--------------------- |
||
611 | |||
612 | BEGIN; |
||
613 | |||
614 | update 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 | |||
619 | update 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 | |||
623 | update 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 | |||
628 | update 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 | |||
632 | update 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 | |||
636 | update 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 | |||
640 | update 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 | |||
644 | update 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 | |||
648 | update 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 | |||
652 | update 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 | |||
657 | update 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 | |||
662 | update 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 | |||
666 | update 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 | |||
670 | update 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 | |||
674 | update 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 | |||
678 | update 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 | |||
682 | update 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 | |||
686 | update 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 | |||
690 | COMMIT; |
||
691 | |||
692 | :VERSION 29 #--------------------- |
||
693 | |||
694 | BEGIN; |
||
695 | |||
696 | ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0; |
||
697 | |||
698 | COMMIT; |
||
699 | |||
700 | :VERSION 30 #--------------------- |
||
701 | |||
702 | BEGIN; |
||
703 | |||
704 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_date varchar(20) default NULL; |
||
705 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_time varchar(20) default NULL; |
||
706 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_id varchar(64) default NULL; |
||
707 | |||
708 | COMMIT; |
||
709 | |||
710 | :VERSION 31 #--------------------- |
||
711 | |||
712 | BEGIN; |
||
713 | |||
714 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_date; |
||
715 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_time; |
||
716 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0; |
||
717 | |||
718 | COMMIT; |
||
719 | |||
720 | :VERSION 32 |
||
721 | |||
722 | BEGIN; |
||
723 | CREATE TABLE `regionwindlight` ( |
||
724 | `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', |
||
726 | `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000', |
||
727 | `water_color_b` float(9,6) unsigned NOT NULL DEFAULT '64.000000', |
||
728 | `water_fog_density_exponent` float(3,1) unsigned NOT NULL DEFAULT '4.0', |
||
729 | `underwater_fog_modifier` float(3,2) unsigned NOT NULL DEFAULT '0.25', |
||
730 | `reflection_wavelet_scale_1` float(3,1) unsigned NOT NULL DEFAULT '2.0', |
||
731 | `reflection_wavelet_scale_2` float(3,1) unsigned NOT NULL DEFAULT '2.0', |
||
732 | `reflection_wavelet_scale_3` float(3,1) unsigned NOT NULL DEFAULT '2.0', |
||
733 | `fresnel_scale` float(3,2) unsigned NOT NULL DEFAULT '0.40', |
||
734 | `fresnel_offset` float(3,2) unsigned NOT NULL DEFAULT '0.50', |
||
735 | `refract_scale_above` float(3,2) unsigned NOT NULL DEFAULT '0.03', |
||
736 | `refract_scale_below` float(3,2) unsigned NOT NULL DEFAULT '0.20', |
||
737 | `blur_multiplier` float(4,3) unsigned NOT NULL DEFAULT '0.040', |
||
738 | `big_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.05', |
||
739 | `big_wave_direction_y` float(3,2) NOT NULL DEFAULT '-0.42', |
||
740 | `little_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.11', |
||
741 | `little_wave_direction_y` float(3,2) NOT NULL DEFAULT '-1.16', |
||
742 | `normal_map_texture` varchar(36) NOT NULL DEFAULT '822ded49-9a6c-f61c-cb89-6df54f42cdf4', |
||
743 | `horizon_r` float(3,2) unsigned NOT NULL DEFAULT '0.25', |
||
744 | `horizon_g` float(3,2) unsigned NOT NULL DEFAULT '0.25', |
||
745 | `horizon_b` float(3,2) unsigned NOT NULL DEFAULT '0.32', |
||
746 | `horizon_i` float(3,2) unsigned NOT NULL DEFAULT '0.32', |
||
747 | `haze_horizon` float(3,2) unsigned NOT NULL DEFAULT '0.19', |
||
748 | `blue_density_r` float(3,2) unsigned NOT NULL DEFAULT '0.12', |
||
749 | `blue_density_g` float(3,2) unsigned NOT NULL DEFAULT '0.22', |
||
750 | `blue_density_b` float(3,2) unsigned NOT NULL DEFAULT '0.38', |
||
751 | `blue_density_i` float(3,2) unsigned NOT NULL DEFAULT '0.38', |
||
752 | `haze_density` float(3,2) unsigned NOT NULL DEFAULT '0.70', |
||
753 | `density_multiplier` float(3,2) unsigned NOT NULL DEFAULT '0.18', |
||
754 | `distance_multiplier` float(4,1) unsigned NOT NULL DEFAULT '0.8', |
||
755 | `max_altitude` int(4) unsigned NOT NULL DEFAULT '1605', |
||
756 | `sun_moon_color_r` float(3,2) unsigned NOT NULL DEFAULT '0.24', |
||
757 | `sun_moon_color_g` float(3,2) unsigned NOT NULL DEFAULT '0.26', |
||
758 | `sun_moon_color_b` float(3,2) unsigned NOT NULL DEFAULT '0.30', |
||
759 | `sun_moon_color_i` float(3,2) unsigned NOT NULL DEFAULT '0.30', |
||
760 | `sun_moon_position` float(4,3) unsigned NOT NULL DEFAULT '0.317', |
||
761 | `ambient_r` float(3,2) unsigned NOT NULL DEFAULT '0.35', |
||
762 | `ambient_g` float(3,2) unsigned NOT NULL DEFAULT '0.35', |
||
763 | `ambient_b` float(3,2) unsigned NOT NULL DEFAULT '0.35', |
||
764 | `ambient_i` float(3,2) unsigned NOT NULL DEFAULT '0.35', |
||
765 | `east_angle` float(3,2) unsigned NOT NULL DEFAULT '0.00', |
||
766 | `sun_glow_focus` float(3,2) unsigned NOT NULL DEFAULT '0.10', |
||
767 | `sun_glow_size` float(3,2) unsigned NOT NULL DEFAULT '1.75', |
||
768 | `scene_gamma` float(4,2) unsigned NOT NULL DEFAULT '1.00', |
||
769 | `star_brightness` float(3,2) unsigned NOT NULL DEFAULT '0.00', |
||
770 | `cloud_color_r` float(3,2) unsigned NOT NULL DEFAULT '0.41', |
||
771 | `cloud_color_g` float(3,2) unsigned NOT NULL DEFAULT '0.41', |
||
772 | `cloud_color_b` float(3,2) unsigned NOT NULL DEFAULT '0.41', |
||
773 | `cloud_color_i` float(3,2) unsigned NOT NULL DEFAULT '0.41', |
||
774 | `cloud_x` float(3,2) unsigned NOT NULL DEFAULT '1.00', |
||
775 | `cloud_y` float(3,2) unsigned NOT NULL DEFAULT '0.53', |
||
776 | `cloud_density` float(3,2) unsigned NOT NULL DEFAULT '1.00', |
||
777 | `cloud_coverage` float(3,2) unsigned NOT NULL DEFAULT '0.27', |
||
778 | `cloud_scale` float(3,2) unsigned NOT NULL DEFAULT '0.42', |
||
779 | `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', |
||
781 | `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', |
||
783 | `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', |
||
784 | `cloud_scroll_y` float(3,2) unsigned NOT NULL DEFAULT '0.01', |
||
785 | `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', |
||
786 | `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1', |
||
787 | PRIMARY KEY (`region_id`) |
||
788 | ); |
||
789 | |||
790 | |||
791 | :VERSION 33 #--------------------- |
||
792 | |||
793 | BEGIN; |
||
794 | ALTER TABLE regionsettings ADD map_tile_ID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; |
||
795 | COMMIT; |
||
796 | |||
797 | :VERSION 34 #--------------------- |
||
798 | |||
799 | BEGIN; |
||
800 | ALTER 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`; |
||
801 | COMMIT; |
||
802 | |||
803 | :VERSION 35 #--------------------- |
||
804 | |||
805 | BEGIN; |
||
806 | ALTER TABLE prims ADD COLUMN MediaURL varchar(255); |
||
807 | ALTER TABLE primshapes ADD COLUMN Media TEXT; |
||
808 | COMMIT; |
||
809 | |||
810 | :VERSION 36 #--------------------- |
||
811 | |||
812 | BEGIN; |
||
813 | ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none' ; |
||
814 | ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT ''; |
||
815 | ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0'; |
||
816 | ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE; |
||
817 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; |
||
818 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; |
||
819 | COMMIT; |
||
820 | |||
821 | :VERSION 37 #--------------------- |
||
822 | |||
823 | BEGIN; |
||
824 | |||
825 | ALTER TABLE `prims` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; |
||
826 | ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; |
||
827 | |||
828 | COMMIT; |
||
829 | |||
830 | :VERSION 38 #--------------------- |
||
831 | |||
832 | BEGIN; |
||
833 | |||
834 | alter table land ENGINE = MyISAM; |
||
835 | alter table landaccesslist ENGINE = MyISAM; |
||
836 | alter table migrations ENGINE = MyISAM; |
||
837 | alter table primitems ENGINE = MyISAM; |
||
838 | alter table prims ENGINE = MyISAM; |
||
839 | alter table primshapes ENGINE = MyISAM; |
||
840 | alter table regionban ENGINE = MyISAM; |
||
841 | alter table regionsettings ENGINE = MyISAM; |
||
842 | alter table terrain ENGINE = MyISAM; |
||
843 | |||
844 | COMMIT; |
||
845 | |||
846 | :VERSION 39 #--------------- Telehub support |
||
847 | |||
848 | BEGIN; |
||
849 | CREATE TABLE IF NOT EXISTS `spawn_points` ( |
||
850 | `RegionID` varchar(36) COLLATE utf8_unicode_ci NOT NULL, |
||
851 | `Yaw` float NOT NULL, |
||
852 | `Pitch` float NOT NULL, |
||
853 | `Distance` float NOT NULL, |
||
854 | KEY `RegionID` (`RegionID`) |
||
855 | ) ENGINE=Innodb; |
||
856 | |||
857 | ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL; |
||
858 | COMMIT; |
||
859 | |||
860 | :VERSION 40 #---------------- Parcels for sale |
||
861 | |||
862 | BEGIN; |
||
863 | ALTER TABLE `regionsettings` ADD COLUMN `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; |
||
864 | COMMIT; |
||
865 | |||
866 | :VERSION 41 #---------------- Timed bans/access |
||
867 | |||
868 | BEGIN; |
||
869 | ALTER TABLE `landaccesslist` ADD COLUMN `Expires` INTEGER NOT NULL DEFAULT 0; |
||
870 | COMMIT; |
||
871 | |||
872 | :VERSION 42 #--------------------- Region Covenant changed time |
||
873 | |||
874 | BEGIN; |
||
875 | ALTER TABLE regionsettings ADD COLUMN covenant_datetime int unsigned NOT NULL DEFAULT '0'; |
||
876 | COMMIT; |
||
877 | |||
878 | :VERSION 43 #--------------------- |
||
879 | |||
880 | BEGIN; |
||
881 | |||
882 | ALTER TABLE `regionsettings` MODIFY COLUMN `TelehubObject` VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; |
||
883 | |||
884 | COMMIT; |
||
885 | |||
886 | :VERSION 44 #--------------------- Environment Settings |
||
887 | |||
888 | BEGIN; |
||
889 | |||
890 | CREATE TABLE `regionenvironment` ( |
||
891 | `region_id` varchar(36) NOT NULL, |
||
892 | `llsd_settings` TEXT NOT NULL, |
||
893 | PRIMARY KEY (`region_id`) |
||
894 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
895 | |||
896 | COMMIT; |
||
897 | |||
898 | :VERSION 45 |
||
899 | |||
900 | BEGIN; |
||
901 | |||
902 | CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32) not null, `value` text, primary key(`RegionID`, `Name`)); |
||
903 | |||
904 | COMMIT; |
||
905 | |||
906 | :VERSION 46 #---------------- Dynamic attributes |
||
907 | |||
908 | BEGIN; |
||
909 | |||
910 | ALTER TABLE prims ADD COLUMN DynAttrs TEXT; |
||
911 | |||
912 | COMMIT; |
||
913 | |||
914 | :VERSION 47 #---------------- Extra physics params |
||
915 | |||
916 | BEGIN; |
||
917 | |||
918 | ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0'; |
||
919 | ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000'; |
||
920 | ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1'; |
||
921 | ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6'; |
||
922 | ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5'; |
||
923 | |||
924 | COMMIT; |
||
925 | |||
926 | :VERSION 48 #---------------- Keyframes |
||
927 | |||
928 | BEGIN; |
||
929 | |||
930 | ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob; |
||
931 | |||
932 | COMMIT; |