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 vote197 views1 answer
Liquibase alter column type / length
SQL
0 vote187 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote210 views1 answer
Mysql export data with a where clause
SQL
0 vote176 views2 answers
Postgresql change user role grant
SQL
1 vote209 views1 answer
Tsql random number
SQL
0 vote178 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote246 views1 answer
A network or instance-specific error sql server
SQL
0 vote193 views1 answer
Mysql average from two table
SQL
0 vote198 views1 answer
Sqlalchemy get ids
SQL
0 vote174 views1 answer
Sql remove last x char
SQL