{"slug":"my-calendar","name":"My Calendar – Accessible Event Manager","description":"Accessible WordPress event calendar plugin. Manage single or recurring events, event venues, and display your calendar anywhere on your site.","author":"Joe Dolson","active_installs":20000,"version":"3.7.16","wp_org_url":"https://wordpress.org/plugins/my-calendar/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_actions` (\\n  `action_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `hook` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `scheduled_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `scheduled_date_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  `priority` tinyint unsigned NOT NULL DEFAULT '10',\\n  `args` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `schedule` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `group_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `attempts` int NOT NULL DEFAULT '0',\\n  `last_attempt_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `last_attempt_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  `claim_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `extended_args` varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`action_id`),\\n  KEY `hook_status_scheduled_date_gmt` (`hook`(163),`status`,`scheduled_date_gmt`),\\n  KEY `status_scheduled_date_gmt` (`status`,`scheduled_date_gmt`),\\n  KEY `scheduled_date_gmt` (`scheduled_date_gmt`),\\n  KEY `args` (`args`),\\n  KEY `group_id` (`group_id`),\\n  KEY `last_attempt_gmt` (`last_attempt_gmt`),\\n  KEY `claim_id_status_priority_scheduled_date_gmt` (`claim_id`,`status`,`priority`,`scheduled_date_gmt`),\\n  KEY `status_last_attempt_gmt` (`status`,`last_attempt_gmt`),\\n  KEY `status_claim_id` (`status`,`claim_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_claims","full_table_name":"wp_actionscheduler_claims","description":"Stores actionscheduler claims data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_claims` (\\n  `claim_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `date_created_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`claim_id`),\\n  KEY `date_created_gmt` (`date_created_gmt`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_groups","full_table_name":"wp_actionscheduler_groups","description":"Stores actionscheduler groups data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_groups` (\\n  `group_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`group_id`),\\n  KEY `slug` (`slug`(191))\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_logs` (\\n  `log_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `action_id` bigint unsigned NOT NULL,\\n  `message` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `log_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `log_date_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`log_id`),\\n  KEY `action_id` (`action_id`),\\n  KEY `log_date_gmt` (`log_date_gmt`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"calendar","full_table_name":"wp_calendar","description":"Stores calendar data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"calendar_categories","full_table_name":"wp_calendar_categories","description":"Stores calendar categories data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"my_calendar","full_table_name":"wp_my_calendar","description":"Stores my calendar data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_my_calendar` (\\n  `event_id` int NOT NULL AUTO_INCREMENT,\\n  `event_begin` date NOT NULL,\\n  `event_end` date NOT NULL,\\n  `event_title` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_desc` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_short` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_registration` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_tickets` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_time` time DEFAULT NULL,\\n  `event_endtime` time DEFAULT NULL,\\n  `event_recur` char(3) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `event_repeats` text COLLATE utf8mb4_unicode_520_ci,\\n  `event_status` int NOT NULL DEFAULT '1',\\n  `event_author` bigint unsigned DEFAULT NULL,\\n  `event_host` bigint unsigned DEFAULT NULL,\\n  `event_category` bigint unsigned NOT NULL DEFAULT '1',\\n  `event_link` text COLLATE utf8mb4_unicode_520_ci,\\n  `event_post` bigint unsigned NOT NULL DEFAULT '0',\\n  `event_link_expires` tinyint(1) NOT NULL,\\n  `event_location` bigint unsigned NOT NULL DEFAULT '0',\\n  `event_label` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_street` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_street2` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_city` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_state` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_postcode` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_region` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_country` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_url` text COLLATE utf8mb4_unicode_520_ci,\\n  `event_longitude` float(10,6) NOT NULL DEFAULT '0.000000',\\n  `event_latitude` float(10,6) NOT NULL DEFAULT '0.000000',\\n  `event_zoom` int NOT NULL DEFAULT '14',\\n  `event_phone` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_phone2` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_access` text COLLATE utf8mb4_unicode_520_ci,\\n  `event_group_id` int NOT NULL DEFAULT '0',\\n  `event_span` int NOT NULL DEFAULT '0',\\n  `event_approved` int NOT NULL DEFAULT '1',\\n  `event_flagged` int NOT NULL DEFAULT '0',\\n  `event_hide_end` int NOT NULL DEFAULT '0',\\n  `event_holiday` int NOT NULL DEFAULT '0',\\n  `event_fifth_week` int NOT NULL DEFAULT '1',\\n  `event_image` text COLLATE utf8mb4_unicode_520_ci,\\n  `event_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`event_id`),\\n  KEY `event_category` (`event_category`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"my_calendar_categories","full_table_name":"wp_my_calendar_categories","description":"Stores my calendar categories data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_my_calendar_categories` (\\n  `category_id` int NOT NULL AUTO_INCREMENT,\\n  `category_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `category_color` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `category_icon` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `category_private` int NOT NULL DEFAULT '0',\\n  `category_term` int NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`category_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"my_calendar_category_relationships","full_table_name":"wp_my_calendar_category_relationships","description":"Stores my calendar category relationships data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_my_calendar_category_relationships` (\\n  `relationship_id` int NOT NULL AUTO_INCREMENT,\\n  `event_id` int NOT NULL,\\n  `category_id` int NOT NULL DEFAULT '1',\\n  PRIMARY KEY (`relationship_id`),\\n  KEY `event_id` (`event_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"my_calendar_events","full_table_name":"wp_my_calendar_events","description":"Stores my calendar events data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_my_calendar_events` (\\n  `occur_id` int NOT NULL AUTO_INCREMENT,\\n  `occur_event_id` int NOT NULL,\\n  `occur_begin` datetime NOT NULL,\\n  `occur_end` datetime NOT NULL,\\n  `occur_group_id` int NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`occur_id`),\\n  KEY `occur_event_id` (`occur_event_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"my_calendar_location_relationships","full_table_name":"wp_my_calendar_location_relationships","description":"Stores my calendar location relationships data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_my_calendar_location_relationships` (\\n  `relationship_id` int NOT NULL AUTO_INCREMENT,\\n  `location_id` int NOT NULL,\\n  `post_id` int NOT NULL DEFAULT '1',\\n  PRIMARY KEY (`relationship_id`),\\n  KEY `location_id` (`location_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"my_calendar_locations","full_table_name":"wp_my_calendar_locations","description":"Stores my calendar locations data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_my_calendar_locations` (\\n  `location_id` int NOT NULL AUTO_INCREMENT,\\n  `location_label` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_street` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_street2` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_city` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_state` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_postcode` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_region` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_url` text COLLATE utf8mb4_unicode_520_ci,\\n  `location_country` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_longitude` float(10,6) NOT NULL DEFAULT '0.000000',\\n  `location_latitude` float(10,6) NOT NULL DEFAULT '0.000000',\\n  `location_zoom` int NOT NULL DEFAULT '14',\\n  `location_phone` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_phone2` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location_access` text COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`location_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":12}