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 vote174 views1 answer
Primary key reset in SQL database
SQL
3 votes120 views2 answers
Sqlite show table definition
SQL
0 vote116 views1 answer
Do postgresql
SQL
0 vote122 views1 answer
Oracle query to find schema you are working on
SQL
0 vote144 views1 answer
SQL Where-Klausel
SQL
0 vote109 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
6 votes116 views4 answers
How to remove unique key in mysql
SQL
1 vote123 views1 answer
Add many column to sap iq table
SQL
3 votes136 views1 answer
Force using index oracle
SQL
2 votes140 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL