Skip to content

Instantly share code, notes, and snippets.

@iainporter
Created July 20, 2020 18:59
Show Gist options
  • Save iainporter/efa49382b8e4baa5e66b6547a01e06b3 to your computer and use it in GitHub Desktop.
Save iainporter/efa49382b8e4baa5e66b6547a01e06b3 to your computer and use it in GitHub Desktop.
migration to add outbox table
CREATE TABLE outboxevent
(
id uuid PRIMARY KEY,
aggregatetype VARCHAR(75),
aggregateid VARCHAR(50) NOT NULL,
type VARCHAR(50) NOT NULL,
timestamp TIMESTAMP NOT NULL,
payload varchar(4096) NOT NULL
);
CREATE TABLE sms.processed_event
(
event_id uuid PRIMARY KEY,
processed_at TIMESTAMP NOT NULL
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment