Hello there.
I was importing my SQL file from the Server Files to Navicat when this error appears.
I don't know what i have to do... i tried again and again but the tables doesn't create :/
I was importing my SQL file from the Server Files to Navicat when this error appears.
Code:
[Err] 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 'USING BTREE,
KEY `Alive` (`Alive`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMEN' at line 30
[Err] -- ----------------------------
-- Table structure for `character_data`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `Character_DATA` (
`CharacterID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`PlayerUID` varchar(20) NOT NULL DEFAULT '0',
`InstanceID` int(11) NOT NULL DEFAULT '0',
`Datestamp` datetime DEFAULT NULL,
`LastLogin` datetime NOT NULL,
`Inventory` longtext,
`Backpack` longtext,
`Worldspace` varchar(128) NOT NULL DEFAULT '[]',
`Medical` varchar(300) NOT NULL DEFAULT '[]',
`Alive` tinyint(3) unsigned NOT NULL DEFAULT '1',
`Generation` int(11) unsigned NOT NULL DEFAULT '1',
`LastAte` datetime NOT NULL,
`LastDrank` datetime NOT NULL,
`KillsZ` int(11) unsigned NOT NULL DEFAULT '0',
`HeadshotsZ` int(11) unsigned NOT NULL DEFAULT '0',
`DistanceFoot` int(11) NOT NULL DEFAULT '0',
`Duration` int(11) NOT NULL DEFAULT '0',
`CurrentState` varchar(200) NOT NULL DEFAULT '[]',
`KillsH` int(11) unsigned NOT NULL DEFAULT '0',
`Model` varchar(50) NOT NULL DEFAULT '"Survivor2_DZ"',
`KillsB` int(11) unsigned NOT NULL DEFAULT '0',
`Humanity` int(11) NOT NULL DEFAULT '2500',
`Infected` tinyint(3) DEFAULT '0',
PRIMARY KEY (`CharacterID`),
KEY `PlayerUID` (`PlayerUID`) USING BTREE,
KEY `Alive` (`Alive`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
I don't know what i have to do... i tried again and again but the tables doesn't create :/