hK3Nv5Dm

15,6c5,6
2< -- Dumped from database version 11.2
3< -- Dumped by pg_dump version 11.2
4---
5> -- Dumped from database version 10.7 (Ubuntu 10.7-0ubuntu0.18.04.1)
6> -- Dumped by pg_dump version 10.7 (Ubuntu 10.7-0ubuntu0.18.04.1)
717a18,31
8> --
9> -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
10> --
11> 
12> CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
13> 
14> 
15> --
16> -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
17> --
18> 
19> COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
20> 
21> 
2223c37
23< -- Name: access_tokens; Type: TABLE; Schema: public; Owner: synapse
24---
25> -- Name: access_tokens; Type: TABLE; Schema: public; Owner: synapse_user
2635c49
27< ALTER TABLE public.access_tokens OWNER TO synapse;
28---
29> ALTER TABLE public.access_tokens OWNER TO synapse_user;
3038c52
31< -- Name: account_data; Type: TABLE; Schema: public; Owner: synapse
32---
33> -- Name: account_data; Type: TABLE; Schema: public; Owner: synapse_user
3449c63
35< ALTER TABLE public.account_data OWNER TO synapse;
36---
37> ALTER TABLE public.account_data OWNER TO synapse_user;
3852c66
39< -- Name: account_data_max_stream_id; Type: TABLE; Schema: public; Owner: synapse
40---
41> -- Name: account_data_max_stream_id; Type: TABLE; Schema: public; Owner: synapse_user
4262c76
43< ALTER TABLE public.account_data_max_stream_id OWNER TO synapse;
44---
45> ALTER TABLE public.account_data_max_stream_id OWNER TO synapse_user;
4665c79
47< -- Name: application_services; Type: TABLE; Schema: public; Owner: synapse
48---
49> -- Name: application_services; Type: TABLE; Schema: public; Owner: synapse_user
5077c91
51< ALTER TABLE public.application_services OWNER TO synapse;
52---
53> ALTER TABLE public.application_services OWNER TO synapse_user;
5480c94
55< -- Name: application_services_regex; Type: TABLE; Schema: public; Owner: synapse
56---
57> -- Name: application_services_regex; Type: TABLE; Schema: public; Owner: synapse_user
5891c105
59< ALTER TABLE public.application_services_regex OWNER TO synapse;
60---
61> ALTER TABLE public.application_services_regex OWNER TO synapse_user;
6294c108
63< -- Name: application_services_state; Type: TABLE; Schema: public; Owner: synapse
64---
65> -- Name: application_services_state; Type: TABLE; Schema: public; Owner: synapse_user
66104c118
67< ALTER TABLE public.application_services_state OWNER TO synapse;
68---
69> ALTER TABLE public.application_services_state OWNER TO synapse_user;
70107c121
71< -- Name: application_services_txns; Type: TABLE; Schema: public; Owner: synapse
72---
73> -- Name: application_services_txns; Type: TABLE; Schema: public; Owner: synapse_user
74117c131
75< ALTER TABLE public.application_services_txns OWNER TO synapse;
76---
77> ALTER TABLE public.application_services_txns OWNER TO synapse_user;
78120c134
79< -- Name: applied_module_schemas; Type: TABLE; Schema: public; Owner: synapse
80---
81> -- Name: applied_module_schemas; Type: TABLE; Schema: public; Owner: synapse_user
82129c143
83< ALTER TABLE public.applied_module_schemas OWNER TO synapse;
84---
85> ALTER TABLE public.applied_module_schemas OWNER TO synapse_user;
86132c146
87< -- Name: applied_schema_deltas; Type: TABLE; Schema: public; Owner: synapse
88---
89> -- Name: applied_schema_deltas; Type: TABLE; Schema: public; Owner: synapse_user
90141c155
91< ALTER TABLE public.applied_schema_deltas OWNER TO synapse;
92---
93> ALTER TABLE public.applied_schema_deltas OWNER TO synapse_user;
94144c158
95< -- Name: appservice_room_list; Type: TABLE; Schema: public; Owner: synapse
96---
97> -- Name: appservice_room_list; Type: TABLE; Schema: public; Owner: synapse_user
98154c168
99< ALTER TABLE public.appservice_room_list OWNER TO synapse;
100---
101> ALTER TABLE public.appservice_room_list OWNER TO synapse_user;
102157c171
103< -- Name: appservice_stream_position; Type: TABLE; Schema: public; Owner: synapse
104---
105> -- Name: appservice_stream_position; Type: TABLE; Schema: public; Owner: synapse_user
106167c181
107< ALTER TABLE public.appservice_stream_position OWNER TO synapse;
108---
109> ALTER TABLE public.appservice_stream_position OWNER TO synapse_user;
110170c184
111< -- Name: background_updates; Type: TABLE; Schema: public; Owner: synapse
112---
113> -- Name: background_updates; Type: TABLE; Schema: public; Owner: synapse_user
114180c194
115< ALTER TABLE public.background_updates OWNER TO synapse;
116---
117> ALTER TABLE public.background_updates OWNER TO synapse_user;
118183c197
119< -- Name: blocked_rooms; Type: TABLE; Schema: public; Owner: synapse
120---
121> -- Name: blocked_rooms; Type: TABLE; Schema: public; Owner: synapse_user
122192c206
123< ALTER TABLE public.blocked_rooms OWNER TO synapse;
124---
125> ALTER TABLE public.blocked_rooms OWNER TO synapse_user;
126195c209
127< -- Name: cache_invalidation_stream; Type: TABLE; Schema: public; Owner: synapse
128---
129> -- Name: cache_invalidation_stream; Type: TABLE; Schema: public; Owner: synapse_user
130206c220
131< ALTER TABLE public.cache_invalidation_stream OWNER TO synapse;
132---
133> ALTER TABLE public.cache_invalidation_stream OWNER TO synapse_user;
134209c223
135< -- Name: current_state_delta_stream; Type: TABLE; Schema: public; Owner: synapse
136---
137> -- Name: current_state_delta_stream; Type: TABLE; Schema: public; Owner: synapse_user
138222c236
139< ALTER TABLE public.current_state_delta_stream OWNER TO synapse;
140---
141> ALTER TABLE public.current_state_delta_stream OWNER TO synapse_user;
142225c239
143< -- Name: current_state_events; Type: TABLE; Schema: public; Owner: synapse
144---
145> -- Name: current_state_events; Type: TABLE; Schema: public; Owner: synapse_user
146236c250
147< ALTER TABLE public.current_state_events OWNER TO synapse;
148---
149> ALTER TABLE public.current_state_events OWNER TO synapse_user;
150239c253
151< -- Name: current_state_resets; Type: TABLE; Schema: public; Owner: synapse
152---
153> -- Name: current_state_resets; Type: TABLE; Schema: public; Owner: synapse_user
154247c261
155< ALTER TABLE public.current_state_resets OWNER TO synapse;
156---
157> ALTER TABLE public.current_state_resets OWNER TO synapse_user;
158250c264
159< -- Name: deleted_pushers; Type: TABLE; Schema: public; Owner: synapse
160---
161> -- Name: deleted_pushers; Type: TABLE; Schema: public; Owner: synapse_user
162261c275
163< ALTER TABLE public.deleted_pushers OWNER TO synapse;
164---
165> ALTER TABLE public.deleted_pushers OWNER TO synapse_user;
166264c278
167< -- Name: destinations; Type: TABLE; Schema: public; Owner: synapse
168---
169> -- Name: destinations; Type: TABLE; Schema: public; Owner: synapse_user
170274c288
171< ALTER TABLE public.destinations OWNER TO synapse;
172---
173> ALTER TABLE public.destinations OWNER TO synapse_user;
174277c291
175< -- Name: device_federation_inbox; Type: TABLE; Schema: public; Owner: synapse
176---
177> -- Name: device_federation_inbox; Type: TABLE; Schema: public; Owner: synapse_user
178287c301
179< ALTER TABLE public.device_federation_inbox OWNER TO synapse;
180---
181> ALTER TABLE public.device_federation_inbox OWNER TO synapse_user;
182290c304
183< -- Name: device_federation_outbox; Type: TABLE; Schema: public; Owner: synapse
184---
185> -- Name: device_federation_outbox; Type: TABLE; Schema: public; Owner: synapse_user
186301c315
187< ALTER TABLE public.device_federation_outbox OWNER TO synapse;
188---
189> ALTER TABLE public.device_federation_outbox OWNER TO synapse_user;
190304c318
191< -- Name: device_inbox; Type: TABLE; Schema: public; Owner: synapse
192---
193> -- Name: device_inbox; Type: TABLE; Schema: public; Owner: synapse_user
194315c329
195< ALTER TABLE public.device_inbox OWNER TO synapse;
196---
197> ALTER TABLE public.device_inbox OWNER TO synapse_user;
198318c332
199< -- Name: device_lists_outbound_last_success; Type: TABLE; Schema: public; Owner: synapse
200---
201> -- Name: device_lists_outbound_last_success; Type: TABLE; Schema: public; Owner: synapse_user
202328c342
203< ALTER TABLE public.device_lists_outbound_last_success OWNER TO synapse;
204---
205> ALTER TABLE public.device_lists_outbound_last_success OWNER TO synapse_user;
206331c345
207< -- Name: device_lists_outbound_pokes; Type: TABLE; Schema: public; Owner: synapse
208---
209> -- Name: device_lists_outbound_pokes; Type: TABLE; Schema: public; Owner: synapse_user
210344c358
211< ALTER TABLE public.device_lists_outbound_pokes OWNER TO synapse;
212---
213> ALTER TABLE public.device_lists_outbound_pokes OWNER TO synapse_user;
214347c361
215< -- Name: device_lists_remote_cache; Type: TABLE; Schema: public; Owner: synapse
216---
217> -- Name: device_lists_remote_cache; Type: TABLE; Schema: public; Owner: synapse_user
218357c371
219< ALTER TABLE public.device_lists_remote_cache OWNER TO synapse;
220---
221> ALTER TABLE public.device_lists_remote_cache OWNER TO synapse_user;
222360c374
223< -- Name: device_lists_remote_extremeties; Type: TABLE; Schema: public; Owner: synapse
224---
225> -- Name: device_lists_remote_extremeties; Type: TABLE; Schema: public; Owner: synapse_user
226369c383
227< ALTER TABLE public.device_lists_remote_extremeties OWNER TO synapse;
228---
229> ALTER TABLE public.device_lists_remote_extremeties OWNER TO synapse_user;
230372c386
231< -- Name: device_lists_stream; Type: TABLE; Schema: public; Owner: synapse
232---
233> -- Name: device_lists_stream; Type: TABLE; Schema: public; Owner: synapse_user
234382c396
235< ALTER TABLE public.device_lists_stream OWNER TO synapse;
236---
237> ALTER TABLE public.device_lists_stream OWNER TO synapse_user;
238385c399
239< -- Name: device_max_stream_id; Type: TABLE; Schema: public; Owner: synapse
240---
241> -- Name: device_max_stream_id; Type: TABLE; Schema: public; Owner: synapse_user
242393c407
243< ALTER TABLE public.device_max_stream_id OWNER TO synapse;
244---
245> ALTER TABLE public.device_max_stream_id OWNER TO synapse_user;
246396c410
247< -- Name: devices; Type: TABLE; Schema: public; Owner: synapse
248---
249> -- Name: devices; Type: TABLE; Schema: public; Owner: synapse_user
250406c420
251< ALTER TABLE public.devices OWNER TO synapse;
252---
253> ALTER TABLE public.devices OWNER TO synapse_user;
254409c423
255< -- Name: e2e_device_keys_json; Type: TABLE; Schema: public; Owner: synapse
256---
257> -- Name: e2e_device_keys_json; Type: TABLE; Schema: public; Owner: synapse_user
258420c434
259< ALTER TABLE public.e2e_device_keys_json OWNER TO synapse;
260---
261> ALTER TABLE public.e2e_device_keys_json OWNER TO synapse_user;
262423c437
263< -- Name: e2e_one_time_keys_json; Type: TABLE; Schema: public; Owner: synapse
264---
265> -- Name: e2e_one_time_keys_json; Type: TABLE; Schema: public; Owner: synapse_user
266436c450
267< ALTER TABLE public.e2e_one_time_keys_json OWNER TO synapse;
268---
269> ALTER TABLE public.e2e_one_time_keys_json OWNER TO synapse_user;
270439c453
271< -- Name: e2e_room_keys; Type: TABLE; Schema: public; Owner: synapse
272---
273> -- Name: e2e_room_keys; Type: TABLE; Schema: public; Owner: synapse_user
274454c468
275< ALTER TABLE public.e2e_room_keys OWNER TO synapse;
276---
277> ALTER TABLE public.e2e_room_keys OWNER TO synapse_user;
278457c471
279< -- Name: e2e_room_keys_versions; Type: TABLE; Schema: public; Owner: synapse
280---
281> -- Name: e2e_room_keys_versions; Type: TABLE; Schema: public; Owner: synapse_user
282469c483
283< ALTER TABLE public.e2e_room_keys_versions OWNER TO synapse;
284---
285> ALTER TABLE public.e2e_room_keys_versions OWNER TO synapse_user;
286472c486
287< -- Name: erased_users; Type: TABLE; Schema: public; Owner: synapse
288---
289> -- Name: erased_users; Type: TABLE; Schema: public; Owner: synapse_user
290480c494
291< ALTER TABLE public.erased_users OWNER TO synapse;
292---
293> ALTER TABLE public.erased_users OWNER TO synapse_user;
294483c497
295< -- Name: event_auth; Type: TABLE; Schema: public; Owner: synapse
296---
297> -- Name: event_auth; Type: TABLE; Schema: public; Owner: synapse_user
298493c507
299< ALTER TABLE public.event_auth OWNER TO synapse;
300---
301> ALTER TABLE public.event_auth OWNER TO synapse_user;
302496c510
303< -- Name: event_backward_extremities; Type: TABLE; Schema: public; Owner: synapse
304---
305> -- Name: event_backward_extremities; Type: TABLE; Schema: public; Owner: synapse_user
306505c519
307< ALTER TABLE public.event_backward_extremities OWNER TO synapse;
308---
309> ALTER TABLE public.event_backward_extremities OWNER TO synapse_user;
310508c522
311< -- Name: event_content_hashes; Type: TABLE; Schema: public; Owner: synapse
312---
313> -- Name: event_content_hashes; Type: TABLE; Schema: public; Owner: synapse_user
314518c532
315< ALTER TABLE public.event_content_hashes OWNER TO synapse;
316---
317> ALTER TABLE public.event_content_hashes OWNER TO synapse_user;
318521c535
319< -- Name: event_destinations; Type: TABLE; Schema: public; Owner: synapse
320---
321> -- Name: event_destinations; Type: TABLE; Schema: public; Owner: synapse_user
322531c545
323< ALTER TABLE public.event_destinations OWNER TO synapse;
324---
325> ALTER TABLE public.event_destinations OWNER TO synapse_user;
326534c548
327< -- Name: event_edge_hashes; Type: TABLE; Schema: public; Owner: synapse
328---
329> -- Name: event_edge_hashes; Type: TABLE; Schema: public; Owner: synapse_user
330545c559
331< ALTER TABLE public.event_edge_hashes OWNER TO synapse;
332---
333> ALTER TABLE public.event_edge_hashes OWNER TO synapse_user;
334548c562
335< -- Name: event_edges; Type: TABLE; Schema: public; Owner: synapse
336---
337> -- Name: event_edges; Type: TABLE; Schema: public; Owner: synapse_user
338559c573
339< ALTER TABLE public.event_edges OWNER TO synapse;
340---
341> ALTER TABLE public.event_edges OWNER TO synapse_user;
342562c576
343< -- Name: event_forward_extremities; Type: TABLE; Schema: public; Owner: synapse
344---
345> -- Name: event_forward_extremities; Type: TABLE; Schema: public; Owner: synapse_user
346571c585
347< ALTER TABLE public.event_forward_extremities OWNER TO synapse;
348---
349> ALTER TABLE public.event_forward_extremities OWNER TO synapse_user;
350574c588
351< -- Name: event_json; Type: TABLE; Schema: public; Owner: synapse
352---
353> -- Name: event_json; Type: TABLE; Schema: public; Owner: synapse_user
354586c600
355< ALTER TABLE public.event_json OWNER TO synapse;
356---
357> ALTER TABLE public.event_json OWNER TO synapse_user;
358589c603
359< -- Name: event_push_actions; Type: TABLE; Schema: public; Owner: synapse
360---
361> -- Name: event_push_actions; Type: TABLE; Schema: public; Owner: synapse_user
362605c619
363< ALTER TABLE public.event_push_actions OWNER TO synapse;
364---
365> ALTER TABLE public.event_push_actions OWNER TO synapse_user;
366608c622
367< -- Name: event_push_actions_staging; Type: TABLE; Schema: public; Owner: synapse
368---
369> -- Name: event_push_actions_staging; Type: TABLE; Schema: public; Owner: synapse_user
370620c634
371< ALTER TABLE public.event_push_actions_staging OWNER TO synapse;
372---
373> ALTER TABLE public.event_push_actions_staging OWNER TO synapse_user;
374623c637
375< -- Name: event_push_summary; Type: TABLE; Schema: public; Owner: synapse
376---
377> -- Name: event_push_summary; Type: TABLE; Schema: public; Owner: synapse_user
378634c648
379< ALTER TABLE public.event_push_summary OWNER TO synapse;
380---
381> ALTER TABLE public.event_push_summary OWNER TO synapse_user;
382637c651
383< -- Name: event_push_summary_stream_ordering; Type: TABLE; Schema: public; Owner: synapse
384---
385> -- Name: event_push_summary_stream_ordering; Type: TABLE; Schema: public; Owner: synapse_user
386647c661
387< ALTER TABLE public.event_push_summary_stream_ordering OWNER TO synapse;
388---
389> ALTER TABLE public.event_push_summary_stream_ordering OWNER TO synapse_user;
390650c664
391< -- Name: event_reference_hashes; Type: TABLE; Schema: public; Owner: synapse
392---
393> -- Name: event_reference_hashes; Type: TABLE; Schema: public; Owner: synapse_user
394660c674
395< ALTER TABLE public.event_reference_hashes OWNER TO synapse;
396---
397> ALTER TABLE public.event_reference_hashes OWNER TO synapse_user;
398663c677
399< -- Name: event_reports; Type: TABLE; Schema: public; Owner: synapse
400---
401> -- Name: event_reports; Type: TABLE; Schema: public; Owner: synapse_user
402677c691
403< ALTER TABLE public.event_reports OWNER TO synapse;
404---
405> ALTER TABLE public.event_reports OWNER TO synapse_user;
406680c694
407< -- Name: event_search; Type: TABLE; Schema: public; Owner: synapse
408---
409> -- Name: event_search; Type: TABLE; Schema: public; Owner: synapse_user
410694c708
411< ALTER TABLE public.event_search OWNER TO synapse;
412---
413> ALTER TABLE public.event_search OWNER TO synapse_user;
414697c711
415< -- Name: event_signatures; Type: TABLE; Schema: public; Owner: synapse
416---
417> -- Name: event_signatures; Type: TABLE; Schema: public; Owner: synapse_user
418708c722
419< ALTER TABLE public.event_signatures OWNER TO synapse;
420---
421> ALTER TABLE public.event_signatures OWNER TO synapse_user;
422711c725
423< -- Name: event_to_state_groups; Type: TABLE; Schema: public; Owner: synapse
424---
425> -- Name: event_to_state_groups; Type: TABLE; Schema: public; Owner: synapse_user
426720c734
427< ALTER TABLE public.event_to_state_groups OWNER TO synapse;
428---
429> ALTER TABLE public.event_to_state_groups OWNER TO synapse_user;
430723c737
431< -- Name: events; Type: TABLE; Schema: public; Owner: synapse
432---
433> -- Name: events; Type: TABLE; Schema: public; Owner: synapse_user
434744c758
435< ALTER TABLE public.events OWNER TO synapse;
436---
437> ALTER TABLE public.events OWNER TO synapse_user;
438747c761
439< -- Name: ex_outlier_stream; Type: TABLE; Schema: public; Owner: synapse
440---
441> -- Name: ex_outlier_stream; Type: TABLE; Schema: public; Owner: synapse_user
442757c771
443< ALTER TABLE public.ex_outlier_stream OWNER TO synapse;
444---
445> ALTER TABLE public.ex_outlier_stream OWNER TO synapse_user;
446760c774
447< -- Name: federation_stream_position; Type: TABLE; Schema: public; Owner: synapse
448---
449> -- Name: federation_stream_position; Type: TABLE; Schema: public; Owner: synapse_user
450769c783
451< ALTER TABLE public.federation_stream_position OWNER TO synapse;
452---
453> ALTER TABLE public.federation_stream_position OWNER TO synapse_user;
454772c786
455< -- Name: feedback; Type: TABLE; Schema: public; Owner: synapse
456---
457> -- Name: feedback; Type: TABLE; Schema: public; Owner: synapse_user
458784c798
459< ALTER TABLE public.feedback OWNER TO synapse;
460---
461> ALTER TABLE public.feedback OWNER TO synapse_user;
462787c801
463< -- Name: group_attestations_remote; Type: TABLE; Schema: public; Owner: synapse
464---
465> -- Name: group_attestations_remote; Type: TABLE; Schema: public; Owner: synapse_user
466798c812
467< ALTER TABLE public.group_attestations_remote OWNER TO synapse;
468---
469> ALTER TABLE public.group_attestations_remote OWNER TO synapse_user;
470801c815
471< -- Name: group_attestations_renewals; Type: TABLE; Schema: public; Owner: synapse
472---
473> -- Name: group_attestations_renewals; Type: TABLE; Schema: public; Owner: synapse_user
474811c825
475< ALTER TABLE public.group_attestations_renewals OWNER TO synapse;
476---
477> ALTER TABLE public.group_attestations_renewals OWNER TO synapse_user;
478814c828
479< -- Name: group_invites; Type: TABLE; Schema: public; Owner: synapse
480---
481> -- Name: group_invites; Type: TABLE; Schema: public; Owner: synapse_user
482823c837
483< ALTER TABLE public.group_invites OWNER TO synapse;
484---
485> ALTER TABLE public.group_invites OWNER TO synapse_user;
486826c840
487< -- Name: group_roles; Type: TABLE; Schema: public; Owner: synapse
488---
489> -- Name: group_roles; Type: TABLE; Schema: public; Owner: synapse_user
490837c851
491< ALTER TABLE public.group_roles OWNER TO synapse;
492---
493> ALTER TABLE public.group_roles OWNER TO synapse_user;
494840c854
495< -- Name: group_room_categories; Type: TABLE; Schema: public; Owner: synapse
496---
497> -- Name: group_room_categories; Type: TABLE; Schema: public; Owner: synapse_user
498851c865
499< ALTER TABLE public.group_room_categories OWNER TO synapse;
500---
501> ALTER TABLE public.group_room_categories OWNER TO synapse_user;
502854c868
503< -- Name: group_rooms; Type: TABLE; Schema: public; Owner: synapse
504---
505> -- Name: group_rooms; Type: TABLE; Schema: public; Owner: synapse_user
506864c878
507< ALTER TABLE public.group_rooms OWNER TO synapse;
508---
509> ALTER TABLE public.group_rooms OWNER TO synapse_user;
510867c881
511< -- Name: group_summary_roles; Type: TABLE; Schema: public; Owner: synapse
512---
513> -- Name: group_summary_roles; Type: TABLE; Schema: public; Owner: synapse_user
514878c892
515< ALTER TABLE public.group_summary_roles OWNER TO synapse;
516---
517> ALTER TABLE public.group_summary_roles OWNER TO synapse_user;
518881c895
519< -- Name: group_summary_room_categories; Type: TABLE; Schema: public; Owner: synapse
520---
521> -- Name: group_summary_room_categories; Type: TABLE; Schema: public; Owner: synapse_user
522892c906
523< ALTER TABLE public.group_summary_room_categories OWNER TO synapse;
524---
525> ALTER TABLE public.group_summary_room_categories OWNER TO synapse_user;
526895c909
527< -- Name: group_summary_rooms; Type: TABLE; Schema: public; Owner: synapse
528---
529> -- Name: group_summary_rooms; Type: TABLE; Schema: public; Owner: synapse_user
530908c922
531< ALTER TABLE public.group_summary_rooms OWNER TO synapse;
532---
533> ALTER TABLE public.group_summary_rooms OWNER TO synapse_user;
534911c925
535< -- Name: group_summary_users; Type: TABLE; Schema: public; Owner: synapse
536---
537> -- Name: group_summary_users; Type: TABLE; Schema: public; Owner: synapse_user
538923c937
539< ALTER TABLE public.group_summary_users OWNER TO synapse;
540---
541> ALTER TABLE public.group_summary_users OWNER TO synapse_user;
542926c940
543< -- Name: group_users; Type: TABLE; Schema: public; Owner: synapse
544---
545> -- Name: group_users; Type: TABLE; Schema: public; Owner: synapse_user
546937c951
547< ALTER TABLE public.group_users OWNER TO synapse;
548---
549> ALTER TABLE public.group_users OWNER TO synapse_user;
550940c954
551< -- Name: groups; Type: TABLE; Schema: public; Owner: synapse
552---
553> -- Name: groups; Type: TABLE; Schema: public; Owner: synapse_user
554954c968
555< ALTER TABLE public.groups OWNER TO synapse;
556---
557> ALTER TABLE public.groups OWNER TO synapse_user;
558957c971
559< -- Name: guest_access; Type: TABLE; Schema: public; Owner: synapse
560---
561> -- Name: guest_access; Type: TABLE; Schema: public; Owner: synapse_user
562967c981
563< ALTER TABLE public.guest_access OWNER TO synapse;
564---
565> ALTER TABLE public.guest_access OWNER TO synapse_user;
566970c984
567< -- Name: history_visibility; Type: TABLE; Schema: public; Owner: synapse
568---
569> -- Name: history_visibility; Type: TABLE; Schema: public; Owner: synapse_user
570980c994
571< ALTER TABLE public.history_visibility OWNER TO synapse;
572---
573> ALTER TABLE public.history_visibility OWNER TO synapse_user;
574983c997
575< -- Name: local_group_membership; Type: TABLE; Schema: public; Owner: synapse
576---
577> -- Name: local_group_membership; Type: TABLE; Schema: public; Owner: synapse_user
578996c1010
579< ALTER TABLE public.local_group_membership OWNER TO synapse;
580---
581> ALTER TABLE public.local_group_membership OWNER TO synapse_user;
582999c1013
583< -- Name: local_group_updates; Type: TABLE; Schema: public; Owner: synapse
584---
585> -- Name: local_group_updates; Type: TABLE; Schema: public; Owner: synapse_user
5861011c1025
587< ALTER TABLE public.local_group_updates OWNER TO synapse;
588---
589> ALTER TABLE public.local_group_updates OWNER TO synapse_user;
5901014c1028
591< -- Name: local_invites; Type: TABLE; Schema: public; Owner: synapse
592---
593> -- Name: local_invites; Type: TABLE; Schema: public; Owner: synapse_user
5941028c1042
595< ALTER TABLE public.local_invites OWNER TO synapse;
596---
597> ALTER TABLE public.local_invites OWNER TO synapse_user;
5981031c1045
599< -- Name: local_media_repository; Type: TABLE; Schema: public; Owner: synapse
600---
601> -- Name: local_media_repository; Type: TABLE; Schema: public; Owner: synapse_user
6021047c1061
603< ALTER TABLE public.local_media_repository OWNER TO synapse;
604---
605> ALTER TABLE public.local_media_repository OWNER TO synapse_user;
6061050c1064
607< -- Name: local_media_repository_thumbnails; Type: TABLE; Schema: public; Owner: synapse
608---
609> -- Name: local_media_repository_thumbnails; Type: TABLE; Schema: public; Owner: synapse_user
6101063c1077
611< ALTER TABLE public.local_media_repository_thumbnails OWNER TO synapse;
612---
613> ALTER TABLE public.local_media_repository_thumbnails OWNER TO synapse_user;
6141066c1080
615< -- Name: local_media_repository_url_cache; Type: TABLE; Schema: public; Owner: synapse
616---
617> -- Name: local_media_repository_url_cache; Type: TABLE; Schema: public; Owner: synapse_user
6181080c1094
619< ALTER TABLE public.local_media_repository_url_cache OWNER TO synapse;
620---
621> ALTER TABLE public.local_media_repository_url_cache OWNER TO synapse_user;
6221083c1097
623< -- Name: monthly_active_users; Type: TABLE; Schema: public; Owner: synapse
624---
625> -- Name: monthly_active_users; Type: TABLE; Schema: public; Owner: synapse_user
6261092c1106
627< ALTER TABLE public.monthly_active_users OWNER TO synapse;
628---
629> ALTER TABLE public.monthly_active_users OWNER TO synapse_user;
6301095c1109
631< -- Name: open_id_tokens; Type: TABLE; Schema: public; Owner: synapse
632---
633> -- Name: open_id_tokens; Type: TABLE; Schema: public; Owner: synapse_user
6341105c1119
635< ALTER TABLE public.open_id_tokens OWNER TO synapse;
636---
637> ALTER TABLE public.open_id_tokens OWNER TO synapse_user;
6381108c1122,1135
639< -- Name: presence; Type: TABLE; Schema: public; Owner: synapse
640---
641> -- Name: port_from_sqlite3; Type: TABLE; Schema: public; Owner: synapse_user
642> --
643> 
644> CREATE TABLE public.port_from_sqlite3 (
645>     table_name character varying(100) NOT NULL,
646>     forward_rowid bigint NOT NULL,
647>     backward_rowid bigint NOT NULL
648> );
649> 
650> 
651> ALTER TABLE public.port_from_sqlite3 OWNER TO synapse_user;
652> 
653> --
654> -- Name: presence; Type: TABLE; Schema: public; Owner: synapse_user
6551119c1146
656< ALTER TABLE public.presence OWNER TO synapse;
657---
658> ALTER TABLE public.presence OWNER TO synapse_user;
6591122c1149
660< -- Name: presence_allow_inbound; Type: TABLE; Schema: public; Owner: synapse
661---
662> -- Name: presence_allow_inbound; Type: TABLE; Schema: public; Owner: synapse_user
6631131c1158
664< ALTER TABLE public.presence_allow_inbound OWNER TO synapse;
665---
666> ALTER TABLE public.presence_allow_inbound OWNER TO synapse_user;
6671134c1161
668< -- Name: presence_list; Type: TABLE; Schema: public; Owner: synapse
669---
670> -- Name: presence_list; Type: TABLE; Schema: public; Owner: synapse_user
6711144c1171
672< ALTER TABLE public.presence_list OWNER TO synapse;
673---
674> ALTER TABLE public.presence_list OWNER TO synapse_user;
6751147c1174
676< -- Name: presence_stream; Type: TABLE; Schema: public; Owner: synapse
677---
678> -- Name: presence_stream; Type: TABLE; Schema: public; Owner: synapse_user
6791162c1189
680< ALTER TABLE public.presence_stream OWNER TO synapse;
681---
682> ALTER TABLE public.presence_stream OWNER TO synapse_user;
6831165c1192
684< -- Name: profiles; Type: TABLE; Schema: public; Owner: synapse
685---
686> -- Name: profiles; Type: TABLE; Schema: public; Owner: synapse_user
6871175c1202
688< ALTER TABLE public.profiles OWNER TO synapse;
689---
690> ALTER TABLE public.profiles OWNER TO synapse_user;
6911178c1205
692< -- Name: public_room_list_stream; Type: TABLE; Schema: public; Owner: synapse
693---
694> -- Name: public_room_list_stream; Type: TABLE; Schema: public; Owner: synapse_user
6951190c1217
696< ALTER TABLE public.public_room_list_stream OWNER TO synapse;
697---
698> ALTER TABLE public.public_room_list_stream OWNER TO synapse_user;
6991193c1220
700< -- Name: push_rules; Type: TABLE; Schema: public; Owner: synapse
701---
702> -- Name: push_rules; Type: TABLE; Schema: public; Owner: synapse_user
7031207c1234
704< ALTER TABLE public.push_rules OWNER TO synapse;
705---
706> ALTER TABLE public.push_rules OWNER TO synapse_user;
7071210c1237
708< -- Name: push_rules_enable; Type: TABLE; Schema: public; Owner: synapse
709---
710> -- Name: push_rules_enable; Type: TABLE; Schema: public; Owner: synapse_user
7111221c1248
712< ALTER TABLE public.push_rules_enable OWNER TO synapse;
713---
714> ALTER TABLE public.push_rules_enable OWNER TO synapse_user;
7151224c1251
716< -- Name: push_rules_stream; Type: TABLE; Schema: public; Owner: synapse
717---
718> -- Name: push_rules_stream; Type: TABLE; Schema: public; Owner: synapse_user
7191240c1267
720< ALTER TABLE public.push_rules_stream OWNER TO synapse;
721---
722> ALTER TABLE public.push_rules_stream OWNER TO synapse_user;
7231243c1270
724< -- Name: pusher_throttle; Type: TABLE; Schema: public; Owner: synapse
725---
726> -- Name: pusher_throttle; Type: TABLE; Schema: public; Owner: synapse_user
7271254c1281
728< ALTER TABLE public.pusher_throttle OWNER TO synapse;
729---
730> ALTER TABLE public.pusher_throttle OWNER TO synapse_user;
7311257c1284
732< -- Name: pushers; Type: TABLE; Schema: public; Owner: synapse
733---
734> -- Name: pushers; Type: TABLE; Schema: public; Owner: synapse_user
7351279c1306
736< ALTER TABLE public.pushers OWNER TO synapse;
737---
738> ALTER TABLE public.pushers OWNER TO synapse_user;
7391282c1309
740< -- Name: ratelimit_override; Type: TABLE; Schema: public; Owner: synapse
741---
742> -- Name: ratelimit_override; Type: TABLE; Schema: public; Owner: synapse_user
7431292c1319
744< ALTER TABLE public.ratelimit_override OWNER TO synapse;
745---
746> ALTER TABLE public.ratelimit_override OWNER TO synapse_user;
7471295c1322
748< -- Name: receipts_graph; Type: TABLE; Schema: public; Owner: synapse
749---
750> -- Name: receipts_graph; Type: TABLE; Schema: public; Owner: synapse_user
7511307c1334
752< ALTER TABLE public.receipts_graph OWNER TO synapse;
753---
754> ALTER TABLE public.receipts_graph OWNER TO synapse_user;
7551310c1337
756< -- Name: receipts_linearized; Type: TABLE; Schema: public; Owner: synapse
757---
758> -- Name: receipts_linearized; Type: TABLE; Schema: public; Owner: synapse_user
7591323c1350
760< ALTER TABLE public.receipts_linearized OWNER TO synapse;
761---
762> ALTER TABLE public.receipts_linearized OWNER TO synapse_user;
7631326c1353
764< -- Name: received_transactions; Type: TABLE; Schema: public; Owner: synapse
765---
766> -- Name: received_transactions; Type: TABLE; Schema: public; Owner: synapse_user
7671339c1366
768< ALTER TABLE public.received_transactions OWNER TO synapse;
769---
770> ALTER TABLE public.received_transactions OWNER TO synapse_user;
7711342c1369
772< -- Name: redactions; Type: TABLE; Schema: public; Owner: synapse
773---
774> -- Name: redactions; Type: TABLE; Schema: public; Owner: synapse_user
7751351c1378
776< ALTER TABLE public.redactions OWNER TO synapse;
777---
778> ALTER TABLE public.redactions OWNER TO synapse_user;
7791354c1381
780< -- Name: rejections; Type: TABLE; Schema: public; Owner: synapse
781---
782> -- Name: rejections; Type: TABLE; Schema: public; Owner: synapse_user
7831364c1391
784< ALTER TABLE public.rejections OWNER TO synapse;
785---
786> ALTER TABLE public.rejections OWNER TO synapse_user;
7871367c1394
788< -- Name: remote_media_cache; Type: TABLE; Schema: public; Owner: synapse
789---
790> -- Name: remote_media_cache; Type: TABLE; Schema: public; Owner: synapse_user
7911383c1410
792< ALTER TABLE public.remote_media_cache OWNER TO synapse;
793---
794> ALTER TABLE public.remote_media_cache OWNER TO synapse_user;
7951386c1413
796< -- Name: remote_media_cache_thumbnails; Type: TABLE; Schema: public; Owner: synapse
797---
798> -- Name: remote_media_cache_thumbnails; Type: TABLE; Schema: public; Owner: synapse_user
7991401c1428
800< ALTER TABLE public.remote_media_cache_thumbnails OWNER TO synapse;
801---
802> ALTER TABLE public.remote_media_cache_thumbnails OWNER TO synapse_user;
8031404c1431
804< -- Name: remote_profile_cache; Type: TABLE; Schema: public; Owner: synapse
805---
806> -- Name: remote_profile_cache; Type: TABLE; Schema: public; Owner: synapse_user
8071415c1442
808< ALTER TABLE public.remote_profile_cache OWNER TO synapse;
809---
810> ALTER TABLE public.remote_profile_cache OWNER TO synapse_user;
8111418c1445
812< -- Name: room_account_data; Type: TABLE; Schema: public; Owner: synapse
813---
814> -- Name: room_account_data; Type: TABLE; Schema: public; Owner: synapse_user
8151430c1457
816< ALTER TABLE public.room_account_data OWNER TO synapse;
817---
818> ALTER TABLE public.room_account_data OWNER TO synapse_user;
8191433c1460
820< -- Name: room_alias_servers; Type: TABLE; Schema: public; Owner: synapse
821---
822> -- Name: room_alias_servers; Type: TABLE; Schema: public; Owner: synapse_user
8231442c1469
824< ALTER TABLE public.room_alias_servers OWNER TO synapse;
825---
826> ALTER TABLE public.room_alias_servers OWNER TO synapse_user;
8271445c1472
828< -- Name: room_aliases; Type: TABLE; Schema: public; Owner: synapse
829---
830> -- Name: room_aliases; Type: TABLE; Schema: public; Owner: synapse_user
8311455c1482
832< ALTER TABLE public.room_aliases OWNER TO synapse;
833---
834> ALTER TABLE public.room_aliases OWNER TO synapse_user;
8351458c1485
836< -- Name: room_depth; Type: TABLE; Schema: public; Owner: synapse
837---
838> -- Name: room_depth; Type: TABLE; Schema: public; Owner: synapse_user
8391467c1494
840< ALTER TABLE public.room_depth OWNER TO synapse;
841---
842> ALTER TABLE public.room_depth OWNER TO synapse_user;
8431470c1497
844< -- Name: room_hosts; Type: TABLE; Schema: public; Owner: synapse
845---
846> -- Name: room_hosts; Type: TABLE; Schema: public; Owner: synapse_user
8471479c1506
848< ALTER TABLE public.room_hosts OWNER TO synapse;
849---
850> ALTER TABLE public.room_hosts OWNER TO synapse_user;
8511482c1509
852< -- Name: room_memberships; Type: TABLE; Schema: public; Owner: synapse
853---
854> -- Name: room_memberships; Type: TABLE; Schema: public; Owner: synapse_user
8551497c1524
856< ALTER TABLE public.room_memberships OWNER TO synapse;
857---
858> ALTER TABLE public.room_memberships OWNER TO synapse_user;
8591500c1527
860< -- Name: room_names; Type: TABLE; Schema: public; Owner: synapse
861---
862> -- Name: room_names; Type: TABLE; Schema: public; Owner: synapse_user
8631510c1537
864< ALTER TABLE public.room_names OWNER TO synapse;
865---
866> ALTER TABLE public.room_names OWNER TO synapse_user;
8671513c1540
868< -- Name: room_tags; Type: TABLE; Schema: public; Owner: synapse
869---
870> -- Name: room_tags; Type: TABLE; Schema: public; Owner: synapse_user
8711524c1551
872< ALTER TABLE public.room_tags OWNER TO synapse;
873---
874> ALTER TABLE public.room_tags OWNER TO synapse_user;
8751527c1554
876< -- Name: room_tags_revisions; Type: TABLE; Schema: public; Owner: synapse
877---
878> -- Name: room_tags_revisions; Type: TABLE; Schema: public; Owner: synapse_user
8791537c1564
880< ALTER TABLE public.room_tags_revisions OWNER TO synapse;
881---
882> ALTER TABLE public.room_tags_revisions OWNER TO synapse_user;
8831540c1567
884< -- Name: rooms; Type: TABLE; Schema: public; Owner: synapse
885---
886> -- Name: rooms; Type: TABLE; Schema: public; Owner: synapse_user
8871550c1577
888< ALTER TABLE public.rooms OWNER TO synapse;
889---
890> ALTER TABLE public.rooms OWNER TO synapse_user;
8911553c1580
892< -- Name: schema_version; Type: TABLE; Schema: public; Owner: synapse
893---
894> -- Name: schema_version; Type: TABLE; Schema: public; Owner: synapse_user
8951564c1591
896< ALTER TABLE public.schema_version OWNER TO synapse;
897---
898> ALTER TABLE public.schema_version OWNER TO synapse_user;
8991567c1594
900< -- Name: server_keys_json; Type: TABLE; Schema: public; Owner: synapse
901---
902> -- Name: server_keys_json; Type: TABLE; Schema: public; Owner: synapse_user
9031580c1607
904< ALTER TABLE public.server_keys_json OWNER TO synapse;
905---
906> ALTER TABLE public.server_keys_json OWNER TO synapse_user;
9071583c1610
908< -- Name: server_signature_keys; Type: TABLE; Schema: public; Owner: synapse
909---
910> -- Name: server_signature_keys; Type: TABLE; Schema: public; Owner: synapse_user
9111595c1622
912< ALTER TABLE public.server_signature_keys OWNER TO synapse;
913---
914> ALTER TABLE public.server_signature_keys OWNER TO synapse_user;
9151598c1625
916< -- Name: server_tls_certificates; Type: TABLE; Schema: public; Owner: synapse
917---
918> -- Name: server_tls_certificates; Type: TABLE; Schema: public; Owner: synapse_user
9191610c1637
920< ALTER TABLE public.server_tls_certificates OWNER TO synapse;
921---
922> ALTER TABLE public.server_tls_certificates OWNER TO synapse_user;
9231613c1640
924< -- Name: state_events; Type: TABLE; Schema: public; Owner: synapse
925---
926> -- Name: state_events; Type: TABLE; Schema: public; Owner: synapse_user
9271625c1652
928< ALTER TABLE public.state_events OWNER TO synapse;
929---
930> ALTER TABLE public.state_events OWNER TO synapse_user;
9311628c1655
932< -- Name: state_forward_extremities; Type: TABLE; Schema: public; Owner: synapse
933---
934> -- Name: state_forward_extremities; Type: TABLE; Schema: public; Owner: synapse_user
9351639c1666
936< ALTER TABLE public.state_forward_extremities OWNER TO synapse;
937---
938> ALTER TABLE public.state_forward_extremities OWNER TO synapse_user;
9391642c1669
940< -- Name: state_group_edges; Type: TABLE; Schema: public; Owner: synapse
941---
942> -- Name: state_group_edges; Type: TABLE; Schema: public; Owner: synapse_user
9431651c1678
944< ALTER TABLE public.state_group_edges OWNER TO synapse;
945---
946> ALTER TABLE public.state_group_edges OWNER TO synapse_user;
9471654c1681
948< -- Name: state_group_id_seq; Type: SEQUENCE; Schema: public; Owner: synapse
949---
950> -- Name: state_group_id_seq; Type: SEQUENCE; Schema: public; Owner: synapse_user
9511665c1692
952< ALTER TABLE public.state_group_id_seq OWNER TO synapse;
953---
954> ALTER TABLE public.state_group_id_seq OWNER TO synapse_user;
9551668c1695
956< -- Name: state_groups; Type: TABLE; Schema: public; Owner: synapse
957---
958> -- Name: state_groups; Type: TABLE; Schema: public; Owner: synapse_user
9591678c1705
960< ALTER TABLE public.state_groups OWNER TO synapse;
961---
962> ALTER TABLE public.state_groups OWNER TO synapse_user;
9631681c1708
964< -- Name: state_groups_state; Type: TABLE; Schema: public; Owner: synapse
965---
966> -- Name: state_groups_state; Type: TABLE; Schema: public; Owner: synapse_user
9671693c1720
968< ALTER TABLE public.state_groups_state OWNER TO synapse;
969---
970> ALTER TABLE public.state_groups_state OWNER TO synapse_user;
9711696c1723
972< -- Name: stats_reporting; Type: TABLE; Schema: public; Owner: synapse
973---
974> -- Name: stats_reporting; Type: TABLE; Schema: public; Owner: synapse_user
9751705c1732
976< ALTER TABLE public.stats_reporting OWNER TO synapse;
977---
978> ALTER TABLE public.stats_reporting OWNER TO synapse_user;
9791708c1735
980< -- Name: stream_ordering_to_exterm; Type: TABLE; Schema: public; Owner: synapse
981---
982> -- Name: stream_ordering_to_exterm; Type: TABLE; Schema: public; Owner: synapse_user
9831718c1745
984< ALTER TABLE public.stream_ordering_to_exterm OWNER TO synapse;
985---
986> ALTER TABLE public.stream_ordering_to_exterm OWNER TO synapse_user;
9871721c1748
988< -- Name: threepid_guest_access_tokens; Type: TABLE; Schema: public; Owner: synapse
989---
990> -- Name: threepid_guest_access_tokens; Type: TABLE; Schema: public; Owner: synapse_user
9911732c1759
992< ALTER TABLE public.threepid_guest_access_tokens OWNER TO synapse;
993---
994> ALTER TABLE public.threepid_guest_access_tokens OWNER TO synapse_user;
9951735c1762
996< -- Name: topics; Type: TABLE; Schema: public; Owner: synapse
997---
998> -- Name: topics; Type: TABLE; Schema: public; Owner: synapse_user
9991745c1772
1000< ALTER TABLE public.topics OWNER TO synapse;
1001---
1002> ALTER TABLE public.topics OWNER TO synapse_user;
10031748c1775
1004< -- Name: transaction_id_to_pdu; Type: TABLE; Schema: public; Owner: synapse
1005---
1006> -- Name: transaction_id_to_pdu; Type: TABLE; Schema: public; Owner: synapse_user
10071759c1786
1008< ALTER TABLE public.transaction_id_to_pdu OWNER TO synapse;
1009---
1010> ALTER TABLE public.transaction_id_to_pdu OWNER TO synapse_user;
10111762c1789
1012< -- Name: user_daily_visits; Type: TABLE; Schema: public; Owner: synapse
1013---
1014> -- Name: user_daily_visits; Type: TABLE; Schema: public; Owner: synapse_user
10151772c1799
1016< ALTER TABLE public.user_daily_visits OWNER TO synapse;
1017---
1018> ALTER TABLE public.user_daily_visits OWNER TO synapse_user;
10191775c1802
1020< -- Name: user_directory; Type: TABLE; Schema: public; Owner: synapse
1021---
1022> -- Name: user_directory; Type: TABLE; Schema: public; Owner: synapse_user
10231786c1813
1024< ALTER TABLE public.user_directory OWNER TO synapse;
1025---
1026> ALTER TABLE public.user_directory OWNER TO synapse_user;
10271789c1816
1028< -- Name: user_directory_search; Type: TABLE; Schema: public; Owner: synapse
1029---
1030> -- Name: user_directory_search; Type: TABLE; Schema: public; Owner: synapse_user
10311798c1825
1032< ALTER TABLE public.user_directory_search OWNER TO synapse;
1033---
1034> ALTER TABLE public.user_directory_search OWNER TO synapse_user;
10351801c1828
1036< -- Name: user_directory_stream_pos; Type: TABLE; Schema: public; Owner: synapse
1037---
1038> -- Name: user_directory_stream_pos; Type: TABLE; Schema: public; Owner: synapse_user
10391811c1838
1040< ALTER TABLE public.user_directory_stream_pos OWNER TO synapse;
1041---
1042> ALTER TABLE public.user_directory_stream_pos OWNER TO synapse_user;
10431814c1841
1044< -- Name: user_filters; Type: TABLE; Schema: public; Owner: synapse
1045---
1046> -- Name: user_filters; Type: TABLE; Schema: public; Owner: synapse_user
10471824c1851
1048< ALTER TABLE public.user_filters OWNER TO synapse;
1049---
1050> ALTER TABLE public.user_filters OWNER TO synapse_user;
10511827c1854
1052< -- Name: user_ips; Type: TABLE; Schema: public; Owner: synapse
1053---
1054> -- Name: user_ips; Type: TABLE; Schema: public; Owner: synapse_user
10551840c1867
1056< ALTER TABLE public.user_ips OWNER TO synapse;
1057---
1058> ALTER TABLE public.user_ips OWNER TO synapse_user;
10591843c1870
1060< -- Name: user_threepids; Type: TABLE; Schema: public; Owner: synapse
1061---
1062> -- Name: user_threepids; Type: TABLE; Schema: public; Owner: synapse_user
10631855c1882
1064< ALTER TABLE public.user_threepids OWNER TO synapse;
1065---
1066> ALTER TABLE public.user_threepids OWNER TO synapse_user;
10671858c1885
1068< -- Name: users; Type: TABLE; Schema: public; Owner: synapse
1069---
1070> -- Name: users; Type: TABLE; Schema: public; Owner: synapse_user
10711875c1902
1072< ALTER TABLE public.users OWNER TO synapse;
1073---
1074> ALTER TABLE public.users OWNER TO synapse_user;
10751878c1905
1076< -- Name: users_in_public_rooms; Type: TABLE; Schema: public; Owner: synapse
1077---
1078> -- Name: users_in_public_rooms; Type: TABLE; Schema: public; Owner: synapse_user
10791887c1914
1080< ALTER TABLE public.users_in_public_rooms OWNER TO synapse;
1081---
1082> ALTER TABLE public.users_in_public_rooms OWNER TO synapse_user;
10831890c1917
1084< -- Name: users_pending_deactivation; Type: TABLE; Schema: public; Owner: synapse
1085---
1086> -- Name: users_pending_deactivation; Type: TABLE; Schema: public; Owner: synapse_user
10871898c1925
1088< ALTER TABLE public.users_pending_deactivation OWNER TO synapse;
1089---
1090> ALTER TABLE public.users_pending_deactivation OWNER TO synapse_user;
10911901c1928
1092< -- Name: users_who_share_private_rooms; Type: TABLE; Schema: public; Owner: synapse
1093---
1094> -- Name: users_who_share_private_rooms; Type: TABLE; Schema: public; Owner: synapse_user
10951911c1938
1096< ALTER TABLE public.users_who_share_private_rooms OWNER TO synapse;
1097---
1098> ALTER TABLE public.users_who_share_private_rooms OWNER TO synapse_user;
10991914c1941
1100< -- Name: access_tokens access_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1101---
1102> -- Name: access_tokens access_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11031922c1949
1104< -- Name: access_tokens access_tokens_token_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1105---
1106> -- Name: access_tokens access_tokens_token_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11071930c1957
1108< -- Name: account_data account_data_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1109---
1110> -- Name: account_data account_data_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11111938c1965
1112< -- Name: application_services application_services_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1113---
1114> -- Name: application_services application_services_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11151946c1973
1116< -- Name: application_services_regex application_services_regex_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1117---
1118> -- Name: application_services_regex application_services_regex_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11191954c1981
1120< -- Name: application_services_state application_services_state_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1121---
1122> -- Name: application_services_state application_services_state_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11231962c1989
1124< -- Name: application_services application_services_token_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1125---
1126> -- Name: application_services application_services_token_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11271970c1997
1128< -- Name: application_services_txns application_services_txns_as_id_txn_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1129---
1130> -- Name: application_services_txns application_services_txns_as_id_txn_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11311978c2005
1132< -- Name: applied_module_schemas applied_module_schemas_module_name_file_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1133---
1134> -- Name: applied_module_schemas applied_module_schemas_module_name_file_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11351986c2013
1136< -- Name: applied_schema_deltas applied_schema_deltas_version_file_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1137---
1138> -- Name: applied_schema_deltas applied_schema_deltas_version_file_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11391994c2021
1140< -- Name: appservice_stream_position appservice_stream_position_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1141---
1142> -- Name: appservice_stream_position appservice_stream_position_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11432002c2029
1144< -- Name: background_updates background_updates_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1145---
1146> -- Name: background_updates background_updates_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11472010c2037
1148< -- Name: current_state_events current_state_events_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1149---
1150> -- Name: current_state_events current_state_events_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11512018c2045
1152< -- Name: current_state_events current_state_events_room_id_type_state_key_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1153---
1154> -- Name: current_state_events current_state_events_room_id_type_state_key_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11552026c2053
1156< -- Name: current_state_resets current_state_resets_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1157---
1158> -- Name: current_state_resets current_state_resets_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11592034c2061
1160< -- Name: destinations destinations_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1161---
1162> -- Name: destinations destinations_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11632042c2069
1164< -- Name: devices device_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1165---
1166> -- Name: devices device_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11672050c2077
1168< -- Name: e2e_device_keys_json e2e_device_keys_json_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1169---
1170> -- Name: e2e_device_keys_json e2e_device_keys_json_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11712058c2085
1172< -- Name: e2e_one_time_keys_json e2e_one_time_keys_json_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1173---
1174> -- Name: e2e_one_time_keys_json e2e_one_time_keys_json_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11752066c2093
1176< -- Name: event_backward_extremities event_backward_extremities_event_id_room_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1177---
1178> -- Name: event_backward_extremities event_backward_extremities_event_id_room_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11792074c2101
1180< -- Name: event_content_hashes event_content_hashes_event_id_algorithm_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1181---
1182> -- Name: event_content_hashes event_content_hashes_event_id_algorithm_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11832082c2109
1184< -- Name: event_destinations event_destinations_event_id_destination_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1185---
1186> -- Name: event_destinations event_destinations_event_id_destination_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11872090c2117
1188< -- Name: event_edge_hashes event_edge_hashes_event_id_prev_event_id_algorithm_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1189---
1190> -- Name: event_edge_hashes event_edge_hashes_event_id_prev_event_id_algorithm_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11912098c2125
1192< -- Name: event_edges event_edges_event_id_prev_event_id_room_id_is_state_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1193---
1194> -- Name: event_edges event_edges_event_id_prev_event_id_room_id_is_state_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11952106c2133
1196< -- Name: event_forward_extremities event_forward_extremities_event_id_room_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1197---
1198> -- Name: event_forward_extremities event_forward_extremities_event_id_room_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
11992114c2141
1200< -- Name: event_push_actions event_id_user_id_profile_tag_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1201---
1202> -- Name: event_push_actions event_id_user_id_profile_tag_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12032122c2149
1204< -- Name: event_json event_json_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1205---
1206> -- Name: event_json event_json_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12072130c2157
1208< -- Name: event_push_summary_stream_ordering event_push_summary_stream_ordering_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1209---
1210> -- Name: event_push_summary_stream_ordering event_push_summary_stream_ordering_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12112138c2165
1212< -- Name: event_reference_hashes event_reference_hashes_event_id_algorithm_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1213---
1214> -- Name: event_reference_hashes event_reference_hashes_event_id_algorithm_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12152146c2173
1216< -- Name: event_reports event_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1217---
1218> -- Name: event_reports event_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12192154c2181
1220< -- Name: event_signatures event_signatures_event_id_signature_name_key_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1221---
1222> -- Name: event_signatures event_signatures_event_id_signature_name_key_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12232162c2189
1224< -- Name: event_to_state_groups event_to_state_groups_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1225---
1226> -- Name: event_to_state_groups event_to_state_groups_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12272170c2197
1228< -- Name: events events_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1229---
1230> -- Name: events events_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12312178c2205
1232< -- Name: events events_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1233---
1234> -- Name: events events_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12352186c2213
1236< -- Name: ex_outlier_stream ex_outlier_stream_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1237---
1238> -- Name: ex_outlier_stream ex_outlier_stream_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12392194c2221
1240< -- Name: feedback feedback_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1241---
1242> -- Name: feedback feedback_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12432202c2229
1244< -- Name: group_roles group_roles_group_id_role_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1245---
1246> -- Name: group_roles group_roles_group_id_role_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12472210c2237
1248< -- Name: group_room_categories group_room_categories_group_id_category_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1249---
1250> -- Name: group_room_categories group_room_categories_group_id_category_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12512218c2245
1252< -- Name: group_summary_roles group_summary_roles_group_id_role_id_role_order_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1253---
1254> -- Name: group_summary_roles group_summary_roles_group_id_role_id_role_order_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12552226c2253
1256< -- Name: group_summary_room_categories group_summary_room_categories_group_id_category_id_cat_orde_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1257---
1258> -- Name: group_summary_room_categories group_summary_room_categories_group_id_category_id_cat_orde_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12592234c2261
1260< -- Name: group_summary_rooms group_summary_rooms_group_id_category_id_room_id_room_order_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1261---
1262> -- Name: group_summary_rooms group_summary_rooms_group_id_category_id_room_id_room_order_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12632242c2269
1264< -- Name: guest_access guest_access_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1265---
1266> -- Name: guest_access guest_access_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12672250c2277
1268< -- Name: history_visibility history_visibility_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1269---
1270> -- Name: history_visibility history_visibility_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12712258c2285
1272< -- Name: local_media_repository local_media_repository_media_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1273---
1274> -- Name: local_media_repository local_media_repository_media_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12752266c2293
1276< -- Name: local_media_repository_thumbnails local_media_repository_thumbn_media_id_thumbnail_width_thum_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1277---
1278> -- Name: local_media_repository_thumbnails local_media_repository_thumbn_media_id_thumbnail_width_thum_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12792274c2301
1280< -- Name: user_threepids medium_address; Type: CONSTRAINT; Schema: public; Owner: synapse
1281---
1282> -- Name: user_threepids medium_address; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12832282c2309
1284< -- Name: open_id_tokens open_id_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1285---
1286> -- Name: open_id_tokens open_id_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12872290c2317,2325
1288< -- Name: presence_allow_inbound presence_allow_inbound_observed_user_id_observer_user_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1289---
1290> -- Name: port_from_sqlite3 port_from_sqlite3_table_name_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
1291> --
1292> 
1293> ALTER TABLE ONLY public.port_from_sqlite3
1294>     ADD CONSTRAINT port_from_sqlite3_table_name_key UNIQUE (table_name);
1295> 
1296> 
1297> --
1298> -- Name: presence_allow_inbound presence_allow_inbound_observed_user_id_observer_user_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
12992298c2333
1300< -- Name: presence_list presence_list_user_id_observed_user_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1301---
1302> -- Name: presence_list presence_list_user_id_observed_user_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13032306c2341
1304< -- Name: presence presence_user_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1305---
1306> -- Name: presence presence_user_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13072314c2349
1308< -- Name: account_data_max_stream_id private_user_data_max_stream_id_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1309---
1310> -- Name: account_data_max_stream_id private_user_data_max_stream_id_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13112322c2357
1312< -- Name: profiles profiles_user_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1313---
1314> -- Name: profiles profiles_user_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13152330c2365
1316< -- Name: push_rules_enable push_rules_enable_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1317---
1318> -- Name: push_rules_enable push_rules_enable_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13192338c2373
1320< -- Name: push_rules_enable push_rules_enable_user_name_rule_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1321---
1322> -- Name: push_rules_enable push_rules_enable_user_name_rule_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13232346c2381
1324< -- Name: push_rules push_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1325---
1326> -- Name: push_rules push_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13272354c2389
1328< -- Name: push_rules push_rules_user_name_rule_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1329---
1330> -- Name: push_rules push_rules_user_name_rule_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13312362c2397
1332< -- Name: pusher_throttle pusher_throttle_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1333---
1334> -- Name: pusher_throttle pusher_throttle_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13352370c2405
1336< -- Name: pushers pushers2_app_id_pushkey_user_name_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1337---
1338> -- Name: pushers pushers2_app_id_pushkey_user_name_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13392378c2413
1340< -- Name: pushers pushers2_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1341---
1342> -- Name: pushers pushers2_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13432386c2421
1344< -- Name: receipts_graph receipts_graph_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1345---
1346> -- Name: receipts_graph receipts_graph_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13472394c2429
1348< -- Name: receipts_linearized receipts_linearized_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1349---
1350> -- Name: receipts_linearized receipts_linearized_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13512402c2437
1352< -- Name: received_transactions received_transactions_transaction_id_origin_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1353---
1354> -- Name: received_transactions received_transactions_transaction_id_origin_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13552410c2445
1356< -- Name: redactions redactions_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1357---
1358> -- Name: redactions redactions_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13592418c2453
1360< -- Name: rejections rejections_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1361---
1362> -- Name: rejections rejections_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13632426c2461
1364< -- Name: remote_media_cache remote_media_cache_media_origin_media_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1365---
1366> -- Name: remote_media_cache remote_media_cache_media_origin_media_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13672434c2469
1368< -- Name: remote_media_cache_thumbnails remote_media_cache_thumbnails_media_origin_media_id_thumbna_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1369---
1370> -- Name: remote_media_cache_thumbnails remote_media_cache_thumbnails_media_origin_media_id_thumbna_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13712442c2477
1372< -- Name: room_account_data room_account_data_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1373---
1374> -- Name: room_account_data room_account_data_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13752450c2485
1376< -- Name: room_aliases room_aliases_room_alias_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1377---
1378> -- Name: room_aliases room_aliases_room_alias_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13792458c2493
1380< -- Name: room_depth room_depth_room_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1381---
1382> -- Name: room_depth room_depth_room_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13832466c2501
1384< -- Name: room_hosts room_hosts_room_id_host_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1385---
1386> -- Name: room_hosts room_hosts_room_id_host_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13872474c2509
1388< -- Name: room_memberships room_memberships_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1389---
1390> -- Name: room_memberships room_memberships_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13912482c2517
1392< -- Name: room_names room_names_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1393---
1394> -- Name: room_names room_names_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13952490c2525
1396< -- Name: room_tags_revisions room_tag_revisions_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1397---
1398> -- Name: room_tags_revisions room_tag_revisions_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
13992498c2533
1400< -- Name: room_tags room_tag_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1401---
1402> -- Name: room_tags room_tag_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14032506c2541
1404< -- Name: rooms rooms_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1405---
1406> -- Name: rooms rooms_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14072514c2549
1408< -- Name: schema_version schema_version_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1409---
1410> -- Name: schema_version schema_version_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14112522c2557
1412< -- Name: server_keys_json server_keys_json_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse
1413---
1414> -- Name: server_keys_json server_keys_json_uniqueness; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14152530c2565
1416< -- Name: server_signature_keys server_signature_keys_server_name_key_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1417---
1418> -- Name: server_signature_keys server_signature_keys_server_name_key_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14192538c2573
1420< -- Name: server_tls_certificates server_tls_certificates_server_name_fingerprint_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1421---
1422> -- Name: server_tls_certificates server_tls_certificates_server_name_fingerprint_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14232546c2581
1424< -- Name: state_events state_events_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1425---
1426> -- Name: state_events state_events_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14272554c2589
1428< -- Name: state_forward_extremities state_forward_extremities_event_id_room_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1429---
1430> -- Name: state_forward_extremities state_forward_extremities_event_id_room_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14312562c2597
1432< -- Name: state_groups state_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse
1433---
1434> -- Name: state_groups state_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14352570c2605
1436< -- Name: topics topics_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1437---
1438> -- Name: topics topics_event_id_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14392578c2613
1440< -- Name: transaction_id_to_pdu transaction_id_to_pdu_transaction_id_destination_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1441---
1442> -- Name: transaction_id_to_pdu transaction_id_to_pdu_transaction_id_destination_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14432586c2621
1444< -- Name: user_directory_stream_pos user_directory_stream_pos_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1445---
1446> -- Name: user_directory_stream_pos user_directory_stream_pos_lock_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14472594c2629
1448< -- Name: users users_name_key; Type: CONSTRAINT; Schema: public; Owner: synapse
1449---
1450> -- Name: users users_name_key; Type: CONSTRAINT; Schema: public; Owner: synapse_user
14512602c2637
1452< -- Name: access_tokens_device_id; Type: INDEX; Schema: public; Owner: synapse
1453---
1454> -- Name: access_tokens_device_id; Type: INDEX; Schema: public; Owner: synapse_user
14552609c2644
1456< -- Name: account_data_stream_id; Type: INDEX; Schema: public; Owner: synapse
1457---
1458> -- Name: account_data_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
14592616c2651
1460< -- Name: application_services_txns_id; Type: INDEX; Schema: public; Owner: synapse
1461---
1462> -- Name: application_services_txns_id; Type: INDEX; Schema: public; Owner: synapse_user
14632623c2658
1464< -- Name: appservice_room_list_idx; Type: INDEX; Schema: public; Owner: synapse
1465---
1466> -- Name: appservice_room_list_idx; Type: INDEX; Schema: public; Owner: synapse_user
14672630c2665
1468< -- Name: blocked_rooms_idx; Type: INDEX; Schema: public; Owner: synapse
1469---
1470> -- Name: blocked_rooms_idx; Type: INDEX; Schema: public; Owner: synapse_user
14712637c2672
1472< -- Name: cache_invalidation_stream_id; Type: INDEX; Schema: public; Owner: synapse
1473---
1474> -- Name: cache_invalidation_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
14752644c2679
1476< -- Name: current_state_delta_stream_idx; Type: INDEX; Schema: public; Owner: synapse
1477---
1478> -- Name: current_state_delta_stream_idx; Type: INDEX; Schema: public; Owner: synapse_user
14792651c2686
1480< -- Name: current_state_events_member_index; Type: INDEX; Schema: public; Owner: synapse
1481---
1482> -- Name: current_state_events_member_index; Type: INDEX; Schema: public; Owner: synapse_user
14832658c2693
1484< -- Name: deleted_pushers_stream_id; Type: INDEX; Schema: public; Owner: synapse
1485---
1486> -- Name: deleted_pushers_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
14872665c2700
1488< -- Name: device_federation_inbox_sender_id; Type: INDEX; Schema: public; Owner: synapse
1489---
1490> -- Name: device_federation_inbox_sender_id; Type: INDEX; Schema: public; Owner: synapse_user
14912672c2707
1492< -- Name: device_federation_outbox_destination_id; Type: INDEX; Schema: public; Owner: synapse
1493---
1494> -- Name: device_federation_outbox_destination_id; Type: INDEX; Schema: public; Owner: synapse_user
14952679c2714
1496< -- Name: device_federation_outbox_id; Type: INDEX; Schema: public; Owner: synapse
1497---
1498> -- Name: device_federation_outbox_id; Type: INDEX; Schema: public; Owner: synapse_user
14992686c2721
1500< -- Name: device_inbox_stream_id_user_id; Type: INDEX; Schema: public; Owner: synapse
1501---
1502> -- Name: device_inbox_stream_id_user_id; Type: INDEX; Schema: public; Owner: synapse_user
15032693c2728
1504< -- Name: device_inbox_user_stream_id; Type: INDEX; Schema: public; Owner: synapse
1505---
1506> -- Name: device_inbox_user_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
15072700c2735
1508< -- Name: device_lists_outbound_last_success_idx; Type: INDEX; Schema: public; Owner: synapse
1509---
1510> -- Name: device_lists_outbound_last_success_idx; Type: INDEX; Schema: public; Owner: synapse_user
15112707c2742
1512< -- Name: device_lists_outbound_pokes_id; Type: INDEX; Schema: public; Owner: synapse
1513---
1514> -- Name: device_lists_outbound_pokes_id; Type: INDEX; Schema: public; Owner: synapse_user
15152714c2749
1516< -- Name: device_lists_outbound_pokes_stream; Type: INDEX; Schema: public; Owner: synapse
1517---
1518> -- Name: device_lists_outbound_pokes_stream; Type: INDEX; Schema: public; Owner: synapse_user
15192721c2756
1520< -- Name: device_lists_outbound_pokes_user; Type: INDEX; Schema: public; Owner: synapse
1521---
1522> -- Name: device_lists_outbound_pokes_user; Type: INDEX; Schema: public; Owner: synapse_user
15232728c2763
1524< -- Name: device_lists_remote_cache_unique_id; Type: INDEX; Schema: public; Owner: synapse
1525---
1526> -- Name: device_lists_remote_cache_unique_id; Type: INDEX; Schema: public; Owner: synapse_user
15272735c2770
1528< -- Name: device_lists_remote_extremeties_unique_idx; Type: INDEX; Schema: public; Owner: synapse
1529---
1530> -- Name: device_lists_remote_extremeties_unique_idx; Type: INDEX; Schema: public; Owner: synapse_user
15312742c2777
1532< -- Name: device_lists_stream_id; Type: INDEX; Schema: public; Owner: synapse
1533---
1534> -- Name: device_lists_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
15352749c2784
1536< -- Name: device_lists_stream_user_id; Type: INDEX; Schema: public; Owner: synapse
1537---
1538> -- Name: device_lists_stream_user_id; Type: INDEX; Schema: public; Owner: synapse_user
15392756c2791
1540< -- Name: e2e_room_keys_idx; Type: INDEX; Schema: public; Owner: synapse
1541---
1542> -- Name: e2e_room_keys_idx; Type: INDEX; Schema: public; Owner: synapse_user
15432763c2798
1544< -- Name: e2e_room_keys_versions_idx; Type: INDEX; Schema: public; Owner: synapse
1545---
1546> -- Name: e2e_room_keys_versions_idx; Type: INDEX; Schema: public; Owner: synapse_user
15472770c2805
1548< -- Name: erased_users_user; Type: INDEX; Schema: public; Owner: synapse
1549---
1550> -- Name: erased_users_user; Type: INDEX; Schema: public; Owner: synapse_user
15512777c2812
1552< -- Name: ev_b_extrem_id; Type: INDEX; Schema: public; Owner: synapse
1553---
1554> -- Name: ev_b_extrem_id; Type: INDEX; Schema: public; Owner: synapse_user
15552784c2819
1556< -- Name: ev_b_extrem_room; Type: INDEX; Schema: public; Owner: synapse
1557---
1558> -- Name: ev_b_extrem_room; Type: INDEX; Schema: public; Owner: synapse_user
15592791c2826
1560< -- Name: ev_edges_id; Type: INDEX; Schema: public; Owner: synapse
1561---
1562> -- Name: ev_edges_id; Type: INDEX; Schema: public; Owner: synapse_user
15632798c2833
1564< -- Name: ev_edges_prev_id; Type: INDEX; Schema: public; Owner: synapse
1565---
1566> -- Name: ev_edges_prev_id; Type: INDEX; Schema: public; Owner: synapse_user
15672805c2840
1568< -- Name: ev_extrem_id; Type: INDEX; Schema: public; Owner: synapse
1569---
1570> -- Name: ev_extrem_id; Type: INDEX; Schema: public; Owner: synapse_user
15712812c2847
1572< -- Name: ev_extrem_room; Type: INDEX; Schema: public; Owner: synapse
1573---
1574> -- Name: ev_extrem_room; Type: INDEX; Schema: public; Owner: synapse_user
15752819c2854
1576< -- Name: evauth_edges_id; Type: INDEX; Schema: public; Owner: synapse
1577---
1578> -- Name: evauth_edges_id; Type: INDEX; Schema: public; Owner: synapse_user
15792826c2861
1580< -- Name: event_contains_url_index; Type: INDEX; Schema: public; Owner: synapse
1581---
1582> -- Name: event_contains_url_index; Type: INDEX; Schema: public; Owner: synapse_user
15832833c2868
1584< -- Name: event_json_room_id; Type: INDEX; Schema: public; Owner: synapse
1585---
1586> -- Name: event_json_room_id; Type: INDEX; Schema: public; Owner: synapse_user
15872840c2875
1588< -- Name: event_push_actions_highlights_index; Type: INDEX; Schema: public; Owner: synapse
1589---
1590> -- Name: event_push_actions_highlights_index; Type: INDEX; Schema: public; Owner: synapse_user
15912847c2882
1592< -- Name: event_push_actions_rm_tokens; Type: INDEX; Schema: public; Owner: synapse
1593---
1594> -- Name: event_push_actions_rm_tokens; Type: INDEX; Schema: public; Owner: synapse_user
15952854c2889
1596< -- Name: event_push_actions_room_id_user_id; Type: INDEX; Schema: public; Owner: synapse
1597---
1598> -- Name: event_push_actions_room_id_user_id; Type: INDEX; Schema: public; Owner: synapse_user
15992861c2896
1600< -- Name: event_push_actions_staging_id; Type: INDEX; Schema: public; Owner: synapse
1601---
1602> -- Name: event_push_actions_staging_id; Type: INDEX; Schema: public; Owner: synapse_user
16032868c2903
1604< -- Name: event_push_actions_stream_ordering; Type: INDEX; Schema: public; Owner: synapse
1605---
1606> -- Name: event_push_actions_stream_ordering; Type: INDEX; Schema: public; Owner: synapse_user
16072875c2910
1608< -- Name: event_push_actions_u_highlight; Type: INDEX; Schema: public; Owner: synapse
1609---
1610> -- Name: event_push_actions_u_highlight; Type: INDEX; Schema: public; Owner: synapse_user
16112882c2917
1612< -- Name: event_push_summary_user_rm; Type: INDEX; Schema: public; Owner: synapse
1613---
1614> -- Name: event_push_summary_user_rm; Type: INDEX; Schema: public; Owner: synapse_user
16152889c2924
1616< -- Name: event_reference_hashes_id; Type: INDEX; Schema: public; Owner: synapse
1617---
1618> -- Name: event_reference_hashes_id; Type: INDEX; Schema: public; Owner: synapse_user
16192896c2931
1620< -- Name: event_search_ev_ridx; Type: INDEX; Schema: public; Owner: synapse
1621---
1622> -- Name: event_search_ev_ridx; Type: INDEX; Schema: public; Owner: synapse_user
16232903c2938
1624< -- Name: event_search_event_id_idx; Type: INDEX; Schema: public; Owner: synapse
1625---
1626> -- Name: event_search_event_id_idx; Type: INDEX; Schema: public; Owner: synapse_user
16272910c2945
1628< -- Name: event_search_fts_idx; Type: INDEX; Schema: public; Owner: synapse
1629---
1630> -- Name: event_search_fts_idx; Type: INDEX; Schema: public; Owner: synapse_user
16312917c2952
1632< -- Name: event_to_state_groups_sg_index; Type: INDEX; Schema: public; Owner: synapse
1633---
1634> -- Name: event_to_state_groups_sg_index; Type: INDEX; Schema: public; Owner: synapse_user
16352924c2959
1636< -- Name: events_order_room; Type: INDEX; Schema: public; Owner: synapse
1637---
1638> -- Name: events_order_room; Type: INDEX; Schema: public; Owner: synapse_user
16392931c2966
1640< -- Name: events_room_stream; Type: INDEX; Schema: public; Owner: synapse
1641---
1642> -- Name: events_room_stream; Type: INDEX; Schema: public; Owner: synapse_user
16432938c2973
1644< -- Name: events_ts; Type: INDEX; Schema: public; Owner: synapse
1645---
1646> -- Name: events_ts; Type: INDEX; Schema: public; Owner: synapse_user
16472945c2980
1648< -- Name: group_attestations_remote_g_idx; Type: INDEX; Schema: public; Owner: synapse
1649---
1650> -- Name: group_attestations_remote_g_idx; Type: INDEX; Schema: public; Owner: synapse_user
16512952c2987
1652< -- Name: group_attestations_remote_u_idx; Type: INDEX; Schema: public; Owner: synapse
1653---
1654> -- Name: group_attestations_remote_u_idx; Type: INDEX; Schema: public; Owner: synapse_user
16552959c2994
1656< -- Name: group_attestations_remote_v_idx; Type: INDEX; Schema: public; Owner: synapse
1657---
1658> -- Name: group_attestations_remote_v_idx; Type: INDEX; Schema: public; Owner: synapse_user
16592966c3001
1660< -- Name: group_attestations_renewals_g_idx; Type: INDEX; Schema: public; Owner: synapse
1661---
1662> -- Name: group_attestations_renewals_g_idx; Type: INDEX; Schema: public; Owner: synapse_user
16632973c3008
1664< -- Name: group_attestations_renewals_u_idx; Type: INDEX; Schema: public; Owner: synapse
1665---
1666> -- Name: group_attestations_renewals_u_idx; Type: INDEX; Schema: public; Owner: synapse_user
16672980c3015
1668< -- Name: group_attestations_renewals_v_idx; Type: INDEX; Schema: public; Owner: synapse
1669---
1670> -- Name: group_attestations_renewals_v_idx; Type: INDEX; Schema: public; Owner: synapse_user
16712987c3022
1672< -- Name: group_invites_g_idx; Type: INDEX; Schema: public; Owner: synapse
1673---
1674> -- Name: group_invites_g_idx; Type: INDEX; Schema: public; Owner: synapse_user
16752994c3029
1676< -- Name: group_invites_u_idx; Type: INDEX; Schema: public; Owner: synapse
1677---
1678> -- Name: group_invites_u_idx; Type: INDEX; Schema: public; Owner: synapse_user
16793001c3036
1680< -- Name: group_rooms_g_idx; Type: INDEX; Schema: public; Owner: synapse
1681---
1682> -- Name: group_rooms_g_idx; Type: INDEX; Schema: public; Owner: synapse_user
16833008c3043
1684< -- Name: group_rooms_r_idx; Type: INDEX; Schema: public; Owner: synapse
1685---
1686> -- Name: group_rooms_r_idx; Type: INDEX; Schema: public; Owner: synapse_user
16873015c3050
1688< -- Name: group_summary_rooms_g_idx; Type: INDEX; Schema: public; Owner: synapse
1689---
1690> -- Name: group_summary_rooms_g_idx; Type: INDEX; Schema: public; Owner: synapse_user
16913022c3057
1692< -- Name: group_summary_users_g_idx; Type: INDEX; Schema: public; Owner: synapse
1693---
1694> -- Name: group_summary_users_g_idx; Type: INDEX; Schema: public; Owner: synapse_user
16953029c3064
1696< -- Name: group_users_g_idx; Type: INDEX; Schema: public; Owner: synapse
1697---
1698> -- Name: group_users_g_idx; Type: INDEX; Schema: public; Owner: synapse_user
16993036c3071
1700< -- Name: group_users_u_idx; Type: INDEX; Schema: public; Owner: synapse
1701---
1702> -- Name: group_users_u_idx; Type: INDEX; Schema: public; Owner: synapse_user
17033043c3078
1704< -- Name: groups_idx; Type: INDEX; Schema: public; Owner: synapse
1705---
1706> -- Name: groups_idx; Type: INDEX; Schema: public; Owner: synapse_user
17073050c3085
1708< -- Name: local_group_membership_g_idx; Type: INDEX; Schema: public; Owner: synapse
1709---
1710> -- Name: local_group_membership_g_idx; Type: INDEX; Schema: public; Owner: synapse_user
17113057c3092
1712< -- Name: local_group_membership_u_idx; Type: INDEX; Schema: public; Owner: synapse
1713---
1714> -- Name: local_group_membership_u_idx; Type: INDEX; Schema: public; Owner: synapse_user
17153064c3099
1716< -- Name: local_invites_for_user_idx; Type: INDEX; Schema: public; Owner: synapse
1717---
1718> -- Name: local_invites_for_user_idx; Type: INDEX; Schema: public; Owner: synapse_user
17193071c3106
1720< -- Name: local_invites_id; Type: INDEX; Schema: public; Owner: synapse
1721---
1722> -- Name: local_invites_id; Type: INDEX; Schema: public; Owner: synapse_user
17233078c3113
1724< -- Name: local_media_repository_thumbnails_media_id; Type: INDEX; Schema: public; Owner: synapse
1725---
1726> -- Name: local_media_repository_thumbnails_media_id; Type: INDEX; Schema: public; Owner: synapse_user
17273085c3120
1728< -- Name: local_media_repository_url_cache_by_url_download_ts; Type: INDEX; Schema: public; Owner: synapse
1729---
1730> -- Name: local_media_repository_url_cache_by_url_download_ts; Type: INDEX; Schema: public; Owner: synapse_user
17313092c3127
1732< -- Name: local_media_repository_url_cache_expires_idx; Type: INDEX; Schema: public; Owner: synapse
1733---
1734> -- Name: local_media_repository_url_cache_expires_idx; Type: INDEX; Schema: public; Owner: synapse_user
17353099c3134
1736< -- Name: local_media_repository_url_cache_media_idx; Type: INDEX; Schema: public; Owner: synapse
1737---
1738> -- Name: local_media_repository_url_cache_media_idx; Type: INDEX; Schema: public; Owner: synapse_user
17393106c3141
1740< -- Name: local_media_repository_url_idx; Type: INDEX; Schema: public; Owner: synapse
1741---
1742> -- Name: local_media_repository_url_idx; Type: INDEX; Schema: public; Owner: synapse_user
17433113c3148
1744< -- Name: monthly_active_users_time_stamp; Type: INDEX; Schema: public; Owner: synapse
1745---
1746> -- Name: monthly_active_users_time_stamp; Type: INDEX; Schema: public; Owner: synapse_user
17473120c3155
1748< -- Name: monthly_active_users_users; Type: INDEX; Schema: public; Owner: synapse
1749---
1750> -- Name: monthly_active_users_users; Type: INDEX; Schema: public; Owner: synapse_user
17513127c3162
1752< -- Name: open_id_tokens_ts_valid_until_ms; Type: INDEX; Schema: public; Owner: synapse
1753---
1754> -- Name: open_id_tokens_ts_valid_until_ms; Type: INDEX; Schema: public; Owner: synapse_user
17553134c3169
1756< -- Name: presence_list_user_id; Type: INDEX; Schema: public; Owner: synapse
1757---
1758> -- Name: presence_list_user_id; Type: INDEX; Schema: public; Owner: synapse_user
17593141c3176
1760< -- Name: presence_stream_id; Type: INDEX; Schema: public; Owner: synapse
1761---
1762> -- Name: presence_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
17633148c3183
1764< -- Name: presence_stream_user_id; Type: INDEX; Schema: public; Owner: synapse
1765---
1766> -- Name: presence_stream_user_id; Type: INDEX; Schema: public; Owner: synapse_user
17673155c3190
1768< -- Name: public_room_index; Type: INDEX; Schema: public; Owner: synapse
1769---
1770> -- Name: public_room_index; Type: INDEX; Schema: public; Owner: synapse_user
17713162c3197
1772< -- Name: public_room_list_stream_idx; Type: INDEX; Schema: public; Owner: synapse
1773---
1774> -- Name: public_room_list_stream_idx; Type: INDEX; Schema: public; Owner: synapse_user
17753169c3204
1776< -- Name: public_room_list_stream_rm_idx; Type: INDEX; Schema: public; Owner: synapse
1777---
1778> -- Name: public_room_list_stream_rm_idx; Type: INDEX; Schema: public; Owner: synapse_user
17793176c3211
1780< -- Name: push_rules_enable_user_name; Type: INDEX; Schema: public; Owner: synapse
1781---
1782> -- Name: push_rules_enable_user_name; Type: INDEX; Schema: public; Owner: synapse_user
17833183c3218
1784< -- Name: push_rules_stream_id; Type: INDEX; Schema: public; Owner: synapse
1785---
1786> -- Name: push_rules_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
17873190c3225
1788< -- Name: push_rules_stream_user_stream_id; Type: INDEX; Schema: public; Owner: synapse
1789---
1790> -- Name: push_rules_stream_user_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
17913197c3232
1792< -- Name: push_rules_user_name; Type: INDEX; Schema: public; Owner: synapse
1793---
1794> -- Name: push_rules_user_name; Type: INDEX; Schema: public; Owner: synapse_user
17953204c3239
1796< -- Name: ratelimit_override_idx; Type: INDEX; Schema: public; Owner: synapse
1797---
1798> -- Name: ratelimit_override_idx; Type: INDEX; Schema: public; Owner: synapse_user
17993211c3246
1800< -- Name: receipts_linearized_id; Type: INDEX; Schema: public; Owner: synapse
1801---
1802> -- Name: receipts_linearized_id; Type: INDEX; Schema: public; Owner: synapse_user
18033218c3253
1804< -- Name: receipts_linearized_room_stream; Type: INDEX; Schema: public; Owner: synapse
1805---
1806> -- Name: receipts_linearized_room_stream; Type: INDEX; Schema: public; Owner: synapse_user
18073225c3260
1808< -- Name: receipts_linearized_user; Type: INDEX; Schema: public; Owner: synapse
1809---
1810> -- Name: receipts_linearized_user; Type: INDEX; Schema: public; Owner: synapse_user
18113232c3267
1812< -- Name: received_transactions_ts; Type: INDEX; Schema: public; Owner: synapse
1813---
1814> -- Name: received_transactions_ts; Type: INDEX; Schema: public; Owner: synapse_user
18153239c3274
1816< -- Name: redactions_redacts; Type: INDEX; Schema: public; Owner: synapse
1817---
1818> -- Name: redactions_redacts; Type: INDEX; Schema: public; Owner: synapse_user
18193246c3281
1820< -- Name: remote_profile_cache_time; Type: INDEX; Schema: public; Owner: synapse
1821---
1822> -- Name: remote_profile_cache_time; Type: INDEX; Schema: public; Owner: synapse_user
18233253c3288
1824< -- Name: remote_profile_cache_user_id; Type: INDEX; Schema: public; Owner: synapse
1825---
1826> -- Name: remote_profile_cache_user_id; Type: INDEX; Schema: public; Owner: synapse_user
18273260c3295
1828< -- Name: room_account_data_stream_id; Type: INDEX; Schema: public; Owner: synapse
1829---
1830> -- Name: room_account_data_stream_id; Type: INDEX; Schema: public; Owner: synapse_user
18313267c3302
1832< -- Name: room_alias_servers_alias; Type: INDEX; Schema: public; Owner: synapse
1833---
1834> -- Name: room_alias_servers_alias; Type: INDEX; Schema: public; Owner: synapse_user
18353274c3309
1836< -- Name: room_aliases_id; Type: INDEX; Schema: public; Owner: synapse
1837---
1838> -- Name: room_aliases_id; Type: INDEX; Schema: public; Owner: synapse_user
18393281c3316
1840< -- Name: room_depth_room; Type: INDEX; Schema: public; Owner: synapse
1841---
1842> -- Name: room_depth_room; Type: INDEX; Schema: public; Owner: synapse_user
18433288c3323
1844< -- Name: room_memberships_room_id; Type: INDEX; Schema: public; Owner: synapse
1845---
1846> -- Name: room_memberships_room_id; Type: INDEX; Schema: public; Owner: synapse_user
18473295c3330
1848< -- Name: room_memberships_user_id; Type: INDEX; Schema: public; Owner: synapse
1849---
1850> -- Name: room_memberships_user_id; Type: INDEX; Schema: public; Owner: synapse_user
18513302c3337
1852< -- Name: room_names_room_id; Type: INDEX; Schema: public; Owner: synapse
1853---
1854> -- Name: room_names_room_id; Type: INDEX; Schema: public; Owner: synapse_user
18553309c3344
1856< -- Name: st_extrem_keys; Type: INDEX; Schema: public; Owner: synapse
1857---
1858> -- Name: st_extrem_keys; Type: INDEX; Schema: public; Owner: synapse_user
18593316c3351
1860< -- Name: state_group_edges_idx; Type: INDEX; Schema: public; Owner: synapse
1861---
1862> -- Name: state_group_edges_idx; Type: INDEX; Schema: public; Owner: synapse_user
18633323c3358
1864< -- Name: state_group_edges_prev_idx; Type: INDEX; Schema: public; Owner: synapse
1865---
1866> -- Name: state_group_edges_prev_idx; Type: INDEX; Schema: public; Owner: synapse_user
18673330c3365
1868< -- Name: state_groups_state_type_idx; Type: INDEX; Schema: public; Owner: synapse
1869---
1870> -- Name: state_groups_state_type_idx; Type: INDEX; Schema: public; Owner: synapse_user
18713337c3372
1872< -- Name: stream_ordering_to_exterm_idx; Type: INDEX; Schema: public; Owner: synapse
1873---
1874> -- Name: stream_ordering_to_exterm_idx; Type: INDEX; Schema: public; Owner: synapse_user
18753344c3379
1876< -- Name: stream_ordering_to_exterm_rm_idx; Type: INDEX; Schema: public; Owner: synapse
1877---
1878> -- Name: stream_ordering_to_exterm_rm_idx; Type: INDEX; Schema: public; Owner: synapse_user
18793351c3386
1880< -- Name: threepid_guest_access_tokens_index; Type: INDEX; Schema: public; Owner: synapse
1881---
1882> -- Name: threepid_guest_access_tokens_index; Type: INDEX; Schema: public; Owner: synapse_user
18833358c3393
1884< -- Name: topics_room_id; Type: INDEX; Schema: public; Owner: synapse
1885---
1886> -- Name: topics_room_id; Type: INDEX; Schema: public; Owner: synapse_user
18873365c3400
1888< -- Name: transaction_id_to_pdu_dest; Type: INDEX; Schema: public; Owner: synapse
1889---
1890> -- Name: transaction_id_to_pdu_dest; Type: INDEX; Schema: public; Owner: synapse_user
18913372c3407
1892< -- Name: user_daily_visits_ts_idx; Type: INDEX; Schema: public; Owner: synapse
1893---
1894> -- Name: user_daily_visits_ts_idx; Type: INDEX; Schema: public; Owner: synapse_user
18953379c3414
1896< -- Name: user_daily_visits_uts_idx; Type: INDEX; Schema: public; Owner: synapse
1897---
1898> -- Name: user_daily_visits_uts_idx; Type: INDEX; Schema: public; Owner: synapse_user
18993386c3421
1900< -- Name: user_directory_room_idx; Type: INDEX; Schema: public; Owner: synapse
1901---
1902> -- Name: user_directory_room_idx; Type: INDEX; Schema: public; Owner: synapse_user
19033393c3428
1904< -- Name: user_directory_search_fts_idx; Type: INDEX; Schema: public; Owner: synapse
1905---
1906> -- Name: user_directory_search_fts_idx; Type: INDEX; Schema: public; Owner: synapse_user
19073400c3435
1908< -- Name: user_directory_search_user_idx; Type: INDEX; Schema: public; Owner: synapse
1909---
1910> -- Name: user_directory_search_user_idx; Type: INDEX; Schema: public; Owner: synapse_user
19113407c3442
1912< -- Name: user_directory_user_idx; Type: INDEX; Schema: public; Owner: synapse
1913---
1914> -- Name: user_directory_user_idx; Type: INDEX; Schema: public; Owner: synapse_user
19153414c3449
1916< -- Name: user_filters_by_user_id_filter_id; Type: INDEX; Schema: public; Owner: synapse
1917---
1918> -- Name: user_filters_by_user_id_filter_id; Type: INDEX; Schema: public; Owner: synapse_user
19193421c3456
1920< -- Name: user_ips_device_id; Type: INDEX; Schema: public; Owner: synapse
1921---
1922> -- Name: user_ips_device_id; Type: INDEX; Schema: public; Owner: synapse_user
19233428c3463
1924< -- Name: user_ips_last_seen; Type: INDEX; Schema: public; Owner: synapse
1925---
1926> -- Name: user_ips_last_seen; Type: INDEX; Schema: public; Owner: synapse_user
19273435c3470
1928< -- Name: user_ips_last_seen_only; Type: INDEX; Schema: public; Owner: synapse
1929---
1930> -- Name: user_ips_last_seen_only; Type: INDEX; Schema: public; Owner: synapse_user
19313442c3477
1932< -- Name: user_ips_user_token_ip_unique_index; Type: INDEX; Schema: public; Owner: synapse
1933---
1934> -- Name: user_ips_user_token_ip_unique_index; Type: INDEX; Schema: public; Owner: synapse_user
19353449c3484
1936< -- Name: user_threepids_medium_address; Type: INDEX; Schema: public; Owner: synapse
1937---
1938> -- Name: user_threepids_medium_address; Type: INDEX; Schema: public; Owner: synapse_user
19393456c3491
1940< -- Name: user_threepids_user_id; Type: INDEX; Schema: public; Owner: synapse
1941---
1942> -- Name: user_threepids_user_id; Type: INDEX; Schema: public; Owner: synapse_user
19433463c3498
1944< -- Name: users_creation_ts; Type: INDEX; Schema: public; Owner: synapse
1945---
1946> -- Name: users_creation_ts; Type: INDEX; Schema: public; Owner: synapse_user
19473470c3505
1948< -- Name: users_in_public_rooms_u_idx; Type: INDEX; Schema: public; Owner: synapse
1949---
1950> -- Name: users_in_public_rooms_u_idx; Type: INDEX; Schema: public; Owner: synapse_user
19513477c3512
1952< -- Name: users_who_share_private_rooms_o_idx; Type: INDEX; Schema: public; Owner: synapse
1953---
1954> -- Name: users_who_share_private_rooms_o_idx; Type: INDEX; Schema: public; Owner: synapse_user
19553484c3519
1956< -- Name: users_who_share_private_rooms_r_idx; Type: INDEX; Schema: public; Owner: synapse
1957---
1958> -- Name: users_who_share_private_rooms_r_idx; Type: INDEX; Schema: public; Owner: synapse_user
19593491c3526
1960< -- Name: users_who_share_private_rooms_u_idx; Type: INDEX; Schema: public; Owner: synapse
1961---
1962> -- Name: users_who_share_private_rooms_u_idx; Type: INDEX; Schema: public; Owner: synapse_user
19633498c3533
1964< -- Name: application_services_regex application_services_regex_as_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: synapse
1965---
1966> -- Name: application_services_regex application_services_regex_as_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: synapse_user
19673508d3542
1968<