From 8a93d97320f8151ca4d5ff2d83e25a7ff5d41499 Mon Sep 17 00:00:00 2001
From: BlueWall
Date: Wed, 15 Oct 2014 17:28:51 -0400
Subject: Touchup PgSQL XAssets adapter

---
 OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'OpenSim/Data/PGSQL/Resources')

diff --git a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
index 8fb3656..096ecc4 100644
--- a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
@@ -81,4 +81,14 @@ ALTER TABLE xassetsdata DROP COLUMN hash;
 ALTER TABLE xassetsdata ADD COLUMN hash bytea NOT NULL;
 ALTER TABLE xassetsdata ADD PRIMARY KEY (hash);
 
+COMMIT;
+
+:VERSION 5
+
+BEGIN;
+
+ALTER TABLE xassetsmeta ALTER COLUMN id SET DATA TYPE uuid USING id::uuid;
+ALTER TABLE xassetsmeta ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea;
+ALTER TABLE xassetsdata ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea;
+
 COMMIT;
\ No newline at end of file
-- 
cgit v1.1