diff options
Diffstat (limited to 'lib/class/update.class.php')
| -rw-r--r-- | lib/class/update.class.php | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/lib/class/update.class.php b/lib/class/update.class.php index 31446e76..7a32c776 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -377,6 +377,9 @@ class Update { $update_string = '- Allow compound MBIDs in the artist table.<br />'; $version[] = array('version' => '360010', 'description' => $update_string); + $update_string = '- Add table to store stream session playlist.<br />'; + $version[] = array('version' => '360011', 'description' => $update_string); + return $version; } // populate_version @@ -2089,5 +2092,27 @@ class Update { self::set_version('db_version', '360010'); } + /** + * update_380011 + * We need a place to store actual playlist data for downloadable + * playlist files. + */ + public static function update_360011() { + $sql = 'CREATE TABLE `stream_playlist` (' . + '`id` int(11) unsigned NOT NULL AUTO_INCREMENT,' . + '`sid` varchar(64) COLLATE utf8_unicode_ci NOT NULL,' . + '`url` text COLLATE utf8_unicode_ci NOT NULL,' . + '`info_url` text COLLATE utf8_unicode_ci DEFAULT NULL,' . + '`image_url` text COLLATE utf8_unicode_ci DEFAULT NULL,' . + '`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,' . + '`author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,' . + '`album` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,' . + '`type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,' . + '`time` smallint(5) DEFAULT NULL,' . + 'PRIMARY KEY (`id`), KEY `sid` (`sid`))'; + $db_results = Dba::write($sql); + self::set_version('db_version', '360011'); + } + } // end update class ?> |