Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- Table structure for table `hungergames_records`
- --
- CREATE TABLE IF NOT EXISTS `hungergames_records` (
- `user_id` int(10) unsigned NOT NULL,
- `victories` int(32) unsigned NOT NULL DEFAULT '0',
- `biggest_kill_streak` int(32) unsigned NOT NULL DEFAULT '0',
- `most_chests_opened` int(32) unsigned NOT NULL DEFAULT '0',
- `total_chests_opened` int(32) unsigned NOT NULL DEFAULT '0',
- `lastlogin` int(32) unsigned NOT NULL DEFAULT '0',
- `longest_lifespan` int(32) unsigned NOT NULL DEFAULT '0',
- `total_lifespan` int(32) unsigned NOT NULL DEFAULT '0',
- `total_points` int(32) unsigned NOT NULL DEFAULT '100',
- `most_points` int(32) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`user_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `hungergames_users`
- --
- CREATE TABLE IF NOT EXISTS `hungergames_users` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `donor` int(32) unsigned NOT NULL DEFAULT '0',
- `user` varchar(40) NOT NULL,
- `donor_cooldown` int(100) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `user` (`user`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12641 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement