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

5 votes402 views4 answers
Mysql update column with value from another table
SQL
0 vote312 views1 answer
Mysqli or pdo
SQL
0 vote384 views1 answer
Watch mysql command line
SQL
0 vote383 views2 answers
Sql query inner join 3 tables
SQL
1 vote354 views4 answers
Postgres extract date from timestamp
SQL
0 vote364 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote356 views2 answers
How to display enum value sql server
SQL
0 vote365 views1 answer
Mysql undo delete
SQL
0 vote352 views1 answer
Limit and offset in stored procedure mssql
SQL
3 votes335 views4 answers
Show sql server database
SQL