Advertisement
Guest User

Untitled

a guest
Nov 26th, 2014
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `battles` (
  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 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement