diff options
author | Melanie Thielker | 2008-11-14 19:00:14 +0000 |
---|---|---|
committer | Melanie Thielker | 2008-11-14 19:00:14 +0000 |
commit | 1bd0721dbec03ea833ec639c1759abcc1e7cbdae (patch) | |
tree | 7da6e578c3c19de6fe52cb381543869cdb1ae74c /OpenSim/Data/SQLite | |
parent | Add group permissions to agent inventory. (diff) | |
download | opensim-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.sql | 5 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteInventoryStore.cs | 3 |
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 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0; | ||
4 | |||
5 | 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 | |||
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)); |