From be68f4852ce0f754e425f6e158df0f7c7fcb33f5 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Sun, 14 Jun 2015 09:30:55 -0700
Subject: Mantis #7610. Changed AgentPrefs table in PGSQL to use uuid instead
 of 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)

---
 OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | 27 +++++++++++-----------
 1 file changed, 14 insertions(+), 13 deletions(-)

(limited to 'OpenSim/Data')

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
-- 
cgit v1.1