{"slug":"azexo-facebook-live-chat","name":"Live Chat Marketing Automation","description":"Add Facebook Customer Chat to your site. Collect subscribers and send news or marketing offers.","author":"azexo","active_installs":0,"version":"1.27.4","wp_org_url":"https://wordpress.org/plugins/azexo-facebook-live-chat/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"azr_fb_campaigns","full_table_name":"wp_azr_fb_campaigns","description":"Stores azr fb campaigns data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"visitor_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"campaign_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"sent_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"read_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"click_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_azr_fb_campaigns ( visitor_id varchar(32) NOT NULL, campaign_id bigint(20) NOT NULL, status varchar(10), sent_timestamp int(11) unsigned, read_timestamp int(11) unsigned, click_timestamp int(11) unsigned, UNIQUE KEY campaign (campaign_id, visitor_id), KEY status (status) ) $collate;\");"},{"table_name":"azr_fb_history","full_table_name":"wp_azr_fb_history","description":"Stores azr fb history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"sender","type":"bigint(30)","nullable":false,"primary_key":false},{"name":"recipient","type":"bigint(30)","nullable":false,"primary_key":false},{"name":"timestamp","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_azr_fb_history ( sender bigint(30) NOT NULL, recipient bigint(30) NOT NULL, timestamp int(11) unsigned NOT NULL, message text, UNIQUE KEY sender (sender), UNIQUE KEY recipient (recipient) ) $collate;\");"},{"table_name":"azr_fb_visitors","full_table_name":"wp_azr_fb_visitors","description":"Stores azr fb visitors data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"visitor_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"psid","type":"bigint(30)","nullable":false,"primary_key":false},{"name":"hash","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"profile_pic","type":"varchar(300)","nullable":true,"primary_key":false},{"name":"locale","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"timezone","type":"int(2)","nullable":true,"primary_key":false},{"name":"gender","type":"varchar(10)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_azr_fb_visitors ( visitor_id varchar(32) NOT NULL, psid bigint(30) NOT NULL, hash varchar(20) NOT NULL, first_name varchar(50), last_name varchar(50), profile_pic varchar(300), locale varchar(5), timezone int(2), gender varchar(10), UNIQUE KEY visitor (visitor_id) ) $collate;\");"}],"table_count":3}