From b7550c947bd17bb7db58f33646db0f0728d93b25 Mon Sep 17 00:00:00 2001 From: BlueWall Date: Thu, 16 Oct 2014 12:34:04 -0400 Subject: Experimental XAssets Module PgSQL Adapter: Remove unused migration. Syntax error preventing migration from running. --- OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | 19 ------------------- 1 file changed, 19 deletions(-) (limited to 'OpenSim') diff --git a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations index 096ecc4..e87d3a1 100644 --- a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations @@ -68,25 +68,6 @@ COMMIT; BEGIN; -;; This is a harsh way of migrating these columns to -;; a different data type, but it didn't work otherwise -;; and we have a strict warning when using the module -;; so here we go ... - -ALTER TABLE xassetsmeta DROP COLUMN hash; -ALTER TABLE xassetsmeta ADD COLUMN hash bytea NOT NULL; - -ALTER TABLE xassetsdata DROP CONSTRAINT xassetsdata_pkey; -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; -- cgit v1.1