remove FOOTPRINT_ID from COC_DATA table