From 5e95d46d072478cf07c879a679c2492e8c99a890 Mon Sep 17 00:00:00 2001
From: DrFrasierCrane <yagood@o2.pl>
Date: Wed, 5 Dec 2007 07:56:09 +0100
Subject: [PATCH] Added more indexes to database schema.

---
 data/sql/create_01.sql | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/data/sql/create_01.sql b/data/sql/create_01.sql
index 451d045..a80bb0a 100644
--- a/data/sql/create_01.sql
+++ b/data/sql/create_01.sql
@@ -29,6 +29,10 @@ CREATE TABLE IF NOT EXISTS treeview_nodes (
     type VARCHAR(1) NOT NULL
 );
 --
+CREATE INDEX idx_feeds_id ON feeds(id);
+--
+CREATE INDEX idx_feeds_category_id ON feeds(category_id);
+--
 CREATE INDEX idx_items_feed_id ON items(feed_id);
 --
 INSERT INTO categories (parent_id, title) VALUES (NULL, 'root');
\ No newline at end of file
-- 
2.11.4.GIT