aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/PGSQLEstateData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2017-01-05Massive tab and trailing space cleanupMelanie Thielker1-1/+1
2015-06-24Thanks Gavin Hird for a fix for an exception when requesting an Estate Ban ↵dahlia1-3/+3
when using PGSQL.
2013-10-16Corrected estateID to EstateID on getEstates function at PGSQLEstateData.csFernando Oliveira1-1/+1
2013-10-15* Fixes mantis #6802 Simulator crashes whist loading (lighshare enabled)fernando1-5/+9
* Please test
2013-10-12Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira1-86/+107
* Added PostGreSQL support * Added MySQL/MySQLXGroupData.cs * PostgreSQL data access implementation * PostgreSQL dll binarie and RegionStore.migrations * Migrations Scripts from MSSQL to POSTGRES * Postgres SQL Type fixes * Postgres SQL Connection string * Data type issues * more fixes * tests and +tests * UUID x string - FIGHT! * Fixed PG types to internal csharp types * More data type fix (PostgreSQL fields are case sensitive) :( * more field case sensitive fixes * changed the migration files to be case sensitive for fields. * fixed fields case * finished converting, now search for hidden bugs. * some more fixes * bool type fixed * more case fixes; * creatorID case fixed * case fields fixed * fixed default now() for TMStamp fields with don't allow nulls. * fix case sensitve for Region name and Estate name * fixed case for names for search * fix class name Error * Bug fixed on select and migrations * Un-Reverting my change due to Postgres issue with the ILIKE function * Fixed some issued for Diva Distro * Fixes for integration with Diva Distro * Added System.Core to prebuild.xml for PG project * Configured to make DIff for Push to OpenSim Project * Diffs only to PostgreSQL mods.
2011-09-16Reattaching a region was failing if the estate name had not changed (issue ↵Kevin Houlihan1-48/+69
5035). Using the RemoteAdmin API to close then recreate a region would fail if the estate name had not changed. If the estate name /was/ changed then the existing estate would be renamed rather than a new one being created. The problem really arose from a lack of distinction in the data storage layer between creating new estates and loading existing ones.
2011-06-01Updates to MSSQL to most recent compatibility, also included Windlight ↵Chris Hart1-23/+180
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-04-05Make the "All Estates" option work from the client (this makes chosen ↵Justin Clark-Casey (justincc)1-0/+5
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-21On initial region registration, if the user chooses the option to make the ↵Justin Clark-Casey (justincc)1-0/+17
region part of an existing estate, then list the existing region names.
2010-09-12* Added ISimulationDataService and IEstateDataServiceJohn Hurliman1-0/+9
* Removed StorageManager * CONFIG CHANGE: There are no more database settings in OpenSim.ini. Check the config-include configuration files for region store and estate store database settings
2010-05-23All data tests made DBMS-independentAlexRa1-1/+1
2010-05-18Massive bugfix in MSSQLEstateData (now works!)AlexRa1-49/+41
2010-03-23First stage of the new interactive region creation. This will allow creationMelanie1-0/+25
of a region and joining it to an existing estate or creating a new estate, as well as creating an estate owner if in standalone, and assigning estate owners. In Grid mode, existing users must be used. MySQL ONLY!!!! so far, as I can't develop or test for either SQLite or MSSQL.
2010-03-22Remove the reading of estate_settings.xml and the associated processing ofMelanie1-21/+2
defaults. Adding code to facilitate estate creation / managemment as part of first time start up
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride1-49/+50
works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
2009-06-14Fixes Mantis #3793 . Committing thomax/Snoopy's patch to allow deeding of ↵Melanie Thielker1-60/+1
objects, with changes: - Set OwnerID = GroupID for deeded objects. - Close a security loophole that would have allowed a user with deed rights in a group to deed ANY object to that group, even if it's not owned by them and/or not set to that group - Set LastOwnerID correctly. Handle objects vs. prims correctly.
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-05-17Thank you kindly, StrawberryFride, for a patch that:Charles Krinke1-6/+3
Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
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-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-57/+59
* Changes varchar(36) columns to UUID type in MSSQL - this will be much more efficient * ===As always, please, please backup your database before applying this patch=== * Thanks Ruud Lathrop (for the patch) and StrawberryFride (for the review)
2009-02-12* optimized usings.lbsa711-2/+2
2009-02-06This changeset is the step 1 of 2 in refactoringDr Scofield1-1/+1
OpenSim.Region.Environment into a "framework" part and a modules only part. This first changeset refactors OpenSim.Region.Environment.Scenes, OpenSim.Region.Environment.Interfaces, and OpenSim.Region.Interfaces into OpenSim.Region.Framework.{Interfaces,Scenes} leaving only region modules in OpenSim.Region.Environment. The next step will be to move region modules up from OpenSim.Region.Environment.Modules to OpenSim.Region.CoreModules and then sort out which modules are really core modules and which should move out to forge. I've been very careful to NOT BREAK anything. i hope i've succeeded. as this is the work of a whole week i hope i managed to keep track with the applied patches of the last week --- could any of you that did check in stuff have a look at whether it survived? thx!
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz1-1/+1
2008-09-14Mantis #2124Melanie Thielker1-9/+3
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-13/+13
* This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
2008-09-06* Remove lots of warnings from the CMS moduleJustin Clarke Casey1-2/+2
* Remove a few other miscellaneous warnings
2008-09-02Mantis #2102Melanie Thielker1-7/+8
Thank you, RuudL, for a patch that supplements the previous MSSQL patch.
2008-09-01Mantis #2095Melanie Thielker1-0/+434
Thank you, RuudL, for a complete adaptation of migration and estate data to MSSQL, and the updating of the RegionData handling in MSSQL.