Просмотр архива chistayabd

DROP TABLE IF EXISTS `avatar_rating`;

CREATE TABLE `avatar_rating` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
 
`id_ank` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=192 DEFAULT CHARSET=cp1251;




DROP
TABLE IF EXISTS `collective`;

CREATE TABLE `collective` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `name` varchar(24) DEFAULT NULL,
  `rating`
bigint(255) DEFAULT '0',
  `serebro` bigint(255) DEFAULT '0',
  `zolota`
bigint(255) DEFAULT '2500',
  `level` int(11) DEFAULT '1',
  `tehnika`
int(11) DEFAULT '0',
  `time` int(11) DEFAULT NULL,
  `time_obmen` int(11)
DEFAULT '0',
  `titleText` varchar(64) DEFAULT NULL,
  `titleText_user`
int(11) DEFAULT NULL,
  `titleText_time` int(11) DEFAULT NULL,
  `soil`
int(11) DEFAULT '0',
  `irrigate` int(11) DEFAULT '0',
  `scholl` int(11)
DEFAULT '0',
  `vet` int(11) DEFAULT '0',
  `greenhouse` int(11) DEFAULT
'0',
  `school` int(11) DEFAULT '0',
  `rass` varchar(32) DEFAULT '0',
 
`treb` varchar(1024) DEFAULT 'Пусто',
  `trebText_time` varchar(64)
DEFAULT 'не менялись',
  `clantour` int(11) DEFAULT '0',
 
`fishki` int(11) DEFAULT '3',
  `soil_level` int(11) DEFAULT '0',
 
`irrigate_level` int(11) DEFAULT '0',
  `scholl_level` int(11) DEFAULT
'0',
  `vet_level` int(11) DEFAULT '0',
  `scholl_times` int(11) DEFAULT
'1',
  `vet_times` int(11) DEFAULT '1',
  UNIQUE KEY `id` (`id`),
  KEY
`level` (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `collective_cash`;

CREATE TABLE
`collective_cash` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user`
int(11) DEFAULT NULL,
  `id_collective` int(11) DEFAULT NULL,
  `type`
enum('zolota','serebro') DEFAULT 'zolota',
  `time` int(11) DEFAULT '0',
 
`count` bigint(255) DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY
`id_collective` (`id_collective`),
  KEY `id_user` (`id_user`)
)
ENGINE=MyISAM AUTO_INCREMENT=11428 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `collective_chat`;

CREATE TABLE `collective_chat` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
 
`id_collective` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
 
`msg` varchar(10000) DEFAULT NULL,
  `otvet` int(11) DEFAULT '0',
  UNIQUE
KEY `id` (`id`),
  KEY `id_collective` (`id_collective`),
  KEY `id_user`
(`id_user`)
) ENGINE=MyISAM AUTO_INCREMENT=15402 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `collective_invite`;

CREATE TABLE
`collective_invite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user`
int(11) DEFAULT NULL,
  `id_collective` int(11) DEFAULT NULL,
  `id_who`
int(11) DEFAULT NULL,
  `time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
 
KEY `id_user` (`id_user`),
  KEY `id_collective` (`id_collective`)
)
ENGINE=MyISAM AUTO_INCREMENT=1852 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `collective_journal`;

CREATE TABLE `collective_journal` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `zadan` varchar(1024) DEFAULT NULL,
 
`id_collective` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1537 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`collective_user`;

CREATE TABLE `collective_user` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `id_collective`
int(11) DEFAULT NULL,
  `rating` bigint(255) DEFAULT '0',
  `money`
bigint(255) DEFAULT '0',
  `rubies` bigint(255) DEFAULT '0',
  `time`
int(11) DEFAULT '0',
  `status` enum('1','2','3','4','5','6','7') DEFAULT
'1',
  `rubies_week` bigint(255) DEFAULT '0',
  `rating_week` bigint(255)
DEFAULT '0',
  `rating_gos` bigint(255) DEFAULT '0',
  `tehnika` int(11)
DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `id_collective`
(`id_collective`)
) ENGINE=MyISAM AUTO_INCREMENT=854 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `cron`;

CREATE TABLE `cron` (
 
`id` varchar(32) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`guests`;

CREATE TABLE `guests` (
  `ip` bigint(20) NOT NULL,
  `ua`
varchar(32) NOT NULL,
  `date_aut` int(11) NOT NULL,
  `date_last` int(11)
NOT NULL,
  `url` varchar(64) NOT NULL,
  `pereh` int(11) NOT NULL DEFAULT
'0',
  KEY `ip_2` (`ip`,`ua`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `help`;

CREATE TABLE `help` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
 
`time` int(11) DEFAULT NULL,
  `mother` int(11) DEFAULT '0',
  `type`
enum('glav','komm') DEFAULT 'glav',
  `msg` varchar(200) DEFAULT NULL,
 
`name` varchar(20) DEFAULT NULL,
  `locked` enum('0','1') DEFAULT '0',
 
`id_vopros` int(11) DEFAULT '0',
  `read_u` int(11) DEFAULT '0',
  `read_h`
int(11) DEFAULT '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1215 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`kolhoz_blacklist`;

CREATE TABLE `kolhoz_blacklist` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `id_ank` int(11)
DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=232 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `kolhoz_forum`;

CREATE TABLE `kolhoz_forum` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `time` int(11)
DEFAULT NULL,
  `mother` int(11) DEFAULT '0',
  `admod` set('0','1')
DEFAULT '0',
  `type` enum('razdel','tema','komm') DEFAULT 'razdel',
 
`msg` varchar(10000) DEFAULT NULL,
  `name` varchar(1024) DEFAULT NULL,
 
`locked` enum('0','1') DEFAULT '0',
  `otvet` int(11) DEFAULT '0',
 
`pined` enum('0','1') DEFAULT '0',
  `pos` int(11) DEFAULT '0',
 
`time_obnov` int(11) DEFAULT '0',
  `visit` text,
  UNIQUE KEY `id`
(`id`),
  KEY `mother` (`mother`),
  KEY `id_user` (`id_user`)
)
ENGINE=MyISAM AUTO_INCREMENT=2076 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `kolhoz_friends`;

CREATE TABLE `kolhoz_friends` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `id_ank`
int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=656 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `kolhoz_gift`;

CREATE TABLE `kolhoz_gift` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(1024) DEFAULT NULL,
  `cena` int(11)
DEFAULT '0',
  `id_cat` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `kolhoz_gift_cat`;

CREATE TABLE `kolhoz_gift_cat` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `name` varchar(1024) DEFAULT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `kolhoz_gifts`;

CREATE TABLE `kolhoz_gifts` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
 
`id_kont` int(11) DEFAULT NULL,
  `id_gift` int(11) DEFAULT NULL,
  `time`
int(11) DEFAULT NULL,
  `read` set('0','1') DEFAULT '0',
  `msg`
varchar(1024) DEFAULT NULL,
  `anonim` int(11) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=504 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `kolhoz_mail`;

CREATE TABLE `kolhoz_mail` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `id_kont`
int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `msg` varchar(1024)
DEFAULT NULL,
  `read` set('0','1') DEFAULT '0',
  `type` enum('at','to')
DEFAULT 'to',
  `sistem` enum('0','1') DEFAULT '0',
  UNIQUE KEY `id`
(`id`),
  KEY `id_user` (`id_user`),
  KEY `read` (`read`),
  KEY `id_kont`
(`id_kont`)
) ENGINE=MyISAM AUTO_INCREMENT=49896 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `level`;

CREATE TABLE `level` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `level` varchar(4) DEFAULT '0',
 
`rating` varchar(64) DEFAULT '0',
  `zolota` int(11) DEFAULT '0',
 
`serebro` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `level`
(`level`)
) ENGINE=MyISAM AUTO_INCREMENT=159 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `mail`;

CREATE TABLE `mail` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_kont` int(11) NOT
NULL,
  `time` int(11) NOT NULL,
  `msg` varchar(1024) NOT NULL,
  `read`
set('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_user`
(`id_user`,`id_kont`),
  KEY `read` (`read`)
) ENGINE=MyISAM
AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`referals`;

CREATE TABLE `referals` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_ref` int(11) NOT NULL,

 `time` int(11) NOT NULL,
  `ip` varchar(32) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=350 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `reklama`;

CREATE TABLE `reklama` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `ip` varchar(323) DEFAULT NULL,
  `adress`
varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=188 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks`;

CREATE TABLE `tanks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_u` int(11) NOT NULL,
  `serebro` int(11) NOT NULL DEFAULT '50000',
 
`zolota` varchar(123) NOT NULL DEFAULT '5',
  `battle` int(11) NOT NULL
DEFAULT '0',
  `race_last` int(11) NOT NULL,
  `race_kol` int(11) NOT
NULL,
  `rating` int(11) NOT NULL DEFAULT '0',
  `tank` varchar(255) NOT
NULL,
  `fuel` int(1) DEFAULT '300',
  `level` int(11) DEFAULT '1',
 
`rubles` int(11) DEFAULT '10',
  `leveltank` int(11) DEFAULT NULL,
 
`prod_tank` int(11) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
 
`levellev` varchar(30) DEFAULT '0',
  `levelboy` varchar(30) DEFAULT '0',
 
`levelmod` varchar(30) DEFAULT '0',
  `win` int(11) DEFAULT '0',
  `lose`
int(11) DEFAULT '0',
  `bans` int(11) DEFAULT '0',
  `status` int(11)
DEFAULT '0',
  `news` int(11) DEFAULT '0',
  `nich` varchar(32) DEFAULT
'0',
  `chat` int(11) DEFAULT '0',
  `medal` int(11) DEFAULT '0',
 
`time_chat` int(11) DEFAULT '0',
  `ava` varchar(32) DEFAULT '1',
  `boy`
int(11) DEFAULT '0',
  `angars` int(11) DEFAULT '2',
  `prem` varchar(32)
DEFAULT '0',
  `ank_mail` varchar(32) NOT NULL,
  `clan` int(11) DEFAULT
'0',
  `fuels` int(11) DEFAULT '300',
  `vbr` int(11) DEFAULT '0',
 
`vbr_zol` int(11) DEFAULT '0',
  `vbr_ser` int(11) DEFAULT '0',
  `vbr_opt`
int(11) DEFAULT '0',
  `e1` varchar(32) DEFAULT '0',
  `e2` varchar(32)
DEFAULT '0',
  `e3` varchar(32) DEFAULT '0',
  `e4` varchar(32) DEFAULT
'0',
  `mart` int(11) DEFAULT '0',
  `vbr_surprize` int(11) DEFAULT NULL,
 
`banit` int(11) DEFAULT '0',
  `prich_ban` varchar(128) DEFAULT NULL,
 
`time_ban` varchar(32) DEFAULT '5',
  `zadan` int(11) DEFAULT '0',
 
`obmen` int(11) DEFAULT '0',
  `time_obmen` int(11) DEFAULT '0',
 
`forum_time` int(11) DEFAULT '0',
  `chaty_time` int(11) DEFAULT '0',
 
`pocht_time` int(11) DEFAULT '0',
  `forum_times` int(11) DEFAULT '0',
 
`nick_pop` int(11) DEFAULT '1',
  `tour` int(11) DEFAULT '0',
 
`day_rating` bigint(255) NOT NULL,
  `boy_serebro` int(11) DEFAULT '0',
 
`boy_experience` int(11) DEFAULT '0',
  `boy_play` varchar(32) DEFAULT
'0',
  `spec_zadan` int(11) DEFAULT '0',
  `spec_level` int(11) DEFAULT
'0',
  `them` int(11) DEFAULT '0',
  `wartour` int(11) NOT NULL,
  `skidka`
int(11) DEFAULT '0',
  `skidka_prem` int(11) DEFAULT '0',
  `tehpodd`
int(11) DEFAULT '0',
  `help_time` int(11) DEFAULT '0',
 
`time_otvet_vopros` int(11) DEFAULT '0',
  `pob_boj` int(11) DEFAULT '0',
 
`help_user` int(11) DEFAULT '0',
  `avafoto` int(11) DEFAULT '0',
 
`serrating` int(11) DEFAULT '0',
  `boy_seropit` int(11) DEFAULT '0',
 
`boy_pokaz` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `vbr`
(`vbr`),
  KEY `vbr_zol` (`vbr_zol`)
) ENGINE=MyISAM AUTO_INCREMENT=2598
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `tanks_admin`;

CREATE TABLE
`tanks_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ban` varchar(32)
NOT NULL,
  `user` varchar(32) NOT NULL,
  `prich` varchar(32) NOT NULL
DEFAULT '0',
  `act` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `tanks_admin2`;

CREATE TABLE `tanks_admin2` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `ban` varchar(32) NOT NULL,
  `user` varchar(32) NOT
NULL,
  `mail_new` varchar(32) NOT NULL,
  `nick_new` varchar(32) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `tanks_angar`;

CREATE TABLE
`tanks_angar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `leveltank` int(11) NOT NULL,
  `tank` int(11) DEFAULT '0',
 
`e1` int(11) DEFAULT '0',
  `e2` int(11) DEFAULT '0',
  `e3` int(11)
DEFAULT '0',
  `e4` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=6979 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `tanks_ava`;

CREATE TABLE `tanks_ava` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `screen` varchar(255) NOT NULL,
  `price` int(11) NOT
NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `screen` (`screen`),
  FULLTEXT
KEY `screen_2` (`screen`),
  FULLTEXT KEY `screen_3` (`screen`)
)
ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `tanks_boy`;

CREATE TABLE `tanks_boy` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
 
`vkl` int(11) DEFAULT NULL,
  `uidt` int(11) DEFAULT '0',
  `id_usert`
int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=330991 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks_chat`;

CREATE TABLE `tanks_chat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL DEFAULT '0',
  `time` int(11)
NOT NULL,
  `msg` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci
DEFAULT NULL,
  `otvet` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY
`time` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=139 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `tanks_magazin`;

CREATE TABLE
`tanks_magazin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level`
varchar(9) NOT NULL,
  `name` varchar(128) NOT NULL,
  `screen`
varchar(128) NOT NULL,
  `price` varchar(244) NOT NULL,
  `ataka` int(11)
DEFAULT NULL,
  `bron` int(11) DEFAULT NULL,
  `toch` int(11) DEFAULT
NULL,
  `proch` int(11) DEFAULT NULL,
  `strana` int(11) DEFAULT NULL,
 
`prod_tank` int(11) DEFAULT NULL,
  `type` varchar(32) DEFAULT '0',
 
`orud` varchar(32) NOT NULL,
  `opis` varchar(2048) DEFAULT 'Пока
нет описания',
  PRIMARY KEY (`id`),
  KEY `level` (`level`),
 
KEY `level_2` (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=120 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `tanks_maps`;

CREATE TABLE
`tanks_maps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `maps`
varchar(255) NOT NULL,
  `battle` varchar(255) NOT NULL,
  `img`
varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks_medal`;

CREATE TABLE `tanks_medal` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL DEFAULT '0',
  `name`
varchar(64) DEFAULT NULL,
  `screen` varchar(1024) DEFAULT '0',
  `tank`
int(11) DEFAULT NULL,
  `zadan` varchar(64) DEFAULT NULL,
  `kollvo`
int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1825 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks_news`;

CREATE TABLE `tanks_news` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL DEFAULT '0',
  `time` int(11)
NOT NULL,
  `msg` varchar(2048) CHARACTER SET utf8 COLLATE utf8_unicode_ci
DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM
AUTO_INCREMENT=187 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks_oborud`;

CREATE TABLE `tanks_oborud` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `screen` varchar(255) NOT NULL,
  `name` varchar(255) NOT
NULL,
  `price` int(11) NOT NULL,
  `opt` int(11) NOT NULL,
  `sell_price`
int(11) NOT NULL,
  `ataka` int(11) DEFAULT NULL,
  `bron` int(11) DEFAULT
NULL,
  `proch` int(11) DEFAULT NULL,
  `toch` int(11) DEFAULT NULL,
 
`uid` int(11) DEFAULT NULL,
  `tank` int(11) DEFAULT '0',
  PRIMARY KEY
(`id`),
  UNIQUE KEY `screen` (`screen`),
  FULLTEXT KEY `screen_2`
(`screen`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `screen_3`
(`screen`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `tanks_otvet`;

CREATE TABLE `tanks_otvet` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `vopros` varchar(1024) NOT NULL,
  `otvet`
varchar(1024) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks_rules`;

CREATE TABLE `tanks_rules` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `tanks_sclad`;

CREATE TABLE `tanks_sclad` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `screen` varchar(255) NOT NULL,
  `name` varchar(255) NOT
NULL,
  `price` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `name_tanks`
varchar(255) NOT NULL,
  `ataka` int(11) DEFAULT '0',
  `bron` int(11)
DEFAULT '0',
  `toch` int(11) DEFAULT '0',
  `proch` int(11) DEFAULT '0',
 
`uids` int(11) DEFAULT NULL,
  `tank` int(11) DEFAULT '0',
  `saletank`
int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=10896 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks_shop`;

CREATE TABLE `tanks_shop` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `screen` varchar(255) NOT NULL,
  `name` varchar(255) NOT
NULL,
  `price` int(11) NOT NULL,
  `opt` int(11) NOT NULL,
  `sell_price`
int(11) NOT NULL,
  `ataka` int(11) DEFAULT NULL,
  `bron` int(11) DEFAULT
NULL,
  `proch` int(11) DEFAULT NULL,
  `toch` int(11) DEFAULT NULL,
 
`uid` int(11) DEFAULT NULL,
  `tank` int(11) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1310 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `tanks_spec`;

CREATE TABLE `tanks_spec` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `name` varchar(1024) NOT NULL,
  `zolota`
int(11) DEFAULT '0',
  `seropit` int(11) DEFAULT '0',
  `level` int(11)
DEFAULT NULL,
  `time` varchar(32) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=600 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `tanks_tournament`;

CREATE TABLE `tanks_tournament` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `screen` varchar(64) NOT NULL,
  `name`
varchar(64) DEFAULT NULL,
  `type` varchar(64) DEFAULT '0',
  `zolota`
int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `nachalo`
varchar(32) DEFAULT NULL,
  `konec` int(11) DEFAULT '0',
  `leveln` int(11)
DEFAULT NULL,
  `levelc` int(11) DEFAULT NULL,
  `time_k` varchar(32)
DEFAULT '0',
  `opis` varchar(2048) DEFAULT 'Нет описания',
 
`zolota_2` int(11) DEFAULT '0',
  `zolota_3` int(11) DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1129 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `tanks_tournament_users`;

CREATE
TABLE `tanks_tournament_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`user` int(11) NOT NULL,
  `tanks` varchar(64) DEFAULT NULL,
  `ataka`
varchar(64) DEFAULT NULL,
  `bron` int(11) DEFAULT NULL,
  `toch` int(11)
DEFAULT NULL,
  `proch` int(11) DEFAULT NULL,
  `fuel` int(11) DEFAULT
'500',
  `fuels` int(11) DEFAULT '500',
  `twofuel` int(11) DEFAULT NULL,
 
`tour` int(11) DEFAULT '0',
  `rand` int(11) DEFAULT '0',
  `win` int(11)
DEFAULT '0',
  `stat` int(11) DEFAULT '0',
  `vkl` int(11) DEFAULT '0',
 
`play` varchar(32) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=10428 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks_wartournament`;

CREATE TABLE `tanks_wartournament` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `konec` int(11) DEFAULT '0',
  `napad` int(11)
NOT NULL,
  `zakaz` int(11) NOT NULL,
  `win` int(11) NOT NULL,
  `napad_b`
int(11) DEFAULT '0',
  `zakaz_b` int(11) DEFAULT '0',
  `time` int(11)
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=214
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`tanks_wartournament_users`;

CREATE TABLE `tanks_wartournament_users` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `tanks`
varchar(64) DEFAULT NULL,
  `ataka` varchar(64) DEFAULT NULL,
  `bron`
int(11) DEFAULT NULL,
  `toch` int(11) DEFAULT NULL,
  `proch` int(11)
DEFAULT NULL,
  `fuel` int(11) DEFAULT '500',
  `fuels` int(11) DEFAULT
'500',
  `twofuel` int(11) DEFAULT NULL,
  `tour` int(11) DEFAULT '0',
 
`rand` int(11) DEFAULT '0',
  `win` int(11) DEFAULT '0',
  `stat` int(11)
DEFAULT '0',
  `vkl` int(11) DEFAULT '0',
  `play` varchar(32) DEFAULT
NULL,
  `clan` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=2115 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`unitpay_payments`;

CREATE TABLE `unitpay_payments` (
  `id` int(10) NOT
NULL AUTO_INCREMENT,
  `unitpayId` varchar(255) NOT NULL,
  `account`
varchar(255) NOT NULL,
  `sum` float NOT NULL,
  `itemsCount` int(11) NOT
NULL DEFAULT '1',
  `dateCreate` datetime NOT NULL,
  `dateComplete`
datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=427 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `nick` varchar(32) NOT NULL,
 
`pass` varchar(32) NOT NULL,
  `sess` varchar(32) DEFAULT NULL,
  `ip`
varchar(323) NOT NULL DEFAULT '0',
  `ip_cl` bigint(20) NOT NULL DEFAULT
'0',
  `ip_xff` bigint(20) NOT NULL DEFAULT '0',
  `ua` varchar(32) DEFAULT
NULL,
  `date_reg` int(11) NOT NULL DEFAULT '0',
  `date_aut` int(11) NOT
NULL DEFAULT '0',
  `date_last` int(11) NOT NULL DEFAULT '0',
  `pol`
enum('0','1') NOT NULL DEFAULT '1',
  `identity` varchar(100) DEFAULT
NULL,
  `type_reg` varchar(100) DEFAULT NULL,
  `ank_mail` varchar(32) NOT
NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nick` (`nick`)
) ENGINE=MyISAM
AUTO_INCREMENT=2598 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`xsolla_billing`;

CREATE TABLE `xsolla_billing` (
  `id` int(10) NOT NULL
AUTO_INCREMENT,
  `invoice` bigint(20) NOT NULL COMMENT 'Xsolla invoice
ID',
  `v1` varchar(100) NOT NULL,
  `v2` varchar(100) DEFAULT NULL,
  `v3`
varchar(100) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL COMMENT
'Amount of payment',
  `currency` varchar(3) DEFAULT NULL COMMENT 'Payment
currency',
  `date` timestamp NULL DEFAULT NULL COMMENT 'Date and time of
payment',
  `code` int(10) DEFAULT NULL COMMENT 'Response code',
 
`description` varchar(100) DEFAULT NULL COMMENT 'Response description',
 
`date_add` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `canceled`
enum('0','1') NOT NULL DEFAULT '0',
  `date_cancel` timestamp NULL DEFAULT
NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoice_UNIQUE` (`invoice`)
)
ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `zadan`;

CREATE TABLE `zadan` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `zadan` varchar(64)
DEFAULT NULL,
  `serebro` int(11) DEFAULT NULL,
  `zolota` int(11) DEFAULT
NULL,
  `nachalo` int(11) DEFAULT NULL,
  `vipolneno` int(11) DEFAULT
NULL,
  `reset` int(11) DEFAULT NULL,
  `opt` int(11) DEFAULT '0',
  `type`
int(11) DEFAULT '0',
  `ot` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=46853 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `zadans`;

CREATE TABLE `zadans` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `zadan` varchar(64) DEFAULT NULL,
  `serebro` int(11)
DEFAULT NULL,
  `zolota` int(11) DEFAULT NULL,
  `vipolneno` int(11)
DEFAULT NULL,
  `opt` int(11) DEFAULT '0',
  `type` int(11) DEFAULT '0',
 
`ot` int(11) DEFAULT '0',
  `allday` int(11) DEFAULT '0',
  `level` int(11)
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=861
DEFAULT CHARSET=utf8;