Last active
October 28, 2019 15:24
-
-
Save lamorbidamacchina/17562001ff2dd9aee9cc961e8bc629ec to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment