aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/PGSQLSimulationData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2015-09-02seems to compile ( tests comented out)UbitUmarov1-0/+5
2015-03-27varregion: refactor use of 'double heightmap[,]' into references to new ↵Robert Adams1-29/+43
class TerrainData and push the implementation from Scene into the database readers and writers.
2014-01-28Repair database routines so they properly return null when asked forRobert Adams1-1/+5
the heighmap of a region that does not exist.
2013-11-22Fixed the update StoreRegionWindlightSettings() wasn't updating ↵Fernando Oliveira1-4/+5
regionwindlight table, raising PrimaryKey violation; Signed-off-by: Fernando Oliveira <fernando@oliveira.eti.br> Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2013-11-04varregion: remove unused terrain serialization code in SQLite and PGSQL modulesRobert Adams1-24/+0
2013-11-01varregion: push TerrainData implementation up and down the database storage ↵Robert Adams1-24/+24
stack. Implement both LoadTerrain and StoreTerrain for all DBs. Move all database blob serialization/deserialization into TerrainData.
2013-10-16varregion: update PGSQL driver for storing variable terrain size blobs.Robert Adams1-15/+30
2013-10-15* Fixes mantis #6802 Simulator crashes whist loading (lighshare enabled)fernando1-4/+4
* Please test
2013-10-12Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira1-425/+421
* 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.
2013-10-07varregion: plug in TerrainData class and modify TerrainModule and ↵Robert Adams1-30/+15
LLClientView to use same. This passes a terrain info class around rather than passing a one dimensional array thus allowing variable regions. Update the database storage for variable region sizes. This should be downward compatible (same format for 256x256 regions).
2013-09-28Remove time based terrain storage in SQLite so revision number can be usedRobert Adams1-1/+1
to denote terrain format revision. Add terrain DB format revision codes to ISimulationDataStore.cs. Setup so legacy compatible terrain storage and fetch is possible while allowing future format extensions.
2013-09-25Remove time based terrain storage in SQLite so revision number can be usedRobert Adams1-1/+1
to denote terrain format revision. Add terrain DB format revision codes to ISimulationDataStore.cs. Setup so legacy compatible terrain storage and fetch is possible while allowing future format extensions.
2013-09-22Preserve attachment point & position when attachment is rezzed in worldAleric Inglewood1-4/+13
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-06-27Make the concept of namespaces explicit in dynamic attributesJustin Clark-Casey (justincc)1-1/+1
This is in order to reduce the likelihood of naming clashes, make it easier to filter in/out attributes, ensure uniformity, etc. All dynattrs in the opensim distro itself or likely future ones should be in the "OpenSim" namespace. This does alter the underlying dynattrs data structure. All data in previous structures may not be available, though old structures should not cause errors. This is done without notice since this feature has been explicitly labelled as experimental, subject to change and has not been in a release. However, existing materials data is being preserved by moving it to the "Materials" store in the "OpenSim" namespace.
2013-02-09Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz1-3/+18
2013-01-25Store NULL in the 'DynAttrs' column if the prim doesn't have any dynamic ↵Oren Hurvitz1-1/+5
attributes
2013-01-25Stopped storing dynamic attributes in the PrimShapeOren Hurvitz1-10/+3
2013-01-25Encapsulate an OSDMap in DAMap (was DynAttrsOSDMap) rather than inheriting ↵Justin Clark-Casey (justincc)1-4/+4
from it This is the easier way to give us control over locking, rather than asking that OSDMap IDictionary methods be virtual
2013-01-25Implement dynamic attribute persistence on mysql and mssqlJustin Clark-Casey (justincc)1-6/+17
mssql is untested
2012-08-15Add a skeleton for a name value storage associated with regionsMelanie1-0/+13
2012-08-15Add a skeleton for a name value storage associated with regionsMelanie1-0/+13
2012-06-07Add the ability to query the MYSQL databse for a list of the stored prim UUIDsMelanie1-0/+5
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen1-0/+66
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-06Updates to MSSQL store for 0.7.3 to include:Chris Hart1-5/+78
* Telehub support * Bugfix to Friends lookups * Updates to Creator fields to store up to 255 characters for HG item creator storage
2012-02-29Use correct casing of RegionSettings.Sandbox in the various database modules.Justin Clark-Casey (justincc)1-2/+2
MySQL and MSSQL have it as Sandbox, sqlite as sandbox. In various different places in every plugin the wrong casing is used... Consistency, who needs it? Or one day sqlite can change to Sandbox.
2012-02-03Fix: Covenant changed time not set ↵PixelTomsen1-4/+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-6/+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-02-02Make ban, eject, freeze and the scripted versions of those work.Melanie1-6/+6
2011-09-01Remove code which was automatically deleting non-root prims from scene ↵Justin Clark-Casey (justincc)1-15/+0
objects that had previous been attachments. Looks like this code was accidentally uncommented in e1b5c612 from feb 2010. Appears to resolve the rest of http://opensimulator.org/mantis/view.php?id=5664
2011-06-01Updates to MSSQL to most recent compatibility, also included Windlight ↵Chris Hart1-14/+499
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-28Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to ↵Diva Canto1-7/+18
speed with 0.7.x.
2010-11-03Add lsClearWindlightScene() to the lightshare module to remove WL settingsMelanie1-0/+3
from a region and allow normal day cycles to be reestablished
2010-09-16Changed SceneObjectGroup to store parts with the fast and thread-safe ↵John Hurliman1-2/+2
MapAndArray collection
2010-09-12* Added ISimulationDataService and IEstateDataServiceJohn Hurliman1-0/+10
* 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-09-12Formatting cleanup.Jeff Ames1-3/+3
2010-09-11Fixed the naming mess around data connectors for simulation dataJohn Hurliman1-1/+1
2010-09-05Remove "Dwell" support from core and replace it with calls to methodsMelanie Thielker1-4/+2
on IDwellModule
2010-09-05Remove "Dwell" support from core and replace it with calls to methodsMelanie Thielker1-4/+2
on IDwellModule
2010-08-26Remove parts locking from data classes since these are using a copy of the ↵Justin Clark-Casey (justincc)1-49/+45
scene object
2010-08-26Improve consistency of locking for SOG.m_parts in order to avoid race ↵Justin Clark-Casey (justincc)1-46/+48
conditions in linking and unlinking
2010-08-13refactor: Use SOP.Flags rather than SOP.ObjectFlagsJustin Clark-Casey (justincc)1-2/+2
2010-08-04fix mysql/mssql prim serialization problemJustin Clark-Casey (justincc)1-6/+2
2010-08-03Implement MediaUrl persistence for MySQL and MsSQLJustin Clark-Casey (justincc)1-4/+10
Not sure how I forgot this. This may resolve problems with media textures not persisting over restart for these databases.
2010-08-03get rid of PrimitiveBaseShape.MediaRaw staging postJustin Clark-Casey (justincc)1-3/+5
using an OSD serialization rather than auto forces serialization code to be placed in OpenSim.Framework this makes the media texture raw data staging post in PrimitiveBaseShape redundant, now we just directly call the code in PrimitiveBaseShape.MediaList itself
2010-07-26add mssql support for media on a primJustin Clark-Casey (justincc)1-3/+7
compiles but not tested. please test and correct if necessary!
2010-07-26add mssql support for media on a primJustin Clark-Casey (justincc)1-3/+7
compiles but not tested. please test and correct if necessary!
2010-03-31Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie1-2/+11
This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
2010-03-30Rename Meta7Windlight to LightShareMelanie1-3/+3
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride1-67/+95
works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
2009-12-09Enable scripting interface for windlightunknown1-0/+4