Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. UPDATE`wp_term_taxonomy` SET count = 0 WHERE `taxonomy` LIKE 'zerobscrm_transactiontag';
  2.  
  3. DELETE FROM `wp_term_taxonomy` WHERE `taxonomy` LIKE 'zerobscrm_tickettag';
  4. DELETE FROM `wp_term_taxonomy` WHERE `taxonomy` LIKE 'zerobscrm_transactiontag';
  5. DELETE FROM `wp_term_taxonomy` WHERE `taxonomy` LIKE 'zerobscrm_customertag';
  6.  
  7. DELETE FROM `wp_posts` WHERE `post_type` LIKE 'zerobs_transaction';
  8. DELETE FROM `wp_posts` WHERE `post_type` LIKE 'zerobs_customer';
  9. DELETE FROM `wp_posts` WHERE `post_type` LIKE 'zerobs_invoice';
  10. DELETE FROM `wp_posts` WHERE `post_type` LIKE 'zerobs_company';
  11. DELETE FROM `wp_posts` WHERE `post_type` LIKE 'zerobs_log';
  12. DELETE FROM `wp_posts` WHERE `post_type` LIKE 'zerobs_quote';
  13. DELETE FROM `wp_posts` WHERE `post_type` LIKE 'zerobs_ticket';
  14. UPDATE`wp_term_taxonomy` SET count = 0 WHERE `taxonomy` LIKE 'zerobscrm_worktag';
  15. UPDATE`wp_term_taxonomy` SET count = 0 WHERE `taxonomy` LIKE 'zerobscrm_customertag';
  16. UPDATE`wp_term_taxonomy` SET count = 0 WHERE `taxonomy` LIKE 'zerobscrm_tickettag';
  17.  
  18. DELETE FROM `wp_postmeta` WHERE `meta_key` LIKE 'zbs_woo_unique_ID';
  19. DELETE FROM `wp_postmeta` WHERE `meta_key` LIKE 'zbs_paypal_unique_ID';
  20. DELETE FROM `wp_postmeta` WHERE `meta_key` LIKE 'zbs_woo_unique_inv_ID';
  21. DELETE FROM `wp_postmeta` WHERE `meta_key` LIKE 'zbs_transaction_meta';
  22. DELETE FROM `wp_postmeta` WHERE `meta_key` LIKE 'zbs_customer_meta';
  23. DELETE FROM `wp_postmeta` WHERE `meta_key` LIKE 'zbs_customer_ext_str';
  24. DELETE FROM `wp_postmeta` WHERE `meta_key` LIKE 'zbs_customer_ext_woo';
  25. DELETE FROM `wp_options` WHERE `option_name` LIKE 'zbs_woo_first_import_complete';
  26.  
  27. DELETE FROM wp_zbs_contacts WHERE 1 = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement