diff options
| author | Sean Dague | 2008-06-16 14:10:51 +0000 |
|---|---|---|
| committer | Sean Dague | 2008-06-16 14:10:51 +0000 |
| commit | ec78a2871bedd951844be01490fcb85e22dac178 (patch) | |
| tree | 8d22fbfcc18697021e0c2611f98a30de13c6c461 /OpenSim/Data/MySQL/Resources | |
| parent | * 0001558: [PATCH] Add support for full collision geometry feature set for li... (diff) | |
| download | opensim-SC_OLD-ec78a2871bedd951844be01490fcb85e22dac178.zip opensim-SC_OLD-ec78a2871bedd951844be01490fcb85e22dac178.tar.gz opensim-SC_OLD-ec78a2871bedd951844be01490fcb85e22dac178.tar.bz2 opensim-SC_OLD-ec78a2871bedd951844be01490fcb85e22dac178.tar.xz | |
the beginning of the great id format migration. This makes
asset uuids no longer binary. I've tested this migration a
few times, and it seems working in all the scenarios I've found
but it wouldn't hurt to backup your asset db before running this
as it does touch a very sensitive part of our content system.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/002_AssetStore.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/002_AssetStore.sql b/OpenSim/Data/MySQL/Resources/002_AssetStore.sql new file mode 100644 index 0000000..a7d7fca --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/002_AssetStore.sql | |||
| @@ -0,0 +1,9 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | ALTER TABLE assets change id oldid binary(16); | ||
| 4 | ALTER TABLE assets add id varchar(36) not null default ''; | ||
| 5 | UPDATE assets set id = concat(substr(hex(oldid),1,8),"-",substr(hex(oldid),9,4),"-",substr(hex(oldid),13,4),"-",substr(hex(oldid),17,4),"-",substr(hex(oldid),21,12)); | ||
| 6 | ALTER TABLE assets drop oldid; | ||
| 7 | ALTER TABLE assets add constraint primary key(id); | ||
| 8 | |||
| 9 | COMMIT; \ No newline at end of file | ||