aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/Resources (follow)
Commit message (Collapse)AuthorAgeFilesLines
* 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-28 22:55:15 +0000