Logo MurCode
MySQL Новое сообщение

присоединение базы к sql на Денвере

fazzini
Дата: 12.02.2013 03:41:15
У меня есть база в файле .SQL стоит Денвер при попытке сделать импорт в созданную базу тут же выходит ошибка

автор
Ошибка

SQL-запрос:

# -------------------------------------------------------- # # `AtackLog` # CREATE TABLE `AtackLog` ( `ID` int(11) NOT NULL auto_increment, `userID` int(11) NOT NULL default '0', `toUserID` int(11) NOT NULL default '0', `atackTurns` int(11) NOT NULL default '0', `atackStrength` int(11) NOT NULL default '0', `defStrength` int(11) NOT NULL default '0', `gold` int(11) NOT NULL default '0', `phrase` varchar(255) NOT NULL default '', `atackUsersKilled` int(11) NOT NULL default '0', `defUsersKilled` int(11) NOT NULL default '0', `atackTrained` int(11) NOT NULL default '0', `atackUnTrained` int(11) NOT NULL default '0', `defTrained` int(11) NOT NULL default '0', `defUnTrained` int(11) NOT NULL default '0', `atackWeapons` varchar(255) NOT NULL default '', `defWeapons` varchar(255) NOT NULL default '', `atackWeaponWas` varchar(255) NOT NULL default '', `atackWeaponIs` varchar(255) NOT NULL default '', `time` int(11) NOT NULL defau[...]

Ответ MySQL: Документация
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=63' at line 32


помогите пожалуйста вот код базы
автор
# --------------------------------------------------------

#
# `AtackLog`
#

CREATE TABLE `AtackLog` (
`ID` int(11) NOT NULL auto_increment,
`userID` int(11) NOT NULL default '0',
`toUserID` int(11) NOT NULL default '0',
`atackTurns` int(11) NOT NULL default '0',
`atackStrength` int(11) NOT NULL default '0',
`defStrength` int(11) NOT NULL default '0',
`gold` int(11) NOT NULL default '0',
`phrase` varchar(255) NOT NULL default '',
`atackUsersKilled` int(11) NOT NULL default '0',
`defUsersKilled` int(11) NOT NULL default '0',
`atackTrained` int(11) NOT NULL default '0',
`atackUnTrained` int(11) NOT NULL default '0',
`defTrained` int(11) NOT NULL default '0',
`defUnTrained` int(11) NOT NULL default '0',
`atackWeapons` varchar(255) NOT NULL default '',
`defWeapons` varchar(255) NOT NULL default '',
`atackWeaponWas` varchar(255) NOT NULL default '',
`atackWeaponIs` varchar(255) NOT NULL default '',
`time` int(11) NOT NULL default '0',
`atackWeaponCount` varchar(255) NOT NULL default '',
`defWeaponWas` varchar(255) NOT NULL default '',
`defWeaponIs` varchar(255) NOT NULL default '',
`defWeaponCount` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=63;

#
# `AtackLog`
#


# --------------------------------------------------------

#
# `IPs`
#

CREATE TABLE `IPs` (
`ID` int(11) NOT NULL auto_increment,
`ip` varchar(15) NOT NULL default '',
`userID` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

#
# `IPs`
#



# --------------------------------------------------------

#
# `Mercenaries`
#

CREATE TABLE `Mercenaries` (
`attackSpecCount` int(11) NOT NULL default '0',
`defSpecCount` int(11) NOT NULL default '0',
`untrainedCount` int(11) NOT NULL default '0',
`lastTurnTime` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# `Mercenaries`
#

INSERT INTO `Mercenaries` (`attackSpecCount`, `defSpecCount`, `untrainedCount`, `lastTurnTime`) VALUES (215, 215, 215, 1083963719);

# --------------------------------------------------------

#
# `Messages`
#

CREATE TABLE `Messages` (
`ID` int(11) NOT NULL auto_increment,
`userID` int(11) NOT NULL default '0',
`fromID` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`text` text NOT NULL,
`date` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

#
# `Messages`
#


# --------------------------------------------------------

#
# `Ranks`
#

CREATE TABLE `Ranks` (
`ID` int(11) NOT NULL auto_increment,
`userID` int(11) NOT NULL default '0',
`rank` int(11) NOT NULL default '0',
`strikeActionRank` int(11) NOT NULL default '0',
`defenceActionRank` int(11) NOT NULL default '0',
`covertActionRank` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;

#
# `Ranks`
#

INSERT INTO `Ranks` (`ID`, `userID`, `rank`, `strikeActionRank`, `defenceActionRank`, `covertActionRank`) VALUES (11, 20, 3, 4, 3, 2),
(35, 44, 0, 0, 0, 0),
(15, 24, 0, 0, 0, 0),
(16, 25, 0, 0, 0, 0),
(18, 27, 5, 5, 5, 1),
(17, 26, 2, 2, 2, 4),
(19, 28, 4, 3, 4, 3),
(37, 46, 6, 6, 6, 6),
(34, 43, 0, 0, 0, 0),
(33, 42, 0, 0, 0, 0),
(32, 41, 0, 0, 0, 0);

# --------------------------------------------------------

#
# `SpyLog`
#

CREATE TABLE `SpyLog` (
`ID` int(11) NOT NULL auto_increment,
`userID` int(11) NOT NULL default '0',
`toUserID` int(11) NOT NULL default '0',
`spyStrength` int(11) NOT NULL default '0',
`spyDefStrength` int(11) NOT NULL default '0',
`trainedAttackSold` varchar(15) NOT NULL default '',
`trainedAttackMerc` varchar(15) NOT NULL default '',
`trainedDefSold` varchar(15) NOT NULL default '',
`trainedDefMerc` varchar(15) NOT NULL default '',
`untrainedMerc` varchar(15) NOT NULL default '',
`untrainedSold` varchar(15) NOT NULL default '',
`strikeAction` varchar(15) NOT NULL default '',
`defenceAction` varchar(15) NOT NULL default '',
`covertSkill` varchar(15) NOT NULL default '',
`covertOperatives` varchar(15) NOT NULL default '',
`siegeLevel` varchar(15) NOT NULL default '',
`atackTurns` varchar(15) NOT NULL default '',
`unitProduction` varchar(15) NOT NULL default '',
`weapons` varchar(255) NOT NULL default '',
`types` varchar(255) NOT NULL default '',
`types2` varchar(255) NOT NULL default '',
`quantities` varchar(255) NOT NULL default '',
`strengths` varchar(255) NOT NULL default '',
`allStrengths` varchar(255) NOT NULL default '',
`time` int(11) NOT NULL default '0',
`spies` int(11) NOT NULL default '0',
`isSuccess` tinyint(1) NOT NULL default '0',
`race` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;

#
# `SpyLog`
#


# --------------------------------------------------------

#
# `UserDetails`
#

CREATE TABLE `UserDetails` (
`ID` int(11) NOT NULL auto_increment,
`userName` varchar(100) NOT NULL default '',
`race` tinyint(4) NOT NULL default '0',
`e_mail` varchar(255) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`commander` int(11) NOT NULL default '0',
`active` int(1) NOT NULL default '0',
`uniqueLink` varchar(12) NOT NULL default '',
`fortificationLevel` int(11) NOT NULL default '0',
`siegeLevel` int(11) NOT NULL default '0',
`gold` int(11) NOT NULL default '0',
`attackTurns` int(11) NOT NULL default '0',
`currentUnitProduction` int(11) default NULL,
`currentSpySkill` int(11) default NULL,
`trainedAttackSold` int(11) default NULL,
`trainedAttackMerc` int(11) default NULL,
`trainedDefSold` int(11) default NULL,
`trainedDefMerc` int(11) default NULL,
`untrainedSold` float default NULL,
`untrainedMerc` int(11) default NULL,
`spies` int(11) default NULL,
`lastTurnTime` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;

#
# `UserDetails`
#

INSERT INTO `UserDetails` (`ID`, `userName`, `race`, `e_mail`, `password`, `commander`, `active`, `uniqueLink`, `fortificationLevel`, `siegeLevel`, `gold`, `attackTurns`, `currentUnitProduction`, `currentSpySkill`, `trainedAttackSold`, `trainedAttackMerc`, `trainedDefSold`, `trainedDefMerc`, `untrainedSold`, `untrainedMerc`, `spies`, `lastTurnTime`) VALUES (27, 'user13', 2, 'user13@email.ru', '1', 0, 1, 'uk4610829096', 1, 1, 2053218, 180, 24, 38, 21, 864, 490, 1831, '1580', 1049, 237, 1083987525),
(28, 'user5', 3, 'test@test123.com', 'user5', 0, 1, 'uu3310829096', 3, 3, 1, 1, 80, 25, 1, 1, 1, 1, '1', 1, 223, 1083987973),
(44, 'xvxczcxddaa', 0, 'test@1234.com', 'xvxczcxddaa', 0, 0, 'sl1083711607', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711607),
(20, 'user6', 1, 'test@1235.ru', 'user6', 0, 1, 'user6', 1, 0, 7171076, 221, 55, 28, 1582, 1716, 719, 1084, '4264', 1365, 1237, 1089727410),
(46, 'jason', 0, 'test@1236.com', 'jason', 0, 1, 'ep1083764260', 0, 0, 3699, 46, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083764636),
(26, 'user12', 1, 'test@1237.com', 'user12', 0, 1, 'user12', 3, 1, 9071948, 210, 91, 18, 1770, 912, 1850, 1959, '5651', 459, 808, 1090281246),
(25, 'user11', 1, 'test@1238.com', 'user11', 0, 0, 'user11', 2, 2, 83874, 98, 13, 0, 1670, 654, 1047, 979, '1273', 527, 207, 1083611939),
(24, 'user10', 2, 'test@1239.com', 'user10', 0, 0, 'user10', 2, 2, 132483, 75, 92, 79, 1146, 1197, 1, 1881, '1998', 1881, 772, 1084659030),
(43, 'xvxczcxdd', 0, 'test@1230.com', 'xvxczcxdd', 0, 0, 'ez1083711525', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711525),
(42, 'xvxczcx', 0, 'test@1244.com', 'xvxczcx', 0, 0, 'rg1083711472', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711472),
(41, 'sfdsfsfd', 2, 'test@1255.com', 'sfdsfsfd', 0, 0, 'ql1083711236', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711236),
(45, 'tsunami', 0, 'test@1256.com', 'tsunami', 0, 0, 'pi1083764140', 0, 0, 806, 43, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083765813),
(48, 'admin', 0, 'admin@yoursite.com', 'admin', 0, 4, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

# --------------------------------------------------------

#
# `Weapon`
#

CREATE TABLE `Weapon` (
`ID` int(11) NOT NULL auto_increment,
`weaponID` int(11) NOT NULL default '0',
`weaponStrength` int(11) NOT NULL default '0',
`weaponCount` int(11) NOT NULL default '0',
`isAtack` int(11) NOT NULL default '0',
`userID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=25 ;

#
# `Weapon`
#

INSERT INTO `Weapon` (`ID`, `weaponID`, `weaponStrength`, `weaponCount`, `isAtack`, `userID`) VALUES (24, 0, 10, 1, 0, 45),
(23, 0, 5, 1, 1, 45);

# --------------------------------------------------------
javajdbc
Дата: 12.02.2013 07:19:48
fazzini,

попробуйте заменить ТУРЕ на

ENGINE = MYISAM
fazzini
Дата: 12.02.2013 09:05:06
javajdbc
fazzini,

попробуйте заменить ТУРЕ на

ENGINE = MYISAM


Спасибо помогло!