[Librefm-commits] [1219] update view definition

[Clint Adams]

Revision: 1219
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1219
Author:   clint
Date:     2009-05-06 01:06:26 +0000 (Wed, 06 May 2009)
Log Message:
-----------
update view definition

Modified Paths:
--------------
    trunk/gnukebox/install.php

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-05-06 00:25:02 UTC (rev 1218)
+++ trunk/gnukebox/install.php  2009-05-06 01:06:26 UTC (rev 1219)
@@ -243,7 +243,12 @@
                        mbid VARCHAR(36),
                        track INTEGER NOT NULL)");
 
-       $res = $mdb2->exec("CREATE VIEW Free_Scrobbles AS SELECT s.* FROM 
Scrobbles s INNER JOIN Track t on lower(s.artist)=lower(t.artist) and 
lower(s.track)=lower(t.name) where t.streamable=1");
+       $res = $mdb2->exec("CREATE VIEW Free_Scrobbles AS
+                       SELECT s.username, s.track, s.artist, s.time, s.mbid, 
s.album, s.source, s.rating, s.length
+                               FROM Scrobbles s
+                               JOIN Scrobble_Track st ON s.stid = st.id
+                               JOIN Track t ON st.track = t.id
+                               WHERE t.streamable = 1");
 
        $res = $mdb2->query("CREATE TABLE User_Relationships (
                username VARCHAR(64) REFERENCES Users(username),