diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLRegionData.cs | 6 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/020_RegionStore.sql | 7 |
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 @@ | |||
1 | begin; | ||
2 | |||
3 | ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0; | ||
4 | ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0; | ||
5 | |||
6 | commit; | ||
7 | |||