Здравейте,
Имам проблем с импортиране на БД ,ето я ..
При импортиране дава грешка...пробвайте.
Моля ви помогнете,спешно ми трябва :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`))
При импортиране дава грешка...пробвайте.
Моля ви помогнете,спешно ми трябва :idea: