lebear

CREATE TABLE IF NOT EXISTS wp_wpforo_forums (
   forumid int(10) unsigned NOT NULL AUTO_INCREMENT,
   title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
   slug varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
   description longtext COLLATE utf8mb4_unicode_ci,
   parentid int(10) unsigned NOT NULL DEFAULT '0',
   icon varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   last_topicid int(10) unsigned NOT NULL DEFAULT '0',
   last_postid int(10) unsigned NOT NULL DEFAULT '0',
   last_userid int(10) unsigned NOT NULL DEFAULT '0',
   last_post_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   topics int(11) NOT NULL DEFAULT '0',
   posts int(11) NOT NULL DEFAULT '0',
   permissions text COLLATE utf8mb4_unicode_ci,
   meta_key text COLLATE utf8mb4_unicode_ci,
   meta_desc text COLLATE utf8mb4_unicode_ci,
   status tinyint(1) unsigned NOT NULL DEFAULT '0',
   is_cat tinyint(1) unsigned NOT NULL DEFAULT '0',
   cat_layout tinyint(1) unsigned NOT NULL DEFAULT '0',
   order int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (forumid),
   UNIQUE KEY UNIQUE SLUG (slug(191)) 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

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 order int(10) unsigned NOT NULL DEFAULT ‘0’, PRIMARY KEY (forumid), UNIQUE’ at line 20 0.063 sec