mysql create table
Posted: Mon Aug 03, 2009 8:19 pm
can anybody tell me whats wrong with this? no matter what i change it wont seem to work. all the other tables in this page are created, this is the only one that isnt so i've narrowed it down. thanks in advance
Code: Select all
mysql_query("CREATE TABLE `r$round[0]_crew` (
`id` int(6) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`founder` varchar(255) NOT NULL default '',
`members` smallint(6) NOT NULL default '1',
`profile` varchar(255) NOT NULL default '',
`icon` varchar(255) NOT NULL default '',
`rank` decimal(65,0) unsigned NOT NULL default '99999',
`networth` decimal(65,0) unsigned NOT NULL default '0',
`cofounder` varchar(255) NOT NULL default '',
`accept` varchar(255) NOT NULL default 'No',
`base` tinyint(3) NOT NULL default '',
`soldiers` tinyint(3) NOT NULL default '2',
`points` tinyint(3) NOT NULL default '2',
`crewpoints` decimal(65,0) NOT NULL default '0',
`joined` int(12) unsigned NOT NULL default '0',
`advisor1` varchar(255) NOT NULL default '',
`advisor2` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;");