{"slug":"awebooking","name":"AweBooking – Hotel Booking System","description":"Awebooking helps you to setup hotel booking system quickly, pleasantly and easily.","author":"awethemes","active_installs":1000,"version":"3.2.26","wp_org_url":"https://wordpress.org/plugins/awebooking/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"awebooking_availability","full_table_name":"wp_awebooking_availability","description":"Stores awebooking availability data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_awebooking_availability` (\\n  `room_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `year` smallint unsigned NOT NULL DEFAULT '0',\\n  `month` tinyint unsigned NOT NULL DEFAULT '0',\\n  `d1` bigint unsigned NOT NULL DEFAULT '0',\\n  `d2` bigint unsigned NOT NULL DEFAULT '0',\\n  `d3` bigint unsigned NOT NULL DEFAULT '0',\\n  `d4` bigint unsigned NOT NULL DEFAULT '0',\\n  `d5` bigint unsigned NOT NULL DEFAULT '0',\\n  `d6` bigint unsigned NOT NULL DEFAULT '0',\\n  `d7` bigint unsigned NOT NULL DEFAULT '0',\\n  `d8` bigint unsigned NOT NULL DEFAULT '0',\\n  `d9` bigint unsigned NOT NULL DEFAULT '0',\\n  `d10` bigint unsigned NOT NULL DEFAULT '0',\\n  `d11` bigint unsigned NOT NULL DEFAULT '0',\\n  `d12` bigint unsigned NOT NULL DEFAULT '0',\\n  `d13` bigint unsigned NOT NULL DEFAULT '0',\\n  `d14` bigint unsigned NOT NULL DEFAULT '0',\\n  `d15` bigint unsigned NOT NULL DEFAULT '0',\\n  `d16` bigint unsigned NOT NULL DEFAULT '0',\\n  `d17` bigint unsigned NOT NULL DEFAULT '0',\\n  `d18` bigint unsigned NOT NULL DEFAULT '0',\\n  `d19` bigint unsigned NOT NULL DEFAULT '0',\\n  `d20` bigint unsigned NOT NULL DEFAULT '0',\\n  `d21` bigint unsigned NOT NULL DEFAULT '0',\\n  `d22` bigint unsigned NOT NULL DEFAULT '0',\\n  `d23` bigint unsigned NOT NULL DEFAULT '0',\\n  `d24` bigint unsigned NOT NULL DEFAULT '0',\\n  `d25` bigint unsigned NOT NULL DEFAULT '0',\\n  `d26` bigint unsigned NOT NULL DEFAULT '0',\\n  `d27` bigint unsigned NOT NULL DEFAULT '0',\\n  `d28` bigint unsigned NOT NULL DEFAULT '0',\\n  `d29` bigint unsigned NOT NULL DEFAULT '0',\\n  `d30` bigint unsigned NOT NULL DEFAULT '0',\\n  `d31` bigint unsigned NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`room_id`,`year`,`month`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"awebooking_booking","full_table_name":"wp_awebooking_booking","description":"Stores awebooking booking data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_awebooking_booking` (\\n  `room_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `year` smallint unsigned NOT NULL DEFAULT '0',\\n  `month` tinyint unsigned NOT NULL DEFAULT '0',\\n  `d1` bigint unsigned NOT NULL DEFAULT '0',\\n  `d2` bigint unsigned NOT NULL DEFAULT '0',\\n  `d3` bigint unsigned NOT NULL DEFAULT '0',\\n  `d4` bigint unsigned NOT NULL DEFAULT '0',\\n  `d5` bigint unsigned NOT NULL DEFAULT '0',\\n  `d6` bigint unsigned NOT NULL DEFAULT '0',\\n  `d7` bigint unsigned NOT NULL DEFAULT '0',\\n  `d8` bigint unsigned NOT NULL DEFAULT '0',\\n  `d9` bigint unsigned NOT NULL DEFAULT '0',\\n  `d10` bigint unsigned NOT NULL DEFAULT '0',\\n  `d11` bigint unsigned NOT NULL DEFAULT '0',\\n  `d12` bigint unsigned NOT NULL DEFAULT '0',\\n  `d13` bigint unsigned NOT NULL DEFAULT '0',\\n  `d14` bigint unsigned NOT NULL DEFAULT '0',\\n  `d15` bigint unsigned NOT NULL DEFAULT '0',\\n  `d16` bigint unsigned NOT NULL DEFAULT '0',\\n  `d17` bigint unsigned NOT NULL DEFAULT '0',\\n  `d18` bigint unsigned NOT NULL DEFAULT '0',\\n  `d19` bigint unsigned NOT NULL DEFAULT '0',\\n  `d20` bigint unsigned NOT NULL DEFAULT '0',\\n  `d21` bigint unsigned NOT NULL DEFAULT '0',\\n  `d22` bigint unsigned NOT NULL DEFAULT '0',\\n  `d23` bigint unsigned NOT NULL DEFAULT '0',\\n  `d24` bigint unsigned NOT NULL DEFAULT '0',\\n  `d25` bigint unsigned NOT NULL DEFAULT '0',\\n  `d26` bigint unsigned NOT NULL DEFAULT '0',\\n  `d27` bigint unsigned NOT NULL DEFAULT '0',\\n  `d28` bigint unsigned NOT NULL DEFAULT '0',\\n  `d29` bigint unsigned NOT NULL DEFAULT '0',\\n  `d30` bigint unsigned NOT NULL DEFAULT '0',\\n  `d31` bigint unsigned NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`room_id`,`year`,`month`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"awebooking_booking_itemmeta","full_table_name":"wp_awebooking_booking_itemmeta","description":"Stores awebooking booking itemmeta data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_awebooking_booking_itemmeta` (\\n  `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `booking_item_id` bigint unsigned NOT NULL,\\n  `meta_key` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`meta_id`),\\n  KEY `booking_item_id` (`booking_item_id`),\\n  KEY `meta_key` (`meta_key`(32))\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"awebooking_booking_items","full_table_name":"wp_awebooking_booking_items","description":"Stores awebooking booking items data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_awebooking_booking_items` (\\n  `booking_item_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `booking_item_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `booking_item_type` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `booking_item_parent` bigint unsigned NOT NULL,\\n  `object_id` bigint unsigned NOT NULL,\\n  `booking_id` bigint unsigned NOT NULL,\\n  PRIMARY KEY (`booking_item_id`),\\n  KEY `booking_item_parent` (`booking_item_parent`),\\n  KEY `object_id` (`object_id`),\\n  KEY `booking_id` (`booking_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"awebooking_pricing","full_table_name":"wp_awebooking_pricing","description":"Stores awebooking pricing data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_awebooking_pricing` (\\n  `rate_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `year` smallint unsigned NOT NULL DEFAULT '0',\\n  `month` tinyint unsigned NOT NULL DEFAULT '0',\\n  `d1` bigint unsigned NOT NULL DEFAULT '0',\\n  `d2` bigint unsigned NOT NULL DEFAULT '0',\\n  `d3` bigint unsigned NOT NULL DEFAULT '0',\\n  `d4` bigint unsigned NOT NULL DEFAULT '0',\\n  `d5` bigint unsigned NOT NULL DEFAULT '0',\\n  `d6` bigint unsigned NOT NULL DEFAULT '0',\\n  `d7` bigint unsigned NOT NULL DEFAULT '0',\\n  `d8` bigint unsigned NOT NULL DEFAULT '0',\\n  `d9` bigint unsigned NOT NULL DEFAULT '0',\\n  `d10` bigint unsigned NOT NULL DEFAULT '0',\\n  `d11` bigint unsigned NOT NULL DEFAULT '0',\\n  `d12` bigint unsigned NOT NULL DEFAULT '0',\\n  `d13` bigint unsigned NOT NULL DEFAULT '0',\\n  `d14` bigint unsigned NOT NULL DEFAULT '0',\\n  `d15` bigint unsigned NOT NULL DEFAULT '0',\\n  `d16` bigint unsigned NOT NULL DEFAULT '0',\\n  `d17` bigint unsigned NOT NULL DEFAULT '0',\\n  `d18` bigint unsigned NOT NULL DEFAULT '0',\\n  `d19` bigint unsigned NOT NULL DEFAULT '0',\\n  `d20` bigint unsigned NOT NULL DEFAULT '0',\\n  `d21` bigint unsigned NOT NULL DEFAULT '0',\\n  `d22` bigint unsigned NOT NULL DEFAULT '0',\\n  `d23` bigint unsigned NOT NULL DEFAULT '0',\\n  `d24` bigint unsigned NOT NULL DEFAULT '0',\\n  `d25` bigint unsigned NOT NULL DEFAULT '0',\\n  `d26` bigint unsigned NOT NULL DEFAULT '0',\\n  `d27` bigint unsigned NOT NULL DEFAULT '0',\\n  `d28` bigint unsigned NOT NULL DEFAULT '0',\\n  `d29` bigint unsigned NOT NULL DEFAULT '0',\\n  `d30` bigint unsigned NOT NULL DEFAULT '0',\\n  `d31` bigint unsigned NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`rate_id`,`year`,`month`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"awebooking_relationshipmeta","full_table_name":"wp_awebooking_relationshipmeta","description":"Stores awebooking relationshipmeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"awebooking_rooms","full_table_name":"wp_awebooking_rooms","description":"Stores awebooking rooms data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_awebooking_rooms` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `room_type` bigint unsigned NOT NULL,\\n  `order` bigint unsigned NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id`),\\n  KEY `name` (`name`),\\n  KEY `room_type` (`room_type`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"awebooking_tax_rates","full_table_name":"wp_awebooking_tax_rates","description":"Stores awebooking tax rates data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_awebooking_tax_rates` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `rate` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `priority` bigint unsigned NOT NULL DEFAULT '0',\\n  `compound` int NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id`),\\n  KEY `name` (`name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"p2p_relationshipmeta","full_table_name":"wp_p2p_relationshipmeta","description":"Stores p2p relationshipmeta data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_p2p_relationshipmeta` (\\n  `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `p2p_relationship_id` bigint unsigned NOT NULL,\\n  `meta_key` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`meta_id`),\\n  KEY `p2p_relationship_id` (`p2p_relationship_id`),\\n  KEY `meta_key` (`meta_key`(32))\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"p2p_relationships","full_table_name":"wp_p2p_relationships","description":"Stores p2p relationships data created by this plugin.","detection_method":"both","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"type","type":"VARCHAR(42)","nullable":false,"primary_key":false},{"name":"rel_from","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"rel_to","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"p2p_relationship_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"meta_key","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"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"}],"table_count":10}