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

0 vote201 views1 answer
Mysql 1 hour ago
SQL
-1 vote198 views1 answer
Window functions in sql
SQL
4 votes208 views1 answer
Mysql query first character
SQL
2 votes202 views2 answers
Sql first character
SQL
15 votes204 views1 answer
Mysql int range
SQL
0 vote215 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote210 views1 answer
Increase speed of like queries postgres
SQL
0 vote180 views1 answer
Opensuse status MySQL
SQL
1 vote198 views3 answers
How to truncate table with foreign key constraint
SQL
6 votes223 views2 answers
Psql load dump
SQL