[syslog-ng]Errata corrige: NEW SOLUTION MYSQL INSERT

[_/CaT\_]

########################################################################
# SQL script for create DB and load the tables: facility and level 
########################################################################
CREATE DATABASE syslog;
USE syslog;

create table facility
(
   	id		 int(2),
    	facility   varchar(16)
);

create table level
(
   	priority		int(2),
    	level   		varchar(16)
);

insert into facility(id,facility) values ('0','kern');
insert into facility(id,facility) values ('1','user');
insert into facility(id,facility) values ('2','mail');
insert into facility(id,facility) values ('3','daemon');
insert into facility(id,facility) values ('4','auth');
insert into facility(id,facility) values ('5','syslog');
insert into facility(id,facility) values ('6','lpr');
insert into facility(id,facility) values ('7','news');
insert into facility(id,facility) values ('8','uucp');
insert into facility(id,facility) values ('9','cron');
insert into facility(id,facility) values ('10','local0'); 
insert into facility(id,facility) values ('11','local1'); 
insert into facility(id,facility) values ('12','local2'); 
insert into facility(id,facility) values ('13','local3'); 
insert into facility(id,facility) values ('14','local4'); 
insert into facility(id,facility) values ('15','local5'); 
insert into facility(id,facility) values ('16','local6'); 
insert into facility(id,facility) values ('17','local7');

insert into level(priority,level) values ('0','emerg');
insert into level(priority,level) values ('1','alert');
insert into level(priority,level) values ('2','crit');
insert into level(priority,level) values ('3','err');
insert into level(priority,level) values ('4','warning'); 
insert into level(priority,level) values ('5','notice'); 
insert into level(priority,level) values ('6','info'); 
insert into level(priority,level) values ('7','debug'); 
insert into level(priority,level) values ('8','none');

commit; 
########################################################################
#EOF 
########################################################################