I have a Magento 1 database that I want to remove sensitive data from before I allow a consultant to connect to.
What tables/rows would I need to fill with dummy data? I have looked at my tables with
myPHPAdmin and wasn't able to find one containing credit card information. I read somewhere that not all versions of Magento store credit card information.
Once I find the tables/columns to change, I assume that what I need is something along the lines of:
UPDATE transactions SET creditCardNum = "4111111111111111";