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 votes239 views1 answer
Pl sql escape &
SQL
0 vote235 views1 answer
Sql server datetime
SQL
14 votes246 views4 answers
Online sql compiler
SQL
0 vote224 views1 answer
Oracle execute package dblink
SQL
7 votes240 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote246 views3 answers
Classement rang mysql 7
SQL
3 votes284 views1 answer
What is having
SQL
13 votes249 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote283 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
16 votes235 views1 answer
Sql comment'
SQL