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 '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 |