--
-- Create table `module_med_diary`
-- TODO tabele de torneios 
--
DROP TABLE IF EXISTS `module_med_diary`;
CREATE TABLE `module_med_diary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `diary` VARCHAR(255) DEFAULT NULL,
  `interval` VARCHAR(255) DEFAULT NULL,
  `default` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


--
-- Create table `module_med_agreement`
--
DROP TABLE IF EXISTS `module_med_agreement`;
CREATE TABLE `module_med_agreement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agreement_company_name` VARCHAR(64) DEFAULT NULL,
  `register_ans` VARCHAR(10) DEFAULT NULL,
  `agreement_cnpj` VARCHAR(14) DEFAULT NULL,
  `agreement_fantasy_name` VARCHAR(64) DEFAULT NULL,
  `modality` VARCHAR(64) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


--
-- Create table `module_med_diary`
--
DROP TABLE IF EXISTS `module_med_scheduling`;
CREATE TABLE `module_med_scheduling` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `diary_id` int(11) DEFAULT NULL,
  `patient_id` int(11) DEFAULT NULL,
  `procedure_id` int(11) DEFAULT NULL,
  `agreement_id` int(11) DEFAULT NULL,
  `date` DATE DEFAULT NULL,
  `hour` TIME DEFAULT NULL,
  `agreement_guide` VARCHAR(255) DEFAULT NULL,
  `observation` TEXT DEFAULT NULL,
  `status` ENUM('pendente','confirmado','aguardando atendimento','atendido','cancelado') NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),

  INDEX `fk_module_med_diary_idx` (`diary_id` ASC),
  INDEX `fk_crm_accounts_idx` (`patient_id` ASC),
  INDEX `fk_module_med_agreement_idx` (`agreement_id` ASC),

  CONSTRAINT `fk_module_med_diary_id`
  FOREIGN KEY (`diary_id`)
  REFERENCES `module_med_diary` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,

  CONSTRAINT `fk_crm_accounts_id`
  FOREIGN KEY (`patient_id`)
  REFERENCES `crm_accounts` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,

  CONSTRAINT `fk_module_med_agreement_id`
  FOREIGN KEY (`agreement_id`)
  REFERENCES `module_med_agreement` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- Create table `module_med_payments`
--
DROP TABLE IF EXISTS `module_med_payments`;
CREATE TABLE `module_med_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `scheduling_id` int(11) DEFAULT NULL,
  `value` DECIMAL(10,2) NOT NULL,
  `date` DATE DEFAULT NULL,
  `observation` TEXT DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_module_med_scheduling_idx` (`scheduling_id` ASC),

  CONSTRAINT `fk_module_med_scheduling`
  FOREIGN KEY (`scheduling_id`)
  REFERENCES `module_med_scheduling` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- Create table `module_med_diary_doctor`
--
DROP TABLE IF EXISTS `module_med_diary_doctor`;
CREATE TABLE `module_med_diary_doctor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `diary_id` int(11) DEFAULT NULL,
  `doctor_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),

  INDEX `fk_module_med_diary_idx` (`diary_id` ASC),
  INDEX `fk_module_med_doctor_idx` (`doctor_id` ASC),

  CONSTRAINT `fk_module_med_diary2`
  FOREIGN KEY (`diary_id`)
  REFERENCES `module_med_diary` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,

  CONSTRAINT `fk_module_med_doctor2`
  FOREIGN KEY (`doctor_id`)
  REFERENCES `crm_accounts` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- ALTER TABLE module_med_diary
--
ALTER TABLE `module_med_diary` ADD `simultaneous` INT(2) NULL DEFAULT NULL AFTER `interval`;



-- Alterações do DIOGO para módulo de procedimentos - medicina
-- ALTER TABLE sys_items
--
ALTER TABLE `sys_items` ADD `tiss_procedures_id` INT(11) NOT NULL AFTER `sys_items_location_id`, ADD INDEX `fk_tiss_procedures_idx2` (`tiss_procedures_id`);

-- ERP-402  01/2018 ANDRÉ CAMARGO

DROP TABLE IF EXISTS `module_med_type_query`;
CREATE TABLE `module_med_type_query` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `schedule_shock` ENUM('Y','N'),
  `active` ENUM('Y','N'),
  `reconsult` ENUM('Y','N'),
  `create_invoice` ENUM('Y','N'),
  `default` tinyint(1) DEFAULT '1',
  `name` VARCHAR(100),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

-- INserts default
INSERT INTO `module_med_type_query` (`id`,`schedule_shock`,`active`,`reconsult`,`create_invoice`,`default`,`name`) VALUES ('1', 'N', 'N', 'N', 'N', '1', 'Consulta');
INSERT INTO `module_med_type_query` (`id`,`schedule_shock`,`active`,`reconsult`,`create_invoice`,`default`,`name`) VALUES ('2', 'N', 'N', 'N', 'N', '1', 'Cirurgia');
INSERT INTO `module_med_type_query` (`id`,`schedule_shock`,`active`,`reconsult`,`create_invoice`,`default`,`name`) VALUES ('3', 'N', 'N', 'N', 'N', '1', 'Encaixe');
INSERT INTO `module_med_type_query` (`id`,`schedule_shock`,`active`,`reconsult`,`create_invoice`,`default`,`name`) VALUES ('4', 'N', 'N', 'N', 'N', '1', 'Encaminamento');
INSERT INTO `module_med_type_query` (`id`,`schedule_shock`,`active`,`reconsult`,`create_invoice`,`default`,`name`) VALUES ('5', 'N', 'N', 'N', 'N', '1', 'Exame');
INSERT INTO `module_med_type_query` (`id`,`schedule_shock`,`active`,`reconsult`,`create_invoice`,`default`,`name`) VALUES ('6', 'N', 'N', 'N', 'N', '1', 'Pré-Natal');
INSERT INTO `module_med_type_query` (`id`,`schedule_shock`,`active`,`reconsult`,`create_invoice`,`default`,`name`) VALUES ('7', 'N', 'N', 'N', 'N', '1', 'Reconsulta');

ALTER TABLE`module_med_agreement` 
ADD COLUMN `active` ENUM('Y', 'N') NULL;

ALTER TABLE`module_med_agreement` 
ADD COLUMN `create_invoice` ENUM('Y', 'N') NULL;

ALTER TABLE`module_med_agreement` 
ADD COLUMN `standard_agreement` ENUM('Y', 'N') NULL;

ALTER TABLE`module_med_agreement` 
ADD COLUMN `enable_tiss` ENUM('Y', 'N') NULL;


ALTER TABLE `module_med_agreement` 
ADD COLUMN `expiration_date` DATE NULL AFTER `standard_agreement`,
ADD COLUMN `tiss_version` VARCHAR(45) NULL AFTER `expiration_date`,
ADD COLUMN `tiss_register_operation` VARCHAR(45) NULL AFTER `tiss_version`,
ADD COLUMN `tiss_number_last_guide` VARCHAR(45) NULL AFTER `tiss_register_operation`,
ADD COLUMN `tiss_billing_type` VARCHAR(45) NULL AFTER `tiss_number_last_guide`,
ADD COLUMN `tiss_billing_type_value` VARCHAR(45) NULL AFTER `tiss_billing_type`;

CREATE TABLE `module_med_agreement_doctors` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `doctor_id` INT NULL,
  `module_med_agreement_id` INT NULL,
  `number_agreement` VARCHAR(45) NULL,
  PRIMARY KEY (`id`));

ALTER TABLE `sys_items` 
ADD COLUMN `average_time` INT NULL;

ALTER TABLE `sys_items` 
ADD COLUMN `linked_tiss` ENUM('Y', 'N') NULL ;

ALTER TABLE `sys_items` 
ADD COLUMN `allowed_schedules` ENUM('Y', 'N') NULL ;

CREATE TABLE `module_med_procedure_diary` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `module_med_diary` INT NULL,
  `sys_item_id` INT NULL,
  PRIMARY KEY (`id`));


CREATE TABLE `module_med_procedure_agreement` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `module_med_agreement_id` INT NULL,
  `sys_item_id` INT NULL,
  `patient_value` DECIMAL(20,2) NULL,
  `agreement_value` DECIMAL(20,2) NULL,
  `code_table` Varchar(45) NULL,
  PRIMARY KEY (`id`));


CREATE TABLE IF NOT EXISTS `module_med_procedure_allowed_schedules` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sys_item_id` int NOT NULL,
  `ind_dia` int NOT NULL,
  `hr_ini_manha` varchar(5) NULL,
  `hr_fim_manha` varchar(5) NULL,
  `hr_ini_tarde` varchar(5) NULL,
  `hr_fim_tarde` varchar(5) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `module_med_diary_schedules` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `diary_id` int NOT NULL,
  `ind_dia` int NOT NULL,
  `hr_ini_manha` varchar(5) NULL,
  `hr_fim_manha` varchar(5) NULL,
  `hr_ini_tarde` varchar(5) NULL,
  `hr_fim_tarde` varchar(5) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `module_med_diary` 
ADD COLUMN `participe_daylight` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `use_rebuilding` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `permit_add_procedure_pos_finished` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `block_professional_not_use_agreement` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `require_completion_procedure_agenda` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `patient_always_send_email_scheduling` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `patient_always_send_email_one_day_before_consultation` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `patient_always_send_sms_one_day_before_consultation` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `patient_always_send_sms_scheduling` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `professional_always_send_sms_address_book` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `professional_always_send_sms_delete_update_address_book` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `professional_always_send_email_address_book` ENUM('Y', 'N') NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `professional_always_send_email_delete_update_address_book` ENUM('Y', 'N') NULL ;


ALTER TABLE `module_med_diary` 
ADD COLUMN `timezone` VARCHAR(45) NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `days_reconsult` VARCHAR(45) NULL ;

ALTER TABLE `module_med_diary` 
ADD COLUMN `max_reassessments_period` VARCHAR(45) NULL ;

    
ALTER TABLE `module_med_agreement` 
ADD COLUMN `default` INT NULL DEFAULT 0;

INSERT INTO `module_med_agreement` (`id`, `agreement_company_name`, `active`, `create_invoice`, `standard_agreement`, `default`) VALUES ('1', 'À vista', 'Y', 'N', 'Y', '1');

INSERT INTO `crm_groups` (`id`, `gname`, `alias`, `color`, `discount`, `parent`, `pid`, `exempt`, `description`, `separateinvoices`, `sorder`, `c1`, `c2`, `c3`, `c4`, `c5`, `default`) VALUES (NULL, 'Scheduling_Requester', 'requester', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1');

CREATE TABLE `module_med_scheduling_attach` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `src` VARCHAR(100) NULL,
  `name` TEXT NULL,
  `module_med_scheduling_id` INT NULL,
  PRIMARY KEY (`id`));


ALTER TABLE `module_med_scheduling` 
CHANGE COLUMN `hour` `hour_start` TIME NULL DEFAULT NULL ,
CHANGE COLUMN `status` `status` ENUM('Scheduled', 'Confirmed', 'Canceled', 'Canceled Patient', 'On Hold', 'In progress', 'Finished', 'Missed', 'Payment', 'PreAttribute', 'Redial') NULL DEFAULT NULL ,
ADD COLUMN `requester_id` INT NULL AFTER `deleted_at`,
ADD COLUMN `professional_id` INT NULL AFTER `requester_id`,
ADD COLUMN `module_med_type_query_id` INT NULL AFTER `professional_id`,
ADD COLUMN `hour_finish` TIME NULL AFTER `module_med_type_query_id`,
ADD COLUMN `type_repetition` VARCHAR(45) NULL AFTER `hour_finish`,
ADD COLUMN `repeat_date_start` DATE NULL AFTER `type_repetition`,
ADD COLUMN `repeat_frequency` VARCHAR(45) NULL AFTER `repeat_date_start`,
ADD COLUMN `repeat_finish` VARCHAR(45) NULL AFTER `repeat_frequency`,
ADD COLUMN `repeat_finish_data` VARCHAR(100) NULL AFTER `repeat_finish`,
ADD COLUMN `repeat_days_week` VARCHAR(100) NULL AFTER `repeat_finish_data`;


CREATE TABLE `module_med_scheduling_procedures` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `module_med_scheduling_id` INT NULL,
  `sys_items_id` INT NULL,
  `qty` INT NULL,
  `discount` DECIMAL(20,2) NULL,
  `value_patient` DECIMAL(20,2) NULL,
  `value_agreement` DECIMAL(20,2) NULL,
  PRIMARY KEY (`id`));


--  ERP 462
ALTER TABLE `module_med_agreement` 
CHANGE COLUMN `agreement_company_name` `agreement_company_name` VARCHAR(100) NULL DEFAULT NULL ,
CHANGE COLUMN `agreement_fantasy_name` `agreement_company_social_reason` VARCHAR(100) NULL DEFAULT NULL ;


UPDATE `crm_groups` SET `gname`='Requester' WHERE alias='requester' and id>=1;


-- ERP 494
CREATE TABLE `module_med_scheduling_occurrence` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `module_med_scheduling_id` INT NULL,
  `created_user_id` INT NULL,
  `status` ENUM('Scheduled', 'Confirmed', 'Canceled', 'Canceled Patient', 'On Hold', 'In progress', 'Finished', 'Missed', 'Payment', 'PreAttribute', 'Redial') NULL,
  `obs` TEXT NULL,
  `date` DATE NULL,
  PRIMARY KEY (`id`));

-- LEONARDO LOPES RAMOS
-- 21/06/2018
ALTER TABLE `module_med_scheduling` 
ADD COLUMN `created_user_id` INT NOT NULL AFTER `repeat_days_week`;


ALTER TABLE `module_med_scheduling_occurrence` 
CHANGE COLUMN `date` `date` DATETIME NULL DEFAULT NULL ;


ALTER TABLE `module_med_scheduling` 
ADD COLUMN `urgency` ENUM('Y', 'N') NULL;

-- erp-498
ALTER TABLE `sys_orders` 
ADD COLUMN `module_med_scheduling_id` VARCHAR(45) NULL COMMENT 'Modulo MED SHEDULING' AFTER `divided_condition`;


ALTER TABLE `module_med_agreement` 
ADD COLUMN `crm_accounts_id_responsable` INT NULL;

ALTER TABLE `module_med_payments` 
DROP COLUMN `date`;


CREATE TABLE `module_med_agreement_patient` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `module_med_agreement_id` INT NULL,
  `crm_accounts_id` INT NULL,
  `identification` varchar(100) NULL,
  `expiration` DATE NULL,
  PRIMARY KEY (`id`));



CREATE TABLE `module_med_scheduling_authorization` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `module_med_agreement_id` INT NULL,
  `date_authorization` DATE NULL,
  `tab_number` varchar(100) NULL,
  `date_validate` DATE NULL,
  `authorization_code` varchar(100) NULL,
 `module_med_scheduling_id` INT NULL,
  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8; 

CREATE TABLE `module_med_scheduling_authorization_procedures` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `module_med_scheduling_authorization_id` INT NULL,
  `module_med_scheduling_procedures_id` INT NULL,
  PRIMARY KEY (`id`))ENGINE=InnoDB DEFAULT CHARSET=utf8; 


-- LEONARDO LOPES  RAMOS
-- 07/07/2018
ALTER TABLE `module_med_scheduling` 
ADD COLUMN `queue_number` INT NULL DEFAULT NULL AFTER `urgency`;


ALTER TABLE`module_med_type_query` 
ADD COLUMN `standard` ENUM('Y', 'N') DEFAULT 'N';



ALTER TABLE `module_med_scheduling_authorization` 
ADD COLUMN `module_med_agreement_patient_id` INT(11) NULL AFTER `module_med_scheduling_id`;



DROP TABLE IF EXISTS `module_med_procedures_expenses`;
CREATE TABLE `module_med_procedures_expenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sys_item_procedure_id` INT(11) NOT NULL,
  `sys_item_expense_id` INT(11) NOT NULL,
  `tiss_table` VARCHAR(2) NOT NULL,
  `tiss_item_code` INT(10) NOT NULL,
  `tiss_expense_code` VARCHAR(2) NOT NULL,
  `tiss_item_term` VARCHAR(512) NOT NULL,
  `qty` FLOAT(8,4) DEFAULT NULL,
  `tiss_unit_code` VARCHAR(3) DEFAULT NULL,
  `fator_reducao` FLOAT(4,2) DEFAULT NULL,
  `cod_anvisa` VARCHAR(15) DEFAULT NULL,
  `ref_fabricante` VARCHAR(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


CREATE TABLE `module_med_scheduling_expenses` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `module_med_scheduling_id` INT NULL,
  `sys_items_id` INT NULL,
  `qty` INT NULL,
  `discount` DECIMAL(20,2) NULL,
  `value_patient` DECIMAL(20,2) NULL,
  `value_agreement` DECIMAL(20,2) NULL,
  PRIMARY KEY (`id`));

ALTER TABLE `module_med_scheduling_expenses` 
ADD COLUMN `procedure_id` INT NULL;















-- MÓDULO DE GESTÃO DE EVENTOS
-- LEONARDO LOPES RAMOS
-- 10/02/2019

ALTER TABLE `module_med_procedure_diary` 
ADD COLUMN `type` ENUM('Package', 'Ticket', 'Hotel', 'Transfer') NULL,
ADD COLUMN `params` TEXT DEFAULT NULL;


-- Tabela de tipos de Tickets
DROP TABLE IF EXISTS `module_events_tickets_type`;
CREATE TABLE `module_events_tickets_type` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `event_id` INT(11) NOT NULL,
    `title` VARCHAR(255) NOT NULL,
    `description` VARCHAR(512) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `created_by` INT(10) NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `updated_by` INT(10) NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `deleted_by` INT(10) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


-- Tabela de valores de Tickets por evento
DROP TABLE IF EXISTS `module_events_tickets_value`;
CREATE TABLE `module_events_tickets_value` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `event_id` INT(11) NOT NULL,
    `event_tickets_type_id` INT(11) NOT NULL,
    `date` DATE NOT NULL,
    `hour` TIME DEFAULT NULL,
    `session` VARCHAR(255) NOT NULL,
    `round_female` VARCHAR(512) NOT NULL,
    `round_male` VARCHAR(512) NOT NULL,
    `sys_item_id` INT(10) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `created_by` INT(10) NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `updated_by` INT(10) NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `deleted_by` INT(10) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


-- Tabela de Hotéis por evento
DROP TABLE IF EXISTS `module_events_hotels`;
CREATE TABLE `module_events_hotels` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `event_id` INT(11) NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    `address` VARCHAR(512) NULL,
    `description` LONGTEXT DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `created_by` INT(10) NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `updated_by` INT(10) NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `deleted_by` INT(10) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


-- Tabela de valores de Tickets por evento
DROP TABLE IF EXISTS `module_events_hotels_value`;
CREATE TABLE `module_events_hotels_value` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `event_id` INT(11) NOT NULL,
    `event_hotel_id` INT(11) NOT NULL,
    `room_type` VARCHAR(255) NOT NULL,
    `description` VARCHAR(512) NULL,
    `sys_item_id` INT(10) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `created_by` INT(10) NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `updated_by` INT(10) NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `deleted_by` INT(10) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


ALTER TABLE `module_med_diary` 
ADD COLUMN `date_init` DATE DEFAULT NULL,
ADD COLUMN `date_end` DATE DEFAULT NULL,
ADD COLUMN `locale` VARCHAR(512) NULL,
ADD COLUMN `description` LONGTEXT DEFAULT NULL;



--- LEONARDO LOPES RAMOS
--- ALTERAÇÕES 07/03/2019
ALTER TABLE `module_events_hotels` 
ADD COLUMN `link` VARCHAR(255) NULL DEFAULT NULL AFTER `description`;


ALTER TABLE `module_events_hotels_value` 
ADD COLUMN `date` DATE NOT NULL AFTER `description`;