replacing upserts due to their ignroing default values