· 7 years ago · Dec 04, 2018, 10:26 AM
1rev. 1825 error in mob_spawn_points upon executing sql manually
2
3
4
5[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 'CREATE TABLE IF NOT EXISTS `mob_spawn_points` (
6 `mobid` int(10) NOT NULL,
7 `m' at line 5
8[Err] -- ----------------------------
9-- Table structure for mob_spawn_points
10-- ----------------------------
11DROP TABLE IF EXISTS `mob_spawn_points`
12CREATE TABLE IF NOT EXISTS `mob_spawn_points` (
13 `mobid` int(10) NOT NULL,
14 `mobname` varchar(24) DEFAULT NULL,
15 `groupid` int(10) unsigned NOT NULL DEFAULT '0',
16 `pos_x` float(7,3) NOT NULL DEFAULT '0.000',
17 `pos_y` float(7,3) NOT NULL DEFAULT '0.000',
18 `pos_z` float(7,3) NOT NULL DEFAULT '0.000',
19 `pos_rot` tinyint(3) unsigned NOT NULL DEFAULT '0',
20 PRIMARY KEY (`mobid`)
21) ENGINE=MyISAM DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=33;
22[Msg] Finished - Unsuccessfully
23--------------------------------------------------