wp_my_calendar_locations

Verified

Stores my calendar locations data created by this plugin.

CREATE TABLE Statement

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

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_locations`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from My Calendar – Accessible Event Manager