{"slug":"infobarwp","name":"InfobarWP","description":"Create fully customizable notification bars, rotate different variants and target specific pages and posts on your website.","author":"bertranddo","active_installs":10,"version":"1.0","wp_org_url":"https://wordpress.org/plugins/infobarwp/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"infobar_campaigns","full_table_name":"wp_infobar_campaigns","description":"Stores infobar campaigns data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"int_title_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"str_title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"start_date","type":"datetime","nullable":false,"primary_key":false},{"name":"end_date","type":"datetime","nullable":false,"primary_key":false},{"name":"duration","type":"int(11)","nullable":false,"primary_key":false},{"name":"show_where","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"link_target","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"display_on","type":"int(11)","nullable":false,"primary_key":false},{"name":"browsers","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"status","type":"int(11)","nullable":false,"primary_key":false},{"name":"imp","type":"int(11)","nullable":false,"primary_key":false},{"name":"loadtime","type":"int(11)","nullable":false,"primary_key":false},{"name":"closetime","type":"int(11)","nullable":false,"primary_key":false},{"name":"tracking","type":"int(11)","nullable":false,"primary_key":false},{"name":"track_imps","type":"int(11)","nullable":false,"primary_key":false},{"name":"dated","type":"timestamp","nullable":false,"primary_key":false},{"name":"last_shown","type":"timestamp","nullable":false,"primary_key":false},{"name":"cookie_name","type":"varchar(100)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE infobar_campaigns ( `int_title_id` int(11) NOT NULL AUTO_INCREMENT, `str_title` varchar(255) NOT NULL, `start_date` datetime NOT NULL, `end_date` datetime NOT NULL, `duration` int(11) NOT NULL DEFAULT '0', `show_where` varchar(255) NOT NULL, `link_target` tinyint(4) NOT NULL, `display_on` int(11) NOT NULL, `browsers` varchar(100) NOT NULL DEFAULT 'All', `status` int(11) NOT NULL DEFAULT '1', `imp` int(11) NOT NULL DEFAULT '1', `loadtime` int(11) NOT NULL DEFAULT '1', `closetime` int(11) NOT NULL DEFAULT '1', `tracking` int(11) NOT NULL DEFAULT '0', `track_imps` int(11) NOT NULL DEFAULT '0', `dated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_shown` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `cookie_name` varchar(100) NOT NULL DEFAULT 'infobar', PRIMARY KEY (`int_title_id`) ) ENGINE"},{"table_name":"infobar_exclude_pages","full_table_name":"wp_infobar_exclude_pages","description":"Stores infobar exclude pages data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"campaign_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"link_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `infobar_exclude_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` int(11) NOT NULL, `type` varchar(50) NOT NULL, `link_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"infobar_link_pages","full_table_name":"wp_infobar_link_pages","description":"Stores infobar link pages data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"campaign_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"link_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `infobar_link_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` int(11) NOT NULL, `link_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"infobar_session","full_table_name":"wp_infobar_session","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[{"name":"int_session_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"int_title_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `infobar_session` ( `int_session_id` int(11) NOT NULL, `int_title_id` int(11) NOT NULL ) ENGINE"},{"table_name":"infobar_variants","full_table_name":"wp_infobar_variants","description":"Stores infobar variants data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"int_message_id","type":"smallint(16)","nullable":false,"primary_key":true},{"name":"int_title_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"str_message","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"link_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"str_link_text","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"str_link_img","type":"text","nullable":false,"primary_key":false},{"name":"str_link_url","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"str_options","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"theme","type":"int(11)","nullable":false,"primary_key":false},{"name":"int_active","type":"int(11)","nullable":false,"primary_key":false},{"name":"dated","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `infobar_variants` ( `int_message_id` smallint(16) NOT NULL AUTO_INCREMENT, `int_title_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `str_message` varchar(255) NOT NULL, `link_type` int(11) NOT NULL DEFAULT '0', `str_link_text` varchar(255) NOT NULL, `str_link_img` text NOT NULL, `str_link_url` varchar(255) NOT NULL, `str_options` varchar(255) NOT NULL, `theme` int(11) NOT NULL, `int_active` int(11) NOT NULL DEFAULT '1', `dated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY `int_message_id` (`int_message_id`) ) ENGINE"}],"table_count":5}