If you need to temporarily violate checks in order to rearrange your schema, I draw your attention to these two:
<https://www.sqlite.org/pragma.html#pragma_ignore_check_constraints> <https://www.sqlite.org/pragma.html#pragma_foreign_keys> Obviously, once you're done rearranging/importing you reenable them both and run <https://www.sqlite.org/pragma.html#pragma_integrity_check> To see what horrible things you've done to the database. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users