# 2019 04 08
ALTER TABLE `users` ADD COLUMN `token_expired_dt` DATE NULL AFTER `userauthkey`;

CREATE TABLE `user_has_token` (
  `fk_user` INT NOT NULL,
  `token` VARCHAR(45) NOT NULL,
  `create_dttm` DATETIME NULL DEFAULT CURRENT_TIMESTAMP(),
  `expire_dttm` DATETIME NULL,
  PRIMARY KEY (`fk_user`, `token`));

/*----------------------------------------- 2019 05 13

ALTER TABLE `elements` ADD COLUMN `position` INT NOT NULL DEFAULT 1 AFTER `liv`;
ALTER TABLE `elements` MODIFY COLUMN `coefficient` double(11, 2) DEFAULT NULL AFTER `name`;

/*----------------------------------------- 2019 06 13

CREATE TABLE `user_visibility` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `fk_integrator` INT NULL,
  `fk_client` INT NULL,
  `fk_site` INT NULL,
  `fk_user` INT NULL,
  `create_dttm` DATETIME NULL DEFAULT CURRENT_TIMESTAMP(),
  `update_dttm` DATETIME NULL DEFAULT ON UPDATE CURRENT_TIMESTAMP(),
  PRIMARY KEY (`id`));

CREATE TABLE `integrators` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `max_services` int(11) DEFAULT -1,
  `max_sites` int(11) DEFAULT -1,
  `max_users` int(11) DEFAULT -1,
  `logo` varchar(255) DEFAULT NULL,
  `deadline_dt` date DEFAULT NULL,
  `note` text DEFAULT NULL,
  `is_enabled` int(11) DEFAULT 1,
  `create_dttm` datetime DEFAULT current_timestamp(),
  `update_dttm` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


ALTER TABLE `integrators` 
MODIFY COLUMN `create_dttm` datetime(0) DEFAULT CURRENT_TIMESTAMP() AFTER `note`,
MODIFY COLUMN `update_dttm` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) AFTER `create_dttm`;

ALTER TABLE `integrators` CHANGE COLUMN `logo` `fk_media` int(11) DEFAULT NULL AFTER `update_dttm`;

ALTER TABLE `clients` ADD COLUMN `fk_integrator` int(11) AFTER `is_enabled`;

ALTER TABLE `grids` ADD COLUMN `fk_replace_by` int(11) AFTER `fk_forward_obj`;

CREATE TABLE `terminology`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `integrators` varchar(255),
  `clients` varchar(255),
  `sites` varchar(255),
  `areas` varchar(255),
  `zones` varchar(255),
  `language` varchar(3) NOT NULL,
  `create_dttm` datetime DEFAULT CURRENT_TIMESTAMP(),
  `update_dttm` datetime ON UPDATE CURRENT_TIMESTAMP(),
  `fk_client` int(11),
  PRIMARY KEY (`id`)
);

ALTER TABLE `terminology` 
ADD COLUMN `integrator` varchar(255) AFTER `id`,
ADD COLUMN `client` varchar(255) AFTER `integrators`,
ADD COLUMN `site` varchar(255) AFTER `clients`,
ADD COLUMN `area` varchar(255) AFTER `sites`,
ADD COLUMN `zone` varchar(255) AFTER `areas`;

ALTER TABLE `periods_type` 
MODIFY COLUMN `name` varchar(150) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `id`,
ADD COLUMN `type` varchar(45) NOT NULL AFTER `name`,
MODIFY COLUMN `days` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `type`,
ADD COLUMN `starting_day` int(255) UNSIGNED NOT NULL DEFAULT 10 AFTER `days`,
ADD COLUMN `periodicity` int(255) UNSIGNED NOT NULL DEFAULT 1 AFTER `starting_day`;

ALTER TABLE `periods` 
ADD COLUMN `fk_period_type` int(11) AFTER `fk_distribution`;

ALTER TABLE `periods_type` 
ADD COLUMN `is_enabled` int(11) DEFAULT 1 AFTER `periodicity`,
ADD COLUMN `is_blocked` int(255) DEFAULT 0 AFTER `is_enabled`,
ADD COLUMN `is_active` int(255) DEFAULT 1 AFTER `is_blocked`;

ALTER TABLE `periods_type` 
MODIFY COLUMN `days` int(11) UNSIGNED DEFAULT 0 AFTER `type`,
MODIFY COLUMN `starting_day` int(255) UNSIGNED DEFAULT 10 AFTER `days`,
MODIFY COLUMN `periodicity` int(255) UNSIGNED DEFAULT 1 AFTER `starting_day`;

ALTER TABLE `periods_type` 
ADD COLUMN `fk_forward_obj` int(11) AFTER `update_dttm`;

ALTER TABLE `medias` ADD COLUMN `fk_obj` int(11) AFTER `fk_insert_by`;
ALTER TABLE `medias` ADD COLUMN `obj_type` int(11) AFTER `mime_type`;

/*----------------------------------------- 2019 07 10

ALTER TABLE `medias` ADD COLUMN `title` varchar(255) AFTER `id`;

ALTER TABLE `medias` 
MODIFY COLUMN `mime_type` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL AFTER `create_dttm`,
MODIFY COLUMN `obj_type` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL AFTER `mime_type`;

ALTER TABLE `grids` ADD COLUMN `description` text AFTER `fk_replace_by`;
ALTER TABLE `areas` ADD COLUMN `description` text AFTER `name`;

ALTER TABLE `users` 
ADD COLUMN `make_checks` int(11) UNSIGNED DEFAULT 0 AFTER `token_expired_dt`;

ALTER TABLE `distribution_has_zones` 
ADD COLUMN `fk_area` int(11) AFTER `fk_zone`,
ADD COLUMN `fk_site` int(11) AFTER `fk_area`;

ALTER TABLE `statistics_images` 
ADD COLUMN `title` int(11) AFTER `id`;

ALTER TABLE `statistics_images` 
MODIFY COLUMN `title` varchar(100) DEFAULT NULL AFTER `id`;
ALTER TABLE `statistics_images` 
MODIFY COLUMN `data` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci AFTER `title`;

/*----------------------------------------- 2019 08 07
ALTER TABLE `elements` ADD COLUMN `description` varchar(255) AFTER `is_active`;

/*----------------------------------------- 2020 02 03

CREATE TABLE `log`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `action` varchar(255),
  `description` varchar(255),
  `create_dttm` datetime(0),
  `fk_user` int(11),
  `fk_token` int(255),
  PRIMARY KEY (`id`),
  INDEX(`fk_user`),
  INDEX(`fk_token`)
);
ALTER TABLE `log` 
ADD COLUMN `type` varchar(255) AFTER `action`;

/*----------------------------------------- 2020 02 05
ALTER TABLE `log` MODIFY COLUMN `description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci AFTER `type`;

/*----------------------------------------- 2020 08 18
ALTER TABLE `ceva`.`grids` 
MODIFY COLUMN `name` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `id`;