{"table_name":"axemit_ipmsseo_suppliers","full_table_name":"wp_axemit_ipmsseo_suppliers","description":"Stores axemit ipmsseo suppliers data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_suppliers ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, feed_url TEXT NOT NULL DEFAULT '', feed_type VARCHAR(10) NOT NULL DEFAULT 'xml', local_file TEXT NOT NULL DEFAULT '', status TINYINT(1) NOT NULL DEFAULT 1, sync_interval VARCHAR(20) NOT NULL DEFAULT 'daily', sync_hour VARCHAR(5) NOT NULL DEFAULT '03:00', missing_action VARCHAR(20) NOT NULL DEFAULT 'stock_zero', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, last_sync DATETIME DEFAULT NULL, next_sync DATETIME DEFAULT NULL, PRIMARY KEY (id) ) $charset;\"; $sql[] = \"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_logs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, started_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, finished_at DATETIME DEFAULT NULL, duration_sec INT UNSIGNED DEFAULT NULL, products_new INT UNSIGNED NOT NULL DEFAULT 0, products_updated INT UNSIGNED NOT NULL DEFAULT 0, products_skipped INT UNSIGNED NOT NULL DEFAULT 0, products_errors INT UNSIGNED NOT NULL DEFAULT 0, status VARCHAR(20) NOT NULL DEFAULT 'running', notes TEXT NOT NULL DEFAULT '', PRIMARY KEY (id), KEY supplier_id (supplier_id) ) $charset;\"; $sql[] = \"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_log_errors ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, log_id BIGINT UNSIGNED NOT NULL, sku VARCHAR(255) NOT NULL DEFAULT '', message TEXT NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY log_id (log_id) ) $charset;\"; $sql[] = \"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_unmapped_categories ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, feed_category VARCHAR(500) NOT NULL, product_count INT UNSIGNED NOT NULL DEFAULT 0, seen_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY supplier_cat (supplier_id, feed_category(255)) ) $charset;\"; $sql[] = \"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_category_mappings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, feed_category VARCHAR(500) NOT NULL, wc_term_id BIGINT UNSIGNED DEFAULT NULL, action VARCHAR(20) NOT NULL DEFAULT 'map', PRIMARY KEY (id), UNIQUE KEY supplier_feed (supplier_id, feed_category(255)) ) $charset;\"; $sql[] = \"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_unmapped_brands ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, feed_brand VARCHAR(255) NOT NULL, seen_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY supplier_brand (supplier_id, feed_brand) ) $charset;\"; $sql[] = \"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_brand_mappings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, feed_brand VARCHAR(255) NOT NULL, wc_brand VARCHAR(255) DEFAULT NULL, action VARCHAR(20) NOT NULL DEFAULT 'map', PRIMARY KEY (id), UNIQUE KEY supplier_brand (supplier_id, feed_brand) ) $charset;\"; $sql[] = \"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_products ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, wc_product_id BIGINT UNSIGNED NOT NULL, feed_sku VARCHAR(255) NOT NULL, feed_hash VARCHAR(64) NOT NULL DEFAULT '', last_seen DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY supplier_sku (supplier_id, feed_sku), KEY wc_product_id (wc_product_id) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $sql as $query ) { dbDelta( $query );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"feed_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"feed_type","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"local_file","type":"TEXT","nullable":false,"primary_key":false},{"name":"status","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"sync_interval","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"sync_hour","type":"VARCHAR(5)","nullable":false,"primary_key":false},{"name":"missing_action","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_sync","type":"DATETIME","nullable":true,"primary_key":false},{"name":"next_sync","type":"DATETIME","nullable":true,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"started_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"finished_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"duration_sec","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"products_new","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"products_updated","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"products_skipped","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"products_errors","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":false,"primary_key":false},{"name":"log_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"sku","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"message","type":"TEXT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_category","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"product_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"seen_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_category","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"wc_term_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"action","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_brand","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"seen_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_brand","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"wc_brand","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"action","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"wc_product_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_sku","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"feed_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"last_seen","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"axemit-import-products-media-seo","name":"aXeMit Import Products, Media & SEO Suite for WooCommerce","active_installs":10,"version":"1.3.15","wp_org_url":"https://wordpress.org/plugins/axemit-import-products-media-seo/"}}