Ive put up a new version of my foreign key constraint trigger generation tool, the parser now better understands supported syntax, and the way is better paved to support generating CHECK constraint triggers in the next release
Download it at: http://odin.nmxs.com/~cpisto/sqlite_fk.tgz windows/linux binaries included, public domain source -Cody