diff options
author | BlueWall | 2014-10-16 12:34:04 -0400 |
---|---|---|
committer | BlueWall | 2014-10-16 12:34:04 -0400 |
commit | b7550c947bd17bb7db58f33646db0f0728d93b25 (patch) | |
tree | 73dd36f226069f02d8b7caf1e3c88d0df3e35115 /OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | |
parent | Fix transferring inventory from prims to agent inventory (diff) | |
download | opensim-SC_OLD-b7550c947bd17bb7db58f33646db0f0728d93b25.zip opensim-SC_OLD-b7550c947bd17bb7db58f33646db0f0728d93b25.tar.gz opensim-SC_OLD-b7550c947bd17bb7db58f33646db0f0728d93b25.tar.bz2 opensim-SC_OLD-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.migrations | 19 |
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 | ||
69 | BEGIN; | 69 | BEGIN; |
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 | |||
76 | ALTER TABLE xassetsmeta DROP COLUMN hash; | ||
77 | ALTER TABLE xassetsmeta ADD COLUMN hash bytea NOT NULL; | ||
78 | |||
79 | ALTER TABLE xassetsdata DROP CONSTRAINT xassetsdata_pkey; | ||
80 | ALTER TABLE xassetsdata DROP COLUMN hash; | ||
81 | ALTER TABLE xassetsdata ADD COLUMN hash bytea NOT NULL; | ||
82 | ALTER TABLE xassetsdata ADD PRIMARY KEY (hash); | ||
83 | |||
84 | COMMIT; | ||
85 | |||
86 | :VERSION 5 | ||
87 | |||
88 | BEGIN; | ||
89 | |||
90 | ALTER TABLE xassetsmeta ALTER COLUMN id SET DATA TYPE uuid USING id::uuid; | 71 | ALTER TABLE xassetsmeta ALTER COLUMN id SET DATA TYPE uuid USING id::uuid; |
91 | ALTER TABLE xassetsmeta ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea; | 72 | ALTER TABLE xassetsmeta ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea; |
92 | ALTER TABLE xassetsdata ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea; | 73 | ALTER TABLE xassetsdata ALTER COLUMN hash SET DATA TYPE bytea USING hash::bytea; |