From 1bd0721dbec03ea833ec639c1759abcc1e7cbdae Mon Sep 17 00:00:00 2001 From: Melanie Thielker Date: Fri, 14 Nov 2008 19:00:14 +0000 Subject: Add SQLite and the missing migrations files for last commit --- OpenSim/Data/MySQL/Resources/003_InventoryStore.sql | 5 +++++ OpenSim/Data/SQLite/Resources/003_InventoryStore.sql | 5 +++++ OpenSim/Data/SQLite/SQLiteInventoryStore.cs | 3 +++ 3 files changed, 13 insertions(+) create mode 100644 OpenSim/Data/MySQL/Resources/003_InventoryStore.sql create mode 100644 OpenSim/Data/SQLite/Resources/003_InventoryStore.sql diff --git a/OpenSim/Data/MySQL/Resources/003_InventoryStore.sql b/OpenSim/Data/MySQL/Resources/003_InventoryStore.sql new file mode 100644 index 0000000..4c6da91 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/003_InventoryStore.sql @@ -0,0 +1,5 @@ +BEGIN; + +alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0; + +COMMIT; 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 @@ +BEGIN; + +alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0; + +COMMIT; 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 item.CurrentPermissions = Convert.ToUInt32(row["inventoryCurrentPermissions"]); item.BasePermissions = Convert.ToUInt32(row["inventoryBasePermissions"]); item.EveryOnePermissions = Convert.ToUInt32(row["inventoryEveryOnePermissions"]); + item.GroupPermissions = Convert.ToUInt32(row["inventoryGroupPermissions"]); // new fields if (!Convert.IsDBNull(row["salePrice"])) @@ -195,6 +196,7 @@ namespace OpenSim.Data.SQLite row["inventoryCurrentPermissions"] = item.CurrentPermissions; row["inventoryBasePermissions"] = item.BasePermissions; row["inventoryEveryOnePermissions"] = item.EveryOnePermissions; + row["inventoryGroupPermissions"] = item.GroupPermissions; // new fields row["salePrice"] = item.SalePrice; @@ -723,6 +725,7 @@ namespace OpenSim.Data.SQLite createCol(inv, "inventoryCurrentPermissions", typeof (Int32)); createCol(inv, "inventoryBasePermissions", typeof (Int32)); createCol(inv, "inventoryEveryOnePermissions", typeof (Int32)); + createCol(inv, "inventoryGroupPermissions", typeof (Int32)); // sale info createCol(inv, "salePrice", typeof(Int32)); -- cgit v1.1