Проблем

nik0laii

Registered
Здравейте,

Имам проблем с импортиране на БД ,ето я ..

Код:
CREATE TABLE `{{prefix}}_award` (  `ida` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `name` char(25) NOT NULL default '',  `img` char(30) NOT NULL,  `grade` tinyint(4) NOT NULL default '1',  PRIMARY KEY  (`ida`))
CREATE TABLE `{{prefix}}_bans` (  `ip` char(15) NOT NULL default '',  UNIQUE KEY `ip` (`ip`))
CREATE TABLE `{{prefix}}_clan` (  `idc` int(10) unsigned NOT NULL auto_increment,  `idsup` int(11) NOT NULL default '0',  `cname` varchar(30) NOT NULL default '',  `tag` varchar(15) default NULL,  `cwww` varchar(40) default NULL,  `date` int(15) default NULL,  `info` tinytext NOT NULL,  `activ` enum('Y','N') NOT NULL default 'Y',  `country` tinyint(4) NOT NULL default '52',  `channel` varchar(20) NOT NULL default '',  `extension` char(3) NOT NULL default '',  `iduser` int(11) NOT NULL default '0',  `clan_passw` char(20) NOT NULL,  PRIMARY KEY  (`idc`))
CREATE TABLE `{{prefix}}_clan_award` (  `idca` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idc` int(11) NOT NULL default '0',  `ida` int(11) NOT NULL default '0',  `ids` int(11) NOT NULL default '0',  PRIMARY KEY  (`idca`))
CREATE TABLE `{{prefix}}_comments` (  `idcomment` int(10) unsigned NOT NULL auto_increment,  `iduser` int(11) NOT NULL default '0',  `date` int(15) default NULL,  `comment` text NOT NULL,  `ip` varchar(15) NOT NULL default '',  `iditem` int(10) unsigned NOT NULL default '0',  `type` tinyint(3) unsigned NOT NULL default '0',  `edit` int(11) NOT NULL default '0',  PRIMARY KEY  (`idcomment`))
CREATE TABLE `{{prefix}}_config` (  `league` int(11) NOT NULL auto_increment,  `signup` enum('H','E','D') NOT NULL default 'H',  `signup_dlimit` int(11) NOT NULL default '0',  `signup_tlimit` tinyint(4) NOT NULL default '0',  `match_per_sgroup` tinyint(4) NOT NULL default '0',  `country` smallint(6) NOT NULL default '0',  `name` char(50) NOT NULL default '',  `irc_server` char(50) NOT NULL,  `max_players` tinyint(4) NOT NULL default '0',  `max_matches` tinyint(3) unsigned NOT NULL default '0',  `transfers` enum('Y','N') NOT NULL default 'Y',  `walkover` enum('S','M') NOT NULL default 'S',  `user_clans` enum('Y','N') NOT NULL default 'Y',  `block_ident` enum('Y','N') NOT NULL default 'Y',  `dispute_limit_before` smallint(6) NOT NULL,  `dispute_limit_after` smallint(6) NOT NULL,  `work_name` char(20) NOT NULL,  `visible` char(1) NOT NULL,  `default_lang` char(20) NOT NULL,  `main_id` int(11) NOT NULL,  `wars_id` int(11) NOT NULL,  `roster_id` int(11) NOT NULL,  `article_id` int(11) NOT NULL,  `address` char(80) NOT NULL,  `skin` char(50) NOT NULL,  `league_type` char(1) NOT NULL,  `score` char(1) NOT NULL,  `score_details` char(1) NOT NULL,  `player_type` char(1) NOT NULL,  `poll_live_time` smallint(1) NOT NULL,  `news_limit_show` smallint(6) NOT NULL,  `short_latest_news` smallint(6) NOT NULL,  `short_latest_matches` smallint(6) NOT NULL,  `user_news` char(1) NOT NULL,  `no_flags` char(1) NOT NULL,  `forum` char(20) NOT NULL,  `forum_prefix` char(20) NOT NULL,  `meta_keywords` char(150) NOT NULL,  PRIMARY KEY  (`league`))
CREATE TABLE `{{prefix}}_demo_sa` (  `idd` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idm` int(11) NOT NULL default '0',  `link` char(100) NOT NULL default '',  `map` char(30) NOT NULL default '',  `pov` char(15) NOT NULL default '', `time` int(11) NOT NULL default '0',  `extension` char(5) NOT NULL default '',  PRIMARY KEY  (`idd`))
CREATE TABLE `{{prefix}}_dround` (  `idgd` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(10) unsigned NOT NULL default '0',  `idg` int(10) unsigned NOT NULL default '0',  `rnd` tinyint(3) unsigned NOT NULL default '0',  `descr` char(30) NOT NULL default '',  PRIMARY KEY  (`idgd`))
CREATE TABLE `{{prefix}}_grants` (  `iduser` int(10) unsigned NOT NULL default '0',  `service` tinyint(3) unsigned NOT NULL default '0',  `wgrant` tinyint(4) NOT NULL default '0',  `descr` char(30) NOT NULL default '')
CREATE TABLE `{{prefix}}_group` (  `idg` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(10) unsigned NOT NULL default '0',  `gname` char(20) NOT NULL,  `gphase` tinyint(4) NOT NULL default '0',  PRIMARY KEY  (`idg`))
CREATE TABLE `{{prefix}}_in` (  `league` int(11) NOT NULL default '0',  `idc` int(11) NOT NULL default '0',  PRIMARY KEY  (`league`,`idc`))
CREATE TABLE `{{prefix}}_interview` (  `idi` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(11) NOT NULL default '0',  `author` int(11) NOT NULL default '0',  `date` int(15) default NULL,  `subject` varchar(50) NOT NULL default '',  `content` text NOT NULL,  `visible` CHAR( 1 ) NOT NULL DEFAULT 'Y',  PRIMARY KEY  (`idi`))
CREATE TABLE `{{prefix}}_maps` (  `idmp` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `sname` char(20) NOT NULL,  `fname` char(50) NOT NULL,  `screen` char(40) NOT NULL,  `screen_descr` char(200) NOT NULL,  PRIMARY KEY  (`idmp`))
CREATE TABLE `{{prefix}}_match` (  `idm` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(10) unsigned NOT NULL default '0',  `judge` int(10) unsigned NOT NULL default '0',  `date` int(15) NOT NULL default '0',  `date_from` int(11) NOT NULL,  `date_to` int(11) NOT NULL,  `roster` char(1) NOT NULL,  `idg` int(10) unsigned default NULL,  `pos` tinyint(3) default NULL,  `rnd` tinyint(3) unsigned default NULL,  `idc1` int(11) NOT NULL default '0',  `idc2` int(11) NOT NULL default '0',  `type` varchar(20) default NULL,  `idpt` smallint(5) unsigned NOT NULL default '0',  `points1` tinyint(3) NOT NULL default '0',  `points2` tinyint(3) NOT NULL default '0',  `frags1` smallint(5) NOT NULL default '0',  `frags2` smallint(5) NOT NULL default '0',  `win1` tinyint(3) unsigned NOT NULL default '0',  `draw` tinyint(3) unsigned NOT NULL default '0',  `win2` tinyint(3) unsigned NOT NULL default '0',  `descr` text NOT NULL,  `server` varchar(30) NOT NULL default '',  PRIMARY KEY  (`idm`))
CREATE TABLE `{{prefix}}_match_map` (  `idmm` int(11) NOT NULL auto_increment,  `idm` int(11) NOT NULL default '0',  `map` char(20) NOT NULL,  `frags1` smallint(6) NOT NULL default '0',  `frags2` smallint(6) NOT NULL default '0',  `wo` int(11) NOT NULL default '0',  `played` char(1) NOT NULL default '',  PRIMARY KEY  (`idmm`),  KEY `idm` (`idm`))
CREATE TABLE `{{prefix}}_match_score_details` (  `idmm` int(11) NOT NULL,  `period` char(1) NOT NULL,  `frags1` smallint(6) NOT NULL,  `frags2` smallint(6) NOT NULL)
CREATE TABLE `{{prefix}}_menu` (  `idml` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `visible` char(1) NOT NULL,  `privilages_global` smallint(6) NOT NULL,  `privilages_local` smallint(6) NOT NULL,  `head` char(30) NOT NULL,  `head_lang` char(30) NOT NULL,  `link` char(80) NOT NULL,  `target` char(15) NOT NULL,  `local` char(1) NOT NULL,  `column` smallint(6) NOT NULL,  `row` smallint(6) NOT NULL,  PRIMARY KEY  (`idml`))
CREATE TABLE `{{prefix}}_news` (  `idn` int(10) unsigned NOT NULL auto_increment,  `iduser` int(11) NOT NULL default '0',  `date` int(15) default NULL,  `title` varchar(30) NOT NULL default '',  `content` text NOT NULL,  `visible` char(1) NOT NULL default 'Y',  `service` tinyint(3) unsigned NOT NULL default '0',  `title_enc` varchar(30) NOT NULL default '',  `content_enc` text NOT NULL,  `encode` varchar(15) NOT NULL default '',  PRIMARY KEY  (`idn`))
CREATE TABLE `{{prefix}}_p_answers` (  `ida` int(10) unsigned NOT NULL auto_increment,  `idp` int(11) NOT NULL default '0',  `answer` char(50) NOT NULL default '',  PRIMARY KEY  (`ida`))
CREATE TABLE `{{prefix}}_p_choices` (  `id_user` int(11) NOT NULL default '0',  `ida` int(11) NOT NULL default '0')
CREATE TABLE `{{prefix}}_p_main` (  `idp` int(10) unsigned NOT NULL auto_increment,  `question` char(100) NOT NULL default '',  `up_time` int(11) default NULL,  `active` enum('Y','N') NOT NULL default 'Y',  `st_time` int(11) NOT NULL default '0',  `service` tinyint(3) unsigned NOT NULL default '0',  PRIMARY KEY  (`idp`))
CREATE TABLE `{{prefix}}_pen_stand` (  `idps` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `level` tinyint(4) unsigned NOT NULL default '0', `frags` smallint(6) NOT NULL default '0',  `points` tinyint(4) NOT NULL default '0',  PRIMARY KEY  (`idps`))
CREATE TABLE `{{prefix}}_penalty` (  `idy` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idt` int(11) NOT NULL default '0',  `frags` smallint(6) NOT NULL default '0',  `points` tinyint(4) NOT NULL default '0',  PRIMARY KEY  (`idy`))
CREATE TABLE `{{prefix}}_player` (  `idp` int(10) unsigned NOT NULL auto_increment,  `idc` int(11) NOT NULL default '0',  `iduser` int(11) NOT NULL default '0',  `approve_user` char(1) NOT NULL,  `invite_by` int(11) NOT NULL,  `pname` char(15) NOT NULL default '',  `contact` char(60) default NULL,  `ident` char(30) NOT NULL default '',  `function` char(1) NOT NULL,  `other` char(20) NOT NULL default '',  PRIMARY KEY  (`idp`))
CREATE TABLE `{{prefix}}_player_in` (  `idp` int(11) NOT NULL default '0',  `league` int(11) NOT NULL default '0',  PRIMARY KEY  (`idp`,`league`))
CREATE TABLE `{{prefix}}_player_in_clan` (  `iduser` int(11) NOT NULL,  `idc` int(11) NOT NULL,  PRIMARY KEY  (`iduser`,`idc`))
CREATE TABLE `{{prefix}}_players_stats` (  `idps` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(11) NOT NULL default '0',  `idp` int(11) NOT NULL default '0',  `idm` int(11) NOT NULL default '0',  `idmm` int(11) NOT NULL default '0',  `frags` int(11) NOT NULL default '0',  `deaths` int(11) NOT NULL default '0',  `mnumber` tinyint(3) unsigned NOT NULL default '0',  PRIMARY KEY  (`idps`))
CREATE TABLE `{{prefix}}_pm` (  `idpm` int(10) unsigned NOT NULL auto_increment,  `idauthor` int(11) NOT NULL default '0',  `iduser` int(11) NOT NULL default '0',  `date` int(15) NOT NULL default '0',  `title` varchar(20) NOT NULL default '',  `content` text NOT NULL,  `ip` varchar(15) NOT NULL default '',  `showed` enum('Y','N') NOT NULL default 'N',  PRIMARY KEY  (`idpm`))
CREATE TABLE `{{prefix}}_points` (  `idps` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `score1` smallint(6) NOT NULL,  `draw` smallint(6) NOT NULL,  `score2` smallint(6) NOT NULL,  `points1` smallint(6) NOT NULL,  `points2` smallint(6) NOT NULL,  PRIMARY KEY  (`idps`))
CREATE TABLE `{{prefix}}_ptable` (  `idpt` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(10) unsigned NOT NULL default '0',  `name` char(30) NOT NULL default '',  `teams` smallint(6) NOT NULL default '0', `ptype` char(1) NOT NULL default '',  `place` smallint(6) NOT NULL default '0',  PRIMARY KEY  (`idpt`))
CREATE TABLE `{{prefix}}_screen` (  `idn` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idm` int(10) unsigned NOT NULL default '0',  `idmm` int(11) NOT NULL default '0',  `map` char(10) default NULL,  `name` int(15) default NULL,  `hash` char(3) NOT NULL default '',  PRIMARY KEY  (`idn`))
CREATE TABLE `{{prefix}}_season` (  `ids` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `sname` char(20) NOT NULL default '',  `descr` char(50) NOT NULL default '',  PRIMARY KEY  (`ids`))
CREATE TABLE `{{prefix}}_servers` (  `idse` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `sname` char(50) NOT NULL, `address` char(50) NOT NULL,  PRIMARY KEY  (`idse`))
CREATE TABLE `{{prefix}}_signup` (  `ids` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `iduser` int(11) NOT NULL default '0',  `idc` int(11) NOT NULL default '0',  PRIMARY KEY  (`ids`))
CREATE TABLE `{{prefix}}_special_table` (  `idst` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `ids` int(11) NOT NULL,  `idc` int(11) NOT NULL,  `date` int(11) NOT NULL,  `points` float NOT NULL,  `description` char(50) NOT NULL,  PRIMARY KEY  (`idst`))
CREATE TABLE `{{prefix}}_table` (  `idt` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idc` int(10) unsigned NOT NULL default '0',  `idg` int(10) unsigned NOT NULL default '0',  `points` smallint(6) NOT NULL default '0',  `frags` smallint(5) NOT NULL default '0',  `deaths` smallint(5) NOT NULL default '0',  `wins` tinyint(3) unsigned NOT NULL default '0',  `draw` tinyint(4) NOT NULL default '0',  `lost` tinyint(3) unsigned NOT NULL default '0',  `map_win` tinyint(3) unsigned NOT NULL default '0',  `map_draw` tinyint(3) unsigned NOT NULL default '0',  `map_lost` tinyint(3) unsigned NOT NULL default '0',  PRIMARY KEY  (`idt`))
CREATE TABLE `{{prefix}}_users` (  `iduser` int(11) NOT NULL auto_increment,  `login` varchar(15) NOT NULL default '',  `pass` varchar(32) NOT NULL default '',  `mail` varchar(60) NOT NULL default '',  `grants` tinyint(4) NOT NULL default '0',  `added` int(15) default NULL,  `lastlog` int(15) default NULL,  `name` varchar(50) default NULL,  `birth` varchar(8) default NULL,  `clan` varchar(20) default NULL,  `clan_www` varchar(40) default NULL,  `home_www` varchar(40) default NULL,  `city` varchar(40) default NULL,  `avatar` char(1) default NULL,  `info` tinytext NOT NULL, `show_mail` enum('N','Y','R') NOT NULL default 'N',  `country` tinyint(4) NOT NULL default '52',  `comtype1` varchar(10) NOT NULL default '',  `comm1` varchar(30) NOT NULL default '',  `comtype2` varchar(10) NOT NULL default '',  `comm2` varchar(30) NOT NULL default '',  `timezone` smallint(6) NOT NULL default '0',  `send_pm_mail` char(1) NOT NULL, `ip` char(15) NOT NULL,  PRIMARY KEY  (`iduser`),  UNIQUE KEY `login` (`login`)) AUTO_INCREMENT=5 
CREATE TABLE `{{prefix}}_users_auth` (  `login` varchar(15) NOT NULL default '',  `pass` varchar(32) NOT NULL default '',  `mail` varchar(30) NOT NULL default '',  `added` int(15) default NULL,  `auth` varchar(32) NOT NULL default '', `ip` char(15) NOT NULL,  UNIQUE KEY `auth` (`auth`),  UNIQUE KEY `login` (`login`))
CREATE TABLE `{{prefix}}_users_pass` (  `iduser` int(11) NOT NULL default '0',  `pass` varchar(32) NOT NULL default '',  `added` int(15) default NULL,  `auth` varchar(32) NOT NULL default '', `ip` char(15) NOT NULL,  UNIQUE KEY `iduser` (`iduser`),  UNIQUE KEY `auth` (`auth`))
CREATE TABLE `{{prefix}}_votes` (  `idcomment` int(11) NOT NULL default '0',  `iditem` int(11) NOT NULL default '0',  `type` tinyint(4) NOT NULL default '0',  `iduser` int(11) NOT NULL default '0',  `vote` tinyint(2) NOT NULL default '0',  KEY `idcomment` (`idcomment`),  KEY `iddemo` (`iditem`),  KEY `iduser` (`iduser`))
CREATE TABLE `{{prefix}}_watchers` (  `time` int(15) NOT NULL default '0',  `ip` char(15) NOT NULL default '',  `iduser` int(11) default NULL,  `service` tinyint(3) unsigned NOT NULL default '0')
CREATE TABLE `{{prefix}}_wildcard` (  `idw` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(11) NOT NULL default '0',  `idc` int(11) NOT NULL default '0',  PRIMARY KEY  (`idw`))


При импортиране дава грешка...пробвайте.
Моля ви помогнете,спешно ми трябва :idea:
 
Ето:
Код:
CREATE TABLE `{{prefix}}_award` (  `ida` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `name` char(25) NOT NULL default '',  `img` char(30) NOT NULL,  `grade` tinyint(4) NOT NULL default '1',  PRIMARY KEY  (`ida`));
CREATE TABLE `{{prefix}}_bans` (  `ip` char(15) NOT NULL default '',  UNIQUE KEY `ip` (`ip`));
CREATE TABLE `{{prefix}}_clan` (  `idc` int(10) unsigned NOT NULL auto_increment,  `idsup` int(11) NOT NULL default '0',  `cname` varchar(30) NOT NULL default '',  `tag` varchar(15) default NULL,  `cwww` varchar(40) default NULL,  `date` int(15) default NULL,  `info` tinytext NOT NULL,  `activ` enum('Y','N') NOT NULL default 'Y',  `country` tinyint(4) NOT NULL default '52',  `channel` varchar(20) NOT NULL default '',  `extension` char(3) NOT NULL default '',  `iduser` int(11) NOT NULL default '0',  `clan_passw` char(20) NOT NULL,  PRIMARY KEY  (`idc`));
CREATE TABLE `{{prefix}}_clan_award` (  `idca` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idc` int(11) NOT NULL default '0',  `ida` int(11) NOT NULL default '0',  `ids` int(11) NOT NULL default '0',  PRIMARY KEY  (`idca`));
CREATE TABLE `{{prefix}}_comments` (  `idcomment` int(10) unsigned NOT NULL auto_increment,  `iduser` int(11) NOT NULL default '0',  `date` int(15) default NULL,  `comment` text NOT NULL,  `ip` varchar(15) NOT NULL default '',  `iditem` int(10) unsigned NOT NULL default '0',  `type` tinyint(3) unsigned NOT NULL default '0',  `edit` int(11) NOT NULL default '0',  PRIMARY KEY  (`idcomment`));
CREATE TABLE `{{prefix}}_config` (  `league` int(11) NOT NULL auto_increment,  `signup` enum('H','E','D') NOT NULL default 'H',  `signup_dlimit` int(11) NOT NULL default '0',  `signup_tlimit` tinyint(4) NOT NULL default '0',  `match_per_sgroup` tinyint(4) NOT NULL default '0',  `country` smallint(6) NOT NULL default '0',  `name` char(50) NOT NULL default '',  `irc_server` char(50) NOT NULL,  `max_players` tinyint(4) NOT NULL default '0',  `max_matches` tinyint(3) unsigned NOT NULL default '0',  `transfers` enum('Y','N') NOT NULL default 'Y',  `walkover` enum('S','M') NOT NULL default 'S',  `user_clans` enum('Y','N') NOT NULL default 'Y',  `block_ident` enum('Y','N') NOT NULL default 'Y',  `dispute_limit_before` smallint(6) NOT NULL,  `dispute_limit_after` smallint(6) NOT NULL,  `work_name` char(20) NOT NULL,  `visible` char(1) NOT NULL,  `default_lang` char(20) NOT NULL,  `main_id` int(11) NOT NULL,  `wars_id` int(11) NOT NULL,  `roster_id` int(11) NOT NULL,  `article_id` int(11) NOT NULL,  `address` char(80) NOT NULL,  `skin` char(50) NOT NULL,  `league_type` char(1) NOT NULL,  `score` char(1) NOT NULL,  `score_details` char(1) NOT NULL,  `player_type` char(1) NOT NULL,  `poll_live_time` smallint(1) NOT NULL,  `news_limit_show` smallint(6) NOT NULL,  `short_latest_news` smallint(6) NOT NULL,  `short_latest_matches` smallint(6) NOT NULL,  `user_news` char(1) NOT NULL,  `no_flags` char(1) NOT NULL,  `forum` char(20) NOT NULL,  `forum_prefix` char(20) NOT NULL,  `meta_keywords` char(150) NOT NULL,  PRIMARY KEY  (`league`));
CREATE TABLE `{{prefix}}_demo_sa` (  `idd` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idm` int(11) NOT NULL default '0',  `link` char(100) NOT NULL default '',  `map` char(30) NOT NULL default '',  `pov` char(15) NOT NULL default '', `time` int(11) NOT NULL default '0',  `extension` char(5) NOT NULL default '',  PRIMARY KEY  (`idd`));
CREATE TABLE `{{prefix}}_dround` (  `idgd` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(10) unsigned NOT NULL default '0',  `idg` int(10) unsigned NOT NULL default '0',  `rnd` tinyint(3) unsigned NOT NULL default '0',  `descr` char(30) NOT NULL default '',  PRIMARY KEY  (`idgd`));
CREATE TABLE `{{prefix}}_grants` (  `iduser` int(10) unsigned NOT NULL default '0',  `service` tinyint(3) unsigned NOT NULL default '0',  `wgrant` tinyint(4) NOT NULL default '0',  `descr` char(30) NOT NULL default '');
CREATE TABLE `{{prefix}}_group` (  `idg` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(10) unsigned NOT NULL default '0',  `gname` char(20) NOT NULL,  `gphase` tinyint(4) NOT NULL default '0',  PRIMARY KEY  (`idg`));
CREATE TABLE `{{prefix}}_in` (  `league` int(11) NOT NULL default '0',  `idc` int(11) NOT NULL default '0',  PRIMARY KEY  (`league`,`idc`));
CREATE TABLE `{{prefix}}_interview` (  `idi` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(11) NOT NULL default '0',  `author` int(11) NOT NULL default '0',  `date` int(15) default NULL,  `subject` varchar(50) NOT NULL default '',  `content` text NOT NULL,  `visible` CHAR( 1 ) NOT NULL DEFAULT 'Y',  PRIMARY KEY  (`idi`));
CREATE TABLE `{{prefix}}_maps` (  `idmp` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `sname` char(20) NOT NULL,  `fname` char(50) NOT NULL,  `screen` char(40) NOT NULL,  `screen_descr` char(200) NOT NULL,  PRIMARY KEY  (`idmp`));
CREATE TABLE `{{prefix}}_match` (  `idm` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(10) unsigned NOT NULL default '0',  `judge` int(10) unsigned NOT NULL default '0',  `date` int(15) NOT NULL default '0',  `date_from` int(11) NOT NULL,  `date_to` int(11) NOT NULL,  `roster` char(1) NOT NULL,  `idg` int(10) unsigned default NULL,  `pos` tinyint(3) default NULL,  `rnd` tinyint(3) unsigned default NULL,  `idc1` int(11) NOT NULL default '0',  `idc2` int(11) NOT NULL default '0',  `type` varchar(20) default NULL,  `idpt` smallint(5) unsigned NOT NULL default '0',  `points1` tinyint(3) NOT NULL default '0',  `points2` tinyint(3) NOT NULL default '0',  `frags1` smallint(5) NOT NULL default '0',  `frags2` smallint(5) NOT NULL default '0',  `win1` tinyint(3) unsigned NOT NULL default '0',  `draw` tinyint(3) unsigned NOT NULL default '0',  `win2` tinyint(3) unsigned NOT NULL default '0',  `descr` text NOT NULL,  `server` varchar(30) NOT NULL default '',  PRIMARY KEY  (`idm`));
CREATE TABLE `{{prefix}}_match_map` (  `idmm` int(11) NOT NULL auto_increment,  `idm` int(11) NOT NULL default '0',  `map` char(20) NOT NULL,  `frags1` smallint(6) NOT NULL default '0',  `frags2` smallint(6) NOT NULL default '0',  `wo` int(11) NOT NULL default '0',  `played` char(1) NOT NULL default '',  PRIMARY KEY  (`idmm`),  KEY `idm` (`idm`));
CREATE TABLE `{{prefix}}_match_score_details` (  `idmm` int(11) NOT NULL,  `period` char(1) NOT NULL,  `frags1` smallint(6) NOT NULL,  `frags2` smallint(6) NOT NULL);
CREATE TABLE `{{prefix}}_menu` (  `idml` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `visible` char(1) NOT NULL,  `privilages_global` smallint(6) NOT NULL,  `privilages_local` smallint(6) NOT NULL,  `head` char(30) NOT NULL,  `head_lang` char(30) NOT NULL,  `link` char(80) NOT NULL,  `target` char(15) NOT NULL,  `local` char(1) NOT NULL,  `column` smallint(6) NOT NULL,  `row` smallint(6) NOT NULL,  PRIMARY KEY  (`idml`));
CREATE TABLE `{{prefix}}_news` (  `idn` int(10) unsigned NOT NULL auto_increment,  `iduser` int(11) NOT NULL default '0',  `date` int(15) default NULL,  `title` varchar(30) NOT NULL default '',  `content` text NOT NULL,  `visible` char(1) NOT NULL default 'Y',  `service` tinyint(3) unsigned NOT NULL default '0',  `title_enc` varchar(30) NOT NULL default '',  `content_enc` text NOT NULL,  `encode` varchar(15) NOT NULL default '',  PRIMARY KEY  (`idn`));
CREATE TABLE `{{prefix}}_p_answers` (  `ida` int(10) unsigned NOT NULL auto_increment,  `idp` int(11) NOT NULL default '0',  `answer` char(50) NOT NULL default '',  PRIMARY KEY  (`ida`));
CREATE TABLE `{{prefix}}_p_choices` (  `id_user` int(11) NOT NULL default '0',  `ida` int(11) NOT NULL default '0');
CREATE TABLE `{{prefix}}_p_main` (  `idp` int(10) unsigned NOT NULL auto_increment,  `question` char(100) NOT NULL default '',  `up_time` int(11) default NULL,  `active` enum('Y','N') NOT NULL default 'Y',  `st_time` int(11) NOT NULL default '0',  `service` tinyint(3) unsigned NOT NULL default '0',  PRIMARY KEY  (`idp`));
CREATE TABLE `{{prefix}}_pen_stand` (  `idps` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `level` tinyint(4) unsigned NOT NULL default '0', `frags` smallint(6) NOT NULL default '0',  `points` tinyint(4) NOT NULL default '0',  PRIMARY KEY  (`idps`));
CREATE TABLE `{{prefix}}_penalty` (  `idy` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idt` int(11) NOT NULL default '0',  `frags` smallint(6) NOT NULL default '0',  `points` tinyint(4) NOT NULL default '0',  PRIMARY KEY  (`idy`));
CREATE TABLE `{{prefix}}_player` (  `idp` int(10) unsigned NOT NULL auto_increment,  `idc` int(11) NOT NULL default '0',  `iduser` int(11) NOT NULL default '0',  `approve_user` char(1) NOT NULL,  `invite_by` int(11) NOT NULL,  `pname` char(15) NOT NULL default '',  `contact` char(60) default NULL,  `ident` char(30) NOT NULL default '',  `function` char(1) NOT NULL,  `other` char(20) NOT NULL default '',  PRIMARY KEY  (`idp`));
CREATE TABLE `{{prefix}}_player_in` (  `idp` int(11) NOT NULL default '0',  `league` int(11) NOT NULL default '0',  PRIMARY KEY  (`idp`,`league`));
CREATE TABLE `{{prefix}}_player_in_clan` (  `iduser` int(11) NOT NULL,  `idc` int(11) NOT NULL,  PRIMARY KEY  (`iduser`,`idc`));
CREATE TABLE `{{prefix}}_players_stats` (  `idps` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(11) NOT NULL default '0',  `idp` int(11) NOT NULL default '0',  `idm` int(11) NOT NULL default '0',  `idmm` int(11) NOT NULL default '0',  `frags` int(11) NOT NULL default '0',  `deaths` int(11) NOT NULL default '0',  `mnumber` tinyint(3) unsigned NOT NULL default '0',  PRIMARY KEY  (`idps`));
CREATE TABLE `{{prefix}}_pm` (  `idpm` int(10) unsigned NOT NULL auto_increment,  `idauthor` int(11) NOT NULL default '0',  `iduser` int(11) NOT NULL default '0',  `date` int(15) NOT NULL default '0',  `title` varchar(20) NOT NULL default '',  `content` text NOT NULL,  `ip` varchar(15) NOT NULL default '',  `showed` enum('Y','N') NOT NULL default 'N',  PRIMARY KEY  (`idpm`));
CREATE TABLE `{{prefix}}_points` (  `idps` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `score1` smallint(6) NOT NULL,  `draw` smallint(6) NOT NULL,  `score2` smallint(6) NOT NULL,  `points1` smallint(6) NOT NULL,  `points2` smallint(6) NOT NULL,  PRIMARY KEY  (`idps`));
CREATE TABLE `{{prefix}}_ptable` (  `idpt` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(10) unsigned NOT NULL default '0',  `name` char(30) NOT NULL default '',  `teams` smallint(6) NOT NULL default '0', `ptype` char(1) NOT NULL default '',  `place` smallint(6) NOT NULL default '0',  PRIMARY KEY  (`idpt`));
CREATE TABLE `{{prefix}}_screen` (  `idn` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idm` int(10) unsigned NOT NULL default '0',  `idmm` int(11) NOT NULL default '0',  `map` char(10) default NULL,  `name` int(15) default NULL,  `hash` char(3) NOT NULL default '',  PRIMARY KEY  (`idn`));
CREATE TABLE `{{prefix}}_season` (  `ids` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `sname` char(20) NOT NULL default '',  `descr` char(50) NOT NULL default '',  PRIMARY KEY  (`ids`));
CREATE TABLE `{{prefix}}_servers` (  `idse` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `sname` char(50) NOT NULL, `address` char(50) NOT NULL,  PRIMARY KEY  (`idse`));
CREATE TABLE `{{prefix}}_signup` (  `ids` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `iduser` int(11) NOT NULL default '0',  `idc` int(11) NOT NULL default '0',  PRIMARY KEY  (`ids`));
CREATE TABLE `{{prefix}}_special_table` (  `idst` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL,  `ids` int(11) NOT NULL,  `idc` int(11) NOT NULL,  `date` int(11) NOT NULL,  `points` float NOT NULL,  `description` char(50) NOT NULL,  PRIMARY KEY  (`idst`));
CREATE TABLE `{{prefix}}_table` (  `idt` int(10) unsigned NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `idc` int(10) unsigned NOT NULL default '0',  `idg` int(10) unsigned NOT NULL default '0',  `points` smallint(6) NOT NULL default '0',  `frags` smallint(5) NOT NULL default '0',  `deaths` smallint(5) NOT NULL default '0',  `wins` tinyint(3) unsigned NOT NULL default '0',  `draw` tinyint(4) NOT NULL default '0',  `lost` tinyint(3) unsigned NOT NULL default '0',  `map_win` tinyint(3) unsigned NOT NULL default '0',  `map_draw` tinyint(3) unsigned NOT NULL default '0',  `map_lost` tinyint(3) unsigned NOT NULL default '0',  PRIMARY KEY  (`idt`));
CREATE TABLE `{{prefix}}_users` (  `iduser` int(11) NOT NULL auto_increment,  `login` varchar(15) NOT NULL default '',  `pass` varchar(32) NOT NULL default '',  `mail` varchar(60) NOT NULL default '',  `grants` tinyint(4) NOT NULL default '0',  `added` int(15) default NULL,  `lastlog` int(15) default NULL,  `name` varchar(50) default NULL,  `birth` varchar(8) default NULL,  `clan` varchar(20) default NULL,  `clan_www` varchar(40) default NULL,  `home_www` varchar(40) default NULL,  `city` varchar(40) default NULL,  `avatar` char(1) default NULL,  `info` tinytext NOT NULL, `show_mail` enum('N','Y','R') NOT NULL default 'N',  `country` tinyint(4) NOT NULL default '52',  `comtype1` varchar(10) NOT NULL default '',  `comm1` varchar(30) NOT NULL default '',  `comtype2` varchar(10) NOT NULL default '',  `comm2` varchar(30) NOT NULL default '',  `timezone` smallint(6) NOT NULL default '0',  `send_pm_mail` char(1) NOT NULL, `ip` char(15) NOT NULL,  PRIMARY KEY  (`iduser`),  UNIQUE KEY `login` (`login`)) AUTO_INCREMENT=5;
CREATE TABLE `{{prefix}}_users_auth` (  `login` varchar(15) NOT NULL default '',  `pass` varchar(32) NOT NULL default '',  `mail` varchar(30) NOT NULL default '',  `added` int(15) default NULL,  `auth` varchar(32) NOT NULL default '', `ip` char(15) NOT NULL,  UNIQUE KEY `auth` (`auth`),  UNIQUE KEY `login` (`login`));
CREATE TABLE `{{prefix}}_users_pass` (  `iduser` int(11) NOT NULL default '0',  `pass` varchar(32) NOT NULL default '',  `added` int(15) default NULL,  `auth` varchar(32) NOT NULL default '', `ip` char(15) NOT NULL,  UNIQUE KEY `iduser` (`iduser`),  UNIQUE KEY `auth` (`auth`));
CREATE TABLE `{{prefix}}_votes` (  `idcomment` int(11) NOT NULL default '0',  `iditem` int(11) NOT NULL default '0',  `type` tinyint(4) NOT NULL default '0',  `iduser` int(11) NOT NULL default '0',  `vote` tinyint(2) NOT NULL default '0',  KEY `idcomment` (`idcomment`),  KEY `iddemo` (`iditem`),  KEY `iduser` (`iduser`));
CREATE TABLE `{{prefix}}_watchers` (  `time` int(15) NOT NULL default '0',  `ip` char(15) NOT NULL default '',  `iduser` int(11) default NULL,  `service` tinyint(3) unsigned NOT NULL default '0');
CREATE TABLE `{{prefix}}_wildcard` (  `idw` int(11) NOT NULL auto_increment,  `league` int(11) NOT NULL default '0',  `ids` int(11) NOT NULL default '0',  `idc` int(11) NOT NULL default '0',  PRIMARY KEY  (`idw`));
 

Back
Горе