subscribers.sql

CREATE TABLE subscribers (
  id int(11) NOT NULL, first_name varchar(255) DEFAULT NULL, last_name varchar(255) DEFAULT NULL, email varchar(255) DEFAULT NULL, phone varchar(255) DEFAULT NULL, privacy char(1) DEFAULT NULL, source varchar(255) DEFAULT NULL, ip varchar(255) DEFAULT NULL, email_hash varchar(255) DEFAULT NULL, phone_hash varchar(255) DEFAULT NULL, creation_date datetime DEFAULT NULL) 
  ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE subscribers
  ADD PRIMARY KEY (id),
  ADD KEY email_hash (email_hash),
  ADD KEY phone_hash (phone_hash);