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

2 votes270 views1 answer
Import database in mysql command line xampp
SQL
0 vote315 views2 answers
Mysql show foreign keys
SQL
1 vote278 views1 answer
Load sql into mamp
SQL
0 vote277 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote271 views1 answer
Implicit inner join table alias with id values
SQL
0 vote293 views1 answer
Mysql grant grant option
SQL
2 votes305 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote286 views3 answers
Sql server import json
SQL
0 vote278 views1 answer
C# datetime to sql server datetime
SQL
1 vote278 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL