I'm not really sure where this should go.
I'm having this error while trying to EXECUTE main.sql with my new database schema "ragnarok".
16:23:18 `clan_id` int(11) unsigned NOT NULL auto_increment, `name` varchar(24) NOT NULL DEFAULT '', `master` varchar(24) NOT NULL DEFAULT '', `mapname` varchar(24) NOT NULL DEFAULT '', `max_member` smallint(6) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`clan_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 Error Code: 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 '`clan_id` int(11) unsigned NOT NULL auto_increment, `name` varchar(24) NOT NUL' at line 1 0.000 sec
I cannot for the life of me figure this out and google has given me nothing. Any of you know what I should do?
EDIT: I just went into the code in the sql workbench and removed everything relating to clans. Everything else executed perfectly fine. It was only the clan data for some reason. I suppose I could always add it to the database manually at some point.