From d7b45a3ed20e6d4230faa812616a6031001c8977 Mon Sep 17 00:00:00 2001
From: BlueWall
Date: Wed, 4 Mar 2015 19:27:34 -0500
Subject: Alter the migrations so that it is a no-op as the columns are unused
 and the operation is very expensive

---
 OpenSim/Data/MySQL/Resources/AssetStore.migrations  | 3 ++-
 OpenSim/Data/MySQL/Resources/XAssetStore.migrations | 3 ---
 OpenSim/Data/PGSQL/Resources/AssetStore.migrations  | 3 ++-
 OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | 3 ---
 4 files changed, 4 insertions(+), 8 deletions(-)

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/MySQL/Resources/AssetStore.migrations b/OpenSim/Data/MySQL/Resources/AssetStore.migrations
index 2c5e7c3..661d825 100644
--- a/OpenSim/Data/MySQL/Resources/AssetStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/AssetStore.migrations
@@ -77,4 +77,5 @@ ALTER TABLE assets ADD COLUMN CreatorID varchar(128) NOT NULL DEFAULT '';
 
 :VERSION 9
 
-ALTER TABLE assets MODIFY description varchar(128);
+BEGIN;
+COMMIT;
diff --git a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
index d56c917..9459e3e 100644
--- a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
@@ -29,7 +29,4 @@ COMMIT;
 :VERSION 2
 
 BEGIN;
- 
-ALTER TABLE xassetsmeta MODIFY Description varchar(128);
-
 COMMIT;
diff --git a/OpenSim/Data/PGSQL/Resources/AssetStore.migrations b/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
index fb7d156..7a858b4 100644
--- a/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
@@ -95,4 +95,5 @@ alter table assets add "creatorid" varchar(36) not null default '';
 
 :VERSION 8
 
-ALTER TABLE assets ALTER COLUMN description TYPE varchar(128);
+BEGIN TRANSACTION;
+COMMIT;
diff --git a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
index 0e22091..df9d821 100644
--- a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
@@ -77,7 +77,4 @@ COMMIT;
 :VERSION 5
 
 BEGIN;
-
-ALTER TABLE xassetsmeta ALTER COLUMN description TYPE varchar(128);
-
 COMMIT;
-- 
cgit v1.1