   phrase TEXT NOT NULL,
   primary_phrase BIT NOT NULL,
   cluster_id INT NOT NULL
-);
+) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 
 CREATE INDEX ix__search_concept_cluster_phrases__search_id ON search_concept_cluster_phrases (search_id);
 ALTER TABLE search_concept_cluster_phrases ADD CONSTRAINT fk__search_concept_cluster_phrases__searches FOREIGN KEY (search_id) REFERENCES searches (search_id);

  search_stored_state_id BIGINT AUTO_INCREMENT PRIMARY KEY,
  search_id BIGINT NOT NULL,
  state_token VARCHAR(100) CHARACTER SET ascii NOT NULL
);

CREATE INDEX ix__search_stored_state__search_id ON search_stored_state (search_id);
ALTER TABLE search_stored_state ADD CONSTRAINT fk__search_stored_state__searches FOREIGN KEY (search_id) REFERENCES searches (search_id);

  date_range_type INT,
  last_fetched_new_date DATETIME,
  active BIT NOT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE INDEX ix__searches__search_type ON searches (search_type);

