wp_amelia_services
LiveStores amelia services data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_amelia_services` (\n `id` int NOT NULL AUTO_INCREMENT,\n `name` varchar(255) NOT NULL DEFAULT '',\n `description` mediumtext,\n `color` varchar(255) NOT NULL DEFAULT '',\n `price` double NOT NULL,\n `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',\n `categoryId` int NOT NULL,\n `minCapacity` int NOT NULL,\n `maxCapacity` int NOT NULL,\n `duration` int NOT NULL,\n `timeBefore` int DEFAULT '0',\n `timeAfter` int DEFAULT '0',\n `bringingAnyone` tinyint(1) DEFAULT '1',\n `priority` enum('least_expensive','most_expensive','least_occupied','most_occupied') NOT NULL,\n `pictureFullPath` varchar(767) DEFAULT NULL,\n `pictureThumbPath` varchar(767) DEFAULT NULL,\n `position` int DEFAULT '0',\n `show` tinyint(1) DEFAULT '1',\n `aggregatedPrice` tinyint(1) DEFAULT '1',\n `settings` mediumtext,\n `recurringCycle` enum('disabled','all','daily','weekly','monthly') DEFAULT 'disabled',\n `recurringSub` enum('disabled','past','future','both') DEFAULT 'future',\n `recurringPayment` int DEFAULT '0',\n `translations` text,\n `depositPayment` enum('disabled','fixed','percentage') DEFAULT 'disabled',\n `depositPerPerson` tinyint(1) DEFAULT '1',\n `deposit` double DEFAULT '0',\n `fullPayment` tinyint(1) DEFAULT '0',\n `mandatoryExtra` tinyint(1) DEFAULT '0',\n `minSelectedExtras` int DEFAULT '0',\n `customPricing` text,\n `maxExtraPeople` int DEFAULT NULL,\n `limitPerCustomer` 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_services`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Booking for Appointments and Events Calendar – Amelia