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

3 votes150 views2 answers
Mysql import gz
SQL
2 votes133 views1 answer
Update trigger
SQL
0 vote148 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote126 views1 answer
First mysql
SQL
1 vote153 views1 answer
Mysql dump specific tables
SQL
1 vote162 views1 answer
How to get alternate records from a table in sql
SQL
0 vote153 views1 answer
How convert into in in sql query
SQL
4 votes137 views2 answers
Postgre sql create table
SQL
0 vote140 views1 answer
Mysql sum with group by
SQL
0 vote159 views2 answers
Getting customers with no orders sql
SQL