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

5 votes335 views3 answers
Mysql check if null or empty string
SQL
0 vote379 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote371 views3 answers
Postgres date difference seconds
SQL
0 vote406 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote348 views3 answers
Sql select only time from datetime
SQL
2 votes350 views1 answer
While loop sql
SQL
5 votes415 views2 answers
Add days in oracle sql
SQL
0 vote387 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote321 views1 answer
Get number of table colums in sql query
SQL
16 votes373 views6 answers
Python sqlite
SQL