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 vote277 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
1 vote208 views2 answers
Mysql spring boot application.properties
SQL
0 vote198 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
1 vote217 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote221 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
5 votes215 views1 answer
Minecraft java port number
SQL
0 vote209 views1 answer
Min mysql
SQL
1 vote221 views1 answer
Rermove categories woocommerce sql
SQL
0 vote233 views1 answer
Update sql sintax
SQL
0 vote265 views2 answers
Sql unique
SQL