[dev] Horde logging.

Jon Parise jon@horde.org
Fri, 28 Sep 2001 01:07:45 -0400


On Thu, Sep 27, 2001 at 05:36:22PM -0400, Frederic Trudeau wrote:

> can I put all loggin info in a mysql db ? If so, what are the mysql tree
> that I must create. thanks

Sure.  Here's the table schema:

    CREATE TABLE log_table (
        unixtime    int NOT NULL,
        ident       char(16) NOT NULL,
        priority    int,
        message     varchar(200),
        primary key (unixtime, ident)
    );

-- 
Jon Parise (jon@csh.rit.edu)  .  Information Technology (B.S.)
http://www.csh.rit.edu/~jon/  :  Computer Science House Member