CREATE TABLE `student_invoice_data` (
  `serial_sid` INT NOT NULL AUTO_INCREMENT,
  `serial_std` INT NOT NULL,
  `id_type_sid` ENUM('CEDULA','RUC','PASAPORTE') NULL,
  `num_id_sid` VARCHAR(45) NULL,
  `name_sid` VARCHAR(45) NULL,
  `main_street_sid` VARCHAR(45) NULL,
  `number_sid` VARCHAR(45) NULL,
  `secondary_street_sid` VARCHAR(45) NULL,
  `phone_sid` VARCHAR(45) NULL,
  `email_sid` VARCHAR(45) NULL,
  `status_sid` ENUM('ACTIVE','INACTIVE') NULL,
  PRIMARY KEY (`serial_sid`));

ALTER TABLE `student_invoice_data` 
ENGINE = InnoDB ;


-- campo adicional telefono celular 

ALTER TABLE `student_invoice_data` 
ADD COLUMN `mobil_phone_sid` VARCHAR(45) NULL DEFAULT NULL AFTER `phone_sid`;


-- bandera para mostrar u ocultar facturacion en wizard sin rubros o con rubros especiales (america latina)
ALTER TABLE `school_year` 
ADD COLUMN `use_invoice_without_debts_scy` ENUM('YES','NO') NULL DEFAULT 'NO' AFTER `enable_travel_scy`;