From 6c23acf41b6ba226dc943cce6afa5f0ef01b838b Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Fri, 13 Jun 2008 14:27:46 +0000
Subject: add indexes for sqlite inventory

---
 OpenSim/Data/SQLite/Resources/002_InventoryStore.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 OpenSim/Data/SQLite/Resources/002_InventoryStore.sql

(limited to 'OpenSim/Data/SQLite/Resources/002_InventoryStore.sql')

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 @@
+BEGIN TRANSACTION;
+
+create index inventoryfolders_agentid on inventoryfolders(agentid);
+create index inventoryfolders_parentid on inventoryfolders(parentid);
+create index inventoryitems_parentfolderid on inventoryitems(parentfolderid);
+create index inventoryitems_avatarid on inventoryitems(avatarid);
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1

