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

18 votes313 views6 answers
Drop table if exists
SQL
0 vote318 views2 answers
Jsonb
SQL
1 vote328 views1 answer
Join first name and last name sql
SQL
0 vote307 views1 answer
Sql select by content lenght
SQL
7 votes320 views6 answers
Group_concat in mysql
SQL
0 vote313 views2 answers
How to get json data mysql
SQL
0 vote312 views1 answer
Truncate a table then insert data
SQL
0 vote313 views1 answer
Mysql conf.d exampel
SQL
0 vote288 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
5 votes296 views6 answers
Sql add days to date
SQL