{"slug":"artzio-artist-marketplace","name":"Artzio Artist Marketplace for WooCommerce","description":"Create an artist marketplace where creators can sell artworks using WooCommerce.","author":"Urban-Age Solutions Private Limited","active_installs":0,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/artzio-artist-marketplace/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"artzioam_artworks","full_table_name":"wp_artzioam_artworks","description":"Stores artzioam artworks data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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);"},{"table_name":"artzioam_earnings","full_table_name":"wp_artzioam_earnings","description":"Stores artzioam earnings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"artzioam_notifications","full_table_name":"wp_artzioam_notifications","description":"Stores artzioam notifications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"artzioam_submissions","full_table_name":"wp_artzioam_submissions","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":4}