add id to authoritative_resource to work around mysql RBR replication bug