aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2018-01-12fix some odd sql queries ap not in useUbitUmarov1-1/+1
2017-11-12mantis 8200: move changes in PGSQL from last commit to a new transaction (13)UbitUmarov1-10/+15
2017-11-12PGSQL EstateStore create estate_settings_id SEQUENCETomTheDragon1-0/+10
Missing creation for estate_settings_id sequence causes first run to fail unless manually added. Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-11-03Add a new experimental implementation of PGSQL FSAssetsTomTheDragon2-0/+330
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-22PGSQL: Another missing cast in XInventoryDataGeir Nøklebye1-1/+1
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-13fix passcollisions bool value on storeUbitUmarov1-2/+2
2017-05-13PGSQL: Convert PassCollision in table prims to bool to avoid a hopeless cast ↵Geir Nøklebye2-3/+18
that fails with newer versions of NPGSQL. Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-09PGSQL: Rewrote EstateStore.migrations as it errored out in version 8 leaving ↵Geir Nøklebye1-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>
2017-05-08PGSQL: Add missing AgentPrefs.migrationsGeir Nøklebye1-0/+19
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-06 GZipStream does have a CopyTo()UbitUmarov1-9/+9
2017-05-06 dispose some MemoryStreamsUbitUmarov1-4/+6
2017-04-20store the physics inertia override in the databaseGeir Nøklebye2-4/+22
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-04-19update for The new Constant: integer OBJECT_REZZER_KEY = 32 + adding missing ↵Geir Nøklebye2-5/+37
support for fields in the prims table. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2017-04-19PGSQL: Fixed a failing query in GroupsData for deleting groups messages ↵Geir Nøklebye1-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>
2017-01-05Massive tab and trailing space cleanupMelanie Thielker18-197/+197
2017-01-04PGSQL fixed a missing cast to uuid in XInventoryDataGeir Nøklebye1-1/+1
Signed-off-by: Melanie Thielker <melanie@t-data.com>
2016-12-01 fix a typo in dbs region rangeUbitUmarov1-1/+1
2016-11-24 revert changes to asset desc size, my bad.. this field will possible go ↵UbitUmarov1-5/+5
away in future
2016-11-22change asset description max sizeUbitUmarov1-5/+5
2016-11-09fix some invalid string.format argumentsUbitUmarov1-1/+10
2016-09-17 add load baked terrain methodsUbitUmarov1-0/+33
2016-09-17 add to databases a table to store baked terrain.UbitUmarov2-0/+56
2016-08-22workaround potencial memory leaksUbitUmarov1-25/+27
2016-07-15PGSQL: Update simulation data with a number of missing fields for parcels. ↵Geir Nøklebye2-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>
2016-04-25POSTGRES: Update database migrations to be in accordance with MySQL table ↵Geir Nøklebye3-1/+39
definitions. Prerequisite for fixing PGSQLSimulationdata Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7846)
2016-04-25Updated the code to handle Agent Preferences. Thanks to TomDataworks for ↵Geir Nøklebye2-13/+5
providing a final solution. Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7610)
2016-04-25Fix Mantis #7805, table handler needs to look for all unique constraints.TomDataworks1-21/+16
Signed-off-by: Kevin Cozens <kevin@ve3syb.ca>
2016-04-25POSTGRES: Added check for Heightfield not equal to Database NULL.. Mirrors ↵Geir Nøklebye1-2/+7
OpenSim commit 50d738 Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7845)
2016-03-22Add migration to add "active" column on PGSQL. UNTESTED!Melanie Thielker1-0/+6
2016-02-21Pushed AssemblyVersion up to VersionInfo, so that we don't need to do global ↵Diva Canto1-1/+1
replace anymore.
2016-01-10Fix region data range selection in the PGSQL backend.TomDataworks1-11/+53
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2015-09-03 at last we can login and see objects ( friends is dead and disable inUbitUmarov1-3/+0
scenepresence)
2015-09-02seems to compile ( tests comented out)UbitUmarov1-0/+5
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 Thielker1-2/+2
unsigned int. PGSQL has no unsigned types, changing to bigint.
2015-07-14Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker1-0/+8
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 Canto1-4/+0
simply calling the base ones.
2015-06-14Quell three new warnings I introduced with AgentPrefsData, return an empty ↵Cinder1-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>
2015-06-13SQLite and PGSQL adapters for AgentPreferencesCinder2-0/+77
Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-04-29Updated all occurrences of AssemblyVersion("0.8.1.*") to ↵Diva Canto1-1/+1
AssemblyVersion("0.8.2.*")
2015-04-12Change UserProfiles so that the parcel name is used for a ProfilePick and ↵AliciaRaven1-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>
generated by cgit v1.1 at 2024-12-23 18:49:05 +0000