[sqlite] creating a table with an index

[Sam Carleton]

I am trying to create a table with two indexes:

CREATE TABLE favorites (
    cust_id CHAR(32) NOT NULL,
    fldoid CHAR(38) NOT NULL,
    imgoid CHAR(64) NOT NULL,
    PRIMARY KEY (cust_id),
    INDEX (fldoid, imgoid));

SQLite keeps complaining saying there is an error around INDEX.  What
might I be doing wrong?

Sam
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users