aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2015-03-27varregion: refactor use of 'double heightmap[,]' into references to new ↵Robert Adams1-34/+49
class TerrainData and push the implementation from Scene into the database readers and writers.
2014-11-28Remove unmaintained MSSQL support.Justin Clark-Casey (justincc)29-9116/+0
This has not been maintained for more than 2 years, is unimplemented for newer features (e.g. built-in groups) and has no core developers using it. If somebody fixes these issues then it could be reinstated.
2014-06-17Change assembly versions to 0.8.1Justin Clark-Casey (justincc)1-1/+1
2014-04-23Eliminated many warningsOren Hurvitz1-2/+2
2014-04-22Changed the maximum asset name and description lengths to constants. Also, ↵Oren Hurvitz1-4/+4
pre-truncate the description of dynamic textures.
2014-04-21Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz1-3/+11
2014-04-02Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz1-7/+28
list of assets exist. This method is used to optimize sending assets with embedded assets: e.g., when a Hypergrid visitor takes an item into the inventory.
2014-03-26Fix MSSQLInventoryHandler.IncreementFolderVersion where sql accidentally ↵Justin Clark-Casey (justincc)1-1/+1
used a MySQL style ?folderID insted of @folderID Thanks to LuciusSirnah in http://opensimulator.org/mantis/view.php?id=7075 for this fix
2014-03-26Add MSSQL EstateStore.migrations VERSION 10 transaction to add ↵Justin Clark-Casey (justincc)1-0/+8
AllowLandMark, AllowParcelChanges and AllowSetHome columns to estate_settings table. Taken from http://opensimulator.org/mantis/view.php?id=7074 by LuciusSirnah. Thanks!
2014-03-26Fix extra physics params MSSQL migration (version 39).Justin Clark-Casey (justincc)1-5/+5
This was failing because it used MySQL syntax This is taken from Lucius Sirnah's entry in http://opensimulator.org/mantis/view.php?id=6593 But with the column existence checking removed, as this should not be necessary in a migration and is inconsistent with all other migrations, though I can see a case for doing it.
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-01varregion: push TerrainData implementation up and down the database storage ↵Robert Adams1-30/+32
stack. Implement both LoadTerrain and StoreTerrain for all DBs. Move all database blob serialization/deserialization into TerrainData.
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-10-04Bump OPenSimulator version and assembly versions up to 0.8.0 DevJustin Clark-Casey (justincc)1-1/+1
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 Inglewood2-4/+25
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-09-02Allow one to specify a DefaultHGRegion flag in [GridService] in order to ↵Justin Clark-Casey (justincc)1-0/+5
allow different default regions for HG and direct grid logins. This requires a new GridService.GetDefaultHypergridRegions() so ROBUST services require updating but not simulators. This method still returns regions flagged with just DefaultRegion after any DefaultHGRegions, so if no DefaultHGRegions are specified then existing configured defaults will still work. Immediate use is for conference where we need to be able to specify different defaults However, this is also generally useful to send experienced HG users to one default location and local users whose specified region fails (e.g. no "home" or "last") to another.
2013-07-02Fix SQL statementDiva Canto1-1/+1
2013-07-02Do the same for SQLite and MSSQLDiva Canto1-1/+1
2013-07-02This should have a strong effect on the Unknown User issue mantis #6625Diva Canto1-1/+6
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-04-02Change recent MSSQL migrations to drop COLUMN from ALTER TABLE which is ↵Justin Clark-Casey (justincc)1-6/+6
either not syntactical or unnecessary. May fix http://opensimulator.org/mantis/view.php?id=6593
2013-02-27Add more information to warnings logged when asset names and descriptions ↵Justin Clark-Casey (justincc)1-2/+6
have to be truncated for database storage On balance, I still think this is useful because asset names and descriptions can sometimes be helpful in determining what things are. Even though they are never subsequently (inventory names/descriptions are always used instead).
2013-02-19Deleted all AssemblyFileVersion directivesDiva Canto1-1/+1
2013-02-09Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz2-3/+30
2013-02-05Bump version and assembly version numbers from 0.7.5 to 0.7.6Justin Clark-Casey (justincc)1-1/+1
This is mostly Bluewall's work but I am also bumping the general version number OpenSimulator 0.7.5 remains in the release candidate stage. I'm doing this because master is significantly adding things that will not be in 0.7.5 This update should not cause issues with existing external binary DLLs because our DLLs do not have strong names and so the exact version match requirement is not in force.
2013-02-01Revert "Update assembly version numbers"BlueWall1-1/+1
This reverts commit 141ad829f448b9138b12be7cf99c834c1f3977ec.
2013-02-01Update assembly version numbersBlueWall1-1/+1
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 Hurvitz2-11/+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)2-6/+26
mssql is untested
2012-12-09Restrict IPresenceData.VerifyAgentBlueWall1-5/+7
Restrict IPresenceData.VerifyAgent to only return bool result
2012-12-08Add agent verification to PresenceBlueWall1-0/+11
2012-11-15Revert "Merge master into teravuswork", it should have been avination, not ↵teravus1-1/+0
master. This reverts commit dfac269032300872c4d0dc507f4f9062d102b0f4, reversing changes made to 619c39e5144f15aca129d6d999bcc5c34133ee64.
2012-11-15refactor: move common inventory folder version update code to parent class ↵Justin Clark-Casey (justincc)1-38/+9
in mysql, mssql and sqlite database plugins
2012-11-15Improve inventory folder version updating for mssql database plugin.Justin Clark-Casey (justincc)1-14/+102
I am not in a position to test this so the updates have been done blind. If it needs any fixing will probably require patches.
2012-11-13Updated all existing AssemblyVersions's to 0.7.5.*. Many DLLs still don't ↵Diva Canto1-1/+1
have an AssemblyInfo file.
2012-11-09Update parent inventory folder version numbers when folders are ↵Justin Clark-Casey (justincc)1-42/+86
moved/created/deleted to match version numbers cached by viewers. This is done in the way that one would expect (e.g. moving a folder increments version number on both source and destination parent folders). This should hopefully improve viewer reuse of its cached inventory information. Currently MySQL only but will be implement for SQLite/MSSQL if there are no issues.
2012-10-09Move OpenSim.Data.RegionFlags -> OpenSim.Framework.RegionFlags to make it ↵Justin Clark-Casey (justincc)1-0/+1
easier for other code to use (e.g. LSL_Api) without having to reference OpenSim.Data just for this.
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: ↵PixelTomsen2-0/+80
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-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
2012-03-06Updates to MSSQL store for 0.7.3 to include:Chris Hart4-7/+169
* 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-14Fix: MSSQLDB Grid - unable to register region ↵PixelTomsen1-1/+8
http://opensimulator.org/mantis/view.php?id=5886
2012-02-14Revert "Add GridStore migration for MSSQL."Justin Clark-Casey (justincc)1-8/+0
This reverts commit 0b17a66e683f7ffca3877c1601c4179684b62144.