/*
ALTER table actor ADD unique uniq_idx_firstname(first_name);
注意:SQLite已经不支持ALTER TABLE创建索引功能!
*/
create UNIQUE index uniq_idx_firstname on actor(first_name);
create index idx_lastname on actor(last_name);
/*
ALTER table actor ADD unique uniq_idx_firstname(first_name);
注意:SQLite已经不支持ALTER TABLE创建索引功能!
*/
create UNIQUE index uniq_idx_firstname on actor(first_name);
create index idx_lastname on actor(last_name);