Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.

* 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.

1 files changed, 242 insertions, 0 deletions

diff --git a/OpenSim/Data/PGSQL/Resources/GridStore.migrations b/OpenSim/Data/PGSQL/Resources/GridStore.migrations
new file mode 100644
index 0000000..0ab8d2b
--- /dev/null
+++ b/OpenSim/Data/PGSQL/Resources/GridStore.migrations
@@ -0,0 +1,242 @@
+:VERSION 1
+
+BEGIN TRANSACTION;
+
+CREATE TABLE regions(
+ "regionHandle" varchar(255) NULL,
+ "regionName" varchar(255) NULL,
+ uuid varchar(255) NOT NULL PRIMARY KEY,
+ "regionRecvKey" varchar(255) NULL,
+ "regionSecret" varchar(255) NULL,
+ "regionSendKey" varchar(255) NULL,
+ "regionDataURI" varchar(255) NULL,
+ "serverIP" varchar(255) NULL,
+ "serverPort" varchar(255) NULL,
+ "serverURI" varchar(255) NULL,
+ "locX" varchar(255) NULL,
+ "locY" varchar(255) NULL,
+ "locZ" varchar(255) NULL,
+ "eastOverrideHandle" varchar(255) NULL,
+ "westOverrideHandle" varchar(255) NULL,
+ "southOverrideHandle" varchar(255) NULL,
+ "northOverrideHandle" varchar(255) NULL,
+ "regionAssetURI" varchar(255) NULL,
+ "regionAssetRecvKey" varchar(255) NULL,
+ "regionAssetSendKey" varchar(255) NULL,
+ "regionUserURI" varchar(255) NULL,
+ "regionUserRecvKey" varchar(255) NULL,
+ "regionUserSendKey" varchar(255) NULL,
+ "regionMapTexture" varchar(255) NULL,
+ "serverHttpPort" varchar(255) NULL,
+ "serverRemotingPort" varchar(255) NULL,
+ "owner_uuid" varchar(36) NULL
+);
+
+COMMIT;
+
+
+:VERSION 2
+
+BEGIN TRANSACTION;
+
+CREATE TABLE Tmp_regions
+        (
+        uuid varchar(36) NOT NULL,
+        "regionHandle" bigint NULL,
+        "regionName" varchar(20) NULL,
+        "regionRecvKey" varchar(128) NULL,
+        "regionSendKey" varchar(128) NULL,
+        "regionSecret" varchar(128) NULL,
+        "regionDataURI" varchar(128) NULL,
+        "serverIP" varchar(64) NULL,
+        "serverPort" int NULL,
+        "serverURI" varchar(255) NULL,
+        "locX" int NULL,
+        "locY" int NULL,
+        "locZ" int NULL,
+        "eastOverrideHandle" bigint NULL,
+        "westOverrideHandle" bigint NULL,
+        "southOverrideHandle" bigint NULL,
+        "northOverrideHandle" bigint NULL,
+        "regionAssetURI" varchar(255) NULL,
+        "regionAssetRecvKey" varchar(128) NULL,
+        "regionAssetSendKey" varchar(128) NULL,
+        "regionUserURI" varchar(255) NULL,
+        "regionUserRecvKey" varchar(128) NULL,
+        "regionUserSendKey" varchar(128) NULL,
+        "regionMapTexture" varchar(36) NULL,
+        "serverHttpPort" int NULL,
+        "serverRemotingPort" int NULL,
+        "owner_uuid" varchar(36) NULL,
+        "originUUID" varchar(36) NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000')
+        );
+
+INSERT INTO Tmp_regions (uuid, "regionHandle", "regionName", "regionRecvKey", "regionSendKey", "regionSecret", "regionDataURI", "serverIP", "serverPort", "serverURI", "locX", "locY", "locZ", "eastOverrideHandle", "westOverrideHandle", "southOverrideHandle", "northOverrideHandle", "regionAssetURI", "regionAssetRecvKey", "regionAssetSendKey", "regionUserURI", "regionUserRecvKey", "regionUserSendKey", "regionMapTexture", "serverHttpPort", "serverRemotingPort", "owner_uuid")
+        SELECT cast(uuid as varchar(36)), cast("regionHandle" as bigint), cast("regionName" as varchar(20)), cast("regionRecvKey" as varchar(128)), cast("regionSendKey" as varchar(128)), cast("regionSecret" as varchar(128)), cast("regionDataURI" as varchar(128)), cast("serverIP" as varchar(64)), cast("serverPort" as int), "serverURI", cast("locX" as int), cast("locY" as int), cast("locZ" as int), cast("eastOverrideHandle" as bigint), cast("westOverrideHandle" as bigint), 
+              cast("southOverrideHandle" as bigint), cast("northOverrideHandle" as bigint), "regionAssetURI", cast("regionAssetRecvKey" as varchar(128)), cast("regionAssetSendKey" as varchar(128)), "regionUserURI", cast("regionUserRecvKey" as varchar(128)), cast("regionUserSendKey" as varchar(128)), cast("regionMapTexture" as varchar(36)), 
+              cast("serverHttpPort" as int), cast("serverRemotingPort" as int), "owner_uuid" 
+              FROM regions;
+
+DROP TABLE regions;
+
+alter table Tmp_regions
+  rename to regions;
+
+COMMIT;
+
+:VERSION 3
+
+BEGIN TRANSACTION;
+
+CREATE INDEX IX_regions_name ON regions
+        (
+        "regionName"
+        );
+
+CREATE INDEX IX_regions_handle ON regions
+        (
+        "regionHandle"
+        );
+
+
+CREATE INDEX IX_regions_override ON regions
+        (
+        "eastOverrideHandle",
+        "westOverrideHandle",
+        "southOverrideHandle",
+        "northOverrideHandle"
+        );
+
+COMMIT;
+
+
+:VERSION 4
+
+/* To prevent any potential data loss issues, you should review this script in detail before running it outside the cotext of the database designer.*/
+BEGIN TRANSACTION;
+
+CREATE TABLE Tmp_regions
+        (
+        uuid uuid NOT NULL,
+        "regionHandle" bigint NULL,
+        "regionName" varchar(20) NULL,
+        "regionRecvKey" varchar(128) NULL,
+        "regionSendKey" varchar(128) NULL,
+        "regionSecret" varchar(128) NULL,
+        "regionDataURI" varchar(128) NULL,
+        "serverIP" varchar(64) NULL,
+        "serverPort" int NULL,
+        "serverURI" varchar(255) NULL,
+        "locX" int NULL,
+        "locY" int NULL,
+        "locZ" int NULL,
+        "eastOverrideHandle" bigint NULL,
+        "westOverrideHandle" bigint NULL,
+        "southOverrideHandle" bigint NULL,
+        "northOverrideHandle" bigint NULL,
+        "regionAssetURI" varchar(255) NULL,
+        "regionAssetRecvKey" varchar(128) NULL,
+        "regionAssetSendKey" varchar(128) NULL,
+        "regionUserURI" varchar(255) NULL,
+        "regionUserRecvKey" varchar(128) NULL,
+        "regionUserSendKey" varchar(128) NULL,
+        "regionMapTexture" uuid NULL,
+        "serverHttpPort" int NULL,
+        "serverRemotingPort" int NULL,
+        "owner_uuid" uuid NOT NULL,
+        "originUUID" uuid NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000')
+        );
+        
+
+INSERT INTO Tmp_regions (uuid, "regionHandle", "regionName", "regionRecvKey", "regionSendKey", "regionSecret", "regionDataURI", "serverIP", "serverPort", "serverURI", "locX", "locY", "locZ", "eastOverrideHandle", "westOverrideHandle", "southOverrideHandle", "northOverrideHandle", "regionAssetURI", "regionAssetRecvKey", "regionAssetSendKey", "regionUserURI", "regionUserRecvKey", "regionUserSendKey", "regionMapTexture", "serverHttpPort", "serverRemotingPort", "owner_uuid", "originUUID")
+  SELECT cast(uuid as uuid), "regionHandle", "regionName", "regionRecvKey", "regionSendKey", "regionSecret", "regionDataURI", "serverIP", "serverPort", "serverURI", "locX", "locY", "locZ", "eastOverrideHandle", "westOverrideHandle", "southOverrideHandle", "northOverrideHandle", "regionAssetURI", "regionAssetRecvKey", "regionAssetSendKey", "regionUserURI", "regionUserRecvKey", "regionUserSendKey", cast("regionMapTexture" as uuid), "serverHttpPort", "serverRemotingPort", cast( "owner_uuid" as uuid), cast("originUUID" as uuid) FROM regions ;
+  
+
+DROP TABLE regions;
+
+alter table Tmp_regions rename to regions;
+
+ALTER TABLE regions ADD CONSTRAINT
+        PK__regions__uuid PRIMARY KEY 
+        (
+        uuid
+        );
+
+CREATE INDEX IX_regions_name ON regions
+        (
+        "regionName"
+        );
+
+CREATE INDEX IX_regions_handle ON regions
+        (
+        "regionHandle"
+        );
+
+CREATE INDEX IX_regions_override ON regions
+        (
+        "eastOverrideHandle",
+        "westOverrideHandle",
+        "southOverrideHandle",
+        "northOverrideHandle"
+        );
+
+COMMIT;
+
+
+:VERSION 5
+
+BEGIN TRANSACTION;
+
+ALTER TABLE regions ADD access int default 0;
+
+COMMIT;
+
+
+:VERSION 6
+
+BEGIN TRANSACTION;
+
+ALTER TABLE regions ADD "ScopeID" uuid default '00000000-0000-0000-0000-000000000000';
+ALTER TABLE regions alter column "owner_uuid" set DEFAULT ('00000000-0000-0000-0000-000000000000');
+ALTER TABLE regions ADD "sizeX" integer not null default 0;
+ALTER TABLE regions ADD "sizeY" integer not null default 0;
+
+COMMIT;
+
+
+:VERSION 7
+
+BEGIN TRANSACTION;
+
+ALTER TABLE regions ADD "flags" integer NOT NULL DEFAULT 0;
+CREATE INDEX flags ON regions("flags");
+ALTER TABLE regions ADD "last_seen" integer NOT NULL DEFAULT 0;
+ALTER TABLE regions ADD "PrincipalID" uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
+ALTER TABLE regions ADD "Token" varchar(255) NOT NULL DEFAULT 0;
+
+COMMIT;
+
+:VERSION 8
+
+BEGIN TRANSACTION;
+ALTER TABLE regions ALTER COLUMN "regionName" type VarChar(128) ;
+
+DROP INDEX IX_regions_name;
+ALTER TABLE regions ALTER COLUMN "regionName" type VarChar(128),
+  ALTER COLUMN "regionName" SET NOT NULL;
+
+CREATE INDEX IX_regions_name ON regions
+        (
+        "regionName"
+        );
+
+COMMIT;
+
+:VERSION 9
+
+BEGIN TRANSACTION;
+
+ALTER TABLE regions ADD "parcelMapTexture" uuid NULL;
+
+COMMIT;
+