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

2 votes198 views1 answer
Mysql change data type of column
SQL
1 vote183 views1 answer
Error code 1175 mysql fix
SQL
0 vote195 views1 answer
Snap craft
SQL
1 vote251 views2 answers
Laravel jwt generate token
SQL
0 vote195 views1 answer
Mysql export search results
SQL
6 votes208 views4 answers
Remove spaces sql server
SQL
0 vote231 views1 answer
Compare strings lexicographically in sql
SQL
4 votes211 views1 answer
Id increment ms sql server
SQL
1 vote219 views1 answer
Myql find duplicates
SQL
0 vote196 views1 answer
Calculate age in sql
SQL