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 vote123 views1 answer
Sql: extract day text from datetime value
SQL
0 vote182 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote126 views1 answer
Typeorm raw sql
SQL
0 vote183 views1 answer
Insert query return id mysql
SQL
1 vote127 views1 answer
Type int in mysql maxlenght
SQL
13 votes145 views2 answers
Sqlite rename table
SQL
0 vote125 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote128 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
21 votes116 views6 answers
Change column in mysql
SQL
2 votes180 views5 answers
Install postgresql 10 centos 7
SQL