aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/PGSQLManager.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2017-01-05Massive tab and trailing space cleanupMelanie Thielker1-1/+1
2016-04-25Updated the code to handle Agent Preferences. Thanks to TomDataworks for ↵Geir Nøklebye1-1/+1
providing a final solution. Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7610)
2015-07-31PGSQL migrations for IM_Store, UserProfiles, removal of casting exception ↵Geir Nøklebye1-0/+4
for UserProfiles and adding double precision to PGSQL Manager PGSQL migrations for IM_Store, UserProfiles, removal of casting exception for UserProfiles and adding double precision to PGSQL Manager. Fixes the Offline IM to Email toggle and prepares for fixing Offline IM. Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2013-10-16* One More thing, add an appdomain data element to ensure that we don't ↵Fernando Oliveira1-2/+7
duplicate the assembly resolving.
2013-10-16* Fixes mantis mantis 0006803 [PGSQL] - Simulator crashes - ↵Fernando Oliveira1-0/+24
Mono.Security.dll missing. The root of the issue is that the Postgres driver relies on Mono.Security.dll from the mono project. Unfortunately, when using Mono, including the dll in the distribution causes conflicts. This solution puts Mono.Security.dll in bin/lib/NET/ and, if windows .NET is the runtime, informs the assembly loader to load bin/lib/NET/Mono.Security.dll when .NET is scanning for the Mono.Security namespace. On Mono, the included Mono.Security assembly is ignored.
2013-10-12Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira1-25/+127
* 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.
2012-03-31Add MSSQL login processing fix for servers run on different locales.Justin Clark-Casey (justincc)1-0/+5
This may no longer be an issue with better locale enforcement in OpenSimulator but it doesn't hurt to have this patch. http://opensimulator.org/mantis/view.php?id=4680 Thanks to controlbreak for this
2011-03-31remove some mono compiler warningsJustin Clark-Casey (justincc)1-3/+1
2010-03-10Formatting cleanup. Add copyright notices.Jeff Ames1-2/+2
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride1-221/+4
works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman1-0/+4
the grid server after running for several hours
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman1-4/+0
Local member in MySQLAssetData * First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-4/+8
* 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-01-12* Apply http://opensimulator.org/mantis/view.php?id=2980Justin Clarke Casey1-0/+4
* Add single conversion to MSSQLManager.DbTypeFromType * May resolve storage of prim information under MSSQL * Thanks SirKimba
2009-01-07Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-1/+14
Solves the problem of unable to load prim items on region start in MSSQL. The error was in the MSSQLRegionData code that loads objects from the database, due to reliance on the ParentID field that is not used.
2008-09-14Mantis #2124Melanie Thielker1-330/+44
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-19/+19
* 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-01Mantis #2095Melanie Thielker1-4/+112
Thank you, RuudL, for a complete adaptation of migration and estate data to MSSQL, and the updating of the RegionData handling in MSSQL.
2008-08-18Formatting cleanup.Jeff Ames1-4/+4
2008-07-20Mantis#1796. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-1/+59
Agent table code (INSERT / UPDATE, etc) now added to MSSQL provider.
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-82/+59
Many issues with handling connections in MSSQL, have rearchitected to ensure that connections are always opened and closed in a timely fashion & disposed of cleanly, and removed unnecessary lock statements. SQL Server performance seems to have improved considerably as a result, and various timeout errors seem to have been fixed.
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey1-1/+0
* Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
2008-06-27last round of warning squashing. calling it a day now.Dr Scofield1-1/+1
2008-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames1-4/+32
kerunix_Flan!
2008-05-16Formatting cleanup.Jeff Ames1-2/+2
2008-05-08* You can haz more spring cleaning.Adam Frisby1-6/+1
* Eventually this codebase will be clean. >_>
2008-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby1-2/+2
(this took a while to run).
2008-04-10renaming of attributes in UserAgentData for readabilitySean Dague1-3/+3
2008-04-10changing UserAgentData to use properties. This caused moreSean Dague1-11/+14
grief than expected, as monodevelop doesn't like to refactor properties of properties.
2008-04-10further renaming of properties for claritySean Dague1-7/+7
2008-04-10moved fields to properties for UserDataProfile, which wasSean Dague1-19/+19
actually a little more work than I expected given the copious use of out params.
2008-04-02fix ups to include OpenSim.Framework explicit includes (theySean Dague1-0/+1
were implicitly included before). Everything builds again. Now off to testing.
2008-04-02attempt to fix up all refernces to new directory structureSean Dague1-1/+1
2008-04-02whole lot more movingSean Dague1-0/+0
2008-03-18Formatting cleanup.Jeff Ames1-26/+25
2008-03-15Thank you kindly, Grumly57 for:Charles Krinke1-1/+1
Added MSSQLDataStore.cs to OpenSim.Framework.Data.MSSQL and changed it to reflect the actual capabilites of MySQLDataStore.cs
2008-03-03* More compiler warning nukage.Adam Frisby1-1/+1
2008-03-02Thank you kindly, Ahzzmandius for addingCharles Krinke1-2/+7
owner_uuid support to the MSSQL data driver.
2008-02-13* Moved insertUserRow into MSSQLUserData so 'create user' works againlbsa711-95/+1
[Provided by openlifegrid.com]
2008-02-13* Moved insertRegionRow into MSSQLGridDatalbsa711-167/+83
* Split table test and creation into table by table * Debugged table creation Sql * Added missing CreateUserFriendsTable.sql
2008-02-13* Split out MSSQLManager Test/Init into each provider.lbsa711-66/+1
* Made regions table name configurable (MSSQL only) * Added a note in ini.example pointing out that the sql resources have to change if you change table names * Removed duplicate picker method from GridData interface [Provided by openlifegrid.com]
2008-02-05Converted logging to use log4net.Jeff Ames1-7/+9
Changed LogBase to ConsoleBase, which handles console I/O. This is mostly an in-place conversion, so lots of refactoring can still be done.
2008-01-15* Mother of all commits:Adam Frisby1-6/+6
* Cleaned up copyright notices in AssemblyInfo.cs's * Added Copyright headers to a bunch of files missing them * Replaced several common string instances with a static constant to prevent reallocation of the same strings thousands of times. "" -> String.Empty is the first such candidate.
2008-01-09* Added a hashtable based HTTP processor in preparation of the web_login_keyTeravus Ovares1-3/+21
* Added the web_login_key to the users table * Added happy configurable http error message pages * This update is large enough to have 'awe' value.. so backup your users or weep. * Not tested on MSSQL, even though I added code to update the tables!
2007-12-27* Optimized usingslbsa711-127/+134
* shortened references * Removed redundant 'this' * Normalized EOF
2007-12-20Added patch from Johan. First attempt to solve the LibSL.Packet GC problem. ↵Jeff Ames1-4/+4
Works with LibSL rev>1532
2007-12-10saved OpenSim source code from the giant rampaging unterminated copyright ↵Jeff Ames1-1/+1
notice of doom
2007-12-05* Applied MSSQL Patch from akokko, Thanks! akokkoTeravus Ovares1-45/+571
* This hasn't been tested in MSSQL mode, however it's been checked to make sure it doesn't cause any issues with mySQL/SQLlite
generated by cgit v1.1 at 2024-12-18 17:35:23 +0000