sqlite创建单列索引语法为:
CREATE INDEX index_name ON table_name (column_name);
创建唯一索引语法为:
CREATE UNIQUE INDEX index_name on table_name (column_name);
结合语法格式可得答案如下:
CREATE UNIQUE INDEX uniq_idx_firstname on actor (first_name); CREATE INDEX idx_lastname ON actor (last_name);