aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
authorSean Dague2009-05-08 14:16:07 +0000
committerSean Dague2009-05-08 14:16:07 +0000
commit51a9c91909897f37c085afc0d1d62e120e9be31f (patch)
treedde4a9dbcd203625fad6ec16c385587d70d3ed90 /OpenSim/Data/MySQL
parentMore additions to the nextgen reference UGAIM (diff)
downloadopensim-SC_OLD-51a9c91909897f37c085afc0d1d62e120e9be31f.zip
opensim-SC_OLD-51a9c91909897f37c085afc0d1d62e120e9be31f.tar.gz
opensim-SC_OLD-51a9c91909897f37c085afc0d1d62e120e9be31f.tar.bz2
opensim-SC_OLD-51a9c91909897f37c085afc0d1d62e120e9be31f.tar.xz
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.
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/Resources/004_InventoryStore.sql7
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 @@
1BEGIN;
2
3update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID is NULL;
4update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID = '';
5alter table inventoryitems modify column creatorID varchar(36) not NULL default '00000000-0000-0000-0000-000000000000';
6
7COMMIT;