{"slug":"gdpr-cookie-consent","name":"Cookie Banner for GDPR / CCPA – WPLP Cookie Consent","description":"WPLP Cookie Consent helps WordPress website owners display cookie consent banners, manage user preferences, and control third-party scripts in line wi …","author":"WP Legal Pages","active_installs":9000,"version":"4.3.6","wp_org_url":"https://wordpress.org/plugins/gdpr-cookie-consent/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"gdpr_cookie_post_cookies","full_table_name":"wp_gdpr_cookie_post_cookies","description":"Stores gdpr cookie post cookies data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_gdpr_cookie_post_cookies` (\\n  `id_gdpr_cookie_post_cookies` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) NOT NULL,\\n  `domain` varchar(255) NOT NULL,\\n  `duration` varchar(255) NOT NULL,\\n  `type` varchar(255) NOT NULL,\\n  `category` varchar(255) NOT NULL,\\n  `category_id` int NOT NULL,\\n  `description` text,\\n  PRIMARY KEY (`id_gdpr_cookie_post_cookies`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"gdpr_cookie_scan_categories","full_table_name":"wp_gdpr_cookie_scan_categories","description":"Stores gdpr cookie scan categories data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_gdpr_cookie_scan_categories` (\\n  `id_gdpr_cookie_category` int NOT NULL AUTO_INCREMENT,\\n  `gdpr_cookie_category_name` varchar(50) NOT NULL,\\n  `gdpr_cookie_category_slug` varchar(50) NOT NULL,\\n  `gdpr_cookie_category_description` text,\\n  PRIMARY KEY (`id_gdpr_cookie_category`),\\n  UNIQUE KEY `cookie` (`gdpr_cookie_category_name`)\\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"wpl_cookie_scan","full_table_name":"wp_wpl_cookie_scan","description":"Stores wpl cookie scan data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_wpl_cookie_scan` (\\n  `id_wpl_cookie_scan` int NOT NULL AUTO_INCREMENT,\\n  `status` int NOT NULL DEFAULT '0',\\n  `created_at` int NOT NULL DEFAULT '0',\\n  `total_url` int NOT NULL DEFAULT '0',\\n  `total_cookies` int NOT NULL DEFAULT '0',\\n  `total_category` int NOT NULL DEFAULT '0',\\n  `current_action` varchar(50) NOT NULL,\\n  `current_offset` int NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id_wpl_cookie_scan`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"wpl_cookie_scan_cookies","full_table_name":"wp_wpl_cookie_scan_cookies","description":"Stores wpl cookie scan cookies data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_wpl_cookie_scan_cookies` (\\n  `id_wpl_cookie_scan_cookies` int NOT NULL AUTO_INCREMENT,\\n  `id_wpl_cookie_scan` int NOT NULL DEFAULT '0',\\n  `id_wpl_cookie_scan_url` int NOT NULL DEFAULT '0',\\n  `name` varchar(50) NOT NULL,\\n  `domain` varchar(255) NOT NULL DEFAULT '',\\n  `duration` varchar(255) DEFAULT NULL,\\n  `type` varchar(255) DEFAULT NULL,\\n  `category` varchar(50) NOT NULL,\\n  `category_id` int NOT NULL,\\n  `description` text,\\n  PRIMARY KEY (`id_wpl_cookie_scan_cookies`),\\n  UNIQUE KEY `cookie` (`id_wpl_cookie_scan`,`name`),\\n  KEY `category_id` (`category_id`),\\n  CONSTRAINT `wp_wpl_cookie_scan_cookies_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `wp_gdpr_cookie_scan_categories` (`id_gdpr_cookie_category`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"wpl_cookie_scan_url","full_table_name":"wp_wpl_cookie_scan_url","description":"Stores wpl cookie scan url data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_wpl_cookie_scan_url` (\\n  `id_wpl_cookie_scan_url` int NOT NULL AUTO_INCREMENT,\\n  `id_wpl_cookie_scan` int NOT NULL DEFAULT '0',\\n  `url` text NOT NULL,\\n  `scanned` int NOT NULL DEFAULT '0',\\n  `total_cookies` int NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id_wpl_cookie_scan_url`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"wpl_cookie_scripts","full_table_name":"wp_wpl_cookie_scripts","description":"Stores wpl cookie scripts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_wpl_cookie_scripts` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `script_title` text NOT NULL,\\n  `script_category` int NOT NULL,\\n  `script_status` tinyint(1) NOT NULL,\\n  `script_description` longtext NOT NULL,\\n  `script_key` varchar(100) NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"wpl_data_req","full_table_name":"wp_wpl_data_req","description":"Stores wpl data req data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":7}