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;");