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

0 vote196 views1 answer
Drop all triggers oracle
SQL
0 vote201 views1 answer
Ubuntu connect to mssql database
SQL
0 vote220 views1 answer
How to find date from date table in sql
SQL
0 vote191 views1 answer
Create database store
SQL
0 vote200 views1 answer
Select multiple row from primary key sql
SQL
1 vote201 views1 answer
Tsql get beginning of year
SQL
0 vote222 views1 answer
Java sql timestamp now
SQL
1 vote196 views1 answer
Data type and their numeric form
SQL
1 vote196 views1 answer
Md5 encryption for existing records
SQL
1 vote184 views1 answer
DATE_SUB postgres
SQL