diff options
author | BlueWall | 2014-10-15 17:28:51 -0400 |
---|---|---|
committer | BlueWall | 2014-10-15 17:28:51 -0400 |
commit | 8a93d97320f8151ca4d5ff2d83e25a7ff5d41499 (patch) | |
tree | c826a4c99448af01dec4bfc4354a9c45fefdaa9a /OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | |
parent | Fix over zealous chopping of text when editing (pilot error) (diff) | |
download | opensim-SC_OLD-8a93d97320f8151ca4d5ff2d83e25a7ff5d41499.zip opensim-SC_OLD-8a93d97320f8151ca4d5ff2d83e25a7ff5d41499.tar.gz opensim-SC_OLD-8a93d97320f8151ca4d5ff2d83e25a7ff5d41499.tar.bz2 opensim-SC_OLD-8a93d97320f8151ca4d5ff2d83e25a7ff5d41499.tar.xz |
Touchup PgSQL XAssets adapter
Diffstat (limited to '')
-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 |