Mailing List not working, core_mailinglist db table doesn't exist

The mailing list options doesn’t work, users are not saved in the database when confirmed or when unconfirmed. SInce the database table *_core_mailinglist doesn’t exist in the database.

I checked db table is created from core_functions.php ln:131.

$wpdb->query(“DROP TABLE IF EXISTS ".$wpdb->prefix."core_mailinglist“);
$wpdb->query(“CREATE TABLE IF NOT EXISTS ".$wpdb->prefix."core_mailinglist (
autoid int(11) NOT NULL AUTO_INCREMENT,
email varchar(255) NOT NULL,
email_hash varchar(50) NOT NULL,
email_ip varchar(50) NOT NULL,
email_date datetime NOT NULL,
email_firstname varchar(150) NOT NULL,
email_lastname varchar(150) NOT NULL,
email_confirmed int(11) NOT NULL,
PRIMARY KEY (autoid),
UNIQUE KEY email (email))”);

When I run these lines in a seperately, taken from the above said file location, it shows the following error and db table is not created.

WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE IF NOT EXISTS *_core_mailinglist ( autoid int(11) NOT NULL AUTO_INCREMENT, email varchar(255) NOT NULL, email_hash varchar(50) NOT NULL, email_ip varchar(50) NOT NULL, email_date datetime NOT NULL, email_firstname varchar(150) NOT NULL, email_lastname varchar(150) NOT NULL, email_confirmed int(11) NOT NULL, PRIMARY KEY (autoid), UNIQUE KEY email (email))