aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-08-21Fix issue where conversion of temporary boolean variable fails on MySQLArthur Valadares1-2/+2
2009-08-19Fixing a spot I missed in assets. Switching Grid to the new naming schema ↵Kunnis1-12/+1
with Store/Get
2009-08-19* Switching IAssetData to follow the new naming schema, removing the ↵Kunnis1-11/+2
separate insert and update methods.
2009-08-17Add copyright headers. Formatting cleanup. Fix a compiler warning.Jeff Ames1-1/+1
2009-08-16* Fixed MySQL/MySQLAssetData.cs to properly do updates * Removed an extra ↵Kunnis2-9/+2
parameter from MySQL/MySQLInventoryData.cs * Fixed a bug in SQLite/SQLiteAssetData.cs that was causing a NRE when updating an asset. * Improved the BasicAssetTest.cs to do full create/update/get testing * Improved the BasicInventoryTest.cs to do full create/update/get of both a folder and an item * Moved the null ref tests to the start of the PropertyCompareConstraint.cs, so that it doesn't throw when passing in a null item
2009-08-16Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis5-15/+34
2009-08-07* Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)1-6/+6
256m limitation within the OpenSimulator framework, however, the LLClient ClientView does not support regions larger then 256 meters so, if you try and make your region larger by setting Constants.RegionSize = 512; in OpenSim.Framework.Constants.cs, the terrain will not display on clients using the LLUDP protocol
2009-07-25* Updates libOMV to version 0.7.0Teravus Ovares1-2/+2
* Uses mantis #3811 as a base (thanks jhuliman) with changes. * E-mail regarding interface changes sent to the opensim-dev list * Archive: https://lists.berlios.de/pipermail/opensim-dev/2009-July/007219.html
2009-07-24* Apply asset and inventory name and description bound checks to MySQLJustin Clarke Casey2-5/+40
2009-06-30From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-1/+1
Ooops, sorry there was a bug in the patch and causes an exception on some system (I think it only happens on windows since it didn't occur during my testin). I've attached a one liner which fixes the problem.
2009-06-29From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague2-13/+11
Attached is a patch that changes the oar file saving of creation date/time to an integer instead of a string. I did this after justincc emailed me saying there is a problem with internationalisation doing it the old way and I said I'd fix it. Its been tested with MySQL and I've made the changes for MSSQL but that hasn't been well tested.
2009-06-03From: Chris Yeoh <yeohc@au1.ibm.com>Dr Scofield2-2/+31
This patch adds oar file date and time (UTC) meta data to an oar file when it is created. It also adds a unique ID, though this id does not in anyway identify the machine that the oar file was created on. When an oar file with this meta data is loaded this extra information is saved with the region settings and available via LSL through: - osLoadedCreationDate() - osLoadedCreationTime() - osLoadedCreationID() If there is no meta data these fields will be blank. Subsequent oar file loads will erase the information for the previous oar file load. Persistence has only been implemented for MySQL, the other backends need updating. Overall this allows us to much more easily identify the specific version of software that clients are using. Its very straightforward to edit the oar file to change the ID string to be something more human friendly. Included in the patch is a new file OpenSim/Data/MySQL/Resources/030_RegionStore.sql required for the MySQL DB migration. btw I had a chat with justincc about this a few weeks ago since he wrote the oar file import/export and he sounded happy to accept something that included date/time information but didn't want anything that would silently leak private information like machine names.
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames15-15/+15
LICENSE.txt.
2009-05-27From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield2-2/+17
The attached patch implements llPassTouches. It has been added to the export/import XML along with the flag for AllowedInventoryDrop. The MySQL backend has been updated as well, though I haven't done one of those before so could do with a check. I added the migration mysql file as well. The other data backends need updating as well.
2009-05-25* Upped version number to 0.6.5lbsa711-2/+2
2009-05-25Revert "From: Chris Yeoh <cyeoh@au1.ibm.com>"Dr Scofield1-12/+2
This reverts r9666. for some reason the mysql update does not work.
2009-05-25From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield1-2/+12
The attached patch implements llPassTouches. It has been added to the export/import XML along with the flag for AllowedInventoryDrop. The MySQL backend has been updated as well, though I haven't done one of those before so could do with a check. I added the migration mysql file as well. The other data backends need updating as well.
2009-05-17Update svn properties.Jeff Ames1-5/+5
2009-05-12Thank you kindly, Patnad, for a patch that:Charles Krinke2-2/+9
This is to handle the changes in the v1.23 viewer of LL regarding the adult rating. With this patch a region can be changed to the adult rating from LL viewer v1.23 and above.
2009-05-08WARNING: contains migrationSean Dague1-0/+7
Since creatorID is no longer treated as a UUID type in the code from the database we need to make sure that it isn't null in the database. This updates all empty string and null values for this column to the Zero UUID, and makes the column a not null definition with a default fo the Zero UUID.
2009-05-08now that creatorID is no longer a strict UUID, and the column can still be NULL,Sean Dague1-1/+10
we lost protection from NULL strings. This puts some protection in for that case. This may address many of the inventory issues that are being seen intermitently.
2009-05-07* Consistently used dashed uuid format for mysql region data, as is done for ↵Justin Clarke Casey2-29/+105
all other tables * This revision contains a mysql data migration. Please backup your mysql region database as a precaution before using this code. * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
2009-04-22add if exists to the drop tableSean Dague2-30/+30
2009-04-22add cleardb to estate testsSean Dague1-16/+24
2009-04-22ensure we've got a clean data environment prior to running the regionSean Dague1-17/+24
tests
2009-04-13* Some more experimental work on distributed assets. Nothing hotwired yet.lbsa711-17/+19
* Introduced preprocess step in FetchAsset (Might revert this later) * Some minor CCC * Added actual implementation of GetUserProfile( uri ) and the corresponding handler to OGS1. * Introduced non-functioning GetUserUri( userProfile) awaiting user server wireup (this might move elsewhere)
2009-04-09* Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey1-1/+1
anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
2009-04-09* Moved the DatabaseTestAttribute to Test.Common, and thus included ref to ↵lbsa716-0/+6
that in all db tests. *phew*
2009-04-09* tagged some more database tests as suchlbsa715-5/+5
2009-04-09* Added custom DatabaseTestAttribute to help separating unit tests from ↵lbsa711-1/+1
component tests.
2009-04-08* Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey1-7/+5
as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
2009-04-05Adding migrations for MySQL and SQLite for removing the "old" cloud image.Homer Horwitz1-0/+1
The new one already in the Library will be reinserted automatically. Fixes Mantis #964
2009-04-01* Upped trunk version number to 0.6.4 as we just tagged 0.6.4-releaselbsa711-1/+1
2009-03-27* This updates LibOMV to the current release 0.6.0 on March 19 2009Teravus Ovares1-1/+1
* Important: HttpServer.dll was changed to HttpServer_OpenSim.dll so that the HttpServer references do not conflict if you've copied the OpenMetaverse.Http.dll and requirements to the OpenSimulator bin folder. This means that if you reference HttpServer.dll in any projects, you will need to change the reference to HttpServer_OpenSim.dll. It still uses the Same HttpServer namespace though.
2009-03-23Committing partial work on passing folders across instances. This may crash.Melanie Thielker1-0/+5
2009-03-22MYSQL Only: Make items given while offline appear in inventory withoutMelanie Thielker1-0/+9
the need to clear cache.
2009-03-21Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker1-0/+5
MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
2009-03-09Implemented FetchAssetMetadataSet in DB backends.Mike Mazur1-0/+51
This method fetches metadata for a subset of the entries in the assets database. This functionality is used in the ForEach calls in the asset storage providers in AssetInventoryServer. With this implemented, frontends such as the BrowseFrontend should now work. - MySQL: implemented, sanity tested - SQLite: implemented, sanity tested - MSSQL: implemented, not tested - NHibernate: not implemented
2009-02-25* Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa711-4/+0
I do realize the setter has to be there for legacy reasons, but since the calls will never acually DO anyhting, I'm removing them. * So, SOP.FolderID is actually a cruft field that should be removed.
2009-02-22Mantis#3218. Thank you kindly, TLaukkan (Tommil) for a patch that:Charles Krinke7-12/+29
* Added log4net dependency to physxplugin in prebuild.xml. * Added missing m_log fields to classes. * Replaced Console.WriteLine with appropriate m_log.Xxxx * Tested that nant test target runs succesfully. * Tested that local opensim sandbox starts up without errors.
2009-02-21* Applied a patch that: Added estate ban table to migration scripts and ↵lbsa711-4/+4
nhibernate mapping. Refactored property getters and setters for estate ban object to support NHibernate. * Added estate ban table to migration scripts of all supported databases. * Added nhibernate mapping for EstateBans property of EstateSettings * Refactored property accessors for EstateBan object. * Added comments for EstateBan properties. * Ensured that NHibernate tests pass with NUnitGUI. * Ensured that nant test target passes. This fixes mantis #3210. Thank you, tlaukkan!
2009-02-20* Upped VersionInfo to 0.6.3 and in the process, changed assemblyinfo to ↵lbsa711-3/+3
0.6.3.* to better track down dll ref and overwrite problems.
2009-02-18Fix estate ban list persistence in MySQL and reenable testsMelanie Thielker1-1/+1
2009-02-18remove legacy pre-migration code for mysql grid adapter, who knew thisSean Dague1-55/+0
was still in there.
2009-02-17remove all the very old create and upgrade sql files, these wereSean Dague17-288/+0
outdated by migrations 6 months ago.
2009-02-17* Moved the nifty MySQLEstateData connectionstring password-stripper out ↵lbsa711-31/+15
into the Util project
2009-02-17- remove the Metadata property from AssetBase and return all previousMike Mazur1-17/+17
properties as before - prefix private variables with m_ in AssetBase.cs - related to Mantis #3122, as mentioned in https://lists.berlios.de/pipermail/opensim-dev/2009-February/005088.html - all services will likely need to be upgraded after this commit
2009-02-16AssetInventoryServer plugins can't be a dependency for the ↵Mike Mazur1-1/+0
OpenSim.Data.MySQL addin.
2009-02-16Rename NewAssetServer AssetInventoryServer and fully qualify withMike Mazur1-1/+1
OpenSim.Grid.AssetInventoryServer.
2009-02-16- add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur1-0/+1
OpenSim.Data.*.addin.xml - remove OpenSim.Grid.NewAssetServer.exe from bin/OpenSim.Data.addin.xml - add prebuild.xml section for OpenSim.Grid.AssetServer.Plugins.OpenSim.dll