wp_amelia_events
LiveStores amelia events data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_amelia_events` (\n `id` int NOT NULL AUTO_INCREMENT,\n `parentId` bigint DEFAULT NULL,\n `name` varchar(255) NOT NULL DEFAULT '',\n `status` enum('approved','pending','canceled','rejected') NOT NULL,\n `bookingOpens` datetime DEFAULT NULL,\n `bookingCloses` datetime DEFAULT NULL,\n `bookingOpensRec` enum('same','calculate') DEFAULT 'same',\n `bookingClosesRec` enum('same','calculate') DEFAULT 'same',\n `ticketRangeRec` enum('same','calculate') DEFAULT 'calculate',\n `recurringCycle` enum('daily','weekly','monthly','yearly') DEFAULT NULL,\n `recurringOrder` int DEFAULT NULL,\n `recurringInterval` int DEFAULT '1',\n `recurringMonthly` enum('each','on') DEFAULT 'each',\n `monthlyDate` datetime DEFAULT NULL,\n `monthlyOnRepeat` enum('first','second','third','fourth','fifth','last') DEFAULT NULL,\n `monthlyOnDay` enum('monday','tuesday','wednesday','thursday','friday','saturday','sunday') DEFAULT NULL,\n `recurringUntil` datetime DEFAULT NULL,\n `maxCapacity` int NOT NULL,\n `maxCustomCapacity` int DEFAULT NULL,\n `maxExtraPeople` int DEFAULT NULL,\n `price` double NOT NULL,\n `locationId` bigint DEFAULT NULL,\n `customLocation` varchar(255) DEFAULT NULL,\n `description` mediumtext,\n `color` varchar(255) DEFAULT NULL,\n `show` tinyint(1) NOT NULL DEFAULT '1',\n `notifyParticipants` tinyint(1) NOT NULL,\n `created` datetime NOT NULL,\n `settings` mediumtext,\n `zoomUserId` varchar(255) DEFAULT NULL,\n `bringingAnyone` tinyint(1) DEFAULT '1',\n `bookMultipleTimes` tinyint(1) DEFAULT '1',\n `translations` text,\n `depositPayment` enum('disabled','fixed','percentage') DEFAULT 'disabled',\n `depositPerPerson` tinyint(1) DEFAULT '1',\n `fullPayment` tinyint(1) DEFAULT '0',\n `deposit` double DEFAULT '0',\n `customPricing` tinyint(1) DEFAULT '0',\n `organizerId` bigint DEFAULT NULL,\n `closeAfterMin` int DEFAULT NULL,\n `closeAfterMinBookings` tinyint(1) DEFAULT '0',\n `aggregatedPrice` tinyint(1) DEFAULT '1',\n `error` mediumtext,\n `pictureFullPath` varchar(767) DEFAULT NULL,\n `pictureThumbPath` varchar(767) DEFAULT NULL,\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_events`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Booking for Appointments and Events Calendar – Amelia