TOPIC: Cannot Create or Edit Locations after upgrade

ALTER TABLE  #__hotspots_marker  ADD   customfields  text NOT NULL;
CREATE TABLE IF NOT EXISTS `#__hotspots_customfields` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `slug` varchar(255) NOT NULL DEFAULT '',
  `show` ENUM( 'all', 'category' ) NOT NULL DEFAULT 'all',
  `type` varchar(100) NOT NULL DEFAULT 'text',
  `options` mediumtext,
  `default` varchar(255) DEFAULT '',
  `allow_empty` tinyint(3) NOT NULL DEFAULT '0',
  `params` mediumtext,
  `enabled` tinyint(3) NOT NULL DEFAULT '1',
  `ordering` bigint(20) unsigned NOT NULL DEFAULT '0',
  `created_by` bigint(20) NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` bigint(20) NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
 
 
CREATE TABLE IF NOT EXISTS `#__hotspots_customfields_cats` (
  `hotspots_customfields_id` int(11) NOT NULL,
  `catid` int(11) NOT NULL,
PRIMARY KEY (`hotspots_customfields_id`,`catid`)
) DEFAULT CHARSET=utf8;
 
CREATE TABLE IF NOT EXISTS `#__hotspots_mappings` (
`marker_id` int(11) NOT NULL,
`foreign_id` int(11) NOT NULL,
`component` varchar(255) DEFAULT '',
PRIMARY KEY (`marker_id`,`foreign_id`)
) DEFAULT CHARSET=utf8;

Error
SQL query:
ALTER TABLE #__hotspots_marker ADD customfields text NOT NULL;
CREATE TABLE IF NOT EXISTS `#__hotspots_customfields` (
`id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 255 ) NOT NULL DEFAULT '',
`slug` VARCHAR( 255 ) NOT NULL DEFAULT '',
`show` ENUM( 'all', 'category' ) NOT NULL DEFAULT 'all',
`type` VARCHAR( 100 ) NOT NULL DEFAULT 'text',
`options` mediumtext,
`default` VARCHAR( 255 ) DEFAULT '',
`allow_empty` tinyint( 3 ) NOT NULL DEFAULT '0',
`params` mediumtext,
`enabled` tinyint( 3 ) NOT NULL DEFAULT '1',
`ordering` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`created_by` BIGINT( 20 ) NOT NULL DEFAULT '0',
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` BIGINT( 20 ) NOT NULL DEFAULT '0',
`modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY ( `id` )
) DEFAULT CHARSET = utf8;
 
MySQL said: Documentation
#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 `#__hotspots_customfields` (
  `id` bigint(20) unsig' at line 2