wp_amelia_events

Live

Stores 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=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_events`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Booking for Appointments and Events Calendar – Amelia