Eye/scripts/updates/2-5-3/mysql-acl.sql

RENAME TABLE `syslog` TO `worklog`;
CREATE TABLE `acl` (`id` int(11) NOT NULL,`name` varchar(30) NOT NULL,`description.english` varchar(250) NOT NULL,`description.russian` varchar(250) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `acl` VALUES(1, 'Full access', 'Full access', 'Полный доступ');
INSERT INTO `acl` VALUES(2, 'Operator', 'Editing parameters that are not related to access rights', 'Редактирование параметров, не связанных с правами доступа');
INSERT INTO `acl` VALUES(3, 'View only', 'View only', 'Только просмотр');
ALTER TABLE `Customers` CHANGE `readonly` `rights` TINYINT(1) NOT NULL DEFAULT '3';
UPDATE `Customers` set rights=3 WHERE rights=1;
UPDATE `Customers` set rights=1 WHERE rights=0;
ALTER TABLE `acl`  ADD PRIMARY KEY (`id`);
ALTER TABLE `acl`  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
ALTER TABLE `Customers` ADD `comment` VARCHAR(100) NULL AFTER `Login`;
UPDATE `config_options` SET `description.russian` = 'Глубина хранения VERBOSE логов работы в интерфейсе администратора' WHERE `config_options`.`id` = 47;
UPDATE `config_options` SET `description.english` = 'Depth of VERBOSE work logs storage in the admin interface' WHERE `config_options`.`id` = 47;
UPDATE `config_options` SET `min_value` = '0' WHERE `config_options`.`id` = 47;
UPDATE `config_options` SET `min_value` = '0' WHERE `config_options`.`id` = 48;
UPDATE `config_options` SET `min_value` = '0' WHERE `config_options`.`id` = 49;
UPDATE `config_options` SET `min_value` = '0' WHERE `config_options`.`id` = 56;