Table 'access' already exists
Database error in vBulletin :
Invalid SQL:
CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
);
MySQL Error : Table 'access' already exists
Error Number : 1050
Request Date : Monday, November 16th 2009 @ 09:42:15 PM
Error Date : Monday, November 16th 2009 @ 09:42:15 PM
Script :......
Referrer :......
IP Address :.......
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community
DELETE FROM access;
CREATE TABLE `access` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`accessmask` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`forumid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
No comments:
Post a Comment