use CASCADING DELETE with SQLITE

https://www.sqlite.org/pragma.html#pragma_foreign_keys

As of SQLite version 3.6.19, the default setting for foreign key enforcement is OFF. [...]  To minimize future problems, applications should set the foreign key enforcement flag as required by the application and not depend on the default setting.

So, when connecting to the database, you need to execute PRAGMA foreign_keys = on; The easiest way to do this would probably be to use the simple_query() method of the database library:

PHP Code:

$this->db->simple_query('PRAGMA foreign_keys = on'); 


You should only need to do this once per connection.

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide