20 lines
1.2 KiB
SQL
20 lines
1.2 KiB
SQL
UPDATE `syslog` SET `priority`='0' WHERE `priority` LIKE 'eme%';
|
|
UPDATE `syslog` SET `priority`='1' WHERE `priority` LIKE 'ale%';
|
|
UPDATE `syslog` SET `priority`='2' WHERE `priority` LIKE 'cri%';
|
|
UPDATE `syslog` SET `priority`='3' WHERE `priority` LIKE 'err%';
|
|
UPDATE `syslog` SET `priority`='4' WHERE `priority` LIKE 'war%';
|
|
UPDATE `syslog` SET `priority`='5' WHERE `priority` LIKE 'not%';
|
|
UPDATE `syslog` SET `priority`='6' WHERE `priority` LIKE 'inf%';
|
|
UPDATE `syslog` SET `priority`='7' WHERE `priority` LIKE 'deb%';
|
|
UPDATE `syslog` SET `priority`='8' WHERE `priority` LIKE 'oth%';
|
|
UPDATE `syslog` SET `level`='0' WHERE `level` LIKE 'eme%';
|
|
UPDATE `syslog` SET `level`='1' WHERE `level` LIKE 'ale%';
|
|
UPDATE `syslog` SET `level`='2' WHERE `level` LIKE 'cri%';
|
|
UPDATE `syslog` SET `level`='3' WHERE `level` LIKE 'err%';
|
|
UPDATE `syslog` SET `level`='4' WHERE `level` LIKE 'war%';
|
|
UPDATE `syslog` SET `level`='5' WHERE `level` LIKE 'not%';
|
|
UPDATE `syslog` SET `level`='6' WHERE `level` LIKE 'inf%';
|
|
UPDATE `syslog` SET `level`='7' WHERE `level` LIKE 'deb%';
|
|
UPDATE `syslog` SET `level`='8' WHERE `level` LIKE 'oth%';
|
|
ALTER TABLE `syslog` CHANGE `priority` `priority` TINYINT NOT NULL DEFAULT '8', CHANGE `level` `level` TINYINT NOT NULL DEFAULT '8';
|