10 lines
517 B
SQL
10 lines
517 B
SQL
ALTER TABLE `vn`.`workerTimeControl`
|
|
ADD COLUMN IF NOT EXISTS `logExclude` tinyint(1) AS (IF(`manual`, FALSE, TRUE)) VIRTUAL,
|
|
ADD COLUMN IF NOT EXISTS `editorFk` int(10) unsigned DEFAULT NULL;
|
|
|
|
ALTER TABLE `vn`.`calendar`
|
|
ADD COLUMN IF NOT EXISTS `editorFk` int(10) unsigned DEFAULT NULL;
|
|
|
|
ALTER TABLE vn.workerLog MODIFY COLUMN changedModel enum('Worker','Calendar','WorkerTimeControlMail','Business','WorkerDms','WorkerTimeControl') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'Worker' NOT NULL;
|
|
|