[Android] Fix typo in MRL trigger

[Geoffrey Métais]

vlc-ports/android | branch: master | Geoffrey Métais <geoffrey.metais at gmail.com> | Thu Mar  5 12:17:27 2015 +0100| [b630f87d62f2c9f99be7f4c143b8d3843a71d9fe] | committer: Geoffrey Métais

Fix typo in MRL trigger

> http://git.videolan.org/gitweb.cgi/vlc-ports/android.git/?a=commit;h=b630f87d62f2c9f99be7f4c143b8d3843a71d9fe
---

 vlc-android/src/org/videolan/vlc/MediaDatabase.java |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/vlc-android/src/org/videolan/vlc/MediaDatabase.java b/vlc-android/src/org/videolan/vlc/MediaDatabase.java
index 06f2ef5..80684cc 100644
--- a/vlc-android/src/org/videolan/vlc/MediaDatabase.java
+++ b/vlc-android/src/org/videolan/vlc/MediaDatabase.java
@@ -238,7 +238,7 @@ public class MediaDatabase {
             createMrlTableQuery = " CREATE TRIGGER mrl_history_trigger AFTER INSERT ON "+
                     MRL_TABLE_NAME+ " BEGIN "+
                     " DELETE FROM "+MRL_TABLE_NAME+" where "+MRL_URI+" NOT IN (SELECT "+MRL_URI+
-                    " from "+MRL_TABLE_NAME+" ORDER BY insertion_date DESC LIMIT "+MRL_TABLE_SIZE+");"+
+                    " from "+MRL_TABLE_NAME+" ORDER BY "+MRL_DATE+" DESC LIMIT "+MRL_TABLE_SIZE+");"+
                     " END";
             db.execSQL(createMrlTableQuery);
         }