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 vote130 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote151 views1 answer
Sql script get all stored procedures from database
SQL
0 vote182 views1 answer
Sql select max value for each group
SQL
0 vote169 views1 answer
ORACLE PARSE STRING
SQL
0 vote181 views1 answer
Sql reverse order of results
SQL
0 vote161 views1 answer
Mysql two joins
SQL
1 vote171 views1 answer
Media sql
SQL
0 vote171 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote186 views2 answers
Sql day from datetime
SQL
0 vote176 views1 answer
Select a row include list of array with join table SQL
SQL