diff options
Diffstat (limited to 'OpenSim/Data')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLRegionData.cs | 6 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/020_RegionStore.sql | 7 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/Resources/013_RegionStore.sql | 6 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteRegionData.cs | 7 |
4 files changed, 26 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 | |||
diff --git a/OpenSim/Data/SQLite/Resources/013_RegionStore.sql b/OpenSim/Data/SQLite/Resources/013_RegionStore.sql new file mode 100644 index 0000000..11529cd --- /dev/null +++ b/OpenSim/Data/SQLite/Resources/013_RegionStore.sql | |||
@@ -0,0 +1,6 @@ | |||
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; | ||
diff --git a/OpenSim/Data/SQLite/SQLiteRegionData.cs b/OpenSim/Data/SQLite/SQLiteRegionData.cs index c87d2e3..812367d 100644 --- a/OpenSim/Data/SQLite/SQLiteRegionData.cs +++ b/OpenSim/Data/SQLite/SQLiteRegionData.cs | |||
@@ -992,6 +992,8 @@ namespace OpenSim.Data.SQLite | |||
992 | createCol(land, "UserLookAtY", typeof (Double)); | 992 | createCol(land, "UserLookAtY", typeof (Double)); |
993 | createCol(land, "UserLookAtZ", typeof (Double)); | 993 | createCol(land, "UserLookAtZ", typeof (Double)); |
994 | createCol(land, "AuthbuyerID", typeof(String)); | 994 | createCol(land, "AuthbuyerID", typeof(String)); |
995 | createCol(land, "OtherCleanTime", typeof(Int32)); | ||
996 | createCol(land, "Dwell", typeof(Int32)); | ||
995 | 997 | ||
996 | land.PrimaryKey = new DataColumn[] {land.Columns["UUID"]}; | 998 | land.PrimaryKey = new DataColumn[] {land.Columns["UUID"]}; |
997 | 999 | ||
@@ -1315,6 +1317,9 @@ namespace OpenSim.Data.SQLite | |||
1315 | 1317 | ||
1316 | UUID.TryParse((string)row["AuthbuyerID"], out authBuyerID); | 1318 | UUID.TryParse((string)row["AuthbuyerID"], out authBuyerID); |
1317 | 1319 | ||
1320 | newData.OtherCleanTime = Convert.ToInt32(row["OtherCleanTime"]); | ||
1321 | newData.Dwell = Convert.ToInt32(row["Dwell"]); | ||
1322 | |||
1318 | return newData; | 1323 | return newData; |
1319 | } | 1324 | } |
1320 | 1325 | ||
@@ -1611,6 +1616,8 @@ namespace OpenSim.Data.SQLite | |||
1611 | row["UserLookAtY"] = land.UserLookAt.Y; | 1616 | row["UserLookAtY"] = land.UserLookAt.Y; |
1612 | row["UserLookAtZ"] = land.UserLookAt.Z; | 1617 | row["UserLookAtZ"] = land.UserLookAt.Z; |
1613 | row["AuthbuyerID"] = Util.ToRawUuidString(land.AuthBuyerID); | 1618 | row["AuthbuyerID"] = Util.ToRawUuidString(land.AuthBuyerID); |
1619 | row["OtherCleanTime"] = land.OtherCleanTime; | ||
1620 | row["Dwell"] = land.Dwell; | ||
1614 | } | 1621 | } |
1615 | 1622 | ||
1616 | /// <summary> | 1623 | /// <summary> |