user@server ~ $ sqlite3 
SQLite version 3.7.7 2011-06-23 19:49:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t1(i int not null primary key, v varchar(100));
sqlite> create table t2(i int not null primary key, f_i references t1(id));
sqlite> select * from t1;
sqlite> select * from t2;
sqlite> insert into t1(i, v) values(1, 'test');
sqlite> select * from t1 where i = 1;
1|test
sqlite> delete from t1;
sqlite> drop table t1;
sqlite> drop table t2;
sqlite> pragma   foreign_keys = ON;
sqlite> create table t1(i int not null primary key, v varchar(100));
sqlite> create table t2(i int not null primary key, f_i references t1(id));
sqlite> insert into t1(i, v) values(1, 'test');
sqlite> select * from t1;
1|test
sqlite> select * from t2;
sqlite> select * from t1 where i = 1;
1|test
sqlite> ------- What wrong?
sqlite> delete from t1;
Error: foreign key mismatch
sqlite> delete from t1 where i = 1;
Error: foreign key mismatch
sqlite> ------- 
sqlite> drop table t2;
sqlite> delete from t1;
sqlite> 
sqlite>