From 0952b317b928a198ba7bfa70ef6055729c384c5e Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Fri, 23 Dec 2005 03:02:40 +0000 Subject: [PATCH] r676: Need table prefixes in the installer --- install/schema.php | 52 +++++++++++++++++++++++----------------------- 1 file changed, 26 insertions(+), 26 deletions(-) diff --git a/install/schema.php b/install/schema.php index 7332310..3c6dbd3 100644 --- a/install/schema.php +++ b/install/schema.php @@ -11,7 +11,7 @@ \*=====================================================================*/ $query['attachment'] = " -CREATE TABLE `attachment` ( +CREATE TABLE `" . TABLE_PREFIX . "attachment` ( `attachmentid` int(10) unsigned NOT NULL auto_increment, `bugid` int(10) unsigned NOT NULL default '0', `filename` varchar(255) NOT NULL default '', @@ -27,7 +27,7 @@ CREATE TABLE `attachment` ( "; $query['autoaction'] = " -CREATE TABLE `autoaction` ( +CREATE TABLE `" . TABLE_PREFIX . "autoaction` ( `actionid` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` mediumtext NOT NULL, @@ -38,7 +38,7 @@ CREATE TABLE `autoaction` ( "; $query['bug'] = " -CREATE TABLE `bug` ( +CREATE TABLE `" . TABLE_PREFIX . "bug` ( `bugid` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `dateline` int(20) unsigned NOT NULL default '0', @@ -65,7 +65,7 @@ CREATE TABLE `bug` ( "; $query['bugfield'] = " -CREATE TABLE `bugfield` ( +CREATE TABLE `" . TABLE_PREFIX . "bugfield` ( `fieldid` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` mediumtext NOT NULL, @@ -82,7 +82,7 @@ CREATE TABLE `bugfield` ( "; $query['bugfieldpermission'] = " -CREATE TABLE `bugfieldpermission` ( +CREATE TABLE `" . TABLE_PREFIX . "bugfieldpermission` ( `usergroupid` int(10) unsigned NOT NULL default '0', `fieldid` int(10) unsigned NOT NULL default '0', `mask` int(5) unsigned NOT NULL default '0', @@ -91,7 +91,7 @@ CREATE TABLE `bugfieldpermission` ( "; $query['bugvaluefill'] = " -CREATE TABLE `bugvaluefill` ( +CREATE TABLE `" . TABLE_PREFIX . "bugvaluefill` ( `bugid` int(10) unsigned NOT NULL default '0', `field2` mediumtext, `field4` mediumtext, @@ -101,7 +101,7 @@ CREATE TABLE `bugvaluefill` ( "; $query['comment'] = " -CREATE TABLE `comment` ( +CREATE TABLE `" . TABLE_PREFIX . "comment` ( `commentid` int(10) unsigned NOT NULL auto_increment, `bugid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', @@ -115,7 +115,7 @@ CREATE TABLE `comment` ( "; $query['datastore'] = " -CREATE TABLE `datastore` ( +CREATE TABLE `" . TABLE_PREFIX . "datastore` ( `title` varchar(255) NOT NULL default '', `data` mediumtext NOT NULL, PRIMARY KEY (`title`) @@ -123,7 +123,7 @@ CREATE TABLE `datastore` ( "; $query['dependency'] = " -CREATE TABLE `dependency` ( +CREATE TABLE `" . TABLE_PREFIX . "dependency` ( `dependencyid` int(10) unsigned NOT NULL auto_increment, `bugid` int(10) unsigned NOT NULL default '0', `dependson` int(10) unsigned NOT NULL default '0', @@ -132,7 +132,7 @@ CREATE TABLE `dependency` ( "; $query['favourite'] = " -CREATE TABLE `favourite` ( +CREATE TABLE `" . TABLE_PREFIX . "favourite` ( `userid` int(10) unsigned NOT NULL default '0', `bugid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`userid`,`bugid`) @@ -140,7 +140,7 @@ CREATE TABLE `favourite` ( "; $query['history'] = " -CREATE TABLE `history` ( +CREATE TABLE `" . TABLE_PREFIX . "history` ( `historyid` int(20) unsigned NOT NULL auto_increment, `bugid` int(10) unsigned NOT NULL default '0', `attachmentid` int(10) unsigned NOT NULL default '0', @@ -155,7 +155,7 @@ CREATE TABLE `history` ( "; $query['language'] = " -CREATE TABLE `language` ( +CREATE TABLE `" . TABLE_PREFIX . "language` ( `languageid` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `languagecode` varchar(5) NOT NULL default '', @@ -171,7 +171,7 @@ CREATE TABLE `language` ( "; $query['localization'] = " -CREATE TABLE `localization` ( +CREATE TABLE `" . TABLE_PREFIX . "localization` ( `localid` int(10) unsigned NOT NULL auto_increment, `localkey` mediumtext NOT NULL, `localtext` mediumtext NOT NULL, @@ -181,7 +181,7 @@ CREATE TABLE `localization` ( "; $query['permission'] = " -CREATE TABLE `permission` ( +CREATE TABLE `" . TABLE_PREFIX . "permission` ( `usergroupid` int(10) unsigned NOT NULL default '0', `productid` int(10) unsigned NOT NULL default '0', `mask` int(5) NOT NULL default '0', @@ -190,7 +190,7 @@ CREATE TABLE `permission` ( "; $query['priority'] = " -CREATE TABLE `priority` ( +CREATE TABLE `" . TABLE_PREFIX . "priority` ( `priorityid` int(10) unsigned NOT NULL auto_increment, `priority` varchar(255) NOT NULL default '', `displayorder` int(10) unsigned NOT NULL default '0', @@ -199,7 +199,7 @@ CREATE TABLE `priority` ( "; $query['product'] = " -CREATE TABLE `product` ( +CREATE TABLE `" . TABLE_PREFIX . "product` ( `productid` int(10) unsigned NOT NULL auto_increment, `componentmother` int(10) unsigned NOT NULL default '0', `shortname` varchar(255) NOT NULL default '', @@ -211,7 +211,7 @@ CREATE TABLE `product` ( "; $query['resolution'] = " -CREATE TABLE `resolution` ( +CREATE TABLE `" . TABLE_PREFIX . "resolution` ( `resolutionid` int(10) unsigned NOT NULL auto_increment, `resolution` varchar(255) NOT NULL default '', `displayorder` int(10) unsigned NOT NULL default '0', @@ -220,7 +220,7 @@ CREATE TABLE `resolution` ( "; $query['search'] = " -CREATE TABLE `search` ( +CREATE TABLE `" . TABLE_PREFIX . "search` ( `userid` int(10) unsigned NOT NULL default '0', `dateline` int(20) unsigned NOT NULL default '0', `query` mediumtext NOT NULL, @@ -232,7 +232,7 @@ CREATE TABLE `search` ( "; $query['setting'] = " -CREATE TABLE `setting` ( +CREATE TABLE `" . TABLE_PREFIX . "setting` ( `varname` varchar(255) NOT NULL default '', `value` mediumtext NOT NULL, PRIMARY KEY (`varname`) @@ -240,7 +240,7 @@ CREATE TABLE `setting` ( "; $query['severity'] = " -CREATE TABLE `severity` ( +CREATE TABLE `" . TABLE_PREFIX . "severity` ( `severityid` int(10) unsigned NOT NULL auto_increment, `severity` varchar(255) NOT NULL default '', `displayorder` int(10) unsigned NOT NULL default '0', @@ -249,7 +249,7 @@ CREATE TABLE `severity` ( "; $query['status'] = " -CREATE TABLE `status` ( +CREATE TABLE `" . TABLE_PREFIX . "status` ( `statusid` int(10) unsigned NOT NULL auto_increment, `status` varchar(255) NOT NULL default '', `displayorder` int(10) unsigned NOT NULL default '0', @@ -259,7 +259,7 @@ CREATE TABLE `status` ( "; $query['user'] = " -CREATE TABLE `user` ( +CREATE TABLE `" . TABLE_PREFIX . "user` ( `userid` int(10) unsigned NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', `displayname` varchar(255) NOT NULL default '', @@ -276,7 +276,7 @@ CREATE TABLE `user` ( "; $query['useractivation'] = " -CREATE TABLE `useractivation` ( +CREATE TABLE `" . TABLE_PREFIX . "useractivation` ( `activator` varchar(25) NOT NULL default '', `userid` int(10) unsigned NOT NULL default '0', `dateline` int(10) unsigned NOT NULL default '0', @@ -286,7 +286,7 @@ CREATE TABLE `useractivation` ( "; $query['usergroup'] = " -CREATE TABLE `usergroup` ( +CREATE TABLE `" . TABLE_PREFIX . "usergroup` ( `usergroupid` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `displaytitle` varchar(255) NOT NULL default '', @@ -298,7 +298,7 @@ CREATE TABLE `usergroup` ( "; $query['version'] = " -CREATE TABLE `version` ( +CREATE TABLE `" . TABLE_PREFIX . "version` ( `versionid` int(10) unsigned NOT NULL auto_increment, `productid` int(10) unsigned NOT NULL default '0', `version` varchar(255) NOT NULL default '', @@ -308,7 +308,7 @@ CREATE TABLE `version` ( "; $query['vote'] = " -CREATE TABLE `vote` ( +CREATE TABLE `" . TABLE_PREFIX . "vote` ( `bugid` int(10) unsigned NOT NULL default '0', `userids` mediumtext NOT NULL, `votefor` int(10) unsigned NOT NULL default '0', -- 2.22.5