Use standard transaction pattern
Reference correct table
Set PRAGMA foreign_keys=ON on every open

See http://www.sqlite.org/foreignkeys.html#fk_enable
add build.xml
add new line
Merge pull request #54 from ddrscott/master

add Ant build file
Merge pull request #20 from vonloxley/transactionpattern

Use standard transaction pattern
Merge pull request #32 from vonloxley/reference_correct_table

Wrong reference generation / PRAGMA foreign_keys not set