Thug
09-02-2005, 09:20 PM
Hi i mstuck on creating tables in phpmyadmin
im missing some tables EG;
and need to no how to create it
"CREATE TABLE ibf_games_cats (
c_id mediumint(8) NOT NULL auto_increment,
cat_name varchar(32) NOT NULL default '',
active tinyint(1) NOT NULL default '1',
show_all TINYINT( 1 ) DEFAULT '0' NOT NULL,
pos TINYINT( 2 ) DEFAULT '1' NOT NULL,
password VARCHAR( 32 ) NOT NULL,
num_of_games MEDIUMINT( 8 ) DEFAULT '0' NOT NULL,
PRIMARY KEY (c_id)) TYPE=MyISAM";
im missing some tables EG;
and need to no how to create it
"CREATE TABLE ibf_games_cats (
c_id mediumint(8) NOT NULL auto_increment,
cat_name varchar(32) NOT NULL default '',
active tinyint(1) NOT NULL default '1',
show_all TINYINT( 1 ) DEFAULT '0' NOT NULL,
pos TINYINT( 2 ) DEFAULT '1' NOT NULL,
password VARCHAR( 32 ) NOT NULL,
num_of_games MEDIUMINT( 8 ) DEFAULT '0' NOT NULL,
PRIMARY KEY (c_id)) TYPE=MyISAM";