aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* PGSQL: Update simulation data with a number of missing fields for parcels. ↵Geir Nøklebye2016-07-152-6/+24
| | | | | | Some of the fields should probably be migrated to type Boolean to avoid the hairy casting in the query. In addition the overall server code relies in the Replace in SQL statement that is proprietary to MySQL, so the PGSQL code is rather unsafe as it is. Should probably set a transaction on the whole operation so that if something goes wrong the database record is not zapped as it is now. PostgreSQL 9.5 has the upsert functionality which would bring the code closer to the MySQL version. This commit also has an update to PGSQLRegionData Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* POSTGRES: Update database migrations to be in accordance with MySQL table ↵Geir Nøklebye2016-04-253-1/+39
| | | | | | definitions. Prerequisite for fixing PGSQLSimulationdata Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7846)
* Updated the code to handle Agent Preferences. Thanks to TomDataworks for ↵Geir Nøklebye2016-04-252-13/+5
| | | | | | providing a final solution. Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7610)
* Fix Mantis #7805, table handler needs to look for all unique constraints.TomDataworks2016-04-251-21/+16
| | | | Signed-off-by: Kevin Cozens <kevin@ve3syb.ca>
* POSTGRES: Added check for Heightfield not equal to Database NULL.. Mirrors ↵Geir Nøklebye2016-04-251-2/+7
| | | | | | OpenSim commit 50d738 Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7845)
* 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.
generated by cgit v1.1 at 2024-12-23 02:37:19 +0000