4xSm6rcG

1
2		CREATE TABLE IF NOT EXISTS `battles` (
3			`battle_id` bigint(20) unsigned NOT NULL auto_increment,
4			`winner` bigint(20) unsigned NOT NULL,
5			`loser` bigint(20) unsigned NOT NULL,
6			PRIMARY KEY  (`battle_id`),
7			KEY `winner` (`winner`)
8		) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
9		
10		
11		CREATE TABLE IF NOT EXISTS `images` (
12			`image_id` bigint(20) unsigned NOT NULL auto_increment,
13			`filename` varchar(255) NOT NULL,
14			`score` int(10) unsigned NOT NULL default '1500',
15			`wins` int(10) unsigned NOT NULL default '0',
16			`losses` int(10) unsigned NOT NULL default '0',
17			PRIMARY KEY  (`image_id`)
18		) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;