[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1219] update view definition
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1219] update view definition |
Date: |
Wed, 06 May 2009 01:06:26 +0000 |
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),
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1219] update view definition,
Clint Adams <=