author | Tero Marttila <terom@fixme.fi> |
Thu, 28 May 2009 01:17:36 +0300 | |
branch | new-lib-errors |
changeset 219 | cefec18b8268 |
parent 135 | 9159bd51525f |
permissions | -rw-r--r-- |
CREATE TABLE logs ( id serial, network varchar(32) NOT NULL, channel varchar(32) NOT NULL, ts timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, -- UTC time nickname varchar(32), -- source nickname, NULL for "meta" events username varchar(32), -- source username, NULL for "meta" events hostname varchar(64), -- source hostname, NULL for "meta" events type varchar(16) NOT NULL, -- event type target varchar(32), -- optional target message varchar(512) -- optional event data );