From 51a9c91909897f37c085afc0d1d62e120e9be31f Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Fri, 8 May 2009 14:16:07 +0000
Subject: WARNING: contains migration

Since creatorID is no longer treated as a UUID type in the code from the database we need to make sure that it isn't null in the database.  This updates all empty string and null values for this column to the Zero UUID, and makes the column a not null definition with a default fo the Zero UUID.

---
 OpenSim/Data/MySQL/Resources/004_InventoryStore.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/004_InventoryStore.sql

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/MySQL/Resources/004_InventoryStore.sql b/OpenSim/Data/MySQL/Resources/004_InventoryStore.sql
new file mode 100644
index 0000000..c45f773
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/004_InventoryStore.sql
@@ -0,0 +1,7 @@
+BEGIN;
+
+update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID is NULL;
+update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID = '';
+alter table inventoryitems modify column creatorID varchar(36) not NULL default '00000000-0000-0000-0000-000000000000';
+
+COMMIT;
-- 
cgit v1.1