From fde6983cce7a6501facba9a3f6d9b86f4dcac8e5 Mon Sep 17 00:00:00 2001 From: Jeff Ames Date: Thu, 3 Jul 2008 03:01:02 +0000 Subject: Update svn properties. --- OpenSim/Data/MySQL/Resources/004_AssetStore.sql | 10 +++++----- OpenSim/Data/SQLite/Resources/002_AssetStore.sql | 20 ++++++++++---------- 2 files changed, 15 insertions(+), 15 deletions(-) (limited to 'OpenSim/Data') 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 @@ -BEGIN; - -ALTER TABLE assets drop InvType; - -COMMIT; +BEGIN; + +ALTER TABLE assets drop InvType; + +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 @@ -BEGIN TRANSACTION; - -CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data); -INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets; -DROP TABLE assets; -CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data); -INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup; -DROP TABLE assets_backup; - -COMMIT; +BEGIN TRANSACTION; + +CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data); +INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets; +DROP TABLE assets; +CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data); +INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup; +DROP TABLE assets_backup; + +COMMIT; -- cgit v1.1