wp_amelia_users
LiveStores amelia users data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_amelia_users` (\n `id` int NOT NULL AUTO_INCREMENT,\n `status` enum('hidden','visible','disabled','blocked') NOT NULL DEFAULT 'visible',\n `type` enum('customer','provider','manager','admin') NOT NULL,\n `externalId` bigint DEFAULT NULL,\n `firstName` varchar(255) NOT NULL DEFAULT '',\n `lastName` varchar(255) NOT NULL DEFAULT '',\n `email` varchar(255) DEFAULT NULL,\n `birthday` date DEFAULT NULL,\n `phone` varchar(63) DEFAULT NULL,\n `gender` enum('male','female') DEFAULT NULL,\n `note` text,\n `description` text,\n `pictureFullPath` varchar(767) DEFAULT NULL,\n `pictureThumbPath` varchar(767) DEFAULT NULL,\n `password` varchar(128) DEFAULT NULL,\n `usedTokens` text,\n `zoomUserId` varchar(255) DEFAULT NULL,\n `stripeConnect` varchar(255) DEFAULT NULL,\n `countryPhoneIso` varchar(2) DEFAULT NULL,\n `translations` text,\n `customFields` text,\n `timeZone` varchar(255) DEFAULT NULL,\n `appleCalendarId` varchar(255) DEFAULT NULL,\n `employeeAppleCalendar` text,\n `googleCalendarId` varchar(255) DEFAULT NULL,\n `outlookCalendarId` varchar(255) DEFAULT NULL,\n `badgeId` int DEFAULT NULL,\n `error` mediumtext,\n `show` tinyint(1) DEFAULT '1',\n PRIMARY KEY (`id`),\n UNIQUE KEY `id` (`id`),\n UNIQUE KEY `email` (`email`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3Safe to delete?
If you have uninstalled Booking for Appointments and Events Calendar – Amelia, 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_amelia_users`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Booking for Appointments and Events Calendar – Amelia