Sqlite create unique pair of columns Sqlite create unique pair of columns sqlite sqlite

Sqlite create unique pair of columns


Add a separate constraint for both columns:

CREATE TABLE MyTable(    user_id INTEGER,    image_id INTEGER,    [...],    UNIQUE(user_id, image_id))