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 vote313 views2 answers
Insert sqlite
SQL
3 votes313 views1 answer
Postgres add not null to existing column
SQL
1 vote318 views1 answer
Postgres power
SQL
4 votes284 views1 answer
Wilayah indonesia database
SQL
3 votes373 views1 answer
Mysql cli connect with password
SQL
0 vote314 views3 answers
Delete in SQL SERVER
SQL
0 vote328 views2 answers
Sql having multiple conditions
SQL
0 vote338 views1 answer
MySQL - Enabling the Event Scheduler
SQL
5 votes287 views2 answers
Ranking functions in sql
SQL
0 vote288 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL