summaryrefslogtreecommitdiff
path: root/p2pvr/lib/sql/Schedules_selectById.sql
diff options
context:
space:
mode:
authorrandomdan <randomdan@localhost>2014-01-09 20:31:18 +0000
committerrandomdan <randomdan@localhost>2014-01-09 20:31:18 +0000
commit800ab74ea27ca22aa62e953cbc012989c23c34ca (patch)
tree67161266c9deb51cf8bb57d91401652c26f6ebc2 /p2pvr/lib/sql/Schedules_selectById.sql
parentMakefile scripts for updating schema/database (diff)
downloadp2pvr-800ab74ea27ca22aa62e953cbc012989c23c34ca.tar.bz2
p2pvr-800ab74ea27ca22aa62e953cbc012989c23c34ca.tar.xz
p2pvr-800ab74ea27ca22aa62e953cbc012989c23c34ca.zip
Basic implementation of a recorder
Diffstat (limited to 'p2pvr/lib/sql/Schedules_selectById.sql')
-rw-r--r--p2pvr/lib/sql/Schedules_selectById.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/p2pvr/lib/sql/Schedules_selectById.sql b/p2pvr/lib/sql/Schedules_selectById.sql
new file mode 100644
index 0000000..2eb7b0b
--- /dev/null
+++ b/p2pvr/lib/sql/Schedules_selectById.sql
@@ -0,0 +1,5 @@
+SELECT scheduleid, serviceid, eventid, title, search, priority, early::text early, late::text late, repeats
+FROM schedules
+WHERE scheduleid = ?
+ORDER BY scheduleId
+