WebSVN – opensim-development – Blame – Rev 1 – /OpenSim/Data/MySQL/Resources/RegionStore.migrations

  CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';

172

COMMIT;

173

174

:VERSION 4 #---------------------

BEGIN;

ALTER TABLE primitems add flags integer not null default 0;

COMMIT;

:VERSION 5 #---------------------

183

BEGIN;

184

185

create table regionsettings (

186

regionUUID char(36) not null,

187

block_terraform integer not null,

188

block_fly integer not null,

189

allow_damage integer not null,

190

restrict_pushing integer not null,

191

allow_land_resell integer not null,

192

allow_land_join_divide integer not null,

193

block_show_in_search integer not null,

194

agent_limit integer not null,

195

object_bonus float not null,

196

maturity integer not null,

197

disable_scripts integer not null,

198

disable_collisions integer not null,

199

disable_physics integer not null,

200

terrain_texture_1 char(36) not null,

201

terrain_texture_2 char(36) not null,

202

terrain_texture_3 char(36) not null,

203

terrain_texture_4 char(36) not null,

204

elevation_1_nw float not null,

205

elevation_2_nw float not null,

206

elevation_1_ne float not null,

207

elevation_2_ne float not null,

208

elevation_1_se float not null,

209

elevation_2_se float not null,

210

elevation_1_sw float not null,

211

elevation_2_sw float not null,

212

water_height float not null,

213

terrain_raise_limit float not null,

214

terrain_lower_limit float not null,

215

use_estate_sun integer not null,

216

fixed_sun integer not null,

217

sun_position float not null,

218

covenant char(36),

219

primary key(regionUUID)

);

COMMIT;

:VERSION 6 #---------------------

BEGIN;

alter table landaccesslist ENGINE = InnoDB;

230

alter table migrations ENGINE = InnoDB;

231

alter table primitems ENGINE = InnoDB;

232

alter table prims ENGINE = InnoDB;

233

alter table primshapes ENGINE = InnoDB;

234

alter table regionsettings ENGINE = InnoDB;

235

alter table terrain ENGINE = InnoDB;

COMMIT;

:VERSION 7 #---------------------

BEGIN;

ALTER TABLE prims change UUID UUIDold varchar(255);

244

ALTER TABLE prims change RegionUUID RegionUUIDold varchar(255);

245

ALTER TABLE prims change CreatorID CreatorIDold varchar(255);

246

ALTER TABLE prims change OwnerID OwnerIDold varchar(255);

247

ALTER TABLE prims change GroupID GroupIDold varchar(255);

248

ALTER TABLE prims change LastOwnerID LastOwnerIDold varchar(255);

249

ALTER TABLE prims add UUID char(36);

250

ALTER TABLE prims add RegionUUID char(36);

251

ALTER TABLE prims add CreatorID char(36);

252

ALTER TABLE prims add OwnerID char(36);

253

ALTER TABLE prims add GroupID char(36);

254

ALTER TABLE prims add LastOwnerID char(36);

255

UPDATE prims set UUID = UUIDold, RegionUUID = RegionUUIDold, CreatorID = CreatorIDold, OwnerID = OwnerIDold, GroupID = GroupIDold, LastOwnerID = LastOwnerIDold;

256

ALTER TABLE prims drop UUIDold;

257

ALTER TABLE prims drop RegionUUIDold;

258

ALTER TABLE prims drop CreatorIDold;

259

ALTER TABLE prims drop OwnerIDold;

260

ALTER TABLE prims drop GroupIDold;

261

ALTER TABLE prims drop LastOwnerIDold;

262

ALTER TABLE prims add constraint primary key(UUID);

263

ALTER TABLE prims add index prims_regionuuid(RegionUUID);

COMMIT;

:VERSION 8 #---------------------

BEGIN;

ALTER TABLE primshapes change UUID UUIDold varchar(255);

272

ALTER TABLE primshapes add UUID char(36);

273

UPDATE primshapes set UUID = UUIDold;

274

ALTER TABLE primshapes drop UUIDold;

275

ALTER TABLE primshapes add constraint primary key(UUID);

COMMIT;

:VERSION 9 #---------------------

BEGIN;

ALTER TABLE primitems change itemID itemIDold varchar(255);

284

ALTER TABLE primitems change primID primIDold varchar(255);

285

ALTER TABLE primitems change assetID assetIDold varchar(255);

286

ALTER TABLE primitems change parentFolderID parentFolderIDold varchar(255);

287

ALTER TABLE primitems change creatorID creatorIDold varchar(255);

288

ALTER TABLE primitems change ownerID ownerIDold varchar(255);

289

ALTER TABLE primitems change groupID groupIDold varchar(255);

290

ALTER TABLE primitems change lastOwnerID lastOwnerIDold varchar(255);

291

ALTER TABLE primitems add itemID char(36);

292

ALTER TABLE primitems add primID char(36);

293

ALTER TABLE primitems add assetID char(36);

294

ALTER TABLE primitems add parentFolderID char(36);

295

ALTER TABLE primitems add creatorID char(36);

296

ALTER TABLE primitems add ownerID char(36);

297

ALTER TABLE primitems add groupID char(36);

298

ALTER TABLE primitems add lastOwnerID char(36);

299

UPDATE primitems set itemID = itemIDold, primID = primIDold, assetID = assetIDold, parentFolderID = parentFolderIDold, creatorID = creatorIDold, ownerID = ownerIDold, groupID = groupIDold, lastOwnerID = lastOwnerIDold;

300

ALTER TABLE primitems drop itemIDold;

301

ALTER TABLE primitems drop primIDold;

302

ALTER TABLE primitems drop assetIDold;

303

ALTER TABLE primitems drop parentFolderIDold;

304

ALTER TABLE primitems drop creatorIDold;

305

ALTER TABLE primitems drop ownerIDold;

306

ALTER TABLE primitems drop groupIDold;

307

ALTER TABLE primitems drop lastOwnerIDold;

308

ALTER TABLE primitems add constraint primary key(itemID);

309

ALTER TABLE primitems add index primitems_primid(primID);

COMMIT;

:VERSION 10 #---------------------

314

315

# 1 "010_RegionStore.sql"

316

# 1 "<built-in>"

317

# 1 "<command line>"

318

# 1 "010_RegionStore.sql"

319

BEGIN;

320

321

DELETE FROM regionsettings;

COMMIT;

:VERSION 11 #---------------------

BEGIN;

ALTER TABLE prims change SceneGroupID SceneGroupIDold varchar(255);

331

ALTER TABLE prims add SceneGroupID char(36);

332

UPDATE prims set SceneGroupID = SceneGroupIDold;

333

ALTER TABLE prims drop SceneGroupIDold;

334

ALTER TABLE prims add index prims_scenegroupid(SceneGroupID);

COMMIT;

:VERSION 12 #---------------------

BEGIN;

ALTER TABLE prims add index prims_parentid(ParentID);

COMMIT;

:VERSION 13 #---------------------

347

begin;

348

349

drop table regionsettings;

350

351

CREATE TABLE `regionsettings` (

352

`regionUUID` char(36) NOT NULL,

353

`block_terraform` int(11) NOT NULL,

354

`block_fly` int(11) NOT NULL,

355

`allow_damage` int(11) NOT NULL,

356

`restrict_pushing` int(11) NOT NULL,

357

`allow_land_resell` int(11) NOT NULL,

358

`allow_land_join_divide` int(11) NOT NULL,

359

`block_show_in_search` int(11) NOT NULL,

360

`agent_limit` int(11) NOT NULL,

361

`object_bonus` float NOT NULL,

362

`maturity` int(11) NOT NULL,

363

`disable_scripts` int(11) NOT NULL,

364

`disable_collisions` int(11) NOT NULL,

365

`disable_physics` int(11) NOT NULL,

366

`terrain_texture_1` char(36) NOT NULL,

367

`terrain_texture_2` char(36) NOT NULL,

368

`terrain_texture_3` char(36) NOT NULL,

369

`terrain_texture_4` char(36) NOT NULL,

370

`elevation_1_nw` float NOT NULL,

371

`elevation_2_nw` float NOT NULL,

372

`elevation_1_ne` float NOT NULL,

373

`elevation_2_ne` float NOT NULL,

374

`elevation_1_se` float NOT NULL,

375

`elevation_2_se` float NOT NULL,

376

`elevation_1_sw` float NOT NULL,

377

`elevation_2_sw` float NOT NULL,

378

`water_height` float NOT NULL,

379

`terrain_raise_limit` float NOT NULL,

380

`terrain_lower_limit` float NOT NULL,

381

`use_estate_sun` int(11) NOT NULL,

382

`fixed_sun` int(11) NOT NULL,

383

`sun_position` float NOT NULL,

384

`covenant` char(36) default NULL,

385

`Sandbox` tinyint(4) NOT NULL,

386

PRIMARY KEY (`regionUUID`)

) ENGINE=InnoDB;

commit;

:VERSION 16 #---------------------

BEGIN;

ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0;

396

ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0;

397

ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0;

398

ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0;

399

ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0;

400

ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000';

401

ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0;

402

ALTER TABLE prims ADD COLUMN TextureAnimation blob;

403

ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0;

404

ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0;

405

ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0;

406

ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0;

407

ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0;

408

ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0;

409

ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0;

410

ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0;

411

ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0;

412

ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0;

413

ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0;

414

ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0;

415

ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0;

416

ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10;

417

ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0;

COMMIT;

:VERSION 17 #---------------------

BEGIN;

ALTER TABLE prims ADD COLUMN ColorR integer not null default 0;

427

ALTER TABLE prims ADD COLUMN ColorG integer not null default 0;

428

ALTER TABLE prims ADD COLUMN ColorB integer not null default 0;

429

ALTER TABLE prims ADD COLUMN ColorA integer not null default 0;

430

ALTER TABLE prims ADD COLUMN ParticleSystem blob;

COMMIT;

:VERSION 18 #---------------------

begin;

ALTER TABLE prims ADD COLUMN ClickAction tinyint NOT NULL default 0;

commit;

:VERSION 19 #---------------------

begin;

ALTER TABLE prims ADD COLUMN Material tinyint NOT NULL default 3;

commit;

:VERSION 20 #---------------------

begin;

ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0;

457

ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0;

commit;

:VERSION 21 #---------------------

begin;

ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0;

466

ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0;

467

ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0;

commit;

:VERSION 22 #---------------------

BEGIN;

ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000';

477

ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0;

COMMIT;

:VERSION 23 #---------------------

BEGIN;

ALTER TABLE prims ADD COLUMN LinkNumber integer not null default 0;

COMMIT;

:VERSION 24 #---------------------

BEGIN;

alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL;

494

alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL;

495

alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL;

496

alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL;

497

alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL;

498

alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL;

499

alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL;

500

alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL;

501

alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL;

502

alter table regionsettings change column `water_height` `water_height` double NOT NULL;

503

alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL;

504

alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL;

505

alter table regionsettings change column `sun_position` `sun_position` double NOT NULL;

COMMIT;

:VERSION 25 #---------------------

BEGIN;

alter table prims change column `PositionX` `PositionX` double default NULL;

515

alter table prims change column `PositionY` `PositionY` double default NULL;

516

alter table prims change column `PositionZ` `PositionZ` double default NULL;

517

alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL;

518

alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL;

519

alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL;

520

alter table prims change column `VelocityX` `VelocityX` double default NULL;

521

alter table prims change column `VelocityY` `VelocityY` double default NULL;

522

alter table prims change column `VelocityZ` `VelocityZ` double default NULL;

523

alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL;

524

alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL;

525

alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL;

526

alter table prims change column `AccelerationX` `AccelerationX` double default NULL;

527

alter table prims change column `AccelerationY` `AccelerationY` double default NULL;

528

alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL;

529

alter table prims change column `RotationX` `RotationX` double default NULL;

530

alter table prims change column `RotationY` `RotationY` double default NULL;

531

alter table prims change column `RotationZ` `RotationZ` double default NULL;

532

alter table prims change column `RotationW` `RotationW` double default NULL;

533

alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL;

534

alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL;

535

alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL;

536

alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL;

537

alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL;

538

alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL;

539

alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL;

540

alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0';

541

alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0';

542

alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0';

543

alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0';

544

alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0';

545

alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0';

546

alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0';

547

alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0';

548

alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0';

549

alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0';

550

alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0';

551

552

alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0';

553

alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0';

554

alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0';

COMMIT;

:VERSION 26 #---------------------

begin;

alter table prims change column `PositionX` `PositionX` double default NULL;

563

alter table prims change column `PositionY` `PositionY` double default NULL;

564

alter table prims change column `PositionZ` `PositionZ` double default NULL;

565

alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL;

566

alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL;

567

alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL;

568

alter table prims change column `VelocityX` `VelocityX` double default NULL;

569

alter table prims change column `VelocityY` `VelocityY` double default NULL;

570

alter table prims change column `VelocityZ` `VelocityZ` double default NULL;

571

alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL;

572

alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL;

573

alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL;

574

alter table prims change column `AccelerationX` `AccelerationX` double default NULL;

575

alter table prims change column `AccelerationY` `AccelerationY` double default NULL;

576

alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL;

577

alter table prims change column `RotationX` `RotationX` double default NULL;

578

alter table prims change column `RotationY` `RotationY` double default NULL;

579

alter table prims change column `RotationZ` `RotationZ` double default NULL;

580

alter table prims change column `RotationW` `RotationW` double default NULL;

581

alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL;

582

alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL;

583

alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL;

584

alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL;

585

alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL;

586

alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL;

587

alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL;

588

alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0';

589

alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0';

590

alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0';

591

alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0';

592

alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0';

593

alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0';

594

alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0';

595

alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0';

596

alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0';

597

alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0';

598

alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0';

commit;

:VERSION 27 #---------------------

BEGIN;

ALTER TABLE prims DROP COLUMN ParentID;

COMMIT;

:VERSION 28 #---------------------

BEGIN;

update terrain

  set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))

616

where RegionUUID not like '%-%';

617

618

619

update landaccesslist

620

  set LandUUID = concat(substr(LandUUID, 1, 8), "-", substr(LandUUID, 9, 4), "-", substr(LandUUID, 13, 4), "-", substr(LandUUID, 17, 4), "-", substr(LandUUID, 21, 12))

621

where LandUUID not like '%-%';

622

623

update landaccesslist

624

  set AccessUUID = concat(substr(AccessUUID, 1, 8), "-", substr(AccessUUID, 9, 4), "-", substr(AccessUUID, 13, 4), "-", substr(AccessUUID, 17, 4), "-", substr(AccessUUID, 21, 12))

625

where AccessUUID not like '%-%';

update prims

  set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))

630

where UUID not like '%-%';

631

632

update prims

633

  set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))

634

where RegionUUID not like '%-%';

635

636

update prims

637

  set SceneGroupID = concat(substr(SceneGroupID, 1, 8), "-", substr(SceneGroupID, 9, 4), "-", substr(SceneGroupID, 13, 4), "-", substr(SceneGroupID, 17, 4), "-", substr(SceneGroupID, 21, 12))

638

where SceneGroupID not like '%-%';

639

640

update prims

641

  set CreatorID = concat(substr(CreatorID, 1, 8), "-", substr(CreatorID, 9, 4), "-", substr(CreatorID, 13, 4), "-", substr(CreatorID, 17, 4), "-", substr(CreatorID, 21, 12))

642

where CreatorID not like '%-%';

643

644

update prims

645

  set OwnerID = concat(substr(OwnerID, 1, 8), "-", substr(OwnerID, 9, 4), "-", substr(OwnerID, 13, 4), "-", substr(OwnerID, 17, 4), "-", substr(OwnerID, 21, 12))

646

where OwnerID not like '%-%';

647

648

update prims

649

  set GroupID = concat(substr(GroupID, 1, 8), "-", substr(GroupID, 9, 4), "-", substr(GroupID, 13, 4), "-", substr(GroupID, 17, 4), "-", substr(GroupID, 21, 12))

650

where GroupID not like '%-%';

651

652

update prims

653

  set LastOwnerID = concat(substr(LastOwnerID, 1, 8), "-", substr(LastOwnerID, 9, 4), "-", substr(LastOwnerID, 13, 4), "-", substr(LastOwnerID, 17, 4), "-", substr(LastOwnerID, 21, 12))

654

where LastOwnerID not like '%-%';

update primshapes

  set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))

659

where UUID not like '%-%';

update land

  set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))

664

where UUID not like '%-%';

665

666

update land

667

  set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))

668

where RegionUUID not like '%-%';

669

670

update land

671

  set OwnerUUID = concat(substr(OwnerUUID, 1, 8), "-", substr(OwnerUUID, 9, 4), "-", substr(OwnerUUID, 13, 4), "-", substr(OwnerUUID, 17, 4), "-", substr(OwnerUUID, 21, 12))

672

where OwnerUUID not like '%-%';

673

674

update land

675

  set GroupUUID = concat(substr(GroupUUID, 1, 8), "-", substr(GroupUUID, 9, 4), "-", substr(GroupUUID, 13, 4), "-", substr(GroupUUID, 17, 4), "-", substr(GroupUUID, 21, 12))

676

where GroupUUID not like '%-%';

677

678

update land

679

  set MediaTextureUUID = concat(substr(MediaTextureUUID, 1, 8), "-", substr(MediaTextureUUID, 9, 4), "-", substr(MediaTextureUUID, 13, 4), "-", substr(MediaTextureUUID, 17, 4), "-", substr(MediaTextureUUID, 21, 12))

680

where MediaTextureUUID not like '%-%';

681

682

update land

683

  set SnapshotUUID = concat(substr(SnapshotUUID, 1, 8), "-", substr(SnapshotUUID, 9, 4), "-", substr(SnapshotUUID, 13, 4), "-", substr(SnapshotUUID, 17, 4), "-", substr(SnapshotUUID, 21, 12))

684

where SnapshotUUID not like '%-%';

685

686

update land

687

  set AuthbuyerID = concat(substr(AuthbuyerID, 1, 8), "-", substr(AuthbuyerID, 9, 4), "-", substr(AuthbuyerID, 13, 4), "-", substr(AuthbuyerID, 17, 4), "-", substr(AuthbuyerID, 21, 12))

688

where AuthbuyerID not like '%-%';

COMMIT;

:VERSION 29 #---------------------

BEGIN;

ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0;

COMMIT;

:VERSION 30 #---------------------

BEGIN;

ALTER TABLE regionsettings ADD COLUMN loaded_creation_date varchar(20) default NULL;

705

ALTER TABLE regionsettings ADD COLUMN loaded_creation_time varchar(20) default NULL;

706

ALTER TABLE regionsettings ADD COLUMN loaded_creation_id varchar(64) default NULL;

COMMIT;

:VERSION 31 #---------------------

BEGIN;

ALTER TABLE regionsettings DROP COLUMN loaded_creation_date;

715

ALTER TABLE regionsettings DROP COLUMN loaded_creation_time;

716

ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0;

COMMIT;

:VERSION 32

BEGIN;

CREATE TABLE `regionwindlight` (

724

`region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000',

725

`water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000',

726

`water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000',

727

`water_color_b` float(9,6) unsigned NOT NULL DEFAULT '64.000000',

728

`water_fog_density_exponent` float(3,1) unsigned NOT NULL DEFAULT '4.0',

729

`underwater_fog_modifier` float(3,2) unsigned NOT NULL DEFAULT '0.25',

730

`reflection_wavelet_scale_1` float(3,1) unsigned NOT NULL DEFAULT '2.0',

731

`reflection_wavelet_scale_2` float(3,1) unsigned NOT NULL DEFAULT '2.0',

732

`reflection_wavelet_scale_3` float(3,1) unsigned NOT NULL DEFAULT '2.0',

733

`fresnel_scale` float(3,2) unsigned NOT NULL DEFAULT '0.40',

734

`fresnel_offset` float(3,2) unsigned NOT NULL DEFAULT '0.50',

735

`refract_scale_above` float(3,2) unsigned NOT NULL DEFAULT '0.03',

736

`refract_scale_below` float(3,2) unsigned NOT NULL DEFAULT '0.20',

737

`blur_multiplier` float(4,3) unsigned NOT NULL DEFAULT '0.040',

738

`big_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.05',

739

`big_wave_direction_y` float(3,2) NOT NULL DEFAULT '-0.42',

740

`little_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.11',

741

`little_wave_direction_y` float(3,2) NOT NULL DEFAULT '-1.16',

742

`normal_map_texture` varchar(36) NOT NULL DEFAULT '822ded49-9a6c-f61c-cb89-6df54f42cdf4',

743

`horizon_r` float(3,2) unsigned NOT NULL DEFAULT '0.25',

744

`horizon_g` float(3,2) unsigned NOT NULL DEFAULT '0.25',

745

`horizon_b` float(3,2) unsigned NOT NULL DEFAULT '0.32',

746

`horizon_i` float(3,2) unsigned NOT NULL DEFAULT '0.32',

747

`haze_horizon` float(3,2) unsigned NOT NULL DEFAULT '0.19',

748

`blue_density_r` float(3,2) unsigned NOT NULL DEFAULT '0.12',

749

`blue_density_g` float(3,2) unsigned NOT NULL DEFAULT '0.22',

750

`blue_density_b` float(3,2) unsigned NOT NULL DEFAULT '0.38',

751

`blue_density_i` float(3,2) unsigned NOT NULL DEFAULT '0.38',

752

`haze_density` float(3,2) unsigned NOT NULL DEFAULT '0.70',

753

`density_multiplier` float(3,2) unsigned NOT NULL DEFAULT '0.18',

754

`distance_multiplier` float(4,1) unsigned NOT NULL DEFAULT '0.8',

755

`max_altitude` int(4) unsigned NOT NULL DEFAULT '1605',

756

`sun_moon_color_r` float(3,2) unsigned NOT NULL DEFAULT '0.24',

757

`sun_moon_color_g` float(3,2) unsigned NOT NULL DEFAULT '0.26',

758

`sun_moon_color_b` float(3,2) unsigned NOT NULL DEFAULT '0.30',

759

`sun_moon_color_i` float(3,2) unsigned NOT NULL DEFAULT '0.30',

760

`sun_moon_position` float(4,3) unsigned NOT NULL DEFAULT '0.317',

761

`ambient_r` float(3,2) unsigned NOT NULL DEFAULT '0.35',

762

`ambient_g` float(3,2) unsigned NOT NULL DEFAULT '0.35',

763

`ambient_b` float(3,2) unsigned NOT NULL DEFAULT '0.35',

764

`ambient_i` float(3,2) unsigned NOT NULL DEFAULT '0.35',

765

`east_angle` float(3,2) unsigned NOT NULL DEFAULT '0.00',

766

`sun_glow_focus` float(3,2) unsigned NOT NULL DEFAULT '0.10',

767

`sun_glow_size` float(3,2) unsigned NOT NULL DEFAULT '1.75',

768

`scene_gamma` float(4,2) unsigned NOT NULL DEFAULT '1.00',

769

`star_brightness` float(3,2) unsigned NOT NULL DEFAULT '0.00',

770

`cloud_color_r` float(3,2) unsigned NOT NULL DEFAULT '0.41',

771

`cloud_color_g` float(3,2) unsigned NOT NULL DEFAULT '0.41',

772

`cloud_color_b` float(3,2) unsigned NOT NULL DEFAULT '0.41',

773

`cloud_color_i` float(3,2) unsigned NOT NULL DEFAULT '0.41',

774

`cloud_x` float(3,2) unsigned NOT NULL DEFAULT '1.00',

775

`cloud_y` float(3,2) unsigned NOT NULL DEFAULT '0.53',

776

`cloud_density` float(3,2) unsigned NOT NULL DEFAULT '1.00',

777

`cloud_coverage` float(3,2) unsigned NOT NULL DEFAULT '0.27',

778

`cloud_scale` float(3,2) unsigned NOT NULL DEFAULT '0.42',

779

`cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00',

780

`cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53',

781

`cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12',

782

`cloud_scroll_x` float(3,2) unsigned NOT NULL DEFAULT '0.20',

783

`cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',

784

`cloud_scroll_y` float(3,2) unsigned NOT NULL DEFAULT '0.01',

785

`cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',

786

`draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1',

787

PRIMARY KEY (`region_id`)

);

:VERSION 33 #---------------------

792

793

BEGIN;

794

ALTER TABLE regionsettings ADD map_tile_ID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';

795

COMMIT;

796

797

:VERSION 34 #---------------------

798

799

BEGIN;

800

ALTER TABLE `regionwindlight`  CHANGE COLUMN `cloud_scroll_x` `cloud_scroll_x` FLOAT(4,2) NOT NULL DEFAULT '0.20' AFTER `cloud_detail_density`,  CHANGE COLUMN `cloud_scroll_y` `cloud_scroll_y` FLOAT(4,2) NOT NULL DEFAULT '0.01' AFTER `cloud_scroll_x_lock`;

801

COMMIT;

802

803

:VERSION 35 #---------------------

804

805

BEGIN;

806

ALTER TABLE prims ADD COLUMN MediaURL varchar(255);

807

ALTER TABLE primshapes ADD COLUMN Media TEXT;

808

COMMIT;

809

810

:VERSION 36 #---------------------

811

812

BEGIN;

813

ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none' ;

814

ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT '';

815

ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0';

816

ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE;

817

ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE;

818

ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE;

819

COMMIT;

820

821

:VERSION 37 #---------------------

BEGIN;

ALTER TABLE `prims` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT '';

826

ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT '';

COMMIT;

:VERSION 38 #---------------------

BEGIN;

alter table land ENGINE = MyISAM;

835

alter table landaccesslist ENGINE = MyISAM;

836

alter table migrations ENGINE = MyISAM;

837

alter table primitems ENGINE = MyISAM;

838

alter table prims ENGINE = MyISAM;

839

alter table primshapes ENGINE = MyISAM;

840

alter table regionban ENGINE = MyISAM;

841

alter table regionsettings ENGINE = MyISAM;

842

alter table terrain ENGINE = MyISAM;

COMMIT;

:VERSION 39 #--------------- Telehub support

847

848

BEGIN;

849

CREATE TABLE IF NOT EXISTS `spawn_points` (

850

`RegionID` varchar(36) COLLATE utf8_unicode_ci NOT NULL,

851

`Yaw` float NOT NULL,

852

`Pitch` float NOT NULL,

853

`Distance` float NOT NULL,

854

KEY `RegionID` (`RegionID`)

855

) ENGINE=Innodb;

856

857

ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL;

858

COMMIT;

859

860

:VERSION 40 #---------------- Parcels for sale

861

862

BEGIN;

863

ALTER TABLE `regionsettings` ADD COLUMN `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';

864

COMMIT;

865

866

:VERSION 41 #---------------- Timed bans/access

867

868

BEGIN;

869

ALTER TABLE `landaccesslist` ADD COLUMN `Expires` INTEGER NOT NULL DEFAULT 0;

870

COMMIT;

871

872

:VERSION 42 #--------------------- Region Covenant changed time

873

874

BEGIN;

875

ALTER TABLE regionsettings ADD COLUMN covenant_datetime int unsigned NOT NULL DEFAULT '0';

876

COMMIT;

877

878

:VERSION 43 #---------------------

BEGIN;

ALTER TABLE `regionsettings` MODIFY COLUMN `TelehubObject` VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';

COMMIT;

:VERSION 44 #--------------------- Environment Settings

BEGIN;

CREATE TABLE `regionenvironment` (

891

`region_id` varchar(36) NOT NULL,

892

`llsd_settings` TEXT NOT NULL,

893

PRIMARY KEY (`region_id`)

894

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

COMMIT;

:VERSION 45

BEGIN;

CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32) not null, `value` text, primary key(`RegionID`, `Name`));

COMMIT;

:VERSION 46 #---------------- Dynamic attributes

BEGIN;

ALTER TABLE prims ADD COLUMN DynAttrs TEXT;

COMMIT;

:VERSION 47 #---------------- Extra physics params

BEGIN;

ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0';

919

ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000';

920

ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1';

921

ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6';

922

ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5';

COMMIT;

:VERSION 48 #---------------- Keyframes

BEGIN;

ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob;

COMMIT;

:VERSION 49 #--------------------- Save attachment info

935

936

BEGIN;

937

ALTER TABLE prims ADD COLUMN AttachedPosX double default 0;

938

ALTER TABLE prims ADD COLUMN AttachedPosY double default 0;

939

ALTER TABLE prims ADD COLUMN AttachedPosZ double default 0;

940

ALTER TABLE primshapes ADD COLUMN LastAttachPoint int(4) not null default '0';

941

COMMIT;

942

opensim-development – Blame information for rev 1