Contact year_id defaults to 1
The AUTOINCREMENTed contact_id and group_id fields are not PRIMARY KEYs
Use a period rather than a slash to seperate the id and device_id in a guid