wp_amelia_services

Live

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

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

Other tables from Booking for Appointments and Events Calendar – Amelia