aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
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
2015-07-12Bringing FSAssets more inline with current OpenSim standards. * If no ↵AliciaRaven1-0/+18
connection string found in assets config, fallback to using default database config * Create database storage interface to allow other db connectors to be written at some point * Add MySQL migrations file to create the initial db table * Added new config option named DaysBetweenAccessTimeUpdates to reduce db load by only updating access times when fetching assets if the last access time was over the threshold. This idea was taken from XAssets service. * Change log message headers to indicate FS assets is the source not just assets Signed-off-by: Melanie Thielker <melanie@t-data.com>
2015-06-13Support for Linden AgentPreferences capability and friends ↵Cinder1-0/+18
(UpdateAgentLanguage and UpdateAgentInformation) and Mantis #7157 Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-03-04Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2-4/+2
operation is very expensive
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-04Revert "Chase latest change to asset description length with an update to ↵BlueWall1-9/+1
XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-03Follow up to last commit, fix field lengthCinder1-0/+3
Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2014-10-27Add hypergrid teleporting support to user profiles picksBlueWall1-1/+6
2014-04-23Changed table 'im_offline' to use UTF8 characters. This fixes a problem with ↵Oren Hurvitz1-1/+9
Offline IM V2 (only relevant to MySQL). This fixes http://opensimulator.org/mantis/view.php?id=7123 Users that use MySQL should change their MySQL configuration to support UTF8. In the config file /etc/my.cnf (Linux) or my.ini (Windows), add these settings: [mysqld] character-set-server=utf8 [client] default-character-set=utf8 And then restart MySQL (on Linux: "sudo service mysqld restart").
2014-04-21Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz1-1/+9
2014-01-16In the offline message table, store the sender.Oren Hurvitz1-1/+11
This data is useful for preventing abuse (e.g., someone who sends too many messages), or for deleting message if their sender has been deleted.
2013-12-06Add support for user preferences (im via email)BlueWall1-0/+10
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-07-14Cleanup old hg sessions (older than 2 days)Diva Canto1-0/+1
2013-07-14HG UAS: Moved hg-session data from memory to DB storage. This makes it so ↵Diva Canto1-0/+17
that traveling info survives Robust resets. It should also eliminate the cause of empty IP addresses in agent circuit data that we saw in CC grid. MySQL only.
2013-07-04HG Friends: migration #3 is failing on some installations of MySql. Setting ↵Diva Canto1-1/+1
the table to InnoDB seems to fix the problem.
2013-06-06Database persistence for keyframes. Contains a Migration.Melanie1-0/+7
2013-05-30UserProfilesBlueWall1-0/+83
UserProfiles for Robust and Standalone. Includes service and connectors for Robust and standalone opensim plus matching region module.
2013-05-11Send up the part missing from the Avination Estate commit.Melanie1-0/+6
Warning - contains a small migration.
2013-03-15Change the table and field names of XAssetService mysql db tables to be ↵Justin Clark-Casey (justincc)1-15/+15
capitalized like Avatars, Friends, etc. Also fixes access time being set on assets rather than XAssetsMeta This is to try and be somewhat consistent with other service tables that are mainly in this style. No migration is supplied, since nobody should be using this service yet except on a test basis.
2013-02-19First commit of Diva Groups. The Data bits went to OpenSim.Data core, the ↵Diva Canto1-0/+115
rest to Addons.Groups.dll.
2013-02-19Offline IM: moved the Data and MySQL bits to the corresponding places in ↵Diva Canto1-0/+24
core, so that it will be easier to plugin a SQLite backend, if anyone is interested in doing that.
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-09-27Removed the bits about the TOSModule. That module doesn't go into core. ↵Diva Canto1-3/+0
WARNING: migration on GridUser withdrawn too, but left the migration number there.
2012-09-25TOS module. WARNING: migration in GridUser table.Diva Canto1-0/+8
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-03-06Switch to sha256 from sha1 in order to avoid future asset hash collisions.Justin Clark-Casey (justincc)1-2/+2
Some successful collision attacks have been carried out on sha1 with speculation that more are possible. http://en.wikipedia.org/wiki/Cryptographic_hash_function#Cryptographic_hash_algorithms No successful attacks have been shown on sha256, which makes it less likely that anybody will be able to engineer an asset hash collision in the future. Tradeoff is more storage required for hashes, and more cpu to hash, though this is neglible compared to db operations and network access.
2012-03-02Make XAssetService a de-duplicating asset service.Justin Clark-Casey (justincc)1-0/+27
This is an extremely crude implemenation which almost works by accident. Nevertheless it does work. It can be tested with the instructions at http://opensimulator.org/wiki/Feature_Proposals/Deduplicating_Asset_Service#Testing It does not interact at all with the existing asset service or any data stored there. This code is subject to change without notice and should not be used for anything other than gawking.
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 the needed column in the regions table and a few tweaks.Melanie1-0/+9
Warning: Contains a Migration Warning: Cannot guarantee nut free
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.Melanie2-22/+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.
2012-01-21Telehub Support:BlueWall1-0/+21
Telehub settings now persist to the database and are saved across sim restarts. So-far this only works on MySQL. this is a work in progress, teleport routing is not yet implemented.
2011-09-20Remove vestigal OpenSim.Data mono addins extension points that don't look ↵Justin Clark-Casey (justincc)1-23/+0
like they've been active for at least 2 and a half years
2011-06-11Switched order of SQL statements in Friends migration -- resulted in the ↵Diva Canto1-1/+1
wrong key
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.
2011-06-01This is the better solution: make the combined key be only on the first 36 ↵Diva Canto1-1/+2
characters of each field -- that's the UUIDs. Thanks coyled. WARNING: Again, people who have gone through this migration and failed need to run it manually.
2011-06-01It looks like there's a better solution for that problem.Diva Canto1-2/+1
Revert "Changed Friends table to have 165-sized varchars on PrincipalID and FriendID. The reason for this number is the following: there is a combined key of these 2 fields; apparently MySql can't handle keys larger than 1000 bytes; when the table is created with utf8 encoding, this combined key is bigger than 1000 bytes, and the migration fails. WARNING: this is not a new migration! People who have gone through this migration and failed should update the sizes of these fields manually." This reverts commit 3fa54a156a83e498a7d5d0949a5f848fe82fe86f.
2011-06-01Changed Friends table to have 165-sized varchars on PrincipalID and ↵Diva Canto1-1/+2
FriendID. The reason for this number is the following: there is a combined key of these 2 fields; apparently MySql can't handle keys larger than 1000 bytes; when the table is created with utf8 encoding, this combined key is bigger than 1000 bytes, and the migration fails. WARNING: this is not a new migration! People who have gone through this migration and failed should update the sizes of these fields manually.
2011-05-19HG Friends working to some extent: friendships offered and accepted ↵Diva Canto1-0/+6
correctly handled. Friends list showing correct foreign names. TODO: GrantRights.
generated by cgit v1.1 at 2024-12-27 16:30:39 +0000