######################################################################## # 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 ########################################################################