11 lines
215 B
MySQL
11 lines
215 B
MySQL
|
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
|
||
|
);
|