wp_amelia_customer_bookings

Live

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