1 

     2 CREATE TABLE logs (

     3     id          serial,

     4     network     varchar(32)     NOT NULL,

     5     channel     varchar(32)     NOT NULL,

     6     ts          timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,       -- UTC time

     7     nickname    varchar(32),                    -- source nickname, NULL for "meta" events

     8     username    varchar(32),                    -- source username, NULL for "meta" events

     9     hostname    varchar(64),                    -- source hostname, NULL for "meta" events

    10     type        varchar(16)     NOT NULL,       -- event type

    11     target      varchar(32),                    -- optional target

    12     message     varchar(512)                    -- optional event data

    13 );

    14