Create Stored Procedure to anonymize customers older than given date - Githubissues

gbirkner / Salon

WebAnwendung der TFBS EKE

0 stars 0 forks source link

Create Stored Procedure to anonymize customers older than given date #32

Closed bweb96 closed 6 years ago

bweb96 commented 6 years ago

Customers Table:

Set Customers.Description null
Set Customers.Birthday to 01.01.[customer birthday year]
Set FName and LName to "Anonym"
Set Customers.isActive to 0

Other Tables:

Delete all Connections
Delete all Images where IsSketch = 0
Set Visit.Description to null