From e4419c34c30e1cf6529ced125f0c05aed24644a4 Mon Sep 17 00:00:00 2001
From: AlexRa
Date: Sat, 1 May 2010 17:43:10 +0300
Subject: Converted MySQL migration history to the new format

Replaced all NNN_StoreName.sql migration resources with a more
readable, single-file-per-store
---
 OpenSim/Data/MySQL/Resources/002_AssetStore.sql | 9 ---------
 1 file changed, 9 deletions(-)
 delete mode 100644 OpenSim/Data/MySQL/Resources/002_AssetStore.sql

(limited to 'OpenSim/Data/MySQL/Resources/002_AssetStore.sql')

diff --git a/OpenSim/Data/MySQL/Resources/002_AssetStore.sql b/OpenSim/Data/MySQL/Resources/002_AssetStore.sql
deleted file mode 100644
index a7d7fca..0000000
--- a/OpenSim/Data/MySQL/Resources/002_AssetStore.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-BEGIN;
-
-ALTER TABLE assets change id oldid binary(16);
-ALTER TABLE assets add id varchar(36) not null default '';
-UPDATE assets set id = concat(substr(hex(oldid),1,8),"-",substr(hex(oldid),9,4),"-",substr(hex(oldid),13,4),"-",substr(hex(oldid),17,4),"-",substr(hex(oldid),21,12));
-ALTER TABLE assets drop oldid;
-ALTER TABLE assets add constraint primary key(id);
-
-COMMIT;
\ No newline at end of file
-- 
cgit v1.1

