aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/RegionStore.migrations
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/SQLite/Resources/RegionStore.migrations549
1 files changed, 157 insertions, 392 deletions
diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
index 901068f..fb154cf 100644
--- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
@@ -1,56 +1,99 @@
1:VERSION 1 1:VERSION 31
2 2
3BEGIN TRANSACTION; 3BEGIN TRANSACTION;
4 4
5CREATE TABLE prims( 5CREATE TABLE IF NOT EXISTS prims(
6 UUID varchar(255) primary key, 6 UUID varchar(255) primary key,
7 RegionUUID varchar(255), 7 RegionUUID varchar(255),
8 ParentID integer, 8 CreationDate integer,
9 CreationDate integer, 9 Name varchar(255),
10 Name varchar(255), 10 SceneGroupID varchar(255),
11 SceneGroupID varchar(255), 11 Text varchar(255),
12 Text varchar(255), 12 Description varchar(255),
13 Description varchar(255), 13 SitName varchar(255),
14 SitName varchar(255), 14 TouchName varchar(255),
15 TouchName varchar(255), 15 CreatorID varchar(255),
16 CreatorID varchar(255), 16 OwnerID varchar(255),
17 OwnerID varchar(255), 17 GroupID varchar(255),
18 GroupID varchar(255), 18 LastOwnerID varchar(255),
19 LastOwnerID varchar(255), 19 OwnerMask integer,
20 OwnerMask integer, 20 NextOwnerMask integer,
21 NextOwnerMask integer, 21 GroupMask integer,
22 GroupMask integer, 22 EveryoneMask integer,
23 EveryoneMask integer, 23 BaseMask integer,
24 BaseMask integer, 24 PositionX float,
25 PositionX float, 25 PositionY float,
26 PositionY float, 26 PositionZ float,
27 PositionZ float, 27 GroupPositionX float,
28 GroupPositionX float, 28 GroupPositionY float,
29 GroupPositionY float, 29 GroupPositionZ float,
30 GroupPositionZ float, 30 VelocityX float,
31 VelocityX float, 31 VelocityY float,
32 VelocityY float, 32 VelocityZ float,
33 VelocityZ float, 33 AngularVelocityX float,
34 AngularVelocityX float, 34 AngularVelocityY float,
35 AngularVelocityY float, 35 AngularVelocityZ float,
36 AngularVelocityZ float, 36 AccelerationX float,
37 AccelerationX float, 37 AccelerationY float,
38 AccelerationY float, 38 AccelerationZ float,
39 AccelerationZ float, 39 RotationX float,
40 RotationX float, 40 RotationY float,
41 RotationY float, 41 RotationZ float,
42 RotationZ float, 42 RotationW float,
43 RotationW float, 43 ObjectFlags integer,
44 ObjectFlags integer, 44 SitTargetOffsetX float NOT NULL default 0,
45 SitTargetOffsetX float NOT NULL default 0, 45 SitTargetOffsetY float NOT NULL default 0,
46 SitTargetOffsetY float NOT NULL default 0, 46 SitTargetOffsetZ float NOT NULL default 0,
47 SitTargetOffsetZ float NOT NULL default 0, 47 SitTargetOrientW float NOT NULL default 0,
48 SitTargetOrientW float NOT NULL default 0, 48 SitTargetOrientX float NOT NULL default 0,
49 SitTargetOrientX float NOT NULL default 0, 49 SitTargetOrientY float NOT NULL default 0,
50 SitTargetOrientY float NOT NULL default 0, 50 SitTargetOrientZ float NOT NULL default 0,
51 SitTargetOrientZ float NOT NULL default 0); 51 ColorR integer not null default 0,
52 52 ColorG integer not null default 0,
53CREATE TABLE primshapes( 53 ColorB integer not null default 0,
54 ColorA integer not null default 0,
55 ClickAction integer not null default 0,
56 PayPrice integer not null default 0,
57 PayButton1 integer not null default 0,
58 PayButton2 integer not null default 0,
59 PayButton3 integer not null default 0,
60 PayButton4 integer not null default 0,
61 LoopedSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
62 LoopedSoundGain float NOT NULL default 0,
63 TextureAnimation string,
64 ParticleSystem string,
65 OmegaX float NOT NULL default 0,
66 OmegaY float NOT NULL default 0,
67 OmegaZ float NOT NULL default 0,
68 CameraEyeOffsetX float NOT NULL default 0,
69 CameraEyeOffsetY float NOT NULL default 0,
70 CameraEyeOffsetZ float NOT NULL default 0,
71 CameraAtOffsetX float NOT NULL default 0,
72 CameraAtOffsetY float NOT NULL default 0,
73 CameraAtOffsetZ float NOT NULL default 0,
74 ForceMouselook string NOT NULL default 0,
75 ScriptAccessPin INTEGER NOT NULL default 0,
76 AllowedDrop INTEGER NOT NULL default 0,
77 DieAtEdge string NOT NULL default 0,
78 SalePrice INTEGER NOT NULL default 0,
79 SaleType string NOT NULL default 0,
80 Material INTEGER NOT NULL default 3,
81 CollisionSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
82 CollisionSoundVolume float NOT NULL default 0,
83 VolumeDetect INTEGER NOT NULL DEFAULT 0,
84 MediaURL varchar(255),
85 DynAttrs TEXT,
86 `PhysicsShapeType` tinyint(4) NOT NULL default '0',
87 `Density` double NOT NULL default '1000',
88 `GravityModifier` double NOT NULL default '1',
89 `Friction` double NOT NULL default '0.6',
90 `Restitution` double NOT NULL default '0.5',
91 `KeyframeMotion` blob,
92 AttachedPosX double default '0',
93 AttachedPosY double default '0',
94 AttachedPosZ double default '0');
95
96CREATE TABLE IF NOT EXISTS primshapes(
54 UUID varchar(255) primary key, 97 UUID varchar(255) primary key,
55 Shape integer, 98 Shape integer,
56 ScaleX float, 99 ScaleX float,
@@ -76,10 +119,12 @@ CREATE TABLE primshapes(
76 ProfileCurve integer, 119 ProfileCurve integer,
77 ProfileHollow integer, 120 ProfileHollow integer,
78 Texture blob, 121 Texture blob,
79 ExtraParams blob, 122 ExtraParams blob,
80 State Integer NOT NULL default 0); 123 State Integer NOT NULL default 0,
124 Media TEXT,
125 LastAttachPoint int not null default '0');
81 126
82CREATE TABLE primitems( 127CREATE TABLE IF NOT EXISTS primitems(
83 itemID varchar(255) primary key, 128 itemID varchar(255) primary key,
84 primID varchar(255), 129 primID varchar(255),
85 assetID varchar(255), 130 assetID varchar(255),
@@ -97,14 +142,15 @@ CREATE TABLE primitems(
97 currentPermissions string, 142 currentPermissions string,
98 basePermissions string, 143 basePermissions string,
99 everyonePermissions string, 144 everyonePermissions string,
100 groupPermissions string); 145 groupPermissions string,
146 flags integer not null default 0);
101 147
102CREATE TABLE terrain( 148CREATE TABLE IF NOT EXISTS terrain(
103 RegionUUID varchar(255), 149 RegionUUID varchar(255),
104 Revision integer, 150 Revision integer,
105 Heightfield blob); 151 Heightfield blob);
106 152
107CREATE TABLE land( 153CREATE TABLE IF NOT EXISTS land(
108 UUID varchar(255) primary key, 154 UUID varchar(255) primary key,
109 RegionUUID varchar(255), 155 RegionUUID varchar(255),
110 LocalLandID string, 156 LocalLandID string,
@@ -135,92 +181,30 @@ CREATE TABLE land(
135 UserLocationZ float, 181 UserLocationZ float,
136 UserLookAtX float, 182 UserLookAtX float,
137 UserLookAtY float, 183 UserLookAtY float,
138 UserLookAtZ float, 184 UserLookAtZ float,
139 AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'); 185 AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
140 186 OtherCleanTime INTEGER NOT NULL default 0,
141CREATE TABLE landaccesslist( 187 Dwell INTEGER NOT NULL default 0,
188 `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none',
189 `MediaDescription` VARCHAR(255) NOT NULL DEFAULT '',
190 `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0',
191 `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE,
192 `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE,
193 `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE);
194
195CREATE TABLE IF NOT EXISTS landaccesslist(
142 LandUUID varchar(255), 196 LandUUID varchar(255),
143 AccessUUID varchar(255), 197 AccessUUID varchar(255),
144 Flags string); 198 Flags string);
145 199
146COMMIT; 200CREATE TABLE IF NOT EXISTS regionban(
147 201 regionUUID varchar (255),
148:VERSION 2 202 bannedUUID varchar (255),
149 203 bannedIp varchar (255),
150BEGIN TRANSACTION; 204 bannedIpHostMask varchar (255)
151 205 );
152CREATE TABLE regionban(
153 regionUUID varchar (255),
154 bannedUUID varchar (255),
155 bannedIp varchar (255),
156 bannedIpHostMask varchar (255)
157 );
158
159COMMIT;
160
161:VERSION 3
162
163BEGIN;
164
165ALTER TABLE primitems add flags integer not null default 0;
166
167COMMIT;
168
169:VERSION 4
170
171BEGIN;
172
173create 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
208COMMIT;
209
210:VERSION 5
211
212BEGIN;
213
214delete from regionsettings;
215
216COMMIT;
217
218:VERSION 6
219 206
220BEGIN TRANSACTION; 207CREATE TABLE IF NOT EXISTS regionsettings (
221
222drop table regionsettings;
223CREATE TABLE regionsettings (
224 regionUUID char(36) NOT NULL, 208 regionUUID char(36) NOT NULL,
225 block_terraform int(11) NOT NULL, 209 block_terraform int(11) NOT NULL,
226 block_fly int(11) NOT NULL, 210 block_fly int(11) NOT NULL,
@@ -254,228 +238,18 @@ CREATE TABLE regionsettings (
254 fixed_sun int(11) NOT NULL, 238 fixed_sun int(11) NOT NULL,
255 sun_position float NOT NULL, 239 sun_position float NOT NULL,
256 covenant char(36) default NULL, 240 covenant char(36) default NULL,
257 sandbox tinyint(4) NOT NULL, 241 sandbox tinyint(4) NOT NULL,
242 sunvectorx double NOT NULL default 0,
243 sunvectory double NOT NULL default 0,
244 sunvectorz double NOT NULL default 0,
245 map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
246 covenant_datetime INTEGER NOT NULL default 0,
247 `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
248 `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
258 PRIMARY KEY (regionUUID) 249 PRIMARY KEY (regionUUID)
259); 250);
260 251
261COMMIT; 252CREATE TABLE IF NOT EXISTS regionwindlight (
262
263:VERSION 9
264
265BEGIN;
266
267ALTER TABLE prims ADD COLUMN ColorR integer not null default 0;
268ALTER TABLE prims ADD COLUMN ColorG integer not null default 0;
269ALTER TABLE prims ADD COLUMN ColorB integer not null default 0;
270ALTER TABLE prims ADD COLUMN ColorA integer not null default 0;
271
272COMMIT;
273
274:VERSION 10
275
276BEGIN;
277
278ALTER TABLE prims ADD COLUMN ClickAction INTEGER NOT NULL default 0;
279
280COMMIT;
281
282:VERSION 11
283
284BEGIN;
285
286ALTER TABLE prims ADD COLUMN PayPrice INTEGER NOT NULL default 0;
287ALTER TABLE prims ADD COLUMN PayButton1 INTEGER NOT NULL default 0;
288ALTER TABLE prims ADD COLUMN PayButton2 INTEGER NOT NULL default 0;
289ALTER TABLE prims ADD COLUMN PayButton3 INTEGER NOT NULL default 0;
290ALTER TABLE prims ADD COLUMN PayButton4 INTEGER NOT NULL default 0;
291ALTER TABLE prims ADD COLUMN LoopedSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
292ALTER TABLE prims ADD COLUMN LoopedSoundGain float NOT NULL default 0;
293ALTER TABLE prims ADD COLUMN TextureAnimation string;
294ALTER TABLE prims ADD COLUMN ParticleSystem string;
295ALTER TABLE prims ADD COLUMN OmegaX float NOT NULL default 0;
296ALTER TABLE prims ADD COLUMN OmegaY float NOT NULL default 0;
297ALTER TABLE prims ADD COLUMN OmegaZ float NOT NULL default 0;
298ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float NOT NULL default 0;
299ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float NOT NULL default 0;
300ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float NOT NULL default 0;
301ALTER TABLE prims ADD COLUMN CameraAtOffsetX float NOT NULL default 0;
302ALTER TABLE prims ADD COLUMN CameraAtOffsetY float NOT NULL default 0;
303ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float NOT NULL default 0;
304ALTER TABLE prims ADD COLUMN ForceMouselook string NOT NULL default 0;
305ALTER TABLE prims ADD COLUMN ScriptAccessPin INTEGER NOT NULL default 0;
306ALTER TABLE prims ADD COLUMN AllowedDrop INTEGER NOT NULL default 0;
307ALTER TABLE prims ADD COLUMN DieAtEdge string NOT NULL default 0;
308ALTER TABLE prims ADD COLUMN SalePrice INTEGER NOT NULL default 0;
309ALTER TABLE prims ADD COLUMN SaleType string NOT NULL default 0;
310
311COMMIT;
312
313:VERSION 12
314
315BEGIN;
316
317ALTER TABLE prims ADD COLUMN Material INTEGER NOT NULL default 3;
318
319COMMIT;
320
321:VERSION 13
322
323BEGIN;
324
325ALTER TABLE land ADD COLUMN OtherCleanTime INTEGER NOT NULL default 0;
326ALTER TABLE land ADD COLUMN Dwell INTEGER NOT NULL default 0;
327
328COMMIT;
329
330:VERSION 14
331
332begin;
333
334ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0;
335ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0;
336ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0;
337
338commit;
339
340:VERSION 15
341
342BEGIN;
343
344ALTER TABLE prims ADD COLUMN CollisionSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
345ALTER TABLE prims ADD COLUMN CollisionSoundVolume float NOT NULL default 0;
346
347COMMIT;
348
349:VERSION 16
350
351BEGIN;
352
353ALTER TABLE prims ADD COLUMN VolumeDetect INTEGER NOT NULL DEFAULT 0;
354
355COMMIT;
356
357:VERSION 17
358
359BEGIN;
360CREATE 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);
361INSERT 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;
362DROP TABLE prims;
363CREATE 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);
364INSERT 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;
365DROP TABLE prims_backup;
366COMMIT;
367
368:VERSION 18
369
370BEGIN;
371
372update 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
377update 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
381update 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
386update 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
390update 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
394update 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
398update 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
402update 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
406update 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
410update 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
415update 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
420update 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
424update 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
428update 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
432update 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
436update 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
440update 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
444update 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
448COMMIT;
449
450:VERSION 19
451BEGIN;
452ALTER TABLE regionsettings ADD COLUMN map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
453COMMIT;
454
455:VERSION 20
456BEGIN;
457ALTER TABLE prims ADD COLUMN MediaURL varchar(255);
458ALTER TABLE primshapes ADD COLUMN Media TEXT;
459COMMIT;
460
461:VERSION 21
462BEGIN;
463ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none';
464ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT '';
465ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0';
466ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE;
467ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE;
468ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE;
469COMMIT;
470
471:VERSION 22
472BEGIN;
473ALTER TABLE regionsettings ADD COLUMN covenant_datetime INTEGER NOT NULL default 0;
474COMMIT;
475
476:VERSION 23
477BEGIN;
478CREATE TABLE regionwindlight (
479 region_id VARCHAR(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY, 253 region_id VARCHAR(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY,
480 water_color_r FLOAT NOT NULL DEFAULT '4.000000', 254 water_color_r FLOAT NOT NULL DEFAULT '4.000000',
481 water_color_g FLOAT NOT NULL DEFAULT '38.000000', 255 water_color_g FLOAT NOT NULL DEFAULT '38.000000',
@@ -541,13 +315,6 @@ CREATE TABLE regionwindlight (
541 cloud_scroll_y_lock INTEGER NOT NULL DEFAULT '0', 315 cloud_scroll_y_lock INTEGER NOT NULL DEFAULT '0',
542 draw_classic_clouds INTEGER NOT NULL DEFAULT '1'); 316 draw_classic_clouds INTEGER NOT NULL DEFAULT '1');
543 317
544COMMIT;
545
546
547:VERSION 24
548
549BEGIN;
550
551CREATE TABLE IF NOT EXISTS `spawn_points` ( 318CREATE TABLE IF NOT EXISTS `spawn_points` (
552 `RegionID` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', 319 `RegionID` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000',
553 `Yaw` float NOT NULL, 320 `Yaw` float NOT NULL,
@@ -555,60 +322,58 @@ CREATE TABLE IF NOT EXISTS `spawn_points` (
555 `Distance` float NOT NULL 322 `Distance` float NOT NULL
556); 323);
557 324
558ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; 325CREATE TABLE IF NOT EXISTS `regionenvironment` (
326 `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY,
327 `llsd_settings` TEXT NOT NULL
328);
559 329
560COMMIT; 330COMMIT;
561 331
562:VERSION 25
563
564BEGIN;
565ALTER TABLE `regionsettings` ADD COLUMN `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
566COMMIT;
567 332
568:VERSION 26 333:VERSION 32 #---- avination fields plus a few others
569 334
570BEGIN; 335BEGIN;
571 336
572CREATE TABLE `regionenvironment` ( 337ALTER TABLE `prims` ADD COLUMN `PassTouches` BOOLEAN NOT NULL DEFAULT FALSE;
573 `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000' PRIMARY KEY, 338ALTER TABLE `prims` ADD COLUMN `PassCollisions`BOOLEAN NOT NULL DEFAULT FALSE;
574 `llsd_settings` TEXT NOT NULL 339ALTER TABLE `prims` ADD COLUMN `Vehicle` TEXT default NULL;
575); 340ALTER TABLE `regionsettings` ADD COLUMN `block_search` BOOLEAN NOT NULL DEFAULT FALSE;;
341ALTER TABLE `regionsettings` ADD COLUMN `casino` BOOLEAN NOT NULL DEFAULT FALSE;;
342ALTER TABLE `land` ADD COLUMN `SeeAVs` BOOLEAN NOT NULL DEFAULT TRUE;
343ALTER TABLE `land` ADD COLUMN `AnyAVSounds` BOOLEAN NOT NULL DEFAULT TRUE;
344ALTER TABLE `land` ADD COLUMN `GroupAVSounds` BOOLEAN NOT NULL DEFAULT TRUE;
576 345
577COMMIT; 346COMMIT;
578 347
579:VERSION 27 348:VERSION 33 #---- Rotation axis locks
580BEGIN;
581ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
582COMMIT;
583
584:VERSION 28
585 349
586BEGIN; 350BEGIN;
587 351
588ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0'; 352ALTER TABLE prims ADD COLUMN `RotationAxisLocks` tinyint(4) NOT NULL default '0';
589ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000';
590ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1';
591ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6';
592ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5';
593 353
594COMMIT; 354COMMIT;
595 355
596:VERSION 29 #---------------- Keyframes 356:VERSION 34 #---- add baked terrain store
597 357
598BEGIN; 358BEGIN;
599 359
600ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob; 360CREATE TABLE IF NOT EXISTS bakedterrain(
361 RegionUUID varchar(255),
362 Revision integer,
363 Heightfield blob);
601 364
602COMMIT; 365COMMIT;
603 366
604:VERSION 30 #---------------- Save Attachment info 367:VERSION 35 #----- Add RezzerID field in table prims
605 368
606BEGIN; 369BEGIN;
607 370
608ALTER TABLE prims ADD COLUMN AttachedPosX double default '0'; 371ALTER TABLE `prims` ADD COLUMN `RezzerID` char(36) DEFAULT NULL;
609ALTER TABLE prims ADD COLUMN AttachedPosY double default '0';
610ALTER TABLE prims ADD COLUMN AttachedPosZ double default '0';
611ALTER TABLE primshapes ADD COLUMN LastAttachPoint int not null default '0';
612 372
613COMMIT; 373COMMIT;
614 374
375:VERSION 36 #----- Add physics inertia data
376
377BEGIN;
378ALTER TABLE `prims` ADD COLUMN `PhysInertia` TEXT default NULL;
379COMMIT;
generated by cgit v1.1 at 2024-10-31 05:11:23 +0000