adding default field support to mysql state provider and cleanup