Advertisement
Guest User

Untitled

a guest
Nov 29th, 2015
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.51 KB | None | 0 0
  1. SET FOREIGN_KEY_CHECKS=0;
  2.  
  3. TRUNCATE `sales_flat_creditmemo`;
  4. TRUNCATE `sales_flat_creditmemo_comment`;
  5. TRUNCATE `sales_flat_creditmemo_grid`;
  6. TRUNCATE `sales_flat_creditmemo_item`;
  7. TRUNCATE `sales_flat_invoice`;
  8. TRUNCATE `sales_flat_invoice_comment`;
  9. TRUNCATE `sales_flat_invoice_grid`;
  10. TRUNCATE `sales_flat_invoice_item`;
  11. TRUNCATE `sales_flat_order`;
  12. TRUNCATE `sales_flat_order_address`;
  13. TRUNCATE `sales_flat_order_grid`;
  14. TRUNCATE `sales_flat_order_item`;
  15. TRUNCATE `sales_flat_order_payment`;
  16. TRUNCATE `sales_flat_order_status_history`;
  17. TRUNCATE `sales_flat_quote`;
  18. TRUNCATE `sales_flat_quote_address`;
  19. TRUNCATE `sales_flat_quote_address_item`;
  20. TRUNCATE `sales_flat_quote_item`;
  21. TRUNCATE `sales_flat_quote_item_option`;
  22. TRUNCATE `sales_flat_quote_payment`;
  23. TRUNCATE `sales_flat_quote_shipping_rate`;
  24. TRUNCATE `sales_flat_shipment`;
  25. TRUNCATE `sales_flat_shipment_comment`;
  26. TRUNCATE `sales_flat_shipment_grid`;
  27. TRUNCATE `sales_flat_shipment_item`;
  28. TRUNCATE `sales_flat_shipment_track`;
  29. TRUNCATE `sales_invoiced_aggregated`;
  30. TRUNCATE `sales_invoiced_aggregated_order`;
  31. TRUNCATE `sales_payment_transaction`;
  32. TRUNCATE `sales_order_aggregated_created`;
  33. TRUNCATE `sales_order_tax`;
  34. TRUNCATE `sales_order_tax_item`;
  35.  
  36. TRUNCATE `sendfriend_log`;
  37. TRUNCATE `tag`;
  38. TRUNCATE `tag_relation`;
  39. TRUNCATE `tag_summary`;
  40. TRUNCATE `wishlist`;
  41. TRUNCATE `log_quote`;
  42. TRUNCATE `report_event`;
  43.  
  44. ALTER TABLE `sales_flat_creditmemo` AUTO_INCREMENT=1;
  45. ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1;
  46. ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1;
  47. ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1;
  48. ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;
  49. ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1;
  50. ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;
  51. ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;
  52. ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;
  53. ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;
  54. ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;
  55. ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
  56. ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;
  57. ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1;
  58. ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;
  59. ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;
  60. ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;
  61. ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;
  62. ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;
  63. ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;
  64. ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;
  65. ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;
  66. ALTER TABLE `sales_flat_shipment_comment` AUTO_INCREMENT=1;
  67. ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;
  68. ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;
  69. ALTER TABLE `sales_flat_shipment_track` AUTO_INCREMENT=1;
  70. ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1;
  71. ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1;
  72. ALTER TABLE `sales_payment_transaction` AUTO_INCREMENT=1;
  73. ALTER TABLE `sales_order_aggregated_created` AUTO_INCREMENT=1;
  74. ALTER TABLE `sales_order_tax` AUTO_INCREMENT=1;
  75. ALTER TABLE `sales_order_tax_item` AUTO_INCREMENT=1;
  76.  
  77. ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
  78. ALTER TABLE `tag` AUTO_INCREMENT=1;
  79. ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
  80. ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
  81. ALTER TABLE `wishlist` AUTO_INCREMENT=1;
  82. ALTER TABLE `log_quote` AUTO_INCREMENT=1;
  83. ALTER TABLE `report_event` AUTO_INCREMENT=1;
  84.  
  85. SET FOREIGN_KEY_CHECKS=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement