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

13 votes184 views2 answers
Get tables in database sql
SQL
-1 vote215 views1 answer
Create view in mysql workbench
SQL
0 vote184 views2 answers
Temp tables in sql server
SQL
0 vote180 views1 answer
Sql server check whether column has same equal values
SQL
0 vote184 views1 answer
Create user faunadb
SQL
0 vote179 views1 answer
Mysql create pool
SQL
1 vote176 views1 answer
Sql drop with dependencies
SQL
8 votes171 views1 answer
Alter tablespace add datafile
SQL
1 vote177 views1 answer
Set autoincrement to 0
SQL
0 vote181 views3 answers
How to increase size of column in sql
SQL