Add index on powerdns.records.designate_record_id

We need to add the index on this as it avoids some deadlocks.

Change-Id: I82f8bee8f80b1bb410d4e51d8938d0dc92e399c7
Merge "Add index on powerdns.records.designate_record_id"