From b3195a727167a26ac84c9105904b2cbb9cf37287 Mon Sep 17 00:00:00 2001 From: martian Date: Thu, 11 Feb 2010 19:26:33 +0000 Subject: moved database alterations to proper place --- lib/class/update.class.php | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'lib/class/update.class.php') diff --git a/lib/class/update.class.php b/lib/class/update.class.php index bda724a4..d51510b1 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -1829,6 +1829,16 @@ class Update { $sql = "ALTER TABLE `live_stream` CHANGE `url` `url` VARCHAR ( 4096 )"; $db_results = Dba::write($sql); + // Index the Artist, Album, and Song tables to prepare for Fulltext searches. + $sql = "ALTER TABLE `artist` ADD FULLTEXT(`name`)"; + $db_results = Dba::write($sql); + + $sql = "ALTER TABLE `album` ADD FULLTEXT(`name`)"; + $db_results = Dba::write($sql); + + $sql = "ALTER TABLE `song` ADD FULLTEXT(`title`)"; + $db_results = Dba::write($sql); + // Now add in the min_object_count preference and the random_method $sql = "INSERT INTO `preferences` (`name`,`value`,`description`,`level`,`type`,`catagory`) " . "VALUES('bandwidth','1','Bandwidth','100','integer','interface')"; -- cgit