Skip to content

Instantly share code, notes, and snippets.

@dapi

dapi/mysql_diff.sql

Created October 21, 2020 18:44
Show Gist options
  • Save dapi/d0c45bcef51b1a83b463b7b66550e9ff to your computer and use it in GitHub Desktop.
Save dapi/d0c45bcef51b1a83b463b7b66550e9ff to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_diff.sql
## mysqldiff 0.50
##
## Run on Wed Oct 21 18:42:45 2020
## Options: tolerant, debug=0
##
## --- db: wordpress_reproduction
## +++ db: test_wordpress
ALTER TABLE aej_bwf_actions CHANGE COLUMN recurring_interval recurring_interval int(11) NOT NULL DEFAULT '0'; # was int(10) NOT NULL DEFAULT '0'
ALTER TABLE aej_bwf_actions CHANGE COLUMN status status int(11) NOT NULL DEFAULT '0' COMMENT '0 - Pending | 1 - Running'; # was int(1) NOT NULL DEFAULT '0' COMMENT '0 - Pending | 1 - Running'
ALTER TABLE aej_bwf_actions CHANGE COLUMN e_time e_time int(11) NOT NULL DEFAULT '0'; # was int(12) NOT NULL DEFAULT '0'
ALTER TABLE aej_bwf_contact CHANGE COLUMN wpid wpid int(11) NOT NULL; # was int(12) NOT NULL
ALTER TABLE aej_bwf_contact CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(12) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_bwf_wc_customers CHANGE COLUMN cid cid int(11) NOT NULL; # was int(12) NOT NULL
ALTER TABLE aej_bwf_wc_customers CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(12) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_bwf_wc_customers CHANGE COLUMN total_order_count total_order_count int(11) NOT NULL; # was int(7) NOT NULL
ALTER TABLE aej_commentmeta ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_comments ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_computers_envato CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_downloads_log CHANGE COLUMN user_id user_id int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE aej_downloads_log CHANGE COLUMN downloaded downloaded int(11) DEFAULT '0'; # was int(1) DEFAULT '0'
ALTER TABLE aej_downloads_log CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_downloads_log_envato CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_downloads_log_trials CHANGE COLUMN trial_id trial_id int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE aej_downloads_log_trials CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_edd_customermeta ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE aej_edd_customers ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE aej_email_log CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_email_log CHANGE COLUMN created created int(11) DEFAULT NULL; # was int(20) DEFAULT NULL
ALTER TABLE aej_installer_log CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(6) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_installer_log CHANGE COLUMN install_end install_end int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE aej_installer_log CHANGE COLUMN install_start install_start int(11) NOT NULL; # was int(1) NOT NULL
ALTER TABLE aej_ip_blacklist CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_launches_stats CHANGE COLUMN last_launch_time last_launch_time int(10) unsigned DEFAULT '0'; # was int(11) unsigned DEFAULT '0'
ALTER TABLE aej_launches_stats CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_launches_stats ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE aej_licenses_envato CHANGE COLUMN ban ban int(11) DEFAULT '0'; # was int(1) DEFAULT '0'
ALTER TABLE aej_licenses_envato CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_licenses_envato CHANGE COLUMN refund refund int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE aej_links ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_log CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_options ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_paywall_stats CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(6) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_postmeta ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_posts CHANGE COLUMN product_size product_size int(11) NOT NULL; # was int(13) NOT NULL
ALTER TABLE aej_posts CHANGE COLUMN product_installed_size product_installed_size int(11) NOT NULL; # was int(13) NOT NULL
ALTER TABLE aej_posts CHANGE COLUMN videohive_only videohive_only int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE aej_posts CHANGE COLUMN preview_size preview_size int(11) NOT NULL; # was int(13) NOT NULL
ALTER TABLE aej_posts ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_projects_searches CHANGE COLUMN day day int(11) NOT NULL; # was int(2) NOT NULL
ALTER TABLE aej_projects_searches CHANGE COLUMN matches matches int(11) NOT NULL; # was int(6) NOT NULL
ALTER TABLE aej_projects_searches CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(6) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_projects_searches CHANGE COLUMN imports imports int(11) NOT NULL; # was int(3) NOT NULL
ALTER TABLE aej_projects_searches CHANGE COLUMN month month int(11) NOT NULL; # was int(2) NOT NULL
ALTER TABLE aej_projects_searches CHANGE COLUMN paid paid int(11) NOT NULL; # was int(3) NOT NULL
ALTER TABLE aej_projects_searches CHANGE COLUMN year year int(11) NOT NULL; # was int(4) NOT NULL
ALTER TABLE aej_projects_stats CHANGE COLUMN finishes finishes int(11) NOT NULL; # was int(6) NOT NULL
ALTER TABLE aej_projects_stats CHANGE COLUMN year year int(11) NOT NULL; # was int(4) NOT NULL
ALTER TABLE aej_projects_stats CHANGE COLUMN searches searches int(11) NOT NULL; # was int(6) NOT NULL
ALTER TABLE aej_projects_stats CHANGE COLUMN imports imports int(11) NOT NULL; # was int(6) NOT NULL
ALTER TABLE aej_projects_stats CHANGE COLUMN favorites favorites int(11) NOT NULL; # was int(6) NOT NULL
ALTER TABLE aej_projects_stats CHANGE COLUMN id id int(11) NOT NULL AUTO_INCREMENT; # was int(8) NOT NULL AUTO_INCREMENT
ALTER TABLE aej_projects_stats CHANGE COLUMN month month int(11) NOT NULL; # was int(2) NOT NULL
ALTER TABLE aej_projects_stats ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE aej_projects_styles CHANGE COLUMN imports imports int(11) NOT NULL; # was int(6) NOT NULL
ALTER TABLE aej_projects_styles CHANGE COLUMN year year int(11) NOT NULL; # was int(4) NOT NULL
ALTER TABLE aej_projects_styles CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(6) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_projects_styles CHANGE COLUMN adds adds int(11) NOT NULL; # was int(6) NOT NULL
ALTER TABLE aej_projects_styles CHANGE COLUMN month month int(11) NOT NULL; # was int(2) NOT NULL
ALTER TABLE aej_redirection_404 CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_redirection_groups CHANGE COLUMN module_id module_id int(10) unsigned NOT NULL DEFAULT '0'; # was int(11) unsigned NOT NULL DEFAULT '0'
ALTER TABLE aej_redirection_groups CHANGE COLUMN position position int(10) unsigned NOT NULL DEFAULT '0'; # was int(11) unsigned NOT NULL DEFAULT '0'
ALTER TABLE aej_redirection_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_redirection_items CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_redirection_items CHANGE COLUMN regex regex int(10) unsigned NOT NULL DEFAULT '0'; # was int(11) unsigned NOT NULL DEFAULT '0'
ALTER TABLE aej_redirection_items CHANGE COLUMN action_code action_code int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE aej_redirection_items CHANGE COLUMN position position int(10) unsigned NOT NULL DEFAULT '0'; # was int(11) unsigned NOT NULL DEFAULT '0'
ALTER TABLE aej_redirection_logs CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_redirection_logs CHANGE COLUMN group_id group_id int(10) unsigned DEFAULT NULL; # was int(11) unsigned DEFAULT NULL
ALTER TABLE aej_redirection_logs CHANGE COLUMN redirection_id redirection_id int(10) unsigned DEFAULT NULL; # was int(11) unsigned DEFAULT NULL
ALTER TABLE aej_redirection_logs CHANGE COLUMN module_id module_id int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE aej_referral CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_referral CHANGE COLUMN created created int(11) DEFAULT NULL; # was int(255) DEFAULT NULL
ALTER TABLE aej_search_log CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_search_log CHANGE COLUMN created created int(11) DEFAULT NULL; # was int(20) DEFAULT NULL
ALTER TABLE aej_sessions CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_social_users DROP INDEX ID; # was INDEX (ID,type)
ALTER TABLE aej_social_users ADD INDEX id (ID,type);
ALTER TABLE aej_social_users ADD PRIMARY KEY (ID);
ALTER TABLE aej_swp_cf CHANGE COLUMN term term int(10) unsigned NOT NULL; # was int(20) unsigned NOT NULL
ALTER TABLE aej_swp_log CHANGE COLUMN hits hits mediumint(8) unsigned NOT NULL; # was mediumint(9) unsigned NOT NULL
ALTER TABLE aej_swp_tax CHANGE COLUMN term term int(10) unsigned NOT NULL; # was int(20) unsigned NOT NULL
ALTER TABLE aej_swpext_metrics_clicks CHANGE COLUMN position position int(10) unsigned NOT NULL COMMENT 'Position in SERP'; # was int(9) unsigned NOT NULL COMMENT 'Position in SERP'
ALTER TABLE aej_swpext_metrics_searches CHANGE COLUMN hits hits int(10) unsigned NOT NULL COMMENT 'How many hits were found'; # was int(9) unsigned NOT NULL COMMENT 'How many hits were found'
ALTER TABLE aej_sync CHANGE COLUMN user_id user_id int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE aej_sync CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_ta_link_clicks ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_ta_link_clicks_meta ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_term_relationships ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_term_taxonomy ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_termmeta ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_terms CHANGE COLUMN term_group term_group bigint(20) NOT NULL DEFAULT '0'; # was bigint(10) NOT NULL DEFAULT '0'
ALTER TABLE aej_terms CHANGE COLUMN term_order term_order int(11) DEFAULT '0'; # was int(4) DEFAULT '0'
ALTER TABLE aej_terms ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_test CHANGE COLUMN refund refund int(11) DEFAULT '0'; # was int(1) DEFAULT '0'
ALTER TABLE aej_test CHANGE COLUMN ban ban int(11) DEFAULT '0'; # was int(1) DEFAULT '0'
ALTER TABLE aej_test ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE aej_trials CHANGE COLUMN purchased_at purchased_at int(10) unsigned DEFAULT NULL; # was int(11) unsigned DEFAULT NULL
ALTER TABLE aej_trials CHANGE COLUMN user_id user_id int(10) unsigned DEFAULT NULL; # was int(11) unsigned DEFAULT NULL
ALTER TABLE aej_trials CHANGE COLUMN dynamic_discount_enabled dynamic_discount_enabled int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE aej_trials CHANGE COLUMN purchased purchased int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE aej_trials CHANGE COLUMN discount discount int(10) unsigned NOT NULL DEFAULT '0'; # was int(3) unsigned NOT NULL DEFAULT '0'
ALTER TABLE aej_trials CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_usermeta ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_users CHANGE COLUMN ban ban int(11) DEFAULT '0'; # was int(1) DEFAULT '0'
ALTER TABLE aej_users CHANGE COLUMN reseller_user_id reseller_user_id int(11) DEFAULT NULL; # was int(20) DEFAULT NULL
ALTER TABLE aej_users CHANGE COLUMN reseller_confirm reseller_confirm int(11) DEFAULT NULL; # was int(2) DEFAULT NULL
ALTER TABLE aej_users ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_users_content_stats CHANGE COLUMN imports imports int(11) NOT NULL; # was int(6) NOT NULL
ALTER TABLE aej_users_content_stats CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(6) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_users_content_stats CHANGE COLUMN year year int(11) NOT NULL; # was int(4) NOT NULL
ALTER TABLE aej_users_content_stats CHANGE COLUMN month month int(11) NOT NULL; # was int(2) NOT NULL
ALTER TABLE aej_users_content_stats CHANGE COLUMN adds adds int(11) NOT NULL; # was int(22) NOT NULL
ALTER TABLE aej_wc_computers CHANGE COLUMN recheck_license recheck_license int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE aej_wc_computers CHANGE COLUMN logged_in logged_in int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE aej_wc_computers CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_wc_computers ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE aej_wc_download_log ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_wc_licences CHANGE COLUMN ban ban int(11) DEFAULT '0'; # was int(1) DEFAULT '0'
ALTER TABLE aej_wc_licences CHANGE COLUMN refund refund int(11) DEFAULT '0'; # was int(1) DEFAULT '0'
ALTER TABLE aej_wc_licences ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE aej_wc_webhooks CHANGE COLUMN failure_count failure_count smallint(6) NOT NULL DEFAULT '0'; # was smallint(10) NOT NULL DEFAULT '0'
ALTER TABLE aej_wc_webhooks CHANGE COLUMN api_version api_version smallint(6) NOT NULL; # was smallint(4) NOT NULL
ALTER TABLE aej_wc_webhooks ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_wcpdf_invoice_number CHANGE COLUMN calculated_number calculated_number int(11) DEFAULT NULL; # was int(16) DEFAULT NULL
ALTER TABLE aej_wcpdf_invoice_number CHANGE COLUMN id id int(11) NOT NULL AUTO_INCREMENT; # was int(16) NOT NULL AUTO_INCREMENT
ALTER TABLE aej_wcpdf_invoice_number CHANGE COLUMN order_id order_id int(11) DEFAULT NULL; # was int(16) DEFAULT NULL
ALTER TABLE aej_wcpdf_invoice_number ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_wfco_report_views CHANGE COLUMN type type tinyint(4) NOT NULL DEFAULT '1'; # was tinyint(2) NOT NULL DEFAULT '1'
ALTER TABLE aej_wfocu_event CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(20) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_wfocu_session CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE aej_wfocu_session CHANGE COLUMN order_id order_id int(11) NOT NULL; # was int(20) NOT NULL
ALTER TABLE aej_woobe_history CHANGE COLUMN id id int(11) NOT NULL AUTO_INCREMENT; # was int(12) NOT NULL AUTO_INCREMENT
ALTER TABLE aej_woobe_history_bulk CHANGE COLUMN id id int(11) NOT NULL AUTO_INCREMENT; # was int(12) NOT NULL AUTO_INCREMENT
ALTER TABLE aej_woocommerce_api_keys ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_attribute_taxonomies CHANGE COLUMN attribute_public attribute_public int(11) NOT NULL DEFAULT '1'; # was int(1) NOT NULL DEFAULT '1'
ALTER TABLE aej_woocommerce_attribute_taxonomies ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_downloadable_product_permissions ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_log CHANGE COLUMN level level smallint(6) NOT NULL; # was smallint(4) NOT NULL
ALTER TABLE aej_woocommerce_log ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_order_itemmeta ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_order_items ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_payment_tokenmeta ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_payment_tokens ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_sessions ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_shipping_zone_locations ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_shipping_zone_methods ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_shipping_zones ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_tax_rate_locations ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_woocommerce_tax_rates CHANGE COLUMN tax_rate_shipping tax_rate_shipping int(11) NOT NULL DEFAULT '1'; # was int(1) NOT NULL DEFAULT '1'
ALTER TABLE aej_woocommerce_tax_rates CHANGE COLUMN tax_rate_compound tax_rate_compound int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE aej_woocommerce_tax_rates ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; # was ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
ALTER TABLE aej_wpxten_sad_youtube_comments DROP FOREIGN KEY aej_wpxten_sad_youtube_comments_ibfk_1; # was CONSTRAINT aej_wpxten_sad_youtube_comments_ibfk_1 (video_id) REFERENCES aej_wpxten_sad_videos (ID) ON DELETE CASCADE ON UPDATE NO ACTION
ALTER TABLE aej_wpxten_sad_youtube_comments ADD CONSTRAINT aej_wpxten_sad_youtube_comments_ibfk_1 FOREIGN KEY (video_id) REFERENCES aej_wpxten_sad_videos (ID) ON DELETE CASCADE;
ALTER TABLE aej_yoast_seo_links CHANGE COLUMN type type varchar(8) CHARACTER SET utf8mb4 NOT NULL; # was varchar(8) NOT NULL
ALTER TABLE aej_yoast_seo_links CHANGE COLUMN url url varchar(255) CHARACTER SET utf8mb4 NOT NULL; # was varchar(255) NOT NULL
ALTER TABLE aej_yoast_seo_meta DROP INDEX object_id; # was UNIQUE (object_id)
ALTER TABLE aej_yoast_seo_meta ADD PRIMARY KEY (object_id);
ALTER TABLE fb_data CHANGE COLUMN installs_gave installs_gave int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE fb_data CHANGE COLUMN blocked blocked int(11) NOT NULL; # was int(1) NOT NULL
ALTER TABLE fb_data CHANGE COLUMN repost_count repost_count int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE fb_data CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE fb_data CHANGE COLUMN imports imports int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE fb_data CHANGE COLUMN launches launches int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE fb_data CHANGE COLUMN user_created_time user_created_time int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE fb_data CHANGE COLUMN last_launch_time last_launch_time int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE fb_data CHANGE COLUMN first_launch_bonus first_launch_bonus int(11) NOT NULL; # was int(1) NOT NULL
ALTER TABLE fb_data CHANGE COLUMN age age int(10) unsigned NOT NULL; # was int(3) unsigned NOT NULL
ALTER TABLE fb_data CHANGE COLUMN months months int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE fb_data ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE ml_insta_posts_approved CHANGE COLUMN permission_asked permission_asked int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE ml_insta_posts_approved CHANGE COLUMN permission permission int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE ml_insta_posts_approved CHANGE COLUMN time_added time_added int(10) unsigned NOT NULL DEFAULT '0'; # was int(11) unsigned NOT NULL DEFAULT '0'
ALTER TABLE ml_insta_posts_approved CHANGE COLUMN status status int(11) NOT NULL DEFAULT '0'; # was int(2) NOT NULL DEFAULT '0'
ALTER TABLE ml_insta_posts_approved CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE ml_insta_posts_approved ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE ml_insta_users CHANGE COLUMN permission permission int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE ml_insta_users CHANGE COLUMN time_added time_added int(10) unsigned NOT NULL; # was int(11) unsigned NOT NULL
ALTER TABLE ml_insta_users CHANGE COLUMN group_member group_member int(11) NOT NULL DEFAULT '0'; # was int(1) NOT NULL DEFAULT '0'
ALTER TABLE ml_insta_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT; # was int(11) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE ml_insta_users ENGINE=InnoDB DEFAULT CHARSET=utf8; # was ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE aej_duplicator_packages (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
name varchar(250) NOT NULL,
hash varchar(50) NOT NULL,
status int(11) NOT NULL,
created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
owner varchar(60) NOT NULL,
package longtext NOT NULL,
PRIMARY KEY (id),
KEY hash (hash)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
CREATE TABLE aej_products_updates (
id int(11) NOT NULL AUTO_INCREMENT,
product_name varchar(120) NOT NULL,
developer_name varchar(50) DEFAULT '',
status int(11) NOT NULL DEFAULT '0',
created int(11) NOT NULL,
platform varchar(50) DEFAULT 'AE',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4;
CREATE TABLE aej_wpfm_backup (
id int(11) NOT NULL AUTO_INCREMENT,
backup_name text COLLATE utf8mb4_unicode_520_ci,
backup_date text COLLATE utf8mb4_unicode_520_ci,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment