aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
authorDiva Canto2010-06-08 15:47:14 -0700
committerDiva Canto2010-06-08 15:47:14 -0700
commit9b9804a498a3d48e7356c0a2cd12bf98887f5a53 (patch)
tree8a64306d9000c52f99f5682fdb54d4a3d90b70bf /OpenSim/Data/MySQL
parentImprove instructions for [Groups] setup in OpenSim.ini.example (diff)
downloadopensim-SC_OLD-9b9804a498a3d48e7356c0a2cd12bf98887f5a53.zip
opensim-SC_OLD-9b9804a498a3d48e7356c0a2cd12bf98887f5a53.tar.gz
opensim-SC_OLD-9b9804a498a3d48e7356c0a2cd12bf98887f5a53.tar.bz2
opensim-SC_OLD-9b9804a498a3d48e7356c0a2cd12bf98887f5a53.tar.xz
* Changed CreatorIDs consistently to varchar(128)
* Deleted redundant migration for assets in SQLite * Rewrote XInventory migrations in SQLite in the new style
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/Resources/AssetStore.migrations2
-rw-r--r--OpenSim/Data/MySQL/Resources/InventoryStore.migrations8
2 files changed, 9 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/AssetStore.migrations b/OpenSim/Data/MySQL/Resources/AssetStore.migrations
index 9c55630..e0526fe 100644
--- a/OpenSim/Data/MySQL/Resources/AssetStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/AssetStore.migrations
@@ -73,5 +73,5 @@ ALTER TABLE assets ADD COLUMN asset_flags INTEGER NOT NULL DEFAULT 0;
73 73
74:VERSION 8 74:VERSION 8
75 75
76ALTER TABLE assets ADD COLUMN CreatorID varchar(36) NOT NULL DEFAULT ''; 76ALTER TABLE assets ADD COLUMN CreatorID varchar(128) NOT NULL DEFAULT '';
77 77
diff --git a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations
index 8c5864e..3e9bad5 100644
--- a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations
@@ -91,3 +91,11 @@ update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' whe
91alter table inventoryitems modify column creatorID varchar(36) not NULL default '00000000-0000-0000-0000-000000000000'; 91alter table inventoryitems modify column creatorID varchar(36) not NULL default '00000000-0000-0000-0000-000000000000';
92 92
93COMMIT; 93COMMIT;
94
95:VERSION 5 # ------------
96
97BEGIN;
98
99alter table inventoryitems modify column creatorID varchar(128) not NULL default '00000000-0000-0000-0000-000000000000';
100
101COMMIT;