Design the contacts table for an address book. It must have id as the primary key and required email as text; the database must prevent two contacts from sharing the same email.