CREATE TABLE addrs ( localpart STRING PRIMARY KEY, user STRING NOT NULL, redirect STRING NOT NULL, comment STRING NOT NULL ); CREATE TABLE disabled_users ( user STRING PRIMARY KEY ); CREATE INDEX addr_users ON addrs (user, localpart);