From 7af878a4f48f1748750d200baa4e59ccbcf75c8e Mon Sep 17 00:00:00 2001
From: BlueWall
Date: Fri, 10 Oct 2014 19:24:46 -0400
Subject: Fix some errors in PgSQL XAssets by changing some data types. Also
 make sql query syntax more in line with the PgSQL AssetData implementation.

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

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

diff --git a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
index 325ed0d..1513cc3 100644
--- a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
@@ -25,3 +25,15 @@ CREATE TABLE XAssetsData (
 );
 
 COMMIT;
+
+
+:VERSION 2
+
+BEGIN;
+
+ALTER TABLE xassetsmeta ALTER COLUMN "Local" SET DATA TYPE boolean USING CASE WHEN '0' THEN FALSE ELSE TRUE END;
+ALTER TABLE xassetsmeta ALTER COLUMN "Temporary" SET DATA TYPE boolean USING CASE WHEN '0' THEN FALSE ELSE TRUE END;
+ALTER TABLE xassetsmeta ALTER COLUMN "Hash" SET DATA TYPE char(66);
+ALTER TABLE xassetsdata ALTER COLUMN "Hash" SET DATA TYPE char(66);
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1