10 lines
311 B
MySQL
10 lines
311 B
MySQL
|
CREATE TABLE email_signups (
|
||
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
email VARCHAR NOT NULL,
|
||
|
|
token VARCHAR NOT NULL,
|
||
|
|
expiration_date TIMESTAMP NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE INDEX email_signups_token ON email_signups (token);
|
||
|
|
CREATE UNIQUE INDEX email_signups_token_requests_email ON email_signups (email);
|