From 1ad12851d076094d6fad3ebe604b4cae378eaef3 Mon Sep 17 00:00:00 2001 From: AlexRa Date: Thu, 6 May 2010 22:44:57 +0300 Subject: Migrations for SQLite converted to new format --- OpenSim/Data/SQLite/Resources/002_AssetStore.sql | 10 ---------- 1 file changed, 10 deletions(-) delete mode 100644 OpenSim/Data/SQLite/Resources/002_AssetStore.sql (limited to 'OpenSim/Data/SQLite/Resources/002_AssetStore.sql') diff --git a/OpenSim/Data/SQLite/Resources/002_AssetStore.sql b/OpenSim/Data/SQLite/Resources/002_AssetStore.sql deleted file mode 100644 index 5339b84..0000000 --- a/OpenSim/Data/SQLite/Resources/002_AssetStore.sql +++ /dev/null @@ -1,10 +0,0 @@ -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