aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/RegionStore.migrations (unfollow)
Commit message (Collapse)AuthorFilesLines
2021-09-09Another database schema fix for crazy.onefang1-1/+1
2021-09-09What numbnuts thought UUIDs should be varchar(255)?onefang1-4/+4
2021-08-17MySQL default character set to utfmb4.onefang1-9/+9
Coz on one box they defaulted to utfmb3, which .NET doesn't support.
2020-07-31Various database fixups.onefang1-13/+13
InnoDB -> MyISAM utf8 if not exists white space
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
2018-12-30add some persistence (mysql only)UbitUmarov1-0/+7
2017-04-01 store the physics inertia override in Mysql and add it to serializer. run ↵UbitUmarov1-0/+6
prebuild is required
2017-01-05Create all tables ad InnoDB by defaultMelanie Thielker1-8/+8
MyISAM isn't properly replicated using row based replication. With the advances in clustering, these systems are becoming more prevalent and MyISAM isn't up to the task anymore.
2016-12-04The new Constant: integer OBJECT_REZZER_KEY = 32;Mandarinka Tasty1-0/+8
Signed-off-by: Mandarinka Tasty <mandarinka.tasty@gmail.com> Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2016-11-26Increase float precision for windlight needed by scripts. mySQL Migration on ↵AliciaRaven1-0/+63
regionwindlight table. mySQL was setup to store smaller values because the viewers editor capped input, scripts can set higher precision so settings could change on region restart. This change brings mySQL more inline with PGSQL which uses doubles for all windlight floats.
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
2016-09-17 add to databases a table to store baked terrain.UbitUmarov1-0/+11
2016-02-20Flatten migrations for MySQL.Diva Canto1-839/+248
Conflicts: OpenSim/Data/MySQL/Resources/RegionStore.migrations OpenSim/Data/MySQL/Resources/UserAccount.migrations
2015-10-20 store rotation axis locks in MySql and SQlite dbs ( others need to be ↵UbitUmarov1-0/+8
updated also
2015-09-14 try to add a mysql migration to avnUbitUmarov1-0/+15
2015-09-03 at last we can login and see objects ( friends is dead and disable inUbitUmarov1-4/+0
scenepresence)
2015-07-14Correcting errors in previous change: MySQL needs int unsigned, notMelanie Thielker1-1/+1
unsigned int. PGSQL has no unsigned types, changing to bigint.
2015-07-14Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker1-0/+8
2013-09-22Preserve attachment point & position when attachment is rezzed in worldAleric Inglewood1-0/+10
Patch taken from http://opensimulator.org/mantis/view.php?id=4905 originally by Greg C. Fixed to apply to r/23314 commit ba9daf849e7c8db48e7c03e7cdedb77776b2052f (cherry picked from commit 4ff9fbca441110cc2b93edc7286e0e9339e61cbe)
2013-06-06Database persistence for keyframes. Contains a Migration.Melanie1-0/+7
2013-02-23MyISAM is much better performing for OpenSim.David Walter Seikel1-12/+12
2013-02-09Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz1-1/+1
2013-02-06Partial port of Avination's support for the new physics parameters.Melanie1-0/+13
Implements the parameters as properties, the serialization and database storage (MySQL only). Implements llSetPrimitiveParams for prim physics shape and the other 4 extra params. Only the prim shape type "None" is currently functional. No support for the Viewer UI (yet), that will be ported in due course. Lots more to port, this is a large-ish changeset.
2013-01-25Stopped storing dynamic attributes in the PrimShapeOren Hurvitz1-1/+0
2013-01-25Implement dynamic attribute persistence on mysql and mssqlJustin Clark-Casey (justincc)1-0/+9
mssql is untested
2012-08-15Add a skeleton for a name value storage associated with regionsMelanie1-0/+7
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.
generated by cgit v1.1 at 2025-03-12 00:36:59 +0000