How to add a constraint to an existing SQLite table

CREATE UNIQUE INDEX table_i ON table(id, type);