{"slug":"aistore-multi-vendor-store","name":"VendorVerse aistore multi vendor store for WooCommerce","description":"VendorVerse aistore multi vendor store for WooCommerce is a complete multi-vendor marketplace solution for WooCommerce with advanced analytics, fraud  …","author":"susheelhbti","active_installs":0,"version":"2.0.0","wp_org_url":"https://wordpress.org/plugins/aistore-multi-vendor-store/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"aistore_multivendor_add_to_cart_report","full_table_name":"wp_aistore_multivendor_add_to_cart_report","description":"Stores aistore multivendor add to cart report data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aistore_multivendor_system_orders","full_table_name":"wp_aistore_multivendor_system_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"vv_affiliates","full_table_name":"wp_vv_affiliates","description":"Stores vv affiliates data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"referrer_vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"referred_vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"commission_rate","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"total_earned","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_affiliates ( id bigint(20) NOT NULL AUTO_INCREMENT, referrer_vendor_id bigint(20) NOT NULL, referred_vendor_id bigint(20) NOT NULL, commission_rate decimal(5,2) NOT NULL DEFAULT 5.00, total_earned decimal(10,2) NOT NULL DEFAULT 0.00, status varchar(20) NOT NULL DEFAULT 'active', created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset;\" );"},{"table_name":"vv_cart_report","full_table_name":"wp_vv_cart_report","description":"Stores vv cart report data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_cart_report ( id bigint(20) NOT NULL AUTO_INCREMENT, product_id bigint(20) NOT NULL, user_id bigint(20) NOT NULL DEFAULT 0, ip_address varchar(45) NOT NULL DEFAULT '', created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY product_id (product_id), KEY user_id (user_id) ) $charset;\" );"},{"table_name":"vv_followers","full_table_name":"wp_vv_followers","description":"Stores vv followers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"customer_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"followed_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_followers ( id bigint(20) NOT NULL AUTO_INCREMENT, vendor_id bigint(20) NOT NULL, customer_id bigint(20) NOT NULL, followed_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY unique_follow (vendor_id, customer_id) ) $charset;\" );"},{"table_name":"vv_fraud_alerts","full_table_name":"wp_vv_fraud_alerts","description":"Stores vv fraud alerts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"customer_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"alert_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"severity","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"details","type":"text","nullable":true,"primary_key":false},{"name":"is_resolved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_fraud_alerts ( id bigint(20) NOT NULL AUTO_INCREMENT, vendor_id bigint(20) DEFAULT NULL, customer_id bigint(20) DEFAULT NULL, order_id bigint(20) DEFAULT NULL, alert_type varchar(50) NOT NULL, severity varchar(20) NOT NULL DEFAULT 'low', details text, is_resolved tinyint(1) NOT NULL DEFAULT 0, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY alert_type (alert_type), KEY is_resolved (is_resolved) ) $charset;\" );"},{"table_name":"vv_inventory","full_table_name":"wp_vv_inventory","description":"Stores vv inventory data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"sku","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"low_stock_threshold","type":"int(11)","nullable":false,"primary_key":false},{"name":"last_updated","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_inventory ( id bigint(20) NOT NULL AUTO_INCREMENT, vendor_id bigint(20) NOT NULL, product_id bigint(20) NOT NULL, sku varchar(100) DEFAULT NULL, quantity int(11) NOT NULL DEFAULT 0, low_stock_threshold int(11) NOT NULL DEFAULT 5, last_updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY vendor_product (vendor_id, product_id) ) $charset;\" );"},{"table_name":"vv_messages","full_table_name":"wp_vv_messages","description":"Stores vv messages data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"conversation_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"sender_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"receiver_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"message","type":"text","nullable":false,"primary_key":false},{"name":"attachment_url","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"is_read","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_messages ( id bigint(20) NOT NULL AUTO_INCREMENT, conversation_id bigint(20) NOT NULL, sender_id bigint(20) NOT NULL, receiver_id bigint(20) NOT NULL, order_id bigint(20) NOT NULL DEFAULT 0, message text NOT NULL, attachment_url varchar(500) DEFAULT NULL, is_read tinyint(1) NOT NULL DEFAULT 0, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY conversation_id (conversation_id), KEY receiver_id (receiver_id) ) $charset;\" );"},{"table_name":"vv_product_approvals","full_table_name":"wp_vv_product_approvals","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"admin_notes","type":"text","nullable":true,"primary_key":false},{"name":"revision_requested","type":"text","nullable":true,"primary_key":false},{"name":"submitted_at","type":"timestamp","nullable":false,"primary_key":false},{"name":"reviewed_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_product_approvals ( id bigint(20) NOT NULL AUTO_INCREMENT, product_id bigint(20) NOT NULL, vendor_id bigint(20) NOT NULL, status varchar(20) NOT NULL DEFAULT 'pending', admin_notes text, revision_requested text, submitted_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, reviewed_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY product_id (product_id), KEY vendor_id (vendor_id), KEY status (status) ) $charset;\" );"},{"table_name":"vv_system_orders","full_table_name":"wp_vv_system_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"product_owner_user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_owner_user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_system_orders ( id bigint(20) NOT NULL AUTO_INCREMENT, product_id bigint(20) NOT NULL, order_id bigint(20) NOT NULL, product_owner_user_id bigint(20) NOT NULL, order_owner_user_id bigint(20) NOT NULL, ip_address varchar(45) NOT NULL DEFAULT '', created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id), KEY product_owner_user_id (product_owner_user_id) ) $charset;\" );"},{"table_name":"vv_vendor_plans","full_table_name":"wp_vv_vendor_plans","description":"Stores vv vendor plans data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"price","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"duration_days","type":"int(11)","nullable":false,"primary_key":false},{"name":"max_products","type":"int(11)","nullable":false,"primary_key":false},{"name":"commission_rate","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"featured_listing","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"priority_support","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_vendor_plans ( id bigint(20) NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL, price decimal(10,2) NOT NULL DEFAULT 0.00, duration_days int(11) NOT NULL DEFAULT 30, max_products int(11) NOT NULL DEFAULT 10, commission_rate decimal(5,2) NOT NULL DEFAULT 10.00, featured_listing tinyint(1) NOT NULL DEFAULT 0, priority_support tinyint(1) NOT NULL DEFAULT 0, is_active tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (id) ) $charset;\" );"},{"table_name":"vv_vendor_reviews","full_table_name":"wp_vv_vendor_reviews","description":"Stores vv vendor reviews data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"customer_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"rating","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"review","type":"text","nullable":true,"primary_key":false},{"name":"vendor_response","type":"text","nullable":true,"primary_key":false},{"name":"is_verified","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_vendor_reviews ( id bigint(20) NOT NULL AUTO_INCREMENT, vendor_id bigint(20) NOT NULL, customer_id bigint(20) NOT NULL, order_id bigint(20) NOT NULL, rating tinyint(1) NOT NULL DEFAULT 5, review text, vendor_response text, is_verified tinyint(1) NOT NULL DEFAULT 0, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY vendor_id (vendor_id), KEY customer_id (customer_id) ) $charset;\" );"},{"table_name":"vv_vendor_subscriptions","full_table_name":"wp_vv_vendor_subscriptions","description":"Stores vv vendor subscriptions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"plan_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"starts_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_vendor_subscriptions ( id bigint(20) NOT NULL AUTO_INCREMENT, vendor_id bigint(20) NOT NULL, plan_id bigint(20) NOT NULL, starts_at datetime NOT NULL, expires_at datetime NOT NULL, status varchar(20) NOT NULL DEFAULT 'active', PRIMARY KEY (id), KEY vendor_id (vendor_id) ) $charset;\" );"},{"table_name":"vv_wallet_transactions","full_table_name":"wp_vv_wallet_transactions","description":"Stores vv wallet transactions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_wallet_transactions ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, product_id bigint(20) NOT NULL DEFAULT 0, order_id bigint(20) NOT NULL DEFAULT 0, amount decimal(10,2) NOT NULL, type varchar(10) NOT NULL COMMENT 'credit|debit', description text, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id) ) $charset;\" );"},{"table_name":"vv_webhook_logs","full_table_name":"wp_vv_webhook_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"webhook_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"payload","type":"longtext","nullable":true,"primary_key":false},{"name":"response","type":"text","nullable":true,"primary_key":false},{"name":"http_code","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_webhook_logs ( id bigint(20) NOT NULL AUTO_INCREMENT, webhook_id bigint(20) NOT NULL, event_type varchar(50) NOT NULL, payload longtext, response text, http_code int(11) DEFAULT NULL, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY webhook_id (webhook_id) ) $charset;\" );"},{"table_name":"vv_webhooks","full_table_name":"wp_vv_webhooks","description":"Stores vv webhooks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"secret_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_webhooks ( id bigint(20) NOT NULL AUTO_INCREMENT, vendor_id bigint(20) NOT NULL, name varchar(100) NOT NULL, url varchar(500) NOT NULL, event_type varchar(50) NOT NULL, secret_key varchar(64) NOT NULL DEFAULT '', is_active tinyint(1) NOT NULL DEFAULT 1, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY vendor_id (vendor_id) ) $charset;\" );"},{"table_name":"vv_withdrawals","full_table_name":"wp_vv_withdrawals","description":"Stores vv withdrawals data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"method","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"account_details","type":"text","nullable":true,"primary_key":false},{"name":"gateway_charge","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"admin_note","type":"text","nullable":true,"primary_key":false},{"name":"transaction_ref","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"processed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_withdrawals ( id bigint(20) NOT NULL AUTO_INCREMENT, vendor_id bigint(20) NOT NULL, amount decimal(10,2) NOT NULL, method varchar(50) NOT NULL DEFAULT 'bank', account_details text, gateway_charge decimal(10,2) NOT NULL DEFAULT 0.00, status varchar(20) NOT NULL DEFAULT 'pending', admin_note text, transaction_ref varchar(100) DEFAULT NULL, processed_at datetime DEFAULT NULL, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY vendor_id (vendor_id), KEY status (status) ) $charset;\" );"}],"table_count":17}