1 files changed, 7 insertions, 0 deletions

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;