WebSphere Commerce Version 8.0.4.12

SQL statements: Right to erasure

Individuals have the right to ask your organization to delete any personal information about them that your organization holds. The following table lists personal data that is stored in WebSphere Commerce and shows how to delete the data by using an SQL query.
Type of personal data SQL query and database table
Address
DELETE FROM ADDRESS WHERE MEMBER_ID=?; 
Birth date
DELETE FROM USERDEMO WHERE USERS_ID = ?; 
Browsing Behavior
DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)
Challenge answer
DELETE FROM USERREG WHERE USERS_ID = ?;
Currency
DELETE FROM USERS WHERE USERS_ID = ?;
Demographics
DELETE FROM USERDEMO WHERE USERS_ID = ?;
Email Address or IBMid
DELETE FROM ADDRESS WHERE MEMBER_ID=?;
Gender
DELETE FROM USERDEMO WHERE USERS_ID = ?;
Income
DELETE FROM USERDEMO WHERE USERS_ID = ?;
Language
DELETE FROM USERS WHERE USERS_ID = ?;
Logon ID
DELETE FROM USERREG WHERE USERS_ID = ?; 
Name
DELETE FROM ADDRESS WHERE MEMBER_ID=?;
Order History
DELETE FROM ORDERS WHERE MEMBER_ID =?;
Password (for shoppers and CSRs)
DELETE FROM USERREG WHERE USERS_ID = ?;
Phone Number
DELETE FROM ADDRESS WHERE MEMBER_ID=?; 
Referral URL
DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)
Search History
DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)