terom@68: 
terom@68: CREATE TABLE logs (
terom@68:     id          serial,
terom@68:     network     varchar(32)     NOT NULL,
terom@68:     channel     varchar(32)     NOT NULL,
terom@68:     ts          timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,       -- UTC time
terom@68:     nickname    varchar(32),                    -- source nickname, NULL for "meta" events
terom@68:     username    varchar(32),                    -- source username, NULL for "meta" events
terom@68:     hostname    varchar(64),                    -- source hostname, NULL for "meta" events
terom@68:     type        varchar(16)     NOT NULL,       -- event type
terom@68:     target      varchar(32),                    -- optional target
terom@68:     message     varchar(512)                    -- optional event data
terom@68: );
terom@68: