第一种:

ALTER TABLE actor ADD unique uniq_idx_firstname (first_name);
alter table actor add index idx_lastname (last_name)

第二种:

create unique index uniq_idx_firstname on actor (first_name);
create index idx_lastname on actor (last_name)