{"slug":"community-events","name":"Community Events","description":"The purpose of this plugin is to allow users to create a schedule of upcoming events and display events for the next 7 days in an AJAX-driven box or d …","author":"Yannick Lefebvre","active_installs":20,"version":"1.5.9","wp_org_url":"https://wordpress.org/plugins/community-events/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ce_category","full_table_name":"wp_ce_category","description":"Stores ce category data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ce_category` (\\n  `event_cat_id` bigint NOT NULL AUTO_INCREMENT,\\n  `event_cat_name` varchar(255) DEFAULT NULL,\\n  PRIMARY KEY (`event_cat_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"ce_events","full_table_name":"wp_ce_events","description":"Stores ce events data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ce_events` (\\n  `event_id` bigint NOT NULL AUTO_INCREMENT,\\n  `event_name` varchar(255) DEFAULT NULL,\\n  `event_start_date` date DEFAULT NULL,\\n  `event_start_hour` int DEFAULT NULL,\\n  `event_start_minute` int(2) unsigned zerofill DEFAULT NULL,\\n  `event_start_ampm` varchar(2) DEFAULT NULL,\\n  `event_end_date` date DEFAULT NULL,\\n  `event_description` varchar(140) DEFAULT NULL,\\n  `event_url` varchar(255) DEFAULT NULL,\\n  `event_ticket_url` varchar(256) DEFAULT NULL,\\n  `event_venue` int DEFAULT NULL,\\n  `event_category` int DEFAULT NULL,\\n  `event_published` varchar(1) DEFAULT NULL,\\n  `event_submitter` varchar(60) DEFAULT NULL,\\n  `event_click_count` int DEFAULT NULL,\\n  `event_end_hour` int DEFAULT NULL,\\n  `event_end_minute` int(2) unsigned zerofill DEFAULT NULL,\\n  `event_end_ampm` varchar(2) DEFAULT NULL,\\n  UNIQUE KEY `event_id` (`event_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"ce_venues","full_table_name":"wp_ce_venues","description":"Stores ce venues data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ce_venues` (\\n  `ce_venue_id` bigint NOT NULL AUTO_INCREMENT,\\n  `ce_venue_name` varchar(256) DEFAULT NULL,\\n  `ce_venue_address` varchar(256) DEFAULT NULL,\\n  `ce_venue_city` varchar(256) DEFAULT NULL,\\n  `ce_venue_zipcode` varchar(256) DEFAULT NULL,\\n  `ce_venue_phone` varchar(256) DEFAULT NULL,\\n  `ce_venue_email` varchar(256) DEFAULT NULL,\\n  `ce_venue_url` varchar(256) DEFAULT NULL,\\n  PRIMARY KEY (`ce_venue_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"}],"table_count":3}