create table logs
(
  msg                 varchar2(4000),
  hostname            varchar2(255),
  syslogtag           varchar2(4000),
  programname         varchar2(4000),
  pri                 varchar2(10),
  pri_text            varchar2(4000),
  iut                 varchar2(10),
  syslogfacility      varchar2(10),
  syslogfacility_text varchar2(100),
  syslogseverity      varchar2(10),
  syslogseverity_text varchar2(100),
  syslogpriority      varchar2(10),
  syslogpriority_text varchar2(100),
  timegenerated       date,
  timereported        date,
  app_name            varchar2(4000),
  procid              varchar2(10),
  msgid               varchar2(10),
  inputname           varchar2(100)
);