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 vote358 views1 answer
Mysql last year
SQL
0 vote321 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
41 votes427 views6 answers
Alter table add column in SQL Server
SQL
1 vote408 views1 answer
Postgresql can you have null foreign key
SQL
1 vote337 views1 answer
Sql server cast date dd/mm/yyyy
SQL
1 vote329 views1 answer
Mysql query bulk insert
SQL
0 vote330 views2 answers
How to check if sqlite table exists in nodejs
SQL
7 votes336 views2 answers
Mysql default value
SQL
6 votes331 views1 answer
Oracle desc table primary key
SQL
2 votes341 views1 answer
Drop sequence
SQL