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 vote156 views2 answers
How to search date in sql query
SQL
0 vote179 views1 answer
Which lock mode is not available in sql
SQL
0 vote206 views1 answer
T-sql delete view if exists
SQL
0 vote150 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote228 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote149 views1 answer
Oracle last user logon
SQL
0 vote158 views1 answer
Write SQL in ruby on rails
SQL
8 votes175 views1 answer
Database backup in mysql server recovery
SQL
0 vote158 views1 answer
Mysql check if lowercase
SQL
0 vote165 views1 answer
Mssql + bit + in python orm
SQL