We're updating the issue view to help you get more done. 

SQLite: UNIQUE index on multiple columns

Description

SQLite supports UNIQUE key on multiple columns:

1 2 3 4 create table foo ( ... UNIQUE (col1, col2, col3) );

This works only at create table level.
addUniqueConstraint generates 'addUniqueConstraint is not supported on sqlite'.

Maybe you can add createTable-level <uniqueConstraint> for such situations?

1 2 3 4 <createTable tableName="foo"> <column .... /> ..... <uniqueConstraint name="uk" columnNames="..." />

Environment

Windows 7, xerial/sqlite-jdbc 3.23.1

Status

Assignee

Unassigned

Reporter

Anatoliy Golubev

Labels

None

Components

Affects versions

3.6.3

Priority

Major