Quote:
[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 'security_token(32) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `n' at line 39
[Err] -- ----------------------------
-- Table structure for players
-- ----------------------------
CREATE TABLE `players` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`account_id` int(11) NOT NULL,
`account_name` varchar(50) NOT NULL,
`exp` bigint(20) NOT NULL default '0',
`recoverexp` bigint(20) NOT NULL default '0',
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`heading` int(11) NOT NULL,
`world_id` int(11) NOT NULL,
`world_owner` int(11) NOT NULL default '0',
`gender` enum('MALE','FEMALE') NOT NULL,
`race` enum('ASMODIANS','ELYOS') NOT NULL,
`player_class` enum('WARRIOR','GLADIATOR','TEMPLAR','SCOUT','ASSASSIN','RANGER','MAGE','SORCERER','SPIRIT_MASTER','PRIEST','CLERIC','CHANTER','ENGINEER','GUNNER','ARTIST','BARD','RIDER','ALL') NOT NULL,
`creation_date` timestamp NULL default NULL,
`deletion_date` timestamp NULL default NULL,
`last_online` timestamp NULL default NULL on update CURRENT_TIMESTAMP,
`quest_expands` tinyint(1) NOT NULL default '0',
`npc_expands` tinyint(1) NOT NULL default '0',
`advenced_stigma_slot_size` tinyint(1) NOT NULL default '0',
`warehouse_size` tinyint(1) NOT NULL default '0',
`mailbox_letters` tinyint(4) unsigned NOT NULL default '0',
`title_id` int(3) NOT NULL default '-1',
`bonus_title_id` int(3) NOT NULL default '-1',
`dp` int(3) NOT NULL default '0',
`soul_sickness` tinyint(1) unsigned NOT NULL default '0',
`reposte_energy` bigint(20) NOT NULL default '0',
`online` tinyint(1) NOT NULL default '0',
`note` text,
`mentor_flag_time` int(11) NOT NULL default '0',
`last_transfer_time` decimal(20,0) NOT NULL default '0',
`custom_points` int(11) NOT NULL default '0',
`security_token` security_token(32) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name_unique` (`name`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------