aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
diff options
context:
space:
mode:
authorBlueWall2014-10-16 12:34:04 -0400
committerBlueWall2014-10-16 12:34:04 -0400
commitb7550c947bd17bb7db58f33646db0f0728d93b25 (patch)
tree73dd36f226069f02d8b7caf1e3c88d0df3e35115 /OpenSim/Data/PGSQL/Resources/XAssetStore.migrations
parentFix transferring inventory from prims to agent inventory (diff)
downloadopensim-SC-b7550c947bd17bb7db58f33646db0f0728d93b25.zip
opensim-SC-b7550c947bd17bb7db58f33646db0f0728d93b25.tar.gz
opensim-SC-b7550c947bd17bb7db58f33646db0f0728d93b25.tar.bz2
opensim-SC-b7550c947bd17bb7db58f33646db0f0728d93b25.tar.xz
Experimental XAssets Module PgSQL Adapter: Remove unused migration. Syntax error preventing migration from running.
Diffstat (limited to 'OpenSim/Data/PGSQL/Resources/XAssetStore.migrations')
-rw-r--r--OpenSim/Data/PGSQL/Resources/XAssetStore.migrations19
1 files changed, 0 insertions, 19 deletions
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;
68 68
69BEGIN; 69BEGIN;
70 70
71;; This is a harsh way of migrating these columns to
72;; a different data type, but it didn't work otherwise
73;; and we have a strict warning when using the module
74;; so here we go ...
75
76ALTER TABLE xassetsmeta DROP COLUMN hash;
77ALTER TABLE xassetsmeta ADD COLUMN hash bytea NOT NULL;
78
79ALTER TABLE xassetsdata DROP CONSTRAINT xassetsdata_pkey;
80ALTER TABLE xassetsdata DROP COLUMN hash;
81ALTER TABLE xassetsdata ADD COLUMN hash bytea NOT NULL;
82ALTER TABLE xassetsdata ADD PRIMARY KEY (hash);
83
84COMMIT;
85
86:VERSION 5
87
88BEGIN;
89
90ALTER TABLE xassetsmeta ALTER COLUMN id SET DATA TYPE uuid USING id::uuid; 71ALTER TABLE xassetsmeta ALTER COLUMN id SET DATA TYPE uuid USING id::uuid;
91ALTER TABLE xassetsmeta ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea; 72ALTER TABLE xassetsmeta ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea;
92ALTER TABLE xassetsdata ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea; 73ALTER TABLE xassetsdata ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea;