Changes between Version 9 and Version 10 of TaskRecordedFile

Timestamp:

01/17/11 21:28:53 (16 years ago)

Author:

sphery

Comment:

a video's length can not be in mediafile, since mediafile will include non-video files, like preview images and coverfiles and fanart.

TaskRecordedFile

@@ -66 +66 @@
         chanid        INT UNSIGNED NOT NULL DEFAULT 0,
         starttime     DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
-        defaultfile   TINYINT(1) NOT NULL DEFAULT 0,
 
 # Recording start and end times.  The (new) recorded table's start/end times
@@ -73 +72 @@
         recstart      DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
         recend      DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+
+        defaultfile   TINYINT(1) NOT NULL DEFAULT 0,
 
         PRIMARY KEY (chanid, starttime, fileid),
@@ -152 +153 @@
         subtype         INT UNSIGNED NOT NULL DEFAULT 0,
 
-# length of video in seconds (used for display of total duration information to user)
-        length        INT UNSIGNED NOT NULL DEFAULT 0,
-
 # comment ('Original Recording', 'Transcoded Copy', 'iPod format', etc.)
 #             for use by MythTV when asking the user which of multiple files
@@ -197 +195 @@
 
         type            INT UNSIGNED NOT NULL DEFAULT 0,
+# length of video in seconds (used for display of total duration information to user)
+        length          INT UNSIGNED NOT NULL DEFAULT 0,
+
         primarystream   TINYINT(1) NOT NULL DEFAULT 0,        
         description     VARCHAR(255) NOT NULL DEFAULT ''