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 vote193 views1 answer
Error code 1292 mysql workbench
SQL
0 vote258 views1 answer
Compare two tables to find unmatched records
SQL
0 vote190 views1 answer
Login failed for login due to trigger execution
SQL
27 votes327 views3 answers
Mysql delete row
SQL
53 votes565 views6 answers
Sql server alter column
SQL
2 votes195 views2 answers
Create empty table from existing table
SQL
0 vote179 views1 answer
Sql right characters
SQL
5 votes197 views1 answer
Oracle find foreign key dependencies
SQL
0 vote202 views1 answer
Datatables server side filter where clause
SQL
0 vote205 views1 answer
Add sqlcmd to path linux
SQL