Changes between Version 15 and Version 16 of TaskRecordedFile

Timestamp:

03/15/11 23:02:16 (15 years ago)

Author:

sphery

Comment:

Add in metadatacommon and modify recorded and videofilemetadata appropriately

TaskRecordedFile

@@ -50 +50 @@
 # - editing
 # - filesize
+# - stars
+#
+# Add metadataid, which refers to a record in metadatacommon.
 # 
 # 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 recorded.progstart/progend columns will be moved to the location where
 #    recorded.starttime/endtime were.
@@ -82 +86 @@
 ##############################################################################
 # Table for storing info about a MythVideo video, joins to videofile.
+#  - videometadata.userrating moves to metadatacommon.stars
+#  - videometadata.rating moves to metadatacommon.certification
+#
 DROP TABLE IF EXISTS videofilemetadata;
 CREATE TABLE videofilemetadata (
@@ -89 +96 @@
         subtitle      VARCHAR(128) NOT NULL DEFAULT '',
         tagline       VARCHAR(255) NOT NULL DEFAULT '',
-        director      VARCHAR(128) NOT NULL DEFAULT '',
-        studio        VARCHAR(128) NOT NULL DEFAULT '',
         plot          VARCHAR(8000) NOT NULL DEFAULT '',
-        rating        VARCHAR(128) NOT NULL DEFAULT '',
         inetref       VARCHAR(255) NOT NULL DEFAULT '',
-        homepage      VARCHAR(8000) NOT NULL DEFAULT '',
         year          SMALLINT(5) NOT NULL DEFAULT 0,
         releasedate   DATE NOT NULL DEFAULT '0000-00-00',
-        userrating    FLOAT NOT NULL DEFAULT 0,
         length        SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-        season        SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-        episode       SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
         insertdate    DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
         showlevel     SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
         browse        TINYINT(1) NOT NULL DEFAULT 0,
         category      INT UNSIGNED NOT NULL DEFAULT 0,
+        metadataid    INT UNSIGNED NOT NULL DEFAULT 0,
+
+        INDEX (videoid)
+        );
+
+##############################################################################
+# Table for common metadata for recordings and MythVideo videos.
+#  - metadatacommon.stars replaces videometadata.userrating and recorded.stars
+#  - metadatacommon.certification replaces videometadata.rating
+#
+DROP TABLE IF EXISTS metadatacommon;
+CREATE TABLE metadatacommon (
+        metadataid    INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
+
+        director      VARCHAR(128) NOT NULL DEFAULT '',
+        studio        VARCHAR(128) NOT NULL DEFAULT '',
+        certification VARCHAR(128) 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,
+        stars         FLOAT NOT NULL DEFAULT 0,
+        processed     TINYINT(1) NOT NULL DEFAULT 0,
         trailer       INT UNSIGNED NOT NULL DEFAULT 0,
         coverfile     INT UNSIGNED NOT NULL DEFAULT 0,
@@ -110 +132 @@
         banner        INT UNSIGNED NOT NULL DEFAULT 0,
         fanart        INT UNSIGNED NOT NULL DEFAULT 0,
-        processed     TINYINT(1) NOT NULL DEFAULT 0,
-
-        INDEX (videoid)
+
+        INDEX (metadataid)
         );