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 vote154 views1 answer
How to change null display in psql
SQL
0 vote182 views3 answers
Sql drop all tables
SQL
0 vote177 views1 answer
Mysql where in maintain order
SQL
0 vote172 views2 answers
Zsh: command not found: mysq
SQL
0 vote165 views1 answer
Tsql default value when no value returned by query
SQL
11 votes263 views2 answers
Sql between date range
SQL
0 vote192 views1 answer
Sql server synonym
SQL
1 vote166 views3 answers
Mysql connection string
SQL
0 vote159 views1 answer
Mysql function variable
SQL
21 votes168 views6 answers
Docker run mysql
SQL