
11-27-2005, 12:38 PM
|
|
|
Join Date: Oct 2004
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by John
You already had an arcade_challenges table to begin with? :ermm:
The current version number you've got installed is 1.0.0, right? If so, run this:
DROP TABLE IF EXISTS arcade_challenges
And then this:
CREATE TABLE arcade_challenges (
challengeid int(10) unsigned NOT NULL auto_increment,
fromuserid int(10) unsigned NOT NULL default '0',
touserid int(10) unsigned NOT NULL default '0',
winnerid int(10) unsigned NOT NULL default '0',
loserid int(10) unsigned NOT NULL default '0',
gameid int(10) unsigned NOT NULL default '0',
datestamp int(10) unsigned NOT NULL default '0',
fromsessionid int(10) unsigned NOT NULL default '0',
tosessionid int(10) unsigned NOT NULL default '0',
fromscore float(15,3) unsigned NOT NULL default '0.000',
toscore float(15,3) unsigned NOT NULL default '0.000',
status tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (challengeid)
)
|
Ok this may sound stupid, but where do I run this? in my mySQL database, in the vB Cpannel?
|