aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/002_AssetStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/002_AssetStore.sql')
-rw-r--r--OpenSim/Data/SQLite/Resources/002_AssetStore.sql20
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 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2 2
3CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data); 3CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data);
4INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets; 4INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets;
5DROP TABLE assets; 5DROP TABLE assets;
6CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data); 6CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data);
7INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup; 7INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup;
8DROP TABLE assets_backup; 8DROP TABLE assets_backup;
9 9
10COMMIT; 10COMMIT;