1CREATE TABLE subscriptions (
2    pid,
3    mail,
4    PRIMARY KEY (pid, mail)
5);
6CREATE INDEX idx_subscriptions_pid ON subscriptions(pid);
7CREATE INDEX idx_subscriptions_mail ON subscriptions(mail);
8
9CREATE TABLE optin (
10    mail PRIMARY KEY,
11    optin DEFAULT 0,
12    key
13);
14
15