From 640e44d687a88dc73d6b7e9ab220505b518dae78 Mon Sep 17 00:00:00 2001
From: Karl 'vollmerk' Vollmer <vollmer@ampache.org>
Date: Tue, 8 May 2007 04:37:45 +0000
Subject: few more minor updates to the db that I just noticed needed to be
 done

---
 lib/class/update.class.php | 17 ++++++++++++++---
 1 file changed, 14 insertions(+), 3 deletions(-)

(limited to 'lib/class/update.class.php')

diff --git a/lib/class/update.class.php b/lib/class/update.class.php
index 27bc8fb5..a87c1760 100644
--- a/lib/class/update.class.php
+++ b/lib/class/update.class.php
@@ -194,7 +194,9 @@ class Update {
 		$update_string = '- Moved Art from the Album table into album_data to improve performance.<br />' . 
 				'- Made some minor changes to song table to reduce size of each row.<br />' . 
 				'- Moved song_ext_data to song_data to match album_data pattern.<br />' . 
-				'- Added Playlist Method and Rate Limit Preferences.<br />';
+				'- Added Playlist Method and Rate Limit Preferences.<br />' . 
+				'- Renamed preferences and ratings to preference and rating to fit table pattern.<br />' . 
+				'- Fixed rating table, renamed user_rating to rating and switched 00 for -1.<br />';
 
 		$version[] = array('version' => '340003','description' => $update_string); 
 
@@ -601,6 +603,12 @@ class Update {
 		$sql = "RENAME TABLE `ampache`.`song_ext_data`  TO `ampache`.`song_data`"; 
 		$db_results = Dba::query($sql); 
 
+		$sql = "RENAME TABLE `ampache`.`preferences` TO `ampache`.`preference`"; 
+		$db_results = Dba::query($sql); 
+
+		$sql = "RENAME TABLE `ampache`.`ratings` TO `ampache`.`rating`"; 
+		$db_results = Dba::query($sql); 
+
 		// Go ahead and drop the art/thumb stuff
 		$sql = "ALTER TABLE `album`  DROP `art`,  DROP `art_mime`,  DROP `thumb`,  DROP `thumb_mime`"; 
 		$db_results = Dba::query($sql); 
@@ -613,12 +621,15 @@ class Update {
 		$sql = "ALTER TABLE `user` DROP `offset_limit`"; 
 		$db_results = Dba::query($sql); 
 
-               /* Add the rate_limit preference */
+		$sql = "ALTER TABLE `ratings` CHANGE `user_rating` `rating` ENUM( '-1', '0', '1', '2', '3', '4', '5' ) NOT NULL DEFAULT '0'"; 
+		$db_results = Dba::query($sql): 
+
+                /* Add the rate_limit preference */
                 $sql = "INSERT INTO `preferences` (`name`,`value`,`description`,`level`,`type`,`catagory`) " .
                         "VALUES ('rate_limit','8192','Rate Limit','100','integer','streaming')";
                 $db_results = Dba::query($sql);
 
-               /* Add the playlist_method preference and remove it from the user table */
+                /* Add the playlist_method preference and remove it from the user table */
                 $sql = "INSERT INTO `preferences` (`name`,`value`,`description`,`level`,`type`,`catagory`) " .
                         "VALUES ('playlist_method','50','Playlist Method','5','string','streaming')";
                 $db_results = Dba::query($sql);
-- 
cgit