Usually during a Magento e-commerce project we like to revert our Magento databases back to the default throughout the project so that we can ensure when we are importing project data (categories, attributes, products, customers etc) that we haven’t missed anything and everything imports well. We usually do this in sections very similar to the above ie. categories, attributes, products, customers.
To help us with this we created these set of SQL scripts over time to either restore close to the entire database back to its original state, or these sub-sections as listed above.
So for a full run down on the scripts and a link to the SQL itself visit the Magento Database Delete/Reset SQL Scripts Lab Page