diff options
| author | randomdan <randomdan@localhost> | 2014-03-13 19:42:07 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2014-03-13 19:42:07 +0000 |
| commit | ab1eee942e75874739ce5f0b4ba289aac5cc3faf (patch) | |
| tree | 6e43828794fe0c0c5c9921ec1911695b67357c50 /p2pvr/daemon/sql/Recordings_getAll.sql | |
| parent | Expose more of the interface (diff) | |
| download | p2pvr-ab1eee942e75874739ce5f0b4ba289aac5cc3faf.tar.bz2 p2pvr-ab1eee942e75874739ce5f0b4ba289aac5cc3faf.tar.xz p2pvr-ab1eee942e75874739ce5f0b4ba289aac5cc3faf.zip | |
Restructure into more sensibly arranged libs
Diffstat (limited to 'p2pvr/daemon/sql/Recordings_getAll.sql')
| -rw-r--r-- | p2pvr/daemon/sql/Recordings_getAll.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/p2pvr/daemon/sql/Recordings_getAll.sql b/p2pvr/daemon/sql/Recordings_getAll.sql new file mode 100644 index 0000000..c0a096c --- /dev/null +++ b/p2pvr/daemon/sql/Recordings_getAll.sql @@ -0,0 +1,3 @@ +SELECT recordingId, storageAddress, guid, scheduleId, title, subtitle, description, startTime, duration +FROM recordings r +ORDER BY startTime, title, subtitle |