-- MySQL Workbench Synchronization
-- Generated: 2021-01-07 08:11
-- Model: New Model
-- Version: 1.0
-- Project: Name of the project
-- Author: Steven Heath

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

ALTER TABLE `ems_account_update`
    ADD COLUMN `pin_code` INT(11) NULL DEFAULT 0 AFTER `ems_id`,
CHANGE COLUMN `opt_in_newsletter` `opt_in_newsletter` TINYINT(4) NULL DEFAULT 0 ,
CHANGE COLUMN `opt_in_3rd_party` `opt_in_3rd_party` TINYINT(4) NULL DEFAULT 0 ,
ADD INDEX `idx_ems_id` (`ems_id` ASC),
ADD INDEX `idx_pin_code` (`pin_code` ASC);
;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
