Skip to content

Instantly share code, notes, and snippets.

@mmilosheski
Created July 7, 2017 13:08
Show Gist options
  • Save mmilosheski/64bce4c5cff07cec95ad3d678db2b5eb to your computer and use it in GitHub Desktop.
Save mmilosheski/64bce4c5cff07cec95ad3d678db2b5eb to your computer and use it in GitHub Desktop.
SET sql_mode = '';
ALTER TABLE wp_commentmeta AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_comments AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_et_bloom_stats AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_et_social_stats AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_failed_jobs AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_links AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailchimp_carts AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_actions AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_forms AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_forms_lists AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_form_fields AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_links AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_lists AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_lists_subscribers AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_queue AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_subscribers AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_subscriber_fields AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_mailster_subscriber_meta AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_options AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_postmeta AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_posts AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_queue AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_social_users AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_termmeta AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_terms AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_term_relationships AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_term_taxonomy AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_usermeta AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_users AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_api_keys AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_attribute_taxonomies AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_downloadable_product_permissions AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_log AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_order_itemmeta AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_order_items AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_payment_tokenmeta AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_payment_tokens AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_sessions AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_shipping_zones AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_shipping_zone_locations AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_shipping_zone_methods AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_tax_rates AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_woocommerce_tax_rate_locations AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_yith_wcaf_affiliates AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_yith_wcaf_clicks AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_yith_wcaf_commissions AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_yith_wcaf_commission_notes AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_yith_wcaf_payments AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_yith_wcaf_payment_commission AUTO_INCREMENT = (highest id + 1);
ALTER TABLE wp_yith_wcaf_payment_notes AUTO_INCREMENT = (highest id + 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment