{"slug":"mailchimp-for-woocommerce","name":"Mailchimp for WooCommerce","description":"Connect your store to your Mailchimp audience to track sales, create targeted emails, send abandoned cart emails, and more.","author":"Mailchimp","active_installs":200000,"version":"6.1.1","wp_org_url":"https://wordpress.org/plugins/mailchimp-for-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"failed_jobs","full_table_name":"wp_failed_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"job","type":"text","nullable":false,"primary_key":false},{"name":"failed_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_failed_jobs ( id bigint(20) NOT NULL AUTO_INCREMENT, job text NOT NULL, failed_at datetime NOT NULL, PRIMARY KEY (id) ) $charset_collate;\"; dbDelta( $sql );"},{"table_name":"mailchimp_carts","full_table_name":"wp_mailchimp_carts","description":"Stores mailchimp carts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"VARCHAR","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR","nullable":false,"primary_key":false},{"name":"user_id","type":"INT","nullable":true,"primary_key":false},{"name":"cart","type":"text","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_mailchimp_carts ( id VARCHAR (255) NOT NULL, email VARCHAR (100) NOT NULL, user_id INT (11) DEFAULT NULL, cart text NOT NULL, created_at datetime NOT NULL, PRIMARY KEY (email) ) $charset_collate;\"; dbDelta( $sql );"},{"table_name":"mailchimp_jobs","full_table_name":"wp_mailchimp_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"obj_id","type":"text","nullable":true,"primary_key":false},{"name":"job","type":"text","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_mailchimp_jobs ( id bigint(20) NOT NULL AUTO_INCREMENT, obj_id text, job text NOT NULL, created_at datetime NOT NULL, PRIMARY KEY (id) ) $charset_collate;\"; dbDelta( $sql );"},{"table_name":"queue","full_table_name":"wp_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"job","type":"text","nullable":false,"primary_key":false},{"name":"attempts","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"locked","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"locked_at","type":"datetime","nullable":true,"primary_key":false},{"name":"available_at","type":"datetime","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_queue ( id bigint(20) NOT NULL AUTO_INCREMENT, job text NOT NULL, attempts tinyint(1) NOT NULL DEFAULT 0, locked tinyint(1) NOT NULL DEFAULT 0, locked_at datetime DEFAULT NULL, available_at datetime NOT NULL, created_at datetime NOT NULL, PRIMARY KEY (id) ) $charset_collate;\"; dbDelta( $sql );"},{"table_name":"woocommerce_api_keys","full_table_name":"wp_woocommerce_api_keys","description":"Stores woocommerce api keys data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":5}