ALTER TABLE mytbl ADD UNIQUE (columnName);
ALTER TABLE contacts ADD CONSTRAINT contacts_unique UNIQUE (reference_number);