| 1 |
|
| 2 |
CREATE TABLE email_signups ( |
| 3 |
id UUID PRIMARY KEY DEFAULT gen_random_uuid(), |
| 4 |
email TEXT NOT NULL UNIQUE, |
| 5 |
source VARCHAR(50) NOT NULL DEFAULT 'landing', |
| 6 |
created_at TIMESTAMPTZ NOT NULL DEFAULT now() |
| 7 |
); |
| 8 |
|
| 9 |
CREATE INDEX idx_email_signups_created_at ON email_signups (created_at DESC); |
| 10 |
|