Does the following schema:
create table t(col1 text NOT NULL,
col2 text NOT NULL,
col3 text NOT NULL,
UNIQUE(col1,col2),
PRIMARY KEY(col1,col2));State that the COMBINATION of col1+col2 must be unique? Or that BOTH col1 and col2 must be unique? I assumed the first but I am getting for rejections for "uniqueness constraint failed" using sqlite 2.8.0. Thank you! Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell)
