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

3 votes151 views4 answers
Show databases in sql server
SQL
0 vote160 views1 answer
USING THE NOT CONDITION IN SQL
SQL
2 votes159 views1 answer
Mysql trigger after update
SQL
0 vote149 views1 answer
Sql auto_increment syntax
SQL
3 votes135 views1 answer
Start mysql server linux terminal
SQL
0 vote151 views2 answers
How to count codition
SQL
3 votes191 views1 answer
Sql several or
SQL
6 votes143 views1 answer
Phpmyadmin password root
SQL
0 vote155 views1 answer
How to check common records in 2 table
SQL
0 vote183 views1 answer
Drop domain postgresql
SQL