wp_p2p_relationships
VerifiedStores p2p relationships data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| type | VARCHAR(42) | NO |
| rel_from | BIGINT UNSIGNED | NO |
| rel_to | BIGINT UNSIGNED | NO |
| p2p_relationship_id | BIGINT UNSIGNED | NO |
| meta_key | VARCHAR(191) | YES |
| meta_value | longtext | YES |
CREATE TABLE Statement
CREATE TABLE `wp_p2p_relationships` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `type` varchar(42) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n `rel_from` bigint unsigned NOT NULL,\n `rel_to` bigint unsigned NOT NULL,\n PRIMARY KEY (`id`),\n KEY `type` (`type`),\n KEY `rel_from` (`rel_from`),\n KEY `rel_to` (`rel_to`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
Safe to delete?
If you have uninstalled AweBooking – Hotel Booking System, 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_p2p_relationships`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AweBooking – Hotel Booking System