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 vote210 views1 answer
Mysql f# examples
SQL
0 vote215 views1 answer
Dataframe lambda elif
SQL
-1 vote294 views5 answers
Left join
SQL
1 vote214 views1 answer
Mysql show data from table
SQL
0 vote247 views1 answer
Oracle show running job
SQL
10 votes154 views2 answers
Django mysql
SQL
0 vote216 views1 answer
Sql query contains multiple ids
SQL
25 votes250 views5 answers
Mysql replace text
SQL
0 vote214 views1 answer
Mysql grant grant option
SQL
6 votes272 views2 answers
Mysql check auto increment value
SQL