simplify subscribing/unsubscribing podcasts
[mygpo.git] / install / update-21.sql
blob3f0e915a74e0593f723ded6a12dde804ca277d87
1 -- episode indices
2 create index episode_podcast_index on episode (podcast_id);
3 create index episode_url_index on episode (url);
5 -- episode_log indices
6 create index user_id on episode_log(user_id);
7 create index action on episode_log(action);
8 create index timestamp on episode_log(timestamp);