From 16b0b2c8a71cb46412a710db08c9d13559787910 Mon Sep 17 00:00:00 2001 From: Stefan Koegl Date: Fri, 26 Mar 2010 15:01:45 +0100 Subject: [PATCH] adding indices to subscribers in update-20.sql --- install/update-20.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/install/update-20.sql b/install/update-20.sql index 0cab2023..59e748f3 100644 --- a/install/update-20.sql +++ b/install/update-20.sql @@ -65,3 +65,8 @@ BEGIN END;// DELIMITER ; + +CREATE INDEX subscriptions_user_index ON subscriptions (user_id); +CREATE INDEX subscriptions_device_index ON subscriptions (device_id); +CREATE INDEX subscriptions_podcast_index ON subscriptions (podcast_id); + -- 2.11.4.GIT