aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite
diff options
context:
space:
mode:
authorMelanie Thielker2008-10-03 12:11:38 +0000
committerMelanie Thielker2008-10-03 12:11:38 +0000
commitec47a1bff2f8bf18be308a059ca8aaa193c9f540 (patch)
tree59342254518d8e1a4ea46c98bba49bc75a58b367 /OpenSim/Data/SQLite
parentMantis #1360 (diff)
downloadopensim-SC_OLD-ec47a1bff2f8bf18be308a059ca8aaa193c9f540.zip
opensim-SC_OLD-ec47a1bff2f8bf18be308a059ca8aaa193c9f540.tar.gz
opensim-SC_OLD-ec47a1bff2f8bf18be308a059ca8aaa193c9f540.tar.bz2
opensim-SC_OLD-ec47a1bff2f8bf18be308a059ca8aaa193c9f540.tar.xz
Add database persistence for material setting
Diffstat (limited to 'OpenSim/Data/SQLite')
-rw-r--r--OpenSim/Data/SQLite/Resources/012_RegionStore.sql5
-rw-r--r--OpenSim/Data/SQLite/SQLiteRegionData.cs6
2 files changed, 11 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/012_RegionStore.sql b/OpenSim/Data/SQLite/Resources/012_RegionStore.sql
new file mode 100644
index 0000000..d952b78
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/012_RegionStore.sql
@@ -0,0 +1,5 @@
1BEGIN;
2
3ALTER TABLE prims ADD COLUMN Material INTEGER NOT NULL default 3;
4
5COMMIT;
diff --git a/OpenSim/Data/SQLite/SQLiteRegionData.cs b/OpenSim/Data/SQLite/SQLiteRegionData.cs
index bc64ba0..c6cd08f 100644
--- a/OpenSim/Data/SQLite/SQLiteRegionData.cs
+++ b/OpenSim/Data/SQLite/SQLiteRegionData.cs
@@ -859,6 +859,8 @@ namespace OpenSim.Data.SQLite
859 // click action 859 // click action
860 createCol(prims, "ClickAction", typeof (Byte)); 860 createCol(prims, "ClickAction", typeof (Byte));
861 861
862 createCol(prims, "Material", typeof(Int32));
863
862 // Add in contraints 864 // Add in contraints
863 prims.PrimaryKey = new DataColumn[] {prims.Columns["UUID"]}; 865 prims.PrimaryKey = new DataColumn[] {prims.Columns["UUID"]};
864 866
@@ -1213,6 +1215,8 @@ namespace OpenSim.Data.SQLite
1213 1215
1214 prim.SalePrice = Convert.ToInt32(row["SalePrice"]); 1216 prim.SalePrice = Convert.ToInt32(row["SalePrice"]);
1215 prim.ObjectSaleType = Convert.ToByte(row["SaleType"]); 1217 prim.ObjectSaleType = Convert.ToByte(row["SaleType"]);
1218
1219 prim.Material = Convert.ToByte(row["Material"]);
1216 return prim; 1220 return prim;
1217 } 1221 }
1218 1222
@@ -1529,6 +1533,8 @@ namespace OpenSim.Data.SQLite
1529 1533
1530 // click action 1534 // click action
1531 row["ClickAction"] = prim.ClickAction; 1535 row["ClickAction"] = prim.ClickAction;
1536
1537 row["SalePrice"] = prim.SalePrice;
1532 } 1538 }
1533 1539
1534 /// <summary> 1540 /// <summary>