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 vote127 views1 answer
Mysql get only the field names in a table
SQL
0 vote106 views1 answer
How many columns can be used for creating index?
SQL
2 votes110 views1 answer
Compare date in sql
SQL
0 vote108 views1 answer
Multiple left join mysql
SQL
5 votes98 views1 answer
Oracle get nls settings
SQL
-1 vote113 views1 answer
Mysql select count if contains
SQL
8 votes106 views1 answer
Oracle find text in functions
SQL
7 votes112 views1 answer
Mysql iif
SQL
0 vote130 views2 answers
While mysql
SQL
2 votes107 views1 answer
Drop table purge
SQL