opensim – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | eva | 1 | :VERSION 1 |
2 | |||
3 | BEGIN TRANSACTION; |
||
4 | |||
5 | CREATE TABLE prims( |
||
6 | UUID varchar(255) primary key, |
||
7 | RegionUUID varchar(255), |
||
8 | ParentID integer, |
||
9 | CreationDate integer, |
||
10 | Name varchar(255), |
||
11 | SceneGroupID varchar(255), |
||
12 | Text varchar(255), |
||
13 | Description varchar(255), |
||
14 | SitName varchar(255), |
||
15 | TouchName varchar(255), |
||
16 | CreatorID varchar(255), |
||
17 | OwnerID varchar(255), |
||
18 | GroupID varchar(255), |
||
19 | LastOwnerID varchar(255), |
||
20 | OwnerMask integer, |
||
21 | NextOwnerMask integer, |
||
22 | GroupMask integer, |
||
23 | EveryoneMask integer, |
||
24 | BaseMask integer, |
||
25 | PositionX float, |
||
26 | PositionY float, |
||
27 | PositionZ float, |
||
28 | GroupPositionX float, |
||
29 | GroupPositionY float, |
||
30 | GroupPositionZ float, |
||
31 | VelocityX float, |
||
32 | VelocityY float, |
||
33 | VelocityZ float, |
||
34 | AngularVelocityX float, |
||
35 | AngularVelocityY float, |
||
36 | AngularVelocityZ float, |
||
37 | AccelerationX float, |
||
38 | AccelerationY float, |
||
39 | AccelerationZ float, |
||
40 | RotationX float, |
||
41 | RotationY float, |
||
42 | RotationZ float, |
||
43 | RotationW float, |
||
44 | ObjectFlags integer, |
||
45 | SitTargetOffsetX float NOT NULL default 0, |
||
46 | SitTargetOffsetY float NOT NULL default 0, |
||
47 | SitTargetOffsetZ float NOT NULL default 0, |
||
48 | SitTargetOrientW float NOT NULL default 0, |
||
49 | SitTargetOrientX float NOT NULL default 0, |
||
50 | SitTargetOrientY float NOT NULL default 0, |
||
51 | SitTargetOrientZ float NOT NULL default 0); |
||
52 | |||
53 | CREATE TABLE primshapes( |
||
54 | UUID varchar(255) primary key, |
||
55 | Shape integer, |
||
56 | ScaleX float, |
||
57 | ScaleY float, |
||
58 | ScaleZ float, |
||
59 | PCode integer, |
||
60 | PathBegin integer, |
||
61 | PathEnd integer, |
||
62 | PathScaleX integer, |
||
63 | PathScaleY integer, |
||
64 | PathShearX integer, |
||
65 | PathShearY integer, |
||
66 | PathSkew integer, |
||
67 | PathCurve integer, |
||
68 | PathRadiusOffset integer, |
||
69 | PathRevolutions integer, |
||
70 | PathTaperX integer, |
||
71 | PathTaperY integer, |
||
72 | PathTwist integer, |
||
73 | PathTwistBegin integer, |
||
74 | ProfileBegin integer, |
||
75 | ProfileEnd integer, |
||
76 | ProfileCurve integer, |
||
77 | ProfileHollow integer, |
||
78 | Texture blob, |
||
79 | ExtraParams blob, |
||
80 | State Integer NOT NULL default 0); |
||
81 | |||
82 | CREATE TABLE primitems( |
||
83 | itemID varchar(255) primary key, |
||
84 | primID varchar(255), |
||
85 | assetID varchar(255), |
||
86 | parentFolderID varchar(255), |
||
87 | invType integer, |
||
88 | assetType integer, |
||
89 | name varchar(255), |
||
90 | description varchar(255), |
||
91 | creationDate integer, |
||
92 | creatorID varchar(255), |
||
93 | ownerID varchar(255), |
||
94 | lastOwnerID varchar(255), |
||
95 | groupID varchar(255), |
||
96 | nextPermissions string, |
||
97 | currentPermissions string, |
||
98 | basePermissions string, |
||
99 | everyonePermissions string, |
||
100 | groupPermissions string); |
||
101 | |||
102 | CREATE TABLE terrain( |
||
103 | RegionUUID varchar(255), |
||
104 | Revision integer, |
||
105 | Heightfield blob); |
||
106 | |||
107 | CREATE TABLE land( |
||
108 | UUID varchar(255) primary key, |
||
109 | RegionUUID varchar(255), |
||
110 | LocalLandID string, |
||
111 | Bitmap blob, |
||
112 | Name varchar(255), |
||
113 | Desc varchar(255), |
||
114 | OwnerUUID varchar(255), |
||
115 | IsGroupOwned string, |
||
116 | Area integer, |
||
117 | AuctionID integer, |
||
118 | Category integer, |
||
119 | ClaimDate integer, |
||
120 | ClaimPrice integer, |
||
121 | GroupUUID varchar(255), |
||
122 | SalePrice integer, |
||
123 | LandStatus integer, |
||
124 | LandFlags string, |
||
125 | LandingType string, |
||
126 | MediaAutoScale string, |
||
127 | MediaTextureUUID varchar(255), |
||
128 | MediaURL varchar(255), |
||
129 | MusicURL varchar(255), |
||
130 | PassHours float, |
||
131 | PassPrice string, |
||
132 | SnapshotUUID varchar(255), |
||
133 | UserLocationX float, |
||
134 | UserLocationY float, |
||
135 | UserLocationZ float, |
||
136 | UserLookAtX float, |
||
137 | UserLookAtY float, |
||
138 | UserLookAtZ float, |
||
139 | AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'); |
||
140 | |||
141 | CREATE TABLE landaccesslist( |
||
142 | LandUUID varchar(255), |
||
143 | AccessUUID varchar(255), |
||
144 | Flags string); |
||
145 | |||
146 | COMMIT; |
||
147 | |||
148 | :VERSION 2 |
||
149 | |||
150 | BEGIN TRANSACTION; |
||
151 | |||
152 | CREATE TABLE regionban( |
||
153 | regionUUID varchar (255), |
||
154 | bannedUUID varchar (255), |
||
155 | bannedIp varchar (255), |
||
156 | bannedIpHostMask varchar (255) |
||
157 | ); |
||
158 | |||
159 | COMMIT; |
||
160 | |||
161 | :VERSION 3 |
||
162 | |||
163 | BEGIN; |
||
164 | |||
165 | ALTER TABLE primitems add flags integer not null default 0; |
||
166 | |||
167 | COMMIT; |
||
168 | |||
169 | :VERSION 4 |
||
170 | |||
171 | BEGIN; |
||
172 | |||
173 | create table regionsettings ( |
||
174 | regionUUID char(36) not null, |
||
175 | block_terraform integer not null, |
||
176 | block_fly integer not null, |
||
177 | allow_damage integer not null, |
||
178 | restrict_pushing integer not null, |
||
179 | allow_land_resell integer not null, |
||
180 | allow_land_join_divide integer not null, |
||
181 | block_show_in_search integer not null, |
||
182 | agent_limit integer not null, |
||
183 | object_bonus float not null, |
||
184 | maturity integer not null, |
||
185 | disable_scripts integer not null, |
||
186 | disable_collisions integer not null, |
||
187 | disable_physics integer not null, |
||
188 | terrain_texture_1 char(36) not null, |
||
189 | terrain_texture_2 char(36) not null, |
||
190 | terrain_texture_3 char(36) not null, |
||
191 | terrain_texture_4 char(36) not null, |
||
192 | elevation_1_nw float not null, |
||
193 | elevation_2_nw float not null, |
||
194 | elevation_1_ne float not null, |
||
195 | elevation_2_ne float not null, |
||
196 | elevation_1_se float not null, |
||
197 | elevation_2_se float not null, |
||
198 | elevation_1_sw float not null, |
||
199 | elevation_2_sw float not null, |
||
200 | water_height float not null, |
||
201 | terrain_raise_limit float not null, |
||
202 | terrain_lower_limit float not null, |
||
203 | use_estate_sun integer not null, |
||
204 | fixed_sun integer not null, |
||
205 | sun_position float not null, |
||
206 | covenant char(36)); |
||
207 | |||
208 | COMMIT; |
||
209 | |||
210 | :VERSION 5 |
||
211 | |||
212 | BEGIN; |
||
213 | |||
214 | delete from regionsettings; |
||
215 | |||
216 | COMMIT; |
||
217 | |||
218 | :VERSION 6 |
||
219 | |||
220 | BEGIN TRANSACTION; |
||
221 | |||
222 | drop table regionsettings; |
||
223 | CREATE TABLE regionsettings ( |
||
224 | regionUUID char(36) NOT NULL, |
||
225 | block_terraform int(11) NOT NULL, |
||
226 | block_fly int(11) NOT NULL, |
||
227 | allow_damage int(11) NOT NULL, |
||
228 | restrict_pushing int(11) NOT NULL, |
||
229 | allow_land_resell int(11) NOT NULL, |
||
230 | allow_land_join_divide int(11) NOT NULL, |
||
231 | block_show_in_search int(11) NOT NULL, |
||
232 | agent_limit int(11) NOT NULL, |
||
233 | object_bonus float NOT NULL, |
||
234 | maturity int(11) NOT NULL, |
||
235 | disable_scripts int(11) NOT NULL, |
||
236 | disable_collisions int(11) NOT NULL, |
||
237 | disable_physics int(11) NOT NULL, |
||
238 | terrain_texture_1 char(36) NOT NULL, |
||
239 | terrain_texture_2 char(36) NOT NULL, |
||
240 | terrain_texture_3 char(36) NOT NULL, |
||
241 | terrain_texture_4 char(36) NOT NULL, |
||
242 | elevation_1_nw float NOT NULL, |
||
243 | elevation_2_nw float NOT NULL, |
||
244 | elevation_1_ne float NOT NULL, |
||
245 | elevation_2_ne float NOT NULL, |
||
246 | elevation_1_se float NOT NULL, |
||
247 | elevation_2_se float NOT NULL, |
||
248 | elevation_1_sw float NOT NULL, |
||
249 | elevation_2_sw float NOT NULL, |
||
250 | water_height float NOT NULL, |
||
251 | terrain_raise_limit float NOT NULL, |
||
252 | terrain_lower_limit float NOT NULL, |
||
253 | use_estate_sun int(11) NOT NULL, |
||
254 | fixed_sun int(11) NOT NULL, |
||
255 | sun_position float NOT NULL, |
||
256 | covenant char(36) default NULL, |
||
257 | sandbox tinyint(4) NOT NULL, |
||
258 | PRIMARY KEY (regionUUID) |
||
259 | ); |
||
260 | |||
261 | COMMIT; |
||
262 | |||
263 | :VERSION 9 |
||
264 | |||
265 | BEGIN; |
||
266 | |||
267 | ALTER TABLE prims ADD COLUMN ColorR integer not null default 0; |
||
268 | ALTER TABLE prims ADD COLUMN ColorG integer not null default 0; |
||
269 | ALTER TABLE prims ADD COLUMN ColorB integer not null default 0; |
||
270 | ALTER TABLE prims ADD COLUMN ColorA integer not null default 0; |
||
271 | |||
272 | COMMIT; |
||
273 | |||
274 | :VERSION 10 |
||
275 | |||
276 | BEGIN; |
||
277 | |||
278 | ALTER TABLE prims ADD COLUMN ClickAction INTEGER NOT NULL default 0; |
||
279 | |||
280 | COMMIT; |
||
281 | |||
282 | :VERSION 11 |
||
283 | |||
284 | BEGIN; |
||
285 | |||
286 | ALTER TABLE prims ADD COLUMN PayPrice INTEGER NOT NULL default 0; |
||
287 | ALTER TABLE prims ADD COLUMN PayButton1 INTEGER NOT NULL default 0; |
||
288 | ALTER TABLE prims ADD COLUMN PayButton2 INTEGER NOT NULL default 0; |
||
289 | ALTER TABLE prims ADD COLUMN PayButton3 INTEGER NOT NULL default 0; |
||
290 | ALTER TABLE prims ADD COLUMN PayButton4 INTEGER NOT NULL default 0; |
||
291 | ALTER TABLE prims ADD COLUMN LoopedSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; |
||
292 | ALTER TABLE prims ADD COLUMN LoopedSoundGain float NOT NULL default 0; |
||
293 | ALTER TABLE prims ADD COLUMN TextureAnimation string; |
||
294 | ALTER TABLE prims ADD COLUMN ParticleSystem string; |
||
295 | ALTER TABLE prims ADD COLUMN OmegaX float NOT NULL default 0; |
||
296 | ALTER TABLE prims ADD COLUMN OmegaY float NOT NULL default 0; |
||
297 | ALTER TABLE prims ADD COLUMN OmegaZ float NOT NULL default 0; |
||
298 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float NOT NULL default 0; |
||
299 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float NOT NULL default 0; |
||
300 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float NOT NULL default 0; |
||
301 | ALTER TABLE prims ADD COLUMN CameraAtOffsetX float NOT NULL default 0; |
||
302 | ALTER TABLE prims ADD COLUMN CameraAtOffsetY float NOT NULL default 0; |
||
303 | ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float NOT NULL default 0; |
||
304 | ALTER TABLE prims ADD COLUMN ForceMouselook string NOT NULL default 0; |
||
305 | ALTER TABLE prims ADD COLUMN ScriptAccessPin INTEGER NOT NULL default 0; |
||
306 | ALTER TABLE prims ADD COLUMN AllowedDrop INTEGER NOT NULL default 0; |
||
307 | ALTER TABLE prims ADD COLUMN DieAtEdge string NOT NULL default 0; |
||
308 | ALTER TABLE prims ADD COLUMN SalePrice INTEGER NOT NULL default 0; |
||
309 | ALTER TABLE prims ADD COLUMN SaleType string NOT NULL default 0; |
||
310 | |||
311 | COMMIT; |
||
312 | |||
313 | :VERSION 12 |
||
314 | |||
315 | BEGIN; |
||
316 | |||
317 | ALTER TABLE prims ADD COLUMN Material INTEGER NOT NULL default 3; |
||
318 | |||
319 | COMMIT; |
||
320 | |||
321 | :VERSION 13 |
||
322 | |||
323 | BEGIN; |
||
324 | |||
325 | ALTER TABLE land ADD COLUMN OtherCleanTime INTEGER NOT NULL default 0; |
||
326 | ALTER TABLE land ADD COLUMN Dwell INTEGER NOT NULL default 0; |
||
327 | |||
328 | COMMIT; |
||
329 | |||
330 | :VERSION 14 |
||
331 | |||
332 | begin; |
||
333 | |||
334 | ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0; |
||
335 | ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0; |
||
336 | ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0; |
||
337 | |||
338 | commit; |
||
339 | |||
340 | :VERSION 15 |
||
341 | |||
342 | BEGIN; |
||
343 | |||
344 | ALTER TABLE prims ADD COLUMN CollisionSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; |
||
345 | ALTER TABLE prims ADD COLUMN CollisionSoundVolume float NOT NULL default 0; |
||
346 | |||
347 | COMMIT; |
||
348 | |||
349 | :VERSION 16 |
||
350 | |||
351 | BEGIN; |
||
352 | |||
353 | ALTER TABLE prims ADD COLUMN VolumeDetect INTEGER NOT NULL DEFAULT 0; |
||
354 | |||
355 | COMMIT; |
||
356 | |||
357 | :VERSION 17 |
||
358 | |||
359 | BEGIN; |
||
360 | CREATE TEMPORARY TABLE prims_backup(UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect); |
||
361 | INSERT INTO prims_backup SELECT UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect FROM prims; |
||
362 | DROP TABLE prims; |
||
363 | CREATE TABLE prims(UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect); |
||
364 | INSERT INTO prims SELECT UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect FROM prims_backup; |
||
365 | DROP TABLE prims_backup; |
||
366 | COMMIT; |
||
367 | |||
368 | :VERSION 18 |
||
369 | |||
370 | BEGIN; |
||
371 | |||
372 | update terrain |
||
373 | set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12) |
||
374 | where RegionUUID not like '%-%'; |
||
375 | |||
376 | |||
377 | update landaccesslist |
||
378 | set LandUUID = substr(LandUUID, 1, 8) || "-" || substr(LandUUID, 9, 4) || "-" || substr(LandUUID, 13, 4) || "-" || substr(LandUUID, 17, 4) || "-" || substr(LandUUID, 21, 12) |
||
379 | where LandUUID not like '%-%'; |
||
380 | |||
381 | update landaccesslist |
||
382 | set AccessUUID = substr(AccessUUID, 1, 8) || "-" || substr(AccessUUID, 9, 4) || "-" || substr(AccessUUID, 13, 4) || "-" || substr(AccessUUID, 17, 4) || "-" || substr(AccessUUID, 21, 12) |
||
383 | where AccessUUID not like '%-%'; |
||
384 | |||
385 | |||
386 | update prims |
||
387 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) |
||
388 | where UUID not like '%-%'; |
||
389 | |||
390 | update prims |
||
391 | set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12) |
||
392 | where RegionUUID not like '%-%'; |
||
393 | |||
394 | update prims |
||
395 | set SceneGroupID = substr(SceneGroupID, 1, 8) || "-" || substr(SceneGroupID, 9, 4) || "-" || substr(SceneGroupID, 13, 4) || "-" || substr(SceneGroupID, 17, 4) || "-" || substr(SceneGroupID, 21, 12) |
||
396 | where SceneGroupID not like '%-%'; |
||
397 | |||
398 | update prims |
||
399 | set CreatorID = substr(CreatorID, 1, 8) || "-" || substr(CreatorID, 9, 4) || "-" || substr(CreatorID, 13, 4) || "-" || substr(CreatorID, 17, 4) || "-" || substr(CreatorID, 21, 12) |
||
400 | where CreatorID not like '%-%'; |
||
401 | |||
402 | update prims |
||
403 | set OwnerID = substr(OwnerID, 1, 8) || "-" || substr(OwnerID, 9, 4) || "-" || substr(OwnerID, 13, 4) || "-" || substr(OwnerID, 17, 4) || "-" || substr(OwnerID, 21, 12) |
||
404 | where OwnerID not like '%-%'; |
||
405 | |||
406 | update prims |
||
407 | set GroupID = substr(GroupID, 1, 8) || "-" || substr(GroupID, 9, 4) || "-" || substr(GroupID, 13, 4) || "-" || substr(GroupID, 17, 4) || "-" || substr(GroupID, 21, 12) |
||
408 | where GroupID not like '%-%'; |
||
409 | |||
410 | update prims |
||
411 | set LastOwnerID = substr(LastOwnerID, 1, 8) || "-" || substr(LastOwnerID, 9, 4) || "-" || substr(LastOwnerID, 13, 4) || "-" || substr(LastOwnerID, 17, 4) || "-" || substr(LastOwnerID, 21, 12) |
||
412 | where LastOwnerID not like '%-%'; |
||
413 | |||
414 | |||
415 | update primshapes |
||
416 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) |
||
417 | where UUID not like '%-%'; |
||
418 | |||
419 | |||
420 | update land |
||
421 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) |
||
422 | where UUID not like '%-%'; |
||
423 | |||
424 | update land |
||
425 | set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12) |
||
426 | where RegionUUID not like '%-%'; |
||
427 | |||
428 | update land |
||
429 | set OwnerUUID = substr(OwnerUUID, 1, 8) || "-" || substr(OwnerUUID, 9, 4) || "-" || substr(OwnerUUID, 13, 4) || "-" || substr(OwnerUUID, 17, 4) || "-" || substr(OwnerUUID, 21, 12) |
||
430 | where OwnerUUID not like '%-%'; |
||
431 | |||
432 | update land |
||
433 | set GroupUUID = substr(GroupUUID, 1, 8) || "-" || substr(GroupUUID, 9, 4) || "-" || substr(GroupUUID, 13, 4) || "-" || substr(GroupUUID, 17, 4) || "-" || substr(GroupUUID, 21, 12) |
||
434 | where GroupUUID not like '%-%'; |
||
435 | |||
436 | update land |
||
437 | set MediaTextureUUID = substr(MediaTextureUUID, 1, 8) || "-" || substr(MediaTextureUUID, 9, 4) || "-" || substr(MediaTextureUUID, 13, 4) || "-" || substr(MediaTextureUUID, 17, 4) || "-" || substr(MediaTextureUUID, 21, 12) |
||
438 | where MediaTextureUUID not like '%-%'; |
||
439 | |||
440 | update land |
||
441 | set SnapshotUUID = substr(SnapshotUUID, 1, 8) || "-" || substr(SnapshotUUID, 9, 4) || "-" || substr(SnapshotUUID, 13, 4) || "-" || substr(SnapshotUUID, 17, 4) || "-" || substr(SnapshotUUID, 21, 12) |
||
442 | where SnapshotUUID not like '%-%'; |
||
443 | |||
444 | update land |
||
445 | set AuthbuyerID = substr(AuthbuyerID, 1, 8) || "-" || substr(AuthbuyerID, 9, 4) || "-" || substr(AuthbuyerID, 13, 4) || "-" || substr(AuthbuyerID, 17, 4) || "-" || substr(AuthbuyerID, 21, 12) |
||
446 | where AuthbuyerID not like '%-%'; |
||
447 | |||
448 | COMMIT; |
||
449 | |||
450 | :VERSION 19 |
||
451 | BEGIN; |
||
452 | ALTER TABLE regionsettings ADD COLUMN map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; |
||
453 | COMMIT; |
||
454 | |||
455 | :VERSION 20 |
||
456 | BEGIN; |
||
457 | ALTER TABLE prims ADD COLUMN MediaURL varchar(255); |
||
458 | ALTER TABLE primshapes ADD COLUMN Media TEXT; |
||
459 | COMMIT; |
||
460 | |||
461 | :VERSION 21 |
||
462 | BEGIN; |
||
463 | ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none'; |
||
464 | ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT ''; |
||
465 | ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0'; |
||
466 | ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE; |
||
467 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; |
||
468 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; |
||
469 | COMMIT; |
||
470 | |||
471 | :VERSION 22 |
||
472 | BEGIN; |
||
473 | ALTER TABLE regionsettings ADD COLUMN covenant_datetime INTEGER NOT NULL default 0; |
||
474 | COMMIT; |
||
475 | |||
476 | :VERSION 23 |
||
477 | BEGIN; |
||
478 | CREATE TABLE regionwindlight ( |
||
479 | region_id VARCHAR(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY, |
||
480 | water_color_r FLOAT NOT NULL DEFAULT '4.000000', |
||
481 | water_color_g FLOAT NOT NULL DEFAULT '38.000000', |
||
482 | water_color_b FLOAT NOT NULL DEFAULT '64.000000', |
||
483 | water_color_i FLOAT NOT NULL DEFAULT '1.000000', |
||
484 | water_fog_density_exponent FLOAT NOT NULL DEFAULT '4.0', |
||
485 | underwater_fog_modifier FLOAT NOT NULL DEFAULT '0.25', |
||
486 | reflection_wavelet_scale_1 FLOAT NOT NULL DEFAULT '2.0', |
||
487 | reflection_wavelet_scale_2 FLOAT NOT NULL DEFAULT '2.0', |
||
488 | reflection_wavelet_scale_3 FLOAT NOT NULL DEFAULT '2.0', |
||
489 | fresnel_scale FLOAT NOT NULL DEFAULT '0.40', |
||
490 | fresnel_offset FLOAT NOT NULL DEFAULT '0.50', |
||
491 | refract_scale_above FLOAT NOT NULL DEFAULT '0.03', |
||
492 | refract_scale_below FLOAT NOT NULL DEFAULT '0.20', |
||
493 | blur_multiplier FLOAT NOT NULL DEFAULT '0.040', |
||
494 | big_wave_direction_x FLOAT NOT NULL DEFAULT '1.05', |
||
495 | big_wave_direction_y FLOAT NOT NULL DEFAULT '-0.42', |
||
496 | little_wave_direction_x FLOAT NOT NULL DEFAULT '1.11', |
||
497 | little_wave_direction_y FLOAT NOT NULL DEFAULT '-1.16', |
||
498 | normal_map_texture VARCHAR(36) NOT NULL DEFAULT '822ded49-9a6c-f61c-cb89-6df54f42cdf4', |
||
499 | horizon_r FLOAT NOT NULL DEFAULT '0.25', |
||
500 | horizon_g FLOAT NOT NULL DEFAULT '0.25', |
||
501 | horizon_b FLOAT NOT NULL DEFAULT '0.32', |
||
502 | horizon_i FLOAT NOT NULL DEFAULT '0.32', |
||
503 | haze_horizon FLOAT NOT NULL DEFAULT '0.19', |
||
504 | blue_density_r FLOAT NOT NULL DEFAULT '0.12', |
||
505 | blue_density_g FLOAT NOT NULL DEFAULT '0.22', |
||
506 | blue_density_b FLOAT NOT NULL DEFAULT '0.38', |
||
507 | blue_density_i FLOAT NOT NULL DEFAULT '0.38', |
||
508 | haze_density FLOAT NOT NULL DEFAULT '0.70', |
||
509 | density_multiplier FLOAT NOT NULL DEFAULT '0.18', |
||
510 | distance_multiplier FLOAT NOT NULL DEFAULT '0.8', |
||
511 | max_altitude INTEGER NOT NULL DEFAULT '1605', |
||
512 | sun_moon_color_r FLOAT NOT NULL DEFAULT '0.24', |
||
513 | sun_moon_color_g FLOAT NOT NULL DEFAULT '0.26', |
||
514 | sun_moon_color_b FLOAT NOT NULL DEFAULT '0.30', |
||
515 | sun_moon_color_i FLOAT NOT NULL DEFAULT '0.30', |
||
516 | sun_moon_position FLOAT NOT NULL DEFAULT '0.317', |
||
517 | ambient_r FLOAT NOT NULL DEFAULT '0.35', |
||
518 | ambient_g FLOAT NOT NULL DEFAULT '0.35', |
||
519 | ambient_b FLOAT NOT NULL DEFAULT '0.35', |
||
520 | ambient_i FLOAT NOT NULL DEFAULT '0.35', |
||
521 | east_angle FLOAT NOT NULL DEFAULT '0.00', |
||
522 | sun_glow_focus FLOAT NOT NULL DEFAULT '0.10', |
||
523 | sun_glow_size FLOAT NOT NULL DEFAULT '1.75', |
||
524 | scene_gamma FLOAT NOT NULL DEFAULT '1.00', |
||
525 | star_brightness FLOAT NOT NULL DEFAULT '0.00', |
||
526 | cloud_color_r FLOAT NOT NULL DEFAULT '0.41', |
||
527 | cloud_color_g FLOAT NOT NULL DEFAULT '0.41', |
||
528 | cloud_color_b FLOAT NOT NULL DEFAULT '0.41', |
||
529 | cloud_color_i FLOAT NOT NULL DEFAULT '0.41', |
||
530 | cloud_x FLOAT NOT NULL DEFAULT '1.00', |
||
531 | cloud_y FLOAT NOT NULL DEFAULT '0.53', |
||
532 | cloud_density FLOAT NOT NULL DEFAULT '1.00', |
||
533 | cloud_coverage FLOAT NOT NULL DEFAULT '0.27', |
||
534 | cloud_scale FLOAT NOT NULL DEFAULT '0.42', |
||
535 | cloud_detail_x FLOAT NOT NULL DEFAULT '1.00', |
||
536 | cloud_detail_y FLOAT NOT NULL DEFAULT '0.53', |
||
537 | cloud_detail_density FLOAT NOT NULL DEFAULT '0.12', |
||
538 | cloud_scroll_x FLOAT NOT NULL DEFAULT '0.20', |
||
539 | cloud_scroll_x_lock INTEGER NOT NULL DEFAULT '0', |
||
540 | cloud_scroll_y FLOAT NOT NULL DEFAULT '0.01', |
||
541 | cloud_scroll_y_lock INTEGER NOT NULL DEFAULT '0', |
||
542 | draw_classic_clouds INTEGER NOT NULL DEFAULT '1'); |
||
543 | |||
544 | COMMIT; |
||
545 | |||
546 | |||
547 | :VERSION 24 |
||
548 | |||
549 | BEGIN; |
||
550 | |||
551 | CREATE TABLE IF NOT EXISTS `spawn_points` ( |
||
552 | `RegionID` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', |
||
553 | `Yaw` float NOT NULL, |
||
554 | `Pitch` float NOT NULL, |
||
555 | `Distance` float NOT NULL |
||
556 | ); |
||
557 | |||
558 | ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; |
||
559 | |||
560 | COMMIT; |
||
561 | |||
562 | :VERSION 25 |
||
563 | |||
564 | BEGIN; |
||
565 | ALTER TABLE `regionsettings` ADD COLUMN `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; |
||
566 | COMMIT; |
||
567 | |||
568 | :VERSION 26 |
||
569 | |||
570 | BEGIN; |
||
571 | |||
572 | CREATE TABLE `regionenvironment` ( |
||
573 | `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY, |
||
574 | `llsd_settings` TEXT NOT NULL |
||
575 | ); |
||
576 | |||
577 | COMMIT; |
||
578 | |||
579 | :VERSION 27 |
||
580 | BEGIN; |
||
581 | ALTER TABLE prims ADD COLUMN DynAttrs TEXT; |
||
582 | COMMIT; |
||
583 | |||
584 | :VERSION 28 |
||
585 | |||
586 | BEGIN; |
||
587 | |||
588 | ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0'; |
||
589 | ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000'; |
||
590 | ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1'; |
||
591 | ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6'; |
||
592 | ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5'; |
||
593 | |||
594 | COMMIT; |
||
595 | |||
596 | :VERSION 29 #---------------- Keyframes |
||
597 | |||
598 | BEGIN; |
||
599 | |||
600 | ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob; |
||
601 | |||
602 | COMMIT; |
||
603 | |||
604 | :VERSION 30 #---------------- Save Attachment info |
||
605 | |||
606 | BEGIN; |
||
607 | |||
608 | ALTER TABLE prims ADD COLUMN AttachedPosX double default '0'; |
||
609 | ALTER TABLE prims ADD COLUMN AttachedPosY double default '0'; |
||
610 | ALTER TABLE prims ADD COLUMN AttachedPosZ double default '0'; |
||
611 | ALTER TABLE primshapes ADD COLUMN LastAttachPoint int not null default '0'; |
||
612 | |||
613 | COMMIT; |
||
614 |