The query you should run to add the table would be:
CREATE TABLE threadrate (
threadrateid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
threadid int(10) unsigned DEFAULT '0' NOT NULL,
userid int(10) unsigned DEFAULT '0' NOT NULL,
vote smallint(6) DEFAULT '0' NOT NULL,
ipaddress varchar(20) NOT NULL,
PRIMARY KEY (threadrateid),
KEY threadid (threadid));
To reverse the other query you would run this one:
UPDATE forum SET allowratings='1' WHERE allowratings = '0';
That will update all your forums to allow ratings. Alternatly you could just change the option in the Admin CP.
|