Is there something about SQL that requires constraints to follow all column definitions?
sqlite> create table `option4_blobs` (`option_id` char(36) default '0', CONSTRAINT `value_id` UNIQUE (`option_id`),`binary` blob, FOREIGN KEY (`option_id`) REFERENCES `option4_map`(`option_id`)ON UPDATE CASCADE ON DELETE CASCADE) ...> ; Error: near "`binary`": syntax error sqlite> create table `option4_blobs` (`option_id` char(36) default '0',`binary` blob, CONSTRAINT `value_id` UNIQUE (`option_id`), FOREIGN KEY (`option_id`) REFERENCES `option4_map`(`option_id`)ON UPDATE CASCADE ON DELETE CASCADE) ...> ; -- works _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
