itslog/init.sql

11 lines
215 B
MySQL
Raw Permalink Normal View History

2013-12-21 00:26:54 -08:00
DROP TABLE log;
CREATE TABLE IF NOT EXISTS
log (
log_id SERIAL,
log_time timestamp DEFAULT CURRENT_TIMESTAMP,
namespace varchar(256) NULL,
level int NOT NULL DEFAULT 0,
payload json NOT NULL
);