wp_my_calendar
VerifiedStores my calendar data created by this plugin.
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled My Calendar – Accessible Event Manager, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_my_calendar`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from My Calendar – Accessible Event Manager