Changes between Version 16 and Version 17 of TaskRecordedFile

Timestamp:

Mar 15, 2011, 11:23:35 PM (13 years ago)

Author:

sphery

Comment:

combine videofilemetadata.releasedate and recording.originalairdate as as metadatacommon.releasedate; move inetref to common

TaskRecordedFile

@@ -51 +51 @@
 # - filesize
 # - stars
+# - originalairdate
 #
 # Add metadataid, which refers to a record in metadatacommon.
@@ -56 +57 @@
 # The former recorded.starttime/endtime values, which correspond to recording
 #    start/end times, will be in recordedfile.recstart and recordedfile.recend.
-# The former recorded.stars value will be moved to metadatacommon.stars.
+# The former recorded.stars value will be in metadatacommon.stars.
+# The former recorded.originalairdate value will be in
+#    metadatacommon.releasedate.
 # The recorded.progstart/progend columns will be moved to the location where
 #    recorded.starttime/endtime were.
@@ -86 +89 @@
 ##############################################################################
 # Table for storing info about a MythVideo video, joins to videofile.
-#  - videometadata.userrating moves to metadatacommon.stars
-#  - videometadata.rating moves to metadatacommon.certification
+#  - videometadata.userrating will be in metadatacommon.stars
+#  - videometadata.rating will be in metadatacommon.certification
+#  - videometadta.year will be combined with/replaced by releasedate
 #
 DROP TABLE IF EXISTS videofilemetadata;
@@ -97 +101 @@
         tagline       VARCHAR(255) NOT NULL DEFAULT '',
         plot          VARCHAR(8000) NOT NULL DEFAULT '',
-        inetref       VARCHAR(255) NOT NULL DEFAULT '',
-        year          SMALLINT(5) NOT NULL DEFAULT 0,
-        releasedate   DATE NOT NULL DEFAULT '0000-00-00',
         length        SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
         insertdate    DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
@@ -122 +123 @@
         studio        VARCHAR(128) NOT NULL DEFAULT '',
         certification VARCHAR(128) NOT NULL DEFAULT '',
+        inetref       VARCHAR(255) NOT NULL DEFAULT '',
         homepage      VARCHAR(8000) NOT NULL DEFAULT '',
         season        SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
         episode       SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
+        releasedate   DATE NOT NULL DEFAULT '0000-00-00',
         stars         FLOAT NOT NULL DEFAULT 0,
         processed     TINYINT(1) NOT NULL DEFAULT 0,