run PHPMyAdmin then select your vB database then select SQL
now paste the code below but do not include the ending semi colon ; from the code above
now click go and the PHPMyAdmin will run the commands and create the table.
Quote:
CREATE TABLE user_rate_trade (
userrateid INT(10) unsigned NOT NULL auto_increment,
rateduser INT(10) unsigned DEFAULT '0' NOT NULL,
userid INT(10) unsigned DEFAULT '0' NOT NULL,
userrating SMALLINT(6) DEFAULT '0' NOT NULL,
userbuysell TINYINT(1) DEFAULT '0' NOT NULL,
userdate DATE DEFAULT '0000-00-00' NOT NULL,
usercomments VARCHAR(80) NOT NULL,
userurl VARCHAR(255) NOT NULL,
PRIMARY KEY (userrateid),
KEY rateduser (userid)
)
|
now do the same with the second query
Quote:
ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL
|