@bowhunt
Looks like u never ran:
[sql]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)
);
ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;[/sql]
|