palpo_data/
schema.rs

1// @generated automatically by Diesel CLI.
2
3diesel::table! {
4    use diesel::sql_types::*;
5    use crate::full_text_search::*;
6
7    appservice_registrations (id) {
8        id -> Text,
9        url -> Nullable<Text>,
10        as_token -> Text,
11        hs_token -> Text,
12        sender_localpart -> Text,
13        namespaces -> Json,
14        rate_limited -> Nullable<Bool>,
15        protocols -> Nullable<Json>,
16    }
17}
18
19diesel::table! {
20    use diesel::sql_types::*;
21    use crate::full_text_search::*;
22
23    device_inboxes (id) {
24        id -> Int8,
25        user_id -> Text,
26        device_id -> Text,
27        json_data -> Json,
28        occur_sn -> Int8,
29        created_at -> Int8,
30    }
31}
32
33diesel::table! {
34    use diesel::sql_types::*;
35    use crate::full_text_search::*;
36
37    device_streams (id) {
38        id -> Int8,
39        user_id -> Text,
40        device_id -> Text,
41    }
42}
43
44diesel::table! {
45    use diesel::sql_types::*;
46    use crate::full_text_search::*;
47
48    e2e_cross_signing_keys (id) {
49        id -> Int8,
50        user_id -> Text,
51        key_type -> Text,
52        key_data -> Json,
53    }
54}
55
56diesel::table! {
57    use diesel::sql_types::*;
58    use crate::full_text_search::*;
59
60    e2e_cross_signing_sigs (id) {
61        id -> Int8,
62        origin_user_id -> Text,
63        origin_key_id -> Text,
64        target_user_id -> Text,
65        target_device_id -> Text,
66        signature -> Text,
67    }
68}
69
70diesel::table! {
71    use diesel::sql_types::*;
72    use crate::full_text_search::*;
73
74    e2e_device_keys (id) {
75        id -> Int8,
76        user_id -> Text,
77        device_id -> Text,
78        stream_id -> Int8,
79        display_name -> Nullable<Text>,
80        key_data -> Json,
81        created_at -> Int8,
82    }
83}
84
85diesel::table! {
86    use diesel::sql_types::*;
87    use crate::full_text_search::*;
88
89    e2e_fallback_keys (id) {
90        id -> Int8,
91        user_id -> Text,
92        device_id -> Text,
93        algorithm -> Text,
94        key_id -> Text,
95        key_data -> Json,
96        used_at -> Nullable<Int8>,
97        created_at -> Int8,
98    }
99}
100
101diesel::table! {
102    use diesel::sql_types::*;
103    use crate::full_text_search::*;
104
105    e2e_key_changes (id) {
106        id -> Int8,
107        user_id -> Text,
108        room_id -> Nullable<Text>,
109        occur_sn -> Int8,
110        changed_at -> Int8,
111    }
112}
113
114diesel::table! {
115    use diesel::sql_types::*;
116    use crate::full_text_search::*;
117
118    e2e_one_time_keys (id) {
119        id -> Int8,
120        user_id -> Text,
121        device_id -> Text,
122        algorithm -> Text,
123        key_id -> Text,
124        key_data -> Json,
125        created_at -> Int8,
126    }
127}
128
129diesel::table! {
130    use diesel::sql_types::*;
131    use crate::full_text_search::*;
132
133    e2e_room_keys (id) {
134        id -> Int8,
135        user_id -> Text,
136        room_id -> Text,
137        session_id -> Text,
138        version -> Int8,
139        first_message_index -> Nullable<Int8>,
140        forwarded_count -> Nullable<Int8>,
141        is_verified -> Bool,
142        session_data -> Json,
143        created_at -> Int8,
144    }
145}
146
147diesel::table! {
148    use diesel::sql_types::*;
149    use crate::full_text_search::*;
150
151    e2e_room_keys_versions (id) {
152        id -> Int8,
153        user_id -> Text,
154        version -> Int8,
155        algorithm -> Json,
156        auth_data -> Json,
157        is_trashed -> Bool,
158        etag -> Int8,
159        created_at -> Int8,
160    }
161}
162
163diesel::table! {
164    use diesel::sql_types::*;
165    use crate::full_text_search::*;
166
167    event_auth_chains (cache_key) {
168        cache_key -> Array<Nullable<Int8>>,
169        chain_sns -> Array<Nullable<Int8>>,
170    }
171}
172
173diesel::table! {
174    use diesel::sql_types::*;
175    use crate::full_text_search::*;
176
177    event_backward_extremities (id) {
178        id -> Int8,
179        event_id -> Text,
180        room_id -> Text,
181    }
182}
183
184diesel::table! {
185    use diesel::sql_types::*;
186    use crate::full_text_search::*;
187
188    event_datas (event_id) {
189        event_id -> Text,
190        event_sn -> Int8,
191        room_id -> Text,
192        internal_metadata -> Nullable<Json>,
193        format_version -> Nullable<Int8>,
194        json_data -> Json,
195    }
196}
197
198diesel::table! {
199    use diesel::sql_types::*;
200    use crate::full_text_search::*;
201
202    event_edges (event_id) {
203        event_id -> Text,
204        prev_event_id -> Text,
205        room_id -> Nullable<Text>,
206        is_state -> Bool,
207    }
208}
209
210diesel::table! {
211    use diesel::sql_types::*;
212    use crate::full_text_search::*;
213
214    event_forward_extremities (id) {
215        id -> Int8,
216        event_id -> Text,
217        room_id -> Text,
218    }
219}
220
221diesel::table! {
222    use diesel::sql_types::*;
223    use crate::full_text_search::*;
224
225    event_points (event_id) {
226        event_id -> Text,
227        event_sn -> Int8,
228        room_id -> Text,
229        frame_id -> Nullable<Int8>,
230    }
231}
232
233diesel::table! {
234    use diesel::sql_types::*;
235    use crate::full_text_search::*;
236
237    event_push_summaries (id) {
238        id -> Int8,
239        user_id -> Text,
240        room_id -> Text,
241        notification_count -> Int8,
242        highlight_count -> Int8,
243        unread_count -> Int8,
244        stream_ordering -> Int8,
245        thread_id -> Nullable<Text>,
246    }
247}
248
249diesel::table! {
250    use diesel::sql_types::*;
251    use crate::full_text_search::*;
252
253    event_receipts (id) {
254        id -> Int8,
255        ty -> Text,
256        room_id -> Text,
257        user_id -> Text,
258        event_id -> Text,
259        occur_sn -> Int8,
260        json_data -> Json,
261        receipt_at -> Int8,
262    }
263}
264
265diesel::table! {
266    use diesel::sql_types::*;
267    use crate::full_text_search::*;
268
269    event_relations (id) {
270        id -> Int8,
271        room_id -> Text,
272        event_id -> Text,
273        event_sn -> Int8,
274        event_ty -> Text,
275        child_id -> Text,
276        child_sn -> Int8,
277        child_ty -> Text,
278        rel_type -> Nullable<Text>,
279    }
280}
281
282diesel::table! {
283    use diesel::sql_types::*;
284    use crate::full_text_search::*;
285
286    event_searches (id) {
287        id -> Int8,
288        event_id -> Text,
289        event_sn -> Int8,
290        room_id -> Text,
291        sender_id -> Text,
292        key -> Text,
293        vector -> Tsvector,
294        origin_server_ts -> Int8,
295        stream_ordering -> Nullable<Int8>,
296    }
297}
298
299diesel::table! {
300    use diesel::sql_types::*;
301    use crate::full_text_search::*;
302
303    event_txn_ids (id) {
304        id -> Int8,
305        txn_id -> Text,
306        user_id -> Text,
307        room_id -> Nullable<Text>,
308        device_id -> Nullable<Text>,
309        event_id -> Nullable<Text>,
310        created_at -> Int8,
311    }
312}
313
314diesel::table! {
315    use diesel::sql_types::*;
316    use crate::full_text_search::*;
317
318    events (id) {
319        id -> Text,
320        sn -> Int8,
321        ty -> Text,
322        room_id -> Text,
323        depth -> Int8,
324        topological_ordering -> Int8,
325        stream_ordering -> Int8,
326        unrecognized_keys -> Nullable<Text>,
327        origin_server_ts -> Nullable<Int8>,
328        received_at -> Nullable<Int8>,
329        sender_id -> Nullable<Text>,
330        contains_url -> Bool,
331        worker_id -> Nullable<Text>,
332        state_key -> Nullable<Text>,
333        is_outlier -> Bool,
334        is_redacted -> Bool,
335        soft_failed -> Bool,
336        rejection_reason -> Nullable<Text>,
337    }
338}
339
340diesel::table! {
341    use diesel::sql_types::*;
342    use crate::full_text_search::*;
343
344    lazy_load_deliveries (id) {
345        id -> Int8,
346        user_id -> Text,
347        device_id -> Text,
348        room_id -> Text,
349        confirmed_user_id -> Nullable<Text>,
350    }
351}
352
353diesel::table! {
354    use diesel::sql_types::*;
355    use crate::full_text_search::*;
356
357    media_metadatas (id) {
358        id -> Int8,
359        media_id -> Text,
360        origin_server -> Text,
361        content_type -> Nullable<Text>,
362        disposition_type -> Nullable<Text>,
363        file_name -> Nullable<Text>,
364        file_extension -> Nullable<Text>,
365        file_size -> Int8,
366        file_hash -> Nullable<Text>,
367        created_by -> Nullable<Text>,
368        created_at -> Int8,
369    }
370}
371
372diesel::table! {
373    use diesel::sql_types::*;
374    use crate::full_text_search::*;
375
376    media_thumbnails (id) {
377        id -> Int8,
378        media_id -> Text,
379        origin_server -> Text,
380        content_type -> Text,
381        file_size -> Int8,
382        width -> Int4,
383        height -> Int4,
384        resize_method -> Text,
385        created_at -> Int8,
386    }
387}
388
389diesel::table! {
390    use diesel::sql_types::*;
391    use crate::full_text_search::*;
392
393    outgoing_requests (id) {
394        id -> Int8,
395        kind -> Text,
396        appservice_id -> Nullable<Text>,
397        user_id -> Nullable<Text>,
398        pushkey -> Nullable<Text>,
399        server_id -> Nullable<Text>,
400        pdu_id -> Nullable<Text>,
401        edu_json -> Nullable<Bytea>,
402        state -> Text,
403        data -> Nullable<Bytea>,
404    }
405}
406
407diesel::table! {
408    use diesel::sql_types::*;
409    use crate::full_text_search::*;
410
411    pushers (id) {
412        id -> Int8,
413        user_id -> Text,
414        kind -> Text,
415        app_id -> Text,
416        app_display_name -> Text,
417        device_id -> Text,
418        device_display_name -> Text,
419        access_token_id -> Nullable<Int8>,
420        profile_tag -> Nullable<Text>,
421        pushkey -> Text,
422        lang -> Text,
423        data -> Json,
424        enabled -> Bool,
425        last_stream_ordering -> Nullable<Int8>,
426        last_success -> Nullable<Int8>,
427        failing_since -> Nullable<Int8>,
428        created_at -> Int8,
429    }
430}
431
432diesel::table! {
433    use diesel::sql_types::*;
434    use crate::full_text_search::*;
435
436    room_aliases (alias_id) {
437        alias_id -> Text,
438        room_id -> Text,
439        created_by -> Text,
440        created_at -> Int8,
441    }
442}
443
444diesel::table! {
445    use diesel::sql_types::*;
446    use crate::full_text_search::*;
447
448    room_servers (id) {
449        id -> Int8,
450        room_id -> Text,
451        server_id -> Text,
452    }
453}
454
455diesel::table! {
456    use diesel::sql_types::*;
457    use crate::full_text_search::*;
458
459    room_state_deltas (frame_id) {
460        frame_id -> Int8,
461        room_id -> Text,
462        parent_id -> Nullable<Int8>,
463        appended -> Bytea,
464        disposed -> Bytea,
465    }
466}
467
468diesel::table! {
469    use diesel::sql_types::*;
470    use crate::full_text_search::*;
471
472    room_state_fields (id) {
473        id -> Int8,
474        event_ty -> Text,
475        state_key -> Text,
476    }
477}
478
479diesel::table! {
480    use diesel::sql_types::*;
481    use crate::full_text_search::*;
482
483    room_state_frames (id) {
484        id -> Int8,
485        room_id -> Text,
486        hash_data -> Bytea,
487    }
488}
489
490diesel::table! {
491    use diesel::sql_types::*;
492    use crate::full_text_search::*;
493
494    room_tags (id) {
495        id -> Int8,
496        user_id -> Text,
497        room_id -> Text,
498        tag -> Text,
499        content -> Json,
500        created_by -> Text,
501        created_at -> Int8,
502    }
503}
504
505diesel::table! {
506    use diesel::sql_types::*;
507    use crate::full_text_search::*;
508
509    room_users (id) {
510        id -> Int8,
511        event_id -> Text,
512        event_sn -> Int8,
513        room_id -> Text,
514        room_server_id -> Text,
515        user_id -> Text,
516        user_server_id -> Text,
517        sender_id -> Text,
518        membership -> Text,
519        forgotten -> Bool,
520        display_name -> Nullable<Text>,
521        avatar_url -> Nullable<Text>,
522        state_data -> Nullable<Json>,
523        created_at -> Int8,
524    }
525}
526
527diesel::table! {
528    use diesel::sql_types::*;
529    use crate::full_text_search::*;
530
531    rooms (id) {
532        id -> Text,
533        sn -> Int8,
534        version -> Text,
535        is_public -> Bool,
536        min_depth -> Int8,
537        state_frame_id -> Nullable<Int8>,
538        has_auth_chain_index -> Bool,
539        disabled -> Bool,
540        created_at -> Int8,
541    }
542}
543
544diesel::table! {
545    use diesel::sql_types::*;
546    use crate::full_text_search::*;
547
548    server_signing_keys (server_id) {
549        server_id -> Text,
550        key_data -> Json,
551        updated_at -> Int8,
552        created_at -> Int8,
553    }
554}
555
556diesel::table! {
557    use diesel::sql_types::*;
558    use crate::full_text_search::*;
559
560    stats_monthly_active_users (id) {
561        id -> Int8,
562        user_id -> Text,
563        created_at -> Int8,
564    }
565}
566
567diesel::table! {
568    use diesel::sql_types::*;
569    use crate::full_text_search::*;
570
571    stats_room_currents (room_id) {
572        room_id -> Text,
573        state_events -> Int8,
574        joined_members -> Int8,
575        invited_members -> Int8,
576        left_members -> Int8,
577        banned_members -> Int8,
578        knocked_members -> Int8,
579        local_users_in_room -> Int8,
580        completed_delta_stream_id -> Int8,
581    }
582}
583
584diesel::table! {
585    use diesel::sql_types::*;
586    use crate::full_text_search::*;
587
588    stats_user_daily_visits (id) {
589        id -> Int8,
590        user_id -> Text,
591        device_id -> Text,
592        user_agent -> Nullable<Text>,
593        created_at -> Int8,
594    }
595}
596
597diesel::table! {
598    use diesel::sql_types::*;
599    use crate::full_text_search::*;
600
601    threads (event_id) {
602        event_id -> Text,
603        event_sn -> Int8,
604        room_id -> Text,
605        last_id -> Text,
606        last_sn -> Int8,
607    }
608}
609
610diesel::table! {
611    use diesel::sql_types::*;
612    use crate::full_text_search::*;
613
614    threepid_guests (id) {
615        id -> Int8,
616        medium -> Nullable<Text>,
617        address -> Nullable<Text>,
618        access_token -> Nullable<Text>,
619        first_inviter -> Nullable<Text>,
620        created_at -> Int8,
621    }
622}
623
624diesel::table! {
625    use diesel::sql_types::*;
626    use crate::full_text_search::*;
627
628    threepid_id_servers (id) {
629        id -> Int8,
630        user_id -> Text,
631        medium -> Text,
632        address -> Text,
633        id_server -> Text,
634    }
635}
636
637diesel::table! {
638    use diesel::sql_types::*;
639    use crate::full_text_search::*;
640
641    threepid_validation_sessions (id) {
642        id -> Int8,
643        session_id -> Text,
644        medium -> Text,
645        address -> Text,
646        client_secret -> Text,
647        last_send_attempt -> Int8,
648        validated_at -> Nullable<Int8>,
649        created_at -> Int8,
650    }
651}
652
653diesel::table! {
654    use diesel::sql_types::*;
655    use crate::full_text_search::*;
656
657    threepid_validation_tokens (id) {
658        id -> Int8,
659        token -> Text,
660        session_id -> Text,
661        next_link -> Nullable<Text>,
662        expired_at -> Int8,
663        created_at -> Int8,
664    }
665}
666
667diesel::table! {
668    use diesel::sql_types::*;
669    use crate::full_text_search::*;
670
671    user_access_tokens (id) {
672        id -> Int8,
673        user_id -> Text,
674        device_id -> Text,
675        token -> Text,
676        puppets_user_id -> Nullable<Text>,
677        last_validated -> Nullable<Int8>,
678        refresh_token_id -> Nullable<Int8>,
679        is_used -> Bool,
680        expired_at -> Nullable<Int8>,
681        created_at -> Int8,
682    }
683}
684
685diesel::table! {
686    use diesel::sql_types::*;
687    use crate::full_text_search::*;
688
689    user_datas (id) {
690        id -> Int8,
691        user_id -> Text,
692        room_id -> Nullable<Text>,
693        data_type -> Text,
694        json_data -> Json,
695        occur_sn -> Int8,
696        created_at -> Int8,
697    }
698}
699
700diesel::table! {
701    use diesel::sql_types::*;
702    use crate::full_text_search::*;
703
704    user_dehydrated_devices (id) {
705        id -> Int8,
706        user_id -> Text,
707        device_id -> Text,
708        device_data -> Json,
709    }
710}
711
712diesel::table! {
713    use diesel::sql_types::*;
714    use crate::full_text_search::*;
715
716    user_devices (id) {
717        id -> Int8,
718        user_id -> Text,
719        device_id -> Text,
720        display_name -> Nullable<Text>,
721        user_agent -> Nullable<Text>,
722        is_hidden -> Bool,
723        last_seen_ip -> Nullable<Text>,
724        last_seen_at -> Nullable<Int8>,
725        created_at -> Int8,
726    }
727}
728
729diesel::table! {
730    use diesel::sql_types::*;
731    use crate::full_text_search::*;
732
733    user_filters (id) {
734        id -> Int8,
735        user_id -> Text,
736        filter -> Json,
737        created_at -> Int8,
738    }
739}
740
741diesel::table! {
742    use diesel::sql_types::*;
743    use crate::full_text_search::*;
744
745    user_ignores (id) {
746        id -> Int8,
747        user_id -> Text,
748        ignored_id -> Text,
749        created_at -> Int8,
750    }
751}
752
753diesel::table! {
754    use diesel::sql_types::*;
755    use crate::full_text_search::*;
756
757    user_openid_tokens (id) {
758        id -> Int8,
759        user_id -> Text,
760        token -> Text,
761        expires_at -> Int8,
762    }
763}
764
765diesel::table! {
766    use diesel::sql_types::*;
767    use crate::full_text_search::*;
768
769    user_passwords (id) {
770        id -> Int8,
771        user_id -> Text,
772        hash -> Text,
773        created_at -> Int8,
774    }
775}
776
777diesel::table! {
778    use diesel::sql_types::*;
779    use crate::full_text_search::*;
780
781    user_presences (id) {
782        id -> Int8,
783        user_id -> Text,
784        stream_id -> Nullable<Int8>,
785        state -> Nullable<Text>,
786        status_msg -> Nullable<Text>,
787        last_active_at -> Nullable<Int8>,
788        last_federation_update_at -> Nullable<Int8>,
789        last_user_sync_at -> Nullable<Int8>,
790        currently_active -> Nullable<Bool>,
791        occur_sn -> Int8,
792    }
793}
794
795diesel::table! {
796    use diesel::sql_types::*;
797    use crate::full_text_search::*;
798
799    user_profiles (id) {
800        id -> Int8,
801        user_id -> Text,
802        room_id -> Nullable<Text>,
803        display_name -> Nullable<Text>,
804        avatar_url -> Nullable<Text>,
805        blurhash -> Nullable<Text>,
806    }
807}
808
809diesel::table! {
810    use diesel::sql_types::*;
811    use crate::full_text_search::*;
812
813    user_refresh_tokens (id) {
814        id -> Int8,
815        user_id -> Text,
816        device_id -> Text,
817        token -> Text,
818        next_token_id -> Nullable<Int8>,
819        expired_at -> Nullable<Int8>,
820        ultimate_session_expired_at -> Nullable<Int8>,
821        created_at -> Int8,
822    }
823}
824
825diesel::table! {
826    use diesel::sql_types::*;
827    use crate::full_text_search::*;
828
829    user_registration_tokens (id) {
830        id -> Int8,
831        token -> Text,
832        uses_allowed -> Nullable<Int8>,
833        pending -> Int8,
834        completed -> Int8,
835        expired_at -> Nullable<Int8>,
836        created_at -> Int8,
837    }
838}
839
840diesel::table! {
841    use diesel::sql_types::*;
842    use crate::full_text_search::*;
843
844    user_sessions (id) {
845        id -> Int8,
846        user_id -> Text,
847        session_id -> Text,
848        session_type -> Text,
849        value -> Json,
850        expired_at -> Int8,
851        created_at -> Int8,
852    }
853}
854
855diesel::table! {
856    use diesel::sql_types::*;
857    use crate::full_text_search::*;
858
859    user_threepids (id) {
860        id -> Int8,
861        user_id -> Text,
862        medium -> Text,
863        address -> Text,
864        validated_at -> Int8,
865        added_at -> Int8,
866    }
867}
868
869diesel::table! {
870    use diesel::sql_types::*;
871    use crate::full_text_search::*;
872
873    user_uiaa_datas (id) {
874        id -> Int8,
875        user_id -> Text,
876        device_id -> Text,
877        session -> Text,
878        uiaa_info -> Json,
879    }
880}
881
882diesel::table! {
883    use diesel::sql_types::*;
884    use crate::full_text_search::*;
885
886    users (id) {
887        id -> Text,
888        ty -> Nullable<Text>,
889        is_admin -> Bool,
890        is_guest -> Bool,
891        appservice_id -> Nullable<Text>,
892        shadow_banned -> Bool,
893        consent_at -> Nullable<Int8>,
894        consent_version -> Nullable<Text>,
895        consent_server_notice_sent -> Nullable<Text>,
896        approved_at -> Nullable<Int8>,
897        approved_by -> Nullable<Text>,
898        deactivated_at -> Nullable<Int8>,
899        deactivated_by -> Nullable<Text>,
900        locked_at -> Nullable<Int8>,
901        locked_by -> Nullable<Text>,
902        created_at -> Int8,
903    }
904}
905
906diesel::allow_tables_to_appear_in_same_query!(
907    appservice_registrations,
908    device_inboxes,
909    device_streams,
910    e2e_cross_signing_keys,
911    e2e_cross_signing_sigs,
912    e2e_device_keys,
913    e2e_fallback_keys,
914    e2e_key_changes,
915    e2e_one_time_keys,
916    e2e_room_keys,
917    e2e_room_keys_versions,
918    event_auth_chains,
919    event_backward_extremities,
920    event_datas,
921    event_edges,
922    event_forward_extremities,
923    event_points,
924    event_push_summaries,
925    event_receipts,
926    event_relations,
927    event_searches,
928    event_txn_ids,
929    events,
930    lazy_load_deliveries,
931    media_metadatas,
932    media_thumbnails,
933    outgoing_requests,
934    pushers,
935    room_aliases,
936    room_servers,
937    room_state_deltas,
938    room_state_fields,
939    room_state_frames,
940    room_tags,
941    room_users,
942    rooms,
943    server_signing_keys,
944    stats_monthly_active_users,
945    stats_room_currents,
946    stats_user_daily_visits,
947    threads,
948    threepid_guests,
949    threepid_id_servers,
950    threepid_validation_sessions,
951    threepid_validation_tokens,
952    user_access_tokens,
953    user_datas,
954    user_dehydrated_devices,
955    user_devices,
956    user_filters,
957    user_ignores,
958    user_openid_tokens,
959    user_passwords,
960    user_presences,
961    user_profiles,
962    user_refresh_tokens,
963    user_registration_tokens,
964    user_sessions,
965    user_threepids,
966    user_uiaa_datas,
967    users,
968);