{"slug":"robo-ivr-call-pakistan","name":"Robo IVR Call Pakistan","description":"Automated Order Confirmation:","author":"H3 Technologies","active_installs":10,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/robo-ivr-call-pakistan/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bsp_robo_logs","full_table_name":"wp_bsp_robo_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bsp_robo_logs` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `shop_url` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `order_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `order_id` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `order_number` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `order_phone` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `order_total` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `order_gateway` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_provider` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_datetime` datetime DEFAULT NULL,\\n  `ivr_id` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_api` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_response` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_api_return` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_retry` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_call` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_status` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ivr_logs` text COLLATE utf8mb4_unicode_520_ci,\\n  `ivr_call_que` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `shop_url` (`shop_url`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bsp_robo_settings","full_table_name":"wp_bsp_robo_settings","description":"Stores bsp robo settings data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bsp_robo_settings` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `bspivr_email` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `bspivr_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `bspivr_voiceid` int DEFAULT NULL,\\n  `enable_confirmed_order` tinyint(1) DEFAULT '1',\\n  `enable_cancelled_order` tinyint(1) DEFAULT '1',\\n  `enable_callback_order` tinyint(1) DEFAULT '1',\\n  `enable_auto_call` tinyint(1) DEFAULT '1',\\n  `billing_phone` tinyint(1) DEFAULT '0',\\n  `international_calls` tinyint(1) DEFAULT '0',\\n  `cod` tinyint(1) DEFAULT '0',\\n  `bacs` tinyint(1) DEFAULT '0',\\n  `cheque` tinyint(1) DEFAULT '0',\\n  `other` tinyint(1) DEFAULT '0',\\n  `calltime` tinyint DEFAULT '0',\\n  `starttime` varchar(15) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',\\n  `endtime` varchar(15) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',\\n  `reattempt` int DEFAULT '0',\\n  `reattempt1` int DEFAULT '0',\\n  `reattempt2` int DEFAULT '0',\\n  `reattempt3` int DEFAULT '0',\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":2}