{"table_name":"artzioam_artworks","full_table_name":"wp_artzioam_artworks","description":"Stores artzioam artworks data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_artzioam_artworks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, artist_id BIGINT(20) UNSIGNED NOT NULL, title VARCHAR(255) NOT NULL, description TEXT NULL, image_url VARCHAR(512) NOT NULL, dpi INT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY artist_id (artist_id) ) $charset_collate;\"; $tables[] = \"CREATE TABLE IF NOT EXISTS wp_artzioam_submissions ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, artist_id BIGINT(20) UNSIGNED NOT NULL, artwork_id BIGINT(20) UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'pending', submitted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY artist_id (artist_id), KEY artwork_id (artwork_id) ) $charset_collate;\"; $tables[] = \"CREATE TABLE IF NOT EXISTS wp_artzioam_earnings ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, artist_id BIGINT(20) UNSIGNED NOT NULL, order_id BIGINT(20) UNSIGNED NOT NULL, product_id BIGINT(20) UNSIGNED NOT NULL, amount DECIMAL(10,2) NOT NULL, earned_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY artist_id (artist_id), KEY order_id (order_id), KEY product_id (product_id) ) $charset_collate;\"; $tables[] = \"CREATE TABLE IF NOT EXISTS wp_artzioam_notifications ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, message TEXT NOT NULL, type VARCHAR(50) NOT NULL DEFAULT 'info', is_read TINYINT(1) NOT NULL DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($tables as $sql) { dbDelta($sql);","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"artist_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"image_url","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"dpi","type":"INT","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"artist_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"artwork_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"submitted_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"artist_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"earned_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"message","type":"TEXT","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"is_read","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"plugin":{"slug":"artzio-artist-marketplace","name":"Artzio Artist Marketplace for WooCommerce","active_installs":0,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/artzio-artist-marketplace/"}}