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

50 votes169 views6 answers
Sql duplicate rows
SQL
0 vote114 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote89 views1 answer
Postgresql export output table as a csv
SQL
0 vote111 views1 answer
Sqlite get date only
SQL
0 vote128 views1 answer
How to define a non primary composite key in sql
SQL
0 vote56 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote108 views4 answers
User defined function sql
SQL
0 vote105 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote104 views2 answers
How to tun mysql on ubunto
SQL
2 votes99 views1 answer
Mysql add boolean column
SQL