-
-
Notifications
You must be signed in to change notification settings - Fork 0
/
init.sql
25 lines (20 loc) · 1.04 KB
/
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
CREATE TABLE test_table(id SERIAL PRIMARY KEY, name VARCHAR);
insert into test_table(name) values('oskar');
insert into test_table(name) values('test');
CREATE SCHEMA testevents;
CREATE TABLE testevents.mt_events
(
seq_id bigint NOT NULL,
id uuid NOT NULL,
stream_id uuid,
version integer NOT NULL,
data jsonb NOT NULL,
type character varying(500) COLLATE pg_catalog."default" NOT NULL,
"timestamp" timestamp with time zone NOT NULL DEFAULT now(),
tenant_id character varying COLLATE pg_catalog."default" DEFAULT '*DEFAULT*'::character varying,
mt_dotnet_type character varying COLLATE pg_catalog."default",
CONSTRAINT pk_mt_events PRIMARY KEY (seq_id)
);
INSERT INTO testevents.mt_events(
seq_id, id, stream_id, version, data, type, "timestamp", tenant_id, mt_dotnet_type)
VALUES (0, '1915d7de-3482-4d3a-b072-109e41e5cb0d', '9a0af90b-288b-454d-94e4-a44574748db6', 1, '{"Name": "Annie Hall"}', 'meeting_created', '2019-09-21 11:16:47.606273+00', 'DEFAULT', 'Marten.WebApi.Meetings.Events.MeetingCreated, Marten.WebApi');