{"slug":"knowband-mobile-app-builder-for-woocommerce","name":"Knowband Mobile App Builder","description":"The Knowband Mobile App Builder converts your online store into a pair of native Android & iOS apps without any coding.","author":"Knowband","active_installs":10,"version":"3.0.1","wp_org_url":"https://wordpress.org/plugins/knowband-mobile-app-builder-for-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"customer_push_notification_access_time","full_table_name":"wp_customer_push_notification_access_time","description":"Stores customer push notification access time data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"id_customer","type":"int(11)","nullable":false,"primary_key":false},{"name":"time_added","type":"datetime","nullable":false,"primary_key":false},{"name":"date_added","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_customer_push_notification_access_time`(`id` int(11) NOT NULL AUTO_INCREMENT, `id_customer` int(11) NOT NULL,`time_added` datetime NOT NULL,`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`))ENGINE"},{"table_name":"mab_banner","full_table_name":"wp_mab_banner","description":"Stores mab banner data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"banner_id","type":"int(10)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"image_width","type":"int(3)","nullable":false,"primary_key":false},{"name":"image_height","type":"int(3)","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"banner_limit","type":"int(10)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_banner` (`banner_id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(40) NOT NULL, `image_width` int(3) NOT NULL, `image_height` int(3) NOT NULL, `status` tinyint(1) NOT NULL, `banner_limit` int(10) NOT NULL, PRIMARY KEY (`banner_id`)) ENGINE"},{"table_name":"mab_banner_image","full_table_name":"wp_mab_banner_image","description":"Stores mab banner image data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"banner_image_id","type":"int(10)","nullable":false,"primary_key":true},{"name":"banner_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"banner_title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"link_type","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"link_to","type":"int(10)","nullable":false,"primary_key":false},{"name":"image","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"sort_order","type":"INT(3)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_banner_image` (`banner_image_id` int(10) NOT NULL AUTO_INCREMENT, `banner_id` int(10) NOT NULL, `banner_title` varchar(255) NOT NULL, `link_type` TINYINT(1) NOT NULL, `link_to` int(10) NOT NULL, `image` varchar(255) NOT NULL, `sort_order` INT(3) NOT NULL DEFAULT '0', PRIMARY KEY (`banner_image_id`))\"));"},{"table_name":"mab_cms_page_data","full_table_name":"wp_mab_cms_page_data","description":"Stores mab cms page data data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"cms_id","type":"int(10)","nullable":false,"primary_key":true},{"name":"page_title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"link_to","type":"int(10)","nullable":false,"primary_key":false},{"name":"status","type":"TINYINT(2)","nullable":false,"primary_key":false},{"name":"sort_order","type":"INT(3)","nullable":false,"primary_key":false},{"name":"date_added","type":"DATETIME","nullable":false,"primary_key":false},{"name":"date_modified","type":"TIMESTAMP","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_cms_page_data` (`cms_id` int(10) NOT NULL AUTO_INCREMENT, `page_title` varchar(255) NOT NULL, `link_to` int(10) NOT NULL, `status` TINYINT(2) NOT NULL, `sort_order` INT(3) NOT NULL DEFAULT '0', `date_added` DATETIME NOT NULL, `date_modified` TIMESTAMP NOT NULL, PRIMARY KEY (`cms_id`))\"));"},{"table_name":"mab_fcm_details","full_table_name":"wp_mab_fcm_details","description":"Stores mab fcm details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"fcm_details_id","type":"int(10)","nullable":false,"primary_key":true},{"name":"email_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"order_id","type":"int(10)","nullable":true,"primary_key":false},{"name":"cart","type":"text","nullable":true,"primary_key":false},{"name":"fcm_id","type":"text","nullable":false,"primary_key":false},{"name":"notification_sent_status","type":"int(2)","nullable":true,"primary_key":false},{"name":"last_order_status","type":"int(11)","nullable":false,"primary_key":false},{"name":"date_add","type":"datetime","nullable":false,"primary_key":false},{"name":"date_upd","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_fcm_details` (`fcm_details_id` int(10) NOT NULL AUTO_INCREMENT, `email_id` varchar(255) DEFAULT NULL, `order_id` int(10) DEFAULT NULL, `cart` text, `fcm_id` text NOT NULL, `notification_sent_status` int(2) DEFAULT NULL, `last_order_status` int(11) NOT NULL DEFAULT '0', `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`fcm_details_id`))\"));"},{"table_name":"mab_login_sessions","full_table_name":"wp_mab_login_sessions","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"session_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"session_value","type":"text","nullable":true,"primary_key":false},{"name":"reorder_direct","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_mab_login_sessions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `session_key` varchar(255) NOT NULL, `session_value` text, `reorder_direct` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"mab_mobileapp_banners","full_table_name":"wp_mab_mobileapp_banners","description":"Stores mab mobileapp banners data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"id_component","type":"int(11)","nullable":false,"primary_key":false},{"name":"id_banner_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"countdown","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(10)","nullable":true,"primary_key":false},{"name":"category_id","type":"int(10)","nullable":true,"primary_key":false},{"name":"redirect_activity","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"image_url","type":"longtext","nullable":true,"primary_key":false},{"name":"product_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"image_contentMode","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"banner_heading","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"background_color","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"is_enabled_background_color","type":"int(10)","nullable":false,"primary_key":false},{"name":"text_color","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"banner_custom_background_color","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"inset_top","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"inset_bottom","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"inset_left","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"inset_right","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"banner_width","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"banner_height","type":"varchar(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_mobileapp_banners` (`id` int(11) NOT NULL AUTO_INCREMENT, `id_component` int(11) NOT NULL, `id_banner_type` int(11) NOT NULL, `countdown` varchar(200) DEFAULT NULL, `product_id` int(10) DEFAULT NULL, `category_id` int(10) DEFAULT NULL, `redirect_activity` varchar(100) DEFAULT NULL, `image_url` longtext, `product_name` varchar(200) DEFAULT NULL, `image_contentMode` varchar(200) NOT NULL, `banner_heading` varchar(200) DEFAULT NULL, `background_color` varchar(11) DEFAULT NULL, `is_enabled_background_color` int(10) NOT NULL DEFAULT '1', `text_color` varchar(11) DEFAULT NULL, `banner_custom_background_color` varchar(11) DEFAULT NULL, `inset_top` varchar(11) DEFAULT NULL, `inset_bottom` varchar(11) DEFAULT NULL, `inset_left` varchar(11) DEFAULT NULL, `inset_right` varchar(11) DEFAULT NULL, `banner_width` varchar(11) DEFAULT NULL, `banner_height` varchar(11) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE"},{"table_name":"mab_mobileapp_layout_component","full_table_name":"wp_mab_mobileapp_layout_component","description":"Stores mab mobileapp layout component data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id_component","type":"int(11)","nullable":false,"primary_key":true},{"name":"id_layout","type":"int(11)","nullable":false,"primary_key":false},{"name":"id_component_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"position","type":"int(11)","nullable":false,"primary_key":false},{"name":"component_heading","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"component_title","type":"varchar(200)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_mobileapp_layout_component` (`id_component` int(11) NOT NULL AUTO_INCREMENT, `id_layout` int(11) NOT NULL, `id_component_type` int(11) NOT NULL, `position` int(11) NOT NULL, `component_heading` varchar(200) CHARACTER SET utf32 DEFAULT NULL, `component_title` varchar(200) CHARACTER SET utf32 COLLATE utf32_unicode_ci DEFAULT NULL, PRIMARY KEY (`id_component`)) ENGINE"},{"table_name":"mab_mobileapp_layouts","full_table_name":"wp_mab_mobileapp_layouts","description":"Stores mab mobileapp layouts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_layout","type":"int(11)","nullable":false,"primary_key":true},{"name":"layout_name","type":"varchar(200)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_mobileapp_layouts` (`id_layout` int(11) NOT NULL AUTO_INCREMENT, `layout_name` varchar(200) NOT NULL, PRIMARY KEY (`id_layout`)) ENGINE"},{"table_name":"mab_mobileapp_product_data","full_table_name":"wp_mab_mobileapp_product_data","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"product_type","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"category_products","type":"text","nullable":true,"primary_key":false},{"name":"custom_products","type":"text","nullable":true,"primary_key":false},{"name":"image_content_mode","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"number_of_products","type":"int(11)","nullable":false,"primary_key":false},{"name":"id_category","type":"int(11)","nullable":true,"primary_key":false},{"name":"id_component","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_mobileapp_product_data` (`id` int(11) NOT NULL AUTO_INCREMENT, `product_type` varchar(200) NOT NULL, `category_products` text, `custom_products` text, `image_content_mode` varchar(200) NOT NULL, `number_of_products` int(11) NOT NULL, `id_category` int(11) DEFAULT NULL, `id_component` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE"},{"table_name":"mab_mobileapp_tab_bar","full_table_name":"wp_mab_mobileapp_tab_bar","description":"Stores mab mobileapp tab bar data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"tab_icon_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"tab_icon_text","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tab_icon_image","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tab_icon_redirect_activity","type":"varchar(80)","nullable":false,"primary_key":false},{"name":"tab_bar_date_added","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_mobileapp_tab_bar` (`tab_icon_id` int(11) NOT NULL AUTO_INCREMENT, `tab_icon_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tab_icon_image` varchar(255) NOT NULL, `tab_icon_redirect_activity` varchar(80) NOT NULL, `tab_bar_date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`tab_icon_id`)) ENGINE"},{"table_name":"mab_mobileapp_top_category","full_table_name":"wp_mab_mobileapp_top_category","description":"Stores mab mobileapp top category data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"id_component","type":"int(11)","nullable":false,"primary_key":false},{"name":"id_category","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"image_url","type":"longtext","nullable":true,"primary_key":false},{"name":"image_content_mode","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"category_heading","type":"varchar(500)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_mobileapp_top_category` (`id` int(11) NOT NULL AUTO_INCREMENT, `id_component` int(11) NOT NULL, `id_category` varchar(200) NOT NULL, `image_url` longtext, `image_content_mode` varchar(200) DEFAULT NULL, `category_heading` varchar(500) CHARACTER SET utf32 DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE"},{"table_name":"mab_mobileapp_user_tokens","full_table_name":"wp_mab_mobileapp_user_tokens","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"customer_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"user_email","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"user_token","type":"TEXT","nullable":false,"primary_key":false},{"name":"added_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_used_time","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_mobileapp_user_tokens` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `customer_id` BIGINT(20) UNSIGNED NOT NULL, `user_email` VARCHAR(191) NOT NULL, `user_token` TEXT NOT NULL, `added_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `last_used_time` DATETIME DEFAULT NULL, PRIMARY KEY (`id`), KEY `customer_id` (`customer_id`), KEY `user_email` (`user_email`), KEY `user_token` (`user_token`) ) ENGINE"},{"table_name":"mab_push_notification_history","full_table_name":"wp_mab_push_notification_history","description":"Stores mab push notification history data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"notification_id","type":"int(10)","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"message","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"image_url","type":"text","nullable":false,"primary_key":false},{"name":"redirect_activity","type":"enum('home', 'category', 'product')","nullable":false,"primary_key":false},{"name":"category_id","type":"int(10)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(10)","nullable":true,"primary_key":false},{"name":"date_added","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_push_notification_history` (`notification_id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `message` varchar(500) DEFAULT NULL, `image_url` text NOT NULL, `redirect_activity` enum('home', 'category', 'product') NOT NULL, `category_id` int(10) DEFAULT NULL, `product_id` int(10) DEFAULT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`notification_id`))\"));"},{"table_name":"mab_unique_verification","full_table_name":"wp_mab_unique_verification","description":"Stores mab unique verification data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(10) UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"mobile_number","type":"varchar(15)","nullable":true,"primary_key":false},{"name":"country_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"unique_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"date_added","type":"datetime","nullable":false,"primary_key":false},{"name":"date_modified","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mab_unique_verification` (`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, `mobile_number` varchar(15) DEFAULT NULL, `country_code` varchar(10) DEFAULT NULL, `unique_id` varchar(100) DEFAULT NULL, `date_added` datetime NOT NULL, `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`))\"));"},{"table_name":"mabmobileapp_component_types","full_table_name":"wp_mabmobileapp_component_types","description":"Stores mabmobileapp component types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"component_name","type":"varchar(200)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_mabmobileapp_component_types` (`id` int(11) NOT NULL AUTO_INCREMENT, `component_name` varchar(200) NOT NULL, PRIMARY KEY (`id`)) ENGINE"}],"table_count":16}