-- -- Table structure for table `aborgazh` -- DROP TABLE IF EXISTS `aborgazh`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aborgazh` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `id_vrag` int(11) unsigned NOT NULL, `ekipazh_user` tinyint(3) unsigned NOT NULL, `ekipazh_vrag` tinyint(3) unsigned NOT NULL, `hp_user` mediumint(5) unsigned NOT NULL, `hp_vrag` mediumint(5) unsigned NOT NULL, `ekipazh_user_hp` mediumint(5) unsigned NOT NULL, `ekipazh_vrag_hp` mediumint(5) unsigned NOT NULL, `osm_user` tinyint(1) unsigned NOT NULL DEFAULT '0', `osm_vrag` tinyint(1) unsigned NOT NULL DEFAULT '0', `ekipazh_user_hp_sum` mediumint(5) unsigned NOT NULL, `ekipazh_vrag_hp_sum` mediumint(5) unsigned NOT NULL, `tip` enum('user','bot') NOT NULL DEFAULT 'user', `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id_user_2` (`id_user`), UNIQUE KEY `id_vrag_2` (`id_vrag`), KEY `time` (`time`) ) ENGINE=InnoDB AUTO_INCREMENT=2233 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `aborgazh_logi` -- DROP TABLE IF EXISTS `aborgazh_logi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aborgazh_logi` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `arena_attack` -- DROP TABLE IF EXISTS `arena_attack`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `arena_attack` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `id_vrag` int(11) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `time` (`time`), KEY `id_user` (`id_user`,`id_vrag`) ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `arena_bochka` -- DROP TABLE IF EXISTS `arena_bochka`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `arena_bochka` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `att` smallint(5) unsigned NOT NULL, `lvl` tinyint(2) unsigned NOT NULL, `x` int(2) unsigned NOT NULL, `y` tinyint(2) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `x` (`x`,`y`,`lvl`), KEY `time` (`time`) ) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `arena_maps` -- DROP TABLE IF EXISTS `arena_maps`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `arena_maps` ( `id` smallint(3) unsigned NOT NULL AUTO_INCREMENT, `x` smallint(3) unsigned NOT NULL, `y` int(10) unsigned NOT NULL, `i` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `arts` -- DROP TABLE IF EXISTS `arts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `arts` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(25) NOT NULL, `text` varchar(100) NOT NULL, `bon` tinyint(3) unsigned NOT NULL DEFAULT '1', `lvl_min` tinyint(2) unsigned NOT NULL DEFAULT '1', `min` smallint(3) unsigned NOT NULL, `max` smallint(3) unsigned NOT NULL, `chast` tinyint(1) unsigned NOT NULL, `money` mediumint(6) unsigned NOT NULL, `gold` smallint(5) unsigned NOT NULL, `caribi_money` mediumint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `lvl_min` (`lvl_min`), KEY `caribi_money` (`caribi_money`) ) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `boat` -- DROP TABLE IF EXISTS `boat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `boat` ( `id` tinyint(2) unsigned NOT NULL AUTO_INCREMENT, `name` enum('HMS Дракон','HMS Охотник','HMS Принц','Бриг','Галеон','Канонерка','Королевская Удача','Ла Дама Негра','Месть Королевы Анны','Фрегат','Шхуна','Эксперто Креде','Месть','Эль-Имполуто','Бенджамин','Рэндольф','Беладонна','Виктуар','Гриф','Сан Мартин','Мановар') NOT NULL, `lvlmin` tinyint(2) unsigned NOT NULL DEFAULT '1', `money` mediumint(5) unsigned NOT NULL DEFAULT '0', `gold` mediumint(5) unsigned NOT NULL DEFAULT '0', `uron_push` tinyint(3) unsigned NOT NULL, `uron_mortira` tinyint(3) unsigned NOT NULL, `uron_knippeli` tinyint(3) unsigned NOT NULL, `hp` smallint(8) unsigned NOT NULL, `trum` smallint(8) unsigned NOT NULL, `arts` tinyint(5) unsigned NOT NULL DEFAULT '5', `time_push` tinyint(2) unsigned NOT NULL DEFAULT '3', `time_mortira` tinyint(2) unsigned NOT NULL DEFAULT '30', `time_knippeli` tinyint(2) unsigned NOT NULL DEFAULT '15', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bosspole` -- DROP TABLE IF EXISTS `bosspole`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bosspole` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_boss` tinyint(2) unsigned NOT NULL, `name` varchar(20) NOT NULL, `att` float NOT NULL, `deff` float NOT NULL, `hp` int(11) NOT NULL, `hp_max` int(11) NOT NULL, `toch` int(3) NOT NULL, `manevr` int(3) NOT NULL, `gold` int(11) NOT NULL, `zoloto` int(11) NOT NULL, `money` int(11) NOT NULL, `steel` int(11) NOT NULL DEFAULT '0', `opit` int(11) NOT NULL, `navik` varchar(25) NOT NULL, `time` int(11) NOT NULL, `st` int(1) NOT NULL, `time_regen` int(10) unsigned NOT NULL, `gorod` tinyint(1) unsigned NOT NULL DEFAULT '1', `lvl` tinyint(1) unsigned NOT NULL DEFAULT '1', `x` smallint(2) unsigned NOT NULL, `y` smallint(2) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `gorod` (`gorod`), KEY `id_boss` (`id_boss`), KEY `time` (`time`), KEY `x` (`x`), KEY `y` (`y`) ) ENGINE=InnoDB AUTO_INCREMENT=3493 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bpoleuser` -- DROP TABLE IF EXISTS `bpoleuser`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bpoleuser` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `kolatt` int(11) NOT NULL DEFAULT '0', `talant1` int(11) NOT NULL DEFAULT '0', `m` int(1) unsigned NOT NULL DEFAULT '0', `kon` int(1) NOT NULL DEFAULT '0', `login` varchar(20) NOT NULL, `money` int(1) NOT NULL DEFAULT '0', `opit` int(1) NOT NULL DEFAULT '0', `st` int(11) NOT NULL, `gorod` tinyint(2) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `gorod` (`gorod`), KEY `st` (`st`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=13897 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `caribi` -- DROP TABLE IF EXISTS `caribi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `caribi` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `id_user` int(11) unsigned NOT NULL, `hp` int(11) unsigned NOT NULL, `toch` smallint(3) unsigned NOT NULL, `ubit` tinyint(1) unsigned NOT NULL DEFAULT '0', `att` int(11) unsigned NOT NULL, `ubil` smallint(4) unsigned NOT NULL, `hp_max` int(11) unsigned NOT NULL, `idattag` int(11) unsigned NOT NULL DEFAULT '0', `manevr` smallint(3) unsigned NOT NULL, `st` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `id_user` (`id_user`), KEY `ubit` (`ubit`), KEY `st` (`st`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `caribi_logi` -- DROP TABLE IF EXISTS `caribi_logi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `caribi_logi` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(400) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chat` -- DROP TABLE IF EXISTS `chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `text` varchar(500) NOT NULL, `date` int(10) unsigned NOT NULL, `id_whom` int(11) unsigned NOT NULL, `privat` varchar(20) NOT NULL, `login` varchar(20) NOT NULL, `sex` tinyint(1) NOT NULL, `adm` enum('user','moder','admin','razrab') NOT NULL, PRIMARY KEY (`id`), KEY `id_whom` (`id_whom`), KEY `id_add` (`id_add`), KEY `date` (`date`) ) ENGINE=InnoDB AUTO_INCREMENT=3106 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `clans` -- DROP TABLE IF EXISTS `clans`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `clans` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `name` varchar(20) NOT NULL, `wins` int(11) unsigned NOT NULL, `data` int(10) unsigned NOT NULL, `logo` varchar(50) NOT NULL, `info` varchar(150) NOT NULL, `info2` varchar(100) NOT NULL, `opit` int(11) unsigned NOT NULL DEFAULT '0', `lvl` tinyint(1) unsigned NOT NULL DEFAULT '1', `money` int(11) unsigned NOT NULL DEFAULT '0', `lumber` int(11) unsigned NOT NULL DEFAULT '0', `steel` int(11) unsigned NOT NULL DEFAULT '0', `rom` int(11) unsigned NOT NULL DEFAULT '0', `tkani` int(11) unsigned NOT NULL DEFAULT '0', `gold` int(11) unsigned NOT NULL DEFAULT '0', `time_att` int(10) unsigned NOT NULL DEFAULT '0', `taverna` tinyint(1) unsigned NOT NULL DEFAULT '0', `build1` tinyint(2) unsigned NOT NULL DEFAULT '0', `build2` tinyint(2) unsigned NOT NULL DEFAULT '0', `build3` tinyint(2) unsigned NOT NULL DEFAULT '0', `build4` tinyint(2) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `lvl` (`lvl`) ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `clans_chat` -- DROP TABLE IF EXISTS `clans_chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `clans_chat` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `text` varchar(500) NOT NULL, `date` int(10) unsigned NOT NULL, `id_clan` smallint(3) unsigned NOT NULL, `id_whom` varchar(35) NOT NULL, `login` varchar(20) NOT NULL, `sex` tinyint(1) unsigned NOT NULL, `adm` varchar(26) NOT NULL, PRIMARY KEY (`id`), KEY `id_clan` (`id_clan`), KEY `id_add` (`id_add`), KEY `date` (`date`) ) ENGINE=InnoDB AUTO_INCREMENT=14105 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `clans_forum_msg` -- DROP TABLE IF EXISTS `clans_forum_msg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `clans_forum_msg` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_clan` smallint(4) unsigned NOT NULL, `id_theme` smallint(4) unsigned NOT NULL, `id_add` int(11) NOT NULL, `msg` varchar(1500) NOT NULL, `data` int(10) NOT NULL, `tip` smallint(2) unsigned NOT NULL, `id_k` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_clan` (`id_clan`), KEY `id_theme` (`id_theme`), KEY `id_add` (`id_add`) ) ENGINE=MyISAM AUTO_INCREMENT=157 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `clans_forum_theme` -- DROP TABLE IF EXISTS `clans_forum_theme`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `clans_forum_theme` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_clan` smallint(4) unsigned NOT NULL, `id_add` int(11) NOT NULL, `data` int(10) unsigned NOT NULL, `name` varchar(500) NOT NULL, `status` varchar(10) NOT NULL, `razdel` tinyint(2) unsigned NOT NULL, `timer` int(10) unsigned NOT NULL, `zakr` tinyint(1) NOT NULL DEFAULT '2', PRIMARY KEY (`id`), KEY `id_clan` (`id_clan`), KEY `id_add` (`id_add`), KEY `razdel` (`razdel`), KEY `data` (`data`), KEY `timer` (`timer`), KEY `zakr` (`zakr`) ) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `clans_jobs` -- DROP TABLE IF EXISTS `clans_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `clans_jobs` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_clan` smallint(5) unsigned NOT NULL, `tip` tinyint(1) unsigned NOT NULL, `kol` mediumint(5) unsigned NOT NULL, `kols` mediumint(6) unsigned NOT NULL DEFAULT '0', `time` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_clan` (`id_clan`), KEY `time` (`time`), KEY `tip` (`id_clan`,`tip`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `clans_log` -- DROP TABLE IF EXISTS `clans_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `clans_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_clan` smallint(5) unsigned NOT NULL, `date` int(10) NOT NULL, `log` varchar(400) NOT NULL, `tip` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_clan` (`id_clan`), KEY `tip` (`tip`), KEY `date` (`date`) ) ENGINE=InnoDB AUTO_INCREMENT=9811 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `clans_prigl` -- DROP TABLE IF EXISTS `clans_prigl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `clans_prigl` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `id_prigl` int(11) unsigned NOT NULL, `id_clan` int(11) unsigned NOT NULL, `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_prigl` (`id_prigl`), KEY `id_add` (`id_add`), KEY `id_clan` (`id_clan`) ) ENGINE=InnoDB AUTO_INCREMENT=3319 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `comp` -- DROP TABLE IF EXISTS `comp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `comp` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `id_user` int(11) unsigned NOT NULL, `hp` int(11) unsigned NOT NULL, `toch` smallint(3) unsigned NOT NULL DEFAULT '1', `ubit` tinyint(1) unsigned NOT NULL DEFAULT '0', `att` int(11) unsigned NOT NULL, `ubil` smallint(4) unsigned NOT NULL DEFAULT '0', `hp_max` int(11) NOT NULL, `idattag` int(11) NOT NULL DEFAULT '0', `manevr` int(11) NOT NULL DEFAULT '0', `mesto` mediumint(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `id_user` (`id_user`), KEY `ubit` (`ubit`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `comp_logi` -- DROP TABLE IF EXISTS `comp_logi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `comp_logi` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(400) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract` -- DROP TABLE IF EXISTS `contract`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract` ( `id` tinyint(2) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(25) NOT NULL, `lvlmin` tinyint(2) unsigned NOT NULL, `time` int(7) unsigned NOT NULL, `opit` mediumint(5) unsigned NOT NULL, `money` mediumint(5) unsigned NOT NULL, `gold` tinyint(1) unsigned NOT NULL, `gorod` tinyint(2) unsigned NOT NULL, `lvl` tinyint(1) unsigned NOT NULL DEFAULT '1', `lumber` smallint(5) unsigned NOT NULL DEFAULT '1', `tkani` smallint(5) unsigned NOT NULL DEFAULT '1', `rom` smallint(5) unsigned NOT NULL DEFAULT '1', `steel` smallint(5) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `lvlmin` (`lvlmin`,`gorod`), KEY `gorod` (`gorod`) ) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract_kom` -- DROP TABLE IF EXISTS `contract_kom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract_kom` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `id_contract` tinyint(3) unsigned NOT NULL, `name` varchar(25) NOT NULL, `time` mediumint(6) unsigned NOT NULL, `opit` mediumint(5) unsigned NOT NULL, `money` mediumint(5) unsigned NOT NULL, `gold` tinyint(2) unsigned NOT NULL, `etap` tinyint(1) unsigned NOT NULL DEFAULT '0', `lose` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl` tinyint(1) unsigned NOT NULL DEFAULT '1', `ekipazh_user` tinyint(3) unsigned NOT NULL DEFAULT '0', `hp_user` smallint(5) unsigned NOT NULL DEFAULT '0', `ekipazh_user_hp` mediumint(5) unsigned NOT NULL DEFAULT '0', `ekipazh_user_hp_sum` mediumint(5) unsigned NOT NULL DEFAULT '0', `lumber` smallint(5) unsigned NOT NULL DEFAULT '1', `tkani` smallint(5) unsigned NOT NULL DEFAULT '1', `rom` smallint(5) unsigned NOT NULL DEFAULT '1', `steel` smallint(5) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `id_add` (`id_add`) ) ENGINE=InnoDB AUTO_INCREMENT=239538 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract_logi` -- DROP TABLE IF EXISTS `contract_logi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract_logi` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(250) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=1601686 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract_prohod` -- DROP TABLE IF EXISTS `contract_prohod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract_prohod` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `contract` tinyint(3) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `time` (`time`), KEY `id_user` (`id_user`,`contract`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=71412 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract_vrag` -- DROP TABLE IF EXISTS `contract_vrag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract_vrag` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `hp` mediumint(5) unsigned NOT NULL, `hp_max` mediumint(5) unsigned NOT NULL, `att` mediumint(5) unsigned NOT NULL, `img` tinyint(3) unsigned NOT NULL, `sektor` tinyint(2) unsigned NOT NULL, `name` varchar(20) NOT NULL, `manevr` tinyint(1) unsigned NOT NULL DEFAULT '2', `toch` tinyint(1) unsigned NOT NULL DEFAULT '2', `ekipazh_vrag` tinyint(3) unsigned NOT NULL DEFAULT '0', `hp_vrag` smallint(5) unsigned NOT NULL DEFAULT '0', `ekipazh_vrag_hp` mediumint(5) unsigned NOT NULL DEFAULT '0', `ekipazh_vrag_hp_sum` mediumint(5) unsigned NOT NULL DEFAULT '0', `hp_vrag_max` smallint(5) unsigned NOT NULL DEFAULT '0', `att_vrag` tinyint(3) unsigned NOT NULL DEFAULT '10', `att_ekipazh` tinyint(3) unsigned NOT NULL DEFAULT '10', PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`) ) ENGINE=InnoDB AUTO_INCREMENT=396613 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dialog` -- DROP TABLE IF EXISTS `dialog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dialog` ( `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` mediumint(11) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `id_poluchat` mediumint(7) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_poluchat` (`id_poluchat`), KEY `id_add` (`id_add`,`id_poluchat`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4018 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fish_boi` -- DROP TABLE IF EXISTS `fish_boi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fish_boi` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `id_fish` tinyint(1) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `hp` mediumint(6) unsigned NOT NULL, `hp_max` mediumint(5) unsigned NOT NULL, `att` smallint(5) unsigned NOT NULL, `name` varchar(20) NOT NULL, `hp_us` mediumint(5) unsigned NOT NULL, `hp_us_max` mediumint(5) unsigned NOT NULL, `garpun` tinyint(3) unsigned NOT NULL DEFAULT '0', `gorod` tinyint(2) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=67997 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fish_ubil` -- DROP TABLE IF EXISTS `fish_ubil`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fish_ubil` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `id_fish` tinyint(1) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `gorod` tinyint(2) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`), KEY `time` (`time`), KEY `id_user_2` (`id_user`,`id_fish`,`gorod`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2724 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fort` -- DROP TABLE IF EXISTS `fort`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fort` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_clan` int(11) unsigned NOT NULL, `id_user` int(11) unsigned NOT NULL, `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL, `win` tinyint(1) unsigned NOT NULL DEFAULT '0', `gorod` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_clan` (`id_clan`), KEY `id_user` (`id_user`), KEY `gorod` (`gorod`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fort_chat` -- DROP TABLE IF EXISTS `fort_chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fort_chat` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `id_add` int(11) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `text` varchar(100) NOT NULL, `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `id_k` int(11) unsigned NOT NULL DEFAULT '0', `st` tinyint(1) unsigned NOT NULL DEFAULT '0', `id_clan` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`), KEY `id_clan` (`id_clan`) ) ENGINE=InnoDB AUTO_INCREMENT=3322 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fort_kom` -- DROP TABLE IF EXISTS `fort_kom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fort_kom` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_gorod` tinyint(1) unsigned NOT NULL DEFAULT '0', `id_сlan` int(11) unsigned NOT NULL, `minuser` int(2) unsigned NOT NULL, `maxuser` int(2) unsigned NOT NULL, `time_nac` int(11) unsigned NOT NULL, `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `etap` int(11) unsigned NOT NULL DEFAULT '0', `timerp` int(11) NOT NULL, `time_sozd` int(10) unsigned NOT NULL, `id_vrag` int(11) unsigned NOT NULL, `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `zabral` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `act` (`act`), KEY `id_сlan` (`id_сlan`), KEY `id_vrag` (`id_vrag`), KEY `id_gorod` (`id_gorod`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fort_user` -- DROP TABLE IF EXISTS `fort_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fort_user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `id_clan` int(11) unsigned NOT NULL, `id_kom` int(11) unsigned NOT NULL, `att` mediumint(5) unsigned NOT NULL DEFAULT '0', `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `zabral` tinyint(1) unsigned NOT NULL DEFAULT '0', `st` tinyint(1) unsigned NOT NULL DEFAULT '0', `hp` tinyint(1) unsigned NOT NULL DEFAULT '0', `hp_user` mediumint(5) unsigned NOT NULL, `hp_user_max` mediumint(5) unsigned NOT NULL, `idattag` int(11) unsigned NOT NULL DEFAULT '0', `hp_max` mediumint(5) unsigned NOT NULL, `toch` smallint(5) unsigned NOT NULL, `manevr` smallint(5) unsigned NOT NULL, `name` varchar(20) NOT NULL DEFAULT '', `time_att` int(10) unsigned NOT NULL DEFAULT '0', `gorod` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`), KEY `id_kom` (`id_kom`), KEY `st` (`st`), KEY `id_clan` (`id_clan`), KEY `gorod` (`gorod`) ) ENGINE=InnoDB AUTO_INCREMENT=184 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `forum_msg` -- DROP TABLE IF EXISTS `forum_msg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `forum_msg` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_theme` int(11) unsigned NOT NULL, `id_add` int(11) unsigned NOT NULL, `msg` varchar(5000) NOT NULL, `data` int(11) unsigned NOT NULL, `tip` int(1) NOT NULL, `id_k` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_add` (`id_add`), KEY `id_theme` (`id_theme`), KEY `tip` (`tip`), KEY `data` (`data`) ) ENGINE=InnoDB AUTO_INCREMENT=549 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `forum_theme` -- DROP TABLE IF EXISTS `forum_theme`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `forum_theme` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(500) NOT NULL, `id_add` int(11) unsigned NOT NULL, `data` varchar(30) NOT NULL, `tip` int(1) NOT NULL, `status` varchar(10) NOT NULL, `razdel` int(1) NOT NULL DEFAULT '0', `zakr` int(1) NOT NULL DEFAULT '2', `timer` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `id_add` (`id_add`), KEY `tip` (`tip`), KEY `zakr` (`zakr`), KEY `razdel` (`razdel`), KEY `timer` (`timer`) ) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gorod` -- DROP TABLE IF EXISTS `gorod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gorod` ( `id` tinyint(1) NOT NULL AUTO_INCREMENT, `name` enum('Андреас-Айленд','Арройос','Большой Кайман','Бухта Гиарико','Донгуана','Драй Тортугас','Игуэй','Иль-а-Ваш','Кабо Де Крус','Кингстон','Коросаль','Крукед Айленд','Кэт Айленд','Лонг-Бэй','Навасса','Нассау','Нью-Боун','Остров Абако','Остров Ангав','Остров Пинос','Сан-Хуан','Сантанилья','Серанилья','Соленая Лагуна','Чинчорро','Шарлотт','Эльтерра') NOT NULL, `time_riba` tinyint(1) unsigned NOT NULL DEFAULT '0', `x` tinyint(2) NOT NULL, `y` tinyint(2) NOT NULL, `riba` tinyint(1) unsigned NOT NULL DEFAULT '0', `time_boss` int(10) unsigned NOT NULL DEFAULT '0', `clan` smallint(5) unsigned NOT NULL DEFAULT '1', `time_att` int(10) unsigned NOT NULL DEFAULT '0', `lvl_push` tinyint(1) unsigned NOT NULL DEFAULT '1', `lvl_mortira` tinyint(1) unsigned NOT NULL DEFAULT '1', `time_push` int(10) unsigned NOT NULL, `time_mortira` int(10) unsigned NOT NULL, `lvl_push2` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_push3` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_mortira2` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_mortira3` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_mortira4` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_deff` tinyint(1) unsigned NOT NULL DEFAULT '0', `rinok` tinyint(1) unsigned NOT NULL DEFAULT '0', `verf` tinyint(1) unsigned NOT NULL DEFAULT '0', `shop` tinyint(1) unsigned NOT NULL DEFAULT '0', `taverna` tinyint(1) unsigned NOT NULL DEFAULT '0', `time_zahvat` varchar(2) NOT NULL DEFAULT '1', `time_nac` varchar(2) NOT NULL, `tip_zahvat` tinyint(1) unsigned NOT NULL DEFAULT '0', `act` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `clan` (`clan`), KEY `x` (`x`), KEY `time_nac` (`time_nac`), KEY `y` (`y`) USING BTREE, KEY `y_2` (`y`,`x`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gorod3` -- DROP TABLE IF EXISTS `gorod3`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gorod3` ( `id` tinyint(1) NOT NULL AUTO_INCREMENT, `name` varchar(15) NOT NULL, `time_riba` int(10) unsigned NOT NULL DEFAULT '0', `x` float NOT NULL, `y` float NOT NULL, `riba` tinyint(1) unsigned NOT NULL DEFAULT '0', `time_boss` int(10) unsigned NOT NULL DEFAULT '0', `clan` int(11) unsigned NOT NULL DEFAULT '1', `time_att` int(10) unsigned NOT NULL DEFAULT '0', `lvl_push` tinyint(1) unsigned NOT NULL DEFAULT '1', `lvl_mortira` tinyint(1) unsigned NOT NULL DEFAULT '1', `time_push` int(10) unsigned NOT NULL, `time_mortira` int(10) unsigned NOT NULL, `lvl_push2` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_push3` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_mortira2` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_mortira3` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_mortira4` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_deff` tinyint(1) unsigned NOT NULL DEFAULT '0', `rinok` tinyint(1) unsigned NOT NULL DEFAULT '0', `verf` tinyint(1) unsigned NOT NULL DEFAULT '0', `shop` tinyint(1) unsigned NOT NULL DEFAULT '0', `taverna` tinyint(1) unsigned NOT NULL DEFAULT '0', `time_zahvat` varchar(2) NOT NULL DEFAULT '1', `time_nac` varchar(2) NOT NULL, `tip_zahvat` tinyint(1) unsigned NOT NULL DEFAULT '0', `act` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `clan` (`clan`), KEY `y` (`y`), KEY `x` (`x`) ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `help` -- DROP TABLE IF EXISTS `help`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `help` ( `id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT, `razdel` tinyint(1) unsigned NOT NULL, `podrazdel` tinyint(1) unsigned NOT NULL, `text` varchar(5000) NOT NULL, `name` varchar(30) NOT NULL, PRIMARY KEY (`id`), KEY `podrazdel` (`podrazdel`), KEY `razdel` (`razdel`) ) ENGINE=MyISAM AUTO_INCREMENT=104 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ignor` -- DROP TABLE IF EXISTS `ignor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ignor` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `id_i` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_i` (`id_i`), KEY `id_add` (`id_add`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `inventar` -- DROP TABLE IF EXISTS `inventar`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `inventar` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` mediumint(5) unsigned NOT NULL, `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `id_shop` smallint(5) unsigned NOT NULL DEFAULT '0', `name` varchar(30) NOT NULL, `kol` tinyint(1) unsigned NOT NULL DEFAULT '1', `chast` tinyint(1) unsigned NOT NULL DEFAULT '0', `komplekt` tinyint(2) unsigned NOT NULL DEFAULT '0', `lvlmin` tinyint(2) unsigned NOT NULL DEFAULT '0', `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `att` smallint(5) unsigned NOT NULL DEFAULT '0', `skor` tinyint(2) unsigned NOT NULL DEFAULT '0', `hp` smallint(5) unsigned NOT NULL DEFAULT '0', `att2` smallint(5) unsigned NOT NULL DEFAULT '0', `hp2` smallint(5) unsigned NOT NULL DEFAULT '0', `ul` tinyint(1) unsigned NOT NULL DEFAULT '0', `rinok` tinyint(1) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL DEFAULT '0', `clan` mediumint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `tip` (`tip`), KEY `time` (`time`), KEY `clan` (`clan`), KEY `id_user_2` (`id_user`,`clan`) USING BTREE, KEY `id_user_3` (`id_user`,`chast`,`act`,`tip`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=11451 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `logi_ip` -- DROP TABLE IF EXISTS `logi_ip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `logi_ip` ( `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` mediumint(7) unsigned NOT NULL, `ip` varchar(13) NOT NULL, `os` varchar(250) NOT NULL, `user_agent` varchar(55) NOT NULL, `data` int(10) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`), KEY `ip` (`ip`), KEY `os` (`os`), KEY `data` (`data`) ) ENGINE=InnoDB AUTO_INCREMENT=34724 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `logi_user` -- DROP TABLE IF EXISTS `logi_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `logi_user` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(500) NOT NULL, `date` int(10) unsigned NOT NULL, `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `tip` (`tip`), KEY `id_user` (`id_user`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `logi_users` -- DROP TABLE IF EXISTS `logi_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `logi_users` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` mediumint(7) unsigned NOT NULL, `log` varchar(500) NOT NULL, `data` int(10) unsigned NOT NULL, `tip` tinyint(2) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `data` (`data`), KEY `id_user_2` (`id_user`,`tip`) ) ENGINE=InnoDB AUTO_INCREMENT=83594 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lotery` -- DROP TABLE IF EXISTS `lotery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lotery` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `maps` -- DROP TABLE IF EXISTS `maps`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maps` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL DEFAULT '0', `id_gorod` tinyint(1) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `x` smallint(2) unsigned NOT NULL DEFAULT '0', `y` smallint(2) unsigned NOT NULL DEFAULT '0', `gde_klad` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=77946 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `monstrs` -- DROP TABLE IF EXISTS `monstrs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `monstrs` ( `id` tinyint(2) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(25) NOT NULL, `lvlmin` tinyint(2) unsigned NOT NULL, `time` int(7) unsigned NOT NULL, `opit` mediumint(5) unsigned NOT NULL, `money` mediumint(5) unsigned NOT NULL, `gold` tinyint(1) unsigned NOT NULL, `gorod` tinyint(2) unsigned NOT NULL, `lvl` tinyint(1) unsigned NOT NULL DEFAULT '1', `lumber` smallint(5) unsigned NOT NULL DEFAULT '1', `tkani` smallint(5) unsigned NOT NULL DEFAULT '1', `rom` smallint(5) unsigned NOT NULL DEFAULT '1', `steel` smallint(5) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `lvlmin` (`lvlmin`,`gorod`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `monstrs_kom` -- DROP TABLE IF EXISTS `monstrs_kom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `monstrs_kom` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `id_contract` tinyint(3) unsigned NOT NULL, `name` varchar(25) NOT NULL, `time` mediumint(6) unsigned NOT NULL, `opit` mediumint(5) unsigned NOT NULL, `money` mediumint(5) unsigned NOT NULL, `gold` tinyint(2) unsigned NOT NULL, `etap` tinyint(1) unsigned NOT NULL DEFAULT '0', `lose` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl` tinyint(1) unsigned NOT NULL DEFAULT '1', `ekipazh_user` tinyint(3) unsigned NOT NULL DEFAULT '0', `hp_user` smallint(5) unsigned NOT NULL DEFAULT '0', `ekipazh_user_hp` mediumint(5) unsigned NOT NULL DEFAULT '0', `ekipazh_user_hp_sum` mediumint(5) unsigned NOT NULL DEFAULT '0', `lumber` smallint(5) unsigned NOT NULL DEFAULT '1', `tkani` smallint(5) unsigned NOT NULL DEFAULT '1', `rom` smallint(5) unsigned NOT NULL DEFAULT '1', `steel` smallint(5) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `id_user` (`id_add`) ) ENGINE=InnoDB AUTO_INCREMENT=144014 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `monstrs_logi` -- DROP TABLE IF EXISTS `monstrs_logi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `monstrs_logi` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(250) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=3265881 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `monstrs_prohod` -- DROP TABLE IF EXISTS `monstrs_prohod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `monstrs_prohod` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `contract` tinyint(3) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`), KEY `time` (`time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `monstrs_vrag` -- DROP TABLE IF EXISTS `monstrs_vrag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `monstrs_vrag` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `hp` mediumint(5) unsigned NOT NULL, `hp_max` mediumint(5) unsigned NOT NULL, `att` mediumint(5) unsigned NOT NULL, `img` tinyint(3) unsigned NOT NULL, `sektor` tinyint(2) unsigned NOT NULL, `name` varchar(20) NOT NULL, `manevr` tinyint(1) unsigned NOT NULL DEFAULT '2', `toch` tinyint(1) unsigned NOT NULL DEFAULT '2', `ekipazh_vrag` tinyint(3) unsigned NOT NULL DEFAULT '0', `hp_vrag` smallint(5) unsigned NOT NULL DEFAULT '0', `ekipazh_vrag_hp` mediumint(5) unsigned NOT NULL DEFAULT '0', `ekipazh_vrag_hp_sum` mediumint(5) unsigned NOT NULL DEFAULT '0', `hp_vrag_max` smallint(5) unsigned NOT NULL DEFAULT '0', `att_vrag` tinyint(3) unsigned NOT NULL DEFAULT '10', `att_ekipazh` tinyint(3) unsigned NOT NULL DEFAULT '10', `timer` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`) ) ENGINE=InnoDB AUTO_INCREMENT=144015 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `msg` -- DROP TABLE IF EXISTS `msg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `msg` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `id_poluchat` int(11) unsigned NOT NULL, `text` varchar(500) NOT NULL, `time` int(10) unsigned NOT NULL, `osm` tinyint(1) unsigned NOT NULL, `pokaz` tinyint(1) unsigned NOT NULL, `dialog` mediumint(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_add` (`id_add`), KEY `time` (`time`), KEY `dialog_2` (`dialog`,`osm`,`id_add`), KEY `id_poluchat` (`id_poluchat`,`osm`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=43026 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `nahodka` -- DROP TABLE IF EXISTS `nahodka`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nahodka` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `tip` enum('lumber','rom','steel','tkani','money','ekipazh') NOT NULL, `kol` tinyint(3) unsigned NOT NULL, `img` tinyint(3) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `x` smallint(2) unsigned NOT NULL, `y` smallint(2) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=186589 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `news` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `text` varchar(10000) NOT NULL, `id_add` int(11) unsigned NOT NULL, `data` int(10) unsigned NOT NULL, `+` int(10) unsigned NOT NULL DEFAULT '0', `-` int(10) unsigned NOT NULL DEFAULT '0', `thema_id` int(11) unsigned NOT NULL, `name` varchar(35) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ohotniki` -- DROP TABLE IF EXISTS `ohotniki`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ohotniki` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `lose` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl` tinyint(3) unsigned NOT NULL, `ekipazh_user` smallint(5) unsigned NOT NULL, `hp_user` mediumint(5) unsigned NOT NULL, `ekipazh_user_hp` mediumint(5) unsigned NOT NULL, `ekipazh_user_hp_sum` mediumint(5) unsigned NOT NULL, `ekipazh_vrag` mediumint(5) unsigned NOT NULL, `hp_vrag` mediumint(5) unsigned NOT NULL, `ekipazh_vrag_hp` mediumint(5) unsigned NOT NULL, `ekipazh_vrag_hp_sum` mediumint(5) unsigned NOT NULL, `hp_vrag_max` mediumint(5) unsigned NOT NULL, `att_vrag` mediumint(5) unsigned NOT NULL, `att_ekipazh` mediumint(5) unsigned NOT NULL, `boarding` tinyint(1) unsigned NOT NULL DEFAULT '0', `hp` mediumint(5) unsigned NOT NULL, `hp_max` mediumint(5) unsigned NOT NULL, `att` smallint(5) unsigned NOT NULL, `manevr` tinyint(3) unsigned NOT NULL, `toch` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=9208 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `orden_pve` -- DROP TABLE IF EXISTS `orden_pve`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orden_pve` ( `id` smallint(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(25) NOT NULL, `lvlmin` tinyint(2) unsigned NOT NULL, `pokaz` tinyint(1) unsigned NOT NULL, `minuser` tinyint(5) unsigned NOT NULL, `maxuser` tinyint(5) unsigned NOT NULL, `time` smallint(11) unsigned NOT NULL, `opit` mediumint(11) unsigned NOT NULL, `money` mediumint(5) unsigned NOT NULL, `lumber` smallint(5) unsigned NOT NULL, `tkani` smallint(5) unsigned NOT NULL, `rom` smallint(5) unsigned NOT NULL, `steel` smallint(5) unsigned NOT NULL, `gold` smallint(5) unsigned NOT NULL, `lvlmax` tinyint(2) unsigned NOT NULL, `open` tinyint(1) unsigned NOT NULL DEFAULT '1', `text` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `pokaz` (`pokaz`), KEY `lvlmax` (`lvlmax`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `orden_pve_chat` -- DROP TABLE IF EXISTS `orden_pve_chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orden_pve_chat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `id_add` int(11) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `text` varchar(400) NOT NULL, `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `id_k` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`) ) ENGINE=InnoDB AUTO_INCREMENT=15627 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `orden_pve_kom` -- DROP TABLE IF EXISTS `orden_pve_kom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orden_pve_kom` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_clan` int(11) unsigned NOT NULL, `id_add` int(11) unsigned NOT NULL, `id_opera` tinyint(1) unsigned NOT NULL, `name` varchar(25) NOT NULL, `lvlmin` tinyint(2) unsigned NOT NULL, `minuser` tinyint(2) unsigned NOT NULL, `maxuser` tinyint(2) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `time_nac` int(10) unsigned NOT NULL, `opit` smallint(5) unsigned NOT NULL, `money` smallint(5) unsigned NOT NULL, `lumber` smallint(5) unsigned NOT NULL, `tkani` smallint(5) unsigned NOT NULL, `rom` smallint(5) unsigned NOT NULL, `steel` smallint(5) unsigned NOT NULL, `gold` tinyint(3) unsigned NOT NULL, `act` tinyint(1) unsigned NOT NULL, `etap` tinyint(1) unsigned NOT NULL, `timerp` int(10) unsigned NOT NULL, `lvlmax` tinyint(2) unsigned NOT NULL, `zabral` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_clan` (`id_clan`), KEY `id_opera` (`id_opera`), KEY `act` (`act`), KEY `id_add` (`id_add`) ) ENGINE=InnoDB AUTO_INCREMENT=1451 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `orden_pve_prohod` -- DROP TABLE IF EXISTS `orden_pve_prohod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orden_pve_prohod` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_clan` int(11) unsigned NOT NULL, `id_travel` tinyint(1) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `time` (`time`), KEY `id_user` (`id_clan`,`id_travel`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `orden_pve_user` -- DROP TABLE IF EXISTS `orden_pve_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orden_pve_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `id_user` int(11) unsigned NOT NULL, `login` varchar(20) NOT NULL, `att` mediumint(5) unsigned NOT NULL DEFAULT '0', `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `rem` tinyint(1) unsigned NOT NULL DEFAULT '0', `ubit` tinyint(1) unsigned NOT NULL DEFAULT '0', `hp` int(11) NOT NULL, `hp_user` mediumint(5) unsigned NOT NULL, `hp_max` int(11) unsigned NOT NULL, `vrag` int(11) unsigned NOT NULL DEFAULT '0', `period` int(10) unsigned NOT NULL DEFAULT '1', `zabral` tinyint(1) unsigned NOT NULL DEFAULT '0', `sektor` tinyint(11) unsigned NOT NULL, `timer` int(10) unsigned NOT NULL DEFAULT '0', `podsek` int(11) unsigned NOT NULL DEFAULT '0', `nagrada` int(11) unsigned NOT NULL DEFAULT '0', `nagradakol` int(11) unsigned NOT NULL DEFAULT '0', `money` mediumint(5) unsigned NOT NULL DEFAULT '0', `opit` mediumint(5) unsigned NOT NULL DEFAULT '0', `time_att` int(11) unsigned NOT NULL, `opera_time_att` int(11) unsigned NOT NULL, `uron` int(5) unsigned NOT NULL, `deff` mediumint(5) unsigned NOT NULL, `krit` mediumint(5) unsigned NOT NULL, `uvorot` mediumint(5) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id_user` (`id_user`), KEY `id_kom` (`id_kom`,`hp`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2531 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `orden_pve_vrag` -- DROP TABLE IF EXISTS `orden_pve_vrag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orden_pve_vrag` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `name` varchar(25) NOT NULL, `hp` mediumint(5) unsigned NOT NULL, `hp_max` mediumint(5) unsigned NOT NULL, `att` mediumint(5) unsigned NOT NULL, `deff` mediumint(5) unsigned NOT NULL, `toch` mediumint(5) unsigned NOT NULL, `manevr` mediumint(5) unsigned NOT NULL, `img` smallint(5) unsigned NOT NULL, `sektor` tinyint(2) unsigned NOT NULL DEFAULT '0', `podsek` tinyint(1) unsigned NOT NULL DEFAULT '0', `podsek2` tinyint(1) unsigned NOT NULL DEFAULT '0', `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `timer` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`), KEY `sektor` (`sektor`) ) ENGINE=InnoDB AUTO_INCREMENT=1449 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `payment_mail` -- DROP TABLE IF EXISTS `payment_mail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payment_mail` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `pay_id` bigint(111) unsigned NOT NULL, `user_id` int(11) unsigned NOT NULL, `sum` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `pay_id` (`pay_id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `payment_ok` -- DROP TABLE IF EXISTS `payment_ok`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payment_ok` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `pay_id` bigint(40) unsigned NOT NULL, `user_id` int(11) unsigned NOT NULL, `date` varchar(40) NOT NULL, `sum` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `pay_id` (`pay_id`) ) ENGINE=MyISAM AUTO_INCREMENT=331 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `poleuser` -- DROP TABLE IF EXISTS `poleuser`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `poleuser` ( `id` mediumint(5) unsigned NOT NULL, `login` varchar(25) NOT NULL, `authtime` int(10) unsigned NOT NULL, `lvl` tinyint(3) unsigned NOT NULL DEFAULT '1', `tip` enum('user','bot') NOT NULL, `att` smallint(5) unsigned NOT NULL, `deff` smallint(5) unsigned NOT NULL, `toch` smallint(5) unsigned NOT NULL, `manevr` smallint(5) unsigned NOT NULL, `hp` smallint(5) unsigned NOT NULL, `hp_max` smallint(5) unsigned NOT NULL, `time_bot` int(10) unsigned NOT NULL, `gorod` tinyint(1) unsigned NOT NULL, `clan` smallint(5) unsigned NOT NULL DEFAULT '0', `x` smallint(2) unsigned NOT NULL, `y` smallint(2) unsigned NOT NULL DEFAULT '0', `time_hod` int(10) unsigned NOT NULL DEFAULT '0', `boarding` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `authtime_2` (`authtime`), KEY `boarding` (`boarding`), KEY `tip` (`tip`,`hp`), KEY `lvl` (`lvl`), KEY `x` (`x`,`y`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_chat` -- DROP TABLE IF EXISTS `pvp_chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_chat` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `id_add` int(11) unsigned NOT NULL, `time` int(11) unsigned NOT NULL, `text` varchar(100) NOT NULL, `st` int(1) unsigned NOT NULL, `id_k` int(11) NOT NULL DEFAULT '0', `tip` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`), KEY `st` (`st`) ) ENGINE=InnoDB AUTO_INCREMENT=141035 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_kom` -- DROP TABLE IF EXISTS `pvp_kom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_kom` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `lvl` tinyint(1) unsigned NOT NULL, `id_pvp` tinyint(2) unsigned NOT NULL, `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `name` varchar(30) NOT NULL, `minuser` int(11) unsigned NOT NULL, `maxuser` int(11) unsigned NOT NULL, `time_nac` int(10) unsigned NOT NULL DEFAULT '0', `timer` int(11) unsigned NOT NULL DEFAULT '0', `pobeda` int(1) unsigned NOT NULL DEFAULT '0', `attvseh1` int(11) unsigned NOT NULL DEFAULT '1', `attvseh2` int(11) unsigned NOT NULL DEFAULT '1', `ubil1` int(11) unsigned NOT NULL DEFAULT '0', `ubil2` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `lvl` (`lvl`), KEY `id_pvp` (`id_pvp`), KEY `act` (`act`), KEY `id_add` (`id_add`) ) ENGINE=InnoDB AUTO_INCREMENT=17048 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_user` -- DROP TABLE IF EXISTS `pvp_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `name` varchar(20) NOT NULL, `id_user` int(11) unsigned NOT NULL, `hp` int(11) unsigned NOT NULL, `lvl` int(1) unsigned NOT NULL, `st` tinyint(1) unsigned NOT NULL DEFAULT '1', `act` int(1) NOT NULL DEFAULT '0', `sektor` int(11) unsigned NOT NULL DEFAULT '0', `ubit` tinyint(1) unsigned NOT NULL DEFAULT '0', `att` int(11) unsigned NOT NULL, `time` int(11) unsigned NOT NULL, `zabral` int(1) NOT NULL DEFAULT '0', `id_dop` int(11) NOT NULL DEFAULT '0', `ubil` int(11) unsigned NOT NULL DEFAULT '0', `hp_max` int(11) NOT NULL, `idattag` int(11) NOT NULL DEFAULT '0', `manevr` int(11) NOT NULL DEFAULT '0', `toch` smallint(5) unsigned NOT NULL DEFAULT '0', `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`), KEY `st` (`st`), KEY `ubit` (`ubit`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=34132 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `riba_mesto` -- DROP TABLE IF EXISTS `riba_mesto`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `riba_mesto` ( `id` tinyint(1) NOT NULL AUTO_INCREMENT, `name` varchar(15) NOT NULL, `gorod` tinyint(2) unsigned NOT NULL, `att` int(11) unsigned NOT NULL, `hp` int(11) unsigned NOT NULL, `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `img` tinyint(1) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `nav` varchar(20) NOT NULL, PRIMARY KEY (`id`), KEY `gorod` (`gorod`), KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `rinok` -- DROP TABLE IF EXISTS `rinok`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rinok` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `gorod` tinyint(2) unsigned NOT NULL, `tipint` tinyint(1) unsigned NOT NULL DEFAULT '0', `tip` varchar(25) NOT NULL, `kol` int(11) unsigned NOT NULL, `money` int(11) unsigned NOT NULL, `gold` int(11) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_add` (`id_add`), KEY `gorod` (`gorod`,`tipint`) ) ENGINE=InnoDB AUTO_INCREMENT=9498 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `name_game` enum('Пираты') NOT NULL, `domen` enum('pirats.mobi') NOT NULL, `open_game` tinyint(1) NOT NULL, `reg_game` tinyint(1) NOT NULL, `opit` float unsigned NOT NULL DEFAULT '1', `opittime` varchar(9) NOT NULL, `bon` tinyint(1) unsigned NOT NULL, `bontime` varchar(9) NOT NULL, `minsum` smallint(3) unsigned NOT NULL DEFAULT '0', `bonstip` tinyint(1) unsigned NOT NULL DEFAULT '0', `bonstime` tinyint(1) unsigned NOT NULL DEFAULT '0', `time_comp` int(10) unsigned NOT NULL, `time_news` int(10) unsigned NOT NULL, `boss1` int(10) unsigned NOT NULL DEFAULT '0', `jack` int(11) unsigned NOT NULL DEFAULT '50', `caribi` tinyint(1) unsigned NOT NULL, `shvatka` int(11) unsigned NOT NULL, `turnir_gold` int(11) unsigned NOT NULL, `bon_arts` tinyint(3) unsigned NOT NULL, `online` smallint(5) unsigned NOT NULL, UNIQUE KEY `open_game` (`open_game`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `shop` -- DROP TABLE IF EXISTS `shop`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shop` ( `id` smallint(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `chast` tinyint(1) NOT NULL, `lvlmin` tinyint(11) unsigned NOT NULL, `hp` int(11) NOT NULL, `att` int(11) NOT NULL, `deff` int(11) NOT NULL, `skor` tinyint(5) unsigned NOT NULL DEFAULT '10', `komplekt` int(11) NOT NULL DEFAULT '0', `cost` int(11) unsigned NOT NULL, `lumber` smallint(5) unsigned NOT NULL DEFAULT '0', `tkani` smallint(5) unsigned NOT NULL DEFAULT '0', `steel` smallint(5) unsigned NOT NULL DEFAULT '0', `gold` int(11) unsigned NOT NULL, `kozha_g_kit` tinyint(3) unsigned NOT NULL DEFAULT '0', `kost_bel_akula` tinyint(3) unsigned NOT NULL DEFAULT '0', `kost_akul_molot` tinyint(3) unsigned NOT NULL DEFAULT '0', `kozha_kosatka` tinyint(3) unsigned NOT NULL DEFAULT '0', `kozha_akula_bik` tinyint(3) unsigned NOT NULL DEFAULT '0', `kozha_b_kit` tinyint(3) unsigned NOT NULL DEFAULT '0', `kost_kit_akula` tinyint(3) unsigned NOT NULL DEFAULT '0', `kost_tigr_akula` tinyint(3) unsigned NOT NULL DEFAULT '0', `kost_rif_akula` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `chast` (`chast`), KEY `lvlmin` (`lvlmin`), KEY `komplekt` (`komplekt`,`chast`), KEY `tip_2` (`chast`,`lvlmin`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `shtab` -- DROP TABLE IF EXISTS `shtab`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shtab` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `id_zadanie` tinyint(2) unsigned NOT NULL, `name` enum('Абордаж','Боец','Бой','Заказ','Контракт','Миссия','Охотник','Рыба') NOT NULL, `tip` tinyint(3) unsigned NOT NULL, `kol` smallint(5) unsigned NOT NULL, `osm` tinyint(1) unsigned NOT NULL DEFAULT '0', `nav` tinyint(3) unsigned NOT NULL, `nagrada` enum('gold','lumber','steel','tkani','tknani') NOT NULL, `nagradakol` smallint(5) unsigned NOT NULL, `opit` mediumint(6) unsigned NOT NULL, `nagradaimg` tinyint(2) unsigned NOT NULL, `kols` smallint(5) unsigned NOT NULL DEFAULT '0', `kon` tinyint(1) unsigned NOT NULL DEFAULT '0', `time` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=217548 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `shtorm` -- DROP TABLE IF EXISTS `shtorm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shtorm` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `id_user` int(11) unsigned NOT NULL, `hp` int(11) unsigned NOT NULL DEFAULT '10000', `toch` smallint(3) unsigned NOT NULL DEFAULT '1', `ubit` tinyint(1) unsigned NOT NULL DEFAULT '0', `ubil` smallint(4) unsigned NOT NULL DEFAULT '0', `hp_max` int(11) NOT NULL DEFAULT '10000', `idattag` int(11) NOT NULL DEFAULT '0', `manevr` int(11) NOT NULL DEFAULT '0', `mesto` mediumint(11) unsigned NOT NULL DEFAULT '0', `push` mediumint(5) unsigned NOT NULL, `mortira` mediumint(5) unsigned NOT NULL, `knippeli` mediumint(5) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id_user` (`id_user`), KEY `ubit` (`ubit`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `shtorm_logi` -- DROP TABLE IF EXISTS `shtorm_logi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shtorm_logi` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(400) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `shvatka` -- DROP TABLE IF EXISTS `shvatka`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shvatka` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `id_user` int(11) unsigned NOT NULL, `hp` int(11) unsigned NOT NULL, `toch` smallint(3) unsigned NOT NULL DEFAULT '1', `ubit` tinyint(1) unsigned NOT NULL DEFAULT '0', `att` int(11) unsigned NOT NULL, `ubil` smallint(4) unsigned NOT NULL DEFAULT '0', `hp_max` int(11) NOT NULL, `idattag` int(11) NOT NULL DEFAULT '0', `manevr` int(11) NOT NULL DEFAULT '0', `clan` mediumint(5) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id_user` (`id_user`), KEY `clan` (`clan`), KEY `ubit` (`ubit`,`clan`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `shvatka_clans` -- DROP TABLE IF EXISTS `shvatka_clans`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shvatka_clans` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_clan` int(11) unsigned NOT NULL, `uron` int(11) unsigned NOT NULL DEFAULT '0', `mesto` smallint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `id_clan` (`id_clan`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `shvatka_logi` -- DROP TABLE IF EXISTS `shvatka_logi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shvatka_logi` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(400) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `support` -- DROP TABLE IF EXISTS `support`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `support` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `close` tinyint(1) unsigned NOT NULL, `tip` tinyint(1) unsigned NOT NULL, `text` varchar(500) NOT NULL, `osmu` tinyint(1) NOT NULL DEFAULT '1', `osma` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_add` (`id_add`), KEY `time` (`time`), KEY `osma` (`osma`), KEY `osmu` (`osmu`) ) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `support_msg` -- DROP TABLE IF EXISTS `support_msg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `support_msg` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) NOT NULL, `id_sup` smallint(5) unsigned NOT NULL, `text` varchar(500) NOT NULL, `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_add` (`id_add`), KEY `id_sup` (`id_sup`) ) ENGINE=InnoDB AUTO_INCREMENT=833 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `travel` -- DROP TABLE IF EXISTS `travel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `travel` ( `id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `lvlmin` tinyint(2) unsigned NOT NULL, `minuser` tinyint(2) unsigned NOT NULL, `maxuser` tinyint(2) unsigned NOT NULL, `time` mediumint(6) unsigned NOT NULL, `opit` mediumint(5) unsigned NOT NULL, `money` mediumint(5) unsigned NOT NULL, `gold` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvlmax` tinyint(2) unsigned NOT NULL DEFAULT '60', `open` tinyint(1) NOT NULL DEFAULT '1', `minatt` tinyint(1) NOT NULL DEFAULT '0', `gorod` tinyint(1) unsigned NOT NULL DEFAULT '1', `lumber` smallint(5) unsigned NOT NULL, `tkani` smallint(5) unsigned NOT NULL, `rom` smallint(5) unsigned NOT NULL, `steel` smallint(5) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `gorod` (`gorod`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `travel_chat` -- DROP TABLE IF EXISTS `travel_chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `travel_chat` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `id_add` int(11) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, `text` varchar(150) NOT NULL, `tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `id_k` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `travel_kom` -- DROP TABLE IF EXISTS `travel_kom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `travel_kom` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_add` int(11) unsigned NOT NULL, `id_opera` int(11) unsigned NOT NULL, `name` varchar(25) NOT NULL, `lvlmin` tinyint(2) unsigned NOT NULL, `minuser` int(2) unsigned NOT NULL, `maxuser` int(2) unsigned NOT NULL, `time` int(11) unsigned NOT NULL, `time_nac` int(11) unsigned NOT NULL, `opit` int(11) unsigned NOT NULL, `money` int(11) unsigned NOT NULL, `gold` int(1) unsigned NOT NULL, `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `etap` int(11) unsigned NOT NULL DEFAULT '0', `timerp` int(11) NOT NULL, `minatt` int(11) unsigned NOT NULL, `lvlmax` int(11) NOT NULL, `sektor1` int(1) NOT NULL DEFAULT '0', `sektor2` int(1) NOT NULL DEFAULT '0', `sektor3` int(1) NOT NULL DEFAULT '0', `sektor4` int(1) NOT NULL DEFAULT '0', `sektor5` int(1) NOT NULL DEFAULT '0', `attvseh` int(11) unsigned NOT NULL DEFAULT '0', `sektor6` int(1) unsigned NOT NULL DEFAULT '0', `sektor7` int(1) unsigned NOT NULL DEFAULT '0', `sektor8` int(1) NOT NULL DEFAULT '0', `sektor9` int(1) NOT NULL DEFAULT '0', `sektor10` int(1) NOT NULL DEFAULT '0', `time_sozd` int(10) unsigned NOT NULL, `lumber` smallint(5) unsigned NOT NULL, `tkani` smallint(5) unsigned NOT NULL, `rom` smallint(5) unsigned NOT NULL, `steel` smallint(5) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_opera` (`id_opera`), KEY `act` (`act`), KEY `id_add` (`id_add`) ) ENGINE=InnoDB AUTO_INCREMENT=23395 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `travel_prohod` -- DROP TABLE IF EXISTS `travel_prohod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `travel_prohod` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `id_travel` tinyint(1) unsigned NOT NULL, `time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `time` (`time`), KEY `id_user` (`id_user`,`id_travel`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `travel_user` -- DROP TABLE IF EXISTS `travel_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `travel_user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `id_kom` int(11) unsigned NOT NULL, `att` mediumint(5) unsigned NOT NULL DEFAULT '0', `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `rem` tinyint(1) unsigned NOT NULL DEFAULT '0', `zabral` tinyint(1) unsigned NOT NULL DEFAULT '0', `vrag` int(11) unsigned NOT NULL DEFAULT '0', `period` tinyint(1) unsigned NOT NULL DEFAULT '1', `hp` mediumint(55) unsigned NOT NULL, `sektor` int(11) unsigned NOT NULL DEFAULT '0', `hp_user` mediumint(5) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`), KEY `id_kom` (`id_kom`) ) ENGINE=InnoDB AUTO_INCREMENT=39932 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `travel_vrag` -- DROP TABLE IF EXISTS `travel_vrag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `travel_vrag` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_kom` int(11) unsigned NOT NULL, `hp` mediumint(5) unsigned NOT NULL, `hp_max` mediumint(5) unsigned NOT NULL, `att` mediumint(5) unsigned NOT NULL, `deff` mediumint(5) unsigned NOT NULL, `toch` tinyint(2) unsigned NOT NULL, `manevr` tinyint(2) unsigned NOT NULL, `img` tinyint(3) unsigned NOT NULL DEFAULT '0', `sektor` tinyint(2) unsigned NOT NULL DEFAULT '0', `act` tinyint(1) unsigned NOT NULL DEFAULT '0', `timer` int(10) unsigned NOT NULL, `name` varchar(20) NOT NULL, PRIMARY KEY (`id`), KEY `id_kom` (`id_kom`) ) ENGINE=InnoDB AUTO_INCREMENT=96360 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `turnir` -- DROP TABLE IF EXISTS `turnir`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `turnir` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `id_user` int(11) unsigned NOT NULL, `hp` int(11) unsigned NOT NULL, `toch` smallint(3) unsigned NOT NULL DEFAULT '1', `ubit` tinyint(1) unsigned NOT NULL DEFAULT '0', `att` int(11) unsigned NOT NULL, `ubil` smallint(4) unsigned NOT NULL DEFAULT '0', `hp_max` int(11) NOT NULL, `idattag` int(11) NOT NULL DEFAULT '0', `manevr` int(11) NOT NULL DEFAULT '0', `mesto` mediumint(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `id_user` (`id_user`), KEY `ubit` (`ubit`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `turnir_logi` -- DROP TABLE IF EXISTS `turnir_logi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `turnir_logi` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `log` varchar(400) NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(20) NOT NULL DEFAULT 'Пират', `pass` varchar(33) NOT NULL, `session` varchar(33) NOT NULL, `datereg` int(10) unsigned NOT NULL, `authtime` int(10) unsigned NOT NULL, `money` int(11) unsigned NOT NULL DEFAULT '1000', `lumber` mediumint(6) unsigned NOT NULL DEFAULT '0', `steel` mediumint(5) unsigned NOT NULL DEFAULT '0', `tkani` mediumint(6) unsigned NOT NULL DEFAULT '0', `rom` mediumint(6) unsigned NOT NULL DEFAULT '0', `gold` mediumint(6) unsigned NOT NULL DEFAULT '0', `opit` int(11) unsigned NOT NULL DEFAULT '15', `lvl` tinyint(2) unsigned NOT NULL DEFAULT '1', `adm` enum('moder','admin','razrab','user') NOT NULL DEFAULT 'user', `hp` mediumint(5) NOT NULL DEFAULT '150', `hp_max` tinyint(3) unsigned NOT NULL DEFAULT '150', `gorod` tinyint(2) unsigned NOT NULL DEFAULT '1', `sex` tinyint(1) unsigned NOT NULL DEFAULT '0', `online` int(11) unsigned NOT NULL DEFAULT '0', `ignor` int(10) unsigned NOT NULL DEFAULT '0', `soh` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_push` tinyint(1) unsigned NOT NULL DEFAULT '1', `lvl_korp` tinyint(1) unsigned NOT NULL DEFAULT '1', `lvl_mortira` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_knippeli` tinyint(1) unsigned NOT NULL DEFAULT '1', `lvl_garpun` tinyint(1) unsigned NOT NULL DEFAULT '1', `lvl_falk` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_truba` tinyint(1) unsigned NOT NULL DEFAULT '0', `lvl_parusa` tinyint(1) unsigned NOT NULL DEFAULT '0', `time_push` int(10) unsigned NOT NULL DEFAULT '0', `time_mortira` int(10) unsigned NOT NULL DEFAULT '0', `time_knippeli` int(10) unsigned NOT NULL DEFAULT '0', `time_garpun` int(10) unsigned NOT NULL DEFAULT '0', `time_falk` int(10) unsigned NOT NULL DEFAULT '0', `att_push` tinyint(1) unsigned NOT NULL DEFAULT '1', `att_mortira` tinyint(1) unsigned NOT NULL DEFAULT '1', `att_knippeli` tinyint(1) unsigned NOT NULL DEFAULT '1', `att_garpun` tinyint(1) unsigned NOT NULL DEFAULT '1', `att_falk` tinyint(1) unsigned NOT NULL DEFAULT '1', `trum` tinyint(1) unsigned NOT NULL DEFAULT '1', `ekipazh` tinyint(1) unsigned NOT NULL DEFAULT '1', `max_ekipazh` tinyint(3) unsigned NOT NULL DEFAULT '1', `max_push` tinyint(1) unsigned NOT NULL DEFAULT '1', `max_mortira` tinyint(1) unsigned NOT NULL DEFAULT '1', `max_knippeli` tinyint(1) unsigned NOT NULL DEFAULT '1', `max_puli` tinyint(1) unsigned NOT NULL DEFAULT '1', `lvl_shlupka` tinyint(1) unsigned NOT NULL DEFAULT '1', `kol_push` smallint(5) unsigned NOT NULL DEFAULT '0', `kol_mortira` smallint(5) unsigned NOT NULL DEFAULT '0', `kol_knippeli` smallint(30) unsigned NOT NULL DEFAULT '5', `kol_garpun` smallint(5) unsigned NOT NULL DEFAULT '10', `kol_puli` smallint(3) unsigned NOT NULL DEFAULT '5', `grot` tinyint(1) unsigned NOT NULL DEFAULT '1', `grot_money` mediumint(7) unsigned NOT NULL DEFAULT '0', `grot_lumber` mediumint(7) unsigned NOT NULL DEFAULT '0', `grot_steel` mediumint(7) unsigned NOT NULL DEFAULT '0', `grot_tkani` mediumint(7) unsigned NOT NULL DEFAULT '0', `grot_rom` mediumint(7) unsigned NOT NULL DEFAULT '0', `besplat_rem` tinyint(2) unsigned NOT NULL DEFAULT '25', `idattag` int(11) unsigned NOT NULL DEFAULT '0', `koluron` int(11) unsigned NOT NULL DEFAULT '0', `hp_us` smallint(5) unsigned NOT NULL DEFAULT '100', `hp_us_max` smallint(5) unsigned NOT NULL DEFAULT '100', `arenawin` int(11) unsigned NOT NULL DEFAULT '0', `att_ekipazh` mediumint(5) unsigned NOT NULL DEFAULT '10', `hp_ekipazh` mediumint(5) unsigned NOT NULL DEFAULT '100', `att_user` smallint(5) unsigned NOT NULL DEFAULT '10', `time_att` int(10) unsigned NOT NULL DEFAULT '0', `time_att_pist` int(10) unsigned NOT NULL DEFAULT '0', `reit_abordazh` int(11) unsigned NOT NULL DEFAULT '0', `secret_slovo` varchar(20) NOT NULL DEFAULT '', `referal` int(11) unsigned NOT NULL DEFAULT '0', `age` tinyint(2) NOT NULL DEFAULT '0', `info` varchar(100) NOT NULL DEFAULT '', `clan` smallint(5) unsigned NOT NULL DEFAULT '0', `opit2` int(11) unsigned NOT NULL DEFAULT '0', `topswap` int(11) unsigned NOT NULL DEFAULT '0', `kozha_g_kit` smallint(5) unsigned NOT NULL DEFAULT '0', `kost_bel_akula` smallint(5) unsigned NOT NULL DEFAULT '0', `kost_akul_molot` smallint(5) unsigned NOT NULL DEFAULT '0', `kozha_kosatka` smallint(5) unsigned NOT NULL DEFAULT '0', `kozha_akula_bik` smallint(5) unsigned NOT NULL DEFAULT '0', `kozha_b_kit` smallint(5) unsigned NOT NULL DEFAULT '0', `kost_kit_akula` smallint(5) unsigned NOT NULL DEFAULT '0', `kost_tigr_akula` smallint(5) unsigned NOT NULL DEFAULT '0', `kost_rif_akula` smallint(5) unsigned NOT NULL DEFAULT '0', `att` smallint(5) unsigned NOT NULL DEFAULT '1', `clan_zvanie` tinyint(1) unsigned NOT NULL DEFAULT '0', `newsn` int(10) unsigned NOT NULL DEFAULT '0', `kolschat` int(10) unsigned NOT NULL DEFAULT '0', `smenalogin` tinyint(1) unsigned NOT NULL DEFAULT '0', `obmengold` tinyint(3) NOT NULL DEFAULT '0', `hp_dop` smallint(4) unsigned NOT NULL DEFAULT '0', `toch` tinyint(2) unsigned NOT NULL DEFAULT '0', `manevr` tinyint(2) unsigned NOT NULL DEFAULT '0', `opitvclan7` int(11) unsigned NOT NULL DEFAULT '0', `clan_time` int(10) unsigned NOT NULL DEFAULT '0', `opitvclan` int(11) unsigned NOT NULL DEFAULT '0', `resvclan` int(11) unsigned NOT NULL DEFAULT '0', `resvclan7` int(11) unsigned NOT NULL DEFAULT '0', `vihodclan` int(10) unsigned NOT NULL DEFAULT '0', `shtrafclan` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(20) NOT NULL DEFAULT '', `time_rom` smallint(3) unsigned NOT NULL DEFAULT '0', `zabralpodar` tinyint(1) unsigned NOT NULL DEFAULT '0', `timepodar` int(10) unsigned NOT NULL DEFAULT '0', `tippodar` tinyint(1) unsigned NOT NULL DEFAULT '0', `prigl_travel` tinyint(1) unsigned NOT NULL DEFAULT '0', `fish_ubil` int(11) unsigned NOT NULL DEFAULT '0', `avatar` tinyint(1) unsigned NOT NULL DEFAULT '0', `time_ohotniki` mediumint(5) unsigned NOT NULL DEFAULT '0', `time_arena` int(10) unsigned NOT NULL DEFAULT '0', `monstr1` smallint(3) unsigned NOT NULL DEFAULT '1', `monstr2` smallint(3) unsigned NOT NULL DEFAULT '1', `monstr3` smallint(3) unsigned NOT NULL DEFAULT '1', `monstr1_time` int(10) unsigned NOT NULL DEFAULT '0', `monstr2_time` int(10) unsigned NOT NULL DEFAULT '0', `monstr3_time` int(10) unsigned NOT NULL DEFAULT '0', `monstr4_time` int(10) unsigned NOT NULL DEFAULT '0', `monstr5_time` int(10) unsigned NOT NULL DEFAULT '0', `monstr4` smallint(3) unsigned NOT NULL DEFAULT '1', `monstr5` smallint(3) unsigned NOT NULL DEFAULT '1', `teach_act` tinyint(1) unsigned NOT NULL DEFAULT '0', `teach` tinyint(2) unsigned NOT NULL DEFAULT '1', `id_ok` bigint(111) unsigned NOT NULL DEFAULT '0', `ok_sesion` varchar(100) NOT NULL DEFAULT ' ', `ok_session_secret_key` varchar(100) NOT NULL DEFAULT ' ', `fish_ubil_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `post_chat_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `arenawin_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `reit_abordazh_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `post_chat` int(11) unsigned NOT NULL DEFAULT '0', `kolschat_clan` int(11) unsigned NOT NULL DEFAULT '0', `boat` tinyint(2) unsigned NOT NULL DEFAULT '0', `id_mail` bigint(111) unsigned NOT NULL DEFAULT '0', `mobile_spec` enum('agent','android','smartphone','basic','ios','') NOT NULL DEFAULT '', `fightwin` int(11) unsigned NOT NULL DEFAULT '0', `fight_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `contractwin` int(11) unsigned NOT NULL DEFAULT '0', `contract_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `missionwin` int(11) unsigned NOT NULL DEFAULT '0', `mission_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `rig_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `rig_kol` mediumint(5) unsigned NOT NULL DEFAULT '0', `comp_kol` int(11) unsigned NOT NULL DEFAULT '0', `comp_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `jack_tip` tinyint(1) unsigned NOT NULL DEFAULT '0', `jack_kol` int(11) unsigned NOT NULL DEFAULT '0', `time_simple` int(10) unsigned NOT NULL DEFAULT '0', `caribi_reit` int(11) NOT NULL DEFAULT '0', `caribi_money` int(11) NOT NULL DEFAULT '0', `shtorm_reit` int(11) unsigned NOT NULL DEFAULT '0', `sunduk_epik` smallint(4) unsigned NOT NULL DEFAULT '0', `sunduk_zakold` smallint(4) unsigned NOT NULL DEFAULT '0', `flot_fight` int(11) unsigned NOT NULL DEFAULT '0', `turnir_reit` int(11) unsigned NOT NULL DEFAULT '0', `kol_bochka` smallint(1) unsigned NOT NULL DEFAULT '0', `max_bochka` smallint(3) unsigned NOT NULL DEFAULT '1', `lvl_bochka` tinyint(1) unsigned NOT NULL DEFAULT '1', `time_bochka` int(10) unsigned NOT NULL DEFAULT '0', `reit_referal` mediumint(7) unsigned NOT NULL DEFAULT '0', `clanobyava` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `login` (`login`), KEY `lvl` (`lvl`), KEY `authtime` (`authtime`), KEY `gorod` (`gorod`), KEY `reit_abordazh` (`reit_abordazh`), KEY `referal` (`referal`), KEY `opit2` (`opit2`), KEY `topswap` (`topswap`), KEY `clan` (`clan`), KEY `arenawin` (`arenawin`), KEY `fish_ubil` (`fish_ubil`), KEY `id_ok` (`id_ok`), KEY `id_mail` (`id_mail`), KEY `time_simple` (`time_simple`), KEY `reit_referal` (`reit_referal`) ) ENGINE=InnoDB AUTO_INCREMENT=29245 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users_block` -- DROP TABLE IF EXISTS `users_block`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users_block` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `id_user_add` mediumint(11) unsigned NOT NULL, `id_user_block` mediumint(5) unsigned NOT NULL, `text` varchar(400) NOT NULL, `time_block` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `id_user_add` (`id_user_add`), KEY `id_user_block` (`id_user_block`) ) ENGINE=InnoDB AUTO_INCREMENT=173 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vip` -- DROP TABLE IF EXISTS `vip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vip` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_user` int(11) unsigned NOT NULL, `time` int(11) unsigned NOT NULL, `tip` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id_user` (`id_user`), KEY `time` (`time`) ) ENGINE=InnoDB AUTO_INCREMENT=5249 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;