aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite
diff options
context:
space:
mode:
authorMelanie Thielker2008-11-14 19:00:14 +0000
committerMelanie Thielker2008-11-14 19:00:14 +0000
commit1bd0721dbec03ea833ec639c1759abcc1e7cbdae (patch)
tree7da6e578c3c19de6fe52cb381543869cdb1ae74c /OpenSim/Data/SQLite
parentAdd group permissions to agent inventory. (diff)
downloadopensim-SC-1bd0721dbec03ea833ec639c1759abcc1e7cbdae.zip
opensim-SC-1bd0721dbec03ea833ec639c1759abcc1e7cbdae.tar.gz
opensim-SC-1bd0721dbec03ea833ec639c1759abcc1e7cbdae.tar.bz2
opensim-SC-1bd0721dbec03ea833ec639c1759abcc1e7cbdae.tar.xz
Add SQLite and the missing migrations files for last commit
Diffstat (limited to 'OpenSim/Data/SQLite')
-rw-r--r--OpenSim/Data/SQLite/Resources/003_InventoryStore.sql5
-rw-r--r--OpenSim/Data/SQLite/SQLiteInventoryStore.cs3
2 files changed, 8 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/003_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/003_InventoryStore.sql
new file mode 100644
index 0000000..4c6da91
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/003_InventoryStore.sql
@@ -0,0 +1,5 @@
1BEGIN;
2
3alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0;
4
5COMMIT;
diff --git a/OpenSim/Data/SQLite/SQLiteInventoryStore.cs b/OpenSim/Data/SQLite/SQLiteInventoryStore.cs
index fe1edde..c497396 100644
--- a/OpenSim/Data/SQLite/SQLiteInventoryStore.cs
+++ b/OpenSim/Data/SQLite/SQLiteInventoryStore.cs
@@ -151,6 +151,7 @@ namespace OpenSim.Data.SQLite
151 item.CurrentPermissions = Convert.ToUInt32(row["inventoryCurrentPermissions"]); 151 item.CurrentPermissions = Convert.ToUInt32(row["inventoryCurrentPermissions"]);
152 item.BasePermissions = Convert.ToUInt32(row["inventoryBasePermissions"]); 152 item.BasePermissions = Convert.ToUInt32(row["inventoryBasePermissions"]);
153 item.EveryOnePermissions = Convert.ToUInt32(row["inventoryEveryOnePermissions"]); 153 item.EveryOnePermissions = Convert.ToUInt32(row["inventoryEveryOnePermissions"]);
154 item.GroupPermissions = Convert.ToUInt32(row["inventoryGroupPermissions"]);
154 155
155 // new fields 156 // new fields
156 if (!Convert.IsDBNull(row["salePrice"])) 157 if (!Convert.IsDBNull(row["salePrice"]))
@@ -195,6 +196,7 @@ namespace OpenSim.Data.SQLite
195 row["inventoryCurrentPermissions"] = item.CurrentPermissions; 196 row["inventoryCurrentPermissions"] = item.CurrentPermissions;
196 row["inventoryBasePermissions"] = item.BasePermissions; 197 row["inventoryBasePermissions"] = item.BasePermissions;
197 row["inventoryEveryOnePermissions"] = item.EveryOnePermissions; 198 row["inventoryEveryOnePermissions"] = item.EveryOnePermissions;
199 row["inventoryGroupPermissions"] = item.GroupPermissions;
198 200
199 // new fields 201 // new fields
200 row["salePrice"] = item.SalePrice; 202 row["salePrice"] = item.SalePrice;
@@ -723,6 +725,7 @@ namespace OpenSim.Data.SQLite
723 createCol(inv, "inventoryCurrentPermissions", typeof (Int32)); 725 createCol(inv, "inventoryCurrentPermissions", typeof (Int32));
724 createCol(inv, "inventoryBasePermissions", typeof (Int32)); 726 createCol(inv, "inventoryBasePermissions", typeof (Int32));
725 createCol(inv, "inventoryEveryOnePermissions", typeof (Int32)); 727 createCol(inv, "inventoryEveryOnePermissions", typeof (Int32));
728 createCol(inv, "inventoryGroupPermissions", typeof (Int32));
726 729
727 // sale info 730 // sale info
728 createCol(inv, "salePrice", typeof(Int32)); 731 createCol(inv, "salePrice", typeof(Int32));