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

1 vote258 views2 answers
Reset mysqli fetch_arra
SQL
0 vote283 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote288 views1 answer
Sqlite löschen einer tabelle
SQL
5 votes316 views3 answers
Sql limit offset
SQL
0 vote303 views1 answer
Mysql dump with table query
SQL
0 vote259 views1 answer
Sqlserver now
SQL
0 vote281 views1 answer
Sql on-premises
SQL
0 vote284 views1 answer
Drop-toys-table
SQL
0 vote282 views1 answer
Database db connection string format
SQL
0 vote270 views2 answers
Sql join on comma separated field
SQL