#29
-- change column types from bit to tinyint in my check in users table

 ALTER TABLE `kiosk_hotel_login`
CHANGE COLUMN `enable` `enable` TINYINT(1) NULL DEFAULT NULL ,
CHANGE COLUMN `report` `report` TINYINT(1) NULL DEFAULT NULL ;

#30
-- increase password size in my rewards app users

ALTER TABLE `redemption_users` CHANGE COLUMN `password` `password` VARCHAR(300) NULL DEFAULT NULL ;

#31
ALTER TABLE my_check_in DROP COLUMN room_nights;

#32
-- drop the table below because the data already is in device_registration table with type field is equal 2
-- (note that the type field is related to device_type table)

DROP TABLE rewards_device_registration;

#33
ALTER TABLE `kiosk_hotel_login`
CHANGE COLUMN `user_id` `user_id` VARCHAR(100) NOT NULL ,
ADD UNIQUE INDEX `user_id_UNIQUE` (`user_id` ASC);

#34
ALTER TABLE `redemption_users`
CHANGE COLUMN `login` `login` VARCHAR(100) NULL DEFAULT NULL ,
ADD UNIQUE INDEX `login_UNIQUE` (`login` ASC) ;

#35
#adding new fields to hotel

ALTER TABLE `hotel`
ADD COLUMN `hotel_features` TEXT NULL DEFAULT NULL AFTER `hotel_thumbnail_name`,
ADD COLUMN `hotel_privacy_policy` TEXT NULL DEFAULT NULL AFTER `hotel_features`,
ADD COLUMN `hotel_policy` TEXT NULL DEFAULT NULL AFTER `hotel_privacy_policy`,
ADD COLUMN `hotel_terms_and_conditions` TEXT NULL DEFAULT NULL AFTER `hotel_policy`;

#36
ALTER TABLE `hotel`
ADD COLUMN `stars` VARCHAR(12) NULL DEFAULT 0;

#37
CREATE TABLE `ammenities` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(100) NULL,
  `enabled` TINYINT NULL DEFAULT 0,
  `hotel_code` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`));

#38
CREATE TABLE `vicinities` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(100) NULL,
  `enabled` TINYINT NULL DEFAULT 0,
  `hotel_code` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`));

#39
ALTER TABLE `offers`
ADD COLUMN `url` VARCHAR(200) NULL AFTER `user_id`,
ADD COLUMN `enabled` TINYINT NULL DEFAULT 0 AFTER `url`;

#40
ALTER TABLE `hotel`
ADD COLUMN `at_glance` TEXT NULL DEFAULT NULL AFTER `hotel_terms_and_conditions`,
ADD COLUMN `destination` TEXT NULL DEFAULT NULL AFTER `at_glance`;

#41
CREATE TABLE `meetings` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NULL,
  `email` VARCHAR(100) NULL,
  `tel` VARCHAR(100) NULL,
  `banquet` VARCHAR(100) NULL DEFAULT 0,
  `classroom` VARCHAR(100) NULL DEFAULT 0,
  `reception` VARCHAR(100) NULL DEFAULT 0,
  `theater` VARCHAR(100) NULL DEFAULT 0,
  `ushaped` VARCHAR(100) NULL DEFAULT 0,
  `description` TEXT NULL,
  `hotel_code` VARCHAR(45) NULL,
  PRIMARY KEY (`id`));

#42
INSERT INTO `enumeration` (`ID`, `ENUM_TYPE_ID`, `DESCRIPTION`) VALUES ('11', '1', 'MEETING_ID');

#43
-- drop features from hotels because we don't need it anymore

ALTER TABLE hotel DROP COLUMN hotel_features;

#44
INSERT INTO `gui_navigation_menu` (`MENU_ID`, `LABEL`, `POSITION`, `PARENT_MENU_ID`, `HREF`, `name`) VALUES ('41', 'SPLASH SCREEN', '41', '2', 'splashscreen', 'SPLASH SCREEN');

INSERT INTO `gui_screen` (`SCREEN_ID`, `MENU_ID`, `PARENT_SCREEN_ID`) VALUES ('41', '41', '18');

--To affect it to a profile (Do not insert this row yet since splash screen is removed for now TBD later)
--INSERT INTO `gui_profile_def` (`PROFILE_ID`, `SCREEN_ID`, `IS_ENABLED`, `IS_VISIBLE`, `IS_WRITABLE`, `IS_TRANSPARENT_MENU`) VALUES ('1', '41', '1', '1', '1', '0');

#45
CREATE TABLE `splash_screen` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `hotel_code` VARCHAR(45) NOT NULL,
  `logo_url` VARCHAR(500) NULL,
  `background_url` VARCHAR(500) NULL,
  PRIMARY KEY (`id`));

#46
INSERT INTO `gui_navigation_menu` (`MENU_ID`, `LABEL`, `POSITION`, `PARENT_MENU_ID`, `HREF`, `name`) VALUES ('42', 'HOME SCREEN', '42', '2', 'homescreen', 'HOME SCREEN');

INSERT INTO `gui_screen` (`SCREEN_ID`, `MENU_ID`, `PARENT_SCREEN_ID`) VALUES ('42', '42', '18');

--To affect it to a profile
INSERT INTO `gui_profile_def` (`PROFILE_ID`, `SCREEN_ID`, `IS_ENABLED`, `IS_VISIBLE`, `IS_WRITABLE`, `IS_TRANSPARENT_MENU`) VALUES ('1', '42', '1', '1', '1', '0');


#47
CREATE TABLE `home_screen` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `hotel_code` VARCHAR(45) NOT NULL,
  `logo_url` VARCHAR(500) NULL,
  `background_url` VARCHAR(500) NULL,
  `color` VARCHAR(45) NULL,
  PRIMARY KEY (`id`));

#48
CREATE TABLE `hotel_service_directory` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `hotel_code` VARCHAR(45) NOT NULL,
  `title` VARCHAR(45) NULL,
  `description` VARCHAR(1024) NULL,
  PRIMARY KEY (`id`));

#49
CREATE TABLE `mobile_app_users` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(50) NULL,
  `first_name` VARCHAR(100) NULL,
  `last_name` VARCHAR(100) NULL,
  `email` VARCHAR(200) NULL,
  `country` VARCHAR(50) NULL,
  `tel` VARCHAR(50) NULL,
  `notifications_check` BIT(1) NULL DEFAULT 0,
  `updates_check` BIT(1) NULL DEFAULT 0,
  `offers_check` BIT(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`));

#50
INSERT INTO `gui_navigation_menu` (`MENU_ID`, `LABEL`, `POSITION`, `CSS_CLASS`, `name`, `CSS_CLASS_Active`) VALUES ('43', 'NOTIFICATIONS', '43', 'fa iconNotification', 'NOTIFICATIONS', 'fa iconNotificationActive');
INSERT INTO `gui_navigation_menu` (`MENU_ID`, `LABEL`, `POSITION`, `PARENT_MENU_ID`, `HREF`, `name`) VALUES ('44', 'APP USERS', '44', '43', 'NotificationsUsers', 'APP USERS');

INSERT INTO `gui_screen` (`SCREEN_ID`, `MENU_ID`) VALUES ('43', '43');
INSERT INTO `gui_screen` (`SCREEN_ID`, `MENU_ID`, `PARENT_SCREEN_ID`) VALUES ('44', '44', '43');

--To affect it to a profile
INSERT INTO `gui_profile_def` (`PROFILE_ID`, `SCREEN_ID`, `IS_ENABLED`, `IS_VISIBLE`, `IS_WRITABLE`, `IS_TRANSPARENT_MENU`) VALUES ('1', '44', '1', '1', '1', '0');
INSERT INTO `gui_profile_def` (`PROFILE_ID`, `SCREEN_ID`, `IS_ENABLED`, `IS_VISIBLE`, `IS_WRITABLE`, `IS_TRANSPARENT_MENU`) VALUES ('1', '43', '1', '1', '1', '0');

#51
CREATE TABLE `meetings_capacity` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(200) NULL DEFAULT 'UNKNOWN',
  PRIMARY KEY (`id`));

-- To insert some data
INSERT INTO `meetings_capacity` (`id`, `name`) VALUES ('1', 'Banquet');
INSERT INTO `meetings_capacity` (`id`, `name`) VALUES ('2', 'Classroom');
INSERT INTO `meetings_capacity` (`id`, `name`) VALUES ('3', 'Reception');
INSERT INTO `meetings_capacity` (`id`, `name`) VALUES ('4', 'Theatre');
INSERT INTO `meetings_capacity` (`id`, `name`) VALUES ('5', 'U-Shaped');

#52
CREATE TABLE `meetings_capacity_joiner` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `meeting_id` INT NOT NULL,
  `meeting_capacity_id` INT NOT NULL,
  `value` VARCHAR(100) NULL DEFAULT 0,
  PRIMARY KEY (`id`));

#53

ALTER TABLE `meetings`
DROP COLUMN `ushaped`,
DROP COLUMN `theater`,
DROP COLUMN `reception`,
DROP COLUMN `classroom`,
DROP COLUMN `banquet`;

#54
ALTER TABLE `redemption_users`
ADD COLUMN `old_user` BIT(1) NOT NULL DEFAULT 0 AFTER `enabled`;
SET SQL_SAFE_UPDATES = 0;
update `redemption_users` set old_user = 1;

#55
CREATE TABLE `redemption_change_log` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(50) NOT NULL,
  `redemption_id` INT(11) NOT NULL,
  `cancel_refund` TINYINT(1) NULL DEFAULT '0',
  `comments` VARCHAR(500) NULL DEFAULT NULL,
  `creation_date` VARCHAR(50) NOT NULL,
  `cancel_refund_changed` TINYINT(1) NULL DEFAULT '0',
  `comments_changed` TINYINT(1) NULL DEFAULT '0',
  PRIMARY KEY (`id`));

#56
ALTER TABLE `home_screen`
CHANGE COLUMN `hotel_code` `font` VARCHAR(100) NULL DEFAULT NULL ;

#57
ALTER TABLE `splash_screen`
DROP COLUMN `hotel_code`;

#58
CREATE TABLE `fonts` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `value` VARCHAR(100) NULL DEFAULT '',
  PRIMARY KEY (`id`));

#59
UPDATE `gui_navigation_menu` SET `LABEL` = 'App Theme', `HREF` = 'Apptheme', `name` = 'APP THEME' WHERE (`MENU_ID` = '42');


#60
ALTER TABLE `spa_and_recreation`
CHANGE COLUMN `description` `description` LONGTEXT NOT NULL ;

#61 (1)
CREATE TABLE `spa_features` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(200) NULL DEFAULT 'UNKNOWN',
  PRIMARY KEY (`id`));

-- To insert some data
INSERT INTO `spa_features` (`id`, `name`) VALUES ('1', 'Moroccan Bath');
INSERT INTO `spa_features` (`id`, `name`) VALUES ('2', 'Nail Services');
INSERT INTO `spa_features` (`id`, `name`) VALUES ('3', 'Steam Room');
INSERT INTO `spa_features` (`id`, `name`) VALUES ('4', 'Sauna');
INSERT INTO `spa_features` (`id`, `name`) VALUES ('5', 'Juice Bar');
INSERT INTO `spa_features` (`id`, `name`) VALUES ('6', 'Heavy Weights');

#61 (2)
CREATE TABLE `spa_features_joiner` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `spa_id` VARCHAR(100) NOT NULL,
  `spa_features_id` INT NOT NULL,
  PRIMARY KEY (`id`));

#62
ALTER TABLE `outlet`
ADD COLUMN `dress_code` VARCHAR(300) NULL DEFAULT '' AFTER `activate`,
ADD COLUMN `bookable` TINYINT(1) NULL DEFAULT 0 AFTER `dress_code`;

#63
ALTER TABLE `ammenities`
ADD COLUMN `url` VARCHAR(500) NULL DEFAULT NULL AFTER `hotel_code`;

#64
CREATE TABLE `mobile_app_users_feedback` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `first_name` VARCHAR(100) NULL,
  `last_name` VARCHAR(100) NULL,
  `star_rating` VARCHAR(50) NULL,
  `comment` VARCHAR(500) NULL,
  `hotel_code` VARCHAR(50) NULL,
  `check_in_date` DATETIME NULL,
  `check_out_date` DATETIME NULL,
  PRIMARY KEY (`id`));

#65
CREATE TABLE `spa_and_recreation_treatments` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `treatment_category_value` VARCHAR(100) NOT NULL,
  `treatment_name` VARCHAR(50) NULL,
  `treatment_description` VARCHAR(500) NULL,
  `treatment_price` VARCHAR(50) NULL,
  `treatment_duration` VARCHAR(50) NULL,
  `spa_and_recreation_id` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`id`));

CREATE TABLE `spa_and_recreation_treatments_category` (
  `id` INT NOT NULL,
  `value` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`id`));

INSERT INTO `spa_and_recreation_treatments_category` (`id`, `value`) VALUES ('1', 'Rituals');
INSERT INTO `spa_and_recreation_treatments_category` (`id`, `value`) VALUES ('2', 'Facials');
INSERT INTO `spa_and_recreation_treatments_category` (`id`, `value`) VALUES ('3', 'Body Treatments');
INSERT INTO `spa_and_recreation_treatments_category` (`id`, `value`) VALUES ('4', 'Massages');
INSERT INTO `spa_and_recreation_treatments_category` (`id`, `value`) VALUES ('5', 'Beauty Services');

#66
CREATE TABLE `offers_category` (
  `id` INT NOT NULL,
  `value` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`id`));

INSERT INTO `offers_category` (`id`, `value`) VALUES ('1', 'Rooms');
INSERT INTO `offers_category` (`id`, `value`) VALUES ('2', 'Outlets');
INSERT INTO `offers_category` (`id`, `value`) VALUES ('3', 'Spa & Recreation');
INSERT INTO `offers_category` (`id`, `value`) VALUES ('4', 'Others');

#67
ALTER TABLE `offers`
ADD COLUMN `category` VARCHAR(50) NULL AFTER `enabled`,
ADD COLUMN `subject` VARCHAR(100) NULL AFTER `category`;