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/PGSQL/Resources/AssetStore.migrations | 3 ++- OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | 3 --- 2 files changed, 2 insertions(+), 4 deletions(-) (limited to 'OpenSim/Data/PGSQL') 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