[Opensim-dev] Heads-Up for users of OpenSim development versions from Jan 20, 2012 until today

[Frank Nichols]

Bluewall,

The below example of what the migration table should look like is the case
only if the robust and region's share the same DB.

Frank

On Mon, Jan 23, 2012 at 7:10 PM, BlueWall <jamesh at bluewallgroup.com> wrote:

> As some are aware, development to add working telehubs to OpenSim has been
> progressing the past couple of days. In the beginning, working out the
> packet dialog with the viewer, several bits of data were needed to send for
> the telehub info. These were saved in the database and there was a
> migration to add the fields and an additional table to the database to save
> these. As work progressed, and more eyes were added to the effort, it was
> apparent that we needed to refresh the values each time they were used and
> that saving them was pointless. So, we are modifying the database to only
> save what is needed. Here is the rub - I was not aware that by policy we do
> not do backwards migrations for a couple of reasons. So, these previous
> migrations will need to be handled by hand. It is just a matter of logging
> into the console of your database and pasting the script that follows.
>
> This affects MySQL only! Works has not been extended to other database
> engines at this time.
>
>
> revisions affected:
> start: 32d58d6e3e9a0ea1bfa808567d0f64**c0652f8a85
> end: c36c916342460751d25350b66ffbd7**eb0a401c2b
>
>
> Script ...
>
> BEGIN;
> alter table regionsettings drop column TelehubName;
> alter table regionsettings drop column TelehubEnabled;
> alter table regionsettings drop column TelehubPosX;
> alter table regionsettings drop column TelehubPosY;
> alter table regionsettings drop column TelehubPosZ;
> alter table regionsettings drop column TelehubRotX;
> alter table regionsettings drop column TelehubRotY;
> alter table regionsettings drop column TelehubRotZ;
> alter table regionsettings drop column TelehubRotW;
>
> alter table spawn_points change column PointX Yaw float NOT NULL;
> alter table spawn_points change column PointY Pitch float NOT NULL;
> alter table spawn_points change column PointZ Distance float NOT NULL;
> COMMIT;
>
> your migrations table (of your region store) should look like ...
>
> +----------------+---------+
> | name           | version |
> +----------------+---------+
> | migrations     |       1 |
> | UserStore      |       7 |
> | GridStore      |       2 |
> | LogStore       |       1 |
> | InventoryStore |       4 |
> | AssetStore     |       6 |
> | RegionStore    |      39 |
> +----------------+---------+
>
>
> That should be all that is needed to get things on track for future
> releases. And, as always you can get additional assistance here or in IRC @
> #opensim or for development questions #opensim-dev.
>
>
> Thanks for using OpenSimulator!
> BlueWall
> ______________________________**_________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/**mailman/listinfo/opensim-dev<https://lists.berlios.de/mailman/listinfo/opensim-dev>
>



-- 
*Descartes walks into a bar, and the bartender asks "Would you like a
beer?" Descartes replies "I think not" and POOF! he vanishes...*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20120124/6aa7bf77/attachment-0001.html>