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

0 vote303 views1 answer
Frename oracle
SQL
0 vote310 views1 answer
Mysqli_connect using prepare statement
SQL
16 votes301 views1 answer
Sql comment'
SQL
0 vote307 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote234 views1 answer
<script>alert
SQL
3 votes298 views2 answers
Tsql join multiple record in one string
SQL
-1 vote335 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote358 views1 answer
ALV GRID events
SQL
0 vote418 views1 answer
ORA-01400
SQL
2 votes294 views1 answer
Sqlite insert if not exists
SQL