10 lines
490 B
SQL
10 lines
490 B
SQL
USE vn;
|
|
ALTER TABLE `vn`.`workerTimeControl`
|
|
ADD INDEX `timed_idx` (`timed` ASC);
|
|
|
|
ALTER TABLE `vn`.`workerTimeControlConfig`
|
|
ADD COLUMN `shortWeekDays` INT(11) NULL COMMENT 'Días a tener en cuenta para calcular el descanso corto' AFTER `dayMaxTime`,
|
|
ADD COLUMN `longWeekDays` INT(11) NULL COMMENT 'Días a tener en cuenta para calcular el descanso largo' AFTER `shortWeekDays`;
|
|
|
|
UPDATE `vn`.`workerTimeControlConfig` SET `shortWeekDays` = '6', `longWeekDays` = '13' WHERE (`id` = '1');
|