diff options
Diffstat (limited to 'lib/class/update.class.php')
| -rw-r--r-- | lib/class/update.class.php | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/lib/class/update.class.php b/lib/class/update.class.php index 7127f1d5..291c26e8 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -1143,9 +1143,29 @@ class Update { $sql = "ALTER TABLE `playlist` ADD `date` INT ( 11 ) UNSIGNED NOT NULL"; $db_results = Dba::query($sql); - $sql = "ALTER TABLE `rating` CHANGE `rating` TINYINT ( 4 ) NOT NULL"; + // Pull all of the rating information + $sql = "SELECT `id`,`rating` FROM `rating`"; $db_results = Dba::query($sql); + $results = array(); + + while ($row = Dba::fetch_assoc($db_results)) { + $results[] = $row; + } + + $sql = "ALTER TABLE `rating` DROP `rating`"; + $db_results = Dba::query($sql); + + $sql = "ALTER TABLE `rating` ADD `rating` TINYINT ( 4 ) NOT NULL"; + $db_results = Dba::query($sql); + + foreach ($results as $row) { + $rating = Dba::escape($row['rating']); + $id = Dba::escape($row['id']); + $sql = "UPDATE `rating` SET `rating`='$rating' WHERE `id`='$id'"; + $db_results = Dba::query($sql); + } + self::set_version('db_version','340015'); } // update_340015 |