{"slug":"hexagonal-reviews","name":"Hexagonal Reviews","description":"The plugin permits you to append reviews on the posts using a shortcode, and manage it's publications on the admin area.","author":"warguns86","active_installs":0,"version":"1.2.13","wp_org_url":"https://wordpress.org/plugins/hexagonal-reviews/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"hexagonal_review","full_table_name":"wp_hexagonal_review","description":"Stores hexagonal review data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"uuid","type":"varchar(300)","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"content","type":"mediumtext","nullable":true,"primary_key":false},{"name":"author","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"stars","type":"float","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"updated_at","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hexagonal_review` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(300) NOT NULL DEFAULT '', `post_id` bigint(20) unsigned DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `content` mediumtext CHARACTER SET latin1 COLLATE latin1_bin, `author` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `stars` float NOT NULL, `email` varchar(255) DEFAULT NULL, `created_at` varchar(255) NOT NULL DEFAULT '', `updated_at` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uuid` (`uuid`), KEY `relations` (`post_id`), CONSTRAINT `relations` FOREIGN KEY (`post_id`) REFERENCES `wp_posts` (`ID`) ) ENGINE"},{"table_name":"hexagonal_review_average","full_table_name":"wp_hexagonal_review_average","description":"Stores hexagonal review average data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"post_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"review_count","type":"int(11)","nullable":true,"primary_key":false},{"name":"total_review","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hexagonal_review_average` ( `post_id` bigint(20) unsigned NOT NULL, `review_count` int(11) DEFAULT '0', `total_review` int(11) DEFAULT '0', PRIMARY KEY (`post_id`), CONSTRAINT `post_id` FOREIGN KEY (`post_id`) REFERENCES `wp_posts` (`ID`) ) ENGINE"}],"table_count":2}