{"slug":"hotel-booking-by-xfor","name":"Hotel Booking by Xfor","description":"Hotel Booking - helps you to setup hotel booking system quickly, pleasantly and easily.","author":"utz0r2","active_installs":10,"version":"0.1.5","wp_org_url":"https://wordpress.org/plugins/hotel-booking-by-xfor/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"xfor_orders","full_table_name":"wp_xfor_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"room","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"fullname","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"tel","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"noty","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"is_paid","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"cost","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"guest","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"John","type":"Dou","nullable":true,"primary_key":false},{"name":"i","type":"like","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_xfor_orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `room` varchar(250) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `fullname` varchar(250) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `tel` varchar(16) DEFAULT NULL, `noty` varchar(255) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `is_paid` tinyint(4) DEFAULT NULL, `cost` varchar(50) DEFAULT NULL, `guest` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"INSERT INTO `wp_xfor_orders` (`room`, `start_date`, `end_date`, `fullname`, `email`, `tel`, `noty`, `status`, `is_paid`, `cost`, `guest`) VALUES ('103', '$start_date', '$end_date', 'John Dou', 'john@mail.com', '99999999', 'i like sleep', 'New', 1, '1000', '1');"},{"table_name":"xfor_room_types","full_table_name":"wp_xfor_room_types","description":"Stores xfor room types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"tinyint(4)","nullable":false,"primary_key":true},{"name":"title","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"images","type":"text","nullable":true,"primary_key":false},{"name":"area","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"capacity","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"desc","type":"text","nullable":true,"primary_key":false},{"name":"comfort_list","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"add_services_list","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"shortcode","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"capacity_desc","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"The","type":"standard","nullable":true,"primary_key":false},{"name":"tastefully","type":"furnished","nullable":true,"primary_key":false},{"name":"Hair","type":"dryer","nullable":true,"primary_key":false},{"name":"1","type":"man","nullable":true,"primary_key":false},{"name":"2","type":"man","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_xfor_room_types` ( `id` tinyint(4) NOT NULL AUTO_INCREMENT, `title` varchar(250) DEFAULT NULL, `images` text DEFAULT NULL, `area` tinyint(4) DEFAULT NULL, `capacity` varchar(250) DEFAULT NULL, `desc` text DEFAULT NULL, `comfort_list` varchar(250) DEFAULT NULL, `add_services_list` varchar(250) DEFAULT NULL, `shortcode` varchar(250) DEFAULT NULL, `capacity_desc` varchar(250) DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"INSERT INTO `wp_xfor_room_types` (`title`, `images`, `area`, `capacity`, `desc`, `comfort_list`, `add_services_list`, `shortcode`, `capacity_desc`) VALUES ('Standart room', '', 32, '{\\\"1\\\":\\\"100\\\",\\\"1 + 1\\\":\\\"\\\",\\\"1 + 2\\\":\\\"160\\\",\\\"1 + 3\\\":\\\"180\\\"}', 'The standard double rooms with a double bed or twin beds are simple and functional, tastefully furnished. The rooms offer views of the quiet courtyard.', 'Wifi,Safe,Slippers,Bathrobe,Conditioner,TV,Balcony,Hair dryer,Refrigerator', 'Transfer,Massage,Dinner,Supper', 'STN', '1 man 2 add place'), ('De luxe suite', '', 64, '{\\\"1\\\":\\\"130\\\",\\\"1 + 1\\\":\\\"\\\",\\\"1 + 2\\\":\\\"\\\",\\\"1 + 3\\\":\\\"\\\"}', 'Description', 'Wifi,Slippers,Conditioner,TV,Refrigerator,Balcony', 'Transfer,Dinner', 'LUX', '2 man 2 add place');"},{"table_name":"xfor_room_types_images","full_table_name":"wp_xfor_room_types_images","description":"Stores xfor room types images data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"tinyint(4)","nullable":false,"primary_key":true},{"name":"images","type":"text","nullable":true,"primary_key":false},{"name":"type_id","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"param","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"value","type":"text","nullable":true,"primary_key":false},{"name":"Hair","type":"dryer","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_xfor_room_types_images` ( `id` tinyint(4) NOT NULL AUTO_INCREMENT, `images` text DEFAULT NULL, `type_id` tinyint(4) DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_xfor_settings` ( `id` tinyint(4) NOT NULL AUTO_INCREMENT, `param` varchar(20) DEFAULT NULL, `value` text DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"INSERT INTO `wp_xfor_settings` (`param`, `value`) VALUES ('ROOM_STATUSES', 'Ready,Cleaning,Dirty'), ('BOOKING_STATUS', 'New,Confirmed,Arrived,Freed'), ('COMFORTS_LIST', 'Wifi,Conditioner,Refrigerator,Safe,Bathrobe,Hair dryer,Slippers,TV,Balcony'), ('SERVICES_LIST', 'Transfer, Massage, Dinner, Supper'), ('SETS_LIST', '1,1 + 1,1 + 2,1 + 3'), ('IMG_LARGE', 1000), ('IMG_SMALL', 100), ('IMG_MEDIUM', 500), ('CUR', '[[\\\"USD\\\",\\\"$\\\",\\\"1.00\\\"],[\\\"RUB\\\",\\\"₽\\\",\\\"38.00\\\"],[\\\"UAH\\\",\\\"₴\\\",\\\"28.00\\\"]]'), ('PROMO', '[[\\\"TEST1\\\", 10, 1]]');"},{"table_name":"xfor_rooms","full_table_name":"wp_xfor_rooms","description":"Stores xfor rooms data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"tinyint(4)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"type_id","type":"smallint(6)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"cleaner","type":"varchar(250)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_xfor_rooms` ( `id` tinyint(4) NOT NULL AUTO_INCREMENT, `name` varchar(250) DEFAULT NULL, `type_id` smallint(6) DEFAULT NULL, `status` tinyint(4) DEFAULT NULL, `cleaner` varchar(250) DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"INSERT INTO `wp_xfor_rooms` (`name`, `type_id`, `status`, `cleaner`) VALUES (101, 1, 1, 'Ready'), (201, 2, 1, 'Cleaning'), (102, 1, 1, 'Dirty'), (103, 1, 1, 'Ready');"},{"table_name":"xfor_settings","full_table_name":"wp_xfor_settings","description":"Stores xfor settings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":5}