❌ Import failed.

/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
--------------
CREATE TABLE `lm_user_email_nppaengage_purplelab` (
  `database_id` bigint(20) UNSIGNED NOT NULL,
  `last` varchar(255) DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `email_domain` varchar(255) NOT NULL,
  `purchased_speciality` varchar(255) DEFAULT NULL,
  `speciality` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip` varchar(11) DEFAULT NULL,
  `np` tinyint(1) DEFAULT 0,
  `pa` tinyint(1) DEFAULT 0,
  `rn` tinyint(1) DEFAULT 0,
  `sn` tinyint(1) DEFAULT 0,
  `ha` tinyint(1) DEFAULT 0,
  `other` tinyint(1) NOT NULL DEFAULT 0,
  `npi_number` varchar(11) DEFAULT NULL,
  `state_license_number` varchar(50) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `member` tinyint(1) DEFAULT 0,
  `source` varchar(45) DEFAULT NULL,
  `created_date` timestamp NULL DEFAULT NULL,
  `email_status` int(11) DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `unsubscribe` tinyint(1) DEFAULT 0,
  `es_identifier` varchar(10) DEFAULT NULL,
  `vendor` varchar(20) DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `last_name_norm` varchar(100) GENERATED ALWAYS AS (lcase(trim(`last`))) STORED,
  `first_name_norm` varchar(100) GENERATED ALWAYS AS (lcase(trim(`first`))) STORED,
  `city_norm` varchar(100) GENERATED ALWAYS AS (lcase(trim(`city`))) STORED,
  `state_norm` varchar(100) GENERATED ALWAYS AS (lcase(trim(`state`))) STORED,
  `zip_code_norm` varchar(11) GENERATED ALWAYS AS (lcase(substr(trim(`zip`),1,5))) STORED,
  `street_address_norm` varchar(255) GENERATED ALWAYS AS (replace(lcase(trim(`address`)),_utf8mb4' ',_utf8mb4'')) STORED,
  `first_initial_norm` varchar(150) GENERATED ALWAYS AS (concat(lcase(substr(trim(`first`),1,1)),_utf8mb4' ',lcase(trim(`last`)))) STORED,
  `title` varchar(6) GENERATED ALWAYS AS (case when `np` = 1 then _utf8mb4'np' when `pa` = 1 then _utf8mb4'pa' when `rn` = 1 then _utf8mb4'rn' when `sn` = 1 then _utf8mb4'sn' when `ha` = 1 then _utf8mb4'ha' when `other` = 1 then _utf8mb4'other' else NULL end) STORED,
  `hcp_id` int(11) DEFAULT NULL,
  `hcp_md_hash` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
--------------

ERROR 1050 (42S01) at line 30: Table 'lm_user_email_nppaengage_purplelab' already exists