diff options
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/004_AssetStore.sql | 10 | ||||
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/002_AssetStore.sql | 20 |
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 @@ | |||
| 1 | BEGIN; | 1 | BEGIN; |
| 2 | 2 | ||
| 3 | ALTER TABLE assets drop InvType; | 3 | ALTER TABLE assets drop InvType; |
| 4 | 4 | ||
| 5 | COMMIT; | 5 | COMMIT; |
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; |