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