I am helping a client clone a test server. Per the instructions they were given they have already truncated out some of the junk data created by testing, including orders and invoices, but they did not delete the RMAs. Could someone please tell me which tables I need to clear to delete the RMAs cleanly?
Here are the queries that were used to purge the test data:
DELETE FROM `sales_flat_order`; DELETE FROM `sales_order_tax`; DELETE FROM `downloadable_link_purchased`; DELETE FROM `eav_entity_store` WHERE entity_type_id IN ( SELECT `entity_type_id` FROM `eav_entity_type` WHERE `entity_type_code` IN ('order', 'invoice', 'creditmemo', 'shipment') );