Managing the User Profile Images

This chapter describes how to add, update, or delete the profile images of the Smart+Connected Personalized Spaces application users.

•Adding the User Profile Images

•Editing the User Profile Images

•Deleting the User Profile Images

Adding the User Profile Images

To add the user profile images, run the following scripts using any SQL tool: 

INSERT INTO ssp_pvo_user_picture (USER_ID, PIC_URL) VALUES (<userID>,<profile image URL>);

commit;

 
   
 
    
   
 Where, <userID> is the user ID of the Cisco Service Delivery Platform (SDP) user and <profile image URL> is the URL where the user profile image is available. 
 
     
    
    
   
 Editing the User Profile Images 
 
    
   
 To edit the existing user profile images, run the following scripts using any SQL tool: 
 
    
   
 
    
UPDATE ssp_pvo_user_picture SET pic_url = <profile image URL> WHERE USER_ID = <userID>;

 
   
 
    
   
 
    
commit;

 
   
 
    
   
 
    
 
   
 
    
   
 Where, <userID> is the user ID of the SDP user and <profile image URL> is the URL where the user profile image is available. 
 
     
    
    
   
 Deleting the User Profile Images 
 
    
   
 To delete the existing user profile images, run the following scripts using any SQL tool: 
 
    
   
 
    
DELETE ssp_pvo_user_picture WHERE USER_ID = <userID>;

 
   
 
    
   
 
    
commit;

 
   
 
    
   
 
    
 
   
 
    
   
 Where, <userID> is the user ID of the SDP user.