diff options
| author | Melanie | 2010-04-30 20:15:19 +0100 |
|---|---|---|
| committer | Melanie | 2010-04-30 20:15:19 +0100 |
| commit | 9bc5098dd8cac09caab5d50045aba13110ead2c6 (patch) | |
| tree | a8c197c950b14234873e66bd199178907983c302 /OpenSim/Data/SQLiteLegacy/Resources/002_AssetStore.sql | |
| parent | Fix linking issue introduced in my earlier commit (diff) | |
| parent | Merge branch 'master' of melanie@opensimulator.org:/var/git/opensim (diff) | |
| download | opensim-SC-9bc5098dd8cac09caab5d50045aba13110ead2c6.zip opensim-SC-9bc5098dd8cac09caab5d50045aba13110ead2c6.tar.gz opensim-SC-9bc5098dd8cac09caab5d50045aba13110ead2c6.tar.bz2 opensim-SC-9bc5098dd8cac09caab5d50045aba13110ead2c6.tar.xz | |
Merge branch 'master' into careminster-presence-refactor
Diffstat (limited to 'OpenSim/Data/SQLiteLegacy/Resources/002_AssetStore.sql')
| -rw-r--r-- | OpenSim/Data/SQLiteLegacy/Resources/002_AssetStore.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLiteLegacy/Resources/002_AssetStore.sql b/OpenSim/Data/SQLiteLegacy/Resources/002_AssetStore.sql new file mode 100644 index 0000000..5339b84 --- /dev/null +++ b/OpenSim/Data/SQLiteLegacy/Resources/002_AssetStore.sql | |||
| @@ -0,0 +1,10 @@ | |||
| 1 | BEGIN TRANSACTION; | ||
| 2 | |||
| 3 | CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data); | ||
| 4 | INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets; | ||
| 5 | DROP TABLE assets; | ||
| 6 | CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data); | ||
| 7 | INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup; | ||
| 8 | DROP TABLE assets_backup; | ||
| 9 | |||
| 10 | COMMIT; | ||