aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-06 23:16:36 +0300
committerAlexRa2010-05-16 17:04:50 +0300
commitdfeb9a0b5c07a85ec8aed591206468cee83ce637 (patch)
tree412dbee487945ed78c9d2598d2310a02c411ef96 /OpenSim/Data/MSSQL/Resources/RegionStore.migrations
parentMigrations for SQLite converted to new format (diff)
downloadopensim-SC_OLD-dfeb9a0b5c07a85ec8aed591206468cee83ce637.zip
opensim-SC_OLD-dfeb9a0b5c07a85ec8aed591206468cee83ce637.tar.gz
opensim-SC_OLD-dfeb9a0b5c07a85ec8aed591206468cee83ce637.tar.bz2
opensim-SC_OLD-dfeb9a0b5c07a85ec8aed591206468cee83ce637.tar.xz
MS SQL migrations converted to the new format
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/RegionStore.migrations')
-rw-r--r--OpenSim/Data/MSSQL/Resources/RegionStore.migrations929
1 files changed, 929 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
new file mode 100644
index 0000000..e912d64
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
@@ -0,0 +1,929 @@
1
2:VERSION 1
3
4CREATE TABLE [dbo].[prims](
5 [UUID] [varchar](255) NOT NULL,
6 [RegionUUID] [varchar](255) NULL,
7 [ParentID] [int] NULL,
8 [CreationDate] [int] NULL,
9 [Name] [varchar](255) NULL,
10 [SceneGroupID] [varchar](255) NULL,
11 [Text] [varchar](255) NULL,
12 [Description] [varchar](255) NULL,
13 [SitName] [varchar](255) NULL,
14 [TouchName] [varchar](255) NULL,
15 [ObjectFlags] [int] NULL,
16 [CreatorID] [varchar](255) NULL,
17 [OwnerID] [varchar](255) NULL,
18 [GroupID] [varchar](255) NULL,
19 [LastOwnerID] [varchar](255) NULL,
20 [OwnerMask] [int] NULL,
21 [NextOwnerMask] [int] NULL,
22 [GroupMask] [int] NULL,
23 [EveryoneMask] [int] NULL,
24 [BaseMask] [int] NULL,
25 [PositionX] [float] NULL,
26 [PositionY] [float] NULL,
27 [PositionZ] [float] NULL,
28 [GroupPositionX] [float] NULL,
29 [GroupPositionY] [float] NULL,
30 [GroupPositionZ] [float] NULL,
31 [VelocityX] [float] NULL,
32 [VelocityY] [float] NULL,
33 [VelocityZ] [float] NULL,
34 [AngularVelocityX] [float] NULL,
35 [AngularVelocityY] [float] NULL,
36 [AngularVelocityZ] [float] NULL,
37 [AccelerationX] [float] NULL,
38 [AccelerationY] [float] NULL,
39 [AccelerationZ] [float] NULL,
40 [RotationX] [float] NULL,
41 [RotationY] [float] NULL,
42 [RotationZ] [float] NULL,
43 [RotationW] [float] NULL,
44 [SitTargetOffsetX] [float] NULL,
45 [SitTargetOffsetY] [float] NULL,
46 [SitTargetOffsetZ] [float] NULL,
47 [SitTargetOrientW] [float] NULL,
48 [SitTargetOrientX] [float] NULL,
49 [SitTargetOrientY] [float] NULL,
50 [SitTargetOrientZ] [float] NULL,
51PRIMARY KEY CLUSTERED
52(
53 [UUID] ASC
54)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
55) ON [PRIMARY]
56
57CREATE TABLE [dbo].[primshapes](
58 [UUID] [varchar](255) NOT NULL,
59 [Shape] [int] NULL,
60 [ScaleX] [float] NULL,
61 [ScaleY] [float] NULL,
62 [ScaleZ] [float] NULL,
63 [PCode] [int] NULL,
64 [PathBegin] [int] NULL,
65 [PathEnd] [int] NULL,
66 [PathScaleX] [int] NULL,
67 [PathScaleY] [int] NULL,
68 [PathShearX] [int] NULL,
69 [PathShearY] [int] NULL,
70 [PathSkew] [int] NULL,
71 [PathCurve] [int] NULL,
72 [PathRadiusOffset] [int] NULL,
73 [PathRevolutions] [int] NULL,
74 [PathTaperX] [int] NULL,
75 [PathTaperY] [int] NULL,
76 [PathTwist] [int] NULL,
77 [PathTwistBegin] [int] NULL,
78 [ProfileBegin] [int] NULL,
79 [ProfileEnd] [int] NULL,
80 [ProfileCurve] [int] NULL,
81 [ProfileHollow] [int] NULL,
82 [State] [int] NULL,
83 [Texture] [image] NULL,
84 [ExtraParams] [image] NULL,
85PRIMARY KEY CLUSTERED
86(
87 [UUID] ASC
88)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
89) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
90
91CREATE TABLE [dbo].[primitems](
92 [itemID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
93 [primID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
94 [assetID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
95 [parentFolderID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
96 [invType] [int] NULL,
97 [assetType] [int] NULL,
98 [name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
99 [description] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
100 [creationDate] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
101 [creatorID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
102 [ownerID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
103 [lastOwnerID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
104 [groupID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
105 [nextPermissions] [int] NULL,
106 [currentPermissions] [int] NULL,
107 [basePermissions] [int] NULL,
108 [everyonePermissions] [int] NULL,
109 [groupPermissions] [int] NULL,
110PRIMARY KEY CLUSTERED
111(
112 [itemID] ASC
113)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
114) ON [PRIMARY]
115
116CREATE TABLE [dbo].[terrain](
117 [RegionUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
118 [Revision] [int] NULL,
119 [Heightfield] [image] NULL
120) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
121
122CREATE TABLE [dbo].[land](
123 [UUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
124 [RegionUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
125 [LocalLandID] [int] NULL,
126 [Bitmap] [image] NULL,
127 [Name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
128 [Description] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
129 [OwnerUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
130 [IsGroupOwned] [int] NULL,
131 [Area] [int] NULL,
132 [AuctionID] [int] NULL,
133 [Category] [int] NULL,
134 [ClaimDate] [int] NULL,
135 [ClaimPrice] [int] NULL,
136 [GroupUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
137 [SalePrice] [int] NULL,
138 [LandStatus] [int] NULL,
139 [LandFlags] [int] NULL,
140 [LandingType] [int] NULL,
141 [MediaAutoScale] [int] NULL,
142 [MediaTextureUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
143 [MediaURL] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
144 [MusicURL] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
145 [PassHours] [float] NULL,
146 [PassPrice] [int] NULL,
147 [SnapshotUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
148 [UserLocationX] [float] NULL,
149 [UserLocationY] [float] NULL,
150 [UserLocationZ] [float] NULL,
151 [UserLookAtX] [float] NULL,
152 [UserLookAtY] [float] NULL,
153 [UserLookAtZ] [float] NULL,
154PRIMARY KEY CLUSTERED
155(
156 [UUID] ASC
157)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
158) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
159
160CREATE TABLE [dbo].[landaccesslist](
161 [LandUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
162 [AccessUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
163 [Flags] [int] NULL
164) ON [PRIMARY]
165
166:VERSION 2
167
168BEGIN TRANSACTION
169
170CREATE TABLE regionban (
171 [regionUUID] VARCHAR(36) NOT NULL,
172 [bannedUUID] VARCHAR(36) NOT NULL,
173 [bannedIp] VARCHAR(16) NOT NULL,
174 [bannedIpHostMask] VARCHAR(16) NOT NULL)
175
176create table [dbo].[regionsettings] (
177 [regionUUID] [varchar](36) not null,
178 [block_terraform] [bit] not null,
179 [block_fly] [bit] not null,
180 [allow_damage] [bit] not null,
181 [restrict_pushing] [bit] not null,
182 [allow_land_resell] [bit] not null,
183 [allow_land_join_divide] [bit] not null,
184 [block_show_in_search] [bit] not null,
185 [agent_limit] [int] not null,
186 [object_bonus] [float] not null,
187 [maturity] [int] not null,
188 [disable_scripts] [bit] not null,
189 [disable_collisions] [bit] not null,
190 [disable_physics] [bit] not null,
191 [terrain_texture_1] [varchar](36) not null,
192 [terrain_texture_2] [varchar](36) not null,
193 [terrain_texture_3] [varchar](36) not null,
194 [terrain_texture_4] [varchar](36) not null,
195 [elevation_1_nw] [float] not null,
196 [elevation_2_nw] [float] not null,
197 [elevation_1_ne] [float] not null,
198 [elevation_2_ne] [float] not null,
199 [elevation_1_se] [float] not null,
200 [elevation_2_se] [float] not null,
201 [elevation_1_sw] [float] not null,
202 [elevation_2_sw] [float] not null,
203 [water_height] [float] not null,
204 [terrain_raise_limit] [float] not null,
205 [terrain_lower_limit] [float] not null,
206 [use_estate_sun] [bit] not null,
207 [fixed_sun] [bit] not null,
208 [sun_position] [float] not null,
209 [covenant] [varchar](36) default NULL,
210 [Sandbox] [bit] NOT NULL,
211PRIMARY KEY CLUSTERED
212(
213 [regionUUID] ASC
214)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
215) ON [PRIMARY]
216
217COMMIT
218
219:VERSION 3
220
221BEGIN TRANSACTION
222
223CREATE TABLE dbo.Tmp_prims
224 (
225 UUID varchar(36) NOT NULL,
226 RegionUUID varchar(36) NULL,
227 ParentID int NULL,
228 CreationDate int NULL,
229 Name varchar(255) NULL,
230 SceneGroupID varchar(36) NULL,
231 Text varchar(255) NULL,
232 Description varchar(255) NULL,
233 SitName varchar(255) NULL,
234 TouchName varchar(255) NULL,
235 ObjectFlags int NULL,
236 CreatorID varchar(36) NULL,
237 OwnerID varchar(36) NULL,
238 GroupID varchar(36) NULL,
239 LastOwnerID varchar(36) NULL,
240 OwnerMask int NULL,
241 NextOwnerMask int NULL,
242 GroupMask int NULL,
243 EveryoneMask int NULL,
244 BaseMask int NULL,
245 PositionX float(53) NULL,
246 PositionY float(53) NULL,
247 PositionZ float(53) NULL,
248 GroupPositionX float(53) NULL,
249 GroupPositionY float(53) NULL,
250 GroupPositionZ float(53) NULL,
251 VelocityX float(53) NULL,
252 VelocityY float(53) NULL,
253 VelocityZ float(53) NULL,
254 AngularVelocityX float(53) NULL,
255 AngularVelocityY float(53) NULL,
256 AngularVelocityZ float(53) NULL,
257 AccelerationX float(53) NULL,
258 AccelerationY float(53) NULL,
259 AccelerationZ float(53) NULL,
260 RotationX float(53) NULL,
261 RotationY float(53) NULL,
262 RotationZ float(53) NULL,
263 RotationW float(53) NULL,
264 SitTargetOffsetX float(53) NULL,
265 SitTargetOffsetY float(53) NULL,
266 SitTargetOffsetZ float(53) NULL,
267 SitTargetOrientW float(53) NULL,
268 SitTargetOrientX float(53) NULL,
269 SitTargetOrientY float(53) NULL,
270 SitTargetOrientZ float(53) NULL
271 ) ON [PRIMARY]
272
273IF EXISTS(SELECT * FROM dbo.prims)
274 EXEC('INSERT INTO dbo.Tmp_prims (UUID, RegionUUID, ParentID, CreationDate, Name, SceneGroupID, Text, Description, SitName, TouchName, ObjectFlags, 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, SitTargetOffsetX, SitTargetOffsetY, SitTargetOffsetZ, SitTargetOrientW, SitTargetOrientX, SitTargetOrientY, SitTargetOrientZ)
275 SELECT CONVERT(varchar(36), UUID), CONVERT(varchar(36), RegionUUID), ParentID, CreationDate, Name, CONVERT(varchar(36), SceneGroupID), Text, Description, SitName, TouchName, ObjectFlags, CONVERT(varchar(36), CreatorID), CONVERT(varchar(36), OwnerID), CONVERT(varchar(36), GroupID), CONVERT(varchar(36), 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, SitTargetOffsetX, SitTargetOffsetY, SitTargetOffsetZ, SitTargetOrientW, SitTargetOrientX, SitTargetOrientY, SitTargetOrientZ FROM dbo.prims WITH (HOLDLOCK TABLOCKX)')
276
277DROP TABLE dbo.prims
278
279EXECUTE sp_rename N'dbo.Tmp_prims', N'prims', 'OBJECT'
280
281ALTER TABLE dbo.prims ADD CONSTRAINT
282 PK__prims__10566F31 PRIMARY KEY CLUSTERED
283 (
284 UUID
285 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
286
287COMMIT
288
289:VERSION 4
290
291BEGIN TRANSACTION
292
293CREATE TABLE Tmp_primitems
294 (
295 itemID varchar(36) NOT NULL,
296 primID varchar(36) NULL,
297 assetID varchar(36) NULL,
298 parentFolderID varchar(36) NULL,
299 invType int NULL,
300 assetType int NULL,
301 name varchar(255) NULL,
302 description varchar(255) NULL,
303 creationDate varchar(255) NULL,
304 creatorID varchar(36) NULL,
305 ownerID varchar(36) NULL,
306 lastOwnerID varchar(36) NULL,
307 groupID varchar(36) NULL,
308 nextPermissions int NULL,
309 currentPermissions int NULL,
310 basePermissions int NULL,
311 everyonePermissions int NULL,
312 groupPermissions int NULL
313 ) ON [PRIMARY]
314
315IF EXISTS(SELECT * FROM primitems)
316 EXEC('INSERT INTO Tmp_primitems (itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate, creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions)
317 SELECT CONVERT(varchar(36), itemID), CONVERT(varchar(36), primID), CONVERT(varchar(36), assetID), CONVERT(varchar(36), parentFolderID), invType, assetType, name, description, creationDate, CONVERT(varchar(36), creatorID), CONVERT(varchar(36), ownerID), CONVERT(varchar(36), lastOwnerID), CONVERT(varchar(36), groupID), nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions')
318
319DROP TABLE primitems
320
321EXECUTE sp_rename N'Tmp_primitems', N'primitems', 'OBJECT'
322
323ALTER TABLE primitems ADD CONSTRAINT
324 PK__primitems__0A688BB1 PRIMARY KEY CLUSTERED
325 (
326 itemID
327 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
328
329
330COMMIT
331
332
333:VERSION 5
334
335BEGIN TRANSACTION
336
337CREATE TABLE Tmp_primshapes
338 (
339 UUID varchar(36) NOT NULL,
340 Shape int NULL,
341 ScaleX float(53) NULL,
342 ScaleY float(53) NULL,
343 ScaleZ float(53) NULL,
344 PCode int NULL,
345 PathBegin int NULL,
346 PathEnd int NULL,
347 PathScaleX int NULL,
348 PathScaleY int NULL,
349 PathShearX int NULL,
350 PathShearY int NULL,
351 PathSkew int NULL,
352 PathCurve int NULL,
353 PathRadiusOffset int NULL,
354 PathRevolutions int NULL,
355 PathTaperX int NULL,
356 PathTaperY int NULL,
357 PathTwist int NULL,
358 PathTwistBegin int NULL,
359 ProfileBegin int NULL,
360 ProfileEnd int NULL,
361 ProfileCurve int NULL,
362 ProfileHollow int NULL,
363 State int NULL,
364 Texture image NULL,
365 ExtraParams image NULL
366 ) ON [PRIMARY]
367 TEXTIMAGE_ON [PRIMARY]
368
369IF EXISTS(SELECT * FROM primshapes)
370 EXEC('INSERT INTO Tmp_primshapes (UUID, Shape, ScaleX, ScaleY, ScaleZ, PCode, PathBegin, PathEnd, PathScaleX, PathScaleY, PathShearX, PathShearY, PathSkew, PathCurve, PathRadiusOffset, PathRevolutions, PathTaperX, PathTaperY, PathTwist, PathTwistBegin, ProfileBegin, ProfileEnd, ProfileCurve, ProfileHollow, State, Texture, ExtraParams)
371 SELECT CONVERT(varchar(36), UUID), Shape, ScaleX, ScaleY, ScaleZ, PCode, PathBegin, PathEnd, PathScaleX, PathScaleY, PathShearX, PathShearY, PathSkew, PathCurve, PathRadiusOffset, PathRevolutions, PathTaperX, PathTaperY, PathTwist, PathTwistBegin, ProfileBegin, ProfileEnd, ProfileCurve, ProfileHollow, State, Texture, ExtraParams FROM primshapes WITH (HOLDLOCK TABLOCKX)')
372
373DROP TABLE primshapes
374
375EXECUTE sp_rename N'Tmp_primshapes', N'primshapes', 'OBJECT'
376
377ALTER TABLE primshapes ADD CONSTRAINT
378 PK__primshapes__0880433F PRIMARY KEY CLUSTERED
379 (
380 UUID
381 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
382
383COMMIT
384
385
386:VERSION 6
387
388BEGIN TRANSACTION
389
390ALTER TABLE prims ADD PayPrice int not null default 0
391ALTER TABLE prims ADD PayButton1 int not null default 0
392ALTER TABLE prims ADD PayButton2 int not null default 0
393ALTER TABLE prims ADD PayButton3 int not null default 0
394ALTER TABLE prims ADD PayButton4 int not null default 0
395ALTER TABLE prims ADD LoopedSound varchar(36) not null default '00000000-0000-0000-0000-000000000000';
396ALTER TABLE prims ADD LoopedSoundGain float not null default 0.0;
397ALTER TABLE prims ADD TextureAnimation image
398ALTER TABLE prims ADD OmegaX float not null default 0.0
399ALTER TABLE prims ADD OmegaY float not null default 0.0
400ALTER TABLE prims ADD OmegaZ float not null default 0.0
401ALTER TABLE prims ADD CameraEyeOffsetX float not null default 0.0
402ALTER TABLE prims ADD CameraEyeOffsetY float not null default 0.0
403ALTER TABLE prims ADD CameraEyeOffsetZ float not null default 0.0
404ALTER TABLE prims ADD CameraAtOffsetX float not null default 0.0
405ALTER TABLE prims ADD CameraAtOffsetY float not null default 0.0
406ALTER TABLE prims ADD CameraAtOffsetZ float not null default 0.0
407ALTER TABLE prims ADD ForceMouselook tinyint not null default 0
408ALTER TABLE prims ADD ScriptAccessPin int not null default 0
409ALTER TABLE prims ADD AllowedDrop tinyint not null default 0
410ALTER TABLE prims ADD DieAtEdge tinyint not null default 0
411ALTER TABLE prims ADD SalePrice int not null default 10
412ALTER TABLE prims ADD SaleType tinyint not null default 0
413
414ALTER TABLE primitems add flags integer not null default 0
415
416ALTER TABLE land ADD AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'
417
418CREATE index prims_regionuuid on prims(RegionUUID)
419CREATE index prims_parentid on prims(ParentID)
420
421CREATE index primitems_primid on primitems(primID)
422
423COMMIT
424
425
426:VERSION 7
427
428BEGIN TRANSACTION
429
430ALTER TABLE prims ADD ColorR int not null default 0;
431ALTER TABLE prims ADD ColorG int not null default 0;
432ALTER TABLE prims ADD ColorB int not null default 0;
433ALTER TABLE prims ADD ColorA int not null default 0;
434ALTER TABLE prims ADD ParticleSystem IMAGE;
435ALTER TABLE prims ADD ClickAction tinyint NOT NULL default 0;
436
437COMMIT
438
439
440:VERSION 8
441
442BEGIN TRANSACTION
443
444ALTER TABLE land ADD OtherCleanTime integer NOT NULL default 0;
445ALTER TABLE land ADD Dwell integer NOT NULL default 0;
446
447COMMIT
448
449:VERSION 9
450
451BEGIN TRANSACTION
452
453ALTER TABLE prims ADD Material tinyint NOT NULL default 3
454
455COMMIT
456
457
458:VERSION 10
459
460BEGIN TRANSACTION
461
462ALTER TABLE regionsettings ADD sunvectorx float NOT NULL default 0;
463ALTER TABLE regionsettings ADD sunvectory float NOT NULL default 0;
464ALTER TABLE regionsettings ADD sunvectorz float NOT NULL default 0;
465
466COMMIT
467
468
469:VERSION 11
470
471BEGIN TRANSACTION
472
473ALTER TABLE prims ADD CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'
474ALTER TABLE prims ADD CollisionSoundVolume float not null default 0.0
475
476COMMIT
477
478
479:VERSION 12
480
481BEGIN TRANSACTION
482
483ALTER TABLE prims ADD LinkNumber integer not null default 0
484
485COMMIT
486
487
488:VERSION 13
489
490BEGIN TRANSACTION
491
492CREATE TABLE dbo.Tmp_prims
493 (
494 UUID uniqueidentifier NOT NULL,
495 RegionUUID uniqueidentifier NULL,
496 ParentID int NULL,
497 CreationDate int NULL,
498 Name varchar(255) NULL,
499 SceneGroupID uniqueidentifier NULL,
500 Text varchar(255) NULL,
501 Description varchar(255) NULL,
502 SitName varchar(255) NULL,
503 TouchName varchar(255) NULL,
504 ObjectFlags int NULL,
505 CreatorID uniqueidentifier NULL,
506 OwnerID uniqueidentifier NULL,
507 GroupID uniqueidentifier NULL,
508 LastOwnerID uniqueidentifier NULL,
509 OwnerMask int NULL,
510 NextOwnerMask int NULL,
511 GroupMask int NULL,
512 EveryoneMask int NULL,
513 BaseMask int NULL,
514 PositionX float(53) NULL,
515 PositionY float(53) NULL,
516 PositionZ float(53) NULL,
517 GroupPositionX float(53) NULL,
518 GroupPositionY float(53) NULL,
519 GroupPositionZ float(53) NULL,
520 VelocityX float(53) NULL,
521 VelocityY float(53) NULL,
522 VelocityZ float(53) NULL,
523 AngularVelocityX float(53) NULL,
524 AngularVelocityY float(53) NULL,
525 AngularVelocityZ float(53) NULL,
526 AccelerationX float(53) NULL,
527 AccelerationY float(53) NULL,
528 AccelerationZ float(53) NULL,
529 RotationX float(53) NULL,
530 RotationY float(53) NULL,
531 RotationZ float(53) NULL,
532 RotationW float(53) NULL,
533 SitTargetOffsetX float(53) NULL,
534 SitTargetOffsetY float(53) NULL,
535 SitTargetOffsetZ float(53) NULL,
536 SitTargetOrientW float(53) NULL,
537 SitTargetOrientX float(53) NULL,
538 SitTargetOrientY float(53) NULL,
539 SitTargetOrientZ float(53) NULL,
540 PayPrice int NOT NULL DEFAULT ((0)),
541 PayButton1 int NOT NULL DEFAULT ((0)),
542 PayButton2 int NOT NULL DEFAULT ((0)),
543 PayButton3 int NOT NULL DEFAULT ((0)),
544 PayButton4 int NOT NULL DEFAULT ((0)),
545 LoopedSound uniqueidentifier NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
546 LoopedSoundGain float(53) NOT NULL DEFAULT ((0.0)),
547 TextureAnimation image NULL,
548 OmegaX float(53) NOT NULL DEFAULT ((0.0)),
549 OmegaY float(53) NOT NULL DEFAULT ((0.0)),
550 OmegaZ float(53) NOT NULL DEFAULT ((0.0)),
551 CameraEyeOffsetX float(53) NOT NULL DEFAULT ((0.0)),
552 CameraEyeOffsetY float(53) NOT NULL DEFAULT ((0.0)),
553 CameraEyeOffsetZ float(53) NOT NULL DEFAULT ((0.0)),
554 CameraAtOffsetX float(53) NOT NULL DEFAULT ((0.0)),
555 CameraAtOffsetY float(53) NOT NULL DEFAULT ((0.0)),
556 CameraAtOffsetZ float(53) NOT NULL DEFAULT ((0.0)),
557 ForceMouselook tinyint NOT NULL DEFAULT ((0)),
558 ScriptAccessPin int NOT NULL DEFAULT ((0)),
559 AllowedDrop tinyint NOT NULL DEFAULT ((0)),
560 DieAtEdge tinyint NOT NULL DEFAULT ((0)),
561 SalePrice int NOT NULL DEFAULT ((10)),
562 SaleType tinyint NOT NULL DEFAULT ((0)),
563 ColorR int NOT NULL DEFAULT ((0)),
564 ColorG int NOT NULL DEFAULT ((0)),
565 ColorB int NOT NULL DEFAULT ((0)),
566 ColorA int NOT NULL DEFAULT ((0)),
567 ParticleSystem image NULL,
568 ClickAction tinyint NOT NULL DEFAULT ((0)),
569 Material tinyint NOT NULL DEFAULT ((3)),
570 CollisionSound uniqueidentifier NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
571 CollisionSoundVolume float(53) NOT NULL DEFAULT ((0.0)),
572 LinkNumber int NOT NULL DEFAULT ((0))
573 ) ON [PRIMARY]
574 TEXTIMAGE_ON [PRIMARY]
575
576IF EXISTS(SELECT * FROM dbo.prims)
577 EXEC('INSERT INTO dbo.Tmp_prims (UUID, RegionUUID, ParentID, CreationDate, Name, SceneGroupID, Text, Description, SitName, TouchName, ObjectFlags, 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, SitTargetOffsetX, SitTargetOffsetY, SitTargetOffsetZ, SitTargetOrientW, SitTargetOrientX, SitTargetOrientY, SitTargetOrientZ, PayPrice, PayButton1, PayButton2, PayButton3, PayButton4, LoopedSound, LoopedSoundGain, TextureAnimation, OmegaX, OmegaY, OmegaZ, CameraEyeOffsetX, CameraEyeOffsetY, CameraEyeOffsetZ, CameraAtOffsetX, CameraAtOffsetY, CameraAtOffsetZ, ForceMouselook, ScriptAccessPin, AllowedDrop, DieAtEdge, SalePrice, SaleType, ColorR, ColorG, ColorB, ColorA, ParticleSystem, ClickAction, Material, CollisionSound, CollisionSoundVolume, LinkNumber)
578 SELECT CONVERT(uniqueidentifier, UUID), CONVERT(uniqueidentifier, RegionUUID), ParentID, CreationDate, Name, CONVERT(uniqueidentifier, SceneGroupID), Text, Description, SitName, TouchName, ObjectFlags, CONVERT(uniqueidentifier, CreatorID), CONVERT(uniqueidentifier, OwnerID), CONVERT(uniqueidentifier, GroupID), CONVERT(uniqueidentifier, 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, SitTargetOffsetX, SitTargetOffsetY, SitTargetOffsetZ, SitTargetOrientW, SitTargetOrientX, SitTargetOrientY, SitTargetOrientZ, PayPrice, PayButton1, PayButton2, PayButton3, PayButton4, CONVERT(uniqueidentifier, LoopedSound), LoopedSoundGain, TextureAnimation, OmegaX, OmegaY, OmegaZ, CameraEyeOffsetX, CameraEyeOffsetY, CameraEyeOffsetZ, CameraAtOffsetX, CameraAtOffsetY, CameraAtOffsetZ, ForceMouselook, ScriptAccessPin, AllowedDrop, DieAtEdge, SalePrice, SaleType, ColorR, ColorG, ColorB, ColorA, ParticleSystem, ClickAction, Material, CONVERT(uniqueidentifier, CollisionSound), CollisionSoundVolume, LinkNumber FROM dbo.prims WITH (HOLDLOCK TABLOCKX)')
579
580DROP TABLE dbo.prims
581
582EXECUTE sp_rename N'dbo.Tmp_prims', N'prims', 'OBJECT'
583
584ALTER TABLE dbo.prims ADD CONSTRAINT
585 PK__prims__10566F31 PRIMARY KEY CLUSTERED
586 (
587 UUID
588 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
589
590
591CREATE NONCLUSTERED INDEX prims_regionuuid ON dbo.prims
592 (
593 RegionUUID
594 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
595
596CREATE NONCLUSTERED INDEX prims_parentid ON dbo.prims
597 (
598 ParentID
599 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
600
601COMMIT
602
603
604:VERSION 14
605
606BEGIN TRANSACTION
607
608CREATE TABLE dbo.Tmp_primshapes
609 (
610 UUID uniqueidentifier NOT NULL,
611 Shape int NULL,
612 ScaleX float(53) NULL,
613 ScaleY float(53) NULL,
614 ScaleZ float(53) NULL,
615 PCode int NULL,
616 PathBegin int NULL,
617 PathEnd int NULL,
618 PathScaleX int NULL,
619 PathScaleY int NULL,
620 PathShearX int NULL,
621 PathShearY int NULL,
622 PathSkew int NULL,
623 PathCurve int NULL,
624 PathRadiusOffset int NULL,
625 PathRevolutions int NULL,
626 PathTaperX int NULL,
627 PathTaperY int NULL,
628 PathTwist int NULL,
629 PathTwistBegin int NULL,
630 ProfileBegin int NULL,
631 ProfileEnd int NULL,
632 ProfileCurve int NULL,
633 ProfileHollow int NULL,
634 State int NULL,
635 Texture image NULL,
636 ExtraParams image NULL
637 ) ON [PRIMARY]
638 TEXTIMAGE_ON [PRIMARY]
639
640IF EXISTS(SELECT * FROM dbo.primshapes)
641 EXEC('INSERT INTO dbo.Tmp_primshapes (UUID, Shape, ScaleX, ScaleY, ScaleZ, PCode, PathBegin, PathEnd, PathScaleX, PathScaleY, PathShearX, PathShearY, PathSkew, PathCurve, PathRadiusOffset, PathRevolutions, PathTaperX, PathTaperY, PathTwist, PathTwistBegin, ProfileBegin, ProfileEnd, ProfileCurve, ProfileHollow, State, Texture, ExtraParams)
642 SELECT CONVERT(uniqueidentifier, UUID), Shape, ScaleX, ScaleY, ScaleZ, PCode, PathBegin, PathEnd, PathScaleX, PathScaleY, PathShearX, PathShearY, PathSkew, PathCurve, PathRadiusOffset, PathRevolutions, PathTaperX, PathTaperY, PathTwist, PathTwistBegin, ProfileBegin, ProfileEnd, ProfileCurve, ProfileHollow, State, Texture, ExtraParams FROM dbo.primshapes WITH (HOLDLOCK TABLOCKX)')
643
644DROP TABLE dbo.primshapes
645
646EXECUTE sp_rename N'dbo.Tmp_primshapes', N'primshapes', 'OBJECT'
647
648ALTER TABLE dbo.primshapes ADD CONSTRAINT
649 PK__primshapes__0880433F PRIMARY KEY CLUSTERED
650 (
651 UUID
652 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
653
654COMMIT
655
656
657:VERSION 15
658
659BEGIN TRANSACTION
660
661CREATE TABLE dbo.Tmp_primitems
662 (
663 itemID uniqueidentifier NOT NULL,
664 primID uniqueidentifier NULL,
665 assetID uniqueidentifier NULL,
666 parentFolderID uniqueidentifier NULL,
667 invType int NULL,
668 assetType int NULL,
669 name varchar(255) NULL,
670 description varchar(255) NULL,
671 creationDate varchar(255) NULL,
672 creatorID uniqueidentifier NULL,
673 ownerID uniqueidentifier NULL,
674 lastOwnerID uniqueidentifier NULL,
675 groupID uniqueidentifier NULL,
676 nextPermissions int NULL,
677 currentPermissions int NULL,
678 basePermissions int NULL,
679 everyonePermissions int NULL,
680 groupPermissions int NULL,
681 flags int NOT NULL DEFAULT ((0))
682 ) ON [PRIMARY]
683
684IF EXISTS(SELECT * FROM dbo.primitems)
685 EXEC('INSERT INTO dbo.Tmp_primitems (itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate, creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions, flags)
686 SELECT CONVERT(uniqueidentifier, itemID), CONVERT(uniqueidentifier, primID), CONVERT(uniqueidentifier, assetID), CONVERT(uniqueidentifier, parentFolderID), invType, assetType, name, description, creationDate, CONVERT(uniqueidentifier, creatorID), CONVERT(uniqueidentifier, ownerID), CONVERT(uniqueidentifier, lastOwnerID), CONVERT(uniqueidentifier, groupID), nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions, flags FROM dbo.primitems WITH (HOLDLOCK TABLOCKX)')
687
688DROP TABLE dbo.primitems
689
690EXECUTE sp_rename N'dbo.Tmp_primitems', N'primitems', 'OBJECT'
691
692ALTER TABLE dbo.primitems ADD CONSTRAINT
693 PK__primitems__0A688BB1 PRIMARY KEY CLUSTERED
694 (
695 itemID
696 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
697
698CREATE NONCLUSTERED INDEX primitems_primid ON dbo.primitems
699 (
700 primID
701 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
702
703COMMIT
704
705
706:VERSION 16
707
708
709BEGIN TRANSACTION
710
711CREATE TABLE dbo.Tmp_terrain
712 (
713 RegionUUID uniqueidentifier NULL,
714 Revision int NULL,
715 Heightfield image NULL
716 ) ON [PRIMARY]
717 TEXTIMAGE_ON [PRIMARY]
718
719IF EXISTS(SELECT * FROM dbo.terrain)
720 EXEC('INSERT INTO dbo.Tmp_terrain (RegionUUID, Revision, Heightfield)
721 SELECT CONVERT(uniqueidentifier, RegionUUID), Revision, Heightfield FROM dbo.terrain WITH (HOLDLOCK TABLOCKX)')
722
723DROP TABLE dbo.terrain
724
725EXECUTE sp_rename N'dbo.Tmp_terrain', N'terrain', 'OBJECT'
726
727COMMIT
728
729
730:VERSION 17
731
732BEGIN TRANSACTION
733
734CREATE TABLE dbo.Tmp_land
735 (
736 UUID uniqueidentifier NOT NULL,
737 RegionUUID uniqueidentifier NULL,
738 LocalLandID int NULL,
739 Bitmap image NULL,
740 Name varchar(255) NULL,
741 Description varchar(255) NULL,
742 OwnerUUID uniqueidentifier NULL,
743 IsGroupOwned int NULL,
744 Area int NULL,
745 AuctionID int NULL,
746 Category int NULL,
747 ClaimDate int NULL,
748 ClaimPrice int NULL,
749 GroupUUID uniqueidentifier NULL,
750 SalePrice int NULL,
751 LandStatus int NULL,
752 LandFlags int NULL,
753 LandingType int NULL,
754 MediaAutoScale int NULL,
755 MediaTextureUUID uniqueidentifier NULL,
756 MediaURL varchar(255) NULL,
757 MusicURL varchar(255) NULL,
758 PassHours float(53) NULL,
759 PassPrice int NULL,
760 SnapshotUUID uniqueidentifier NULL,
761 UserLocationX float(53) NULL,
762 UserLocationY float(53) NULL,
763 UserLocationZ float(53) NULL,
764 UserLookAtX float(53) NULL,
765 UserLookAtY float(53) NULL,
766 UserLookAtZ float(53) NULL,
767 AuthbuyerID uniqueidentifier NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
768 OtherCleanTime int NOT NULL DEFAULT ((0)),
769 Dwell int NOT NULL DEFAULT ((0))
770 ) ON [PRIMARY]
771 TEXTIMAGE_ON [PRIMARY]
772
773IF EXISTS(SELECT * FROM dbo.land)
774 EXEC('INSERT INTO dbo.Tmp_land (UUID, RegionUUID, LocalLandID, Bitmap, Name, Description, OwnerUUID, IsGroupOwned, Area, AuctionID, Category, ClaimDate, ClaimPrice, GroupUUID, SalePrice, LandStatus, LandFlags, LandingType, MediaAutoScale, MediaTextureUUID, MediaURL, MusicURL, PassHours, PassPrice, SnapshotUUID, UserLocationX, UserLocationY, UserLocationZ, UserLookAtX, UserLookAtY, UserLookAtZ, AuthbuyerID, OtherCleanTime, Dwell)
775 SELECT CONVERT(uniqueidentifier, UUID), CONVERT(uniqueidentifier, RegionUUID), LocalLandID, Bitmap, Name, Description, CONVERT(uniqueidentifier, OwnerUUID), IsGroupOwned, Area, AuctionID, Category, ClaimDate, ClaimPrice, CONVERT(uniqueidentifier, GroupUUID), SalePrice, LandStatus, LandFlags, LandingType, MediaAutoScale, CONVERT(uniqueidentifier, MediaTextureUUID), MediaURL, MusicURL, PassHours, PassPrice, CONVERT(uniqueidentifier, SnapshotUUID), UserLocationX, UserLocationY, UserLocationZ, UserLookAtX, UserLookAtY, UserLookAtZ, CONVERT(uniqueidentifier, AuthbuyerID), OtherCleanTime, Dwell FROM dbo.land WITH (HOLDLOCK TABLOCKX)')
776
777DROP TABLE dbo.land
778
779EXECUTE sp_rename N'dbo.Tmp_land', N'land', 'OBJECT'
780
781ALTER TABLE dbo.land ADD CONSTRAINT
782 PK__land__65A475E71BFD2C07 PRIMARY KEY CLUSTERED
783 (
784 UUID
785 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
786
787COMMIT
788
789
790
791:VERSION 18
792
793BEGIN TRANSACTION
794
795CREATE TABLE dbo.Tmp_landaccesslist
796 (
797 LandUUID uniqueidentifier NULL,
798 AccessUUID uniqueidentifier NULL,
799 Flags int NULL
800 ) ON [PRIMARY]
801
802IF EXISTS(SELECT * FROM dbo.landaccesslist)
803 EXEC('INSERT INTO dbo.Tmp_landaccesslist (LandUUID, AccessUUID, Flags)
804 SELECT CONVERT(uniqueidentifier, LandUUID), CONVERT(uniqueidentifier, AccessUUID), Flags FROM dbo.landaccesslist WITH (HOLDLOCK TABLOCKX)')
805
806DROP TABLE dbo.landaccesslist
807
808EXECUTE sp_rename N'dbo.Tmp_landaccesslist', N'landaccesslist', 'OBJECT'
809
810COMMIT
811
812
813
814:VERSION 19
815
816BEGIN TRANSACTION
817
818CREATE TABLE dbo.Tmp_regionban
819 (
820 regionUUID uniqueidentifier NOT NULL,
821 bannedUUID uniqueidentifier NOT NULL,
822 bannedIp varchar(16) NOT NULL,
823 bannedIpHostMask varchar(16) NOT NULL
824 ) ON [PRIMARY]
825
826IF EXISTS(SELECT * FROM dbo.regionban)
827 EXEC('INSERT INTO dbo.Tmp_regionban (regionUUID, bannedUUID, bannedIp, bannedIpHostMask)
828 SELECT CONVERT(uniqueidentifier, regionUUID), CONVERT(uniqueidentifier, bannedUUID), bannedIp, bannedIpHostMask FROM dbo.regionban WITH (HOLDLOCK TABLOCKX)')
829
830DROP TABLE dbo.regionban
831
832EXECUTE sp_rename N'dbo.Tmp_regionban', N'regionban', 'OBJECT'
833
834COMMIT
835
836
837:VERSION 20
838
839BEGIN TRANSACTION
840
841CREATE TABLE dbo.Tmp_regionsettings
842 (
843 regionUUID uniqueidentifier NOT NULL,
844 block_terraform bit NOT NULL,
845 block_fly bit NOT NULL,
846 allow_damage bit NOT NULL,
847 restrict_pushing bit NOT NULL,
848 allow_land_resell bit NOT NULL,
849 allow_land_join_divide bit NOT NULL,
850 block_show_in_search bit NOT NULL,
851 agent_limit int NOT NULL,
852 object_bonus float(53) NOT NULL,
853 maturity int NOT NULL,
854 disable_scripts bit NOT NULL,
855 disable_collisions bit NOT NULL,
856 disable_physics bit NOT NULL,
857 terrain_texture_1 uniqueidentifier NOT NULL,
858 terrain_texture_2 uniqueidentifier NOT NULL,
859 terrain_texture_3 uniqueidentifier NOT NULL,
860 terrain_texture_4 uniqueidentifier NOT NULL,
861 elevation_1_nw float(53) NOT NULL,
862 elevation_2_nw float(53) NOT NULL,
863 elevation_1_ne float(53) NOT NULL,
864 elevation_2_ne float(53) NOT NULL,
865 elevation_1_se float(53) NOT NULL,
866 elevation_2_se float(53) NOT NULL,
867 elevation_1_sw float(53) NOT NULL,
868 elevation_2_sw float(53) NOT NULL,
869 water_height float(53) NOT NULL,
870 terrain_raise_limit float(53) NOT NULL,
871 terrain_lower_limit float(53) NOT NULL,
872 use_estate_sun bit NOT NULL,
873 fixed_sun bit NOT NULL,
874 sun_position float(53) NOT NULL,
875 covenant uniqueidentifier NULL DEFAULT (NULL),
876 Sandbox bit NOT NULL,
877 sunvectorx float(53) NOT NULL DEFAULT ((0)),
878 sunvectory float(53) NOT NULL DEFAULT ((0)),
879 sunvectorz float(53) NOT NULL DEFAULT ((0))
880 ) ON [PRIMARY]
881
882IF EXISTS(SELECT * FROM dbo.regionsettings)
883 EXEC('INSERT INTO dbo.Tmp_regionsettings (regionUUID, block_terraform, block_fly, allow_damage, restrict_pushing, allow_land_resell, allow_land_join_divide, block_show_in_search, agent_limit, object_bonus, maturity, disable_scripts, disable_collisions, disable_physics, terrain_texture_1, terrain_texture_2, terrain_texture_3, terrain_texture_4, elevation_1_nw, elevation_2_nw, elevation_1_ne, elevation_2_ne, elevation_1_se, elevation_2_se, elevation_1_sw, elevation_2_sw, water_height, terrain_raise_limit, terrain_lower_limit, use_estate_sun, fixed_sun, sun_position, covenant, Sandbox, sunvectorx, sunvectory, sunvectorz)
884 SELECT CONVERT(uniqueidentifier, regionUUID), block_terraform, block_fly, allow_damage, restrict_pushing, allow_land_resell, allow_land_join_divide, block_show_in_search, agent_limit, object_bonus, maturity, disable_scripts, disable_collisions, disable_physics, CONVERT(uniqueidentifier, terrain_texture_1), CONVERT(uniqueidentifier, terrain_texture_2), CONVERT(uniqueidentifier, terrain_texture_3), CONVERT(uniqueidentifier, terrain_texture_4), elevation_1_nw, elevation_2_nw, elevation_1_ne, elevation_2_ne, elevation_1_se, elevation_2_se, elevation_1_sw, elevation_2_sw, water_height, terrain_raise_limit, terrain_lower_limit, use_estate_sun, fixed_sun, sun_position, CONVERT(uniqueidentifier, covenant), Sandbox, sunvectorx, sunvectory, sunvectorz FROM dbo.regionsettings WITH (HOLDLOCK TABLOCKX)')
885
886DROP TABLE dbo.regionsettings
887
888EXECUTE sp_rename N'dbo.Tmp_regionsettings', N'regionsettings', 'OBJECT'
889
890ALTER TABLE dbo.regionsettings ADD CONSTRAINT
891 PK__regionse__5B35159D21B6055D PRIMARY KEY CLUSTERED
892 (
893 regionUUID
894 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
895
896COMMIT
897
898
899:VERSION 21
900
901BEGIN TRANSACTION
902
903ALTER TABLE prims ADD PassTouches bit not null default 0
904
905COMMIT
906
907
908:VERSION 22
909
910BEGIN TRANSACTION
911
912ALTER TABLE regionsettings ADD loaded_creation_date varchar(20)
913ALTER TABLE regionsettings ADD loaded_creation_time varchar(20)
914ALTER TABLE regionsettings ADD loaded_creation_id varchar(64)
915
916COMMIT
917
918:VERSION 23
919
920BEGIN TRANSACTION
921
922ALTER TABLE regionsettings DROP COLUMN loaded_creation_date
923ALTER TABLE regionsettings DROP COLUMN loaded_creation_time
924ALTER TABLE regionsettings ADD loaded_creation_datetime int NOT NULL default 0
925
926COMMIT
927
928
929
generated by cgit v1.1 at 2024-11-09 01:42:22 +0000