diff options
author | Jonathan Freedman | 2010-11-21 20:01:48 -0800 |
---|---|---|
committer | Jonathan Freedman | 2010-11-21 20:01:48 -0800 |
commit | b7f5e8284360f92e0e102b9546076573c57d9397 (patch) | |
tree | 132663da8c1882e524241b55a739ef2758ef8958 /OpenSim/Data | |
parent | Merge https://github.com/opensim/opensim into mantis5110 (diff) | |
parent | Merge branch 'master' of /var/git/opensim/ (diff) | |
download | opensim-SC_OLD-b7f5e8284360f92e0e102b9546076573c57d9397.zip opensim-SC_OLD-b7f5e8284360f92e0e102b9546076573c57d9397.tar.gz opensim-SC_OLD-b7f5e8284360f92e0e102b9546076573c57d9397.tar.bz2 opensim-SC_OLD-b7f5e8284360f92e0e102b9546076573c57d9397.tar.xz |
Merge branch 'master-core' into mantis5110
Diffstat (limited to 'OpenSim/Data')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLSimulationData.cs | 8 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/InventoryStore.migrations | 8 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 9 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteInventoryStore.cs | 4 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteSimulationData.cs | 8 | ||||
-rw-r--r-- | OpenSim/Data/SQLiteLegacy/SQLiteInventoryStore.cs | 4 | ||||
-rw-r--r-- | OpenSim/Data/SQLiteLegacy/SQLiteSimulationData.cs | 8 |
7 files changed, 33 insertions, 16 deletions
diff --git a/OpenSim/Data/MySQL/MySQLSimulationData.cs b/OpenSim/Data/MySQL/MySQLSimulationData.cs index ae78814..02997b3 100644 --- a/OpenSim/Data/MySQL/MySQLSimulationData.cs +++ b/OpenSim/Data/MySQL/MySQLSimulationData.cs | |||
@@ -1090,7 +1090,7 @@ namespace OpenSim.Data.MySQL | |||
1090 | 1090 | ||
1091 | // depending on the MySQL connector version, CHAR(36) may be already converted to Guid! | 1091 | // depending on the MySQL connector version, CHAR(36) may be already converted to Guid! |
1092 | prim.UUID = DBGuid.FromDB(row["UUID"]); | 1092 | prim.UUID = DBGuid.FromDB(row["UUID"]); |
1093 | prim.CreatorID = DBGuid.FromDB(row["CreatorID"]); | 1093 | prim.CreatorIdentification = (string)row["CreatorID"]; |
1094 | prim.OwnerID = DBGuid.FromDB(row["OwnerID"]); | 1094 | prim.OwnerID = DBGuid.FromDB(row["OwnerID"]); |
1095 | prim.GroupID = DBGuid.FromDB(row["GroupID"]); | 1095 | prim.GroupID = DBGuid.FromDB(row["GroupID"]); |
1096 | prim.LastOwnerID = DBGuid.FromDB(row["LastOwnerID"]); | 1096 | prim.LastOwnerID = DBGuid.FromDB(row["LastOwnerID"]); |
@@ -1243,7 +1243,7 @@ namespace OpenSim.Data.MySQL | |||
1243 | taskItem.Name = (String)row["name"]; | 1243 | taskItem.Name = (String)row["name"]; |
1244 | taskItem.Description = (String)row["description"]; | 1244 | taskItem.Description = (String)row["description"]; |
1245 | taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]); | 1245 | taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]); |
1246 | taskItem.CreatorID = DBGuid.FromDB(row["creatorID"]); | 1246 | taskItem.CreatorIdentification = (String)row["creatorID"]; |
1247 | taskItem.OwnerID = DBGuid.FromDB(row["ownerID"]); | 1247 | taskItem.OwnerID = DBGuid.FromDB(row["ownerID"]); |
1248 | taskItem.LastOwnerID = DBGuid.FromDB(row["lastOwnerID"]); | 1248 | taskItem.LastOwnerID = DBGuid.FromDB(row["lastOwnerID"]); |
1249 | taskItem.GroupID = DBGuid.FromDB(row["groupID"]); | 1249 | taskItem.GroupID = DBGuid.FromDB(row["groupID"]); |
@@ -1453,7 +1453,7 @@ namespace OpenSim.Data.MySQL | |||
1453 | cmd.Parameters.AddWithValue("TouchName", prim.TouchName); | 1453 | cmd.Parameters.AddWithValue("TouchName", prim.TouchName); |
1454 | // permissions | 1454 | // permissions |
1455 | cmd.Parameters.AddWithValue("ObjectFlags", (uint)prim.Flags); | 1455 | cmd.Parameters.AddWithValue("ObjectFlags", (uint)prim.Flags); |
1456 | cmd.Parameters.AddWithValue("CreatorID", prim.CreatorID.ToString()); | 1456 | cmd.Parameters.AddWithValue("CreatorID", prim.CreatorIdentification.ToString()); |
1457 | cmd.Parameters.AddWithValue("OwnerID", prim.OwnerID.ToString()); | 1457 | cmd.Parameters.AddWithValue("OwnerID", prim.OwnerID.ToString()); |
1458 | cmd.Parameters.AddWithValue("GroupID", prim.GroupID.ToString()); | 1458 | cmd.Parameters.AddWithValue("GroupID", prim.GroupID.ToString()); |
1459 | cmd.Parameters.AddWithValue("LastOwnerID", prim.LastOwnerID.ToString()); | 1459 | cmd.Parameters.AddWithValue("LastOwnerID", prim.LastOwnerID.ToString()); |
@@ -1583,7 +1583,7 @@ namespace OpenSim.Data.MySQL | |||
1583 | cmd.Parameters.AddWithValue("name", taskItem.Name); | 1583 | cmd.Parameters.AddWithValue("name", taskItem.Name); |
1584 | cmd.Parameters.AddWithValue("description", taskItem.Description); | 1584 | cmd.Parameters.AddWithValue("description", taskItem.Description); |
1585 | cmd.Parameters.AddWithValue("creationDate", taskItem.CreationDate); | 1585 | cmd.Parameters.AddWithValue("creationDate", taskItem.CreationDate); |
1586 | cmd.Parameters.AddWithValue("creatorID", taskItem.CreatorID); | 1586 | cmd.Parameters.AddWithValue("creatorID", taskItem.CreatorIdentification); |
1587 | cmd.Parameters.AddWithValue("ownerID", taskItem.OwnerID); | 1587 | cmd.Parameters.AddWithValue("ownerID", taskItem.OwnerID); |
1588 | cmd.Parameters.AddWithValue("lastOwnerID", taskItem.LastOwnerID); | 1588 | cmd.Parameters.AddWithValue("lastOwnerID", taskItem.LastOwnerID); |
1589 | cmd.Parameters.AddWithValue("groupID", taskItem.GroupID); | 1589 | cmd.Parameters.AddWithValue("groupID", taskItem.GroupID); |
diff --git a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations index 3e9bad5..993a5a0 100644 --- a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations +++ b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations | |||
@@ -99,3 +99,11 @@ BEGIN; | |||
99 | alter table inventoryitems modify column creatorID varchar(128) not NULL default '00000000-0000-0000-0000-000000000000'; | 99 | alter table inventoryitems modify column creatorID varchar(128) not NULL default '00000000-0000-0000-0000-000000000000'; |
100 | 100 | ||
101 | COMMIT; | 101 | COMMIT; |
102 | |||
103 | :VERSION 6 # ------------ | ||
104 | |||
105 | BEGIN; | ||
106 | |||
107 | alter table inventoryitems modify column creatorID varchar(255) not NULL default '00000000-0000-0000-0000-000000000000'; | ||
108 | |||
109 | COMMIT; | ||
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index 1405207..ba8d538 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -817,3 +817,12 @@ ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE; | |||
817 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; | 817 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; |
818 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; | 818 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; |
819 | COMMIT; | 819 | COMMIT; |
820 | |||
821 | :VERSION 37 #--------------------- | ||
822 | |||
823 | BEGIN; | ||
824 | |||
825 | ALTER TABLE `prims` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; | ||
826 | ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; | ||
827 | |||
828 | COMMIT; | ||
diff --git a/OpenSim/Data/SQLite/SQLiteInventoryStore.cs b/OpenSim/Data/SQLite/SQLiteInventoryStore.cs index d606f11..7dc07ec 100644 --- a/OpenSim/Data/SQLite/SQLiteInventoryStore.cs +++ b/OpenSim/Data/SQLite/SQLiteInventoryStore.cs | |||
@@ -156,7 +156,7 @@ namespace OpenSim.Data.SQLite | |||
156 | item.InvType = Convert.ToInt32(row["invType"]); | 156 | item.InvType = Convert.ToInt32(row["invType"]); |
157 | item.Folder = new UUID((string) row["parentFolderID"]); | 157 | item.Folder = new UUID((string) row["parentFolderID"]); |
158 | item.Owner = new UUID((string) row["avatarID"]); | 158 | item.Owner = new UUID((string) row["avatarID"]); |
159 | item.CreatorId = (string)row["creatorsID"]; | 159 | item.CreatorIdentification = (string)row["creatorsID"]; |
160 | item.Name = (string) row["inventoryName"]; | 160 | item.Name = (string) row["inventoryName"]; |
161 | item.Description = (string) row["inventoryDescription"]; | 161 | item.Description = (string) row["inventoryDescription"]; |
162 | 162 | ||
@@ -201,7 +201,7 @@ namespace OpenSim.Data.SQLite | |||
201 | row["invType"] = item.InvType; | 201 | row["invType"] = item.InvType; |
202 | row["parentFolderID"] = item.Folder.ToString(); | 202 | row["parentFolderID"] = item.Folder.ToString(); |
203 | row["avatarID"] = item.Owner.ToString(); | 203 | row["avatarID"] = item.Owner.ToString(); |
204 | row["creatorsID"] = item.CreatorId.ToString(); | 204 | row["creatorsID"] = item.CreatorIdentification.ToString(); |
205 | row["inventoryName"] = item.Name; | 205 | row["inventoryName"] = item.Name; |
206 | row["inventoryDescription"] = item.Description; | 206 | row["inventoryDescription"] = item.Description; |
207 | 207 | ||
diff --git a/OpenSim/Data/SQLite/SQLiteSimulationData.cs b/OpenSim/Data/SQLite/SQLiteSimulationData.cs index bade0a1..0bfd73a 100644 --- a/OpenSim/Data/SQLite/SQLiteSimulationData.cs +++ b/OpenSim/Data/SQLite/SQLiteSimulationData.cs | |||
@@ -1243,7 +1243,7 @@ namespace OpenSim.Data.SQLite | |||
1243 | prim.TouchName = (String) row["TouchName"]; | 1243 | prim.TouchName = (String) row["TouchName"]; |
1244 | // permissions | 1244 | // permissions |
1245 | prim.ObjectFlags = Convert.ToUInt32(row["ObjectFlags"]); | 1245 | prim.ObjectFlags = Convert.ToUInt32(row["ObjectFlags"]); |
1246 | prim.CreatorID = new UUID((String) row["CreatorID"]); | 1246 | prim.CreatorIdentification = (String) row["CreatorID"]; |
1247 | prim.OwnerID = new UUID((String) row["OwnerID"]); | 1247 | prim.OwnerID = new UUID((String) row["OwnerID"]); |
1248 | prim.GroupID = new UUID((String) row["GroupID"]); | 1248 | prim.GroupID = new UUID((String) row["GroupID"]); |
1249 | prim.LastOwnerID = new UUID((String) row["LastOwnerID"]); | 1249 | prim.LastOwnerID = new UUID((String) row["LastOwnerID"]); |
@@ -1385,7 +1385,7 @@ namespace OpenSim.Data.SQLite | |||
1385 | taskItem.Name = (String)row["name"]; | 1385 | taskItem.Name = (String)row["name"]; |
1386 | taskItem.Description = (String)row["description"]; | 1386 | taskItem.Description = (String)row["description"]; |
1387 | taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]); | 1387 | taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]); |
1388 | taskItem.CreatorID = new UUID((String)row["creatorID"]); | 1388 | taskItem.CreatorIdentification = (String)row["creatorID"]; |
1389 | taskItem.OwnerID = new UUID((String)row["ownerID"]); | 1389 | taskItem.OwnerID = new UUID((String)row["ownerID"]); |
1390 | taskItem.LastOwnerID = new UUID((String)row["lastOwnerID"]); | 1390 | taskItem.LastOwnerID = new UUID((String)row["lastOwnerID"]); |
1391 | taskItem.GroupID = new UUID((String)row["groupID"]); | 1391 | taskItem.GroupID = new UUID((String)row["groupID"]); |
@@ -1583,7 +1583,7 @@ namespace OpenSim.Data.SQLite | |||
1583 | row["TouchName"] = prim.TouchName; | 1583 | row["TouchName"] = prim.TouchName; |
1584 | // permissions | 1584 | // permissions |
1585 | row["ObjectFlags"] = prim.ObjectFlags; | 1585 | row["ObjectFlags"] = prim.ObjectFlags; |
1586 | row["CreatorID"] = prim.CreatorID.ToString(); | 1586 | row["CreatorID"] = prim.CreatorIdentification.ToString(); |
1587 | row["OwnerID"] = prim.OwnerID.ToString(); | 1587 | row["OwnerID"] = prim.OwnerID.ToString(); |
1588 | row["GroupID"] = prim.GroupID.ToString(); | 1588 | row["GroupID"] = prim.GroupID.ToString(); |
1589 | row["LastOwnerID"] = prim.LastOwnerID.ToString(); | 1589 | row["LastOwnerID"] = prim.LastOwnerID.ToString(); |
@@ -1716,7 +1716,7 @@ namespace OpenSim.Data.SQLite | |||
1716 | row["name"] = taskItem.Name; | 1716 | row["name"] = taskItem.Name; |
1717 | row["description"] = taskItem.Description; | 1717 | row["description"] = taskItem.Description; |
1718 | row["creationDate"] = taskItem.CreationDate; | 1718 | row["creationDate"] = taskItem.CreationDate; |
1719 | row["creatorID"] = taskItem.CreatorID.ToString(); | 1719 | row["creatorID"] = taskItem.CreatorIdentification.ToString(); |
1720 | row["ownerID"] = taskItem.OwnerID.ToString(); | 1720 | row["ownerID"] = taskItem.OwnerID.ToString(); |
1721 | row["lastOwnerID"] = taskItem.LastOwnerID.ToString(); | 1721 | row["lastOwnerID"] = taskItem.LastOwnerID.ToString(); |
1722 | row["groupID"] = taskItem.GroupID.ToString(); | 1722 | row["groupID"] = taskItem.GroupID.ToString(); |
diff --git a/OpenSim/Data/SQLiteLegacy/SQLiteInventoryStore.cs b/OpenSim/Data/SQLiteLegacy/SQLiteInventoryStore.cs index 726703b..8ca48f9 100644 --- a/OpenSim/Data/SQLiteLegacy/SQLiteInventoryStore.cs +++ b/OpenSim/Data/SQLiteLegacy/SQLiteInventoryStore.cs | |||
@@ -150,7 +150,7 @@ namespace OpenSim.Data.SQLiteLegacy | |||
150 | item.InvType = Convert.ToInt32(row["invType"]); | 150 | item.InvType = Convert.ToInt32(row["invType"]); |
151 | item.Folder = new UUID((string) row["parentFolderID"]); | 151 | item.Folder = new UUID((string) row["parentFolderID"]); |
152 | item.Owner = new UUID((string) row["avatarID"]); | 152 | item.Owner = new UUID((string) row["avatarID"]); |
153 | item.CreatorId = (string)row["creatorsID"]; | 153 | item.CreatorIdentification = (string)row["creatorsID"]; |
154 | item.Name = (string) row["inventoryName"]; | 154 | item.Name = (string) row["inventoryName"]; |
155 | item.Description = (string) row["inventoryDescription"]; | 155 | item.Description = (string) row["inventoryDescription"]; |
156 | 156 | ||
@@ -195,7 +195,7 @@ namespace OpenSim.Data.SQLiteLegacy | |||
195 | row["invType"] = item.InvType; | 195 | row["invType"] = item.InvType; |
196 | row["parentFolderID"] = item.Folder.ToString(); | 196 | row["parentFolderID"] = item.Folder.ToString(); |
197 | row["avatarID"] = item.Owner.ToString(); | 197 | row["avatarID"] = item.Owner.ToString(); |
198 | row["creatorsID"] = item.CreatorId.ToString(); | 198 | row["creatorsID"] = item.CreatorIdentification.ToString(); |
199 | row["inventoryName"] = item.Name; | 199 | row["inventoryName"] = item.Name; |
200 | row["inventoryDescription"] = item.Description; | 200 | row["inventoryDescription"] = item.Description; |
201 | 201 | ||
diff --git a/OpenSim/Data/SQLiteLegacy/SQLiteSimulationData.cs b/OpenSim/Data/SQLiteLegacy/SQLiteSimulationData.cs index 4952cdf..1ad1e66 100644 --- a/OpenSim/Data/SQLiteLegacy/SQLiteSimulationData.cs +++ b/OpenSim/Data/SQLiteLegacy/SQLiteSimulationData.cs | |||
@@ -1198,7 +1198,7 @@ namespace OpenSim.Data.SQLiteLegacy | |||
1198 | prim.TouchName = (String) row["TouchName"]; | 1198 | prim.TouchName = (String) row["TouchName"]; |
1199 | // permissions | 1199 | // permissions |
1200 | prim.Flags = (PrimFlags)Convert.ToUInt32(row["ObjectFlags"]); | 1200 | prim.Flags = (PrimFlags)Convert.ToUInt32(row["ObjectFlags"]); |
1201 | prim.CreatorID = new UUID((String) row["CreatorID"]); | 1201 | prim.CreatorIdentification = (String) row["CreatorID"]; |
1202 | prim.OwnerID = new UUID((String) row["OwnerID"]); | 1202 | prim.OwnerID = new UUID((String) row["OwnerID"]); |
1203 | prim.GroupID = new UUID((String) row["GroupID"]); | 1203 | prim.GroupID = new UUID((String) row["GroupID"]); |
1204 | prim.LastOwnerID = new UUID((String) row["LastOwnerID"]); | 1204 | prim.LastOwnerID = new UUID((String) row["LastOwnerID"]); |
@@ -1334,7 +1334,7 @@ namespace OpenSim.Data.SQLiteLegacy | |||
1334 | taskItem.Name = (String)row["name"]; | 1334 | taskItem.Name = (String)row["name"]; |
1335 | taskItem.Description = (String)row["description"]; | 1335 | taskItem.Description = (String)row["description"]; |
1336 | taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]); | 1336 | taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]); |
1337 | taskItem.CreatorID = new UUID((String)row["creatorID"]); | 1337 | taskItem.CreatorIdentification = (String)row["creatorID"]; |
1338 | taskItem.OwnerID = new UUID((String)row["ownerID"]); | 1338 | taskItem.OwnerID = new UUID((String)row["ownerID"]); |
1339 | taskItem.LastOwnerID = new UUID((String)row["lastOwnerID"]); | 1339 | taskItem.LastOwnerID = new UUID((String)row["lastOwnerID"]); |
1340 | taskItem.GroupID = new UUID((String)row["groupID"]); | 1340 | taskItem.GroupID = new UUID((String)row["groupID"]); |
@@ -1531,7 +1531,7 @@ namespace OpenSim.Data.SQLiteLegacy | |||
1531 | row["TouchName"] = prim.TouchName; | 1531 | row["TouchName"] = prim.TouchName; |
1532 | // permissions | 1532 | // permissions |
1533 | row["ObjectFlags"] = (uint)prim.Flags; | 1533 | row["ObjectFlags"] = (uint)prim.Flags; |
1534 | row["CreatorID"] = prim.CreatorID.ToString(); | 1534 | row["CreatorID"] = prim.CreatorIdentification.ToString(); |
1535 | row["OwnerID"] = prim.OwnerID.ToString(); | 1535 | row["OwnerID"] = prim.OwnerID.ToString(); |
1536 | row["GroupID"] = prim.GroupID.ToString(); | 1536 | row["GroupID"] = prim.GroupID.ToString(); |
1537 | row["LastOwnerID"] = prim.LastOwnerID.ToString(); | 1537 | row["LastOwnerID"] = prim.LastOwnerID.ToString(); |
@@ -1664,7 +1664,7 @@ namespace OpenSim.Data.SQLiteLegacy | |||
1664 | row["name"] = taskItem.Name; | 1664 | row["name"] = taskItem.Name; |
1665 | row["description"] = taskItem.Description; | 1665 | row["description"] = taskItem.Description; |
1666 | row["creationDate"] = taskItem.CreationDate; | 1666 | row["creationDate"] = taskItem.CreationDate; |
1667 | row["creatorID"] = taskItem.CreatorID.ToString(); | 1667 | row["creatorID"] = taskItem.CreatorIdentification.ToString(); |
1668 | row["ownerID"] = taskItem.OwnerID.ToString(); | 1668 | row["ownerID"] = taskItem.OwnerID.ToString(); |
1669 | row["lastOwnerID"] = taskItem.LastOwnerID.ToString(); | 1669 | row["lastOwnerID"] = taskItem.LastOwnerID.ToString(); |
1670 | row["groupID"] = taskItem.GroupID.ToString(); | 1670 | row["groupID"] = taskItem.GroupID.ToString(); |