Sqlite unique multiple columns

create table projects (
    _id integer primary key autoincrement,
    project_type text not null,
    name text not null,
    description text,
    last_updated datetime default current_timestamp,
    date_created datetime default current_timestamp,
    unique (project_type, name)
);

Similar codes

1 vote245 views1 answer
Sql auto date
SQL
4 votes249 views1 answer
Delete record mysql query
SQL
0 vote254 views1 answer
Unique index in mysql
SQL
0 vote268 views1 answer
Set root password mysql xampp
SQL
0 vote253 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote249 views1 answer
Cannot start database server xampp mac os
SQL
0 vote255 views2 answers
Sql join on wildcard
SQL
0 vote255 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote423 views1 answer
Dublicate row sql
SQL
2 votes269 views1 answer
Power query concatenate
SQL