diff options
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; |