[Xelation]

ok, I added a hack that required me to drop this table... the hack doesnt work and now when I delete thread theirs and error.. So I reverted all the php files back and now I need to add the threadrate table back to mysql... I took at look at the install file in the admin dir.... I found this..

PHP Code:

$explain[]="Creating table thread";

$query[]="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)
)";
$explain[]="Creating table thread rate"; 


I was wondering.. what would I need to do to add that to mysql, I know how to run queires, but would I just run this?

PHP Code:

$query[]="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)
)"; 


another qurey it told me to run was this...

UPDATE forum SET allowratings='0' WHERE allowratings = '1'

how can I reverse that?


I appreciate any help I can get!