diff options
| author | Tim Almdal <tnalmdal@shaw.ca> | 2009-02-27 21:07:18 +0000 |
|---|---|---|
| committer | Tim Almdal <tnalmdal@shaw.ca> | 2009-02-27 21:07:18 +0000 |
| commit | bd15853708ae73ee69220738a061e10d015d7fb9 (patch) | |
| tree | facfbd5b08e3cbb8e7fa2b4adf433b54d4c0c5bc /modules/comment/helpers | |
| parent | 0b9fe18a6bf4036a05db7f9479d7b55d3fe5c782 (diff) | |
This implements table prefix for all the queries in core, user, exif,
tag, search, comment and notification modules (Ticket #68)
Diffstat (limited to 'modules/comment/helpers')
| -rw-r--r-- | modules/comment/helpers/comment_installer.php | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/modules/comment/helpers/comment_installer.php b/modules/comment/helpers/comment_installer.php index 12caa547..a7852d05 100644 --- a/modules/comment/helpers/comment_installer.php +++ b/modules/comment/helpers/comment_installer.php @@ -23,7 +23,7 @@ class comment_installer { $version = module::get_version("comment"); if ($version == 0) { - $db->query("CREATE TABLE IF NOT EXISTS `comments` ( + $db->query("CREATE TABLE IF NOT EXISTS `[comments]` ( `author_id` int(9) default NULL, `created` int(9) NOT NULL, `guest_email` varchar(128) default NULL, @@ -58,10 +58,11 @@ class comment_installer { static function uninstall() { $db = Database::instance(); - $sql = "SELECT `item_id` FROM `comments`"; + $sql = "SELECT `item_id` FROM `[comments]`"; module::event("item_related_update_batch", $sql); - $db->query("DROP TABLE IF EXISTS `comments`;"); + $db->query("DROP TABLE IF EXISTS `[comments] +`;"); module::delete("comment"); } } |