aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/Resources (follow)
Commit message (Collapse)AuthorAgeFilesLines
* 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-031-0/+14
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* PGSQL: Convert PassCollision in table prims to bool to avoid a hopeless cast ↵Geir Nøklebye2017-05-131-0/+14
| | | | | | 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>
* store the physics inertia override in the databaseGeir Nøklebye2017-04-201-0/+7
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* update for The new Constant: integer OBJECT_REZZER_KEY = 32 + adding missing ↵Geir Nøklebye2017-04-191-0/+9
| | | | | | support for fields in the prims table. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* add to databases a table to store baked terrain.UbitUmarov2016-09-171-0/+13
|
* 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)
* Add migration to add "active" column on PGSQL. UNTESTED!Melanie Thielker2016-03-221-0/+6
|
* at last we can login and see objects ( friends is dead and disable inUbitUmarov2015-09-031-3/+0
| | | | scenepresence)
* bad merge?UbitUmarov2015-09-011-1/+4
|\
| * Revert "Add support for user preferences (im via email)"Melanie2013-12-071-9/+0
| | | | | | | | This reverts commit 1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.
* | 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-312-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>
* | Update PGSQL groups handler to accept search queries from the viewerGeir Nøklebye2015-07-261-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>
* | 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
* | Removed the pgsql table for AgentPrefs, because it is not working. For now ↵Diva Canto2015-06-141-18/+0
| | | | | | | | 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)
* | SQLite and PGSQL adapters for AgentPreferencesCinder2015-06-131-0/+17
| | | | | | | | Signed-off-by: Diva Canto <diva@metaverseink.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>
* | Experimental XAssets Module PgSQL Adapter: Remove unused migration. Syntax ↵BlueWall2014-10-161-19/+0
| | | | | | | | error preventing migration from running.
* | Touchup PgSQL XAssets adapterBlueWall2014-10-151-0/+10
| |
* | Fix PgSQL adapter for UserProfilesBlueWall2014-10-151-1/+55
| |
* | Get V2 Groups working under PgSQL. Needed to re-create tables to satisy the ↵BlueWall2014-10-121-0/+107
| | | | | | | | generic handler type matching. There should be no existing data because it couldn't complete the first migration as-is.
* | Make column names lower-case, change hash column type to bytea and remove ↵BlueWall2014-10-121-0/+45
| | | | | | | | old commented lines of code
* | Fix some errors in PgSQL XAssets by changing some data types. Also make sql ↵BlueWall2014-10-101-0/+12
|/ | | | query syntax more in line with the PgSQL AssetData implementation.
* Add support for user preferences (im via email)BlueWall2013-12-061-0/+9
|
* * Fixes mantis #6802 Simulator crashes whist loading (lighshare enabled)fernando2013-10-152-0/+27
| | | | * Please test
* Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira2013-10-1218-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-27 03:01:28 +0000