aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* fix some odd sql queries ap not in useUbitUmarov2018-01-121-1/+1
|
* mantis 8200: move changes in PGSQL from last commit to a new transaction (13)UbitUmarov2017-11-121-10/+15
|
* PGSQL EstateStore create estate_settings_id SEQUENCETomTheDragon2017-11-121-0/+10
| | | | | | | Missing creation for estate_settings_id sequence causes first run to fail unless manually added. Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* Add a new experimental implementation of PGSQL FSAssetsTomTheDragon2017-11-032-0/+330
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* PGSQL: Another missing cast in XInventoryDataGeir Nøklebye2017-05-221-1/+1
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* fix passcollisions bool value on storeUbitUmarov2017-05-131-2/+2
|
* PGSQL: Convert PassCollision in table prims to bool to avoid a hopeless cast ↵Geir Nøklebye2017-05-132-3/+18
| | | | | | that fails with newer versions of NPGSQL. Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* PGSQL: Rewrote EstateStore.migrations as it errored out in version 8 leaving ↵Geir Nøklebye2017-05-091-299/+104
| | | | | | the database without any estate tables on first run. It also lacked primary keys on estate_map and estate_settings. Syntax requires Postgresql 9.5 or higher. Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* PGSQL: Add missing AgentPrefs.migrationsGeir Nøklebye2017-05-081-0/+19
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* GZipStream does have a CopyTo()UbitUmarov2017-05-061-9/+9
|
* dispose some MemoryStreamsUbitUmarov2017-05-061-4/+6
|
* store the physics inertia override in the databaseGeir Nøklebye2017-04-202-4/+22
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* update for The new Constant: integer OBJECT_REZZER_KEY = 32 + adding missing ↵Geir Nøklebye2017-04-192-5/+37
| | | | | | support for fields in the prims table. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* PGSQL: Fixed a failing query in GroupsData for deleting groups messages ↵Geir Nøklebye2017-04-191-2/+2
| | | | | | older than 14 days. The little known abstime function could be used for a double cast. The field TMStamp should be changed to store the data as a proper timestamp. Related to Mantis #7848. Usually this would easily be solved using the to_timestamp function, but there is no support for it in NPGSQL as there are no very close functionality in .NET Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* Massive tab and trailing space cleanupMelanie Thielker2017-01-0518-197/+197
|
* PGSQL fixed a missing cast to uuid in XInventoryDataGeir Nøklebye2017-01-041-1/+1
| | | | Signed-off-by: Melanie Thielker <melanie@t-data.com>
* fix a typo in dbs region rangeUbitUmarov2016-12-011-1/+1
|
* revert changes to asset desc size, my bad.. this field will possible go ↵UbitUmarov2016-11-241-5/+5
| | | | away in future
* change asset description max sizeUbitUmarov2016-11-221-5/+5
|
* fix some invalid string.format argumentsUbitUmarov2016-11-091-1/+10
|
* add load baked terrain methodsUbitUmarov2016-09-171-0/+33
|
* add to databases a table to store baked terrain.UbitUmarov2016-09-172-0/+56
|
* workaround potencial memory leaksUbitUmarov2016-08-221-25/+27
|
* 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.
generated by cgit v1.1 at 2024-12-27 19:46:01 +0000