CREATE TABLE `al_work_calendar_settings` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `wday_id` SET('0','1','2','3','4','5','6','-1') NOT NULL DEFAULT '-1' ,
    `half_day_id` SET('Value A','Value B') NULL DEFAULT NULL ,
    `half_time_in` TIME NULL DEFAULT NULL,
    `half_time_out` TIME NULL DEFAULT NULL,
    `cid` INT(11) UNSIGNED NULL DEFAULT NULL,
    `gm_id` INT(11) UNSIGNED NULL DEFAULT NULL,
    `region_id` INT(11) NULL DEFAULT NULL,
    `subregion_id` INT(11) NULL DEFAULT NULL,
    `country_id` INT(11) NULL DEFAULT NULL,
    `state_id` INT(11) NULL DEFAULT NULL,
    `city_id` INT(11) NULL DEFAULT NULL,
    `loc_id` INT(11) NULL DEFAULT NULL,
    `dep_id` INT(11) NULL DEFAULT NULL,
    `year` INT(6) NULL DEFAULT NULL,
    `status` TINYINT(1) NULL DEFAULT NULL,
    `created_by` INT(11) NULL DEFAULT NULL,
    `created_date` DATETIME NULL DEFAULT NULL,
    `additional_weekend` SET('Value A','Value B') NULL DEFAULT NULL ,
    `occurrence` SET('0','1','2','3','4','5','6','-1') NOT NULL DEFAULT '-1' ,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_gm_region_subregion_country_state_city_loc_dep` (`gm_id`, `region_id`, `subregion_id`, `country_id`, `state_id`, `city_id`, `loc_id`, `dep_id`) USING BTREE
)
ENGINE=InnoDB
AUTO_INCREMENT=20;
