aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/MySQLRegionData.cs6
-rw-r--r--OpenSim/Data/MySQL/Resources/020_RegionStore.sql7
2 files changed, 13 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/MySQLRegionData.cs b/OpenSim/Data/MySQL/MySQLRegionData.cs
index ae048fe..ab7e92d 100644
--- a/OpenSim/Data/MySQL/MySQLRegionData.cs
+++ b/OpenSim/Data/MySQL/MySQLRegionData.cs
@@ -994,6 +994,8 @@ namespace OpenSim.Data.MySQL
994 createCol(land, "UserLookAtY", typeof (Double)); 994 createCol(land, "UserLookAtY", typeof (Double));
995 createCol(land, "UserLookAtZ", typeof (Double)); 995 createCol(land, "UserLookAtZ", typeof (Double));
996 createCol(land, "AuthBuyerID", typeof (String)); 996 createCol(land, "AuthBuyerID", typeof (String));
997 createCol(land, "OtherCleanTime", typeof(Int32));
998 createCol(land, "Dwell", typeof(Int32));
997 999
998 land.PrimaryKey = new DataColumn[] {land.Columns["UUID"]}; 1000 land.PrimaryKey = new DataColumn[] {land.Columns["UUID"]};
999 1001
@@ -1357,6 +1359,8 @@ namespace OpenSim.Data.MySQL
1357 1359
1358 UUID.TryParse((string)row["AuthBuyerID"], out authedbuyer); 1360 UUID.TryParse((string)row["AuthBuyerID"], out authedbuyer);
1359 UUID.TryParse((string)row["SnapshotUUID"], out snapshotID); 1361 UUID.TryParse((string)row["SnapshotUUID"], out snapshotID);
1362 newData.OtherCleanTime = Convert.ToInt32(row["OtherCleanTime"]);
1363 newData.Dwell = Convert.ToInt32(row["Dwell"]);
1360 1364
1361 newData.AuthBuyerID = authedbuyer; 1365 newData.AuthBuyerID = authedbuyer;
1362 newData.SnapshotID = snapshotID; 1366 newData.SnapshotID = snapshotID;
@@ -1661,6 +1665,8 @@ namespace OpenSim.Data.MySQL
1661 row["UserLookAtY"] = land.UserLookAt.Y; 1665 row["UserLookAtY"] = land.UserLookAt.Y;
1662 row["UserLookAtZ"] = land.UserLookAt.Z; 1666 row["UserLookAtZ"] = land.UserLookAt.Z;
1663 row["AuthBuyerID"] = land.AuthBuyerID; 1667 row["AuthBuyerID"] = land.AuthBuyerID;
1668 row["OtherCleanTime"] = land.OtherCleanTime;
1669 row["Dwell"] = land.Dwell;
1664 } 1670 }
1665 1671
1666 /// <summary> 1672 /// <summary>
diff --git a/OpenSim/Data/MySQL/Resources/020_RegionStore.sql b/OpenSim/Data/MySQL/Resources/020_RegionStore.sql
new file mode 100644
index 0000000..814ef48
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/020_RegionStore.sql
@@ -0,0 +1,7 @@
1begin;
2
3ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0;
4ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0;
5
6commit;
7