aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2011-07-31Allow removing users from search and avatar pickerMelanie1-2/+2
2011-07-05Don't store the default WL profile. This will prevent "valid" from beingMelanie1-1/+1
set on the default profile and hopefully finally fix day and night
2011-06-20Add some flags to control content in search betterMelanie1-2/+7
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-06-01Updates to MSSQL to most recent compatibility, also included Windlight ↵Chris Hart10-48/+828
support. Needs plenty of testing but clean install and migration from 0.6.9 have been tested and work, a few indexes still need to be added for performance.
2011-05-31Fix dumb sql mistake in MSSQLGenericTableHandler.Delete()Justin Clark-Casey (justincc)1-1/+1
2011-05-27fix bug where generic sqlite table delete wasn't working.Justin Clark-Casey (justincc)1-1/+1
this would have caused dupe links bugs when using the sqlite adaptor
2011-05-22More on HG Friends. Added Delete(string, string) across the board. Added ↵Diva Canto5-5/+30
security to friendship identifiers so that they can safely be deleted across worlds. Had to change Get(string) to use LIKE because the secret in the identifier is not always known -- affects only HG visitors. BOTTOM LINE SO FAR: HG friendships established and deleted safely across grids, local rights working but not (yet?) being transmitted back.
2011-05-21Fixed permissions bug related to friends in PermissionsModule. Added ↵Diva Canto5-2/+24
FriendsData[] GetFriends(string principalID) to IFriendsData and FriendInfo[] GetFriends(string PrincipalID) to IFriendsService. Refactored some more in the FriendsModule. Made client get notification of local friends permissions upon HGLogin. HG Friends object permissions work.
2011-05-20Add a missing virtual keywordMelanie1-1/+1
2011-05-20Make public interface methods in MySQLSimulation data virtual so the CMMelanie1-14/+14
data layer can inherit from it
2011-05-19HG Friends working to some extent: friendships offered and accepted ↵Diva Canto3-3/+9
correctly handled. Friends list showing correct foreign names. TODO: GrantRights.
2011-05-19Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)7-24/+125
If these links are not deleted, then they will build up in the player's inventory until they can no longer log in. Accidental deletion of links due to bugs or other causes is potentially inconvenient but on a par with items being accidentally moved. When a link is deleted, the target of the link is never touched. This is a general solution that accounts for the use of links anywhere in the user's inventory.
2011-05-18Accidentally committed too earlyJustin Clark-Casey (justincc)7-125/+24
Revert "Allow item links to be deleted even when other deletes and purges are disabled." This reverts commit 491279f99afc65860d44765ee7829c7dd5e4e38e.
2011-05-17Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)7-24/+125
If these links are not deleted, then they will build up in the player's inventory until they can no longer log in. Accidental deletion of links due to bugs or other causes is potentially inconvenient but on a par with items being accidentally moved. When a link is deleted, the target of the link is never touched. This is a general solution that accounts for the use of links anywhere in the user's inventory.
2011-05-07Mantis #5470 -- add forgotten MSSQL's GridUserStore. Thank you MrMonkEDiva Canto1-0/+19
2011-05-06remove further mono compiler warningsJustin Clark-Casey (justincc)5-6/+6
2011-05-06minor: remove mono compiler warningsJustin Clark-Casey (justincc)2-4/+2
2011-04-28Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to ↵Diva Canto11-32/+199
speed with 0.7.x.
2011-04-21Honor agent limit for region crossings and teleportsMelanie1-10/+14
2011-04-12minor: remove some mono compiler warningsJustin Clark-Casey (justincc)1-3/+3
2011-04-11Include code to return more information about the NullReferenceException seen inJustin Clark-Casey (justincc)1-2/+13
http://opensimulator.org/mantis/view.php?id=5403 prior to doing something about it.
2011-04-07Remove the SQLite legacy adaptor. This is no longer needed now that the ↵Justin Clark-Casey (justincc)57-6164/+0
main adaptor works on Mac OS X. The SQLite legacy adapator was also not at all well maintained, even worse than the mainline sqlite adapator.
2011-04-04* Bugfix - Compile NullEstateData implement public List<int> ↵Teravus Ovares (Dan Olivares)1-0/+10
IEstateDataStore.GetEstatesByOwner(UUID)
2011-04-04Updates NullStorage plugin.Mic Bowman2-0/+140
Thanks MisterBlue...
2011-04-05Make the "All Estates" option work from the client (this makes chosen ↵Justin Clark-Casey (justincc)4-1/+80
changes to all the estates that the user owns). This applies to adding/removing estate users, groups, managers and bans. This is the application of the AllEstates_0.5.patch from http://opensimulator.org/mantis/view.php?id=5420 Thanks very much, Snoopy!
2011-03-31remove some mono compiler warningsJustin Clark-Casey (justincc)6-10/+8
2011-03-22Add some more fields to Estate settings and make them work.Melanie1-2/+1
Run alter table estate_settings add column AllowLandmark tinyint not null default 1, add column AllowParcelChanges tinyint not null default 1, add column AllowSetHome tinyint not null default 1; to make this work.
2011-03-22Add a definition for a region flag to omit a region from traffic countingMelanie1-1/+2
2011-03-21On initial region registration, if the user chooses the option to make the ↵Justin Clark-Casey (justincc)4-0/+122
region part of an existing estate, then list the existing region names.
2011-03-14Fix a bug in T015_LargeSceneObjects() where the large scene object was ↵Justin Clark-Casey (justincc)1-2/+3
stored 31 times (1 time for each added part) instead of once at the end, even though only the largest 31 prim scene object was retrieved and tested. This considerably speeds up the test, when on sqlite it now only takes 2 seconds rather than 30+
2011-03-14when retrieving a sog in database tests, don't bother adding the scene since ↵Justin Clark-Casey (justincc)1-14/+1
this isn't used
2011-03-14Add method doc to T015_LargeSceneObjects() and slightly clean up formatting.Justin Clark-Casey (justincc)1-3/+6
This test takes a considerable time on SQLite but should remain since it's testing storage and retrieval of a scene object with 31 parts.
2011-03-14Add current method output to all persistence level tests so that we can ↵Justin Clark-Casey (justincc)4-11/+99
track where we are in the test suite
2011-03-12Change avatar picker search to work properly when two name parts are usedMelanie1-1/+1
2011-03-12minor: remove mono compiler warningJustin Clark-Casey (justincc)1-1/+1
2011-03-09Upgrade nunit.framework.dll to version 2.5.9. Fix up tests appropriately.Justin Clark-Casey (justincc)6-57/+2
This version removes the NUnit.Framework.SyntaxHelpers namespace, so any modules with their own tests will need to delete this using statement.
2011-03-09Simplify TestLoadIarV0_1AbsentUsers() to use common IAR test setup. Make ↵Justin Clark-Casey (justincc)1-14/+51
static dictionaries on NullUserAccountData instance instead to stop user accounts being carried over between tests
2011-03-08Pull up Assembly of the MySQL classes as a protected property, so that it ↵Diva Canto6-11/+39
can be overwritten in subclasses. That way extensions can decide in which assembly migration resources should be looked up. This is just a refactor -- no functional changes whatsoever.
2011-02-22GetRegion(s)ByName with SQLite behaves like it does with other databases.Marck1-10/+38
The in-memory storage of region data that is used by default with SQLite now handles wildcards in region names in the same way as SQL queries do with other databases.
2011-02-11In SQLiteSimulationData.RemoveLandObject(), don't manually remove the row ↵Justin Clark-Casey (justincc)1-6/+0
from the data adaptor's Rows list in addition to calling Delete. This matches the behaviour for other deletions and stops this operation failing on Windows .NET (though mono is fine with the duplication). Probably a holdover from copying code from the older legacy adaptor. Resolves http://opensimulator.org/mantis/view.php?id=5361
2011-01-18Also fix MySQLXInventoryDataMelanie1-1/+1
2011-01-18Prevent activation and deactivation of gestures from clobbering the slamMelanie1-1/+1
bits
2011-01-18Prevent activation and deactivation of gestures from clobbering the slamMelanie1-1/+1
bits
2010-12-05Fixed some inconsistency with trailing /. Made debug messages consistent. ↵Diva Canto2-2/+9
Changed the stored region names of HG regions. Increased the size of regionName in DB.
2010-11-26Another attempt at fixing failing test for creator info.Marck1-2/+2