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 vote136 views1 answer
How to get the date diff on once field in sql server
SQL
1 vote140 views2 answers
Postgres copy table from one schema to another
SQL
0 vote141 views1 answer
Oracle db timestamp auto add
SQL
0 vote137 views1 answer
How to output a different column name in mysql
SQL
5 votes166 views1 answer
Migrate sql table another database
SQL
8 votes142 views1 answer
Oracle all_source package body
SQL
2 votes133 views1 answer
Install sqlite npm
SQL
-1 vote131 views1 answer
Mysql case when multiple conditions
SQL
3 votes130 views1 answer
Oracle list user grants
SQL
0 vote137 views1 answer
Load utilities in sql server
SQL