diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-08-16 15:37:31 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-08-16 15:37:31 +0000 |
| commit | ce094e4d95762791de7fa32b0a83ab0da7254d70 (patch) | |
| tree | de1bade5cf1d376d0ad12b0578a197700bbbfa62 /lib/class/update.class.php | |
| parent | aeeb56a33bc863e3aea6f7e9fc96495492cbb2b6 (diff) | |
| download | ampache-ce094e4d95762791de7fa32b0a83ab0da7254d70.tar.gz ampache-ce094e4d95762791de7fa32b0a83ab0da7254d70.tar.bz2 ampache-ce094e4d95762791de7fa32b0a83ab0da7254d70.zip | |
first step towards multi-disk support, Thx Hugo Haas
Diffstat (limited to 'lib/class/update.class.php')
| -rw-r--r-- | lib/class/update.class.php | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/lib/class/update.class.php b/lib/class/update.class.php index 2c5f5694..a5160c7e 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -227,6 +227,12 @@ class Update { $version[] = array('version' => '340008','description' => $update_string); + $update_string = '- Added disk to Album table.<br />' . + '- Added artist_data for artist images and bios.<br />' . + '- Added DNS to access list to allow for dns based ACLs.<br />'; + + $version[] = array('version' => '340009','description' => $update_string); + return $version; } // populate_version @@ -904,5 +910,34 @@ class Update { } // update_340008 + /** + * update_340009 + * This modifies the song table to handle pos fields + */ + public static function update_340009() { + + $sql = "ALTER TABLE `album` ADD `disk` smallint(5) UNSIGNED DEFAULT NULL"; + $db_results = Dba::query($sql); + + $sql = "ALTER TABLE `album` ADD INDEX (`disk`)"; + $db_results = Dba::query($sql); + + $sql = "ALTER TABLE `access_list` ADD `dns` VARCHAR( 255 ) NOT NULL AFTER `end`"; + $db_results = Dba::query($sql); + + $sql = "CREATE TABLE `artist_data` (" . + "`artist_id` INT( 11 ) UNSIGNED NOT NULL ," . + "`art` MEDIUMBLOB NOT NULL ," . + "`art_mime` VARCHAR( 32 ) NOT NULL ," . + "`thumb` BLOB NOT NULL ," . + "`thumb_mime` VARCHAR( 32 ) NOT NULL ," . + "`bio` TEXT NOT NULL , " . + "UNIQUE (`artist_id`) ) ENGINE = MYISAM"; + $db_results = Dba::query($sql); + + self::set_version('db_version','340009'); + + } // update_340009 + } // end update class ?> |