How does Magento interact with the MySQL database if I delete categories with products inside?
For example: There are lets say five categories with subcategories. Inside every category there are 100 products. So if i delete a category or subcategory, what happens with the products? Are they deleted too or do those products remain somewhere in the database?
A few other shop systems can be easily messed up by deleting categories with products.
Another question is: If I delete products, a customer has ordered, does the order tables keep those products , so that the shop administrator or the customer can still see the ordered products in the account history on the customer site or in the order history on the admin site?