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

11 votes257 views2 answers
Mysql disable safe mode
SQL
0 vote250 views1 answer
Concat column value of same user in mysql
SQL
3 votes260 views2 answers
Update part of a string in mysql
SQL
1 vote301 views1 answer
Column with prefix in sql
SQL
0 vote201 views1 answer
Show the colums of table sql
SQL
0 vote206 views1 answer
Sql change date format
SQL
0 vote207 views1 answer
Mariadb select limit offset
SQL
0 vote276 views1 answer
Get enginge db mysql
SQL
0 vote345 views1 answer
Mysql select field if condition
SQL
0 vote198 views1 answer
Create new schema mysql
SQL