Changes between Version 8 and Version 9 of TaskRecordedFile


Ignore:
Timestamp:
01/17/11 21:17:37 (16 years ago)
Author:
sphery
Comment:

Fix progstart/progend, which can't be in recorded since we may have multiple parts for a recording

Legend:

Unmodified
Added
Removed
Modified

  • TaskRecordedFile

    v8 v9  
    4848# - editing
    4949# - filesize
     50#
     51# The old recorded.starttime/endtime values, which correspond to recording
     52#    start/end times, will be in recordedfile.recstart and recordedfile.recend.
     53# Also deleted/moved are:
     54# - progstart (the starttime field will reference program listings start time)
     55# - progend (the endtime field will reference program listings end time)
    5056
    5157##############################################################################
    … …  
    6167        starttime     DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    6268        defaultfile   TINYINT(1) NOT NULL DEFAULT 0,
     69
     70# Recording start and end times.  The (new) recorded table's start/end times
     71# will reference only values from listings data--allowing us to link multiple
     72# parts of the same recording to a single row in recorded.
     73        recstart      DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
     74        recend      DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    6375
    6476        PRIMARY KEY (chanid, starttime, fileid),