1 files changed, 14 insertions, 13 deletions

diff --git a/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations b/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations
index 2615ca2..6154719 100644
--- a/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations
+++ b/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations
@@ -1,17 +1,18 @@
-:VERSION 1
+:VERSION 2
 
-BEGIN;
+BEGIN TRANSACTION;
 
-CREATE TABLE `AgentPrefs` (
-    `PrincipalID` CHAR(36) NOT NULL,
-    `AccessPrefs` CHAR(2) NOT NULL DEFAULT 'M',
-    `HoverHeight` DOUBLE(30, 27) NOT NULL DEFAULT 0,
-    `Language` CHAR(5) NOT NULL DEFAULT 'en-us',
-    `LanguageIsPublic` BOOLEAN NOT NULL DEFAULT 1,
-    `PermEveryone` INT(6) NOT NULL DEFAULT 0,
-    `PermGroup` INT(6) NOT NULL DEFAULT 0,
-    `PermNextOwner` INT(6) NOT NULL DEFAULT 532480,
-    UNIQUE KEY `PrincipalID` (`PrincipalID`),
-    PRIMARY KEY(`PrincipalID`));
+DROP TABLE IF EXISTS "AgentPrefs";
+CREATE TABLE "AgentPrefs" (
+    "PrincipalID" uuid NOT NULL,
+    "AccessPrefs" CHAR(2) NOT NULL DEFAULT 'M',
+    "HoverHeight" DOUBLE PRECISION NOT NULL DEFAULT 0,
+    "Language" CHAR(5) NOT NULL DEFAULT 'en-us',
+    "LanguageIsPublic" BOOLEAN NOT NULL DEFAULT true,
+    "PermEveryone" INT4 NOT NULL DEFAULT 0,
+    "PermGroup" INT4 NOT NULL DEFAULT 0,
+    "PermNextOwner" INT4 NOT NULL DEFAULT 532480
+    );
+    ALTER TABLE "AgentPrefs" ADD PRIMARY KEY("PrincipalID");    
 
 COMMIT;
\ No newline at end of file