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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947--
-- PostgreSQL database dump
--
\restrict w0UCtZUAkqllrkWsq8VVIBLlGNK3f5ezOdm6EvNhX5O5xGQEfYRD5Am35egQpHu
-- Dumped from database version 17.5
-- Dumped by pg_dump version 18.3 (Homebrew)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
--
-- Name: hdb_catalog; Type: SCHEMA; Schema: -; Owner: -
--
CREATE SCHEMA hdb_catalog;
--
-- Name: pgcrypto; Type: EXTENSION; Schema: -; Owner: -
--
CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;
--
-- Name: EXTENSION pgcrypto; Type: COMMENT; Schema: -; Owner: -
--
COMMENT ON EXTENSION pgcrypto IS 'cryptographic functions';
--
-- Name: gen_hasura_uuid(); Type: FUNCTION; Schema: hdb_catalog; Owner: -
--
CREATE FUNCTION hdb_catalog.gen_hasura_uuid() RETURNS uuid
LANGUAGE sql
AS $$select gen_random_uuid()$$;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: item_count_template; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.item_count_template (
key text,
count integer
);
--
-- Name: get_most_common_messages(uuid, integer); Type: FUNCTION; Schema: public; Owner: -
--
CREATE FUNCTION public.get_most_common_messages(search_audit_id uuid, row_limit integer) RETURNS SETOF public.item_count_template
LANGUAGE plpgsql STABLE
AS $$
BEGIN RETURN QUERY
SELECT
m.content :: text AS key,
COUNT(*) :: int AS count
FROM
blockers b
JOIN blocker_messages bm ON b.id = bm.blocker_id
JOIN messages m ON bm.message_id = m.id
WHERE
b.audit_id = search_audit_id
GROUP BY
m.content
ORDER BY
count DESC
LIMIT
row_limit;
END;
$$;
--
-- Name: get_most_common_tags(uuid, integer); Type: FUNCTION; Schema: public; Owner: -
--
CREATE FUNCTION public.get_most_common_tags(search_audit_id uuid, row_limit integer) RETURNS SETOF public.item_count_template
LANGUAGE plpgsql STABLE
AS $$
BEGIN RETURN QUERY
SELECT
t.content :: text AS key,
COUNT(*) :: int AS count
FROM
blockers b
JOIN blocker_messages bm ON b.id = bm.blocker_id
JOIN messages m ON bm.message_id = m.id
JOIN message_tags mt ON m.id = mt.message_id
JOIN tags t ON mt.tag_id = t.id
WHERE
b.audit_id = search_audit_id
GROUP BY
t.content
ORDER BY
count DESC
LIMIT
row_limit;
END;
$$;
--
-- Name: get_most_common_urls(uuid, integer); Type: FUNCTION; Schema: public; Owner: -
--
CREATE FUNCTION public.get_most_common_urls(search_audit_id uuid, row_limit integer) RETURNS SETOF public.item_count_template
LANGUAGE plpgsql STABLE
AS $$
BEGIN RETURN QUERY
SELECT
u.url :: text AS key,
COUNT(*) :: int AS count
FROM
blockers b
JOIN urls u ON b.url_id = u.id
WHERE
b.audit_id = search_audit_id
GROUP BY
u.url
ORDER BY
count DESC
LIMIT
row_limit;
END;
$$;
--
-- Name: set_current_timestamp_updated_at(); Type: FUNCTION; Schema: public; Owner: -
--
CREATE FUNCTION public.set_current_timestamp_updated_at() RETURNS trigger
LANGUAGE plpgsql
AS $$
DECLARE
_new record;
BEGIN
_new := NEW;
_new."updated_at" = NOW();
RETURN _new;
END;
$$;
--
-- Name: hdb_action_log; Type: TABLE; Schema: hdb_catalog; Owner: -
--
CREATE TABLE hdb_catalog.hdb_action_log (
id uuid DEFAULT hdb_catalog.gen_hasura_uuid() NOT NULL,
action_name text,
input_payload jsonb NOT NULL,
request_headers jsonb NOT NULL,
session_variables jsonb NOT NULL,
response_payload jsonb,
errors jsonb,
created_at timestamp with time zone DEFAULT now() NOT NULL,
response_received_at timestamp with time zone,
status text NOT NULL,
CONSTRAINT hdb_action_log_status_check CHECK ((status = ANY (ARRAY['created'::text, 'processing'::text, 'completed'::text, 'error'::text])))
);
--
-- Name: hdb_cron_event_invocation_logs; Type: TABLE; Schema: hdb_catalog; Owner: -
--
CREATE TABLE hdb_catalog.hdb_cron_event_invocation_logs (
id text DEFAULT hdb_catalog.gen_hasura_uuid() NOT NULL,
event_id text,
status integer,
request json,
response json,
created_at timestamp with time zone DEFAULT now()
);
--
-- Name: hdb_cron_events; Type: TABLE; Schema: hdb_catalog; Owner: -
--
CREATE TABLE hdb_catalog.hdb_cron_events (
id text DEFAULT hdb_catalog.gen_hasura_uuid() NOT NULL,
trigger_name text NOT NULL,
scheduled_time timestamp with time zone NOT NULL,
status text DEFAULT 'scheduled'::text NOT NULL,
tries integer DEFAULT 0 NOT NULL,
created_at timestamp with time zone DEFAULT now(),
next_retry_at timestamp with time zone,
CONSTRAINT valid_status CHECK ((status = ANY (ARRAY['scheduled'::text, 'locked'::text, 'delivered'::text, 'error'::text, 'dead'::text])))
);
--
-- Name: hdb_metadata; Type: TABLE; Schema: hdb_catalog; Owner: -
--
CREATE TABLE hdb_catalog.hdb_metadata (
id integer NOT NULL,
metadata json NOT NULL,
resource_version integer DEFAULT 1 NOT NULL
);
--
-- Name: hdb_scheduled_event_invocation_logs; Type: TABLE; Schema: hdb_catalog; Owner: -
--
CREATE TABLE hdb_catalog.hdb_scheduled_event_invocation_logs (
id text DEFAULT hdb_catalog.gen_hasura_uuid() NOT NULL,
event_id text,
status integer,
request json,
response json,
created_at timestamp with time zone DEFAULT now()
);
--
-- Name: hdb_scheduled_events; Type: TABLE; Schema: hdb_catalog; Owner: -
--
CREATE TABLE hdb_catalog.hdb_scheduled_events (
id text DEFAULT hdb_catalog.gen_hasura_uuid() NOT NULL,
webhook_conf json NOT NULL,
scheduled_time timestamp with time zone NOT NULL,
retry_conf json,
payload json,
header_conf json,
status text DEFAULT 'scheduled'::text NOT NULL,
tries integer DEFAULT 0 NOT NULL,
created_at timestamp with time zone DEFAULT now(),
next_retry_at timestamp with time zone,
comment text,
CONSTRAINT valid_status CHECK ((status = ANY (ARRAY['scheduled'::text, 'locked'::text, 'delivered'::text, 'error'::text, 'dead'::text])))
);
--
-- Name: hdb_schema_notifications; Type: TABLE; Schema: hdb_catalog; Owner: -
--
CREATE TABLE hdb_catalog.hdb_schema_notifications (
id integer NOT NULL,
notification json NOT NULL,
resource_version integer DEFAULT 1 NOT NULL,
instance_id uuid NOT NULL,
updated_at timestamp with time zone DEFAULT now(),
CONSTRAINT hdb_schema_notifications_id_check CHECK ((id = 1))
);
--
-- Name: hdb_version; Type: TABLE; Schema: hdb_catalog; Owner: -
--
CREATE TABLE hdb_catalog.hdb_version (
hasura_uuid uuid DEFAULT hdb_catalog.gen_hasura_uuid() NOT NULL,
version text NOT NULL,
upgraded_on timestamp with time zone NOT NULL,
cli_state jsonb DEFAULT '{}'::jsonb NOT NULL,
console_state jsonb DEFAULT '{}'::jsonb NOT NULL,
ee_client_id text,
ee_client_secret text
);
--
-- Name: audits; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.audits (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
user_id uuid NOT NULL,
"interval" text NOT NULL,
scheduled_at timestamp with time zone,
processed_at timestamp with time zone,
status text NOT NULL,
name text NOT NULL,
payload jsonb,
response jsonb,
email_notifications text,
remote_csv_url text,
remote_csv_error text
);
--
-- Name: blocker_messages; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.blocker_messages (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
message_id uuid NOT NULL,
blocker_id uuid NOT NULL
);
--
-- Name: blockers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.blockers (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
audit_id uuid NOT NULL,
content text NOT NULL,
content_normalized text NOT NULL,
content_hash_id uuid NOT NULL,
targets jsonb DEFAULT jsonb_build_array() NOT NULL,
equalified boolean DEFAULT false NOT NULL,
url_id uuid,
scan_id uuid,
short_id text
);
--
-- Name: message_tags; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.message_tags (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
message_id uuid NOT NULL,
tag_id uuid NOT NULL
);
--
-- Name: messages; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.messages (
id uuid DEFAULT gen_random_uuid() NOT NULL,
content text NOT NULL,
category text NOT NULL
);
--
-- Name: tags; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.tags (
id uuid DEFAULT gen_random_uuid() NOT NULL,
content text NOT NULL
);
--
-- Name: urls; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.urls (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
user_id uuid NOT NULL,
audit_id uuid NOT NULL,
url text NOT NULL,
type text NOT NULL,
audit_ids jsonb DEFAULT jsonb_build_array() NOT NULL
);
--
-- Name: blocker_summary_view; Type: VIEW; Schema: public; Owner: -
--
CREATE VIEW public.blocker_summary_view AS
SELECT b.audit_id,
u.url,
m.content AS message_content,
m.category,
t.content AS tag_content
FROM (((((public.blockers b
LEFT JOIN public.urls u ON ((b.url_id = u.id)))
LEFT JOIN public.blocker_messages bm ON ((b.id = bm.blocker_id)))
LEFT JOIN public.messages m ON ((bm.message_id = m.id)))
LEFT JOIN public.message_tags mt ON ((m.id = mt.message_id)))
LEFT JOIN public.tags t ON ((mt.tag_id = t.id)));
--
-- Name: ignored_blockers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.ignored_blockers (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
audit_id uuid NOT NULL,
blocker_id uuid NOT NULL
);
--
-- Name: invites; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.invites (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
user_id uuid NOT NULL,
name text,
email text NOT NULL,
type text DEFAULT 'member'::text NOT NULL,
expires_on timestamp with time zone
);
--
-- Name: logs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.logs (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
user_id uuid,
audit_id uuid,
message text,
data jsonb
);
--
-- Name: scans; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.scans (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
audit_id uuid NOT NULL,
status text,
errors jsonb DEFAULT jsonb_build_array(),
percentage numeric DEFAULT '0'::numeric NOT NULL,
pages jsonb DEFAULT jsonb_build_array(),
processed_pages jsonb DEFAULT jsonb_build_array()
);
--
-- Name: users; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.users (
id uuid DEFAULT gen_random_uuid() NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
name text NOT NULL,
email text NOT NULL,
type text DEFAULT 'member'::text,
analytics jsonb,
apikey uuid DEFAULT gen_random_uuid() NOT NULL
);
--
-- Name: hdb_action_log hdb_action_log_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_action_log
ADD CONSTRAINT hdb_action_log_pkey PRIMARY KEY (id);
--
-- Name: hdb_cron_event_invocation_logs hdb_cron_event_invocation_logs_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_cron_event_invocation_logs
ADD CONSTRAINT hdb_cron_event_invocation_logs_pkey PRIMARY KEY (id);
--
-- Name: hdb_cron_events hdb_cron_events_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_cron_events
ADD CONSTRAINT hdb_cron_events_pkey PRIMARY KEY (id);
--
-- Name: hdb_metadata hdb_metadata_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_metadata
ADD CONSTRAINT hdb_metadata_pkey PRIMARY KEY (id);
--
-- Name: hdb_metadata hdb_metadata_resource_version_key; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_metadata
ADD CONSTRAINT hdb_metadata_resource_version_key UNIQUE (resource_version);
--
-- Name: hdb_scheduled_event_invocation_logs hdb_scheduled_event_invocation_logs_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_scheduled_event_invocation_logs
ADD CONSTRAINT hdb_scheduled_event_invocation_logs_pkey PRIMARY KEY (id);
--
-- Name: hdb_scheduled_events hdb_scheduled_events_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_scheduled_events
ADD CONSTRAINT hdb_scheduled_events_pkey PRIMARY KEY (id);
--
-- Name: hdb_schema_notifications hdb_schema_notifications_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_schema_notifications
ADD CONSTRAINT hdb_schema_notifications_pkey PRIMARY KEY (id);
--
-- Name: hdb_version hdb_version_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_version
ADD CONSTRAINT hdb_version_pkey PRIMARY KEY (hasura_uuid);
--
-- Name: audits audits_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.audits
ADD CONSTRAINT audits_pkey PRIMARY KEY (id);
--
-- Name: blocker_messages blocker_messages_message_id_blocker_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.blocker_messages
ADD CONSTRAINT blocker_messages_message_id_blocker_id_key UNIQUE (message_id, blocker_id);
--
-- Name: tags blocker_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.tags
ADD CONSTRAINT blocker_tags_pkey PRIMARY KEY (id);
--
-- Name: blocker_messages blocker_type_blockers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.blocker_messages
ADD CONSTRAINT blocker_type_blockers_pkey PRIMARY KEY (id);
--
-- Name: message_tags blocker_type_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.message_tags
ADD CONSTRAINT blocker_type_tags_pkey PRIMARY KEY (id);
--
-- Name: messages blocker_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.messages
ADD CONSTRAINT blocker_types_pkey PRIMARY KEY (id);
--
-- Name: invites invites_email_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.invites
ADD CONSTRAINT invites_email_key UNIQUE (email);
--
-- Name: invites invites_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.invites
ADD CONSTRAINT invites_pkey PRIMARY KEY (id);
--
-- Name: ignored_blockers issue_updates_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.ignored_blockers
ADD CONSTRAINT issue_updates_pkey PRIMARY KEY (id);
--
-- Name: blockers issues_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.blockers
ADD CONSTRAINT issues_pkey PRIMARY KEY (id);
--
-- Name: logs logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.logs
ADD CONSTRAINT logs_pkey PRIMARY KEY (id);
--
-- Name: message_tags message_tags_message_id_tag_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.message_tags
ADD CONSTRAINT message_tags_message_id_tag_id_key UNIQUE (message_id, tag_id);
--
-- Name: scans scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.scans
ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
--
-- Name: urls urls_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.urls
ADD CONSTRAINT urls_pkey PRIMARY KEY (id);
--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
--
-- Name: hdb_cron_event_invocation_event_id; Type: INDEX; Schema: hdb_catalog; Owner: -
--
CREATE INDEX hdb_cron_event_invocation_event_id ON hdb_catalog.hdb_cron_event_invocation_logs USING btree (event_id);
--
-- Name: hdb_cron_event_status; Type: INDEX; Schema: hdb_catalog; Owner: -
--
CREATE INDEX hdb_cron_event_status ON hdb_catalog.hdb_cron_events USING btree (status);
--
-- Name: hdb_cron_events_unique_scheduled; Type: INDEX; Schema: hdb_catalog; Owner: -
--
CREATE UNIQUE INDEX hdb_cron_events_unique_scheduled ON hdb_catalog.hdb_cron_events USING btree (trigger_name, scheduled_time) WHERE (status = 'scheduled'::text);
--
-- Name: hdb_scheduled_event_status; Type: INDEX; Schema: hdb_catalog; Owner: -
--
CREATE INDEX hdb_scheduled_event_status ON hdb_catalog.hdb_scheduled_events USING btree (status);
--
-- Name: hdb_version_one_row; Type: INDEX; Schema: hdb_catalog; Owner: -
--
CREATE UNIQUE INDEX hdb_version_one_row ON hdb_catalog.hdb_version USING btree (((version IS NOT NULL)));
--
-- Name: blockers_short_id; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX blockers_short_id ON public.blockers USING btree (audit_id, short_id);
--
-- Name: idx_blocker_messages_blocker_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_blocker_messages_blocker_id ON public.blocker_messages USING btree (blocker_id);
--
-- Name: idx_blocker_messages_message_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_blocker_messages_message_id ON public.blocker_messages USING btree (message_id);
--
-- Name: idx_blockers_audit_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_blockers_audit_id ON public.blockers USING btree (audit_id);
--
-- Name: idx_blockers_scan_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_blockers_scan_id ON public.blockers USING btree (scan_id);
--
-- Name: idx_blockers_url_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_blockers_url_id ON public.blockers USING btree (url_id);
--
-- Name: idx_message_tags_message_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_message_tags_message_id ON public.message_tags USING btree (message_id);
--
-- Name: idx_message_tags_tag_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_message_tags_tag_id ON public.message_tags USING btree (tag_id);
--
-- Name: idx_scans_status_updated; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_scans_status_updated ON public.scans USING btree (status, updated_at);
--
-- Name: idx_urls_audit_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_urls_audit_id ON public.urls USING btree (audit_id);
--
-- Name: audits set_public_audits_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_audits_updated_at BEFORE UPDATE ON public.audits FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_audits_updated_at ON audits; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_audits_updated_at ON public.audits IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: blocker_messages set_public_blocker_type_blockers_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_blocker_type_blockers_updated_at BEFORE UPDATE ON public.blocker_messages FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_blocker_type_blockers_updated_at ON blocker_messages; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_blocker_type_blockers_updated_at ON public.blocker_messages IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: message_tags set_public_blocker_type_tags_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_blocker_type_tags_updated_at BEFORE UPDATE ON public.message_tags FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_blocker_type_tags_updated_at ON message_tags; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_blocker_type_tags_updated_at ON public.message_tags IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: invites set_public_invites_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_invites_updated_at BEFORE UPDATE ON public.invites FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_invites_updated_at ON invites; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_invites_updated_at ON public.invites IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: ignored_blockers set_public_issue_updates_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_issue_updates_updated_at BEFORE UPDATE ON public.ignored_blockers FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_issue_updates_updated_at ON ignored_blockers; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_issue_updates_updated_at ON public.ignored_blockers IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: blockers set_public_issues_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_issues_updated_at BEFORE UPDATE ON public.blockers FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_issues_updated_at ON blockers; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_issues_updated_at ON public.blockers IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: logs set_public_logs_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_logs_updated_at BEFORE UPDATE ON public.logs FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_logs_updated_at ON logs; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_logs_updated_at ON public.logs IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: scans set_public_scans_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_scans_updated_at BEFORE UPDATE ON public.scans FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_scans_updated_at ON scans; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_scans_updated_at ON public.scans IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: urls set_public_urls_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_urls_updated_at BEFORE UPDATE ON public.urls FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_urls_updated_at ON urls; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_urls_updated_at ON public.urls IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: users set_public_users_updated_at; Type: TRIGGER; Schema: public; Owner: -
--
CREATE TRIGGER set_public_users_updated_at BEFORE UPDATE ON public.users FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();
--
-- Name: TRIGGER set_public_users_updated_at ON users; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TRIGGER set_public_users_updated_at ON public.users IS 'trigger to set value of column "updated_at" to current timestamp on row update';
--
-- Name: hdb_cron_event_invocation_logs hdb_cron_event_invocation_logs_event_id_fkey; Type: FK CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_cron_event_invocation_logs
ADD CONSTRAINT hdb_cron_event_invocation_logs_event_id_fkey FOREIGN KEY (event_id) REFERENCES hdb_catalog.hdb_cron_events(id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: hdb_scheduled_event_invocation_logs hdb_scheduled_event_invocation_logs_event_id_fkey; Type: FK CONSTRAINT; Schema: hdb_catalog; Owner: -
--
ALTER TABLE ONLY hdb_catalog.hdb_scheduled_event_invocation_logs
ADD CONSTRAINT hdb_scheduled_event_invocation_logs_event_id_fkey FOREIGN KEY (event_id) REFERENCES hdb_catalog.hdb_scheduled_events(id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- PostgreSQL database dump complete
--
\unrestrict w0UCtZUAkqllrkWsq8VVIBLlGNK3f5ezOdm6EvNhX5O5xGQEfYRD5Am35egQpHu