{"slug":"easy-ad-picker","name":"Easy Ad Picker","description":"EASY ADVERTISING WITH EASY AD PICKER","author":"EasyAdPicker","active_installs":10,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/easy-ad-picker/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"easyadpicker_advertiser_properties","full_table_name":"wp_easyadpicker_advertiser_properties","description":"Stores easyadpicker advertiser properties data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"advertiser_property_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"advertiser_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"priority","type":"int(11)","nullable":false,"primary_key":false},{"name":"best_deal","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_easyadpicker_advertiser_properties` ( `advertiser_property_id` int(11) NOT NULL, `advertiser_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `priority` int(11) NOT NULL, `best_deal` tinyint(1) NOT NULL ) ENGINE"},{"table_name":"easyadpicker_advertisers","full_table_name":"wp_easyadpicker_advertisers","description":"Stores easyadpicker advertisers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"advertiser_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"advertiser","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"bulk_import","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"last_import_products","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_easyadpicker_advertisers` ( `advertiser_id` int(11) NOT NULL, `advertiser` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `bulk_import` tinyint(1) NOT NULL DEFAULT '1', `last_import_products` int(11) NOT NULL ) ENGINE"},{"table_name":"easyadpicker_material_words","full_table_name":"wp_easyadpicker_material_words","description":"Stores easyadpicker material words data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"advertiser_material_word_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"advertiser_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"material_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"word","type":"varchar(20)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_easyadpicker_material_words` ( `advertiser_material_word_id` int(11) NOT NULL, `advertiser_id` int(11) NOT NULL, `material_id` int(11) NOT NULL, `word` varchar(20) NOT NULL ) ENGINE"},{"table_name":"easyadpicker_materials","full_table_name":"wp_easyadpicker_materials","description":"Stores easyadpicker materials data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"material_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"advertiser_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"material","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"link","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"display","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"width","type":"int(3)","nullable":false,"primary_key":false},{"name":"height","type":"int(3)","nullable":false,"primary_key":false},{"name":"date","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_easyadpicker_materials` ( `material_id` int(11) NOT NULL, `advertiser_id` int(11) NOT NULL, `title` varchar(100) NOT NULL, `material` varchar(255) NOT NULL, `link` varchar(255) NOT NULL, `display` varchar(10) NOT NULL, `width` int(3) NOT NULL, `height` int(3) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"easyadpicker_post_ads","full_table_name":"wp_easyadpicker_post_ads","description":"Stores easyadpicker post ads data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"post_ad_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ad","type":"varchar(15)","nullable":false,"primary_key":false},{"name":"words","type":"text","nullable":false,"primary_key":false},{"name":"filters","type":"text","nullable":false,"primary_key":false},{"name":"date","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_easyadpicker_post_ads` ( `post_ad_id` int(11) NOT NULL, `post_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `ad` varchar(15) NOT NULL, `words` text NOT NULL, `filters` text NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE"},{"table_name":"easyadpicker_product_words","full_table_name":"wp_easyadpicker_product_words","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"advertiser_product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"advertiser_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"column_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"word","type":"varchar(70)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_easyadpicker_product_words` ( `advertiser_product_id` int(11) NOT NULL, `advertiser_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `column_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `word` varchar(70) NOT NULL ) ENGINE"},{"table_name":"easyadpicker_products","full_table_name":"wp_easyadpicker_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"advertiser_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"advertiser_property_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"search","type":"varchar(125)","nullable":false,"primary_key":false},{"name":"material","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"link","type":"text","nullable":false,"primary_key":false},{"name":"price","type":"decimal(6,2)","nullable":false,"primary_key":false},{"name":"price_old","type":"decimal(6,2)","nullable":false,"primary_key":false},{"name":"unique_id","type":"varchar(35)","nullable":false,"primary_key":false},{"name":"date","type":"int(11)","nullable":false,"primary_key":false},{"name":"new","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_easyadpicker_products` ( `product_id` int(11) NOT NULL, `advertiser_id` int(11) NOT NULL, `advertiser_property_id` int(11) NOT NULL, `title` varchar(100) NOT NULL, `search` varchar(125) NOT NULL, `material` varchar(255) NOT NULL, `link` text NOT NULL, `price` decimal(6,2) NOT NULL, `price_old` decimal(6,2) NOT NULL, `unique_id` varchar(35) NOT NULL, `date` int(11) NOT NULL, `new` tinyint(1) NOT NULL ) ENGINE"},{"table_name":"easyadpicker_stats_clicks","full_table_name":"wp_easyadpicker_stats_clicks","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"stats_clicks_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"post_ad_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"clicks","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_easyadpicker_stats_clicks` ( `stats_clicks_id` int(11) NOT NULL, `post_ad_id` int(11) NOT NULL, `post_id` int(11) NOT NULL, `clicks` int(11) NOT NULL DEFAULT '1', `date` int(11) NOT NULL ) ENGINE"}],"table_count":8}