WordPress database error: [Table 'wp_sleepops_outreach_contacts' already exists]
CREATE TABLE wp_sleepops_outreach_contacts (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
outreach_date date DEFAULT NULL,
website varchar(191) DEFAULT NULL,
url varchar(500) DEFAULT NULL,
contact_name varchar(191) DEFAULT NULL,
email varchar(191) DEFAULT NULL,
platform varchar(64) DEFAULT NULL,
prospect_type varchar(64) DEFAULT NULL,
topic varchar(191) DEFAULT NULL,
article_title varchar(255) DEFAULT NULL,
resource_sent varchar(500) DEFAULT NULL,
recommended_anchor varchar(191) DEFAULT NULL,
status varchar(32) NOT NULL DEFAULT 'prospect',
audience_match_score tinyint unsigned NOT NULL DEFAULT 0,
content_fit_score tinyint unsigned NOT NULL DEFAULT 0,
external_link_habit_score tinyint unsigned NOT NULL DEFAULT 0,
total_score tinyint unsigned NOT NULL DEFAULT 0,
personalization_note text DEFAULT NULL,
reply text DEFAULT NULL,
backlink tinyint(1) NOT NULL DEFAULT 0,
backlink_url varchar(500) DEFAULT NULL,
follow_up_date date DEFAULT NULL,
notes text DEFAULT NULL,
sent_at datetime DEFAULT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
KEY email (email),
KEY platform (platform),
KEY prospect_type (prospect_type),
KEY status (status),
KEY total_score (total_score),
KEY follow_up_date (follow_up_date),
KEY outreach_date (outreach_date)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci