diff options
| author | martian <martian@ampache> | 2010-02-11 19:26:33 +0000 |
|---|---|---|
| committer | martian <martian@ampache> | 2010-02-11 19:26:33 +0000 |
| commit | b3195a727167a26ac84c9105904b2cbb9cf37287 (patch) | |
| tree | 5a670de542f7e81ea66423cead177d7eb1ac5351 /lib/class/update.class.php | |
| parent | 81b75945bfb645adbae1c6ad1efcc980d4f0e134 (diff) | |
| download | ampache-b3195a727167a26ac84c9105904b2cbb9cf37287.tar.gz ampache-b3195a727167a26ac84c9105904b2cbb9cf37287.tar.bz2 ampache-b3195a727167a26ac84c9105904b2cbb9cf37287.zip | |
moved database alterations to proper place
Diffstat (limited to 'lib/class/update.class.php')
| -rw-r--r-- | lib/class/update.class.php | 10 |
1 files changed, 10 insertions, 0 deletions
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')"; |