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

0 vote237 views1 answer
Sql query contains multiple ids
SQL
10 votes220 views1 answer
All_dependencies
SQL
4 votes259 views2 answers
Postgresql float data type
SQL
0 vote217 views1 answer
MySql count occurences more than"
SQL
0 vote249 views1 answer
Hour differeence in mysql
SQL
2 votes226 views2 answers
Oracle no data found error code
SQL
0 vote255 views1 answer
T-sql update table variale
SQL
0 vote235 views1 answer
Set a value by excuting stored procedure
SQL
0 vote217 views1 answer
What is mysql_pconnect
SQL
0 vote220 views1 answer
Date diff sql
SQL