wp_amelia_notifications_sms_history
LiveStores amelia notifications sms history data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_amelia_notifications_sms_history` (\n `id` int NOT NULL AUTO_INCREMENT,\n `notificationId` int NOT NULL,\n `userId` int DEFAULT NULL,\n `appointmentId` int DEFAULT NULL,\n `eventId` int DEFAULT NULL,\n `packageCustomerId` int DEFAULT NULL,\n `logId` int DEFAULT NULL,\n `dateTime` datetime DEFAULT NULL,\n `text` varchar(1600) NOT NULL,\n `phone` varchar(63) NOT NULL,\n `alphaSenderId` varchar(11) NOT NULL,\n `status` enum('prepared','accepted','queued','sent','failed','delivered','undelivered') NOT NULL DEFAULT 'prepared',\n `price` double DEFAULT NULL,\n `segments` tinyint DEFAULT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `id` (`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_notifications_sms_history`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Booking for Appointments and Events Calendar – Amelia