1MDZx7dn

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.15
6-- Dumped by pg_dump version 9.6.15
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET xmloption = content;
16SET client_min_messages = warning;
17SET row_security = off;
18
19--
20-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
21--
22
23CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
24
25
26--
27-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
28--
29
30COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
31
32
33--
34-- Name: timestamp_id(text); Type: FUNCTION; Schema: public; Owner: mastodon
35--
36
37CREATE FUNCTION public.timestamp_id(table_name text) RETURNS bigint
38    LANGUAGE plpgsql
39    AS $$
40  DECLARE
41    time_part bigint;
42    sequence_base bigint;
43    tail bigint;
44  BEGIN
45    time_part := (
46      -- Get the time in milliseconds
47      ((date_part('epoch', now()) * 1000))::bigint
48      -- And shift it over two bytes
49      << 16);
50
51    sequence_base := (
52      'x' ||
53      -- Take the first two bytes (four hex characters)
54      substr(
55        -- Of the MD5 hash of the data we documented
56        md5(table_name ||
57          'c98d89c298de2cf5e8c2954071a460e5' ||
58          time_part::text
59        ),
60        1, 4
61      )
62    -- And turn it into a bigint
63    )::bit(16)::bigint;
64
65    -- Finally, add our sequence number to our base, and chop
66    -- it to the last two bytes
67    tail := (
68      (sequence_base + nextval(table_name || '_id_seq'))
69      & 65535);
70
71    -- Return the time part and the sequence part. OR appears
72    -- faster here than addition, but they're equivalent:
73    -- time_part has no trailing two bytes, and tail is only
74    -- the last two bytes.
75    RETURN time_part | tail;
76  END
77$$;
78
79
80ALTER FUNCTION public.timestamp_id(table_name text) OWNER TO mastodon;
81
82SET default_tablespace = '';
83
84SET default_with_oids = false;
85
86--
87-- Name: account_aliases; Type: TABLE; Schema: public; Owner: mastodon
88--
89
90CREATE TABLE public.account_aliases (
91    id bigint NOT NULL,
92    account_id bigint,
93    acct character varying DEFAULT ''::character varying NOT NULL,
94    uri character varying DEFAULT ''::character varying NOT NULL,
95    created_at timestamp without time zone NOT NULL,
96    updated_at timestamp without time zone NOT NULL
97);
98
99
100ALTER TABLE public.account_aliases OWNER TO mastodon;
101
102--
103-- Name: account_aliases_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
104--
105
106CREATE SEQUENCE public.account_aliases_id_seq
107    START WITH 1
108    INCREMENT BY 1
109    NO MINVALUE
110    NO MAXVALUE
111    CACHE 1;
112
113
114ALTER TABLE public.account_aliases_id_seq OWNER TO mastodon;
115
116--
117-- Name: account_aliases_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
118--
119
120ALTER SEQUENCE public.account_aliases_id_seq OWNED BY public.account_aliases.id;
121
122
123--
124-- Name: account_conversations; Type: TABLE; Schema: public; Owner: mastodon
125--
126
127CREATE TABLE public.account_conversations (
128    id bigint NOT NULL,
129    account_id bigint,
130    conversation_id bigint,
131    participant_account_ids bigint[] DEFAULT '{}'::bigint[] NOT NULL,
132    status_ids bigint[] DEFAULT '{}'::bigint[] NOT NULL,
133    last_status_id bigint,
134    lock_version integer DEFAULT 0 NOT NULL,
135    unread boolean DEFAULT false NOT NULL
136);
137
138
139ALTER TABLE public.account_conversations OWNER TO mastodon;
140
141--
142-- Name: account_conversations_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
143--
144
145CREATE SEQUENCE public.account_conversations_id_seq
146    START WITH 1
147    INCREMENT BY 1
148    NO MINVALUE
149    NO MAXVALUE
150    CACHE 1;
151
152
153ALTER TABLE public.account_conversations_id_seq OWNER TO mastodon;
154
155--
156-- Name: account_conversations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
157--
158
159ALTER SEQUENCE public.account_conversations_id_seq OWNED BY public.account_conversations.id;
160
161
162--
163-- Name: account_domain_blocks; Type: TABLE; Schema: public; Owner: mastodon
164--
165
166CREATE TABLE public.account_domain_blocks (
167    id bigint NOT NULL,
168    domain character varying,
169    created_at timestamp without time zone NOT NULL,
170    updated_at timestamp without time zone NOT NULL,
171    account_id bigint
172);
173
174
175ALTER TABLE public.account_domain_blocks OWNER TO mastodon;
176
177--
178-- Name: account_domain_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
179--
180
181CREATE SEQUENCE public.account_domain_blocks_id_seq
182    START WITH 1
183    INCREMENT BY 1
184    NO MINVALUE
185    NO MAXVALUE
186    CACHE 1;
187
188
189ALTER TABLE public.account_domain_blocks_id_seq OWNER TO mastodon;
190
191--
192-- Name: account_domain_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
193--
194
195ALTER SEQUENCE public.account_domain_blocks_id_seq OWNED BY public.account_domain_blocks.id;
196
197
198--
199-- Name: account_identity_proofs; Type: TABLE; Schema: public; Owner: mastodon
200--
201
202CREATE TABLE public.account_identity_proofs (
203    id bigint NOT NULL,
204    account_id bigint,
205    provider character varying DEFAULT ''::character varying NOT NULL,
206    provider_username character varying DEFAULT ''::character varying NOT NULL,
207    token text DEFAULT ''::text NOT NULL,
208    verified boolean DEFAULT false NOT NULL,
209    live boolean DEFAULT false NOT NULL,
210    created_at timestamp without time zone NOT NULL,
211    updated_at timestamp without time zone NOT NULL
212);
213
214
215ALTER TABLE public.account_identity_proofs OWNER TO mastodon;
216
217--
218-- Name: account_identity_proofs_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
219--
220
221CREATE SEQUENCE public.account_identity_proofs_id_seq
222    START WITH 1
223    INCREMENT BY 1
224    NO MINVALUE
225    NO MAXVALUE
226    CACHE 1;
227
228
229ALTER TABLE public.account_identity_proofs_id_seq OWNER TO mastodon;
230
231--
232-- Name: account_identity_proofs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
233--
234
235ALTER SEQUENCE public.account_identity_proofs_id_seq OWNED BY public.account_identity_proofs.id;
236
237
238--
239-- Name: account_migrations; Type: TABLE; Schema: public; Owner: mastodon
240--
241
242CREATE TABLE public.account_migrations (
243    id bigint NOT NULL,
244    account_id bigint,
245    acct character varying DEFAULT ''::character varying NOT NULL,
246    followers_count bigint DEFAULT 0 NOT NULL,
247    target_account_id bigint,
248    created_at timestamp without time zone NOT NULL,
249    updated_at timestamp without time zone NOT NULL
250);
251
252
253ALTER TABLE public.account_migrations OWNER TO mastodon;
254
255--
256-- Name: account_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
257--
258
259CREATE SEQUENCE public.account_migrations_id_seq
260    START WITH 1
261    INCREMENT BY 1
262    NO MINVALUE
263    NO MAXVALUE
264    CACHE 1;
265
266
267ALTER TABLE public.account_migrations_id_seq OWNER TO mastodon;
268
269--
270-- Name: account_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
271--
272
273ALTER SEQUENCE public.account_migrations_id_seq OWNED BY public.account_migrations.id;
274
275
276--
277-- Name: account_moderation_notes; Type: TABLE; Schema: public; Owner: mastodon
278--
279
280CREATE TABLE public.account_moderation_notes (
281    id bigint NOT NULL,
282    content text NOT NULL,
283    account_id bigint NOT NULL,
284    target_account_id bigint NOT NULL,
285    created_at timestamp without time zone NOT NULL,
286    updated_at timestamp without time zone NOT NULL
287);
288
289
290ALTER TABLE public.account_moderation_notes OWNER TO mastodon;
291
292--
293-- Name: account_moderation_notes_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
294--
295
296CREATE SEQUENCE public.account_moderation_notes_id_seq
297    START WITH 1
298    INCREMENT BY 1
299    NO MINVALUE
300    NO MAXVALUE
301    CACHE 1;
302
303
304ALTER TABLE public.account_moderation_notes_id_seq OWNER TO mastodon;
305
306--
307-- Name: account_moderation_notes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
308--
309
310ALTER SEQUENCE public.account_moderation_notes_id_seq OWNED BY public.account_moderation_notes.id;
311
312
313--
314-- Name: account_pins; Type: TABLE; Schema: public; Owner: mastodon
315--
316
317CREATE TABLE public.account_pins (
318    id bigint NOT NULL,
319    account_id bigint,
320    target_account_id bigint,
321    created_at timestamp without time zone NOT NULL,
322    updated_at timestamp without time zone NOT NULL
323);
324
325
326ALTER TABLE public.account_pins OWNER TO mastodon;
327
328--
329-- Name: account_pins_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
330--
331
332CREATE SEQUENCE public.account_pins_id_seq
333    START WITH 1
334    INCREMENT BY 1
335    NO MINVALUE
336    NO MAXVALUE
337    CACHE 1;
338
339
340ALTER TABLE public.account_pins_id_seq OWNER TO mastodon;
341
342--
343-- Name: account_pins_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
344--
345
346ALTER SEQUENCE public.account_pins_id_seq OWNED BY public.account_pins.id;
347
348
349--
350-- Name: account_stats; Type: TABLE; Schema: public; Owner: mastodon
351--
352
353CREATE TABLE public.account_stats (
354    id bigint NOT NULL,
355    account_id bigint NOT NULL,
356    statuses_count bigint DEFAULT 0 NOT NULL,
357    following_count bigint DEFAULT 0 NOT NULL,
358    followers_count bigint DEFAULT 0 NOT NULL,
359    created_at timestamp without time zone NOT NULL,
360    updated_at timestamp without time zone NOT NULL,
361    last_status_at timestamp without time zone,
362    lock_version integer DEFAULT 0 NOT NULL
363);
364
365
366ALTER TABLE public.account_stats OWNER TO mastodon;
367
368--
369-- Name: account_stats_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
370--
371
372CREATE SEQUENCE public.account_stats_id_seq
373    START WITH 1
374    INCREMENT BY 1
375    NO MINVALUE
376    NO MAXVALUE
377    CACHE 1;
378
379
380ALTER TABLE public.account_stats_id_seq OWNER TO mastodon;
381
382--
383-- Name: account_stats_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
384--
385
386ALTER SEQUENCE public.account_stats_id_seq OWNED BY public.account_stats.id;
387
388
389--
390-- Name: account_tag_stats; Type: TABLE; Schema: public; Owner: mastodon
391--
392
393CREATE TABLE public.account_tag_stats (
394    id bigint NOT NULL,
395    tag_id bigint NOT NULL,
396    accounts_count bigint DEFAULT 0 NOT NULL,
397    hidden boolean DEFAULT false NOT NULL,
398    created_at timestamp without time zone NOT NULL,
399    updated_at timestamp without time zone NOT NULL
400);
401
402
403ALTER TABLE public.account_tag_stats OWNER TO mastodon;
404
405--
406-- Name: account_tag_stats_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
407--
408
409CREATE SEQUENCE public.account_tag_stats_id_seq
410    START WITH 1
411    INCREMENT BY 1
412    NO MINVALUE
413    NO MAXVALUE
414    CACHE 1;
415
416
417ALTER TABLE public.account_tag_stats_id_seq OWNER TO mastodon;
418
419--
420-- Name: account_tag_stats_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
421--
422
423ALTER SEQUENCE public.account_tag_stats_id_seq OWNED BY public.account_tag_stats.id;
424
425
426--
427-- Name: account_warning_presets; Type: TABLE; Schema: public; Owner: mastodon
428--
429
430CREATE TABLE public.account_warning_presets (
431    id bigint NOT NULL,
432    text text DEFAULT ''::text NOT NULL,
433    created_at timestamp without time zone NOT NULL,
434    updated_at timestamp without time zone NOT NULL
435);
436
437
438ALTER TABLE public.account_warning_presets OWNER TO mastodon;
439
440--
441-- Name: account_warning_presets_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
442--
443
444CREATE SEQUENCE public.account_warning_presets_id_seq
445    START WITH 1
446    INCREMENT BY 1
447    NO MINVALUE
448    NO MAXVALUE
449    CACHE 1;
450
451
452ALTER TABLE public.account_warning_presets_id_seq OWNER TO mastodon;
453
454--
455-- Name: account_warning_presets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
456--
457
458ALTER SEQUENCE public.account_warning_presets_id_seq OWNED BY public.account_warning_presets.id;
459
460
461--
462-- Name: account_warnings; Type: TABLE; Schema: public; Owner: mastodon
463--
464
465CREATE TABLE public.account_warnings (
466    id bigint NOT NULL,
467    account_id bigint,
468    target_account_id bigint,
469    action integer DEFAULT 0 NOT NULL,
470    text text DEFAULT ''::text NOT NULL,
471    created_at timestamp without time zone NOT NULL,
472    updated_at timestamp without time zone NOT NULL
473);
474
475
476ALTER TABLE public.account_warnings OWNER TO mastodon;
477
478--
479-- Name: account_warnings_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
480--
481
482CREATE SEQUENCE public.account_warnings_id_seq
483    START WITH 1
484    INCREMENT BY 1
485    NO MINVALUE
486    NO MAXVALUE
487    CACHE 1;
488
489
490ALTER TABLE public.account_warnings_id_seq OWNER TO mastodon;
491
492--
493-- Name: account_warnings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
494--
495
496ALTER SEQUENCE public.account_warnings_id_seq OWNED BY public.account_warnings.id;
497
498
499--
500-- Name: accounts; Type: TABLE; Schema: public; Owner: mastodon
501--
502
503CREATE TABLE public.accounts (
504    id bigint NOT NULL,
505    username character varying DEFAULT ''::character varying NOT NULL,
506    domain character varying,
507    secret character varying DEFAULT ''::character varying NOT NULL,
508    private_key text,
509    public_key text DEFAULT ''::text NOT NULL,
510    remote_url character varying DEFAULT ''::character varying NOT NULL,
511    salmon_url character varying DEFAULT ''::character varying NOT NULL,
512    hub_url character varying DEFAULT ''::character varying NOT NULL,
513    created_at timestamp without time zone NOT NULL,
514    updated_at timestamp without time zone NOT NULL,
515    note text DEFAULT ''::text NOT NULL,
516    display_name character varying DEFAULT ''::character varying NOT NULL,
517    uri character varying DEFAULT ''::character varying NOT NULL,
518    url character varying,
519    avatar_file_name character varying,
520    avatar_content_type character varying,
521    avatar_file_size integer,
522    avatar_updated_at timestamp without time zone,
523    header_file_name character varying,
524    header_content_type character varying,
525    header_file_size integer,
526    header_updated_at timestamp without time zone,
527    avatar_remote_url character varying,
528    subscription_expires_at timestamp without time zone,
529    locked boolean DEFAULT false NOT NULL,
530    header_remote_url character varying DEFAULT ''::character varying NOT NULL,
531    last_webfingered_at timestamp without time zone,
532    inbox_url character varying DEFAULT ''::character varying NOT NULL,
533    outbox_url character varying DEFAULT ''::character varying NOT NULL,
534    shared_inbox_url character varying DEFAULT ''::character varying NOT NULL,
535    followers_url character varying DEFAULT ''::character varying NOT NULL,
536    protocol integer DEFAULT 0 NOT NULL,
537    memorial boolean DEFAULT false NOT NULL,
538    moved_to_account_id bigint,
539    featured_collection_url character varying,
540    fields jsonb,
541    actor_type character varying,
542    discoverable boolean,
543    also_known_as character varying[],
544    silenced_at timestamp without time zone,
545    suspended_at timestamp without time zone,
546    trust_level integer
547);
548
549
550ALTER TABLE public.accounts OWNER TO mastodon;
551
552--
553-- Name: accounts_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
554--
555
556CREATE SEQUENCE public.accounts_id_seq
557    START WITH 1
558    INCREMENT BY 1
559    NO MINVALUE
560    NO MAXVALUE
561    CACHE 1;
562
563
564ALTER TABLE public.accounts_id_seq OWNER TO mastodon;
565
566--
567-- Name: accounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
568--
569
570ALTER SEQUENCE public.accounts_id_seq OWNED BY public.accounts.id;
571
572
573--
574-- Name: accounts_tags; Type: TABLE; Schema: public; Owner: mastodon
575--
576
577CREATE TABLE public.accounts_tags (
578    account_id bigint NOT NULL,
579    tag_id bigint NOT NULL
580);
581
582
583ALTER TABLE public.accounts_tags OWNER TO mastodon;
584
585--
586-- Name: admin_action_logs; Type: TABLE; Schema: public; Owner: mastodon
587--
588
589CREATE TABLE public.admin_action_logs (
590    id bigint NOT NULL,
591    account_id bigint,
592    action character varying DEFAULT ''::character varying NOT NULL,
593    target_type character varying,
594    target_id bigint,
595    recorded_changes text DEFAULT ''::text NOT NULL,
596    created_at timestamp without time zone NOT NULL,
597    updated_at timestamp without time zone NOT NULL
598);
599
600
601ALTER TABLE public.admin_action_logs OWNER TO mastodon;
602
603--
604-- Name: admin_action_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
605--
606
607CREATE SEQUENCE public.admin_action_logs_id_seq
608    START WITH 1
609    INCREMENT BY 1
610    NO MINVALUE
611    NO MAXVALUE
612    CACHE 1;
613
614
615ALTER TABLE public.admin_action_logs_id_seq OWNER TO mastodon;
616
617--
618-- Name: admin_action_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
619--
620
621ALTER SEQUENCE public.admin_action_logs_id_seq OWNED BY public.admin_action_logs.id;
622
623
624--
625-- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: mastodon
626--
627
628CREATE TABLE public.ar_internal_metadata (
629    key character varying NOT NULL,
630    value character varying,
631    created_at timestamp without time zone NOT NULL,
632    updated_at timestamp without time zone NOT NULL
633);
634
635
636ALTER TABLE public.ar_internal_metadata OWNER TO mastodon;
637
638--
639-- Name: backups; Type: TABLE; Schema: public; Owner: mastodon
640--
641
642CREATE TABLE public.backups (
643    id bigint NOT NULL,
644    user_id bigint,
645    dump_file_name character varying,
646    dump_content_type character varying,
647    dump_file_size integer,
648    dump_updated_at timestamp without time zone,
649    processed boolean DEFAULT false NOT NULL,
650    created_at timestamp without time zone NOT NULL,
651    updated_at timestamp without time zone NOT NULL
652);
653
654
655ALTER TABLE public.backups OWNER TO mastodon;
656
657--
658-- Name: backups_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
659--
660
661CREATE SEQUENCE public.backups_id_seq
662    START WITH 1
663    INCREMENT BY 1
664    NO MINVALUE
665    NO MAXVALUE
666    CACHE 1;
667
668
669ALTER TABLE public.backups_id_seq OWNER TO mastodon;
670
671--
672-- Name: backups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
673--
674
675ALTER SEQUENCE public.backups_id_seq OWNED BY public.backups.id;
676
677
678--
679-- Name: blocks; Type: TABLE; Schema: public; Owner: mastodon
680--
681
682CREATE TABLE public.blocks (
683    id bigint NOT NULL,
684    created_at timestamp without time zone NOT NULL,
685    updated_at timestamp without time zone NOT NULL,
686    account_id bigint NOT NULL,
687    target_account_id bigint NOT NULL,
688    uri character varying
689);
690
691
692ALTER TABLE public.blocks OWNER TO mastodon;
693
694--
695-- Name: blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
696--
697
698CREATE SEQUENCE public.blocks_id_seq
699    START WITH 1
700    INCREMENT BY 1
701    NO MINVALUE
702    NO MAXVALUE
703    CACHE 1;
704
705
706ALTER TABLE public.blocks_id_seq OWNER TO mastodon;
707
708--
709-- Name: blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
710--
711
712ALTER SEQUENCE public.blocks_id_seq OWNED BY public.blocks.id;
713
714
715--
716-- Name: conversation_mutes; Type: TABLE; Schema: public; Owner: mastodon
717--
718
719CREATE TABLE public.conversation_mutes (
720    id bigint NOT NULL,
721    conversation_id bigint NOT NULL,
722    account_id bigint NOT NULL
723);
724
725
726ALTER TABLE public.conversation_mutes OWNER TO mastodon;
727
728--
729-- Name: conversation_mutes_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
730--
731
732CREATE SEQUENCE public.conversation_mutes_id_seq
733    START WITH 1
734    INCREMENT BY 1
735    NO MINVALUE
736    NO MAXVALUE
737    CACHE 1;
738
739
740ALTER TABLE public.conversation_mutes_id_seq OWNER TO mastodon;
741
742--
743-- Name: conversation_mutes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
744--
745
746ALTER SEQUENCE public.conversation_mutes_id_seq OWNED BY public.conversation_mutes.id;
747
748
749--
750-- Name: conversations; Type: TABLE; Schema: public; Owner: mastodon
751--
752
753CREATE TABLE public.conversations (
754    id bigint NOT NULL,
755    uri character varying,
756    created_at timestamp without time zone NOT NULL,
757    updated_at timestamp without time zone NOT NULL
758);
759
760
761ALTER TABLE public.conversations OWNER TO mastodon;
762
763--
764-- Name: conversations_id_seq; Type: SEQUENCE; Schema: public; Owner: mastodon
765--
766
767CREATE SEQUENCE public.conversations_id_seq
768    START WITH 1
769    INCREMENT BY 1
770    NO MINVALUE
771    NO MAXVALUE
772    CACHE 1;
773
774
775ALTER TABLE public.conversations_id_seq OWNER TO mastodon;
776
777--
778-- Name: conversations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mastodon
779--
780
781ALTER SEQUENCE public.conversations_id_seq OWNED BY public.conversations.id;
782
783
784--
785-- Name: custom_emoji_categories; Type: TABLE; Schema: public; Owner: mastodon
786--
787
788CREATE TABLE public.custom_emoji_categories (
789    id bigint NOT NULL,
790    name character varying,
791    created_at timestamp without time zone NOT NULL,
792    updated_at timestamp without time zone NOT NULL
793);