diff options
| author | BlueWall | 2014-10-10 19:24:46 -0400 |
|---|---|---|
| committer | BlueWall | 2014-10-10 19:58:07 -0400 |
| commit | 7af878a4f48f1748750d200baa4e59ccbcf75c8e (patch) | |
| tree | 8a26d0dcf549215133e123806be57e1ab4314a57 /OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | |
| parent | Change name of just added OSSL osForceSit() to osForceOtherSit() (diff) | |
| download | opensim-SC-7af878a4f48f1748750d200baa4e59ccbcf75c8e.zip opensim-SC-7af878a4f48f1748750d200baa4e59ccbcf75c8e.tar.gz opensim-SC-7af878a4f48f1748750d200baa4e59ccbcf75c8e.tar.bz2 opensim-SC-7af878a4f48f1748750d200baa4e59ccbcf75c8e.tar.xz | |
Fix some errors in PgSQL XAssets by changing some data types. Also make sql query syntax more in line with the PgSQL AssetData implementation.
Diffstat (limited to 'OpenSim/Data/PGSQL/Resources/XAssetStore.migrations')
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations index 325ed0d..1513cc3 100644 --- a/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/XAssetStore.migrations | |||
| @@ -25,3 +25,15 @@ CREATE TABLE XAssetsData ( | |||
| 25 | ); | 25 | ); |
| 26 | 26 | ||
| 27 | COMMIT; | 27 | COMMIT; |
| 28 | |||
| 29 | |||
| 30 | :VERSION 2 | ||
| 31 | |||
| 32 | BEGIN; | ||
| 33 | |||
| 34 | ALTER TABLE xassetsmeta ALTER COLUMN "Local" SET DATA TYPE boolean USING CASE WHEN '0' THEN FALSE ELSE TRUE END; | ||
| 35 | ALTER TABLE xassetsmeta ALTER COLUMN "Temporary" SET DATA TYPE boolean USING CASE WHEN '0' THEN FALSE ELSE TRUE END; | ||
| 36 | ALTER TABLE xassetsmeta ALTER COLUMN "Hash" SET DATA TYPE char(66); | ||
| 37 | ALTER TABLE xassetsdata ALTER COLUMN "Hash" SET DATA TYPE char(66); | ||
| 38 | |||
| 39 | COMMIT; \ No newline at end of file | ||