diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2014-12-30 19:52:21 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-06-13 17:29:37 +0100 |
| commit | f31ff1177eec7ffa0ea6375b77d78d69559f9c88 (patch) | |
| tree | 9e3bbb6dabbf2b082d793ca470fb8c790225663d /p2pvr/daemon/sql/Recordings_getAll.sql | |
| parent | Don't create comically broken sample data and fix the last sample (diff) | |
| download | p2pvr-f31ff1177eec7ffa0ea6375b77d78d69559f9c88.tar.bz2 p2pvr-f31ff1177eec7ffa0ea6375b77d78d69559f9c88.tar.xz p2pvr-f31ff1177eec7ffa0ea6375b77d78d69559f9c88.zip | |
Big commit comprising mostly of changes to the DB structure to unify recorded event details into events, lots of new unit tests
Diffstat (limited to 'p2pvr/daemon/sql/Recordings_getAll.sql')
| -rw-r--r-- | p2pvr/daemon/sql/Recordings_getAll.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/p2pvr/daemon/sql/Recordings_getAll.sql b/p2pvr/daemon/sql/Recordings_getAll.sql index c0a096c..3c3ff51 100644 --- a/p2pvr/daemon/sql/Recordings_getAll.sql +++ b/p2pvr/daemon/sql/Recordings_getAll.sql @@ -1,3 +1,3 @@ -SELECT recordingId, storageAddress, guid, scheduleId, title, subtitle, description, startTime, duration +SELECT recordingId, storageAddress, guid, scheduleId, eventUid FROM recordings r -ORDER BY startTime, title, subtitle +ORDER BY recordingId |