The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
CREATE TABLE helios_log_entry_tb (
    logid           INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    log_time        DECIMAL(32,6) NOT NULL,
    host            VARCHAR(64),
    pid             INTEGER,
    jobid           INTEGER,
    jobtypeid       INTEGER,
    service         VARCHAR(128),
    priority        VARCHAR(20),
    message         BLOB
);
CREATE INDEX helios_let_lt_idx ON helios_log_entry_tb (log_time);
CREATE INDEX helios_let_lt_lid_idx ON helios_log_entry_tb (log_time, logid);