diff options
Diffstat (limited to 'OpenSim/Data/PGSQL/Resources/XAssetStore.migrations')
-rw-r--r-- | OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations index 8fb3656..096ecc4 100644 --- a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | |||
@@ -81,4 +81,14 @@ ALTER TABLE xassetsdata DROP COLUMN hash; | |||
81 | ALTER TABLE xassetsdata ADD COLUMN hash bytea NOT NULL; | 81 | ALTER TABLE xassetsdata ADD COLUMN hash bytea NOT NULL; |
82 | ALTER TABLE xassetsdata ADD PRIMARY KEY (hash); | 82 | ALTER TABLE xassetsdata ADD PRIMARY KEY (hash); |
83 | 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; | ||
91 | 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; | ||
93 | |||
84 | COMMIT; \ No newline at end of file | 94 | COMMIT; \ No newline at end of file |