aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources
diff options
context:
space:
mode:
authorSean Dague2008-06-13 14:27:46 +0000
committerSean Dague2008-06-13 14:27:46 +0000
commit6c23acf41b6ba226dc943cce6afa5f0ef01b838b (patch)
tree33b4d7b6489e369505d8e6cd050f3b24cc61982d /OpenSim/Data/SQLite/Resources
parentA little minor cleanup and harmonizing between LSL_BuiltIn_Commands.cs (diff)
downloadopensim-SC-6c23acf41b6ba226dc943cce6afa5f0ef01b838b.zip
opensim-SC-6c23acf41b6ba226dc943cce6afa5f0ef01b838b.tar.gz
opensim-SC-6c23acf41b6ba226dc943cce6afa5f0ef01b838b.tar.bz2
opensim-SC-6c23acf41b6ba226dc943cce6afa5f0ef01b838b.tar.xz
add indexes for sqlite inventory
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-rw-r--r--OpenSim/Data/SQLite/Resources/002_InventoryStore.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/002_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/002_InventoryStore.sql
new file mode 100644
index 0000000..01951d6
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/002_InventoryStore.sql
@@ -0,0 +1,8 @@
1BEGIN TRANSACTION;
2
3create index inventoryfolders_agentid on inventoryfolders(agentid);
4create index inventoryfolders_parentid on inventoryfolders(parentid);
5create index inventoryitems_parentfolderid on inventoryitems(parentfolderid);
6create index inventoryitems_avatarid on inventoryitems(avatarid);
7
8COMMIT; \ No newline at end of file