From 1de8c3570d0c8d18c181286334de81bf436dfbb4 Mon Sep 17 00:00:00 2001
From: Geir Nøklebye
Date: Mon, 27 Jul 2015 14:25:28 +0200
Subject: PGSQL migrations for IM_Store, UserProfiles, removal of casting
 exception 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>
---
 OpenSim/Data/PGSQL/Resources/IM_Store.migrations | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'OpenSim/Data/PGSQL/Resources/IM_Store.migrations')

diff --git a/OpenSim/Data/PGSQL/Resources/IM_Store.migrations b/OpenSim/Data/PGSQL/Resources/IM_Store.migrations
index 70dc011..eb97824 100644
--- a/OpenSim/Data/PGSQL/Resources/IM_Store.migrations
+++ b/OpenSim/Data/PGSQL/Resources/IM_Store.migrations
@@ -24,3 +24,22 @@ DELETE FROM `migrations` WHERE name='diva_im_Store';
 */
 
 COMMIT;
+
+:VERSION 3         # -------------------------- 
+
+BEGIN;
+
+-- dropping the table here as there most likely is only one record in the table at the time of migration
+
+DROP TABLE IF EXISTS "public"."im_offline";
+CREATE TABLE "public"."im_offline" (
+	"ID" serial,
+	"PrincipalID" uuid NOT NULL,
+	"Message" text NOT NULL COLLATE "default",
+	"TMStamp" timestamp(6) NOT NULL DEFAULT clock_timestamp(),
+	"FromID" uuid NOT NULL
+)
+WITH (OIDS=FALSE);
+ALTER TABLE "public"."im_offline" ADD PRIMARY KEY ("ID","PrincipalID","FromID") NOT DEFERRABLE INITIALLY IMMEDIATE;
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1