aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2015-08-03Merged the two "Version 2" migrations in PGSQLOren Hurvitz1-6/+0
2015-08-03PGSL Presence migration to correct a double version 2 migration that existedGeir Nøklebye1-0/+10
The migration file had a version 2 migration defined twice and therefore the LastSeen field most likely never was defined in the presence file. This migration adds the field and migrates the table to version 4. Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-07-31PGSQL migrations for IM_Store, UserProfiles, removal of casting exception ↵Geir Nøklebye4-1/+33
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>
2015-07-26Update PGSQL groups handler to accept search queries from the viewerGeir Nøklebye3-17/+26
Update PGSQL groups handler to accept search queries from the viewer. Fixed malformed query strings. Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-07-23Add quotes aroung LandFlags as PGSQL seems to choke on the word whenMelanie Thielker1-1/+1
it's bare.
2015-07-14Correcting errors in previous change: MySQL needs int unsigned, notMelanie Thielker2-3/+3
unsigned int. PGSQL has no unsigned types, changing to bigint.
2015-07-14Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker2-0/+16
2015-07-12Bringing FSAssets more inline with current OpenSim standards. * If no ↵AliciaRaven3-25/+147
connection string found in assets config, fallback to using default database config * Create database storage interface to allow other db connectors to be written at some point * Add MySQL migrations file to create the initial db table * Added new config option named DaysBetweenAccessTimeUpdates to reduce db load by only updating access times when fetching assets if the last access time was over the threshold. This idea was taken from XAssets service. * Change log message headers to indicate FS assets is the source not just assets Signed-off-by: Melanie Thielker <melanie@t-data.com>
2015-07-11Some cleanup, add prebuild project, correct pathMelanie Thielker1-4/+0
2015-07-11Rename for uniformity, add data moduleMelanie Thielker1-0/+361
2015-06-26Applying Gavin Hird's patch to correct PGSQL group notices. Thatk you,Melanie Thielker1-1/+11
Gavin
2015-06-24Thanks Gavin Hird for a fix for Mantis 0007604: DeleteClassifiedRecord ↵dahlia1-123/+124
exception PGSQL
2015-06-24Thanks Gavin Hird for a fix for an exception when requesting an Estate Ban ↵dahlia1-3/+3
when using PGSQL.
2015-06-14Removed the pgsql table for AgentPrefs, because it is not working. For now ↵Diva Canto2-22/+12
the Agent Preferences feature will not work with PGSQL installations -- someone who uses PGSQL needs to send a table that works.
2015-06-14Mantis #7610. Changed AgentPrefs table in PGSQL to use uuid instead of ↵Diva Canto1-13/+14
varchar(36), to be consistent with the otehr pgsql tables. Since the first commit on this was yesterday, there's no migration; instead, the version starts at 2. If anyone created the table yesterday, it will be dropped and recreated. WARNING: untested. (I don't use pg)
2015-06-14Removing the Store methods in the DB layer of AgentPreferences, as they were ↵Diva Canto3-13/+0
simply calling the base ones.
2015-06-14Quell three new warnings I introduced with AgentPrefsData, return an empty ↵Cinder3-6/+6
llsd map instead of an empty llsd block when no AgentPrefs service is available to try and appease Firestorm Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13AgentPreferences SQLLite Migration update Mantis #7157Roger Kirkman1-0/+19
Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13SQLite and PGSQL adapters for AgentPreferencesCinder4-0/+158
Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13Refactor AgentPreferences so that database operations happen centrally. the ↵Cinder2-26/+4
opensim way. Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13Relicense AgentPreferences files to BSD and OpenSimulatorCinder2-48/+48
Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13Support for Linden AgentPreferences capability and friends ↵Cinder3-0/+147
(UpdateAgentLanguage and UpdateAgentInformation) and Mantis #7157 Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-04-29Updated all occurrences of AssemblyVersion("0.8.1.*") to ↵Diva Canto5-5/+5
AssemblyVersion("0.8.2.*")
2015-04-12Change UserProfiles so that the parcel name is used for a ProfilePick and ↵AliciaRaven3-6/+8
not the parcel owners name. This change also fixes a bug where if the avatar enters and does not move, creating or editing a ProfilePick would set the parcelId as an empty UUID. This is because ScenePresence.currentParcelUUID is not set until the avatar moves. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2015-03-04Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall4-8/+4
operation is very expensive
2015-03-04One more migration fixCinder2-2/+2
Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-04Chase latest change to asset description length with an update to ↵Cinder2-2/+18
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-04Revert "Chase latest change to asset description length with an update to ↵BlueWall2-18/+2
XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
2015-03-04Chase latest change to asset description length with an update to ↵Cinder2-2/+18
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-03Follow up to last commit, fix field lengthCinder2-0/+7
Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-01-14Use ToString() on uuids returned in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.GetUserImageAssets(). These are Guids rather than strings so casting to string generates a casting exception. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Fix PGSQLUserProfilesData.GetUserPreferences error when no usersettings yet ↵Justin Clark-Casey (justincc)1-0/+1
exist by inserting missing ID parameter. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarProperties()" This reverts commit fdecf4f610fc42205cb77c1cfa51f3e3d61cfdc9.
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarInterests()" This reverts commit f31feef6c16cd79772e32b57a54f5cb6924a4df3.
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.GetUserImageAssets()" This reverts commit bd9539c2a73901f063202bb244e556e7f6927bae.
2015-01-13Revert "Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)1-2/+2
PGSQLUserProfilesData.GetUserAppData()" This reverts commit 0794a403783208fa1e137b624317f42ea65fbce7.
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.SetUserAppData()" This reverts commit 59c0df962a9dcac896cae2ce9b908be37047825c. This is necessary to preserve the casing of column names, otherwise pgsql converts everything to lowercase. TIL, Unlike mysql, a quoted column still refers to the column itself...
2015-01-13Fix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible ↵Justin Clark-Casey (justincc)1-3/+3
casts. These should be left as bools, not converted to strings. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Change PGSQLUserProfilesData.UpdateUserPreferences() to directly pass the ↵Justin Clark-Casey (justincc)1-1/+1
UUID to the uuid parameter instead of its ToString() This may well be the cause behind "operator does not exist: uuid = character varying" pgsql errors. If so, the other instances will also be changed. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly ↵Justin Clark-Casey (justincc)2-2/+2
set the UserId parameter instead of the non-existing Id parameter when writing a record because none yet exists. SQLite version is already correct for this.
2015-01-13Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData()Justin Clark-Casey (justincc)1-5/+5
This may have been preventing it from working.
2015-01-13Remove extraneous colon when setting TagId parameter in ↵Justin Clark-Casey (justincc)1-1/+1
PGSQLUserProfilesData.GetUserAppData()
2015-01-13Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)1-2/+2
PGSQLUserProfilesData.GetUserAppData()
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.GetUserImageAssets() This may have been preventing it from working.
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarInterests() This may have been preventing it from working. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarProperties() This may have been preventing it from working.
2015-01-13Remove quotes from column selection in PGSQLUserProfilesData.GetAvatarNotes()Justin Clark-Casey (justincc)1-1/+1
This may have been preventing it from working.
2015-01-13Remove quotes from field selection in PGSQLUserProfilesData.GetAvatarPicks()Justin Clark-Casey (justincc)1-1/+1
This may have been preventing it from working.
2015-01-13minor: correct two exception messages in PGSQLUserProfilesData where I ↵Justin Clark-Casey (justincc)1-2/+2
copy/pasted AgentInterestsUpdate twice
2015-01-12Remove the locking in PGSQLUserProfilesData which was buggy (Lock object ↵Justin Clark-Casey (justincc)1-30/+9
wasn't set!) and is unnecessary. Relates to http://opensimulator.org/mantis/view.php?id=7398
generated by cgit v1.1 at 2024-11-17 00:23:10 +0000