cRTgc1qS

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.13
6-- Dumped by pg_dump version 9.6.13
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: citext; Type: EXTENSION; Schema: -; Owner: 
35--
36
37CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
38
39
40--
41-- Name: EXTENSION citext; Type: COMMENT; Schema: -; Owner: 
42--
43
44COMMENT ON EXTENSION citext IS 'data type for case-insensitive character strings';
45
46
47--
48-- Name: unaccent; Type: EXTENSION; Schema: -; Owner: 
49--
50
51CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;
52
53
54--
55-- Name: EXTENSION unaccent; Type: COMMENT; Schema: -; Owner: 
56--
57
58COMMENT ON EXTENSION unaccent IS 'text search dictionary that removes accents';
59
60
61SET default_tablespace = '';
62
63SET default_with_oids = false;
64
65--
66-- Name: account_emailaddress; Type: TABLE; Schema: public; Owner: funkwhale
67--
68
69CREATE TABLE public.account_emailaddress (
70    id integer NOT NULL,
71    email character varying(254) NOT NULL,
72    verified boolean NOT NULL,
73    "primary" boolean NOT NULL,
74    user_id integer NOT NULL
75);
76
77
78ALTER TABLE public.account_emailaddress OWNER TO funkwhale;
79
80--
81-- Name: account_emailaddress_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
82--
83
84CREATE SEQUENCE public.account_emailaddress_id_seq
85    START WITH 1
86    INCREMENT BY 1
87    NO MINVALUE
88    NO MAXVALUE
89    CACHE 1;
90
91
92ALTER TABLE public.account_emailaddress_id_seq OWNER TO funkwhale;
93
94--
95-- Name: account_emailaddress_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
96--
97
98ALTER SEQUENCE public.account_emailaddress_id_seq OWNED BY public.account_emailaddress.id;
99
100
101--
102-- Name: account_emailconfirmation; Type: TABLE; Schema: public; Owner: funkwhale
103--
104
105CREATE TABLE public.account_emailconfirmation (
106    id integer NOT NULL,
107    created timestamp with time zone NOT NULL,
108    sent timestamp with time zone,
109    key character varying(64) NOT NULL,
110    email_address_id integer NOT NULL
111);
112
113
114ALTER TABLE public.account_emailconfirmation OWNER TO funkwhale;
115
116--
117-- Name: account_emailconfirmation_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
118--
119
120CREATE SEQUENCE public.account_emailconfirmation_id_seq
121    START WITH 1
122    INCREMENT BY 1
123    NO MINVALUE
124    NO MAXVALUE
125    CACHE 1;
126
127
128ALTER TABLE public.account_emailconfirmation_id_seq OWNER TO funkwhale;
129
130--
131-- Name: account_emailconfirmation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
132--
133
134ALTER SEQUENCE public.account_emailconfirmation_id_seq OWNED BY public.account_emailconfirmation.id;
135
136
137--
138-- Name: auth_group; Type: TABLE; Schema: public; Owner: funkwhale
139--
140
141CREATE TABLE public.auth_group (
142    id integer NOT NULL,
143    name character varying(150) NOT NULL
144);
145
146
147ALTER TABLE public.auth_group OWNER TO funkwhale;
148
149--
150-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
151--
152
153CREATE SEQUENCE public.auth_group_id_seq
154    START WITH 1
155    INCREMENT BY 1
156    NO MINVALUE
157    NO MAXVALUE
158    CACHE 1;
159
160
161ALTER TABLE public.auth_group_id_seq OWNER TO funkwhale;
162
163--
164-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
165--
166
167ALTER SEQUENCE public.auth_group_id_seq OWNED BY public.auth_group.id;
168
169
170--
171-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: funkwhale
172--
173
174CREATE TABLE public.auth_group_permissions (
175    id integer NOT NULL,
176    group_id integer NOT NULL,
177    permission_id integer NOT NULL
178);
179
180
181ALTER TABLE public.auth_group_permissions OWNER TO funkwhale;
182
183--
184-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
185--
186
187CREATE SEQUENCE public.auth_group_permissions_id_seq
188    START WITH 1
189    INCREMENT BY 1
190    NO MINVALUE
191    NO MAXVALUE
192    CACHE 1;
193
194
195ALTER TABLE public.auth_group_permissions_id_seq OWNER TO funkwhale;
196
197--
198-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
199--
200
201ALTER SEQUENCE public.auth_group_permissions_id_seq OWNED BY public.auth_group_permissions.id;
202
203
204--
205-- Name: auth_permission; Type: TABLE; Schema: public; Owner: funkwhale
206--
207
208CREATE TABLE public.auth_permission (
209    id integer NOT NULL,
210    name character varying(255) NOT NULL,
211    content_type_id integer NOT NULL,
212    codename character varying(100) NOT NULL
213);
214
215
216ALTER TABLE public.auth_permission OWNER TO funkwhale;
217
218--
219-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
220--
221
222CREATE SEQUENCE public.auth_permission_id_seq
223    START WITH 1
224    INCREMENT BY 1
225    NO MINVALUE
226    NO MAXVALUE
227    CACHE 1;
228
229
230ALTER TABLE public.auth_permission_id_seq OWNER TO funkwhale;
231
232--
233-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
234--
235
236ALTER SEQUENCE public.auth_permission_id_seq OWNED BY public.auth_permission.id;
237
238
239--
240-- Name: authtoken_token; Type: TABLE; Schema: public; Owner: funkwhale
241--
242
243CREATE TABLE public.authtoken_token (
244    key character varying(40) NOT NULL,
245    created timestamp with time zone NOT NULL,
246    user_id integer NOT NULL
247);
248
249
250ALTER TABLE public.authtoken_token OWNER TO funkwhale;
251
252--
253-- Name: common_mutation; Type: TABLE; Schema: public; Owner: funkwhale
254--
255
256CREATE TABLE public.common_mutation (
257    id integer NOT NULL,
258    fid character varying(500) NOT NULL,
259    uuid uuid NOT NULL,
260    type character varying(100) NOT NULL,
261    is_approved boolean,
262    is_applied boolean,
263    creation_date timestamp with time zone NOT NULL,
264    applied_date timestamp with time zone,
265    summary text,
266    payload jsonb NOT NULL,
267    previous_state jsonb,
268    target_id integer,
269    approved_by_id integer,
270    created_by_id integer,
271    target_content_type_id integer
272);
273
274
275ALTER TABLE public.common_mutation OWNER TO funkwhale;
276
277--
278-- Name: common_mutation_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
279--
280
281CREATE SEQUENCE public.common_mutation_id_seq
282    START WITH 1
283    INCREMENT BY 1
284    NO MINVALUE
285    NO MAXVALUE
286    CACHE 1;
287
288
289ALTER TABLE public.common_mutation_id_seq OWNER TO funkwhale;
290
291--
292-- Name: common_mutation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
293--
294
295ALTER SEQUENCE public.common_mutation_id_seq OWNED BY public.common_mutation.id;
296
297
298--
299-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: funkwhale
300--
301
302CREATE TABLE public.django_admin_log (
303    id integer NOT NULL,
304    action_time timestamp with time zone NOT NULL,
305    object_id text,
306    object_repr character varying(200) NOT NULL,
307    action_flag smallint NOT NULL,
308    change_message text NOT NULL,
309    content_type_id integer,
310    user_id integer NOT NULL,
311    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
312);
313
314
315ALTER TABLE public.django_admin_log OWNER TO funkwhale;
316
317--
318-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
319--
320
321CREATE SEQUENCE public.django_admin_log_id_seq
322    START WITH 1
323    INCREMENT BY 1
324    NO MINVALUE
325    NO MAXVALUE
326    CACHE 1;
327
328
329ALTER TABLE public.django_admin_log_id_seq OWNER TO funkwhale;
330
331--
332-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
333--
334
335ALTER SEQUENCE public.django_admin_log_id_seq OWNED BY public.django_admin_log.id;
336
337
338--
339-- Name: django_content_type; Type: TABLE; Schema: public; Owner: funkwhale
340--
341
342CREATE TABLE public.django_content_type (
343    id integer NOT NULL,
344    app_label character varying(100) NOT NULL,
345    model character varying(100) NOT NULL
346);
347
348
349ALTER TABLE public.django_content_type OWNER TO funkwhale;
350
351--
352-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
353--
354
355CREATE SEQUENCE public.django_content_type_id_seq
356    START WITH 1
357    INCREMENT BY 1
358    NO MINVALUE
359    NO MAXVALUE
360    CACHE 1;
361
362
363ALTER TABLE public.django_content_type_id_seq OWNER TO funkwhale;
364
365--
366-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
367--
368
369ALTER SEQUENCE public.django_content_type_id_seq OWNED BY public.django_content_type.id;
370
371
372--
373-- Name: django_migrations; Type: TABLE; Schema: public; Owner: funkwhale
374--
375
376CREATE TABLE public.django_migrations (
377    id integer NOT NULL,
378    app character varying(255) NOT NULL,
379    name character varying(255) NOT NULL,
380    applied timestamp with time zone NOT NULL
381);
382
383
384ALTER TABLE public.django_migrations OWNER TO funkwhale;
385
386--
387-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
388--
389
390CREATE SEQUENCE public.django_migrations_id_seq
391    START WITH 1
392    INCREMENT BY 1
393    NO MINVALUE
394    NO MAXVALUE
395    CACHE 1;
396
397
398ALTER TABLE public.django_migrations_id_seq OWNER TO funkwhale;
399
400--
401-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
402--
403
404ALTER SEQUENCE public.django_migrations_id_seq OWNED BY public.django_migrations.id;
405
406
407--
408-- Name: django_session; Type: TABLE; Schema: public; Owner: funkwhale
409--
410
411CREATE TABLE public.django_session (
412    session_key character varying(40) NOT NULL,
413    session_data text NOT NULL,
414    expire_date timestamp with time zone NOT NULL
415);
416
417
418ALTER TABLE public.django_session OWNER TO funkwhale;
419
420--
421-- Name: django_site; Type: TABLE; Schema: public; Owner: funkwhale
422--
423
424CREATE TABLE public.django_site (
425    id integer NOT NULL,
426    domain character varying(100) NOT NULL,
427    name character varying(50) NOT NULL
428);
429
430
431ALTER TABLE public.django_site OWNER TO funkwhale;
432
433--
434-- Name: django_site_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
435--
436
437CREATE SEQUENCE public.django_site_id_seq
438    START WITH 1
439    INCREMENT BY 1
440    NO MINVALUE
441    NO MAXVALUE
442    CACHE 1;
443
444
445ALTER TABLE public.django_site_id_seq OWNER TO funkwhale;
446
447--
448-- Name: django_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
449--
450
451ALTER SEQUENCE public.django_site_id_seq OWNED BY public.django_site.id;
452
453
454--
455-- Name: dynamic_preferences_globalpreferencemodel; Type: TABLE; Schema: public; Owner: funkwhale
456--
457
458CREATE TABLE public.dynamic_preferences_globalpreferencemodel (
459    id integer NOT NULL,
460    section character varying(150),
461    name character varying(150) NOT NULL,
462    raw_value text
463);
464
465
466ALTER TABLE public.dynamic_preferences_globalpreferencemodel OWNER TO funkwhale;
467
468--
469-- Name: dynamic_preferences_globalpreferencemodel_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
470--
471
472CREATE SEQUENCE public.dynamic_preferences_globalpreferencemodel_id_seq
473    START WITH 1
474    INCREMENT BY 1
475    NO MINVALUE
476    NO MAXVALUE
477    CACHE 1;
478
479
480ALTER TABLE public.dynamic_preferences_globalpreferencemodel_id_seq OWNER TO funkwhale;
481
482--
483-- Name: dynamic_preferences_globalpreferencemodel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
484--
485
486ALTER SEQUENCE public.dynamic_preferences_globalpreferencemodel_id_seq OWNED BY public.dynamic_preferences_globalpreferencemodel.id;
487
488
489--
490-- Name: favorites_trackfavorite; Type: TABLE; Schema: public; Owner: funkwhale
491--
492
493CREATE TABLE public.favorites_trackfavorite (
494    id integer NOT NULL,
495    creation_date timestamp with time zone NOT NULL,
496    track_id integer NOT NULL,
497    user_id integer NOT NULL
498);
499
500
501ALTER TABLE public.favorites_trackfavorite OWNER TO funkwhale;
502
503--
504-- Name: favorites_trackfavorite_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
505--
506
507CREATE SEQUENCE public.favorites_trackfavorite_id_seq
508    START WITH 1
509    INCREMENT BY 1
510    NO MINVALUE
511    NO MAXVALUE
512    CACHE 1;
513
514
515ALTER TABLE public.favorites_trackfavorite_id_seq OWNER TO funkwhale;
516
517--
518-- Name: favorites_trackfavorite_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
519--
520
521ALTER SEQUENCE public.favorites_trackfavorite_id_seq OWNED BY public.favorites_trackfavorite.id;
522
523
524--
525-- Name: federation_activity; Type: TABLE; Schema: public; Owner: funkwhale
526--
527
528CREATE TABLE public.federation_activity (
529    id integer NOT NULL,
530    uuid uuid NOT NULL,
531    fid character varying(500),
532    url character varying(500),
533    payload jsonb NOT NULL,
534    creation_date timestamp with time zone NOT NULL,
535    actor_id integer NOT NULL,
536    object_content_type_id integer,
537    object_id integer,
538    related_object_content_type_id integer,
539    related_object_id integer,
540    target_content_type_id integer,
541    target_id integer,
542    type character varying(100)
543);
544
545
546ALTER TABLE public.federation_activity OWNER TO funkwhale;
547
548--
549-- Name: federation_activity_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
550--
551
552CREATE SEQUENCE public.federation_activity_id_seq
553    START WITH 1
554    INCREMENT BY 1
555    NO MINVALUE
556    NO MAXVALUE
557    CACHE 1;
558
559
560ALTER TABLE public.federation_activity_id_seq OWNER TO funkwhale;
561
562--
563-- Name: federation_activity_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
564--
565
566ALTER SEQUENCE public.federation_activity_id_seq OWNED BY public.federation_activity.id;
567
568
569--
570-- Name: federation_actor; Type: TABLE; Schema: public; Owner: funkwhale
571--
572
573CREATE TABLE public.federation_actor (
574    id integer NOT NULL,
575    fid character varying(500) NOT NULL,
576    outbox_url character varying(500) NOT NULL,
577    inbox_url character varying(500) NOT NULL,
578    following_url character varying(500),
579    followers_url character varying(500),
580    shared_inbox_url character varying(500),
581    type character varying(25) NOT NULL,
582    name character varying(200),
583    summary character varying(500),
584    preferred_username character varying(200),
585    public_key text,
586    private_key text,
587    creation_date timestamp with time zone NOT NULL,
588    last_fetch_date timestamp with time zone NOT NULL,
589    manually_approves_followers boolean,
590    url character varying(500),
591    domain_id character varying(255) NOT NULL
592);
593
594
595ALTER TABLE public.federation_actor OWNER TO funkwhale;
596
597--
598-- Name: federation_actor_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
599--
600
601CREATE SEQUENCE public.federation_actor_id_seq
602    START WITH 1
603    INCREMENT BY 1
604    NO MINVALUE
605    NO MAXVALUE
606    CACHE 1;
607
608
609ALTER TABLE public.federation_actor_id_seq OWNER TO funkwhale;
610
611--
612-- Name: federation_actor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
613--
614
615ALTER SEQUENCE public.federation_actor_id_seq OWNED BY public.federation_actor.id;
616
617
618--
619-- Name: federation_delivery; Type: TABLE; Schema: public; Owner: funkwhale
620--
621
622CREATE TABLE public.federation_delivery (
623    id integer NOT NULL,
624    is_delivered boolean NOT NULL,
625    last_attempt_date timestamp with time zone,
626    attempts integer NOT NULL,
627    inbox_url character varying(500) NOT NULL,
628    activity_id integer NOT NULL,
629    CONSTRAINT federation_delivery_attempts_check CHECK ((attempts >= 0))
630);
631
632
633ALTER TABLE public.federation_delivery OWNER TO funkwhale;
634
635--
636-- Name: federation_delivery_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
637--
638
639CREATE SEQUENCE public.federation_delivery_id_seq
640    START WITH 1
641    INCREMENT BY 1
642    NO MINVALUE
643    NO MAXVALUE
644    CACHE 1;
645
646
647ALTER TABLE public.federation_delivery_id_seq OWNER TO funkwhale;
648
649--
650-- Name: federation_delivery_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
651--
652
653ALTER SEQUENCE public.federation_delivery_id_seq OWNED BY public.federation_delivery.id;
654
655
656--
657-- Name: federation_domain; Type: TABLE; Schema: public; Owner: funkwhale
658--
659
660CREATE TABLE public.federation_domain (
661    name character varying(255) NOT NULL,
662    creation_date timestamp with time zone NOT NULL,
663    nodeinfo jsonb NOT NULL,
664    nodeinfo_fetch_date timestamp with time zone,
665    service_actor_id integer,
666    allowed boolean
667);
668
669
670ALTER TABLE public.federation_domain OWNER TO funkwhale;
671
672--
673-- Name: federation_fetch; Type: TABLE; Schema: public; Owner: funkwhale
674--
675
676CREATE TABLE public.federation_fetch (
677    id integer NOT NULL,
678    url character varying(500) NOT NULL,
679    creation_date timestamp with time zone NOT NULL,
680    fetch_date timestamp with time zone,
681    object_id integer,
682    status character varying(20) NOT NULL,
683    detail jsonb NOT NULL,
684    actor_id integer NOT NULL,
685    object_content_type_id integer
686);
687
688
689ALTER TABLE public.federation_fetch OWNER TO funkwhale;
690
691--
692-- Name: federation_fetch_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
693--
694
695CREATE SEQUENCE public.federation_fetch_id_seq
696    START WITH 1
697    INCREMENT BY 1
698    NO MINVALUE
699    NO MAXVALUE
700    CACHE 1;
701
702
703ALTER TABLE public.federation_fetch_id_seq OWNER TO funkwhale;
704
705--
706-- Name: federation_fetch_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
707--
708
709ALTER SEQUENCE public.federation_fetch_id_seq OWNED BY public.federation_fetch.id;
710
711
712--
713-- Name: federation_follow; Type: TABLE; Schema: public; Owner: funkwhale
714--
715
716CREATE TABLE public.federation_follow (
717    id integer NOT NULL,
718    uuid uuid NOT NULL,
719    creation_date timestamp with time zone NOT NULL,
720    modification_date timestamp with time zone NOT NULL,
721    actor_id integer NOT NULL,
722    target_id integer NOT NULL,
723    approved boolean,
724    fid character varying(500)
725);
726
727
728ALTER TABLE public.federation_follow OWNER TO funkwhale;
729
730--
731-- Name: federation_follow_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
732--
733
734CREATE SEQUENCE public.federation_follow_id_seq
735    START WITH 1
736    INCREMENT BY 1
737    NO MINVALUE
738    NO MAXVALUE
739    CACHE 1;
740
741
742ALTER TABLE public.federation_follow_id_seq OWNER TO funkwhale;
743
744--
745-- Name: federation_follow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
746--
747
748ALTER SEQUENCE public.federation_follow_id_seq OWNED BY public.federation_follow.id;
749
750
751--
752-- Name: federation_inboxitem; Type: TABLE; Schema: public; Owner: funkwhale
753--
754
755CREATE TABLE public.federation_inboxitem (
756    id integer NOT NULL,
757    type character varying(10) NOT NULL,
758    activity_id integer NOT NULL,
759    actor_id integer NOT NULL,
760    is_read boolean NOT NULL
761);
762
763
764ALTER TABLE public.federation_inboxitem OWNER TO funkwhale;
765
766--
767-- Name: federation_inboxitem_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
768--
769
770CREATE SEQUENCE public.federation_inboxitem_id_seq
771    START WITH 1
772    INCREMENT BY 1
773    NO MINVALUE
774    NO MAXVALUE
775    CACHE 1;
776
777
778ALTER TABLE public.federation_inboxitem_id_seq OWNER TO funkwhale;
779
780--
781-- Name: federation_inboxitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
782--
783
784ALTER SEQUENCE public.federation_inboxitem_id_seq OWNED BY public.federation_inboxitem.id;
785
786
787--
788-- Name: federation_library; Type: TABLE; Schema: public; Owner: funkwhale
789--
790
791CREATE TABLE public.federation_library (
792    id integer NOT NULL,
793    creation_date timestamp with time zone NOT NULL,
794    modification_date timestamp with time zone NOT NULL,
795    fetched_date timestamp with time zone,
796    uuid uuid NOT NULL,
797    url character varying(500) NOT NULL,
798    federation_enabled boolean NOT NULL,
799    download_files boolean NOT NULL,
800    autoimport boolean NOT NULL,
801    tracks_count integer,
802    actor_id integer NOT NULL,
803    follow_id integer,
804    CONSTRAINT federation_library_tracks_count_check CHECK ((tracks_count >= 0))
805);
806
807
808ALTER TABLE public.federation_library OWNER TO funkwhale;
809
810--
811-- Name: federation_library_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
812--
813
814CREATE SEQUENCE public.federation_library_id_seq
815    START WITH 1
816    INCREMENT BY 1
817    NO MINVALUE
818    NO MAXVALUE
819    CACHE 1;
820
821
822ALTER TABLE public.federation_library_id_seq OWNER TO funkwhale;
823
824--
825-- Name: federation_library_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
826--
827
828ALTER SEQUENCE public.federation_library_id_seq OWNED BY public.federation_library.id;
829
830
831--
832-- Name: federation_libraryfollow; Type: TABLE; Schema: public; Owner: funkwhale
833--
834
835CREATE TABLE public.federation_libraryfollow (
836    id integer NOT NULL,
837    fid character varying(500),
838    uuid uuid NOT NULL,
839    creation_date timestamp with time zone NOT NULL,
840    modification_date timestamp with time zone NOT NULL,
841    approved boolean,
842    actor_id integer NOT NULL,
843    target_id integer NOT NULL
844);
845
846
847ALTER TABLE public.federation_libraryfollow OWNER TO funkwhale;
848
849--
850-- Name: federation_libraryfollow_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
851--
852
853CREATE SEQUENCE public.federation_libraryfollow_id_seq
854    START WITH 1
855    INCREMENT BY 1
856    NO MINVALUE
857    NO MAXVALUE
858    CACHE 1;
859
860
861ALTER TABLE public.federation_libraryfollow_id_seq OWNER TO funkwhale;
862
863--
864-- Name: federation_libraryfollow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
865--
866
867ALTER SEQUENCE public.federation_libraryfollow_id_seq OWNED BY public.federation_libraryfollow.id;
868
869
870--
871-- Name: federation_librarytrack; Type: TABLE; Schema: public; Owner: funkwhale
872--
873
874CREATE TABLE public.federation_librarytrack (
875    id integer NOT NULL,
876    url character varying(500) NOT NULL,
877    audio_url character varying(500) NOT NULL,
878    audio_mimetype character varying(200) NOT NULL,
879    creation_date timestamp with time zone NOT NULL,
880    modification_date timestamp with time zone NOT NULL,
881    fetched_date timestamp with time zone,
882    published_date timestamp with time zone,
883    artist_name character varying(500) NOT NULL,
884    album_title character varying(500) NOT NULL,
885    title character varying(500) NOT NULL,
886    metadata jsonb NOT NULL,
887    library_id integer NOT NULL,
888    audio_file character varying(100)
889);
890
891
892ALTER TABLE public.federation_librarytrack OWNER TO funkwhale;
893
894--
895-- Name: federation_librarytrack_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
896--
897
898CREATE SEQUENCE public.federation_librarytrack_id_seq
899    START WITH 1
900    INCREMENT BY 1
901    NO MINVALUE
902    NO MAXVALUE
903    CACHE 1;
904
905
906ALTER TABLE public.federation_librarytrack_id_seq OWNER TO funkwhale;
907
908--
909-- Name: federation_librarytrack_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
910--
911
912ALTER SEQUENCE public.federation_librarytrack_id_seq OWNED BY public.federation_librarytrack.id;
913
914
915--
916-- Name: history_listening; Type: TABLE; Schema: public; Owner: funkwhale
917--
918
919CREATE TABLE public.history_listening (
920    id integer NOT NULL,
921    creation_date timestamp with time zone,
922    session_key character varying(100),
923    track_id integer NOT NULL,
924    user_id integer
925);
926
927
928ALTER TABLE public.history_listening OWNER TO funkwhale;
929
930--
931-- Name: history_listening_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
932--
933
934CREATE SEQUENCE public.history_listening_id_seq
935    START WITH 1
936    INCREMENT BY 1
937    NO MINVALUE
938    NO MAXVALUE
939    CACHE 1;
940
941
942ALTER TABLE public.history_listening_id_seq OWNER TO funkwhale;
943
944--
945-- Name: history_listening_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
946--
947
948ALTER SEQUENCE public.history_listening_id_seq OWNED BY public.history_listening.id;
949
950
951--
952-- Name: moderation_instancepolicy; Type: TABLE; Schema: public; Owner: funkwhale
953--
954
955CREATE TABLE public.moderation_instancepolicy (
956    id integer NOT NULL,
957    uuid uuid NOT NULL,
958    creation_date timestamp with time zone NOT NULL,
959    is_active boolean NOT NULL,
960    summary text,
961    block_all boolean NOT NULL,
962    silence_activity boolean NOT NULL,
963    silence_notifications boolean NOT NULL,
964    reject_media boolean NOT NULL,
965    actor_id integer,
966    target_actor_id integer,
967    target_domain_id character varying(255)
968);
969
970
971ALTER TABLE public.moderation_instancepolicy OWNER TO funkwhale;
972
973--
974-- Name: moderation_instancepolicy_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
975--
976
977CREATE SEQUENCE public.moderation_instancepolicy_id_seq
978    START WITH 1
979    INCREMENT BY 1
980    NO MINVALUE
981    NO MAXVALUE
982    CACHE 1;
983
984
985ALTER TABLE public.moderation_instancepolicy_id_seq OWNER TO funkwhale;
986
987--
988-- Name: moderation_instancepolicy_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
989--
990
991ALTER SEQUENCE public.moderation_instancepolicy_id_seq OWNED BY public.moderation_instancepolicy.id;
992
993
994--
995-- Name: moderation_userfilter; Type: TABLE; Schema: public; Owner: funkwhale
996--
997
998CREATE TABLE public.moderation_userfilter (
999    id integer NOT NULL,
1000    uuid uuid NOT NULL,
1001    creation_date timestamp with time zone NOT NULL,
1002    target_artist_id integer NOT NULL,
1003    user_id integer NOT NULL
1004);
1005
1006
1007ALTER TABLE public.moderation_userfilter OWNER TO funkwhale;
1008
1009--
1010-- Name: moderation_userfilter_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1011--
1012
1013CREATE SEQUENCE public.moderation_userfilter_id_seq
1014    START WITH 1
1015    INCREMENT BY 1
1016    NO MINVALUE
1017    NO MAXVALUE
1018    CACHE 1;
1019
1020
1021ALTER TABLE public.moderation_userfilter_id_seq OWNER TO funkwhale;
1022
1023--
1024-- Name: moderation_userfilter_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1025--
1026
1027ALTER SEQUENCE public.moderation_userfilter_id_seq OWNED BY public.moderation_userfilter.id;
1028
1029
1030--
1031-- Name: music_album; Type: TABLE; Schema: public; Owner: funkwhale
1032--
1033
1034CREATE TABLE public.music_album (
1035    id integer NOT NULL,
1036    mbid uuid,
1037    creation_date timestamp with time zone NOT NULL,
1038    title character varying(255) NOT NULL,
1039    release_date date,
1040    type character varying(30) NOT NULL,
1041    artist_id integer NOT NULL,
1042    cover character varying(100),
1043    release_group_id uuid,
1044    uuid uuid NOT NULL,
1045    fid character varying(500),
1046    from_activity_id integer,
1047    attributed_to_id integer
1048);
1049
1050
1051ALTER TABLE public.music_album OWNER TO funkwhale;
1052
1053--
1054-- Name: music_album_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1055--
1056
1057CREATE SEQUENCE public.music_album_id_seq
1058    START WITH 1
1059    INCREMENT BY 1
1060    NO MINVALUE
1061    NO MAXVALUE
1062    CACHE 1;
1063
1064
1065ALTER TABLE public.music_album_id_seq OWNER TO funkwhale;
1066
1067--
1068-- Name: music_album_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1069--
1070
1071ALTER SEQUENCE public.music_album_id_seq OWNED BY public.music_album.id;
1072
1073
1074--
1075-- Name: music_artist; Type: TABLE; Schema: public; Owner: funkwhale
1076--
1077
1078CREATE TABLE public.music_artist (
1079    id integer NOT NULL,
1080    mbid uuid,
1081    creation_date timestamp with time zone NOT NULL,
1082    name character varying(255) NOT NULL,
1083    uuid uuid NOT NULL,
1084    fid character varying(500),
1085    from_activity_id integer,
1086    attributed_to_id integer
1087);
1088
1089
1090ALTER TABLE public.music_artist OWNER TO funkwhale;
1091
1092--
1093-- Name: music_artist_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1094--
1095
1096CREATE SEQUENCE public.music_artist_id_seq
1097    START WITH 1
1098    INCREMENT BY 1
1099    NO MINVALUE
1100    NO MAXVALUE
1101    CACHE 1;
1102
1103
1104ALTER TABLE public.music_artist_id_seq OWNER TO funkwhale;
1105
1106--
1107-- Name: music_artist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1108--
1109
1110ALTER SEQUENCE public.music_artist_id_seq OWNED BY public.music_artist.id;
1111
1112
1113--
1114-- Name: music_importbatch; Type: TABLE; Schema: public; Owner: funkwhale
1115--
1116
1117CREATE TABLE public.music_importbatch (
1118    id integer NOT NULL,
1119    creation_date timestamp with time zone NOT NULL,
1120    submitted_by_id integer,
1121    source character varying(30) NOT NULL,
1122    status character varying(30) NOT NULL,
1123    import_request_id integer,
1124    uuid uuid NOT NULL,
1125    library_id integer
1126);
1127
1128
1129ALTER TABLE public.music_importbatch OWNER TO funkwhale;
1130
1131--
1132-- Name: music_importbatch_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1133--
1134
1135CREATE SEQUENCE public.music_importbatch_id_seq
1136    START WITH 1
1137    INCREMENT BY 1
1138    NO MINVALUE
1139    NO MAXVALUE
1140    CACHE 1;
1141
1142
1143ALTER TABLE public.music_importbatch_id_seq OWNER TO funkwhale;
1144
1145--
1146-- Name: music_importbatch_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1147--
1148
1149ALTER SEQUENCE public.music_importbatch_id_seq OWNED BY public.music_importbatch.id;
1150
1151
1152--
1153-- Name: music_importjob; Type: TABLE; Schema: public; Owner: funkwhale
1154--
1155
1156CREATE TABLE public.music_importjob (
1157    id integer NOT NULL,
1158    source character varying(500) NOT NULL,
1159    mbid uuid,
1160    status character varying(30) NOT NULL,
1161    batch_id integer NOT NULL,
1162    upload_id integer,
1163    audio_file character varying(255),
1164    library_track_id integer,
1165    uuid uuid NOT NULL,
1166    replace_if_duplicate boolean NOT NULL,
1167    audio_file_size integer
1168);
1169
1170
1171ALTER TABLE public.music_importjob OWNER TO funkwhale;
1172
1173--
1174-- Name: music_importjob_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1175--
1176
1177CREATE SEQUENCE public.music_importjob_id_seq
1178    START WITH 1
1179    INCREMENT BY 1
1180    NO MINVALUE
1181    NO MAXVALUE
1182    CACHE 1;
1183
1184
1185ALTER TABLE public.music_importjob_id_seq OWNER TO funkwhale;
1186
1187--
1188-- Name: music_importjob_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1189--
1190
1191ALTER SEQUENCE public.music_importjob_id_seq OWNED BY public.music_importjob.id;
1192
1193
1194--
1195-- Name: music_library; Type: TABLE; Schema: public; Owner: funkwhale
1196--
1197
1198CREATE TABLE public.music_library (
1199    id integer NOT NULL,
1200    fid character varying(500) NOT NULL,
1201    url character varying(500),
1202    uuid uuid NOT NULL,
1203    followers_url character varying(500) NOT NULL,
1204    creation_date timestamp with time zone NOT NULL,
1205    name character varying(100) NOT NULL,
1206    description text,
1207    privacy_level character varying(25) NOT NULL,
1208    actor_id integer NOT NULL,
1209    uploads_count integer NOT NULL,
1210    CONSTRAINT music_library_uploads_count_38407877_check CHECK ((uploads_count >= 0))
1211);
1212
1213
1214ALTER TABLE public.music_library OWNER TO funkwhale;
1215
1216--
1217-- Name: music_library_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1218--
1219
1220CREATE SEQUENCE public.music_library_id_seq
1221    START WITH 1
1222    INCREMENT BY 1
1223    NO MINVALUE
1224    NO MAXVALUE
1225    CACHE 1;
1226
1227
1228ALTER TABLE public.music_library_id_seq OWNER TO funkwhale;
1229
1230--
1231-- Name: music_library_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1232--
1233
1234ALTER SEQUENCE public.music_library_id_seq OWNED BY public.music_library.id;
1235
1236
1237--
1238-- Name: music_libraryscan; Type: TABLE; Schema: public; Owner: funkwhale
1239--
1240
1241CREATE TABLE public.music_libraryscan (
1242    id integer NOT NULL,
1243    total_files integer NOT NULL,
1244    processed_files integer NOT NULL,
1245    errored_files integer NOT NULL,
1246    status character varying(25) NOT NULL,
1247    creation_date timestamp with time zone NOT NULL,
1248    modification_date timestamp with time zone,
1249    actor_id integer,
1250    library_id integer NOT NULL,
1251    CONSTRAINT music_libraryscan_errored_files_check CHECK ((errored_files >= 0)),
1252    CONSTRAINT music_libraryscan_processed_files_check CHECK ((processed_files >= 0)),
1253    CONSTRAINT music_libraryscan_total_files_check CHECK ((total_files >= 0))
1254);
1255
1256
1257ALTER TABLE public.music_libraryscan OWNER TO funkwhale;
1258
1259--
1260-- Name: music_libraryscan_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1261--
1262
1263CREATE SEQUENCE public.music_libraryscan_id_seq
1264    START WITH 1
1265    INCREMENT BY 1
1266    NO MINVALUE
1267    NO MAXVALUE
1268    CACHE 1;
1269
1270
1271ALTER TABLE public.music_libraryscan_id_seq OWNER TO funkwhale;
1272
1273--
1274-- Name: music_libraryscan_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1275--
1276
1277ALTER SEQUENCE public.music_libraryscan_id_seq OWNED BY public.music_libraryscan.id;
1278
1279
1280--
1281-- Name: music_license; Type: TABLE; Schema: public; Owner: funkwhale
1282--
1283
1284CREATE TABLE public.music_license (
1285    code character varying(100) NOT NULL,
1286    url character varying(500) NOT NULL,
1287    copyleft boolean NOT NULL,
1288    commercial boolean NOT NULL,
1289    attribution boolean NOT NULL,
1290    derivative boolean NOT NULL,
1291    redistribute boolean NOT NULL
1292);
1293
1294
1295ALTER TABLE public.music_license OWNER TO funkwhale;
1296
1297--
1298-- Name: music_track; Type: TABLE; Schema: public; Owner: funkwhale
1299--
1300
1301CREATE TABLE public.music_track (
1302    id integer NOT NULL,
1303    mbid uuid,
1304    creation_date timestamp with time zone NOT NULL,
1305    title character varying(255) NOT NULL,
1306    album_id integer,
1307    artist_id integer NOT NULL,
1308    "position" integer,
1309    uuid uuid NOT NULL,
1310    fid character varying(500),
1311    from_activity_id integer,
1312    license_id character varying(100),
1313    copyright character varying(500),
1314    disc_number integer,
1315    attributed_to_id integer,
1316    CONSTRAINT music_track_disc_number_check CHECK ((disc_number >= 0)),
1317    CONSTRAINT music_track_position_check CHECK (("position" >= 0))
1318);
1319
1320
1321ALTER TABLE public.music_track OWNER TO funkwhale;
1322
1323--
1324-- Name: music_track_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1325--
1326
1327CREATE SEQUENCE public.music_track_id_seq
1328    START WITH 1
1329    INCREMENT BY 1
1330    NO MINVALUE
1331    NO MAXVALUE
1332    CACHE 1;
1333
1334
1335ALTER TABLE public.music_track_id_seq OWNER TO funkwhale;
1336
1337--
1338-- Name: music_track_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1339--
1340
1341ALTER SEQUENCE public.music_track_id_seq OWNED BY public.music_track.id;
1342
1343
1344--
1345-- Name: music_upload; Type: TABLE; Schema: public; Owner: funkwhale
1346--
1347
1348CREATE TABLE public.music_upload (
1349    id integer NOT NULL,
1350    audio_file character varying(255) NOT NULL,
1351    source character varying(500),
1352    duration integer,
1353    track_id integer,
1354    acoustid_track_id uuid,
1355    mimetype character varying(200),
1356    creation_date timestamp with time zone NOT NULL,
1357    modification_date timestamp with time zone,
1358    uuid uuid NOT NULL,
1359    accessed_date timestamp with time zone,
1360    bitrate integer,
1361    size integer,
1362    library_id integer,
1363    fid character varying(500),
1364    import_date timestamp with time zone,
1365    import_details jsonb NOT NULL,
1366    import_metadata jsonb NOT NULL,
1367    import_reference character varying(50) NOT NULL,
1368    import_status character varying(25) NOT NULL,
1369    metadata jsonb NOT NULL,
1370    from_activity_id integer
1371);
1372
1373
1374ALTER TABLE public.music_upload OWNER TO funkwhale;
1375
1376--
1377-- Name: music_trackfile_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1378--
1379
1380CREATE SEQUENCE public.music_trackfile_id_seq
1381    START WITH 1
1382    INCREMENT BY 1
1383    NO MINVALUE
1384    NO MAXVALUE
1385    CACHE 1;
1386
1387
1388ALTER TABLE public.music_trackfile_id_seq OWNER TO funkwhale;
1389
1390--
1391-- Name: music_trackfile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1392--
1393
1394ALTER SEQUENCE public.music_trackfile_id_seq OWNED BY public.music_upload.id;
1395
1396
1397--
1398-- Name: music_uploadversion; Type: TABLE; Schema: public; Owner: funkwhale
1399--
1400
1401CREATE TABLE public.music_uploadversion (
1402    id integer NOT NULL,
1403    mimetype character varying(50) NOT NULL,
1404    creation_date timestamp with time zone NOT NULL,
1405    accessed_date timestamp with time zone,
1406    audio_file character varying(255) NOT NULL,
1407    bitrate integer NOT NULL,
1408    size integer NOT NULL,
1409    upload_id integer NOT NULL,
1410    CONSTRAINT music_uploadversion_bitrate_check CHECK ((bitrate >= 0))
1411);
1412
1413
1414ALTER TABLE public.music_uploadversion OWNER TO funkwhale;
1415
1416--
1417-- Name: music_uploadversion_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1418--
1419
1420CREATE SEQUENCE public.music_uploadversion_id_seq
1421    START WITH 1
1422    INCREMENT BY 1
1423    NO MINVALUE
1424    NO MAXVALUE
1425    CACHE 1;
1426
1427
1428ALTER TABLE public.music_uploadversion_id_seq OWNER TO funkwhale;
1429
1430--
1431-- Name: music_uploadversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1432--
1433
1434ALTER SEQUENCE public.music_uploadversion_id_seq OWNED BY public.music_uploadversion.id;
1435
1436
1437--
1438-- Name: playlists_playlist; Type: TABLE; Schema: public; Owner: funkwhale
1439--
1440
1441CREATE TABLE public.playlists_playlist (
1442    id integer NOT NULL,
1443    name character varying(50) NOT NULL,
1444    creation_date timestamp with time zone NOT NULL,
1445    user_id integer NOT NULL,
1446    privacy_level character varying(30) NOT NULL,
1447    modification_date timestamp with time zone NOT NULL
1448);
1449
1450
1451ALTER TABLE public.playlists_playlist OWNER TO funkwhale;
1452
1453--
1454-- Name: playlists_playlist_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1455--
1456
1457CREATE SEQUENCE public.playlists_playlist_id_seq
1458    START WITH 1
1459    INCREMENT BY 1
1460    NO MINVALUE
1461    NO MAXVALUE
1462    CACHE 1;
1463
1464
1465ALTER TABLE public.playlists_playlist_id_seq OWNER TO funkwhale;
1466
1467--
1468-- Name: playlists_playlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1469--
1470
1471ALTER SEQUENCE public.playlists_playlist_id_seq OWNED BY public.playlists_playlist.id;
1472
1473
1474--
1475-- Name: playlists_playlisttrack; Type: TABLE; Schema: public; Owner: funkwhale
1476--
1477
1478CREATE TABLE public.playlists_playlisttrack (
1479    id integer NOT NULL,
1480    playlist_id integer NOT NULL,
1481    track_id integer NOT NULL,
1482    creation_date timestamp with time zone NOT NULL,
1483    index integer,
1484    CONSTRAINT playlists_playlisttrack_index_check CHECK ((index >= 0))
1485);
1486
1487
1488ALTER TABLE public.playlists_playlisttrack OWNER TO funkwhale;
1489
1490--
1491-- Name: playlists_playlisttrack_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1492--
1493
1494CREATE SEQUENCE public.playlists_playlisttrack_id_seq
1495    START WITH 1
1496    INCREMENT BY 1
1497    NO MINVALUE
1498    NO MAXVALUE
1499    CACHE 1;
1500
1501
1502ALTER TABLE public.playlists_playlisttrack_id_seq OWNER TO funkwhale;
1503
1504--
1505-- Name: playlists_playlisttrack_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1506--
1507
1508ALTER SEQUENCE public.playlists_playlisttrack_id_seq OWNED BY public.playlists_playlisttrack.id;
1509
1510
1511--
1512-- Name: radios_radio; Type: TABLE; Schema: public; Owner: funkwhale
1513--
1514
1515CREATE TABLE public.radios_radio (
1516    id integer NOT NULL,
1517    name character varying(100) NOT NULL,
1518    description text NOT NULL,
1519    creation_date timestamp with time zone NOT NULL,
1520    is_public boolean NOT NULL,
1521    version integer NOT NULL,
1522    config jsonb NOT NULL,
1523    user_id integer,
1524    CONSTRAINT radios_radio_version_check CHECK ((version >= 0))
1525);
1526
1527
1528ALTER TABLE public.radios_radio OWNER TO funkwhale;
1529
1530--
1531-- Name: radios_radio_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1532--
1533
1534CREATE SEQUENCE public.radios_radio_id_seq
1535    START WITH 1
1536    INCREMENT BY 1
1537    NO MINVALUE
1538    NO MAXVALUE
1539    CACHE 1;
1540
1541
1542ALTER TABLE public.radios_radio_id_seq OWNER TO funkwhale;
1543
1544--
1545-- Name: radios_radio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1546--
1547
1548ALTER SEQUENCE public.radios_radio_id_seq OWNED BY public.radios_radio.id;
1549
1550
1551--
1552-- Name: radios_radiosession; Type: TABLE; Schema: public; Owner: funkwhale
1553--
1554
1555CREATE TABLE public.radios_radiosession (
1556    id integer NOT NULL,
1557    radio_type character varying(50) NOT NULL,
1558    creation_date timestamp with time zone NOT NULL,
1559    user_id integer,
1560    session_key character varying(100),
1561    related_object_content_type_id integer,
1562    related_object_id integer,
1563    custom_radio_id integer,
1564    CONSTRAINT radios_radiosession_related_object_id_check CHECK ((related_object_id >= 0))
1565);
1566
1567
1568ALTER TABLE public.radios_radiosession OWNER TO funkwhale;
1569
1570--
1571-- Name: radios_radiosession_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1572--
1573
1574CREATE SEQUENCE public.radios_radiosession_id_seq
1575    START WITH 1
1576    INCREMENT BY 1
1577    NO MINVALUE
1578    NO MAXVALUE
1579    CACHE 1;
1580
1581
1582ALTER TABLE public.radios_radiosession_id_seq OWNER TO funkwhale;
1583
1584--
1585-- Name: radios_radiosession_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1586--
1587
1588ALTER SEQUENCE public.radios_radiosession_id_seq OWNED BY public.radios_radiosession.id;
1589
1590
1591--
1592-- Name: radios_radiosessiontrack; Type: TABLE; Schema: public; Owner: funkwhale
1593--
1594
1595CREATE TABLE public.radios_radiosessiontrack (
1596    id integer NOT NULL,
1597    "position" integer NOT NULL,
1598    session_id integer NOT NULL,
1599    track_id integer NOT NULL
1600);
1601
1602
1603ALTER TABLE public.radios_radiosessiontrack OWNER TO funkwhale;
1604
1605--
1606-- Name: radios_radiosessiontrack_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1607--
1608
1609CREATE SEQUENCE public.radios_radiosessiontrack_id_seq
1610    START WITH 1
1611    INCREMENT BY 1
1612    NO MINVALUE
1613    NO MAXVALUE
1614    CACHE 1;
1615
1616
1617ALTER TABLE public.radios_radiosessiontrack_id_seq OWNER TO funkwhale;
1618
1619--
1620-- Name: radios_radiosessiontrack_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1621--
1622
1623ALTER SEQUENCE public.radios_radiosessiontrack_id_seq OWNED BY public.radios_radiosessiontrack.id;
1624
1625
1626--
1627-- Name: requests_importrequest; Type: TABLE; Schema: public; Owner: funkwhale
1628--
1629
1630CREATE TABLE public.requests_importrequest (
1631    id integer NOT NULL,
1632    creation_date timestamp with time zone NOT NULL,
1633    imported_date timestamp with time zone,
1634    artist_name character varying(250) NOT NULL,
1635    albums character varying(3000),
1636    status character varying(50) NOT NULL,
1637    comment text,
1638    user_id integer NOT NULL
1639);
1640
1641
1642ALTER TABLE public.requests_importrequest OWNER TO funkwhale;
1643
1644--
1645-- Name: requests_importrequest_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1646--
1647
1648CREATE SEQUENCE public.requests_importrequest_id_seq
1649    START WITH 1
1650    INCREMENT BY 1
1651    NO MINVALUE
1652    NO MAXVALUE
1653    CACHE 1;
1654
1655
1656ALTER TABLE public.requests_importrequest_id_seq OWNER TO funkwhale;
1657
1658--
1659-- Name: requests_importrequest_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1660--
1661
1662ALTER SEQUENCE public.requests_importrequest_id_seq OWNED BY public.requests_importrequest.id;
1663
1664
1665--
1666-- Name: socialaccount_socialaccount; Type: TABLE; Schema: public; Owner: funkwhale
1667--
1668
1669CREATE TABLE public.socialaccount_socialaccount (
1670    id integer NOT NULL,
1671    provider character varying(30) NOT NULL,
1672    uid character varying(191) NOT NULL,
1673    last_login timestamp with time zone NOT NULL,
1674    date_joined timestamp with time zone NOT NULL,
1675    extra_data text NOT NULL,
1676    user_id integer NOT NULL
1677);
1678
1679
1680ALTER TABLE public.socialaccount_socialaccount OWNER TO funkwhale;
1681
1682--
1683-- Name: socialaccount_socialaccount_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1684--
1685
1686CREATE SEQUENCE public.socialaccount_socialaccount_id_seq
1687    START WITH 1
1688    INCREMENT BY 1
1689    NO MINVALUE
1690    NO MAXVALUE
1691    CACHE 1;
1692
1693
1694ALTER TABLE public.socialaccount_socialaccount_id_seq OWNER TO funkwhale;
1695
1696--
1697-- Name: socialaccount_socialaccount_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1698--
1699
1700ALTER SEQUENCE public.socialaccount_socialaccount_id_seq OWNED BY public.socialaccount_socialaccount.id;
1701
1702
1703--
1704-- Name: socialaccount_socialapp; Type: TABLE; Schema: public; Owner: funkwhale
1705--
1706
1707CREATE TABLE public.socialaccount_socialapp (
1708    id integer NOT NULL,
1709    provider character varying(30) NOT NULL,
1710    name character varying(40) NOT NULL,
1711    client_id character varying(191) NOT NULL,
1712    secret character varying(191) NOT NULL,
1713    key character varying(191) NOT NULL
1714);
1715
1716
1717ALTER TABLE public.socialaccount_socialapp OWNER TO funkwhale;
1718
1719--
1720-- Name: socialaccount_socialapp_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1721--
1722
1723CREATE SEQUENCE public.socialaccount_socialapp_id_seq
1724    START WITH 1
1725    INCREMENT BY 1
1726    NO MINVALUE
1727    NO MAXVALUE
1728    CACHE 1;
1729
1730
1731ALTER TABLE public.socialaccount_socialapp_id_seq OWNER TO funkwhale;
1732
1733--
1734-- Name: socialaccount_socialapp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1735--
1736
1737ALTER SEQUENCE public.socialaccount_socialapp_id_seq OWNED BY public.socialaccount_socialapp.id;
1738
1739
1740--
1741-- Name: socialaccount_socialapp_sites; Type: TABLE; Schema: public; Owner: funkwhale
1742--
1743
1744CREATE TABLE public.socialaccount_socialapp_sites (
1745    id integer NOT NULL,
1746    socialapp_id integer NOT NULL,
1747    site_id integer NOT NULL
1748);
1749
1750
1751ALTER TABLE public.socialaccount_socialapp_sites OWNER TO funkwhale;
1752
1753--
1754-- Name: socialaccount_socialapp_sites_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1755--
1756
1757CREATE SEQUENCE public.socialaccount_socialapp_sites_id_seq
1758    START WITH 1
1759    INCREMENT BY 1
1760    NO MINVALUE
1761    NO MAXVALUE
1762    CACHE 1;
1763
1764
1765ALTER TABLE public.socialaccount_socialapp_sites_id_seq OWNER TO funkwhale;
1766
1767--
1768-- Name: socialaccount_socialapp_sites_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1769--
1770
1771ALTER SEQUENCE public.socialaccount_socialapp_sites_id_seq OWNED BY public.socialaccount_socialapp_sites.id;
1772
1773
1774--
1775-- Name: socialaccount_socialtoken; Type: TABLE; Schema: public; Owner: funkwhale
1776--
1777
1778CREATE TABLE public.socialaccount_socialtoken (
1779    id integer NOT NULL,
1780    token text NOT NULL,
1781    token_secret text NOT NULL,
1782    expires_at timestamp with time zone,
1783    account_id integer NOT NULL,
1784    app_id integer NOT NULL
1785);
1786
1787
1788ALTER TABLE public.socialaccount_socialtoken OWNER TO funkwhale;
1789
1790--
1791-- Name: socialaccount_socialtoken_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1792--
1793
1794CREATE SEQUENCE public.socialaccount_socialtoken_id_seq
1795    START WITH 1
1796    INCREMENT BY 1
1797    NO MINVALUE
1798    NO MAXVALUE
1799    CACHE 1;
1800
1801
1802ALTER TABLE public.socialaccount_socialtoken_id_seq OWNER TO funkwhale;
1803
1804--
1805-- Name: socialaccount_socialtoken_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1806--
1807
1808ALTER SEQUENCE public.socialaccount_socialtoken_id_seq OWNED BY public.socialaccount_socialtoken.id;
1809
1810
1811--
1812-- Name: taggit_tag; Type: TABLE; Schema: public; Owner: funkwhale
1813--
1814
1815CREATE TABLE public.taggit_tag (
1816    id integer NOT NULL,
1817    name character varying(100) NOT NULL,
1818    slug character varying(100) NOT NULL
1819);
1820
1821
1822ALTER TABLE public.taggit_tag OWNER TO funkwhale;
1823
1824--
1825-- Name: taggit_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1826--
1827
1828CREATE SEQUENCE public.taggit_tag_id_seq
1829    START WITH 1
1830    INCREMENT BY 1
1831    NO MINVALUE
1832    NO MAXVALUE
1833    CACHE 1;
1834
1835
1836ALTER TABLE public.taggit_tag_id_seq OWNER TO funkwhale;
1837
1838--
1839-- Name: taggit_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1840--
1841
1842ALTER SEQUENCE public.taggit_tag_id_seq OWNED BY public.taggit_tag.id;
1843
1844
1845--
1846-- Name: taggit_taggeditem; Type: TABLE; Schema: public; Owner: funkwhale
1847--
1848
1849CREATE TABLE public.taggit_taggeditem (
1850    id integer NOT NULL,
1851    object_id integer NOT NULL,
1852    content_type_id integer NOT NULL,
1853    tag_id integer NOT NULL
1854);
1855
1856
1857ALTER TABLE public.taggit_taggeditem OWNER TO funkwhale;
1858
1859--
1860-- Name: taggit_taggeditem_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1861--
1862
1863CREATE SEQUENCE public.taggit_taggeditem_id_seq
1864    START WITH 1
1865    INCREMENT BY 1
1866    NO MINVALUE
1867    NO MAXVALUE
1868    CACHE 1;
1869
1870
1871ALTER TABLE public.taggit_taggeditem_id_seq OWNER TO funkwhale;
1872
1873--
1874-- Name: taggit_taggeditem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1875--
1876
1877ALTER SEQUENCE public.taggit_taggeditem_id_seq OWNED BY public.taggit_taggeditem.id;
1878
1879
1880--
1881-- Name: tags_tag; Type: TABLE; Schema: public; Owner: funkwhale
1882--
1883
1884CREATE TABLE public.tags_tag (
1885    id integer NOT NULL,
1886    name public.citext NOT NULL,
1887    creation_date timestamp with time zone NOT NULL
1888);
1889
1890
1891ALTER TABLE public.tags_tag OWNER TO funkwhale;
1892
1893--
1894-- Name: tags_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1895--
1896
1897CREATE SEQUENCE public.tags_tag_id_seq
1898    START WITH 1
1899    INCREMENT BY 1
1900    NO MINVALUE
1901    NO MAXVALUE
1902    CACHE 1;
1903
1904
1905ALTER TABLE public.tags_tag_id_seq OWNER TO funkwhale;
1906
1907--
1908-- Name: tags_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1909--
1910
1911ALTER SEQUENCE public.tags_tag_id_seq OWNED BY public.tags_tag.id;
1912
1913
1914--
1915-- Name: tags_taggeditem; Type: TABLE; Schema: public; Owner: funkwhale
1916--
1917
1918CREATE TABLE public.tags_taggeditem (
1919    id integer NOT NULL,
1920    creation_date timestamp with time zone NOT NULL,
1921    object_id integer NOT NULL,
1922    content_type_id integer NOT NULL,
1923    tag_id integer NOT NULL
1924);
1925
1926
1927ALTER TABLE public.tags_taggeditem OWNER TO funkwhale;
1928
1929--
1930-- Name: tags_taggeditem_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1931--
1932
1933CREATE SEQUENCE public.tags_taggeditem_id_seq
1934    START WITH 1
1935    INCREMENT BY 1
1936    NO MINVALUE
1937    NO MAXVALUE
1938    CACHE 1;
1939
1940
1941ALTER TABLE public.tags_taggeditem_id_seq OWNER TO funkwhale;
1942
1943--
1944-- Name: tags_taggeditem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1945--
1946
1947ALTER SEQUENCE public.tags_taggeditem_id_seq OWNED BY public.tags_taggeditem.id;
1948
1949
1950--
1951-- Name: users_accesstoken; Type: TABLE; Schema: public; Owner: funkwhale
1952--
1953
1954CREATE TABLE public.users_accesstoken (
1955    id bigint NOT NULL,
1956    expires timestamp with time zone NOT NULL,
1957    scope text NOT NULL,
1958    created timestamp with time zone NOT NULL,
1959    updated timestamp with time zone NOT NULL,
1960    token character varying(255) NOT NULL,
1961    application_id bigint,
1962    source_refresh_token_id bigint,
1963    user_id integer
1964);
1965
1966
1967ALTER TABLE public.users_accesstoken OWNER TO funkwhale;
1968
1969--
1970-- Name: users_accesstoken_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
1971--
1972
1973CREATE SEQUENCE public.users_accesstoken_id_seq
1974    START WITH 1
1975    INCREMENT BY 1
1976    NO MINVALUE
1977    NO MAXVALUE
1978    CACHE 1;
1979
1980
1981ALTER TABLE public.users_accesstoken_id_seq OWNER TO funkwhale;
1982
1983--
1984-- Name: users_accesstoken_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
1985--
1986
1987ALTER SEQUENCE public.users_accesstoken_id_seq OWNED BY public.users_accesstoken.id;
1988
1989
1990--
1991-- Name: users_application; Type: TABLE; Schema: public; Owner: funkwhale
1992--
1993
1994CREATE TABLE public.users_application (
1995    id bigint NOT NULL,
1996    client_id character varying(100) NOT NULL,
1997    redirect_uris text NOT NULL,
1998    client_type character varying(32) NOT NULL,
1999    authorization_grant_type character varying(32) NOT NULL,
2000    client_secret character varying(255) NOT NULL,
2001    name character varying(255) NOT NULL,
2002    skip_authorization boolean NOT NULL,
2003    created timestamp with time zone NOT NULL,
2004    updated timestamp with time zone NOT NULL,
2005    user_id integer,
2006    scope text NOT NULL
2007);
2008
2009
2010ALTER TABLE public.users_application OWNER TO funkwhale;
2011
2012--
2013-- Name: users_application_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
2014--
2015
2016CREATE SEQUENCE public.users_application_id_seq
2017    START WITH 1
2018    INCREMENT BY 1
2019    NO MINVALUE
2020    NO MAXVALUE
2021    CACHE 1;
2022
2023
2024ALTER TABLE public.users_application_id_seq OWNER TO funkwhale;
2025
2026--
2027-- Name: users_application_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
2028--
2029
2030ALTER SEQUENCE public.users_application_id_seq OWNED BY public.users_application.id;
2031
2032
2033--
2034-- Name: users_grant; Type: TABLE; Schema: public; Owner: funkwhale
2035--
2036
2037CREATE TABLE public.users_grant (
2038    id bigint NOT NULL,
2039    code character varying(255) NOT NULL,
2040    expires timestamp with time zone NOT NULL,
2041    redirect_uri character varying(255) NOT NULL,
2042    scope text NOT NULL,
2043    created timestamp with time zone NOT NULL,
2044    updated timestamp with time zone NOT NULL,
2045    application_id bigint NOT NULL,
2046    user_id integer NOT NULL
2047);
2048
2049
2050ALTER TABLE public.users_grant OWNER TO funkwhale;
2051
2052--
2053-- Name: users_grant_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
2054--
2055
2056CREATE SEQUENCE public.users_grant_id_seq
2057    START WITH 1
2058    INCREMENT BY 1
2059    NO MINVALUE
2060    NO MAXVALUE
2061    CACHE 1;
2062
2063
2064ALTER TABLE public.users_grant_id_seq OWNER TO funkwhale;
2065
2066--
2067-- Name: users_grant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
2068--
2069
2070ALTER SEQUENCE public.users_grant_id_seq OWNED BY public.users_grant.id;
2071
2072
2073--
2074-- Name: users_invitation; Type: TABLE; Schema: public; Owner: funkwhale
2075--
2076
2077CREATE TABLE public.users_invitation (
2078    id integer NOT NULL,
2079    creation_date timestamp with time zone NOT NULL,
2080    expiration_date timestamp with time zone NOT NULL,
2081    code character varying(50) NOT NULL,
2082    owner_id integer NOT NULL
2083);
2084
2085
2086ALTER TABLE public.users_invitation OWNER TO funkwhale;
2087
2088--
2089-- Name: users_invitation_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
2090--
2091
2092CREATE SEQUENCE public.users_invitation_id_seq
2093    START WITH 1
2094    INCREMENT BY 1
2095    NO MINVALUE
2096    NO MAXVALUE
2097    CACHE 1;
2098
2099
2100ALTER TABLE public.users_invitation_id_seq OWNER TO funkwhale;
2101
2102--
2103-- Name: users_invitation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
2104--
2105
2106ALTER SEQUENCE public.users_invitation_id_seq OWNED BY public.users_invitation.id;
2107
2108
2109--
2110-- Name: users_refreshtoken; Type: TABLE; Schema: public; Owner: funkwhale
2111--
2112
2113CREATE TABLE public.users_refreshtoken (
2114    id bigint NOT NULL,
2115    token character varying(255) NOT NULL,
2116    created timestamp with time zone NOT NULL,
2117    updated timestamp with time zone NOT NULL,
2118    revoked timestamp with time zone,
2119    access_token_id bigint,
2120    application_id bigint NOT NULL,
2121    user_id integer NOT NULL
2122);
2123
2124
2125ALTER TABLE public.users_refreshtoken OWNER TO funkwhale;
2126
2127--
2128-- Name: users_refreshtoken_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
2129--
2130
2131CREATE SEQUENCE public.users_refreshtoken_id_seq
2132    START WITH 1
2133    INCREMENT BY 1
2134    NO MINVALUE
2135    NO MAXVALUE
2136    CACHE 1;
2137
2138
2139ALTER TABLE public.users_refreshtoken_id_seq OWNER TO funkwhale;
2140
2141--
2142-- Name: users_refreshtoken_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
2143--
2144
2145ALTER SEQUENCE public.users_refreshtoken_id_seq OWNED BY public.users_refreshtoken.id;
2146
2147
2148--
2149-- Name: users_user; Type: TABLE; Schema: public; Owner: funkwhale
2150--
2151
2152CREATE TABLE public.users_user (
2153    id integer NOT NULL,
2154    password character varying(128) NOT NULL,
2155    last_login timestamp with time zone,
2156    is_superuser boolean NOT NULL,
2157    username character varying(150) NOT NULL,
2158    first_name character varying(30) NOT NULL,
2159    last_name character varying(150) NOT NULL,
2160    email character varying(254) NOT NULL,
2161    is_staff boolean NOT NULL,
2162    is_active boolean NOT NULL,
2163    date_joined timestamp with time zone NOT NULL,
2164    name character varying(255) NOT NULL,
2165    secret_key uuid,
2166    privacy_level character varying(30) NOT NULL,
2167    subsonic_api_token character varying(255),
2168    permission_library boolean NOT NULL,
2169    permission_settings boolean NOT NULL,
2170    last_activity timestamp with time zone,
2171    invitation_id integer,
2172    avatar character varying(150),
2173    actor_id integer,
2174    upload_quota integer,
2175    permission_moderation boolean NOT NULL,
2176    CONSTRAINT users_user_upload_quota_check CHECK ((upload_quota >= 0))
2177);
2178
2179
2180ALTER TABLE public.users_user OWNER TO funkwhale;
2181
2182--
2183-- Name: users_user_groups; Type: TABLE; Schema: public; Owner: funkwhale
2184--
2185
2186CREATE TABLE public.users_user_groups (
2187    id integer NOT NULL,
2188    user_id integer NOT NULL,
2189    group_id integer NOT NULL
2190);
2191
2192
2193ALTER TABLE public.users_user_groups OWNER TO funkwhale;
2194
2195--
2196-- Name: users_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
2197--
2198
2199CREATE SEQUENCE public.users_user_groups_id_seq
2200    START WITH 1
2201    INCREMENT BY 1
2202    NO MINVALUE
2203    NO MAXVALUE
2204    CACHE 1;
2205
2206
2207ALTER TABLE public.users_user_groups_id_seq OWNER TO funkwhale;
2208
2209--
2210-- Name: users_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
2211--
2212
2213ALTER SEQUENCE public.users_user_groups_id_seq OWNED BY public.users_user_groups.id;
2214
2215
2216--
2217-- Name: users_user_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
2218--
2219
2220CREATE SEQUENCE public.users_user_id_seq
2221    START WITH 1
2222    INCREMENT BY 1
2223    NO MINVALUE
2224    NO MAXVALUE
2225    CACHE 1;
2226
2227
2228ALTER TABLE public.users_user_id_seq OWNER TO funkwhale;
2229
2230--
2231-- Name: users_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
2232--
2233
2234ALTER SEQUENCE public.users_user_id_seq OWNED BY public.users_user.id;
2235
2236
2237--
2238-- Name: users_user_user_permissions; Type: TABLE; Schema: public; Owner: funkwhale
2239--
2240
2241CREATE TABLE public.users_user_user_permissions (
2242    id integer NOT NULL,
2243    user_id integer NOT NULL,
2244    permission_id integer NOT NULL
2245);
2246
2247
2248ALTER TABLE public.users_user_user_permissions OWNER TO funkwhale;
2249
2250--
2251-- Name: users_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: funkwhale
2252--
2253
2254CREATE SEQUENCE public.users_user_user_permissions_id_seq
2255    START WITH 1
2256    INCREMENT BY 1
2257    NO MINVALUE
2258    NO MAXVALUE
2259    CACHE 1;
2260
2261
2262ALTER TABLE public.users_user_user_permissions_id_seq OWNER TO funkwhale;
2263
2264--
2265-- Name: users_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: funkwhale
2266--
2267
2268ALTER SEQUENCE public.users_user_user_permissions_id_seq OWNED BY public.users_user_user_permissions.id;
2269
2270
2271--
2272-- Name: account_emailaddress id; Type: DEFAULT; Schema: public; Owner: funkwhale
2273--
2274
2275ALTER TABLE ONLY public.account_emailaddress ALTER COLUMN id SET DEFAULT nextval('public.account_emailaddress_id_seq'::regclass);
2276
2277
2278--
2279-- Name: account_emailconfirmation id; Type: DEFAULT; Schema: public; Owner: funkwhale
2280--
2281
2282ALTER TABLE ONLY public.account_emailconfirmation ALTER COLUMN id SET DEFAULT nextval('public.account_emailconfirmation_id_seq'::regclass);
2283
2284
2285--
2286-- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: funkwhale
2287--
2288
2289ALTER TABLE ONLY public.auth_group ALTER COLUMN id SET DEFAULT nextval('public.auth_group_id_seq'::regclass);
2290
2291
2292--
2293-- Name: auth_group_permissions id; Type: DEFAULT; Schema: public; Owner: funkwhale
2294--
2295
2296ALTER TABLE ONLY public.auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('public.auth_group_permissions_id_seq'::regclass);
2297
2298
2299--
2300-- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: funkwhale
2301--
2302
2303ALTER TABLE ONLY public.auth_permission ALTER COLUMN id SET DEFAULT nextval('public.auth_permission_id_seq'::regclass);
2304
2305
2306--
2307-- Name: common_mutation id; Type: DEFAULT; Schema: public; Owner: funkwhale
2308--
2309
2310ALTER TABLE ONLY public.common_mutation ALTER COLUMN id SET DEFAULT nextval('public.common_mutation_id_seq'::regclass);
2311
2312
2313--
2314-- Name: django_admin_log id; Type: DEFAULT; Schema: public; Owner: funkwhale
2315--
2316
2317ALTER TABLE ONLY public.django_admin_log ALTER COLUMN id SET DEFAULT nextval('public.django_admin_log_id_seq'::regclass);
2318
2319
2320--
2321-- Name: django_content_type id; Type: DEFAULT; Schema: public; Owner: funkwhale
2322--
2323
2324ALTER TABLE ONLY public.django_content_type ALTER COLUMN id SET DEFAULT nextval('public.django_content_type_id_seq'::regclass);
2325
2326
2327--
2328-- Name: django_migrations id; Type: DEFAULT; Schema: public; Owner: funkwhale
2329--
2330
2331ALTER TABLE ONLY public.django_migrations ALTER COLUMN id SET DEFAULT nextval('public.django_migrations_id_seq'::regclass);
2332
2333
2334--
2335-- Name: django_site id; Type: DEFAULT; Schema: public; Owner: funkwhale
2336--
2337
2338ALTER TABLE ONLY public.django_site ALTER COLUMN id SET DEFAULT nextval('public.django_site_id_seq'::regclass);
2339
2340
2341--
2342-- Name: dynamic_preferences_globalpreferencemodel id; Type: DEFAULT; Schema: public; Owner: funkwhale
2343--
2344
2345ALTER TABLE ONLY public.dynamic_preferences_globalpreferencemodel ALTER COLUMN id SET DEFAULT nextval('public.dynamic_preferences_globalpreferencemodel_id_seq'::regclass);
2346
2347
2348--
2349-- Name: favorites_trackfavorite id; Type: DEFAULT; Schema: public; Owner: funkwhale
2350--
2351
2352ALTER TABLE ONLY public.favorites_trackfavorite ALTER COLUMN id SET DEFAULT nextval('public.favorites_trackfavorite_id_seq'::regclass);
2353
2354
2355--
2356-- Name: federation_activity id; Type: DEFAULT; Schema: public; Owner: funkwhale
2357--
2358
2359ALTER TABLE ONLY public.federation_activity ALTER COLUMN id SET DEFAULT nextval('public.federation_activity_id_seq'::regclass);
2360
2361
2362--
2363-- Name: federation_actor id; Type: DEFAULT; Schema: public; Owner: funkwhale
2364--
2365
2366ALTER TABLE ONLY public.federation_actor ALTER COLUMN id SET DEFAULT nextval('public.federation_actor_id_seq'::regclass);
2367
2368
2369--
2370-- Name: federation_delivery id; Type: DEFAULT; Schema: public; Owner: funkwhale
2371--
2372
2373ALTER TABLE ONLY public.federation_delivery ALTER COLUMN id SET DEFAULT nextval('public.federation_delivery_id_seq'::regclass);
2374
2375
2376--
2377-- Name: federation_fetch id; Type: DEFAULT; Schema: public; Owner: funkwhale
2378--
2379
2380ALTER TABLE ONLY public.federation_fetch ALTER COLUMN id SET DEFAULT nextval('public.federation_fetch_id_seq'::regclass);
2381
2382
2383--
2384-- Name: federation_follow id; Type: DEFAULT; Schema: public; Owner: funkwhale
2385--
2386
2387ALTER TABLE ONLY public.federation_follow ALTER COLUMN id SET DEFAULT nextval('public.federation_follow_id_seq'::regclass);
2388
2389
2390--
2391-- Name: federation_inboxitem id; Type: DEFAULT; Schema: public; Owner: funkwhale
2392--
2393
2394ALTER TABLE ONLY public.federation_inboxitem ALTER COLUMN id SET DEFAULT nextval('public.federation_inboxitem_id_seq'::regclass);
2395
2396
2397--
2398-- Name: federation_library id; Type: DEFAULT; Schema: public; Owner: funkwhale
2399--
2400
2401ALTER TABLE ONLY public.federation_library ALTER COLUMN id SET DEFAULT nextval('public.federation_library_id_seq'::regclass);
2402
2403
2404--
2405-- Name: federation_libraryfollow id; Type: DEFAULT; Schema: public; Owner: funkwhale
2406--
2407
2408ALTER TABLE ONLY public.federation_libraryfollow ALTER COLUMN id SET DEFAULT nextval('public.federation_libraryfollow_id_seq'::regclass);
2409
2410
2411--
2412-- Name: federation_librarytrack id; Type: DEFAULT; Schema: public; Owner: funkwhale
2413--
2414
2415ALTER TABLE ONLY public.federation_librarytrack ALTER COLUMN id SET DEFAULT nextval('public.federation_librarytrack_id_seq'::regclass);
2416
2417
2418--
2419-- Name: history_listening id; Type: DEFAULT; Schema: public; Owner: funkwhale
2420--
2421
2422ALTER TABLE ONLY public.history_listening ALTER COLUMN id SET DEFAULT nextval('public.history_listening_id_seq'::regclass);
2423
2424
2425--
2426-- Name: moderation_instancepolicy id; Type: DEFAULT; Schema: public; Owner: funkwhale
2427--
2428
2429ALTER TABLE ONLY public.moderation_instancepolicy ALTER COLUMN id SET DEFAULT nextval('public.moderation_instancepolicy_id_seq'::regclass);
2430
2431
2432--
2433-- Name: moderation_userfilter id; Type: DEFAULT; Schema: public; Owner: funkwhale
2434--
2435
2436ALTER TABLE ONLY public.moderation_userfilter ALTER COLUMN id SET DEFAULT nextval('public.moderation_userfilter_id_seq'::regclass);
2437
2438
2439--
2440-- Name: music_album id; Type: DEFAULT; Schema: public; Owner: funkwhale
2441--
2442
2443ALTER TABLE ONLY public.music_album ALTER COLUMN id SET DEFAULT nextval('public.music_album_id_seq'::regclass);
2444
2445
2446--
2447-- Name: music_artist id; Type: DEFAULT; Schema: public; Owner: funkwhale
2448--
2449
2450ALTER TABLE ONLY public.music_artist ALTER COLUMN id SET DEFAULT nextval('public.music_artist_id_seq'::regclass);
2451
2452
2453--
2454-- Name: music_importbatch id; Type: DEFAULT; Schema: public; Owner: funkwhale
2455--
2456
2457ALTER TABLE ONLY public.music_importbatch ALTER COLUMN id SET DEFAULT nextval('public.music_importbatch_id_seq'::regclass);
2458
2459
2460--
2461-- Name: music_importjob id; Type: DEFAULT; Schema: public; Owner: funkwhale
2462--
2463
2464ALTER TABLE ONLY public.music_importjob ALTER COLUMN id SET DEFAULT nextval('public.music_importjob_id_seq'::regclass);
2465
2466
2467--
2468-- Name: music_library id; Type: DEFAULT; Schema: public; Owner: funkwhale
2469--
2470
2471ALTER TABLE ONLY public.music_library ALTER COLUMN id SET DEFAULT nextval('public.music_library_id_seq'::regclass);
2472
2473
2474--
2475-- Name: music_libraryscan id; Type: DEFAULT; Schema: public; Owner: funkwhale
2476--
2477
2478ALTER TABLE ONLY public.music_libraryscan ALTER COLUMN id SET DEFAULT nextval('public.music_libraryscan_id_seq'::regclass);
2479
2480
2481--
2482-- Name: music_track id; Type: DEFAULT; Schema: public; Owner: funkwhale
2483--
2484
2485ALTER TABLE ONLY public.music_track ALTER COLUMN id SET DEFAULT nextval('public.music_track_id_seq'::regclass);
2486
2487
2488--
2489-- Name: music_upload id; Type: DEFAULT; Schema: public; Owner: funkwhale
2490--
2491
2492ALTER TABLE ONLY public.music_upload ALTER COLUMN id SET DEFAULT nextval('public.music_trackfile_id_seq'::regclass);
2493
2494
2495--
2496-- Name: music_uploadversion id; Type: DEFAULT; Schema: public; Owner: funkwhale
2497--
2498
2499ALTER TABLE ONLY public.music_uploadversion ALTER COLUMN id SET DEFAULT nextval('public.music_uploadversion_id_seq'::regclass);
2500
2501
2502--
2503-- Name: playlists_playlist id; Type: DEFAULT; Schema: public; Owner: funkwhale
2504--
2505
2506ALTER TABLE ONLY public.playlists_playlist ALTER COLUMN id SET DEFAULT nextval('public.playlists_playlist_id_seq'::regclass);
2507
2508
2509--
2510-- Name: playlists_playlisttrack id; Type: DEFAULT; Schema: public; Owner: funkwhale
2511--
2512
2513ALTER TABLE ONLY public.playlists_playlisttrack ALTER COLUMN id SET DEFAULT nextval('public.playlists_playlisttrack_id_seq'::regclass);
2514
2515
2516--
2517-- Name: radios_radio id; Type: DEFAULT; Schema: public; Owner: funkwhale
2518--
2519
2520ALTER TABLE ONLY public.radios_radio ALTER COLUMN id SET DEFAULT nextval('public.radios_radio_id_seq'::regclass);
2521
2522
2523--
2524-- Name: radios_radiosession id; Type: DEFAULT; Schema: public; Owner: funkwhale
2525--
2526
2527ALTER TABLE ONLY public.radios_radiosession ALTER COLUMN id SET DEFAULT nextval('public.radios_radiosession_id_seq'::regclass);
2528
2529
2530--
2531-- Name: radios_radiosessiontrack id; Type: DEFAULT; Schema: public; Owner: funkwhale
2532--
2533
2534ALTER TABLE ONLY public.radios_radiosessiontrack ALTER COLUMN id SET DEFAULT nextval('public.radios_radiosessiontrack_id_seq'::regclass);
2535
2536
2537--
2538-- Name: requests_importrequest id; Type: DEFAULT; Schema: public; Owner: funkwhale
2539--
2540
2541ALTER TABLE ONLY public.requests_importrequest ALTER COLUMN id SET DEFAULT nextval('public.requests_importrequest_id_seq'::regclass);
2542
2543
2544--
2545-- Name: socialaccount_socialaccount id; Type: DEFAULT; Schema: public; Owner: funkwhale
2546--
2547
2548ALTER TABLE ONLY public.socialaccount_socialaccount ALTER COLUMN id SET DEFAULT nextval('public.socialaccount_socialaccount_id_seq'::regclass);
2549
2550
2551--
2552-- Name: socialaccount_socialapp id; Type: DEFAULT; Schema: public; Owner: funkwhale
2553--
2554
2555ALTER TABLE ONLY public.socialaccount_socialapp ALTER COLUMN id SET DEFAULT nextval('public.socialaccount_socialapp_id_seq'::regclass);
2556
2557
2558--
2559-- Name: socialaccount_socialapp_sites id; Type: DEFAULT; Schema: public; Owner: funkwhale
2560--
2561
2562ALTER TABLE ONLY public.socialaccount_socialapp_sites ALTER COLUMN id SET DEFAULT nextval('public.socialaccount_socialapp_sites_id_seq'::regclass);
2563
2564
2565--
2566-- Name: socialaccount_socialtoken id; Type: DEFAULT; Schema: public; Owner: funkwhale
2567--
2568
2569ALTER TABLE ONLY public.socialaccount_socialtoken ALTER COLUMN id SET DEFAULT nextval('public.socialaccount_socialtoken_id_seq'::regclass);
2570
2571
2572--
2573-- Name: taggit_tag id; Type: DEFAULT; Schema: public; Owner: funkwhale
2574--
2575
2576ALTER TABLE ONLY public.taggit_tag ALTER COLUMN id SET DEFAULT nextval('public.taggit_tag_id_seq'::regclass);
2577
2578
2579--
2580-- Name: taggit_taggeditem id; Type: DEFAULT; Schema: public; Owner: funkwhale
2581--
2582
2583ALTER TABLE ONLY public.taggit_taggeditem ALTER COLUMN id SET DEFAULT nextval('public.taggit_taggeditem_id_seq'::regclass);
2584
2585
2586--
2587-- Name: tags_tag id; Type: DEFAULT; Schema: public; Owner: funkwhale
2588--
2589
2590ALTER TABLE ONLY public.tags_tag ALTER COLUMN id SET DEFAULT nextval('public.tags_tag_id_seq'::regclass);
2591
2592
2593--
2594-- Name: tags_taggeditem id; Type: DEFAULT; Schema: public; Owner: funkwhale
2595--
2596
2597ALTER TABLE ONLY public.tags_taggeditem ALTER COLUMN id SET DEFAULT nextval('public.tags_taggeditem_id_seq'::regclass);
2598
2599
2600--
2601-- Name: users_accesstoken id; Type: DEFAULT; Schema: public; Owner: funkwhale
2602--
2603
2604ALTER TABLE ONLY public.users_accesstoken ALTER COLUMN id SET DEFAULT nextval('public.users_accesstoken_id_seq'::regclass);
2605
2606
2607--
2608-- Name: users_application id; Type: DEFAULT; Schema: public; Owner: funkwhale
2609--
2610
2611ALTER TABLE ONLY public.users_application ALTER COLUMN id SET DEFAULT nextval('public.users_application_id_seq'::regclass);
2612
2613
2614--
2615-- Name: users_grant id; Type: DEFAULT; Schema: public; Owner: funkwhale
2616--
2617
2618ALTER TABLE ONLY public.users_grant ALTER COLUMN id SET DEFAULT nextval('public.users_grant_id_seq'::regclass);
2619
2620
2621--
2622-- Name: users_invitation id; Type: DEFAULT; Schema: public; Owner: funkwhale
2623--
2624
2625ALTER TABLE ONLY public.users_invitation ALTER COLUMN id SET DEFAULT nextval('public.users_invitation_id_seq'::regclass);
2626
2627
2628--
2629-- Name: users_refreshtoken id; Type: DEFAULT; Schema: public; Owner: funkwhale
2630--
2631
2632ALTER TABLE ONLY public.users_refreshtoken ALTER COLUMN id SET DEFAULT nextval('public.users_refreshtoken_id_seq'::regclass);
2633
2634
2635--
2636-- Name: users_user id; Type: DEFAULT; Schema: public; Owner: funkwhale
2637--
2638
2639ALTER TABLE ONLY public.users_user ALTER COLUMN id SET DEFAULT nextval('public.users_user_id_seq'::regclass);
2640
2641
2642--
2643-- Name: users_user_groups id; Type: DEFAULT; Schema: public; Owner: funkwhale
2644--
2645
2646ALTER TABLE ONLY public.users_user_groups ALTER COLUMN id SET DEFAULT nextval('public.users_user_groups_id_seq'::regclass);
2647
2648
2649--
2650-- Name: users_user_user_permissions id; Type: DEFAULT; Schema: public; Owner: funkwhale
2651--
2652
2653ALTER TABLE ONLY public.users_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('public.users_user_user_permissions_id_seq'::regclass);
2654
2655
2656--
2657-- Name: account_emailaddress account_emailaddress_email_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2658--
2659
2660ALTER TABLE ONLY public.account_emailaddress
2661    ADD CONSTRAINT account_emailaddress_email_key UNIQUE (email);
2662
2663
2664--
2665-- Name: account_emailaddress account_emailaddress_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2666--
2667
2668ALTER TABLE ONLY public.account_emailaddress
2669    ADD CONSTRAINT account_emailaddress_pkey PRIMARY KEY (id);
2670
2671
2672--
2673-- Name: account_emailconfirmation account_emailconfirmation_key_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2674--
2675
2676ALTER TABLE ONLY public.account_emailconfirmation
2677    ADD CONSTRAINT account_emailconfirmation_key_key UNIQUE (key);
2678
2679
2680--
2681-- Name: account_emailconfirmation account_emailconfirmation_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2682--
2683
2684ALTER TABLE ONLY public.account_emailconfirmation
2685    ADD CONSTRAINT account_emailconfirmation_pkey PRIMARY KEY (id);
2686
2687
2688--
2689-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2690--
2691
2692ALTER TABLE ONLY public.auth_group
2693    ADD CONSTRAINT auth_group_name_key UNIQUE (name);
2694
2695
2696--
2697-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2698--
2699
2700ALTER TABLE ONLY public.auth_group_permissions
2701    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);
2702
2703
2704--
2705-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2706--
2707
2708ALTER TABLE ONLY public.auth_group_permissions
2709    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);
2710
2711
2712--
2713-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2714--
2715
2716ALTER TABLE ONLY public.auth_group
2717    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);
2718
2719
2720--
2721-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2722--
2723
2724ALTER TABLE ONLY public.auth_permission
2725    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);
2726
2727
2728--
2729-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2730--
2731
2732ALTER TABLE ONLY public.auth_permission
2733    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);
2734
2735
2736--
2737-- Name: authtoken_token authtoken_token_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2738--
2739
2740ALTER TABLE ONLY public.authtoken_token
2741    ADD CONSTRAINT authtoken_token_pkey PRIMARY KEY (key);
2742
2743
2744--
2745-- Name: authtoken_token authtoken_token_user_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2746--
2747
2748ALTER TABLE ONLY public.authtoken_token
2749    ADD CONSTRAINT authtoken_token_user_id_key UNIQUE (user_id);
2750
2751
2752--
2753-- Name: common_mutation common_mutation_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2754--
2755
2756ALTER TABLE ONLY public.common_mutation
2757    ADD CONSTRAINT common_mutation_fid_key UNIQUE (fid);
2758
2759
2760--
2761-- Name: common_mutation common_mutation_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2762--
2763
2764ALTER TABLE ONLY public.common_mutation
2765    ADD CONSTRAINT common_mutation_pkey PRIMARY KEY (id);
2766
2767
2768--
2769-- Name: common_mutation common_mutation_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2770--
2771
2772ALTER TABLE ONLY public.common_mutation
2773    ADD CONSTRAINT common_mutation_uuid_key UNIQUE (uuid);
2774
2775
2776--
2777-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2778--
2779
2780ALTER TABLE ONLY public.django_admin_log
2781    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);
2782
2783
2784--
2785-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2786--
2787
2788ALTER TABLE ONLY public.django_content_type
2789    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);
2790
2791
2792--
2793-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2794--
2795
2796ALTER TABLE ONLY public.django_content_type
2797    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);
2798
2799
2800--
2801-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2802--
2803
2804ALTER TABLE ONLY public.django_migrations
2805    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);
2806
2807
2808--
2809-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2810--
2811
2812ALTER TABLE ONLY public.django_session
2813    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);
2814
2815
2816--
2817-- Name: django_site django_site_domain_a2e37b91_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2818--
2819
2820ALTER TABLE ONLY public.django_site
2821    ADD CONSTRAINT django_site_domain_a2e37b91_uniq UNIQUE (domain);
2822
2823
2824--
2825-- Name: django_site django_site_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2826--
2827
2828ALTER TABLE ONLY public.django_site
2829    ADD CONSTRAINT django_site_pkey PRIMARY KEY (id);
2830
2831
2832--
2833-- Name: dynamic_preferences_globalpreferencemodel dynamic_preferences_glob_section_name_f4a2439b_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2834--
2835
2836ALTER TABLE ONLY public.dynamic_preferences_globalpreferencemodel
2837    ADD CONSTRAINT dynamic_preferences_glob_section_name_f4a2439b_uniq UNIQUE (section, name);
2838
2839
2840--
2841-- Name: dynamic_preferences_globalpreferencemodel dynamic_preferences_globalpreferencemodel_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2842--
2843
2844ALTER TABLE ONLY public.dynamic_preferences_globalpreferencemodel
2845    ADD CONSTRAINT dynamic_preferences_globalpreferencemodel_pkey PRIMARY KEY (id);
2846
2847
2848--
2849-- Name: favorites_trackfavorite favorites_trackfavorite_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2850--
2851
2852ALTER TABLE ONLY public.favorites_trackfavorite
2853    ADD CONSTRAINT favorites_trackfavorite_pkey PRIMARY KEY (id);
2854
2855
2856--
2857-- Name: favorites_trackfavorite favorites_trackfavorite_track_id_user_id_8870c46b_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2858--
2859
2860ALTER TABLE ONLY public.favorites_trackfavorite
2861    ADD CONSTRAINT favorites_trackfavorite_track_id_user_id_8870c46b_uniq UNIQUE (track_id, user_id);
2862
2863
2864--
2865-- Name: federation_activity federation_activity_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2866--
2867
2868ALTER TABLE ONLY public.federation_activity
2869    ADD CONSTRAINT federation_activity_fid_key UNIQUE (fid);
2870
2871
2872--
2873-- Name: federation_activity federation_activity_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2874--
2875
2876ALTER TABLE ONLY public.federation_activity
2877    ADD CONSTRAINT federation_activity_pkey PRIMARY KEY (id);
2878
2879
2880--
2881-- Name: federation_activity federation_activity_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2882--
2883
2884ALTER TABLE ONLY public.federation_activity
2885    ADD CONSTRAINT federation_activity_uuid_key UNIQUE (uuid);
2886
2887
2888--
2889-- Name: federation_actor federation_actor_domain_id_preferred_username_6c81d6d2_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2890--
2891
2892ALTER TABLE ONLY public.federation_actor
2893    ADD CONSTRAINT federation_actor_domain_id_preferred_username_6c81d6d2_uniq UNIQUE (domain_id, preferred_username);
2894
2895
2896--
2897-- Name: federation_actor federation_actor_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2898--
2899
2900ALTER TABLE ONLY public.federation_actor
2901    ADD CONSTRAINT federation_actor_pkey PRIMARY KEY (id);
2902
2903
2904--
2905-- Name: federation_actor federation_actor_url_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2906--
2907
2908ALTER TABLE ONLY public.federation_actor
2909    ADD CONSTRAINT federation_actor_url_key UNIQUE (fid);
2910
2911
2912--
2913-- Name: federation_delivery federation_delivery_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2914--
2915
2916ALTER TABLE ONLY public.federation_delivery
2917    ADD CONSTRAINT federation_delivery_pkey PRIMARY KEY (id);
2918
2919
2920--
2921-- Name: federation_domain federation_domain_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2922--
2923
2924ALTER TABLE ONLY public.federation_domain
2925    ADD CONSTRAINT federation_domain_pkey PRIMARY KEY (name);
2926
2927
2928--
2929-- Name: federation_fetch federation_fetch_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2930--
2931
2932ALTER TABLE ONLY public.federation_fetch
2933    ADD CONSTRAINT federation_fetch_pkey PRIMARY KEY (id);
2934
2935
2936--
2937-- Name: federation_follow federation_follow_actor_id_target_id_280dde37_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2938--
2939
2940ALTER TABLE ONLY public.federation_follow
2941    ADD CONSTRAINT federation_follow_actor_id_target_id_280dde37_uniq UNIQUE (actor_id, target_id);
2942
2943
2944--
2945-- Name: federation_follow federation_follow_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2946--
2947
2948ALTER TABLE ONLY public.federation_follow
2949    ADD CONSTRAINT federation_follow_fid_key UNIQUE (fid);
2950
2951
2952--
2953-- Name: federation_follow federation_follow_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2954--
2955
2956ALTER TABLE ONLY public.federation_follow
2957    ADD CONSTRAINT federation_follow_pkey PRIMARY KEY (id);
2958
2959
2960--
2961-- Name: federation_follow federation_follow_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2962--
2963
2964ALTER TABLE ONLY public.federation_follow
2965    ADD CONSTRAINT federation_follow_uuid_key UNIQUE (uuid);
2966
2967
2968--
2969-- Name: federation_inboxitem federation_inboxitem_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2970--
2971
2972ALTER TABLE ONLY public.federation_inboxitem
2973    ADD CONSTRAINT federation_inboxitem_pkey PRIMARY KEY (id);
2974
2975
2976--
2977-- Name: federation_library federation_library_actor_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2978--
2979
2980ALTER TABLE ONLY public.federation_library
2981    ADD CONSTRAINT federation_library_actor_id_key UNIQUE (actor_id);
2982
2983
2984--
2985-- Name: federation_library federation_library_follow_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2986--
2987
2988ALTER TABLE ONLY public.federation_library
2989    ADD CONSTRAINT federation_library_follow_id_key UNIQUE (follow_id);
2990
2991
2992--
2993-- Name: federation_library federation_library_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
2994--
2995
2996ALTER TABLE ONLY public.federation_library
2997    ADD CONSTRAINT federation_library_pkey PRIMARY KEY (id);
2998
2999
3000--
3001-- Name: federation_libraryfollow federation_libraryfollow_actor_id_target_id_4d6935c3_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3002--
3003
3004ALTER TABLE ONLY public.federation_libraryfollow
3005    ADD CONSTRAINT federation_libraryfollow_actor_id_target_id_4d6935c3_uniq UNIQUE (actor_id, target_id);
3006
3007
3008--
3009-- Name: federation_libraryfollow federation_libraryfollow_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3010--
3011
3012ALTER TABLE ONLY public.federation_libraryfollow
3013    ADD CONSTRAINT federation_libraryfollow_fid_key UNIQUE (fid);
3014
3015
3016--
3017-- Name: federation_libraryfollow federation_libraryfollow_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3018--
3019
3020ALTER TABLE ONLY public.federation_libraryfollow
3021    ADD CONSTRAINT federation_libraryfollow_pkey PRIMARY KEY (id);
3022
3023
3024--
3025-- Name: federation_libraryfollow federation_libraryfollow_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3026--
3027
3028ALTER TABLE ONLY public.federation_libraryfollow
3029    ADD CONSTRAINT federation_libraryfollow_uuid_key UNIQUE (uuid);
3030
3031
3032--
3033-- Name: federation_librarytrack federation_librarytrack_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3034--
3035
3036ALTER TABLE ONLY public.federation_librarytrack
3037    ADD CONSTRAINT federation_librarytrack_pkey PRIMARY KEY (id);
3038
3039
3040--
3041-- Name: federation_librarytrack federation_librarytrack_url_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3042--
3043
3044ALTER TABLE ONLY public.federation_librarytrack
3045    ADD CONSTRAINT federation_librarytrack_url_key UNIQUE (url);
3046
3047
3048--
3049-- Name: history_listening history_listening_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3050--
3051
3052ALTER TABLE ONLY public.history_listening
3053    ADD CONSTRAINT history_listening_pkey PRIMARY KEY (id);
3054
3055
3056--
3057-- Name: moderation_instancepolicy moderation_instancepolicy_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3058--
3059
3060ALTER TABLE ONLY public.moderation_instancepolicy
3061    ADD CONSTRAINT moderation_instancepolicy_pkey PRIMARY KEY (id);
3062
3063
3064--
3065-- Name: moderation_instancepolicy moderation_instancepolicy_target_actor_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3066--
3067
3068ALTER TABLE ONLY public.moderation_instancepolicy
3069    ADD CONSTRAINT moderation_instancepolicy_target_actor_id_key UNIQUE (target_actor_id);
3070
3071
3072--
3073-- Name: moderation_instancepolicy moderation_instancepolicy_target_domain_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3074--
3075
3076ALTER TABLE ONLY public.moderation_instancepolicy
3077    ADD CONSTRAINT moderation_instancepolicy_target_domain_id_key UNIQUE (target_domain_id);
3078
3079
3080--
3081-- Name: moderation_instancepolicy moderation_instancepolicy_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3082--
3083
3084ALTER TABLE ONLY public.moderation_instancepolicy
3085    ADD CONSTRAINT moderation_instancepolicy_uuid_key UNIQUE (uuid);
3086
3087
3088--
3089-- Name: moderation_userfilter moderation_userfilter_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3090--
3091
3092ALTER TABLE ONLY public.moderation_userfilter
3093    ADD CONSTRAINT moderation_userfilter_pkey PRIMARY KEY (id);
3094
3095
3096--
3097-- Name: moderation_userfilter moderation_userfilter_user_id_target_artist_id_d00f35ca_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3098--
3099
3100ALTER TABLE ONLY public.moderation_userfilter
3101    ADD CONSTRAINT moderation_userfilter_user_id_target_artist_id_d00f35ca_uniq UNIQUE (user_id, target_artist_id);
3102
3103
3104--
3105-- Name: moderation_userfilter moderation_userfilter_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3106--
3107
3108ALTER TABLE ONLY public.moderation_userfilter
3109    ADD CONSTRAINT moderation_userfilter_uuid_key UNIQUE (uuid);
3110
3111
3112--
3113-- Name: music_album music_album_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3114--
3115
3116ALTER TABLE ONLY public.music_album
3117    ADD CONSTRAINT music_album_fid_key UNIQUE (fid);
3118
3119
3120--
3121-- Name: music_album music_album_mbid_b09e59fe_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3122--
3123
3124ALTER TABLE ONLY public.music_album
3125    ADD CONSTRAINT music_album_mbid_b09e59fe_uniq UNIQUE (mbid);
3126
3127
3128--
3129-- Name: music_album music_album_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3130--
3131
3132ALTER TABLE ONLY public.music_album
3133    ADD CONSTRAINT music_album_pkey PRIMARY KEY (id);
3134
3135
3136--
3137-- Name: music_album music_album_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3138--
3139
3140ALTER TABLE ONLY public.music_album
3141    ADD CONSTRAINT music_album_uuid_key UNIQUE (uuid);
3142
3143
3144--
3145-- Name: music_artist music_artist_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3146--
3147
3148ALTER TABLE ONLY public.music_artist
3149    ADD CONSTRAINT music_artist_fid_key UNIQUE (fid);
3150
3151
3152--
3153-- Name: music_artist music_artist_mbid_0b814e0b_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3154--
3155
3156ALTER TABLE ONLY public.music_artist
3157    ADD CONSTRAINT music_artist_mbid_0b814e0b_uniq UNIQUE (mbid);
3158
3159
3160--
3161-- Name: music_artist music_artist_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3162--
3163
3164ALTER TABLE ONLY public.music_artist
3165    ADD CONSTRAINT music_artist_pkey PRIMARY KEY (id);
3166
3167
3168--
3169-- Name: music_artist music_artist_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3170--
3171
3172ALTER TABLE ONLY public.music_artist
3173    ADD CONSTRAINT music_artist_uuid_key UNIQUE (uuid);
3174
3175
3176--
3177-- Name: music_importbatch music_importbatch_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3178--
3179
3180ALTER TABLE ONLY public.music_importbatch
3181    ADD CONSTRAINT music_importbatch_pkey PRIMARY KEY (id);
3182
3183
3184--
3185-- Name: music_importbatch music_importbatch_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3186--
3187
3188ALTER TABLE ONLY public.music_importbatch
3189    ADD CONSTRAINT music_importbatch_uuid_key UNIQUE (uuid);
3190
3191
3192--
3193-- Name: music_importjob music_importjob_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3194--
3195
3196ALTER TABLE ONLY public.music_importjob
3197    ADD CONSTRAINT music_importjob_pkey PRIMARY KEY (id);
3198
3199
3200--
3201-- Name: music_importjob music_importjob_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3202--
3203
3204ALTER TABLE ONLY public.music_importjob
3205    ADD CONSTRAINT music_importjob_uuid_key UNIQUE (uuid);
3206
3207
3208--
3209-- Name: music_library music_library_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3210--
3211
3212ALTER TABLE ONLY public.music_library
3213    ADD CONSTRAINT music_library_fid_key UNIQUE (fid);
3214
3215
3216--
3217-- Name: music_library music_library_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3218--
3219
3220ALTER TABLE ONLY public.music_library
3221    ADD CONSTRAINT music_library_pkey PRIMARY KEY (id);
3222
3223
3224--
3225-- Name: music_library music_library_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3226--
3227
3228ALTER TABLE ONLY public.music_library
3229    ADD CONSTRAINT music_library_uuid_key UNIQUE (uuid);
3230
3231
3232--
3233-- Name: music_libraryscan music_libraryscan_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3234--
3235
3236ALTER TABLE ONLY public.music_libraryscan
3237    ADD CONSTRAINT music_libraryscan_pkey PRIMARY KEY (id);
3238
3239
3240--
3241-- Name: music_license music_license_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3242--
3243
3244ALTER TABLE ONLY public.music_license
3245    ADD CONSTRAINT music_license_pkey PRIMARY KEY (code);
3246
3247
3248--
3249-- Name: music_track music_track_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3250--
3251
3252ALTER TABLE ONLY public.music_track
3253    ADD CONSTRAINT music_track_fid_key UNIQUE (fid);
3254
3255
3256--
3257-- Name: music_track music_track_mbid_30675995_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3258--
3259
3260ALTER TABLE ONLY public.music_track
3261    ADD CONSTRAINT music_track_mbid_30675995_uniq UNIQUE (mbid);
3262
3263
3264--
3265-- Name: music_track music_track_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3266--
3267
3268ALTER TABLE ONLY public.music_track
3269    ADD CONSTRAINT music_track_pkey PRIMARY KEY (id);
3270
3271
3272--
3273-- Name: music_track music_track_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3274--
3275
3276ALTER TABLE ONLY public.music_track
3277    ADD CONSTRAINT music_track_uuid_key UNIQUE (uuid);
3278
3279
3280--
3281-- Name: music_upload music_trackfile_fid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3282--
3283
3284ALTER TABLE ONLY public.music_upload
3285    ADD CONSTRAINT music_trackfile_fid_key UNIQUE (fid);
3286
3287
3288--
3289-- Name: music_upload music_trackfile_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3290--
3291
3292ALTER TABLE ONLY public.music_upload
3293    ADD CONSTRAINT music_trackfile_pkey PRIMARY KEY (id);
3294
3295
3296--
3297-- Name: music_upload music_trackfile_uuid_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3298--
3299
3300ALTER TABLE ONLY public.music_upload
3301    ADD CONSTRAINT music_trackfile_uuid_key UNIQUE (uuid);
3302
3303
3304--
3305-- Name: music_uploadversion music_uploadversion_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3306--
3307
3308ALTER TABLE ONLY public.music_uploadversion
3309    ADD CONSTRAINT music_uploadversion_pkey PRIMARY KEY (id);
3310
3311
3312--
3313-- Name: music_uploadversion music_uploadversion_upload_id_mimetype_bitrate_3424f32c_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3314--
3315
3316ALTER TABLE ONLY public.music_uploadversion
3317    ADD CONSTRAINT music_uploadversion_upload_id_mimetype_bitrate_3424f32c_uniq UNIQUE (upload_id, mimetype, bitrate);
3318
3319
3320--
3321-- Name: playlists_playlist playlists_playlist_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3322--
3323
3324ALTER TABLE ONLY public.playlists_playlist
3325    ADD CONSTRAINT playlists_playlist_pkey PRIMARY KEY (id);
3326
3327
3328--
3329-- Name: playlists_playlisttrack playlists_playlisttrack_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3330--
3331
3332ALTER TABLE ONLY public.playlists_playlisttrack
3333    ADD CONSTRAINT playlists_playlisttrack_pkey PRIMARY KEY (id);
3334
3335
3336--
3337-- Name: radios_radio radios_radio_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3338--
3339
3340ALTER TABLE ONLY public.radios_radio
3341    ADD CONSTRAINT radios_radio_pkey PRIMARY KEY (id);
3342
3343
3344--
3345-- Name: radios_radiosession radios_radiosession_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3346--
3347
3348ALTER TABLE ONLY public.radios_radiosession
3349    ADD CONSTRAINT radios_radiosession_pkey PRIMARY KEY (id);
3350
3351
3352--
3353-- Name: radios_radiosessiontrack radios_radiosessiontrack_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3354--
3355
3356ALTER TABLE ONLY public.radios_radiosessiontrack
3357    ADD CONSTRAINT radios_radiosessiontrack_pkey PRIMARY KEY (id);
3358
3359
3360--
3361-- Name: radios_radiosessiontrack radios_radiosessiontrack_session_id_position_3f16c2ac_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3362--
3363
3364ALTER TABLE ONLY public.radios_radiosessiontrack
3365    ADD CONSTRAINT radios_radiosessiontrack_session_id_position_3f16c2ac_uniq UNIQUE (session_id, "position");
3366
3367
3368--
3369-- Name: requests_importrequest requests_importrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3370--
3371
3372ALTER TABLE ONLY public.requests_importrequest
3373    ADD CONSTRAINT requests_importrequest_pkey PRIMARY KEY (id);
3374
3375
3376--
3377-- Name: socialaccount_socialaccount socialaccount_socialaccount_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3378--
3379
3380ALTER TABLE ONLY public.socialaccount_socialaccount
3381    ADD CONSTRAINT socialaccount_socialaccount_pkey PRIMARY KEY (id);
3382
3383
3384--
3385-- Name: socialaccount_socialaccount socialaccount_socialaccount_provider_uid_fc810c6e_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3386--
3387
3388ALTER TABLE ONLY public.socialaccount_socialaccount
3389    ADD CONSTRAINT socialaccount_socialaccount_provider_uid_fc810c6e_uniq UNIQUE (provider, uid);
3390
3391
3392--
3393-- Name: socialaccount_socialapp_sites socialaccount_socialapp__socialapp_id_site_id_71a9a768_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3394--
3395
3396ALTER TABLE ONLY public.socialaccount_socialapp_sites
3397    ADD CONSTRAINT socialaccount_socialapp__socialapp_id_site_id_71a9a768_uniq UNIQUE (socialapp_id, site_id);
3398
3399
3400--
3401-- Name: socialaccount_socialapp socialaccount_socialapp_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3402--
3403
3404ALTER TABLE ONLY public.socialaccount_socialapp
3405    ADD CONSTRAINT socialaccount_socialapp_pkey PRIMARY KEY (id);
3406
3407
3408--
3409-- Name: socialaccount_socialapp_sites socialaccount_socialapp_sites_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3410--
3411
3412ALTER TABLE ONLY public.socialaccount_socialapp_sites
3413    ADD CONSTRAINT socialaccount_socialapp_sites_pkey PRIMARY KEY (id);
3414
3415
3416--
3417-- Name: socialaccount_socialtoken socialaccount_socialtoken_app_id_account_id_fca4e0ac_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3418--
3419
3420ALTER TABLE ONLY public.socialaccount_socialtoken
3421    ADD CONSTRAINT socialaccount_socialtoken_app_id_account_id_fca4e0ac_uniq UNIQUE (app_id, account_id);
3422
3423
3424--
3425-- Name: socialaccount_socialtoken socialaccount_socialtoken_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3426--
3427
3428ALTER TABLE ONLY public.socialaccount_socialtoken
3429    ADD CONSTRAINT socialaccount_socialtoken_pkey PRIMARY KEY (id);
3430
3431
3432--
3433-- Name: taggit_tag taggit_tag_name_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3434--
3435
3436ALTER TABLE ONLY public.taggit_tag
3437    ADD CONSTRAINT taggit_tag_name_key UNIQUE (name);
3438
3439
3440--
3441-- Name: taggit_tag taggit_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3442--
3443
3444ALTER TABLE ONLY public.taggit_tag
3445    ADD CONSTRAINT taggit_tag_pkey PRIMARY KEY (id);
3446
3447
3448--
3449-- Name: taggit_tag taggit_tag_slug_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3450--
3451
3452ALTER TABLE ONLY public.taggit_tag
3453    ADD CONSTRAINT taggit_tag_slug_key UNIQUE (slug);
3454
3455
3456--
3457-- Name: taggit_taggeditem taggit_taggeditem_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3458--
3459
3460ALTER TABLE ONLY public.taggit_taggeditem
3461    ADD CONSTRAINT taggit_taggeditem_pkey PRIMARY KEY (id);
3462
3463
3464--
3465-- Name: tags_tag tags_tag_name_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3466--
3467
3468ALTER TABLE ONLY public.tags_tag
3469    ADD CONSTRAINT tags_tag_name_key UNIQUE (name);
3470
3471
3472--
3473-- Name: tags_tag tags_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3474--
3475
3476ALTER TABLE ONLY public.tags_tag
3477    ADD CONSTRAINT tags_tag_pkey PRIMARY KEY (id);
3478
3479
3480--
3481-- Name: tags_taggeditem tags_taggeditem_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3482--
3483
3484ALTER TABLE ONLY public.tags_taggeditem
3485    ADD CONSTRAINT tags_taggeditem_pkey PRIMARY KEY (id);
3486
3487
3488--
3489-- Name: tags_taggeditem tags_taggeditem_tag_id_content_type_id_object_id_eda7330b_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3490--
3491
3492ALTER TABLE ONLY public.tags_taggeditem
3493    ADD CONSTRAINT tags_taggeditem_tag_id_content_type_id_object_id_eda7330b_uniq UNIQUE (tag_id, content_type_id, object_id);
3494
3495
3496--
3497-- Name: users_accesstoken users_accesstoken_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3498--
3499
3500ALTER TABLE ONLY public.users_accesstoken
3501    ADD CONSTRAINT users_accesstoken_pkey PRIMARY KEY (id);
3502
3503
3504--
3505-- Name: users_accesstoken users_accesstoken_source_refresh_token_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3506--
3507
3508ALTER TABLE ONLY public.users_accesstoken
3509    ADD CONSTRAINT users_accesstoken_source_refresh_token_id_key UNIQUE (source_refresh_token_id);
3510
3511
3512--
3513-- Name: users_accesstoken users_accesstoken_token_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3514--
3515
3516ALTER TABLE ONLY public.users_accesstoken
3517    ADD CONSTRAINT users_accesstoken_token_key UNIQUE (token);
3518
3519
3520--
3521-- Name: users_application users_application_client_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3522--
3523
3524ALTER TABLE ONLY public.users_application
3525    ADD CONSTRAINT users_application_client_id_key UNIQUE (client_id);
3526
3527
3528--
3529-- Name: users_application users_application_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3530--
3531
3532ALTER TABLE ONLY public.users_application
3533    ADD CONSTRAINT users_application_pkey PRIMARY KEY (id);
3534
3535
3536--
3537-- Name: users_grant users_grant_code_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3538--
3539
3540ALTER TABLE ONLY public.users_grant
3541    ADD CONSTRAINT users_grant_code_key UNIQUE (code);
3542
3543
3544--
3545-- Name: users_grant users_grant_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3546--
3547
3548ALTER TABLE ONLY public.users_grant
3549    ADD CONSTRAINT users_grant_pkey PRIMARY KEY (id);
3550
3551
3552--
3553-- Name: users_invitation users_invitation_code_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3554--
3555
3556ALTER TABLE ONLY public.users_invitation
3557    ADD CONSTRAINT users_invitation_code_key UNIQUE (code);
3558
3559
3560--
3561-- Name: users_invitation users_invitation_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3562--
3563
3564ALTER TABLE ONLY public.users_invitation
3565    ADD CONSTRAINT users_invitation_pkey PRIMARY KEY (id);
3566
3567
3568--
3569-- Name: users_refreshtoken users_refreshtoken_access_token_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3570--
3571
3572ALTER TABLE ONLY public.users_refreshtoken
3573    ADD CONSTRAINT users_refreshtoken_access_token_id_key UNIQUE (access_token_id);
3574
3575
3576--
3577-- Name: users_refreshtoken users_refreshtoken_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3578--
3579
3580ALTER TABLE ONLY public.users_refreshtoken
3581    ADD CONSTRAINT users_refreshtoken_pkey PRIMARY KEY (id);
3582
3583
3584--
3585-- Name: users_refreshtoken users_refreshtoken_token_revoked_95ceb6f9_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3586--
3587
3588ALTER TABLE ONLY public.users_refreshtoken
3589    ADD CONSTRAINT users_refreshtoken_token_revoked_95ceb6f9_uniq UNIQUE (token, revoked);
3590
3591
3592--
3593-- Name: users_user users_user_actor_id_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3594--
3595
3596ALTER TABLE ONLY public.users_user
3597    ADD CONSTRAINT users_user_actor_id_key UNIQUE (actor_id);
3598
3599
3600--
3601-- Name: users_user_groups users_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3602--
3603
3604ALTER TABLE ONLY public.users_user_groups
3605    ADD CONSTRAINT users_user_groups_pkey PRIMARY KEY (id);
3606
3607
3608--
3609-- Name: users_user_groups users_user_groups_user_id_group_id_b88eab82_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3610--
3611
3612ALTER TABLE ONLY public.users_user_groups
3613    ADD CONSTRAINT users_user_groups_user_id_group_id_b88eab82_uniq UNIQUE (user_id, group_id);
3614
3615
3616--
3617-- Name: users_user users_user_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3618--
3619
3620ALTER TABLE ONLY public.users_user
3621    ADD CONSTRAINT users_user_pkey PRIMARY KEY (id);
3622
3623
3624--
3625-- Name: users_user_user_permissions users_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3626--
3627
3628ALTER TABLE ONLY public.users_user_user_permissions
3629    ADD CONSTRAINT users_user_user_permissions_pkey PRIMARY KEY (id);
3630
3631
3632--
3633-- Name: users_user_user_permissions users_user_user_permissions_user_id_permission_id_43338c45_uniq; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3634--
3635
3636ALTER TABLE ONLY public.users_user_user_permissions
3637    ADD CONSTRAINT users_user_user_permissions_user_id_permission_id_43338c45_uniq UNIQUE (user_id, permission_id);
3638
3639
3640--
3641-- Name: users_user users_user_username_key; Type: CONSTRAINT; Schema: public; Owner: funkwhale
3642--
3643
3644ALTER TABLE ONLY public.users_user
3645    ADD CONSTRAINT users_user_username_key UNIQUE (username);
3646
3647
3648--
3649-- Name: account_emailaddress_email_03be32b2_like; Type: INDEX; Schema: public; Owner: funkwhale
3650--
3651
3652CREATE INDEX account_emailaddress_email_03be32b2_like ON public.account_emailaddress USING btree (email varchar_pattern_ops);
3653
3654
3655--
3656-- Name: account_emailaddress_user_id_2c513194; Type: INDEX; Schema: public; Owner: funkwhale
3657--
3658
3659CREATE INDEX account_emailaddress_user_id_2c513194 ON public.account_emailaddress USING btree (user_id);
3660
3661
3662--
3663-- Name: account_emailconfirmation_email_address_id_5b7f8c58; Type: INDEX; Schema: public; Owner: funkwhale
3664--
3665
3666CREATE INDEX account_emailconfirmation_email_address_id_5b7f8c58 ON public.account_emailconfirmation USING btree (email_address_id);
3667
3668
3669--
3670-- Name: account_emailconfirmation_key_f43612bd_like; Type: INDEX; Schema: public; Owner: funkwhale
3671--
3672
3673CREATE INDEX account_emailconfirmation_key_f43612bd_like ON public.account_emailconfirmation USING btree (key varchar_pattern_ops);
3674
3675
3676--
3677-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: funkwhale
3678--
3679
3680CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);
3681
3682
3683--
3684-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: funkwhale
3685--
3686
3687CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);
3688
3689
3690--
3691-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: funkwhale
3692--
3693
3694CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);
3695
3696
3697--
3698-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: funkwhale
3699--
3700
3701CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);
3702
3703
3704--
3705-- Name: authtoken_token_key_10f0b77e_like; Type: INDEX; Schema: public; Owner: funkwhale
3706--
3707
3708CREATE INDEX authtoken_token_key_10f0b77e_like ON public.authtoken_token USING btree (key varchar_pattern_ops);
3709
3710
3711--
3712-- Name: common_mutation_applied_date_9bf255da; Type: INDEX; Schema: public; Owner: funkwhale
3713--
3714
3715CREATE INDEX common_mutation_applied_date_9bf255da ON public.common_mutation USING btree (applied_date);
3716
3717
3718--
3719-- Name: common_mutation_approved_by_id_41c8c522; Type: INDEX; Schema: public; Owner: funkwhale
3720--
3721
3722CREATE INDEX common_mutation_approved_by_id_41c8c522 ON public.common_mutation USING btree (approved_by_id);
3723
3724
3725--
3726-- Name: common_mutation_created_by_id_1db2fa2c; Type: INDEX; Schema: public; Owner: funkwhale
3727--
3728
3729CREATE INDEX common_mutation_created_by_id_1db2fa2c ON public.common_mutation USING btree (created_by_id);
3730
3731
3732--
3733-- Name: common_mutation_creation_date_c95f4af5; Type: INDEX; Schema: public; Owner: funkwhale
3734--
3735
3736CREATE INDEX common_mutation_creation_date_c95f4af5 ON public.common_mutation USING btree (creation_date);
3737
3738
3739--
3740-- Name: common_mutation_fid_89da1c9c_like; Type: INDEX; Schema: public; Owner: funkwhale
3741--
3742
3743CREATE INDEX common_mutation_fid_89da1c9c_like ON public.common_mutation USING btree (fid varchar_pattern_ops);
3744
3745
3746--
3747-- Name: common_mutation_target_content_type_id_94567848; Type: INDEX; Schema: public; Owner: funkwhale
3748--
3749
3750CREATE INDEX common_mutation_target_content_type_id_94567848 ON public.common_mutation USING btree (target_content_type_id);
3751
3752
3753--
3754-- Name: common_mutation_type_f1676218; Type: INDEX; Schema: public; Owner: funkwhale
3755--
3756
3757CREATE INDEX common_mutation_type_f1676218 ON public.common_mutation USING btree (type);
3758
3759
3760--
3761-- Name: common_mutation_type_f1676218_like; Type: INDEX; Schema: public; Owner: funkwhale
3762--
3763
3764CREATE INDEX common_mutation_type_f1676218_like ON public.common_mutation USING btree (type varchar_pattern_ops);
3765
3766
3767--
3768-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: funkwhale
3769--
3770
3771CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);
3772
3773
3774--
3775-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: funkwhale
3776--
3777
3778CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);
3779
3780
3781--
3782-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: funkwhale
3783--
3784
3785CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);
3786
3787
3788--
3789-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: funkwhale
3790--
3791
3792CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);
3793
3794
3795--
3796-- Name: django_site_domain_a2e37b91_like; Type: INDEX; Schema: public; Owner: funkwhale
3797--
3798
3799CREATE INDEX django_site_domain_a2e37b91_like ON public.django_site USING btree (domain varchar_pattern_ops);
3800
3801
3802--
3803-- Name: dynamic_preferences_globalpreferencemodel_name_033debe0; Type: INDEX; Schema: public; Owner: funkwhale
3804--
3805
3806CREATE INDEX dynamic_preferences_globalpreferencemodel_name_033debe0 ON public.dynamic_preferences_globalpreferencemodel USING btree (name);
3807
3808
3809--
3810-- Name: dynamic_preferences_globalpreferencemodel_name_033debe0_like; Type: INDEX; Schema: public; Owner: funkwhale
3811--
3812
3813CREATE INDEX dynamic_preferences_globalpreferencemodel_name_033debe0_like ON public.dynamic_preferences_globalpreferencemodel USING btree (name varchar_pattern_ops);
3814
3815
3816--
3817-- Name: dynamic_preferences_globalpreferencemodel_section_c1ee9cc3; Type: INDEX; Schema: public; Owner: funkwhale
3818--
3819
3820CREATE INDEX dynamic_preferences_globalpreferencemodel_section_c1ee9cc3 ON public.dynamic_preferences_globalpreferencemodel USING btree (section);
3821
3822
3823--
3824-- Name: dynamic_preferences_globalpreferencemodel_section_c1ee9cc3_like; Type: INDEX; Schema: public; Owner: funkwhale
3825--
3826
3827CREATE INDEX dynamic_preferences_globalpreferencemodel_section_c1ee9cc3_like ON public.dynamic_preferences_globalpreferencemodel USING btree (section varchar_pattern_ops);
3828
3829
3830--
3831-- Name: favorites_trackfavorite_track_id_be170b21; Type: INDEX; Schema: public; Owner: funkwhale
3832--
3833
3834CREATE INDEX favorites_trackfavorite_track_id_be170b21 ON public.favorites_trackfavorite USING btree (track_id);
3835
3836
3837--
3838-- Name: favorites_trackfavorite_user_id_125d16dd; Type: INDEX; Schema: public; Owner: funkwhale
3839--
3840
3841CREATE INDEX favorites_trackfavorite_user_id_125d16dd ON public.favorites_trackfavorite USING btree (user_id);
3842
3843
3844--
3845-- Name: federation_activity_actor_id_724f7092; Type: INDEX; Schema: public; Owner: funkwhale
3846--
3847
3848CREATE INDEX federation_activity_actor_id_724f7092 ON public.federation_activity USING btree (actor_id);
3849
3850
3851--
3852-- Name: federation_activity_creation_date_644d9cff; Type: INDEX; Schema: public; Owner: funkwhale
3853--
3854
3855CREATE INDEX federation_activity_creation_date_644d9cff ON public.federation_activity USING btree (creation_date);
3856
3857
3858--
3859-- Name: federation_activity_fid_57f9b9c0_like; Type: INDEX; Schema: public; Owner: funkwhale
3860--
3861
3862CREATE INDEX federation_activity_fid_57f9b9c0_like ON public.federation_activity USING btree (fid varchar_pattern_ops);
3863
3864
3865--
3866-- Name: federation_activity_object_content_type_id_57ab8d8d; Type: INDEX; Schema: public; Owner: funkwhale
3867--
3868
3869CREATE INDEX federation_activity_object_content_type_id_57ab8d8d ON public.federation_activity USING btree (object_content_type_id);
3870
3871
3872--
3873-- Name: federation_activity_related_object_content_type_id_a85b6b99; Type: INDEX; Schema: public; Owner: funkwhale
3874--
3875
3876CREATE INDEX federation_activity_related_object_content_type_id_a85b6b99 ON public.federation_activity USING btree (related_object_content_type_id);
3877
3878
3879--
3880-- Name: federation_activity_target_content_type_id_ffc12178; Type: INDEX; Schema: public; Owner: funkwhale
3881--
3882
3883CREATE INDEX federation_activity_target_content_type_id_ffc12178 ON public.federation_activity USING btree (target_content_type_id);
3884
3885
3886--
3887-- Name: federation_activity_type_6dda0a33; Type: INDEX; Schema: public; Owner: funkwhale
3888--
3889
3890CREATE INDEX federation_activity_type_6dda0a33 ON public.federation_activity USING btree (type);
3891
3892
3893--
3894-- Name: federation_activity_type_6dda0a33_like; Type: INDEX; Schema: public; Owner: funkwhale
3895--
3896
3897CREATE INDEX federation_activity_type_6dda0a33_like ON public.federation_activity USING btree (type varchar_pattern_ops);
3898
3899
3900--
3901-- Name: federation_actor_domain_id_391b1309; Type: INDEX; Schema: public; Owner: funkwhale
3902--
3903
3904CREATE INDEX federation_actor_domain_id_391b1309 ON public.federation_actor USING btree (domain_id);
3905
3906
3907--
3908-- Name: federation_actor_domain_id_391b1309_like; Type: INDEX; Schema: public; Owner: funkwhale
3909--
3910
3911CREATE INDEX federation_actor_domain_id_391b1309_like ON public.federation_actor USING btree (domain_id varchar_pattern_ops);
3912
3913
3914--
3915-- Name: federation_actor_url_dc8f6b10_like; Type: INDEX; Schema: public; Owner: funkwhale
3916--
3917
3918CREATE INDEX federation_actor_url_dc8f6b10_like ON public.federation_actor USING btree (fid varchar_pattern_ops);
3919
3920
3921--
3922-- Name: federation_delivery_activity_id_acf14d06; Type: INDEX; Schema: public; Owner: funkwhale
3923--
3924
3925CREATE INDEX federation_delivery_activity_id_acf14d06 ON public.federation_delivery USING btree (activity_id);
3926
3927
3928--
3929-- Name: federation_domain_name_bda59a99_like; Type: INDEX; Schema: public; Owner: funkwhale
3930--
3931
3932CREATE INDEX federation_domain_name_bda59a99_like ON public.federation_domain USING btree (name varchar_pattern_ops);
3933
3934
3935--
3936-- Name: federation_domain_service_actor_id_63a05c1f; Type: INDEX; Schema: public; Owner: funkwhale
3937--
3938
3939CREATE INDEX federation_domain_service_actor_id_63a05c1f ON public.federation_domain USING btree (service_actor_id);
3940
3941
3942--
3943-- Name: federation_fetch_actor_id_8c5eb8c3; Type: INDEX; Schema: public; Owner: funkwhale
3944--
3945
3946CREATE INDEX federation_fetch_actor_id_8c5eb8c3 ON public.federation_fetch USING btree (actor_id);
3947
3948
3949--
3950-- Name: federation_fetch_object_content_type_id_53e7a322; Type: INDEX; Schema: public; Owner: funkwhale
3951--
3952
3953CREATE INDEX federation_fetch_object_content_type_id_53e7a322 ON public.federation_fetch USING btree (object_content_type_id);
3954
3955
3956--
3957-- Name: federation_fetch_url_d502ed2f; Type: INDEX; Schema: public; Owner: funkwhale
3958--
3959
3960CREATE INDEX federation_fetch_url_d502ed2f ON public.federation_fetch USING btree (url);
3961
3962
3963--
3964-- Name: federation_fetch_url_d502ed2f_like; Type: INDEX; Schema: public; Owner: funkwhale
3965--
3966
3967CREATE INDEX federation_fetch_url_d502ed2f_like ON public.federation_fetch USING btree (url varchar_pattern_ops);
3968
3969
3970--
3971-- Name: federation_follow_actor_id_1dd316b5; Type: INDEX; Schema: public; Owner: funkwhale
3972--
3973
3974CREATE INDEX federation_follow_actor_id_1dd316b5 ON public.federation_follow USING btree (actor_id);
3975
3976
3977--
3978-- Name: federation_follow_fid_52377ea7_like; Type: INDEX; Schema: public; Owner: funkwhale
3979--
3980
3981CREATE INDEX federation_follow_fid_52377ea7_like ON public.federation_follow USING btree (fid varchar_pattern_ops);
3982
3983
3984--
3985-- Name: federation_follow_target_id_1eadcb8c; Type: INDEX; Schema: public; Owner: funkwhale
3986--
3987
3988CREATE INDEX federation_follow_target_id_1eadcb8c ON public.federation_follow USING btree (target_id);
3989
3990
3991--
3992-- Name: federation_inboxitem_activity_id_6919318c; Type: INDEX; Schema: public; Owner: funkwhale
3993--
3994
3995CREATE INDEX federation_inboxitem_activity_id_6919318c ON public.federation_inboxitem USING btree (activity_id);
3996
3997
3998--
3999-- Name: federation_inboxitem_actor_id_2ec82923; Type: INDEX; Schema: public; Owner: funkwhale
4000--
4001
4002CREATE INDEX federation_inboxitem_actor_id_2ec82923 ON public.federation_inboxitem USING btree (actor_id);
4003
4004
4005--
4006-- Name: federation_libraryfollow_actor_id_5a3bf6f1; Type: INDEX; Schema: public; Owner: funkwhale
4007--
4008
4009CREATE INDEX federation_libraryfollow_actor_id_5a3bf6f1 ON public.federation_libraryfollow USING btree (actor_id);
4010
4011
4012--
4013-- Name: federation_libraryfollow_fid_80e933b3_like; Type: INDEX; Schema: public; Owner: funkwhale
4014--
4015
4016CREATE INDEX federation_libraryfollow_fid_80e933b3_like ON public.federation_libraryfollow USING btree (fid varchar_pattern_ops);
4017
4018
4019--
4020-- Name: federation_libraryfollow_target_id_6ed2ae56; Type: INDEX; Schema: public; Owner: funkwhale
4021--
4022
4023CREATE INDEX federation_libraryfollow_target_id_6ed2ae56 ON public.federation_libraryfollow USING btree (target_id);
4024
4025
4026--
4027-- Name: federation_librarytrack_library_id_f921e998; Type: INDEX; Schema: public; Owner: funkwhale
4028--
4029
4030CREATE INDEX federation_librarytrack_library_id_f921e998 ON public.federation_librarytrack USING btree (library_id);
4031
4032
4033--
4034-- Name: federation_librarytrack_url_3b99338d_like; Type: INDEX; Schema: public; Owner: funkwhale
4035--
4036
4037CREATE INDEX federation_librarytrack_url_3b99338d_like ON public.federation_librarytrack USING btree (url varchar_pattern_ops);
4038
4039
4040--
4041-- Name: history_listening_track_id_7f208094; Type: INDEX; Schema: public; Owner: funkwhale
4042--
4043
4044CREATE INDEX history_listening_track_id_7f208094 ON public.history_listening USING btree (track_id);
4045
4046
4047--
4048-- Name: history_listening_user_id_fe5e2f16; Type: INDEX; Schema: public; Owner: funkwhale
4049--
4050
4051CREATE INDEX history_listening_user_id_fe5e2f16 ON public.history_listening USING btree (user_id);
4052
4053
4054--
4055-- Name: moderation_instancepolicy_actor_id_14bb8bf2; Type: INDEX; Schema: public; Owner: funkwhale
4056--
4057
4058CREATE INDEX moderation_instancepolicy_actor_id_14bb8bf2 ON public.moderation_instancepolicy USING btree (actor_id);
4059
4060
4061--
4062-- Name: moderation_instancepolicy_target_domain_id_5ae2c96c_like; Type: INDEX; Schema: public; Owner: funkwhale
4063--
4064
4065CREATE INDEX moderation_instancepolicy_target_domain_id_5ae2c96c_like ON public.moderation_instancepolicy USING btree (target_domain_id varchar_pattern_ops);
4066
4067
4068--
4069-- Name: moderation_userfilter_target_artist_id_7e190a04; Type: INDEX; Schema: public; Owner: funkwhale
4070--
4071
4072CREATE INDEX moderation_userfilter_target_artist_id_7e190a04 ON public.moderation_userfilter USING btree (target_artist_id);
4073
4074
4075--
4076-- Name: moderation_userfilter_user_id_be10cd70; Type: INDEX; Schema: public; Owner: funkwhale
4077--
4078
4079CREATE INDEX moderation_userfilter_user_id_be10cd70 ON public.moderation_userfilter USING btree (user_id);
4080
4081
4082--
4083-- Name: music_album_artist_id_f633b817; Type: INDEX; Schema: public; Owner: funkwhale
4084--
4085
4086CREATE INDEX music_album_artist_id_f633b817 ON public.music_album USING btree (artist_id);
4087
4088
4089--
4090-- Name: music_album_attributed_to_id_612f1d98; Type: INDEX; Schema: public; Owner: funkwhale
4091--
4092
4093CREATE INDEX music_album_attributed_to_id_612f1d98 ON public.music_album USING btree (attributed_to_id);
4094
4095
4096--
4097-- Name: music_album_creation_date_b13d9f40; Type: INDEX; Schema: public; Owner: funkwhale
4098--
4099
4100CREATE INDEX music_album_creation_date_b13d9f40 ON public.music_album USING btree (creation_date);
4101
4102
4103--
4104-- Name: music_album_fid_ad6dc879_like; Type: INDEX; Schema: public; Owner: funkwhale
4105--
4106
4107CREATE INDEX music_album_fid_ad6dc879_like ON public.music_album USING btree (fid varchar_pattern_ops);
4108
4109
4110--
4111-- Name: music_album_from_activity_id_b4915a61; Type: INDEX; Schema: public; Owner: funkwhale
4112--
4113
4114CREATE INDEX music_album_from_activity_id_b4915a61 ON public.music_album USING btree (from_activity_id);
4115
4116
4117--
4118-- Name: music_artist_attributed_to_id_379d647d; Type: INDEX; Schema: public; Owner: funkwhale
4119--
4120
4121CREATE INDEX music_artist_attributed_to_id_379d647d ON public.music_artist USING btree (attributed_to_id);
4122
4123
4124--
4125-- Name: music_artist_creation_date_00b3af25; Type: INDEX; Schema: public; Owner: funkwhale
4126--
4127
4128CREATE INDEX music_artist_creation_date_00b3af25 ON public.music_artist USING btree (creation_date);
4129
4130
4131--
4132-- Name: music_artist_fid_bd915d2d_like; Type: INDEX; Schema: public; Owner: funkwhale
4133--
4134
4135CREATE INDEX music_artist_fid_bd915d2d_like ON public.music_artist USING btree (fid varchar_pattern_ops);
4136
4137
4138--
4139-- Name: music_artist_from_activity_id_f589431a; Type: INDEX; Schema: public; Owner: funkwhale
4140--
4141
4142CREATE INDEX music_artist_from_activity_id_f589431a ON public.music_artist USING btree (from_activity_id);
4143
4144
4145--
4146-- Name: music_importbatch_import_request_id_bf61f1a6; Type: INDEX; Schema: public; Owner: funkwhale
4147--
4148
4149CREATE INDEX music_importbatch_import_request_id_bf61f1a6 ON public.music_importbatch USING btree (import_request_id);
4150
4151
4152--
4153-- Name: music_importbatch_library_id_99ffb5c7; Type: INDEX; Schema: public; Owner: funkwhale
4154--
4155
4156CREATE INDEX music_importbatch_library_id_99ffb5c7 ON public.music_importbatch USING btree (library_id);
4157
4158
4159--
4160-- Name: music_importbatch_submitted_by_id_9d334d05; Type: INDEX; Schema: public; Owner: funkwhale
4161--
4162
4163CREATE INDEX music_importbatch_submitted_by_id_9d334d05 ON public.music_importbatch USING btree (submitted_by_id);
4164
4165
4166--
4167-- Name: music_importjob_batch_id_a3d98cd9; Type: INDEX; Schema: public; Owner: funkwhale
4168--
4169
4170CREATE INDEX music_importjob_batch_id_a3d98cd9 ON public.music_importjob USING btree (batch_id);
4171
4172
4173--
4174-- Name: music_importjob_library_track_id_f5163265; Type: INDEX; Schema: public; Owner: funkwhale
4175--
4176
4177CREATE INDEX music_importjob_library_track_id_f5163265 ON public.music_importjob USING btree (library_track_id);
4178
4179
4180--
4181-- Name: music_importjob_track_file_id_5dd97ee9; Type: INDEX; Schema: public; Owner: funkwhale
4182--
4183
4184CREATE INDEX music_importjob_track_file_id_5dd97ee9 ON public.music_importjob USING btree (upload_id);
4185
4186
4187--
4188-- Name: music_library_actor_id_e7414c5f; Type: INDEX; Schema: public; Owner: funkwhale
4189--
4190
4191CREATE INDEX music_library_actor_id_e7414c5f ON public.music_library USING btree (actor_id);
4192
4193
4194--
4195-- Name: music_library_fid_aeb5f009_like; Type: INDEX; Schema: public; Owner: funkwhale
4196--
4197
4198CREATE INDEX music_library_fid_aeb5f009_like ON public.music_library USING btree (fid varchar_pattern_ops);
4199
4200
4201--
4202-- Name: music_libraryscan_actor_id_265a7e94; Type: INDEX; Schema: public; Owner: funkwhale
4203--
4204
4205CREATE INDEX music_libraryscan_actor_id_265a7e94 ON public.music_libraryscan USING btree (actor_id);
4206
4207
4208--
4209-- Name: music_libraryscan_library_id_4481e635; Type: INDEX; Schema: public; Owner: funkwhale
4210--
4211
4212CREATE INDEX music_libraryscan_library_id_4481e635 ON public.music_libraryscan USING btree (library_id);
4213
4214
4215--
4216-- Name: music_license_code_1e9c3f42_like; Type: INDEX; Schema: public; Owner: funkwhale
4217--
4218
4219CREATE INDEX music_license_code_1e9c3f42_like ON public.music_license USING btree (code varchar_pattern_ops);
4220
4221
4222--
4223-- Name: music_track_album_id_f2264d26; Type: INDEX; Schema: public; Owner: funkwhale
4224--
4225
4226CREATE INDEX music_track_album_id_f2264d26 ON public.music_track USING btree (album_id);
4227
4228
4229--
4230-- Name: music_track_artist_id_a65d07d5; Type: INDEX; Schema: public; Owner: funkwhale
4231--
4232
4233CREATE INDEX music_track_artist_id_a65d07d5 ON public.music_track USING btree (artist_id);
4234
4235
4236--
4237-- Name: music_track_attributed_to_id_8b2a30dc; Type: INDEX; Schema: public; Owner: funkwhale
4238--
4239
4240CREATE INDEX music_track_attributed_to_id_8b2a30dc ON public.music_track USING btree (attributed_to_id);
4241
4242
4243--
4244-- Name: music_track_creation_date_604db63d; Type: INDEX; Schema: public; Owner: funkwhale
4245--
4246
4247CREATE INDEX music_track_creation_date_604db63d ON public.music_track USING btree (creation_date);
4248
4249
4250--
4251-- Name: music_track_fid_e09e220d_like; Type: INDEX; Schema: public; Owner: funkwhale
4252--
4253
4254CREATE INDEX music_track_fid_e09e220d_like ON public.music_track USING btree (fid varchar_pattern_ops);
4255
4256
4257--
4258-- Name: music_track_from_activity_id_608b81a6; Type: INDEX; Schema: public; Owner: funkwhale
4259--
4260
4261CREATE INDEX music_track_from_activity_id_608b81a6 ON public.music_track USING btree (from_activity_id);
4262
4263
4264--
4265-- Name: music_track_license_id_5268131e; Type: INDEX; Schema: public; Owner: funkwhale
4266--
4267
4268CREATE INDEX music_track_license_id_5268131e ON public.music_track USING btree (license_id);
4269
4270
4271--
4272-- Name: music_track_license_id_5268131e_like; Type: INDEX; Schema: public; Owner: funkwhale
4273--
4274
4275CREATE INDEX music_track_license_id_5268131e_like ON public.music_track USING btree (license_id varchar_pattern_ops);
4276
4277
4278--
4279-- Name: music_trackfile_fid_34740d06_like; Type: INDEX; Schema: public; Owner: funkwhale
4280--
4281
4282CREATE INDEX music_trackfile_fid_34740d06_like ON public.music_upload USING btree (fid varchar_pattern_ops);
4283
4284
4285--
4286-- Name: music_trackfile_from_activity_id_80146598; Type: INDEX; Schema: public; Owner: funkwhale
4287--
4288
4289CREATE INDEX music_trackfile_from_activity_id_80146598 ON public.music_upload USING btree (from_activity_id);
4290
4291
4292--
4293-- Name: music_trackfile_library_id_0652b91c; Type: INDEX; Schema: public; Owner: funkwhale
4294--
4295
4296CREATE INDEX music_trackfile_library_id_0652b91c ON public.music_upload USING btree (library_id);
4297
4298
4299--
4300-- Name: music_trackfile_track_id_0bfee9a4; Type: INDEX; Schema: public; Owner: funkwhale
4301--
4302
4303CREATE INDEX music_trackfile_track_id_0bfee9a4 ON public.music_upload USING btree (track_id);
4304
4305
4306--
4307-- Name: music_upload_creation_date_d211e505; Type: INDEX; Schema: public; Owner: funkwhale
4308--
4309
4310CREATE INDEX music_upload_creation_date_d211e505 ON public.music_upload USING btree (creation_date);
4311
4312
4313--
4314-- Name: music_uploadversion_upload_id_489c0a3d; Type: INDEX; Schema: public; Owner: funkwhale
4315--
4316
4317CREATE INDEX music_uploadversion_upload_id_489c0a3d ON public.music_uploadversion USING btree (upload_id);
4318
4319
4320--
4321-- Name: playlists_playlist_user_id_155248c5; Type: INDEX; Schema: public; Owner: funkwhale
4322--
4323
4324CREATE INDEX playlists_playlist_user_id_155248c5 ON public.playlists_playlist USING btree (user_id);
4325
4326
4327--
4328-- Name: playlists_playlisttrack_playlist_id_55ed1521; Type: INDEX; Schema: public; Owner: funkwhale
4329--
4330
4331CREATE INDEX playlists_playlisttrack_playlist_id_55ed1521 ON public.playlists_playlisttrack USING btree (playlist_id);
4332
4333
4334--
4335-- Name: playlists_playlisttrack_track_id_a6e7ea01; Type: INDEX; Schema: public; Owner: funkwhale
4336--
4337
4338CREATE INDEX playlists_playlisttrack_track_id_a6e7ea01 ON public.playlists_playlisttrack USING btree (track_id);
4339
4340
4341--
4342-- Name: radios_radio_user_id_1fd41ff9; Type: INDEX; Schema: public; Owner: funkwhale
4343--
4344
4345CREATE INDEX radios_radio_user_id_1fd41ff9 ON public.radios_radio USING btree (user_id);
4346
4347
4348--
4349-- Name: radios_radiosession_custom_radio_id_552cb4f0; Type: INDEX; Schema: public; Owner: funkwhale
4350--
4351
4352CREATE INDEX radios_radiosession_custom_radio_id_552cb4f0 ON public.radios_radiosession USING btree (custom_radio_id);
4353
4354
4355--
4356-- Name: radios_radiosession_related_object_content_type_id_ac0e19b3; Type: INDEX; Schema: public; Owner: funkwhale
4357--
4358
4359CREATE INDEX radios_radiosession_related_object_content_type_id_ac0e19b3 ON public.radios_radiosession USING btree (related_object_content_type_id);
4360
4361
4362--
4363-- Name: radios_radiosession_user_id_2f6d0243; Type: INDEX; Schema: public; Owner: funkwhale
4364--
4365
4366CREATE INDEX radios_radiosession_user_id_2f6d0243 ON public.radios_radiosession USING btree (user_id);
4367
4368
4369--
4370-- Name: radios_radiosessiontrack_session_id_1e8532ac; Type: INDEX; Schema: public; Owner: funkwhale
4371--
4372
4373CREATE INDEX radios_radiosessiontrack_session_id_1e8532ac ON public.radios_radiosessiontrack USING btree (session_id);
4374
4375
4376--
4377-- Name: radios_radiosessiontrack_track_id_c3daa8e8; Type: INDEX; Schema: public; Owner: funkwhale
4378--
4379
4380CREATE INDEX radios_radiosessiontrack_track_id_c3daa8e8 ON public.radios_radiosessiontrack USING btree (track_id);
4381
4382
4383--
4384-- Name: requests_importrequest_user_id_5ef0f95c; Type: INDEX; Schema: public; Owner: funkwhale
4385--
4386
4387CREATE INDEX requests_importrequest_user_id_5ef0f95c ON public.requests_importrequest USING btree (user_id);
4388
4389
4390--
4391-- Name: socialaccount_socialaccount_user_id_8146e70c; Type: INDEX; Schema: public; Owner: funkwhale
4392--
4393
4394CREATE INDEX socialaccount_socialaccount_user_id_8146e70c ON public.socialaccount_socialaccount USING btree (user_id);
4395
4396
4397--
4398-- Name: socialaccount_socialapp_sites_site_id_2579dee5; Type: INDEX; Schema: public; Owner: funkwhale
4399--
4400
4401CREATE INDEX socialaccount_socialapp_sites_site_id_2579dee5 ON public.socialaccount_socialapp_sites USING btree (site_id);
4402
4403
4404--
4405-- Name: socialaccount_socialapp_sites_socialapp_id_97fb6e7d; Type: INDEX; Schema: public; Owner: funkwhale
4406--
4407
4408CREATE INDEX socialaccount_socialapp_sites_socialapp_id_97fb6e7d ON public.socialaccount_socialapp_sites USING btree (socialapp_id);
4409
4410
4411--
4412-- Name: socialaccount_socialtoken_account_id_951f210e; Type: INDEX; Schema: public; Owner: funkwhale
4413--
4414
4415CREATE INDEX socialaccount_socialtoken_account_id_951f210e ON public.socialaccount_socialtoken USING btree (account_id);
4416
4417
4418--
4419-- Name: socialaccount_socialtoken_app_id_636a42d7; Type: INDEX; Schema: public; Owner: funkwhale
4420--
4421
4422CREATE INDEX socialaccount_socialtoken_app_id_636a42d7 ON public.socialaccount_socialtoken USING btree (app_id);
4423
4424
4425--
4426-- Name: taggit_tag_name_58eb2ed9_like; Type: INDEX; Schema: public; Owner: funkwhale
4427--
4428
4429CREATE INDEX taggit_tag_name_58eb2ed9_like ON public.taggit_tag USING btree (name varchar_pattern_ops);
4430
4431
4432--
4433-- Name: taggit_tag_slug_6be58b2c_like; Type: INDEX; Schema: public; Owner: funkwhale
4434--
4435
4436CREATE INDEX taggit_tag_slug_6be58b2c_like ON public.taggit_tag USING btree (slug varchar_pattern_ops);
4437
4438
4439--
4440-- Name: taggit_taggeditem_content_type_id_9957a03c; Type: INDEX; Schema: public; Owner: funkwhale
4441--
4442
4443CREATE INDEX taggit_taggeditem_content_type_id_9957a03c ON public.taggit_taggeditem USING btree (content_type_id);
4444
4445
4446--
4447-- Name: taggit_taggeditem_content_type_id_object_id_196cc965_idx; Type: INDEX; Schema: public; Owner: funkwhale
4448--
4449
4450CREATE INDEX taggit_taggeditem_content_type_id_object_id_196cc965_idx ON public.taggit_taggeditem USING btree (content_type_id, object_id);
4451
4452
4453--
4454-- Name: taggit_taggeditem_object_id_e2d7d1df; Type: INDEX; Schema: public; Owner: funkwhale
4455--
4456
4457CREATE INDEX taggit_taggeditem_object_id_e2d7d1df ON public.taggit_taggeditem USING btree (object_id);
4458
4459
4460--
4461-- Name: taggit_taggeditem_tag_id_f4f5b767; Type: INDEX; Schema: public; Owner: funkwhale
4462--
4463
4464CREATE INDEX taggit_taggeditem_tag_id_f4f5b767 ON public.taggit_taggeditem USING btree (tag_id);
4465
4466
4467--
4468-- Name: tags_taggeditem_content_type_id_03c84c71; Type: INDEX; Schema: public; Owner: funkwhale
4469--
4470
4471CREATE INDEX tags_taggeditem_content_type_id_03c84c71 ON public.tags_taggeditem USING btree (content_type_id);
4472
4473
4474--
4475-- Name: tags_taggeditem_object_id_5718393f; Type: INDEX; Schema: public; Owner: funkwhale
4476--
4477
4478CREATE INDEX tags_taggeditem_object_id_5718393f ON public.tags_taggeditem USING btree (object_id);
4479
4480
4481--
4482-- Name: tags_taggeditem_tag_id_31864f91; Type: INDEX; Schema: public; Owner: funkwhale
4483--
4484
4485CREATE INDEX tags_taggeditem_tag_id_31864f91 ON public.tags_taggeditem USING btree (tag_id);
4486
4487
4488--
4489-- Name: users_accesstoken_application_id_6e9a3267; Type: INDEX; Schema: public; Owner: funkwhale
4490--
4491
4492CREATE INDEX users_accesstoken_application_id_6e9a3267 ON public.users_accesstoken USING btree (application_id);
4493
4494
4495--
4496-- Name: users_accesstoken_token_3195d0d1_like; Type: INDEX; Schema: public; Owner: funkwhale
4497--
4498
4499CREATE INDEX users_accesstoken_token_3195d0d1_like ON public.users_accesstoken USING btree (token varchar_pattern_ops);
4500
4501
4502--
4503-- Name: users_accesstoken_user_id_77202406; Type: INDEX; Schema: public; Owner: funkwhale
4504--
4505
4506CREATE INDEX users_accesstoken_user_id_77202406 ON public.users_accesstoken USING btree (user_id);
4507
4508
4509--
4510-- Name: users_application_client_id_8782dae5_like; Type: INDEX; Schema: public; Owner: funkwhale
4511--
4512
4513CREATE INDEX users_application_client_id_8782dae5_like ON public.users_application USING btree (client_id varchar_pattern_ops);
4514
4515
4516--
4517-- Name: users_application_client_secret_aec7268a; Type: INDEX; Schema: public; Owner: funkwhale
4518--
4519
4520CREATE INDEX users_application_client_secret_aec7268a ON public.users_application USING btree (client_secret);
4521
4522
4523--
4524-- Name: users_application_client_secret_aec7268a_like; Type: INDEX; Schema: public; Owner: funkwhale
4525--
4526
4527CREATE INDEX users_application_client_secret_aec7268a_like ON public.users_application USING btree (client_secret varchar_pattern_ops);
4528
4529
4530--
4531-- Name: users_application_user_id_d61d39e7; Type: INDEX; Schema: public; Owner: funkwhale
4532--
4533
4534CREATE INDEX users_application_user_id_d61d39e7 ON public.users_application USING btree (user_id);
4535
4536
4537--
4538-- Name: users_grant_application_id_fe747060; Type: INDEX; Schema: public; Owner: funkwhale
4539--
4540
4541CREATE INDEX users_grant_application_id_fe747060 ON public.users_grant USING btree (application_id);
4542
4543
4544--
4545-- Name: users_grant_code_a79899b6_like; Type: INDEX; Schema: public; Owner: funkwhale
4546--
4547
4548CREATE INDEX users_grant_code_a79899b6_like ON public.users_grant USING btree (code varchar_pattern_ops);
4549
4550
4551--
4552-- Name: users_grant_user_id_ebedef34; Type: INDEX; Schema: public; Owner: funkwhale
4553--
4554
4555CREATE INDEX users_grant_user_id_ebedef34 ON public.users_grant USING btree (user_id);
4556
4557
4558--
4559-- Name: users_invitation_code_05432933_like; Type: INDEX; Schema: public; Owner: funkwhale
4560--
4561
4562CREATE INDEX users_invitation_code_05432933_like ON public.users_invitation USING btree (code varchar_pattern_ops);
4563
4564
4565--
4566-- Name: users_invitation_owner_id_96084d2c; Type: INDEX; Schema: public; Owner: funkwhale
4567--
4568
4569CREATE INDEX users_invitation_owner_id_96084d2c ON public.users_invitation USING btree (owner_id);
4570
4571
4572--
4573-- Name: users_refreshtoken_application_id_c6abec85; Type: INDEX; Schema: public; Owner: funkwhale
4574--
4575
4576CREATE INDEX users_refreshtoken_application_id_c6abec85 ON public.users_refreshtoken USING btree (application_id);
4577
4578
4579--
4580-- Name: users_refreshtoken_user_id_2df68a14; Type: INDEX; Schema: public; Owner: funkwhale
4581--
4582
4583CREATE INDEX users_refreshtoken_user_id_2df68a14 ON public.users_refreshtoken USING btree (user_id);
4584
4585
4586--
4587-- Name: users_user_groups_group_id_9afc8d0e; Type: INDEX; Schema: public; Owner: funkwhale
4588--
4589
4590CREATE INDEX users_user_groups_group_id_9afc8d0e ON public.users_user_groups USING btree (group_id);
4591
4592
4593--
4594-- Name: users_user_groups_user_id_5f6f5a90; Type: INDEX; Schema: public; Owner: funkwhale
4595--
4596
4597CREATE INDEX users_user_groups_user_id_5f6f5a90 ON public.users_user_groups USING btree (user_id);
4598
4599
4600--
4601-- Name: users_user_invitation_id_2911621e; Type: INDEX; Schema: public; Owner: funkwhale
4602--
4603
4604CREATE INDEX users_user_invitation_id_2911621e ON public.users_user USING btree (invitation_id);
4605
4606
4607--
4608-- Name: users_user_user_permissions_permission_id_0b93982e; Type: INDEX; Schema: public; Owner: funkwhale
4609--
4610
4611CREATE INDEX users_user_user_permissions_permission_id_0b93982e ON public.users_user_user_permissions USING btree (permission_id);
4612
4613
4614--
4615-- Name: users_user_user_permissions_user_id_20aca447; Type: INDEX; Schema: public; Owner: funkwhale
4616--
4617
4618CREATE INDEX users_user_user_permissions_user_id_20aca447 ON public.users_user_user_permissions USING btree (user_id);
4619
4620
4621--
4622-- Name: users_user_username_06e46fe6_like; Type: INDEX; Schema: public; Owner: funkwhale
4623--
4624
4625CREATE INDEX users_user_username_06e46fe6_like ON public.users_user USING btree (username varchar_pattern_ops);
4626
4627
4628--
4629-- Name: account_emailaddress account_emailaddress_user_id_2c513194_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4630--
4631
4632ALTER TABLE ONLY public.account_emailaddress
4633    ADD CONSTRAINT account_emailaddress_user_id_2c513194_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
4634
4635
4636--
4637-- Name: account_emailconfirmation account_emailconfirm_email_address_id_5b7f8c58_fk_account_e; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4638--
4639
4640ALTER TABLE ONLY public.account_emailconfirmation
4641    ADD CONSTRAINT account_emailconfirm_email_address_id_5b7f8c58_fk_account_e FOREIGN KEY (email_address_id) REFERENCES public.account_emailaddress(id) DEFERRABLE INITIALLY DEFERRED;
4642
4643
4644--
4645-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4646--
4647
4648ALTER TABLE ONLY public.auth_group_permissions
4649    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
4650
4651
4652--
4653-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4654--
4655
4656ALTER TABLE ONLY public.auth_group_permissions
4657    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;
4658
4659
4660--
4661-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4662--
4663
4664ALTER TABLE ONLY public.auth_permission
4665    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
4666
4667
4668--
4669-- Name: authtoken_token authtoken_token_user_id_35299eff_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4670--
4671
4672ALTER TABLE ONLY public.authtoken_token
4673    ADD CONSTRAINT authtoken_token_user_id_35299eff_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
4674
4675
4676--
4677-- Name: common_mutation common_mutation_approved_by_id_41c8c522_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4678--
4679
4680ALTER TABLE ONLY public.common_mutation
4681    ADD CONSTRAINT common_mutation_approved_by_id_41c8c522_fk_federation_actor_id FOREIGN KEY (approved_by_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4682
4683
4684--
4685-- Name: common_mutation common_mutation_created_by_id_1db2fa2c_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4686--
4687
4688ALTER TABLE ONLY public.common_mutation
4689    ADD CONSTRAINT common_mutation_created_by_id_1db2fa2c_fk_federation_actor_id FOREIGN KEY (created_by_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4690
4691
4692--
4693-- Name: common_mutation common_mutation_target_content_type__94567848_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4694--
4695
4696ALTER TABLE ONLY public.common_mutation
4697    ADD CONSTRAINT common_mutation_target_content_type__94567848_fk_django_co FOREIGN KEY (target_content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
4698
4699
4700--
4701-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4702--
4703
4704ALTER TABLE ONLY public.django_admin_log
4705    ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
4706
4707
4708--
4709-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4710--
4711
4712ALTER TABLE ONLY public.django_admin_log
4713    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
4714
4715
4716--
4717-- Name: favorites_trackfavorite favorites_trackfavorite_track_id_be170b21_fk_music_track_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4718--
4719
4720ALTER TABLE ONLY public.favorites_trackfavorite
4721    ADD CONSTRAINT favorites_trackfavorite_track_id_be170b21_fk_music_track_id FOREIGN KEY (track_id) REFERENCES public.music_track(id) DEFERRABLE INITIALLY DEFERRED;
4722
4723
4724--
4725-- Name: favorites_trackfavorite favorites_trackfavorite_user_id_125d16dd_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4726--
4727
4728ALTER TABLE ONLY public.favorites_trackfavorite
4729    ADD CONSTRAINT favorites_trackfavorite_user_id_125d16dd_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
4730
4731
4732--
4733-- Name: federation_activity federation_activity_actor_id_724f7092_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4734--
4735
4736ALTER TABLE ONLY public.federation_activity
4737    ADD CONSTRAINT federation_activity_actor_id_724f7092_fk_federation_actor_id FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4738
4739
4740--
4741-- Name: federation_activity federation_activity_object_content_type__57ab8d8d_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4742--
4743
4744ALTER TABLE ONLY public.federation_activity
4745    ADD CONSTRAINT federation_activity_object_content_type__57ab8d8d_fk_django_co FOREIGN KEY (object_content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
4746
4747
4748--
4749-- Name: federation_activity federation_activity_related_object_conte_a85b6b99_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4750--
4751
4752ALTER TABLE ONLY public.federation_activity
4753    ADD CONSTRAINT federation_activity_related_object_conte_a85b6b99_fk_django_co FOREIGN KEY (related_object_content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
4754
4755
4756--
4757-- Name: federation_activity federation_activity_target_content_type__ffc12178_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4758--
4759
4760ALTER TABLE ONLY public.federation_activity
4761    ADD CONSTRAINT federation_activity_target_content_type__ffc12178_fk_django_co FOREIGN KEY (target_content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
4762
4763
4764--
4765-- Name: federation_actor federation_actor_domain_id_391b1309_fk_federation_domain_name; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4766--
4767
4768ALTER TABLE ONLY public.federation_actor
4769    ADD CONSTRAINT federation_actor_domain_id_391b1309_fk_federation_domain_name FOREIGN KEY (domain_id) REFERENCES public.federation_domain(name) DEFERRABLE INITIALLY DEFERRED;
4770
4771
4772--
4773-- Name: federation_delivery federation_delivery_activity_id_acf14d06_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4774--
4775
4776ALTER TABLE ONLY public.federation_delivery
4777    ADD CONSTRAINT federation_delivery_activity_id_acf14d06_fk_federatio FOREIGN KEY (activity_id) REFERENCES public.federation_activity(id) DEFERRABLE INITIALLY DEFERRED;
4778
4779
4780--
4781-- Name: federation_domain federation_domain_service_actor_id_63a05c1f_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4782--
4783
4784ALTER TABLE ONLY public.federation_domain
4785    ADD CONSTRAINT federation_domain_service_actor_id_63a05c1f_fk_federatio FOREIGN KEY (service_actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4786
4787
4788--
4789-- Name: federation_fetch federation_fetch_actor_id_8c5eb8c3_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4790--
4791
4792ALTER TABLE ONLY public.federation_fetch
4793    ADD CONSTRAINT federation_fetch_actor_id_8c5eb8c3_fk_federation_actor_id FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4794
4795
4796--
4797-- Name: federation_fetch federation_fetch_object_content_type__53e7a322_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4798--
4799
4800ALTER TABLE ONLY public.federation_fetch
4801    ADD CONSTRAINT federation_fetch_object_content_type__53e7a322_fk_django_co FOREIGN KEY (object_content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
4802
4803
4804--
4805-- Name: federation_follow federation_follow_actor_id_1dd316b5_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4806--
4807
4808ALTER TABLE ONLY public.federation_follow
4809    ADD CONSTRAINT federation_follow_actor_id_1dd316b5_fk_federation_actor_id FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4810
4811
4812--
4813-- Name: federation_follow federation_follow_target_id_1eadcb8c_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4814--
4815
4816ALTER TABLE ONLY public.federation_follow
4817    ADD CONSTRAINT federation_follow_target_id_1eadcb8c_fk_federation_actor_id FOREIGN KEY (target_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4818
4819
4820--
4821-- Name: federation_inboxitem federation_inboxitem_activity_id_6919318c_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4822--
4823
4824ALTER TABLE ONLY public.federation_inboxitem
4825    ADD CONSTRAINT federation_inboxitem_activity_id_6919318c_fk_federatio FOREIGN KEY (activity_id) REFERENCES public.federation_activity(id) DEFERRABLE INITIALLY DEFERRED;
4826
4827
4828--
4829-- Name: federation_inboxitem federation_inboxitem_actor_id_2ec82923_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4830--
4831
4832ALTER TABLE ONLY public.federation_inboxitem
4833    ADD CONSTRAINT federation_inboxitem_actor_id_2ec82923_fk_federation_actor_id FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4834
4835
4836--
4837-- Name: federation_library federation_library_actor_id_b1808c2a_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4838--
4839
4840ALTER TABLE ONLY public.federation_library
4841    ADD CONSTRAINT federation_library_actor_id_b1808c2a_fk_federation_actor_id FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4842
4843
4844--
4845-- Name: federation_library federation_library_follow_id_7ea76688_fk_federation_follow_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4846--
4847
4848ALTER TABLE ONLY public.federation_library
4849    ADD CONSTRAINT federation_library_follow_id_7ea76688_fk_federation_follow_id FOREIGN KEY (follow_id) REFERENCES public.federation_follow(id) DEFERRABLE INITIALLY DEFERRED;
4850
4851
4852--
4853-- Name: federation_libraryfollow federation_libraryfo_actor_id_5a3bf6f1_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4854--
4855
4856ALTER TABLE ONLY public.federation_libraryfollow
4857    ADD CONSTRAINT federation_libraryfo_actor_id_5a3bf6f1_fk_federatio FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4858
4859
4860--
4861-- Name: federation_libraryfollow federation_libraryfollow_target_id_6ed2ae56_fk_music_library_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4862--
4863
4864ALTER TABLE ONLY public.federation_libraryfollow
4865    ADD CONSTRAINT federation_libraryfollow_target_id_6ed2ae56_fk_music_library_id FOREIGN KEY (target_id) REFERENCES public.music_library(id) DEFERRABLE INITIALLY DEFERRED;
4866
4867
4868--
4869-- Name: federation_librarytrack federation_librarytr_library_id_f921e998_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4870--
4871
4872ALTER TABLE ONLY public.federation_librarytrack
4873    ADD CONSTRAINT federation_librarytr_library_id_f921e998_fk_federatio FOREIGN KEY (library_id) REFERENCES public.federation_library(id) DEFERRABLE INITIALLY DEFERRED;
4874
4875
4876--
4877-- Name: history_listening history_listening_track_id_7f208094_fk_music_track_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4878--
4879
4880ALTER TABLE ONLY public.history_listening
4881    ADD CONSTRAINT history_listening_track_id_7f208094_fk_music_track_id FOREIGN KEY (track_id) REFERENCES public.music_track(id) DEFERRABLE INITIALLY DEFERRED;
4882
4883
4884--
4885-- Name: history_listening history_listening_user_id_fe5e2f16_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4886--
4887
4888ALTER TABLE ONLY public.history_listening
4889    ADD CONSTRAINT history_listening_user_id_fe5e2f16_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
4890
4891
4892--
4893-- Name: moderation_instancepolicy moderation_instancep_actor_id_14bb8bf2_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4894--
4895
4896ALTER TABLE ONLY public.moderation_instancepolicy
4897    ADD CONSTRAINT moderation_instancep_actor_id_14bb8bf2_fk_federatio FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4898
4899
4900--
4901-- Name: moderation_instancepolicy moderation_instancep_target_actor_id_84344dfd_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4902--
4903
4904ALTER TABLE ONLY public.moderation_instancepolicy
4905    ADD CONSTRAINT moderation_instancep_target_actor_id_84344dfd_fk_federatio FOREIGN KEY (target_actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4906
4907
4908--
4909-- Name: moderation_instancepolicy moderation_instancep_target_domain_id_5ae2c96c_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4910--
4911
4912ALTER TABLE ONLY public.moderation_instancepolicy
4913    ADD CONSTRAINT moderation_instancep_target_domain_id_5ae2c96c_fk_federatio FOREIGN KEY (target_domain_id) REFERENCES public.federation_domain(name) DEFERRABLE INITIALLY DEFERRED;
4914
4915
4916--
4917-- Name: moderation_userfilter moderation_userfilte_target_artist_id_7e190a04_fk_music_art; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4918--
4919
4920ALTER TABLE ONLY public.moderation_userfilter
4921    ADD CONSTRAINT moderation_userfilte_target_artist_id_7e190a04_fk_music_art FOREIGN KEY (target_artist_id) REFERENCES public.music_artist(id) DEFERRABLE INITIALLY DEFERRED;
4922
4923
4924--
4925-- Name: moderation_userfilter moderation_userfilter_user_id_be10cd70_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4926--
4927
4928ALTER TABLE ONLY public.moderation_userfilter
4929    ADD CONSTRAINT moderation_userfilter_user_id_be10cd70_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
4930
4931
4932--
4933-- Name: music_album music_album_artist_id_f633b817_fk_music_artist_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4934--
4935
4936ALTER TABLE ONLY public.music_album
4937    ADD CONSTRAINT music_album_artist_id_f633b817_fk_music_artist_id FOREIGN KEY (artist_id) REFERENCES public.music_artist(id) DEFERRABLE INITIALLY DEFERRED;
4938
4939
4940--
4941-- Name: music_album music_album_attributed_to_id_612f1d98_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4942--
4943
4944ALTER TABLE ONLY public.music_album
4945    ADD CONSTRAINT music_album_attributed_to_id_612f1d98_fk_federation_actor_id FOREIGN KEY (attributed_to_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4946
4947
4948--
4949-- Name: music_album music_album_from_activity_id_b4915a61_fk_federation_activity_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4950--
4951
4952ALTER TABLE ONLY public.music_album
4953    ADD CONSTRAINT music_album_from_activity_id_b4915a61_fk_federation_activity_id FOREIGN KEY (from_activity_id) REFERENCES public.federation_activity(id) DEFERRABLE INITIALLY DEFERRED;
4954
4955
4956--
4957-- Name: music_artist music_artist_attributed_to_id_379d647d_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4958--
4959
4960ALTER TABLE ONLY public.music_artist
4961    ADD CONSTRAINT music_artist_attributed_to_id_379d647d_fk_federation_actor_id FOREIGN KEY (attributed_to_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
4962
4963
4964--
4965-- Name: music_artist music_artist_from_activity_id_f589431a_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4966--
4967
4968ALTER TABLE ONLY public.music_artist
4969    ADD CONSTRAINT music_artist_from_activity_id_f589431a_fk_federatio FOREIGN KEY (from_activity_id) REFERENCES public.federation_activity(id) DEFERRABLE INITIALLY DEFERRED;
4970
4971
4972--
4973-- Name: music_importbatch music_importbatch_import_request_id_bf61f1a6_fk_requests_; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4974--
4975
4976ALTER TABLE ONLY public.music_importbatch
4977    ADD CONSTRAINT music_importbatch_import_request_id_bf61f1a6_fk_requests_ FOREIGN KEY (import_request_id) REFERENCES public.requests_importrequest(id) DEFERRABLE INITIALLY DEFERRED;
4978
4979
4980--
4981-- Name: music_importbatch music_importbatch_library_id_99ffb5c7_fk_music_library_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4982--
4983
4984ALTER TABLE ONLY public.music_importbatch
4985    ADD CONSTRAINT music_importbatch_library_id_99ffb5c7_fk_music_library_id FOREIGN KEY (library_id) REFERENCES public.music_library(id) DEFERRABLE INITIALLY DEFERRED;
4986
4987
4988--
4989-- Name: music_importbatch music_importbatch_submitted_by_id_9d334d05_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4990--
4991
4992ALTER TABLE ONLY public.music_importbatch
4993    ADD CONSTRAINT music_importbatch_submitted_by_id_9d334d05_fk_users_user_id FOREIGN KEY (submitted_by_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
4994
4995
4996--
4997-- Name: music_importjob music_importjob_batch_id_a3d98cd9_fk_music_importbatch_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
4998--
4999
5000ALTER TABLE ONLY public.music_importjob
5001    ADD CONSTRAINT music_importjob_batch_id_a3d98cd9_fk_music_importbatch_id FOREIGN KEY (batch_id) REFERENCES public.music_importbatch(id) DEFERRABLE INITIALLY DEFERRED;
5002
5003
5004--
5005-- Name: music_importjob music_importjob_library_track_id_f5163265_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5006--
5007
5008ALTER TABLE ONLY public.music_importjob
5009    ADD CONSTRAINT music_importjob_library_track_id_f5163265_fk_federatio FOREIGN KEY (library_track_id) REFERENCES public.federation_librarytrack(id) DEFERRABLE INITIALLY DEFERRED;
5010
5011
5012--
5013-- Name: music_importjob music_importjob_upload_id_188b5360_fk_music_upload_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5014--
5015
5016ALTER TABLE ONLY public.music_importjob
5017    ADD CONSTRAINT music_importjob_upload_id_188b5360_fk_music_upload_id FOREIGN KEY (upload_id) REFERENCES public.music_upload(id) DEFERRABLE INITIALLY DEFERRED;
5018
5019
5020--
5021-- Name: music_library music_library_actor_id_e7414c5f_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5022--
5023
5024ALTER TABLE ONLY public.music_library
5025    ADD CONSTRAINT music_library_actor_id_e7414c5f_fk_federation_actor_id FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
5026
5027
5028--
5029-- Name: music_libraryscan music_libraryscan_actor_id_265a7e94_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5030--
5031
5032ALTER TABLE ONLY public.music_libraryscan
5033    ADD CONSTRAINT music_libraryscan_actor_id_265a7e94_fk_federation_actor_id FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
5034
5035
5036--
5037-- Name: music_libraryscan music_libraryscan_library_id_4481e635_fk_music_library_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5038--
5039
5040ALTER TABLE ONLY public.music_libraryscan
5041    ADD CONSTRAINT music_libraryscan_library_id_4481e635_fk_music_library_id FOREIGN KEY (library_id) REFERENCES public.music_library(id) DEFERRABLE INITIALLY DEFERRED;
5042
5043
5044--
5045-- Name: music_track music_track_album_id_f2264d26_fk_music_album_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5046--
5047
5048ALTER TABLE ONLY public.music_track
5049    ADD CONSTRAINT music_track_album_id_f2264d26_fk_music_album_id FOREIGN KEY (album_id) REFERENCES public.music_album(id) DEFERRABLE INITIALLY DEFERRED;
5050
5051
5052--
5053-- Name: music_track music_track_artist_id_a65d07d5_fk_music_artist_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5054--
5055
5056ALTER TABLE ONLY public.music_track
5057    ADD CONSTRAINT music_track_artist_id_a65d07d5_fk_music_artist_id FOREIGN KEY (artist_id) REFERENCES public.music_artist(id) DEFERRABLE INITIALLY DEFERRED;
5058
5059
5060--
5061-- Name: music_track music_track_attributed_to_id_8b2a30dc_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5062--
5063
5064ALTER TABLE ONLY public.music_track
5065    ADD CONSTRAINT music_track_attributed_to_id_8b2a30dc_fk_federation_actor_id FOREIGN KEY (attributed_to_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
5066
5067
5068--
5069-- Name: music_track music_track_from_activity_id_608b81a6_fk_federation_activity_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5070--
5071
5072ALTER TABLE ONLY public.music_track
5073    ADD CONSTRAINT music_track_from_activity_id_608b81a6_fk_federation_activity_id FOREIGN KEY (from_activity_id) REFERENCES public.federation_activity(id) DEFERRABLE INITIALLY DEFERRED;
5074
5075
5076--
5077-- Name: music_track music_track_license_id_5268131e_fk_music_license_code; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5078--
5079
5080ALTER TABLE ONLY public.music_track
5081    ADD CONSTRAINT music_track_license_id_5268131e_fk_music_license_code FOREIGN KEY (license_id) REFERENCES public.music_license(code) DEFERRABLE INITIALLY DEFERRED;
5082
5083
5084--
5085-- Name: music_upload music_trackfile_from_activity_id_80146598_fk_federatio; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5086--
5087
5088ALTER TABLE ONLY public.music_upload
5089    ADD CONSTRAINT music_trackfile_from_activity_id_80146598_fk_federatio FOREIGN KEY (from_activity_id) REFERENCES public.federation_activity(id) DEFERRABLE INITIALLY DEFERRED;
5090
5091
5092--
5093-- Name: music_upload music_upload_library_id_05917ae6_fk_music_library_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5094--
5095
5096ALTER TABLE ONLY public.music_upload
5097    ADD CONSTRAINT music_upload_library_id_05917ae6_fk_music_library_id FOREIGN KEY (library_id) REFERENCES public.music_library(id) DEFERRABLE INITIALLY DEFERRED;
5098
5099
5100--
5101-- Name: music_upload music_upload_track_id_cb15ade0_fk_music_track_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5102--
5103
5104ALTER TABLE ONLY public.music_upload
5105    ADD CONSTRAINT music_upload_track_id_cb15ade0_fk_music_track_id FOREIGN KEY (track_id) REFERENCES public.music_track(id) DEFERRABLE INITIALLY DEFERRED;
5106
5107
5108--
5109-- Name: music_uploadversion music_uploadversion_upload_id_489c0a3d_fk_music_upload_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5110--
5111
5112ALTER TABLE ONLY public.music_uploadversion
5113    ADD CONSTRAINT music_uploadversion_upload_id_489c0a3d_fk_music_upload_id FOREIGN KEY (upload_id) REFERENCES public.music_upload(id) DEFERRABLE INITIALLY DEFERRED;
5114
5115
5116--
5117-- Name: playlists_playlist playlists_playlist_user_id_155248c5_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5118--
5119
5120ALTER TABLE ONLY public.playlists_playlist
5121    ADD CONSTRAINT playlists_playlist_user_id_155248c5_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5122
5123
5124--
5125-- Name: playlists_playlisttrack playlists_playlisttr_playlist_id_55ed1521_fk_playlists; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5126--
5127
5128ALTER TABLE ONLY public.playlists_playlisttrack
5129    ADD CONSTRAINT playlists_playlisttr_playlist_id_55ed1521_fk_playlists FOREIGN KEY (playlist_id) REFERENCES public.playlists_playlist(id) DEFERRABLE INITIALLY DEFERRED;
5130
5131
5132--
5133-- Name: playlists_playlisttrack playlists_playlisttrack_track_id_a6e7ea01_fk_music_track_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5134--
5135
5136ALTER TABLE ONLY public.playlists_playlisttrack
5137    ADD CONSTRAINT playlists_playlisttrack_track_id_a6e7ea01_fk_music_track_id FOREIGN KEY (track_id) REFERENCES public.music_track(id) DEFERRABLE INITIALLY DEFERRED;
5138
5139
5140--
5141-- Name: radios_radio radios_radio_user_id_1fd41ff9_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5142--
5143
5144ALTER TABLE ONLY public.radios_radio
5145    ADD CONSTRAINT radios_radio_user_id_1fd41ff9_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5146
5147
5148--
5149-- Name: radios_radiosession radios_radiosession_custom_radio_id_552cb4f0_fk_radios_radio_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5150--
5151
5152ALTER TABLE ONLY public.radios_radiosession
5153    ADD CONSTRAINT radios_radiosession_custom_radio_id_552cb4f0_fk_radios_radio_id FOREIGN KEY (custom_radio_id) REFERENCES public.radios_radio(id) DEFERRABLE INITIALLY DEFERRED;
5154
5155
5156--
5157-- Name: radios_radiosession radios_radiosession_related_object_conte_ac0e19b3_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5158--
5159
5160ALTER TABLE ONLY public.radios_radiosession
5161    ADD CONSTRAINT radios_radiosession_related_object_conte_ac0e19b3_fk_django_co FOREIGN KEY (related_object_content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
5162
5163
5164--
5165-- Name: radios_radiosession radios_radiosession_user_id_2f6d0243_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5166--
5167
5168ALTER TABLE ONLY public.radios_radiosession
5169    ADD CONSTRAINT radios_radiosession_user_id_2f6d0243_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5170
5171
5172--
5173-- Name: radios_radiosessiontrack radios_radiosessiont_session_id_1e8532ac_fk_radios_ra; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5174--
5175
5176ALTER TABLE ONLY public.radios_radiosessiontrack
5177    ADD CONSTRAINT radios_radiosessiont_session_id_1e8532ac_fk_radios_ra FOREIGN KEY (session_id) REFERENCES public.radios_radiosession(id) DEFERRABLE INITIALLY DEFERRED;
5178
5179
5180--
5181-- Name: radios_radiosessiontrack radios_radiosessiontrack_track_id_c3daa8e8_fk_music_track_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5182--
5183
5184ALTER TABLE ONLY public.radios_radiosessiontrack
5185    ADD CONSTRAINT radios_radiosessiontrack_track_id_c3daa8e8_fk_music_track_id FOREIGN KEY (track_id) REFERENCES public.music_track(id) DEFERRABLE INITIALLY DEFERRED;
5186
5187
5188--
5189-- Name: requests_importrequest requests_importrequest_user_id_5ef0f95c_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5190--
5191
5192ALTER TABLE ONLY public.requests_importrequest
5193    ADD CONSTRAINT requests_importrequest_user_id_5ef0f95c_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5194
5195
5196--
5197-- Name: socialaccount_socialtoken socialaccount_social_account_id_951f210e_fk_socialacc; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5198--
5199
5200ALTER TABLE ONLY public.socialaccount_socialtoken
5201    ADD CONSTRAINT socialaccount_social_account_id_951f210e_fk_socialacc FOREIGN KEY (account_id) REFERENCES public.socialaccount_socialaccount(id) DEFERRABLE INITIALLY DEFERRED;
5202
5203
5204--
5205-- Name: socialaccount_socialtoken socialaccount_social_app_id_636a42d7_fk_socialacc; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5206--
5207
5208ALTER TABLE ONLY public.socialaccount_socialtoken
5209    ADD CONSTRAINT socialaccount_social_app_id_636a42d7_fk_socialacc FOREIGN KEY (app_id) REFERENCES public.socialaccount_socialapp(id) DEFERRABLE INITIALLY DEFERRED;
5210
5211
5212--
5213-- Name: socialaccount_socialapp_sites socialaccount_social_site_id_2579dee5_fk_django_si; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5214--
5215
5216ALTER TABLE ONLY public.socialaccount_socialapp_sites
5217    ADD CONSTRAINT socialaccount_social_site_id_2579dee5_fk_django_si FOREIGN KEY (site_id) REFERENCES public.django_site(id) DEFERRABLE INITIALLY DEFERRED;
5218
5219
5220--
5221-- Name: socialaccount_socialapp_sites socialaccount_social_socialapp_id_97fb6e7d_fk_socialacc; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5222--
5223
5224ALTER TABLE ONLY public.socialaccount_socialapp_sites
5225    ADD CONSTRAINT socialaccount_social_socialapp_id_97fb6e7d_fk_socialacc FOREIGN KEY (socialapp_id) REFERENCES public.socialaccount_socialapp(id) DEFERRABLE INITIALLY DEFERRED;
5226
5227
5228--
5229-- Name: socialaccount_socialaccount socialaccount_socialaccount_user_id_8146e70c_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5230--
5231
5232ALTER TABLE ONLY public.socialaccount_socialaccount
5233    ADD CONSTRAINT socialaccount_socialaccount_user_id_8146e70c_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5234
5235
5236--
5237-- Name: taggit_taggeditem taggit_taggeditem_content_type_id_9957a03c_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5238--
5239
5240ALTER TABLE ONLY public.taggit_taggeditem
5241    ADD CONSTRAINT taggit_taggeditem_content_type_id_9957a03c_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
5242
5243
5244--
5245-- Name: taggit_taggeditem taggit_taggeditem_tag_id_f4f5b767_fk_taggit_tag_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5246--
5247
5248ALTER TABLE ONLY public.taggit_taggeditem
5249    ADD CONSTRAINT taggit_taggeditem_tag_id_f4f5b767_fk_taggit_tag_id FOREIGN KEY (tag_id) REFERENCES public.taggit_tag(id) DEFERRABLE INITIALLY DEFERRED;
5250
5251
5252--
5253-- Name: tags_taggeditem tags_taggeditem_content_type_id_03c84c71_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5254--
5255
5256ALTER TABLE ONLY public.tags_taggeditem
5257    ADD CONSTRAINT tags_taggeditem_content_type_id_03c84c71_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
5258
5259
5260--
5261-- Name: tags_taggeditem tags_taggeditem_tag_id_31864f91_fk_tags_tag_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5262--
5263
5264ALTER TABLE ONLY public.tags_taggeditem
5265    ADD CONSTRAINT tags_taggeditem_tag_id_31864f91_fk_tags_tag_id FOREIGN KEY (tag_id) REFERENCES public.tags_tag(id) DEFERRABLE INITIALLY DEFERRED;
5266
5267
5268--
5269-- Name: users_accesstoken users_accesstoken_application_id_6e9a3267_fk_users_app; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5270--
5271
5272ALTER TABLE ONLY public.users_accesstoken
5273    ADD CONSTRAINT users_accesstoken_application_id_6e9a3267_fk_users_app FOREIGN KEY (application_id) REFERENCES public.users_application(id) DEFERRABLE INITIALLY DEFERRED;
5274
5275
5276--
5277-- Name: users_accesstoken users_accesstoken_source_refresh_token_d5109c81_fk_users_ref; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5278--
5279
5280ALTER TABLE ONLY public.users_accesstoken
5281    ADD CONSTRAINT users_accesstoken_source_refresh_token_d5109c81_fk_users_ref FOREIGN KEY (source_refresh_token_id) REFERENCES public.users_refreshtoken(id) DEFERRABLE INITIALLY DEFERRED;
5282
5283
5284--
5285-- Name: users_accesstoken users_accesstoken_user_id_77202406_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5286--
5287
5288ALTER TABLE ONLY public.users_accesstoken
5289    ADD CONSTRAINT users_accesstoken_user_id_77202406_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5290
5291
5292--
5293-- Name: users_application users_application_user_id_d61d39e7_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5294--
5295
5296ALTER TABLE ONLY public.users_application
5297    ADD CONSTRAINT users_application_user_id_d61d39e7_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5298
5299
5300--
5301-- Name: users_grant users_grant_application_id_fe747060_fk_users_application_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5302--
5303
5304ALTER TABLE ONLY public.users_grant
5305    ADD CONSTRAINT users_grant_application_id_fe747060_fk_users_application_id FOREIGN KEY (application_id) REFERENCES public.users_application(id) DEFERRABLE INITIALLY DEFERRED;
5306
5307
5308--
5309-- Name: users_grant users_grant_user_id_ebedef34_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5310--
5311
5312ALTER TABLE ONLY public.users_grant
5313    ADD CONSTRAINT users_grant_user_id_ebedef34_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5314
5315
5316--
5317-- Name: users_invitation users_invitation_owner_id_96084d2c_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5318--
5319
5320ALTER TABLE ONLY public.users_invitation
5321    ADD CONSTRAINT users_invitation_owner_id_96084d2c_fk_users_user_id FOREIGN KEY (owner_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5322
5323
5324--
5325-- Name: users_refreshtoken users_refreshtoken_access_token_id_325ac0aa_fk_users_acc; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5326--
5327
5328ALTER TABLE ONLY public.users_refreshtoken
5329    ADD CONSTRAINT users_refreshtoken_access_token_id_325ac0aa_fk_users_acc FOREIGN KEY (access_token_id) REFERENCES public.users_accesstoken(id) DEFERRABLE INITIALLY DEFERRED;
5330
5331
5332--
5333-- Name: users_refreshtoken users_refreshtoken_application_id_c6abec85_fk_users_app; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5334--
5335
5336ALTER TABLE ONLY public.users_refreshtoken
5337    ADD CONSTRAINT users_refreshtoken_application_id_c6abec85_fk_users_app FOREIGN KEY (application_id) REFERENCES public.users_application(id) DEFERRABLE INITIALLY DEFERRED;
5338
5339
5340--
5341-- Name: users_refreshtoken users_refreshtoken_user_id_2df68a14_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5342--
5343
5344ALTER TABLE ONLY public.users_refreshtoken
5345    ADD CONSTRAINT users_refreshtoken_user_id_2df68a14_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5346
5347
5348--
5349-- Name: users_user users_user_actor_id_bc13dddc_fk_federation_actor_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5350--
5351
5352ALTER TABLE ONLY public.users_user
5353    ADD CONSTRAINT users_user_actor_id_bc13dddc_fk_federation_actor_id FOREIGN KEY (actor_id) REFERENCES public.federation_actor(id) DEFERRABLE INITIALLY DEFERRED;
5354
5355
5356--
5357-- Name: users_user_groups users_user_groups_group_id_9afc8d0e_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5358--
5359
5360ALTER TABLE ONLY public.users_user_groups
5361    ADD CONSTRAINT users_user_groups_group_id_9afc8d0e_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;
5362
5363
5364--
5365-- Name: users_user_groups users_user_groups_user_id_5f6f5a90_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5366--
5367
5368ALTER TABLE ONLY public.users_user_groups
5369    ADD CONSTRAINT users_user_groups_user_id_5f6f5a90_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5370
5371
5372--
5373-- Name: users_user users_user_invitation_id_2911621e_fk_users_invitation_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5374--
5375
5376ALTER TABLE ONLY public.users_user
5377    ADD CONSTRAINT users_user_invitation_id_2911621e_fk_users_invitation_id FOREIGN KEY (invitation_id) REFERENCES public.users_invitation(id) DEFERRABLE INITIALLY DEFERRED;
5378
5379
5380--
5381-- Name: users_user_user_permissions users_user_user_perm_permission_id_0b93982e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5382--
5383
5384ALTER TABLE ONLY public.users_user_user_permissions
5385    ADD CONSTRAINT users_user_user_perm_permission_id_0b93982e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
5386
5387
5388--
5389-- Name: users_user_user_permissions users_user_user_permissions_user_id_20aca447_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: funkwhale
5390--
5391
5392ALTER TABLE ONLY public.users_user_user_permissions
5393    ADD CONSTRAINT users_user_user_permissions_user_id_20aca447_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;
5394
5395
5396--
5397-- PostgreSQL database dump complete
5398--