Changes between Version 10 and Version 11 of TaskRecordedFile

Timestamp:

01/23/11 00:33:03 (16 years ago)

Author:

sphery

Comment:

Don't use starttime/endtime. Avoids the confusion we've always had over the meaning of starttime/endtime. Instead, be explicit and use progstart/progend and recstart/recend everywhere.

TaskRecordedFile

@@ -38 +38 @@
 # Two versions after migration, delete the following fields which would be
 #     unused at that time:
+# - starttime
+# - endtime
 # - storagegroup
 # - hostname
@@ -49 +51 @@
 # - filesize
 # 
-# The old recorded.starttime/endtime values, which correspond to recording
+# The former recorded.starttime/endtime values, which correspond to recording
 #    start/end times, will be in recordedfile.recstart and recordedfile.recend.
-# Also deleted/moved are:
-# - progstart (the starttime field will reference program listings start time)
-# - progend (the endtime field will reference program listings end time)
+# The recorded.progstart/progend columns will be moved to the location where
+#    recorded.starttime/endtime were.
 
 ##############################################################################
@@ -65 +66 @@
 
         chanid        INT UNSIGNED NOT NULL DEFAULT 0,
-        starttime     DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+        progstart     DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
 
 # Recording start and end times.  The (new) recorded table's start/end times
@@ -75 +76 @@
         defaultfile   TINYINT(1) NOT NULL DEFAULT 0,
 
-        PRIMARY KEY (chanid, starttime, fileid),
+        PRIMARY KEY (chanid, progstart, fileid),
         INDEX (fileid)
         );