added purchase url column to deals table