From b8bcbfe5efa0c765a3fd3ac00ed6c55ca79ed8c8 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sat, 9 Sep 2006 22:37:40 +0000 Subject: [PATCH] r1137: Renaming the schema variable to be $schema, not $query --- install/install.php | 2 +- install/schema.php | 52 ++++++++++++++++++++++----------------------- 2 files changed, 27 insertions(+), 27 deletions(-) diff --git a/install/install.php b/install/install.php index 499fd15..382d120 100644 --- a/install/install.php +++ b/install/install.php @@ -54,7 +54,7 @@ if ($bugsys->in['mark'] == 1) require_once('./install/schema.php'); - foreach ($query AS $table => $query) + foreach ($schema AS $table => $query) { $db->query($query); echo 'Creating table ' . $table . '
' . "\n"; diff --git a/install/schema.php b/install/schema.php index 1a83a78..c8de826 100644 --- a/install/schema.php +++ b/install/schema.php @@ -19,7 +19,7 @@ || ################################################################### \*=====================================================================*/ -$query['attachment'] = " +$schema['attachment'] = " CREATE TABLE " . TABLE_PREFIX . "attachment ( attachmentid int unsigned NOT NULL AUTO_INCREMENT, @@ -35,7 +35,7 @@ CREATE TABLE " . TABLE_PREFIX . "attachment PRIMARY KEY (attachmentid) );"; -$query['autoaction'] = " +$schema['autoaction'] = " CREATE TABLE " . TABLE_PREFIX . "autoaction ( actionid int unsigned NOT NULL AUTO_INCREMENT, @@ -46,7 +46,7 @@ CREATE TABLE " . TABLE_PREFIX . "autoaction PRIMARY KEY (actionid) );"; -$query['bug'] = " +$schema['bug'] = " CREATE TABLE " . TABLE_PREFIX . "bug ( bugid int unsigned NOT NULL AUTO_INCREMENT, @@ -76,7 +76,7 @@ CREATE TABLE " . TABLE_PREFIX . "bug FULLTEXT KEY summary (summary) );"; -$query['bugfield'] = " +$schema['bugfield'] = " CREATE TABLE " . TABLE_PREFIX . "bugfield ( fieldid int unsigned NOT NULL AUTO_INCREMENT, @@ -93,7 +93,7 @@ CREATE TABLE " . TABLE_PREFIX . "bugfield PRIMARY KEY (fieldid) );"; -$query['bugfieldpermission'] = " +$schema['bugfieldpermission'] = " CREATE TABLE " . TABLE_PREFIX . "bugfieldpermission ( usergroupid int unsigned NOT NULL, @@ -102,14 +102,14 @@ CREATE TABLE " . TABLE_PREFIX . "bugfieldpermission PRIMARY KEY (usergroupid, fieldid) );"; -$query['bugvaluefill'] = " +$schema['bugvaluefill'] = " CREATE TABLE " . TABLE_PREFIX . "bugvaluefill ( bugid int unsigned NOT NULL, PRIMARY KEY (bugid) );"; -$query['comment'] = " +$schema['comment'] = " CREATE TABLE " . TABLE_PREFIX . "comment ( commentid int unsigned NOT NULL AUTO_INCREMENT, @@ -123,7 +123,7 @@ CREATE TABLE " . TABLE_PREFIX . "comment FULLTEXT KEY comment (comment) );"; -$query['datastore'] = " +$schema['datastore'] = " CREATE TABLE " . TABLE_PREFIX . "datastore ( title varchar(255) NOT NULL, @@ -131,7 +131,7 @@ CREATE TABLE " . TABLE_PREFIX . "datastore PRIMARY KEY (title) );"; -$query['favorite'] = " +$schema['favorite'] = " CREATE TABLE " . TABLE_PREFIX . "favorite ( userid int unsigned NOT NULL, @@ -139,7 +139,7 @@ CREATE TABLE " . TABLE_PREFIX . "favorite PRIMARY KEY (userid, bugid) );"; -$query['fieldhelp'] = " +$schema['fieldhelp'] = " CREATE TABLE " . TABLE_PREFIX . "fieldhelp ( keystring varchar(255) NOT NULL, @@ -148,7 +148,7 @@ CREATE TABLE " . TABLE_PREFIX . "fieldhelp PRIMARY KEY (keystring) );"; -$query['history'] = " +$schema['history'] = " CREATE TABLE " . TABLE_PREFIX . "history ( historyid bigint unsigned NOT NULL AUTO_INCREMENT, @@ -163,7 +163,7 @@ CREATE TABLE " . TABLE_PREFIX . "history PRIMARY KEY (historyid) );"; -$query['language'] = " +$schema['language'] = " CREATE TABLE " . TABLE_PREFIX . "language ( languageid int unsigned NOT NULL AUTO_INCREMENT, @@ -176,7 +176,7 @@ CREATE TABLE " . TABLE_PREFIX . "language UNIQUE KEY languagecode (langcode) );"; -$query['permission'] = " +$schema['permission'] = " CREATE TABLE " . TABLE_PREFIX . "permission ( usergroupid int unsigned NOT NULL, @@ -185,7 +185,7 @@ CREATE TABLE " . TABLE_PREFIX . "permission PRIMARY KEY (usergroupid, productid) );"; -$query['priority'] = " +$schema['priority'] = " CREATE TABLE " . TABLE_PREFIX . "priority ( priorityid int unsigned NOT NULL AUTO_INCREMENT, @@ -194,7 +194,7 @@ CREATE TABLE " . TABLE_PREFIX . "priority PRIMARY KEY (priorityid) );"; -$query['product'] = " +$schema['product'] = " CREATE TABLE " . TABLE_PREFIX . "product ( productid int unsigned NOT NULL AUTO_INCREMENT, @@ -205,7 +205,7 @@ CREATE TABLE " . TABLE_PREFIX . "product PRIMARY KEY (productid) );"; -$query['resolution'] = " +$schema['resolution'] = " CREATE TABLE " . TABLE_PREFIX . "resolution ( resolutionid int unsigned NOT NULL AUTO_INCREMENT, @@ -214,7 +214,7 @@ CREATE TABLE " . TABLE_PREFIX . "resolution PRIMARY KEY (resolutionid) );"; -$query['search'] = " +$schema['search'] = " CREATE TABLE " . TABLE_PREFIX . "search ( userid int unsigned NOT NULL, @@ -227,7 +227,7 @@ CREATE TABLE " . TABLE_PREFIX . "search PRIMARY KEY (userid) );"; -$query['setting'] = " +$schema['setting'] = " CREATE TABLE " . TABLE_PREFIX . "setting ( varname varchar(255) NOT NULL, @@ -235,7 +235,7 @@ CREATE TABLE " . TABLE_PREFIX . "setting PRIMARY KEY (varname) );"; -$query['severity'] = " +$schema['severity'] = " CREATE TABLE " . TABLE_PREFIX . "severity ( severityid int unsigned NOT NULL AUTO_INCREMENT, @@ -244,7 +244,7 @@ CREATE TABLE " . TABLE_PREFIX . "severity PRIMARY KEY (severityid) );"; -$query['status'] = " +$schema['status'] = " CREATE TABLE " . TABLE_PREFIX . "status ( statusid int unsigned NOT NULL AUTO_INCREMENT, @@ -254,7 +254,7 @@ CREATE TABLE " . TABLE_PREFIX . "status PRIMARY KEY (statusid) );"; -$query['user'] = " +$schema['user'] = " CREATE TABLE " . TABLE_PREFIX . "user ( userid int unsigned NOT NULL AUTO_INCREMENT, @@ -275,7 +275,7 @@ CREATE TABLE " . TABLE_PREFIX . "user PRIMARY KEY (userid) );"; -$query['useractivation'] = " +$schema['useractivation'] = " CREATE TABLE " . TABLE_PREFIX . "useractivation ( activator varchar(25) NOT NULL, @@ -285,7 +285,7 @@ CREATE TABLE " . TABLE_PREFIX . "useractivation PRIMARY KEY (activator) );"; -$query['useremail'] = " +$schema['useremail'] = " CREATE TABLE " . TABLE_PREFIX . "useremail ( userid int unsigned NOT NULL, @@ -293,7 +293,7 @@ CREATE TABLE " . TABLE_PREFIX . "useremail relation int unsigned NOT NULL );"; -$query['usergroup'] = " +$schema['usergroup'] = " CREATE TABLE " . TABLE_PREFIX . "usergroup ( usergroupid int unsigned NOT NULL AUTO_INCREMENT, @@ -303,7 +303,7 @@ CREATE TABLE " . TABLE_PREFIX . "usergroup PRIMARY KEY (usergroupid) );"; -$query['version'] = " +$schema['version'] = " CREATE TABLE " . TABLE_PREFIX . "version ( versionid int unsigned NOT NULL AUTO_INCREMENT, @@ -313,7 +313,7 @@ CREATE TABLE " . TABLE_PREFIX . "version PRIMARY KEY (versionid) );"; -$query['vote'] = " +$schema['vote'] = " CREATE TABLE " . TABLE_PREFIX . "vote ( bugid int unsigned NOT NULL, -- 2.22.5