DekodeInteraktiv / anonymize-mysqldump

Allows you to pipe data from mysqldump or an SQL file and anonymize it.
GNU General Public License v3.0
17 stars 9 forks source link

Add more supported types #16

Open JorgenStenshaugen opened 2 years ago

JorgenStenshaugen commented 2 years ago

When anonymizing Woocommerce I stumbled upon some missing types to use for the shipping/billing fields

Address types missing: For _billing_city field in WC I'd need a one word string for the City. So a type addressCity would solve this. For _billing_country expects a country code for example "NO" or "SV". A type addressCountryCode would solve this.

_billing_address_index is a little more tricky. It stores the whole billing address including the:

I think it's stored as a string in the database with spaces between them.

dekode-kevin commented 2 years ago

We are also missing "social security number"

In norway this is a 12 number code with date month year and a random number. Example: 010122123456

pdewouters commented 1 year ago

A simple number type would be useful too