wp_amelia_customer_bookings
LiveStores amelia customer bookings data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_amelia_customer_bookings` (\n `id` int NOT NULL AUTO_INCREMENT,\n `appointmentId` int DEFAULT NULL,\n `customerId` int NOT NULL,\n `status` enum('approved','pending','canceled','rejected','no-show','waiting') DEFAULT NULL,\n `price` double NOT NULL,\n `tax` varchar(255) DEFAULT NULL,\n `persons` int NOT NULL,\n `couponId` int DEFAULT NULL,\n `token` varchar(10) DEFAULT NULL,\n `customFields` text,\n `info` text,\n `utcOffset` int DEFAULT NULL,\n `aggregatedPrice` tinyint(1) DEFAULT '1',\n `packageCustomerServiceId` int DEFAULT NULL,\n `duration` int DEFAULT NULL,\n `created` datetime DEFAULT NULL,\n `actionsCompleted` tinyint(1) DEFAULT NULL,\n `qrCodes` text,\n PRIMARY KEY (`id`)\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_customer_bookings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Booking for Appointments and Events Calendar – Amelia