-
Notifications
You must be signed in to change notification settings - Fork 0
/
pg-init.sql
28 lines (26 loc) · 865 Bytes
/
pg-init.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
CREATE TABLE IF NOT EXISTS public.balances
(
id text COLLATE pg_catalog."default" NOT NULL,
version integer NOT NULL,
content json NOT NULL,
CONSTRAINT balances_pkey PRIMARY KEY (id)
);
CREATE TABLE IF NOT EXISTS public.sagas
(
id text COLLATE pg_catalog."default" NOT NULL,
version integer NOT NULL,
content json NOT NULL,
CONSTRAINT sagas_pkey PRIMARY KEY (id)
);
CREATE TABLE IF NOT EXISTS public.outbox
(
id text COLLATE pg_catalog."default" NOT NULL,
key text COLLATE pg_catalog."default" NOT NULL,
keyHash integer NOT NULL,
"timestamp" timestamp without time zone NOT NULL DEFAULT (now() AT TIME ZONE 'utc'::text),
topic text COLLATE pg_catalog."default" NOT NULL,
reply_to text COLLATE pg_catalog."default",
sent boolean,
message json NOT NULL,
CONSTRAINT outbox_pkey PRIMARY KEY (id)
);