ALTER TABLE `about_us` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `banners` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `destinations` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `dining` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `enquiries` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `events` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `gallery` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `general_settings` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `gymspa` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `home` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `instagram` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `management` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `newsletter` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `offers` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `pages` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `testimonials` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `press` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `vacancies` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;
ALTER TABLE `room_facilities` ADD `hotel_id` INT(11) NOT NULL DEFAULT '1' COMMENT '1=> alsad, 2=> souq wakif' AFTER `id`;

-- gd installed
sudo apt-get install php-gd
sudo service apache2 restart

ALTER TABLE room_facilities RENAME TO facilities;
ALTER TABLE room_facilities_texts RENAME TO facilities_texts;

drop table hotel_facilitie_texts;
drop table hotel_facilities;

-- change hoteltable structure

ALTER TABLE facilities_texts RENAME COLUMN room_facility TO facilities;
ALTER TABLE facilities_texts RENAME COLUMN room_facility_id TO facilities_id;

ALTER TABLE facilities ADD COLUMN type VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '1' COMMENT '1 = Hotel, 2 = Room';
ALTER TABLE facilities_texts ADD COLUMN sub_heading VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE facilities_texts ADD COLUMN description TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;


ALTER TABLE hotel_texts DROP COLUMN spa;
ALTER TABLE hotel_texts DROP COLUMN gym;
ALTER TABLE hotel_texts DROP COLUMN restaurant;
ALTER TABLE hotel_texts DROP COLUMN wifi;
ALTER TABLE hotel_texts DROP COLUMN parking;
ALTER TABLE hotel_texts DROP COLUMN swimming_pool;
ALTER TABLE hotel_texts DROP COLUMN concierge;
ALTER TABLE hotel_texts DROP COLUMN cctv;
ALTER TABLE hotel_texts DROP COLUMN complimentary_wifi;
ALTER TABLE hotel_texts DROP COLUMN business_centre;
ALTER TABLE hotel_texts DROP COLUMN valet_parking;
ALTER TABLE hotel_texts DROP COLUMN doctor_on_call;
ALTER TABLE hotel_texts DROP COLUMN currency_exchange;
ALTER TABLE hotel_texts DROP COLUMN house_keeping;
ALTER TABLE hotel_texts DROP COLUMN check_out;
ALTER TABLE hotel_texts DROP COLUMN check_in;


ALTER TABLE room_texts DROP COLUMN washing_dryer_machine;
ALTER TABLE room_texts DROP COLUMN dishwasher;
ALTER TABLE room_texts DROP COLUMN refrigerator;
ALTER TABLE room_texts DROP COLUMN microwave_oven;
ALTER TABLE room_texts DROP COLUMN cooking_pots_pans;
ALTER TABLE room_texts DROP COLUMN cutleries;
ALTER TABLE room_texts DROP COLUMN electric_kettle;
ALTER TABLE room_texts DROP COLUMN cooking_stove;
ALTER TABLE room_texts DROP COLUMN dining_table;
ALTER TABLE room_texts DROP COLUMN iron_iron_board;
ALTER TABLE room_texts DROP COLUMN television;
ALTER TABLE room_texts DROP COLUMN wifi;
ALTER TABLE room_texts DROP COLUMN check_in;
ALTER TABLE room_texts DROP COLUMN check_out;


ALTER TABLE rooms ADD facilities VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT 'array of facilities table id';

INSERT INTO hotels VALUES (2,' ',1,1,NULL,'2022-01-12 18:54:36','2022-08-16 17:28:27');
INSERT INTO hotel_texts VALUES (3,2,1,'Central Inn, Souq Waqif','Hotel Central Inn is located in the heart of Souq Waqif, the Qatari historical centre, and cultural hub. The hotel is a 15-minute drive from Doha International Airport and just a few minutes walk from Souq Waqif.',' ',' ',' ',' ',' ',' ',' ',2,'2022-01-12 18:54:36','2022-06-21 10:43:21',NULL);
INSERT INTO hotel_texts VALUES (4,2,2,'Central Inn, Souq Waqif','Hotel Central Inn is located in the heart of Souq Waqif, the Qatari historical centre, and cultural hub. The hotel is a 15-minute drive from Doha International Airport and just a few minutes walk from Souq Waqif.',' ',' ',' ',' ',' ',' ',' ',2,'2022-01-12 18:54:36','2022-06-21 10:43:21',NULL);

ALTER TABLE home_text ADD COLUMN title_hotel1 VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE home_text ADD COLUMN title_hotel2 VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;

ALTER TABLE home_text ADD COLUMN description_hotel1 TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE home_text ADD COLUMN description_hotel2 TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE home ADD COLUMN link_hotel1 VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE home ADD COLUMN link_hotel2 VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE home ADD COLUMN image1 VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE home ADD COLUMN image2 VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;

ALTER TABLE dining ADD COLUMN menu_pdf VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE room_texts ADD COLUMN short_description VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT null;
ALTER TABLE room_texts ADD COLUMN check_in VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT null;
ALTER TABLE room_texts ADD COLUMN check_out VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT null;