nidus-sync/db/migrations/00144_lob_events.sql

13 lines
241 B
MySQL
Raw Permalink Normal View History

-- +goose Up
CREATE SCHEMA lob;
CREATE TABLE lob.event (
created TIMESTAMP WITHOUT TIME ZONE NOT NULL,
body JSONB NOT NULL,
id TEXT NOT NULL,
type_ TEXT NOT NULL,
PRIMARY KEY(id)
);
-- +goose Down
DROP TABLE lob.event;
DROP SCHEMA lob;