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

1 vote151 views1 answer
Postgres format date in select
SQL
1 vote153 views2 answers
Sql now - 1 day
SQL
3 votes202 views2 answers
Oracle privileges users
SQL
2 votes137 views1 answer
How to select first row of database sql
SQL
6 votes147 views3 answers
What is where in sql
SQL
2 votes140 views2 answers
Postgresql get table names
SQL
0 vote149 views1 answer
Make parameters nullable in sql server
SQL
0 vote138 views1 answer
Components/Fields of Internal Table
SQL
1 vote137 views1 answer
Access the postgres psql
SQL
1 vote137 views2 answers
Mysql: command not found
SQL