From f7e6b3eb254d38ddf2a74a772e2814cec08c20d9 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Wed, 26 Jul 2006 22:43:08 +0000 Subject: [PATCH] r967: Adding TABLE_PREFIX's to the queries --- install/upgrade2.php | 26 +++++++++++++------------- 1 file changed, 13 insertions(+), 13 deletions(-) diff --git a/install/upgrade2.php b/install/upgrade2.php index d138a28..664c2e1 100644 --- a/install/upgrade2.php +++ b/install/upgrade2.php @@ -62,7 +62,7 @@ if ($bugsys->in['mark'] == 1) echo "Adding the useremail table to store email preferences
\n"; - $db->query("DROP TABLE dependency"); + $db->query("DROP TABLE " . TABLE_PREFIX . "dependency"); echo "Dropping the unused dependency table (this was never used and was from a 1.0.0 pre-release version, so data has been lost)
\n"; } @@ -77,16 +77,16 @@ if ($bugsys->in['mark'] == 2)

Changes are now being done on the user table.

query("ALTER TABLE user ADD usedst BOOL NOT NULL"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD usedst BOOL NOT NULL"); echo "Adding user.usedst, a daylight savings time option
\n"; - $db->query("ALTER TABLE user ADD hidestatuses mediumtext NOT NULL"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD hidestatuses mediumtext NOT NULL"); echo "Adding user.hidestatuses to allow users to opt to not display certain statuses
\n"; - $db->query("ALTER TABLE user ADD defaultsortkey varchar(50) NULL"); - $db->query("ALTER TABLE user ADD defaultsortas varchar(10) NULL"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD defaultsortkey varchar(50) NULL"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD defaultsortas varchar(10) NULL"); echo "Adding user.defaultsortkey and user.defaultsortas for bug list sorting options
\n"; } @@ -101,23 +101,23 @@ if ($bugsys->in['mark'] == 3)

Minor, miscellaneous modifications are now being performed on database tables.

query("DELETE FROM search"); + $db->query("DELETE FROM " . TABLE_PREFIX . "search"); echo "Clearing the search table because new features make changes to the way data is stored in this table
\n"; - $db->query("ALTER TABLE search ADD resultcount INT(10) NULL"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "search ADD resultcount INT(10) NULL"); echo "Adding search.resultcount as an internal counter for search features
\n"; - $db->query("ALTER TABLE bug CHANGE productid product INT(10) UNSIGNED NOT NULL DEFAULT '0'"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "bug CHANGE productid product INT(10) UNSIGNED NOT NULL DEFAULT '0'"); echo "Renaming bug.productid to bug.product
\n"; - $db->query("ALTER TABLE bug CHANGE componentid component INT(10) UNSIGNED NOT NULL DEFAULT '0'"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "bug CHANGE componentid component INT(10) UNSIGNED NOT NULL DEFAULT '0'"); echo "Renaming bug.componentid to bug.component
\n"; - $db->query("ALTER TABLE bug CHANGE versionid version INT(10) UNSIGNED NOT NULL DEFAULT '0'"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "bug CHANGE versionid version INT(10) UNSIGNED NOT NULL DEFAULT '0'"); echo "Renaming bug.versionid to bug.version
\n"; } @@ -132,9 +132,9 @@ if ($bugsys->in['mark'] == 4)

To decrease load times and complex queries, user information is now stored in the bug table. This step will add additional fields for this data and then will populate those same fields.

query("ALTER TABLE bug ADD username varchar(255) NOT NULL"); - $db->query("ALTER TABLE bug ADD lastpostbyname varchar(255) NOT NULL"); - $db->query("ALTER TABLE bug ADD hiddenlastpostbyname varchar(255) NOT NULL"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "bug ADD username varchar(255) NOT NULL"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "bug ADD lastpostbyname varchar(255) NOT NULL"); + $db->query("ALTER TABLE " . TABLE_PREFIX . "bug ADD hiddenlastpostbyname varchar(255) NOT NULL"); echo "Adding bug.username, bug.lastpostbyname, and bug.hiddenlastpostbyname to store cached user name data
\n"; -- 2.22.5