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

14 votes185 views5 answers
Sql oracle limit
SQL
0 vote178 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
3 votes176 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote175 views1 answer
Create new table pl sql
SQL
1 vote176 views3 answers
How to filter repeated same result using sql query
SQL
2 votes183 views1 answer
When matched in sql server
SQL
2 votes217 views2 answers
Set value to null sql
SQL
-1 vote149 views10 answers
Delete Query in SQL Server
SQL
8 votes170 views3 answers
Alter table auto_increment
SQL
0 vote195 views1 answer
Allow null in psql
SQL