wp_amelia_users

Live

Stores 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=utf8mb3

Safe 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