Hi Peter ,
unfortunately I am not a developper and cannot provide you with any insight
into what role regionextra is serving.
Like a lot of thinks in opensim its yours to discover and possibly share what
you find with others if you feel so incline.
This is what I found hoping it can be usefull to your quest:
searching for regionextra in bin or opensim from 064 in april 2009 release,
069 of 14th May 2010, 070 release 10th September 2010 , 0.7.1.1 ,released on
8th May 2011, 0.7.3.1 released on 30th March 2012 , 0.7.4 released on 31st
August 2012, I found nothing refering to regionextra.
The first appearence of regionextra I have are in
opensim-0.7.5/bin/OpenSim.Data.MySQL.dll and same file in ./diva-r22043 and
./osgrid130102 .
According to source RegionStore.migrations the database was created in
version 45 and never updated after as follows::
______________________
VERSION 45
BEGIN;
CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32)
not null, `value` text, primary key(`RegionID`, `Name`));
COMMIT;
______________________
The code use to interface with regionextra is found in MYSQLSimulationData.cs
with the following functions: public void SaveExtra(UUID regionID, string
name, string val)
public void RemoveExtra(UUID regionID, string name)
public Dictionary<string, string> GetExtra(UUID regionID)
Its the last addition of that code file where you also can find other region
coding like windlight and spanpoints. I see that it contain, a save, a
remove, and a data query function. Therefor I would speculate that since it
often empty , its possibly use for temporary storage of some kind regarding
region data. Since string name and string val could be anything that does not
clarify what is store in that dictionnary.
The only way to know more without finding someone that do would be to monitor
that file in debug mode to see when this part of code is executed.
Hope it helps.
GiMiSa
GiMiSa
Le samedi 13 juillet 2019 12 h 36 min 24 s UTC−4, Peter Gloor
<[email protected]> a écrit :
Working on a database related module I stumbled over the regionextra table
which seems to exist in MySQL databases only. At least it does not exist in
standalone environments using SQlite and I couldn't find any references in
PGSQL code nor related migration files.
I checked all my active MySQL databases and could not find any regionextra
table containing data.
I don't have any issues, I'm just wondering what this table is for. Is it a
leftover from older code that can be removed or is there still a purpose I
just don't see?
Peter
aka Pius Noel
_______________________________________________
Opensim-dev mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
_______________________________________________
Opensim-dev mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
