From 4d16f09c394266f8b5cc8b701907dac651993d41 Mon Sep 17 00:00:00 2001
From: Cinder <cinder@sdf.org>
Date: Wed, 4 Mar 2015 10:02:23 -0700
Subject: [PATCH] Chase latest change to asset description length with an
 update to XAssetStore db tables

---
 OpenSim/Data/MySQL/Resources/XAssetStore.migrations | 10 +++++++++-
 OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | 10 +++++++++-
 2 files changed, 18 insertions(+), 2 deletions(-)

diff --git a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
index 0c49d0d..d56c917 100644
--- a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
@@ -24,4 +24,12 @@ CREATE TABLE `XAssetsData` (
   PRIMARY KEY (`hash`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1';
 
-COMMIT;
\ No newline at end of file
+COMMIT;
+
+:VERSION 2
+
+BEGIN;
+ 
+ALTER TABLE xassetsmeta MODIFY Description varchar(128);
+
+COMMIT;
diff --git a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
index e87d3a1..79879b8 100644
--- a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
@@ -72,4 +72,12 @@ 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
+COMMIT;
+
+:VERSION 5
+
+BEGIN;
+
+ALTER TABLE xassetsmeta MODIFY Description varchar(128);
+
+COMMIT;
-- 
2.2.1

From cd996eb6032761cbc6200d3754030666568d35e7 Mon Sep 17 00:00:00 2001
From: Cinder <cinder@sdf.org>
Date: Wed, 4 Mar 2015 11:11:01 -0700
Subject: [PATCH] One more migration fix

---
 OpenSim/Data/PGSQL/Resources/AssetStore.migrations  | 2 +-
 OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/OpenSim/Data/PGSQL/Resources/AssetStore.migrations b/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
index 9919844..fb7d156 100644
--- a/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
@@ -95,4 +95,4 @@ alter table assets add "creatorid" varchar(36) not null default '';
 
 :VERSION 8
 
-ALTER TABLE assets MODIFY description varchar(128);
+ALTER TABLE assets ALTER COLUMN description TYPE varchar(128);
diff --git a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
index 79879b8..0e22091 100644
--- a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
@@ -78,6 +78,6 @@ COMMIT;
 
 BEGIN;
 
-ALTER TABLE xassetsmeta MODIFY Description varchar(128);
+ALTER TABLE xassetsmeta ALTER COLUMN description TYPE varchar(128);
 
 COMMIT;
-- 
2.2.1