aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Add migration to add "active" column on PGSQL. UNTESTED!Melanie Thielker2016-03-221-0/+6
|
* Pushed AssemblyVersion up to VersionInfo, so that we don't need to do global ↵Diva Canto2016-02-211-1/+1
| | | | replace anymore.
* Fix region data range selection in the PGSQL backend.TomDataworks2016-01-101-11/+53
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* at last we can login and see objects ( friends is dead and disable inUbitUmarov2015-09-031-3/+0
| | | | scenepresence)
* seems to compile ( tests comented out)UbitUmarov2015-09-021-0/+5
|
* bad merge?UbitUmarov2015-09-013-2/+11
|\
| * varregion: refactor use of 'double heightmap[,]' into references to new ↵Robert Adams2015-03-271-29/+43
| | | | | | | | | | | | class TerrainData and push the implementation from Scene into the database readers and writers.
| * Revert "Add support for user preferences (im via email)"Melanie2013-12-072-23/+15
| | | | | | | | This reverts commit 1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.
| * Merge branch 'master' into careminsterMelanie2013-12-072-15/+23
| |\
| * \ Merge branch 'master' into careminsterMelanie2013-12-072-3/+1
| |\ \ | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: OpenSim/Region/ClientStack/Linden/Caps/BunchOfCaps/BunchOfCaps.cs OpenSim/Region/ClientStack/Linden/UDP/LLClientView.cs OpenSim/Region/Framework/Scenes/ScenePresence.cs
| * \ \ Merge branch 'master' into careminsterMelanie2013-11-231-4/+5
| |\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: .gitignore OpenSim/Region/CoreModules/Scripting/HttpRequest/ScriptsHttpRequests.cs OpenSim/Region/CoreModules/World/Land/LandManagementModule.cs prebuild.xml runprebuild.bat
| * | | | Merge branch 'master' into careminsterMelanie2013-11-033-1/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: OpenSim/Region/CoreModules/Framework/InventoryAccess/InventoryAccessModule.cs OpenSim/Region/Framework/Scenes/SceneObjectPartInventory.cs OpenSim/Region/ScriptEngine/Shared/Api/Implementation/LSL_Api.cs
* | | | | Merged the two "Version 2" migrations in PGSQLOren Hurvitz2015-08-031-6/+0
| | | | |
* | | | | PGSL Presence migration to correct a double version 2 migration that existedGeir Nøklebye2015-08-031-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>
* | | | | PGSQL migrations for IM_Store, UserProfiles, removal of casting exception ↵Geir Nøklebye2015-07-314-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>
* | | | | Update PGSQL groups handler to accept search queries from the viewerGeir Nøklebye2015-07-263-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>
* | | | | Add quotes aroung LandFlags as PGSQL seems to choke on the word whenMelanie Thielker2015-07-231-1/+1
| | | | | | | | | | | | | | | | | | | | it's bare.
* | | | | Correcting errors in previous change: MySQL needs int unsigned, notMelanie Thielker2015-07-141-2/+2
| | | | | | | | | | | | | | | | | | | | unsigned int. PGSQL has no unsigned types, changing to bigint.
* | | | | Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker2015-07-141-0/+8
| | | | |
* | | | | Applying Gavin Hird's patch to correct PGSQL group notices. Thatk you,Melanie Thielker2015-06-261-1/+11
| | | | | | | | | | | | | | | | | | | | Gavin
* | | | | Thanks Gavin Hird for a fix for Mantis 0007604: DeleteClassifiedRecord ↵dahlia2015-06-241-123/+124
| | | | | | | | | | | | | | | | | | | | exception PGSQL
* | | | | Thanks Gavin Hird for a fix for an exception when requesting an Estate Ban ↵dahlia2015-06-241-3/+3
| | | | | | | | | | | | | | | | | | | | when using PGSQL.
* | | | | Removed the pgsql table for AgentPrefs, because it is not working. For now ↵Diva Canto2015-06-142-22/+12
| | | | | | | | | | | | | | | | | | | | the Agent Preferences feature will not work with PGSQL installations -- someone who uses PGSQL needs to send a table that works.
* | | | | Mantis #7610. Changed AgentPrefs table in PGSQL to use uuid instead of ↵Diva Canto2015-06-141-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)
* | | | | Removing the Store methods in the DB layer of AgentPreferences, as they were ↵Diva Canto2015-06-141-4/+0
| | | | | | | | | | | | | | | | | | | | simply calling the base ones.
* | | | | Quell three new warnings I introduced with AgentPrefsData, return an empty ↵Cinder2015-06-141-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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>
* | | | | SQLite and PGSQL adapters for AgentPreferencesCinder2015-06-132-0/+77
| | | | | | | | | | | | | | | | | | | | Signed-off-by: Diva Canto <diva@metaverseink.com>
* | | | | Updated all occurrences of AssemblyVersion("0.8.1.*") to ↵Diva Canto2015-04-291-1/+1
| | | | | | | | | | | | | | | | | | | | AssemblyVersion("0.8.2.*")
* | | | | Change UserProfiles so that the parcel name is used for a ProfilePick and ↵AliciaRaven2015-04-121-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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>
* | | | | Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2015-03-042-4/+2
| | | | | | | | | | | | | | | | | | | | operation is very expensive
* | | | | One more migration fixCinder2015-03-042-2/+2
| | | | | | | | | | | | | | | | | | | | Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* | | | | Chase latest change to asset description length with an update to ↵Cinder2015-03-041-1/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* | | | | Revert "Chase latest change to asset description length with an update to ↵BlueWall2015-03-041-9/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
* | | | | Chase latest change to asset description length with an update to ↵Cinder2015-03-041-1/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* | | | | Follow up to last commit, fix field lengthCinder2015-03-031-0/+4
| | | | | | | | | | | | | | | | | | | | Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* | | | | Use ToString() on uuids returned in ↵Justin Clark-Casey (justincc)2015-01-141-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
* | | | | Fix PGSQLUserProfilesData.GetUserPreferences error when no usersettings yet ↵Justin Clark-Casey (justincc)2015-01-131-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | exist by inserting missing ID parameter. Relates to http://opensimulator.org/mantis/view.php?id=7398
* | | | | Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.UpdateAvatarProperties()" This reverts commit fdecf4f610fc42205cb77c1cfa51f3e3d61cfdc9.
* | | | | Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.UpdateAvatarInterests()" This reverts commit f31feef6c16cd79772e32b57a54f5cb6924a4df3.
* | | | | Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserImageAssets()" This reverts commit bd9539c2a73901f063202bb244e556e7f6927bae.
* | | | | Revert "Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserAppData()" This reverts commit 0794a403783208fa1e137b624317f42ea65fbce7.
* | | | | Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-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...
* | | | | Fix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible ↵Justin Clark-Casey (justincc)2015-01-131-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | casts. These should be left as bools, not converted to strings. Relates to http://opensimulator.org/mantis/view.php?id=7398
* | | | | Change PGSQLUserProfilesData.UpdateUserPreferences() to directly pass the ↵Justin Clark-Casey (justincc)2015-01-131-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
* | | | | Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly ↵Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.
* | | | | Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData()Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | | | | | | | | | | | | | | | This may have been preventing it from working.
* | | | | Remove extraneous colon when setting TagId parameter in ↵Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserAppData()
* | | | | Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-2/+2
| | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserAppData()
* | | | | Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserImageAssets() This may have been preventing it from working.
* | | | | Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.UpdateAvatarInterests() This may have been preventing it from working. Relates to http://opensimulator.org/mantis/view.php?id=7398
generated by cgit v1.1 at 2024-11-09 06:27:18 +0000