From bd15853708ae73ee69220738a061e10d015d7fb9 Mon Sep 17 00:00:00 2001 From: Tim Almdal Date: Fri, 27 Feb 2009 21:07:18 +0000 Subject: This implements table prefix for all the queries in core, user, exif, tag, search, comment and notification modules (Ticket #68) --- modules/search/helpers/search_installer.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'modules/search/helpers/search_installer.php') diff --git a/modules/search/helpers/search_installer.php b/modules/search/helpers/search_installer.php index b823f498..05775fec 100644 --- a/modules/search/helpers/search_installer.php +++ b/modules/search/helpers/search_installer.php @@ -22,7 +22,7 @@ class search_installer { $version = module::get_version("search"); $db = Database::instance(); if ($version == 0) { - $db->query("CREATE TABLE `search_records` ( + $db->query("CREATE TABLE `[search_records]` ( `id` int(9) NOT NULL auto_increment, `item_id` int(9), `dirty` boolean default 1, @@ -32,7 +32,7 @@ class search_installer { ENGINE=MyISAM DEFAULT CHARSET=utf8;"); // populate the index with dirty records - $db->query("insert into `search_records` (`item_id`) SELECT `id` FROM `items`"); + $db->query("INSERT INTO `[search_records]` (`item_id`) SELECT `id` FROM `[items]`"); module::set_version("search", 1); if (ORM::factory("search_record")->count_all() < 10) { @@ -47,7 +47,7 @@ class search_installer { static function uninstall() { $db = Database::instance(); - $db->query("DROP TABLE `search_records`"); + $db->query("DROP TABLE `[search_records]`"); site_status::clear("search_index_out_of_date"); module::delete("search"); } -- cgit v1.2.3