aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data')
-rw-r--r--OpenSim/Data/MySQL/Resources/004_AssetStore.sql10
-rw-r--r--OpenSim/Data/SQLite/Resources/002_AssetStore.sql20
2 files changed, 15 insertions, 15 deletions
diff --git a/OpenSim/Data/MySQL/Resources/004_AssetStore.sql b/OpenSim/Data/MySQL/Resources/004_AssetStore.sql
index 9e9b9fe..ae1951d 100644
--- a/OpenSim/Data/MySQL/Resources/004_AssetStore.sql
+++ b/OpenSim/Data/MySQL/Resources/004_AssetStore.sql
@@ -1,5 +1,5 @@
1BEGIN; 1BEGIN;
2 2
3ALTER TABLE assets drop InvType; 3ALTER TABLE assets drop InvType;
4 4
5COMMIT; 5COMMIT;
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;