1006374: add delete cascade to cp_pool_*

adding in delete cascades on the pool_id foreign keys will allow
deletion of pools and have their provided/derived products go away.

In the event we end up with duplicate entries again in cp_pool_products
this change will prevent the constraint violation when deleting
the pool.