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 vote358 views1 answer
Postgresql port 5432 not open
SQL
0 vote336 views1 answer
Fetch second word from a string in ms sql
SQL
6 votes326 views5 answers
Get current date sql
SQL
1 vote342 views1 answer
Access the postgres psql
SQL
0 vote332 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote319 views1 answer
Sql select column names starting with
SQL
0 vote328 views1 answer
Groupby error in mysql
SQL
5 votes326 views2 answers
Oracle show procedures
SQL
1 vote394 views1 answer
Postgresql float 2 decimal places
SQL
17 votes343 views6 answers
MySQL ORDER BY
SQL