diff options
Diffstat (limited to 'OpenSim/Data/SQLite')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/002_AssetStore.sql | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/OpenSim/Data/SQLite/Resources/002_AssetStore.sql b/OpenSim/Data/SQLite/Resources/002_AssetStore.sql index 41ca640..5339b84 100644 --- a/OpenSim/Data/SQLite/Resources/002_AssetStore.sql +++ b/OpenSim/Data/SQLite/Resources/002_AssetStore.sql | |||
@@ -1,10 +1,10 @@ | |||
1 | BEGIN TRANSACTION; | 1 | BEGIN TRANSACTION; |
2 | 2 | ||
3 | CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data); | 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; | 4 | INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets; |
5 | DROP TABLE assets; | 5 | DROP TABLE assets; |
6 | CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data); | 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; | 7 | INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup; |
8 | DROP TABLE assets_backup; | 8 | DROP TABLE assets_backup; |
9 | 9 | ||
10 | COMMIT; | 10 | COMMIT; |