ds9WcnM8

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