DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `sex` enum('0','1') NOT NULL DEFAULT '0',
  `online` int(11) NOT NULL DEFAULT '0',
  `last_update` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `activation` int(1) NOT NULL DEFAULT '0',
  `date` datatime() NOT NULL DEFAULT '0000-00-00',
  `access` enum('0','1','2') NOT NULL DEFAULT '0',
  `r` enum('0','1') NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '1',
  `hp` int(11) NOT NULL DEFAULT '0',
  `mp` int(11) NOT NULL DEFAULT '0',
  `exp` int(11) NOT NULL DEFAULT '0',
  `g` int(11) NOT NULL DEFAULT '0',
  `s` int(11) NOT NULL DEFAULT '0',
  `skill` int(11) NOT NULL DEFAULT '0',
  `str` int(11) NOT NULL DEFAULT '10',
  `_str` int(11) NOT NULL DEFAULT '0',
  `vit` int(11) NOT NULL DEFAULT '10',
  `_vit` int(11) NOT NULL DEFAULT '0',
  `agi` int(11) NOT NULL DEFAULT '10',
  `_agi` int(11) NOT NULL DEFAULT '0',
  `def` int(11) NOT NULL DEFAULT '10',
  `_def` int(11) NOT NULL DEFAULT '0',
  `mana` int(11) NOT NULL DEFAULT '1000',
  `_mana` int(11) NOT NULL DEFAULT '0',
  `w_1` int(11) NOT NULL DEFAULT '0',
  `w_2` int(11) NOT NULL DEFAULT '0',
  `w_3` int(11) NOT NULL DEFAULT '0',
  `w_4` int(11) NOT NULL DEFAULT '0',
  `w_5` int(11) NOT NULL DEFAULT '0',
  `w_6` int(11) NOT NULL DEFAULT '0',
  `w_7` int(11) NOT NULL DEFAULT '0',
  `w_8` int(11) NOT NULL DEFAULT '0',
  `save` enum('0','1') NOT NULL DEFAULT '0',
  `duel_rating` int(11) NOT NULL DEFAULT '0',
  `duel_fights` int(11) NOT NULL DEFAULT '0',
  `duel_last_update` int(11) NOT NULL DEFAULT '0',
  `duel_changes` int(11) NOT NULL DEFAULT '0',
  `ip` text,
  `ua` text,
  `coliseum_rating` int(11) NOT NULL DEFAULT '0',
  `self` text,
  `ability_1` int(11) NOT NULL DEFAULT '0',
  `ability_1_quality` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
  `ability_2` int(11) NOT NULL DEFAULT '0',
  `ability_2_quality` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
  `ability_3` int(11) NOT NULL DEFAULT '0',
  `ability_3_quality` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
  `ability_4` int(11) NOT NULL DEFAULT '0',
  `ability_4_quality` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
  `ability_5` int(11) NOT NULL DEFAULT '0',
  `ability_5_quality` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
  `bg` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
  `chest` enum('0','1') NOT NULL DEFAULT '0',
  `duel_trophy` int(11) NOT NULL DEFAULT '0',
  `arena_opponent` int(11) NOT NULL DEFAULT '0',
  `arena_time` int(11) NOT NULL DEFAULT '0',
  `res_1` int(11) NOT NULL DEFAULT '0',
  `res_2` int(11) NOT NULL DEFAULT '0',
  `res_3` int(11) NOT NULL DEFAULT '0',
  `res_4` int(11) NOT NULL DEFAULT '0',
  `res_5` int(11) NOT NULL DEFAULT '0',
  `res_6` int(11) NOT NULL DEFAULT '0',
  `res_7` int(11) NOT NULL DEFAULT '0',
  `res_8` int(11) NOT NULL DEFAULT '0',
  `res_9` int(11) NOT NULL DEFAULT '0',
  `mail_closed` int(10) DEFAULT NULL,
  `kod` int(10) DEFAULT NULL,
  `kode` int(32) DEFAULT NULL,
  `league` int(11) NOT NULL,
  `league_place` int(11) NOT NULL,
  `league_fights` int(11) NOT NULL,
  `key` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14006 DEFAULT CHARSET=cp1251;

INSERT INTO users VALUES("1","admin","123123","0","1423226165","1423226165","0","0","2","20","1000","49","500293","500272","0","10","0","10","0","10","0","10","0","1000","0","0","0","0","0","0","0","0","0","1","0","11","144000","11","178.121.80.178","Mozilla/5.0 (Linux; U; Android 4.2.2; zh-CN; GT-I9060 Build/JDQ39) AppleWebKit/534.31 (KHTML, like Gecko) UCBrowser/9.3.0.321 U3/0.8.0 Mobile Safari/534.31","0","/undying.php","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0");
