aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/RegionStore.migrations (unfollow)
Commit message (Collapse)AuthorFilesLines
2019-05-19Various database fixups.onefang1-13/+13
InnoDB -> MyISAM utf8 if not exists white space
2019-05-19Dump OpenSim 0.9.0.1 into it's own branch.onefang1-832/+351
2016-11-03MyISAM is still much better performing for OpenSim.David Walter Seikel1-12/+12
This time we got the file system asset server, even better still. B-)
2016-11-03Initial update to OpenSim 0.8.2.1 source code.David Walter Seikel1-12/+58
2013-02-23MyISAM is much better performing for OpenSim.David Walter Seikel1-12/+12
2012-08-15Add a skeleton for a name value storage associated with regionsMelanie1-0/+7
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen1-0/+11
includes database region store migrations for mssql, mysql, sqlite enable/disable this module: Cap_EnvironmentSettings = "localhost" (for enable) Cap_EnvironmentSettings = "" (for disable) at ClientStack.LindenCaps section (OpenSimDefaults.ini file) or owerwrite in OpenSim.ini mantis: http://opensimulator.org/mantis/view.php?id=5860 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2012-02-04Add default value to TelehubObjectBlueWall1-0/+10
2012-02-03Fix: Covenant changed time not set ↵PixelTomsen1-0/+5
http://opensimulator.org/mantis/view.php?id=5869 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2012-02-02Replace ParcelAccessEntry with a new struct, LandAccessEntry, which moreMelanie1-0/+6
accurately reflects the data sent by the viewer. Add times bans and the expiration of timed bans. Warning: Contains a Migration (and nuts)
2012-01-30Add ParcelImageID to RegionSettings so we can have that overlay.Melanie1-0/+6
Warning: Contains a Migration. Warning: May contain nuts.
2012-01-23IMPORTANT!!!!! Please READ. DO NOT Use this version or any before it since theMelanie1-12/+3
Telehub commits! They will eat your babies and corrupt your database while they munch. DO NOT use anything from the first Telehub commit to this one. FIRST GOOD COMMIT is the one FOLLOWING this one. You have been warned.
2012-01-22Change the key name I missed in last commitMelanie1-1/+1
2012-01-22Move Telehub tables and data from EstateSettings to RegionSettings.Melanie1-1/+25
This is damage control es EstateSettings is not the place this can be put. EstateSettings is nt unique to a region and therefore would introduce a hard limit of one telehub per estate, completely shutting off the option of having SL style telehubs, e.g. one per region. Whole estate teleport routing can still be implemented id desiresd, this way all options are open while the other way most options get closed off.
2011-06-10For MySQL, migrate region tables to the MyISAM storage engine rather than InnoDBJustin Clark-Casey (justincc)1-0/+16
Using MyISAM proves vastly faster for persisting scene objects. For instance, a scene object that took 9 seconds to persist before now takes 1. This also improves the experience of loading large OARs. We don't use any of the transactional features of InnoDB. The only thing that may have an impact is that InnoDB does row locking on inserts while MyISAM does table locking. However, field reports say there is no noticeable difference.
2010-11-21Added creator info across the board -- TaskInventoryItems and InventoryItems ↵Diva Canto1-0/+1
themselves. Tested. Seems to be working, main tests pass. Nothing done for IARs or HG transfers yet -- this only works for OARs for the time being. New migration in inventory table in order to make CreatorID varchar(255).
2010-11-21Global creator information working on MySQL DB and on load/save OARs. ↵Diva Canto1-0/+8
Creator name properly shown on the viewer as first.last @authority. New option added to save oar -profile=url. Migration on RegionStore making CreatorID be 255 chars. Moved Handling of user UUID -> name requests to a new module UserManagement/UserManagementModule.
2010-08-30Implements parcel media setting persistence and packet / CAPS handlingJonathan Freedman1-2/+12
properly for the new media settings. Signed-off-by: Melanie <melanie@t-data.com>
2010-08-30local commit with parcel media bitsJonathan Freedman1-2/+12
Signed-off-by: Melanie <melanie@t-data.com>
2010-07-26add mysql support for media on a primJustin Clark-Casey (justincc)1-1/+8
2010-07-26add mysql support for media on a primJustin Clark-Casey (justincc)1-1/+8
2010-06-14* Deleted duplicated migration that was failing anyway.Diva Canto1-2/+0
* Added an error message in initial estate owner creation that makes it clear what needs to happen.
2010-06-09Add the BEGIN; I had missedMelanie1-0/+1
2010-06-09Re-add Migration version 32, which apparently got dropped completely.Melanie1-0/+72
2010-06-08Add a migration to adjust types in the WL table. The new connector likes thatMelanie1-0/+6
better
2010-05-23MySQL Migrations: Minor correcton to Region/Estate splitAlexRa1-6/+0
(some Estate SQL left behind in the Region migration)
2010-05-23Split migrations for RegionStore and EstateStore (see WARNING!)AlexRa1-78/+0
ok, so the estate stores now want their own migration files, but as it happened the SQL definition were inside the Region migrations. It seems better/cleaner to keep each 'store' separately updatable. WARNING: any editing in the middle of the migration scripts (as opposite to just appending to them) has the potential of messing up updates of existing databases. As far as I can see, this one is (probably) safe, the worst that could happen is the EstateStore migration silently fail if the estate the tables are already there.
2010-05-20Cleaned up MySql migrations a bit more, got rid of all old-form migration ↵Diva Canto1-1/+4
files. Restored Presence table to its taboo-breaking form.
2010-05-18Converted MySQL migration history to the new formatAlexRa1-0/+806
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
2010-05-16Converted MySQL migration history to the new formatAlexRa1-0/+806
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store