aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data')
-rw-r--r--OpenSim/Data/MySQL/MySQLRegionData.cs6
-rw-r--r--OpenSim/Data/MySQL/Resources/020_RegionStore.sql7
-rw-r--r--OpenSim/Data/SQLite/Resources/013_RegionStore.sql6
-rw-r--r--OpenSim/Data/SQLite/SQLiteRegionData.cs7
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 @@
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
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 @@
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;
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>