{"slug":"pb-floats-contact-widget","name":"PB Floats Contact Widget","description":"Floating contact buttons for WhatsApp, phone, email, Telegram, and a custom link, with business hours and click analytics.","author":"pluginsbuy","active_installs":0,"version":"1.3.1","wp_org_url":"https://wordpress.org/plugins/pb-floats-contact-widget/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"fcwg_analytics","full_table_name":"wp_fcwg_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"widget_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"channel_key","type":"VARCHAR(60)","nullable":false,"primary_key":false},{"name":"event_date","type":"DATE","nullable":false,"primary_key":false},{"name":"clicks","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fcwg_analytics ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, widget_id BIGINT UNSIGNED NOT NULL, channel_key VARCHAR(60) NOT NULL, event_date DATE NOT NULL, clicks INT NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY widget_channel_date (widget_id, channel_key, event_date), KEY widget_id (widget_id), KEY event_date (event_date) ) $c;\" );"},{"table_name":"fcwg_widgets","full_table_name":"wp_fcwg_widgets","description":"Stores fcwg widgets data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('active','inactive','draft')","nullable":false,"primary_key":false},{"name":"channels","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"settings","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"priority","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"total_clicks","type":"BIGINT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fcwg_widgets ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(191) NOT NULL DEFAULT 'My Float', status ENUM('active','inactive','draft') NOT NULL DEFAULT 'draft', channels LONGTEXT, settings LONGTEXT, priority SMALLINT NOT NULL DEFAULT 10, total_clicks BIGINT NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY priority (priority) ) $c;\" );"}],"table_count":2}