aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2019-08-19change PGSQL migrationUbitUmarov1-3/+3
2019-08-18try to update PGSQL estatebanUbitUmarov1-0/+8
2018-12-28PGSQL: it may be a good idea to also add the field to the tableUbitUmarov1-0/+7
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 FSAssetsTomTheDragon1-0/+14
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-13PGSQL: Convert PassCollision in table prims to bool to avoid a hopeless cast ↵Geir Nøklebye1-0/+14
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-04-20store the physics inertia override in the databaseGeir Nøklebye1-0/+7
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-04-19update for The new Constant: integer OBJECT_REZZER_KEY = 32 + adding missing ↵Geir Nøklebye1-0/+9
support for fields in the prims table. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2016-09-17 add to databases a table to store baked terrain.UbitUmarov1-0/+13
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-03-22Add migration to add "active" column on PGSQL. UNTESTED!Melanie Thielker1-0/+6
2015-09-03 at last we can login and see objects ( friends is dead and disable inUbitUmarov1-3/+0
scenepresence)
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øklebye2-0/+28
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øklebye1-0/+8
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-14Removed the pgsql table for AgentPrefs, because it is not working. For now ↵Diva Canto1-18/+0
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-13SQLite and PGSQL adapters for AgentPreferencesCinder1-0/+17
Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-03-04Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2-4/+2
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 ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-04Revert "Chase latest change to asset description length with an update to ↵BlueWall1-9/+1
XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-03Follow up to last commit, fix field lengthCinder1-0/+4
Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2014-10-16Experimental XAssets Module PgSQL Adapter: Remove unused migration. Syntax ↵BlueWall1-19/+0
error preventing migration from running.
2014-10-15Touchup PgSQL XAssets adapterBlueWall1-0/+10
2014-10-15Fix PgSQL adapter for UserProfilesBlueWall1-1/+55
2014-10-12Get V2 Groups working under PgSQL. Needed to re-create tables to satisy the ↵BlueWall1-0/+107
generic handler type matching. There should be no existing data because it couldn't complete the first migration as-is.
2014-10-12Make column names lower-case, change hash column type to bytea and remove ↵BlueWall1-0/+45
old commented lines of code
2014-10-10Fix some errors in PgSQL XAssets by changing some data types. Also make sql ↵BlueWall1-0/+12
query syntax more in line with the PgSQL AssetData implementation.
2013-12-07Revert "Add support for user preferences (im via email)"Melanie1-9/+0
This reverts commit 1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.
2013-12-06Add support for user preferences (im via email)BlueWall1-0/+9
2013-10-15* Fixes mantis #6802 Simulator crashes whist loading (lighshare enabled)fernando2-0/+27
* Please test
2013-10-12Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira18-0/+2933
* Added PostGreSQL support * Added MySQL/MySQLXGroupData.cs * PostgreSQL data access implementation * PostgreSQL dll binarie and RegionStore.migrations * Migrations Scripts from MSSQL to POSTGRES * Postgres SQL Type fixes * Postgres SQL Connection string * Data type issues * more fixes * tests and +tests * UUID x string - FIGHT! * Fixed PG types to internal csharp types * More data type fix (PostgreSQL fields are case sensitive) :( * more field case sensitive fixes * changed the migration files to be case sensitive for fields. * fixed fields case * finished converting, now search for hidden bugs. * some more fixes * bool type fixed * more case fixes; * creatorID case fixed * case fields fixed * fixed default now() for TMStamp fields with don't allow nulls. * fix case sensitve for Region name and Estate name * fixed case for names for search * fix class name Error * Bug fixed on select and migrations * Un-Reverting my change due to Postgres issue with the ILIKE function * Fixed some issued for Diva Distro * Fixes for integration with Diva Distro * Added System.Core to prebuild.xml for PG project * Configured to make DIff for Push to OpenSim Project * Diffs only to PostgreSQL mods.
generated by cgit v1.1 at 2024-12-19 18:05:36 +0000