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 vote172 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote238 views1 answer
Opensuse start MySQL
SQL
6 votes222 views3 answers
Mysql remove user privileges
SQL
21 votes168 views5 answers
Oracle all tables
SQL
0 vote212 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
11 votes161 views2 answers
Insert date sql
SQL
1 vote166 views1 answer
Xampp import sql file command line
SQL
-2 votes184 views1 answer
How to open database
SQL
0 vote178 views1 answer
Psql check if sql script is valid
SQL
0 vote176 views1 answer
Power bi dax add related shows column but not working
SQL