]> git.donarmstrong.com Git - debbugs.git/blob - sql/_source/deploy/1/001-auto.yml
727ee14f16036d54934339565b60cb964ae6ac25
[debbugs.git] / sql / _source / deploy / 1 / 001-auto.yml
1 ---
2 schema:
3   procedures: {}
4   tables:
5     arch:
6       constraints:
7         - deferrable: 1
8           expression: ''
9           fields:
10             - id
11           match_type: ''
12           name: ''
13           on_delete: ''
14           on_update: ''
15           options: []
16           reference_fields: []
17           reference_table: ''
18           type: PRIMARY KEY
19         - deferrable: 1
20           expression: ''
21           fields:
22             - arch
23           match_type: ''
24           name: arch_arch_key
25           on_delete: ''
26           on_update: ''
27           options: []
28           reference_fields: []
29           reference_table: ''
30           type: UNIQUE
31       fields:
32         arch:
33           data_type: text
34           default_value: ~
35           is_nullable: 0
36           is_primary_key: 0
37           is_unique: 1
38           name: arch
39           order: 2
40           size:
41             - 0
42         id:
43           data_type: integer
44           default_value: ~
45           is_auto_increment: 1
46           is_nullable: 0
47           is_primary_key: 1
48           is_unique: 0
49           name: id
50           order: 1
51           size:
52             - 0
53       indices: []
54       name: arch
55       options: []
56       order: 1
57     bin_associations:
58       constraints:
59         - deferrable: 1
60           expression: ''
61           fields:
62             - id
63           match_type: ''
64           name: ''
65           on_delete: ''
66           on_update: ''
67           options: []
68           reference_fields: []
69           reference_table: ''
70           type: PRIMARY KEY
71         - deferrable: 0
72           expression: ''
73           fields:
74             - bin
75           match_type: ''
76           name: bin_associations_fk_bin
77           on_delete: CASCADE
78           on_update: CASCADE
79           options: []
80           reference_fields:
81             - id
82           reference_table: bin_ver
83           type: FOREIGN KEY
84         - deferrable: 0
85           expression: ''
86           fields:
87             - suite
88           match_type: ''
89           name: bin_associations_fk_suite
90           on_delete: CASCADE
91           on_update: CASCADE
92           options: []
93           reference_fields:
94             - id
95           reference_table: suite
96           type: FOREIGN KEY
97       fields:
98         bin:
99           data_type: integer
100           default_value: ~
101           is_nullable: 0
102           is_primary_key: 0
103           is_unique: 0
104           name: bin
105           order: 3
106           size:
107             - 0
108         created:
109           data_type: timestamp with time zone
110           default_value: !!perl/ref
111             =: current_timestamp
112           is_nullable: 0
113           is_primary_key: 0
114           is_unique: 0
115           name: created
116           order: 4
117           size:
118             - 0
119         id:
120           data_type: integer
121           default_value: ~
122           is_auto_increment: 1
123           is_nullable: 0
124           is_primary_key: 1
125           is_unique: 0
126           name: id
127           order: 1
128           size:
129             - 0
130         modified:
131           data_type: timestamp with time zone
132           default_value: !!perl/ref
133             =: current_timestamp
134           is_nullable: 0
135           is_primary_key: 0
136           is_unique: 0
137           name: modified
138           order: 5
139           size:
140             - 0
141         suite:
142           data_type: integer
143           default_value: ~
144           is_nullable: 0
145           is_primary_key: 0
146           is_unique: 0
147           name: suite
148           order: 2
149           size:
150             - 0
151       indices:
152         - fields:
153             - bin
154           name: bin_associations_idx_bin
155           options: []
156           type: NORMAL
157         - fields:
158             - suite
159           name: bin_associations_idx_suite
160           options: []
161           type: NORMAL
162       name: bin_associations
163       options: []
164       order: 30
165     bin_pkg:
166       constraints:
167         - deferrable: 1
168           expression: ''
169           fields:
170             - id
171           match_type: ''
172           name: ''
173           on_delete: ''
174           on_update: ''
175           options: []
176           reference_fields: []
177           reference_table: ''
178           type: PRIMARY KEY
179         - deferrable: 1
180           expression: ''
181           fields:
182             - pkg
183           match_type: ''
184           name: bin_pkg_pkg_key
185           on_delete: ''
186           on_update: ''
187           options: []
188           reference_fields: []
189           reference_table: ''
190           type: UNIQUE
191       fields:
192         id:
193           data_type: integer
194           default_value: ~
195           is_auto_increment: 1
196           is_nullable: 0
197           is_primary_key: 1
198           is_unique: 0
199           name: id
200           order: 1
201           size:
202             - 0
203         pkg:
204           data_type: text
205           default_value: ~
206           is_nullable: 0
207           is_primary_key: 0
208           is_unique: 1
209           name: pkg
210           order: 2
211           size:
212             - 0
213       indices: []
214       name: bin_pkg
215       options: []
216       order: 2
217     bin_ver:
218       constraints:
219         - deferrable: 1
220           expression: ''
221           fields:
222             - id
223           match_type: ''
224           name: ''
225           on_delete: ''
226           on_update: ''
227           options: []
228           reference_fields: []
229           reference_table: ''
230           type: PRIMARY KEY
231         - deferrable: 0
232           expression: ''
233           fields:
234             - arch
235           match_type: ''
236           name: bin_ver_fk_arch
237           on_delete: CASCADE
238           on_update: CASCADE
239           options: []
240           reference_fields:
241             - id
242           reference_table: arch
243           type: FOREIGN KEY
244         - deferrable: 0
245           expression: ''
246           fields:
247             - bin_pkg
248           match_type: ''
249           name: bin_ver_fk_bin_pkg
250           on_delete: CASCADE
251           on_update: CASCADE
252           options: []
253           reference_fields:
254             - id
255           reference_table: bin_pkg
256           type: FOREIGN KEY
257         - deferrable: 0
258           expression: ''
259           fields:
260             - src_ver
261           match_type: ''
262           name: bin_ver_fk_src_ver
263           on_delete: CASCADE
264           on_update: CASCADE
265           options: []
266           reference_fields:
267             - id
268           reference_table: src_ver
269           type: FOREIGN KEY
270       fields:
271         arch:
272           data_type: integer
273           default_value: ~
274           is_nullable: 0
275           is_primary_key: 0
276           is_unique: 0
277           name: arch
278           order: 4
279           size:
280             - 0
281         bin_pkg:
282           data_type: integer
283           default_value: ~
284           is_nullable: 0
285           is_primary_key: 0
286           is_unique: 0
287           name: bin_pkg
288           order: 2
289           size:
290             - 0
291         id:
292           data_type: integer
293           default_value: ~
294           is_auto_increment: 1
295           is_nullable: 0
296           is_primary_key: 1
297           is_unique: 0
298           name: id
299           order: 1
300           size:
301             - 0
302         src_ver:
303           data_type: integer
304           default_value: ~
305           is_nullable: 0
306           is_primary_key: 0
307           is_unique: 0
308           name: src_ver
309           order: 3
310           size:
311             - 0
312         ver:
313           data_type: debversion
314           default_value: ~
315           is_nullable: 0
316           is_primary_key: 0
317           is_unique: 0
318           name: ver
319           order: 5
320           size:
321             - 0
322       indices:
323         - fields:
324             - arch
325           name: bin_ver_idx_arch
326           options: []
327           type: NORMAL
328         - fields:
329             - bin_pkg
330           name: bin_ver_idx_bin_pkg
331           options: []
332           type: NORMAL
333         - fields:
334             - src_ver
335           name: bin_ver_idx_src_ver
336           options: []
337           type: NORMAL
338       name: bin_ver
339       options: []
340       order: 28
341     binary_versions:
342       constraints: []
343       fields:
344         arch:
345           data_type: text
346           default_value: ~
347           is_nullable: 1
348           is_primary_key: 0
349           is_unique: 0
350           name: arch
351           order: 4
352           size:
353             - 0
354         bin_pkg:
355           data_type: text
356           default_value: ~
357           is_nullable: 1
358           is_primary_key: 0
359           is_unique: 0
360           name: bin_pkg
361           order: 3
362           size:
363             - 0
364         bin_ver:
365           data_type: debversion
366           default_value: ~
367           is_nullable: 1
368           is_primary_key: 0
369           is_unique: 0
370           name: bin_ver
371           order: 5
372           size:
373             - 0
374         src_pkg:
375           data_type: text
376           default_value: ~
377           is_nullable: 1
378           is_primary_key: 0
379           is_unique: 0
380           name: src_pkg
381           order: 1
382           size:
383             - 0
384         src_pkg_based_on:
385           data_type: text
386           default_value: ~
387           is_nullable: 1
388           is_primary_key: 0
389           is_unique: 0
390           name: src_pkg_based_on
391           order: 7
392           size:
393             - 0
394         src_ver:
395           data_type: debversion
396           default_value: ~
397           is_nullable: 1
398           is_primary_key: 0
399           is_unique: 0
400           name: src_ver
401           order: 2
402           size:
403             - 0
404         src_ver_based_on:
405           data_type: debversion
406           default_value: ~
407           is_nullable: 1
408           is_primary_key: 0
409           is_unique: 0
410           name: src_ver_based_on
411           order: 6
412           size:
413             - 0
414       indices: []
415       name: binary_versions
416       options: []
417       order: 3
418     bug:
419       constraints:
420         - deferrable: 1
421           expression: ''
422           fields:
423             - id
424           match_type: ''
425           name: ''
426           on_delete: ''
427           on_update: ''
428           options: []
429           reference_fields: []
430           reference_table: ''
431           type: PRIMARY KEY
432         - deferrable: 0
433           expression: ''
434           fields:
435             - done
436           match_type: ''
437           name: bug_fk_done
438           on_delete: NO ACTION
439           on_update: NO ACTION
440           options: []
441           reference_fields:
442             - id
443           reference_table: correspondent
444           type: FOREIGN KEY
445         - deferrable: 0
446           expression: ''
447           fields:
448             - owner
449           match_type: ''
450           name: bug_fk_owner
451           on_delete: NO ACTION
452           on_update: NO ACTION
453           options: []
454           reference_fields:
455             - id
456           reference_table: correspondent
457           type: FOREIGN KEY
458         - deferrable: 0
459           expression: ''
460           fields:
461             - severity
462           match_type: ''
463           name: bug_fk_severity
464           on_delete: NO ACTION
465           on_update: NO ACTION
466           options: []
467           reference_fields:
468             - id
469           reference_table: severity
470           type: FOREIGN KEY
471         - deferrable: 0
472           expression: ''
473           fields:
474             - submitter
475           match_type: ''
476           name: bug_fk_submitter
477           on_delete: NO ACTION
478           on_update: NO ACTION
479           options: []
480           reference_fields:
481             - id
482           reference_table: correspondent
483           type: FOREIGN KEY
484       fields:
485         archived:
486           data_type: boolean
487           default_value: !!perl/ref
488             =: false
489           is_nullable: 0
490           is_primary_key: 0
491           is_unique: 0
492           name: archived
493           order: 5
494           size:
495             - 0
496         creation:
497           data_type: timestamp with time zone
498           default_value: !!perl/ref
499             =: current_timestamp
500           is_nullable: 0
501           is_primary_key: 0
502           is_unique: 0
503           name: creation
504           order: 2
505           size:
506             - 0
507         done:
508           data_type: integer
509           default_value: ~
510           is_nullable: 1
511           is_primary_key: 0
512           is_unique: 0
513           name: done
514           order: 12
515           size:
516             - 0
517         done_full:
518           data_type: text
519           default_value: ''
520           is_nullable: 0
521           is_primary_key: 0
522           is_unique: 0
523           name: done_full
524           order: 13
525           size:
526             - 0
527         forwarded:
528           data_type: text
529           default_value: ''
530           is_nullable: 0
531           is_primary_key: 0
532           is_unique: 0
533           name: forwarded
534           order: 7
535           size:
536             - 0
537         id:
538           data_type: integer
539           default_value: ~
540           is_nullable: 0
541           is_primary_key: 1
542           is_unique: 0
543           name: id
544           order: 1
545           size:
546             - 0
547         last_modified:
548           data_type: timestamp with time zone
549           default_value: !!perl/ref
550             =: current_timestamp
551           is_nullable: 0
552           is_primary_key: 0
553           is_unique: 0
554           name: last_modified
555           order: 4
556           size:
557             - 0
558         log_modified:
559           data_type: timestamp with time zone
560           default_value: !!perl/ref
561             =: current_timestamp
562           is_nullable: 0
563           is_primary_key: 0
564           is_unique: 0
565           name: log_modified
566           order: 3
567           size:
568             - 0
569         outlook:
570           data_type: text
571           default_value: ''
572           is_nullable: 0
573           is_primary_key: 0
574           is_unique: 0
575           name: outlook
576           order: 9
577           size:
578             - 0
579         owner:
580           data_type: integer
581           default_value: ~
582           is_nullable: 1
583           is_primary_key: 0
584           is_unique: 0
585           name: owner
586           order: 14
587           size:
588             - 0
589         owner_full:
590           data_type: text
591           default_value: ''
592           is_nullable: 0
593           is_primary_key: 0
594           is_unique: 0
595           name: owner_full
596           order: 15
597           size:
598             - 0
599         severity:
600           data_type: integer
601           default_value: ~
602           is_nullable: 0
603           is_primary_key: 0
604           is_unique: 0
605           name: severity
606           order: 11
607           size:
608             - 0
609         subject:
610           data_type: text
611           default_value: ~
612           is_nullable: 0
613           is_primary_key: 0
614           is_unique: 0
615           name: subject
616           order: 10
617           size:
618             - 0
619         submitter:
620           data_type: integer
621           default_value: ~
622           is_nullable: 1
623           is_primary_key: 0
624           is_unique: 0
625           name: submitter
626           order: 16
627           size:
628             - 0
629         submitter_full:
630           data_type: text
631           default_value: ''
632           is_nullable: 0
633           is_primary_key: 0
634           is_unique: 0
635           name: submitter_full
636           order: 17
637           size:
638             - 0
639         summary:
640           data_type: text
641           default_value: ''
642           is_nullable: 0
643           is_primary_key: 0
644           is_unique: 0
645           name: summary
646           order: 8
647           size:
648             - 0
649         unarchived:
650           data_type: timestamp with time zone
651           default_value: ~
652           is_nullable: 1
653           is_primary_key: 0
654           is_unique: 0
655           name: unarchived
656           order: 6
657           size:
658             - 0
659         unknown_packages:
660           data_type: text
661           default_value: ''
662           is_nullable: 0
663           is_primary_key: 0
664           is_unique: 0
665           name: unknown_packages
666           order: 18
667           size:
668             - 0
669       indices:
670         - fields:
671             - done
672           name: bug_idx_done
673           options: []
674           type: NORMAL
675         - fields:
676             - owner
677           name: bug_idx_owner
678           options: []
679           type: NORMAL
680         - fields:
681             - severity
682           name: bug_idx_severity
683           options: []
684           type: NORMAL
685         - fields:
686             - submitter
687           name: bug_idx_submitter
688           options: []
689           type: NORMAL
690       name: bug
691       options: []
692       order: 17
693     bug_binpackage:
694       constraints:
695         - deferrable: 1
696           expression: ''
697           fields:
698             - id
699           match_type: ''
700           name: ''
701           on_delete: ''
702           on_update: ''
703           options: []
704           reference_fields: []
705           reference_table: ''
706           type: PRIMARY KEY
707         - deferrable: 1
708           expression: ''
709           fields:
710             - bug
711             - bin_pkg
712           match_type: ''
713           name: bug_binpackage_id_pkg
714           on_delete: ''
715           on_update: ''
716           options: []
717           reference_fields: []
718           reference_table: ''
719           type: UNIQUE
720         - deferrable: 0
721           expression: ''
722           fields:
723             - bin_pkg
724           match_type: ''
725           name: bug_binpackage_fk_bin_pkg
726           on_delete: NO ACTION
727           on_update: NO ACTION
728           options: []
729           reference_fields:
730             - id
731           reference_table: bin_pkg
732           type: FOREIGN KEY
733         - deferrable: 0
734           expression: ''
735           fields:
736             - bug
737           match_type: ''
738           name: bug_binpackage_fk_bug
739           on_delete: NO ACTION
740           on_update: NO ACTION
741           options: []
742           reference_fields:
743             - id
744           reference_table: bug
745           type: FOREIGN KEY
746       fields:
747         bin_pkg:
748           data_type: integer
749           default_value: ~
750           is_nullable: 0
751           is_primary_key: 0
752           is_unique: 1
753           name: bin_pkg
754           order: 3
755           size:
756             - 0
757         bug:
758           data_type: integer
759           default_value: ~
760           is_nullable: 0
761           is_primary_key: 0
762           is_unique: 1
763           name: bug
764           order: 2
765           size:
766             - 0
767         id:
768           data_type: integer
769           default_value: ~
770           is_auto_increment: 1
771           is_nullable: 0
772           is_primary_key: 1
773           is_unique: 0
774           name: id
775           order: 1
776           size:
777             - 0
778       indices:
779         - fields:
780             - bin_pkg
781           name: bug_binpackage_idx_bin_pkg
782           options: []
783           type: NORMAL
784         - fields:
785             - bug
786           name: bug_binpackage_idx_bug
787           options: []
788           type: NORMAL
789       name: bug_binpackage
790       options: []
791       order: 22
792     bug_blocks:
793       constraints:
794         - deferrable: 1
795           expression: ''
796           fields:
797             - id
798           match_type: ''
799           name: ''
800           on_delete: ''
801           on_update: ''
802           options: []
803           reference_fields: []
804           reference_table: ''
805           type: PRIMARY KEY
806         - deferrable: 1
807           expression: ''
808           fields:
809             - bug
810             - blocks
811           match_type: ''
812           name: bug_blocks_bug_id_blocks_idx
813           on_delete: ''
814           on_update: ''
815           options: []
816           reference_fields: []
817           reference_table: ''
818           type: UNIQUE
819         - deferrable: 0
820           expression: ''
821           fields:
822             - blocks
823           match_type: ''
824           name: bug_blocks_fk_blocks
825           on_delete: NO ACTION
826           on_update: NO ACTION
827           options: []
828           reference_fields:
829             - id
830           reference_table: bug
831           type: FOREIGN KEY
832         - deferrable: 0
833           expression: ''
834           fields:
835             - bug
836           match_type: ''
837           name: bug_blocks_fk_bug
838           on_delete: NO ACTION
839           on_update: NO ACTION
840           options: []
841           reference_fields:
842             - id
843           reference_table: bug
844           type: FOREIGN KEY
845       fields:
846         blocks:
847           data_type: integer
848           default_value: ~
849           is_nullable: 0
850           is_primary_key: 0
851           is_unique: 1
852           name: blocks
853           order: 3
854           size:
855             - 0
856         bug:
857           data_type: integer
858           default_value: ~
859           is_nullable: 0
860           is_primary_key: 0
861           is_unique: 1
862           name: bug
863           order: 2
864           size:
865             - 0
866         id:
867           data_type: integer
868           default_value: ~
869           is_auto_increment: 1
870           is_nullable: 0
871           is_primary_key: 1
872           is_unique: 0
873           name: id
874           order: 1
875           size:
876             - 0
877       indices:
878         - fields:
879             - blocks
880           name: bug_blocks_idx_blocks
881           options: []
882           type: NORMAL
883         - fields:
884             - bug
885           name: bug_blocks_idx_bug
886           options: []
887           type: NORMAL
888       name: bug_blocks
889       options: []
890       order: 19
891     bug_merged:
892       constraints:
893         - deferrable: 1
894           expression: ''
895           fields:
896             - id
897           match_type: ''
898           name: ''
899           on_delete: ''
900           on_update: ''
901           options: []
902           reference_fields: []
903           reference_table: ''
904           type: PRIMARY KEY
905         - deferrable: 1
906           expression: ''
907           fields:
908             - bug
909             - merged
910           match_type: ''
911           name: bug_merged_bug_id_merged_idx
912           on_delete: ''
913           on_update: ''
914           options: []
915           reference_fields: []
916           reference_table: ''
917           type: UNIQUE
918         - deferrable: 0
919           expression: ''
920           fields:
921             - bug
922           match_type: ''
923           name: bug_merged_fk_bug
924           on_delete: NO ACTION
925           on_update: NO ACTION
926           options: []
927           reference_fields:
928             - id
929           reference_table: bug
930           type: FOREIGN KEY
931         - deferrable: 0
932           expression: ''
933           fields:
934             - merged
935           match_type: ''
936           name: bug_merged_fk_merged
937           on_delete: NO ACTION
938           on_update: NO ACTION
939           options: []
940           reference_fields:
941             - id
942           reference_table: bug
943           type: FOREIGN KEY
944       fields:
945         bug:
946           data_type: integer
947           default_value: ~
948           is_nullable: 0
949           is_primary_key: 0
950           is_unique: 1
951           name: bug
952           order: 2
953           size:
954             - 0
955         id:
956           data_type: integer
957           default_value: ~
958           is_auto_increment: 1
959           is_nullable: 0
960           is_primary_key: 1
961           is_unique: 0
962           name: id
963           order: 1
964           size:
965             - 0
966         merged:
967           data_type: integer
968           default_value: ~
969           is_nullable: 0
970           is_primary_key: 0
971           is_unique: 1
972           name: merged
973           order: 3
974           size:
975             - 0
976       indices:
977         - fields:
978             - bug
979           name: bug_merged_idx_bug
980           options: []
981           type: NORMAL
982         - fields:
983             - merged
984           name: bug_merged_idx_merged
985           options: []
986           type: NORMAL
987       name: bug_merged
988       options: []
989       order: 20
990     bug_message:
991       constraints:
992         - deferrable: 1
993           expression: ''
994           fields:
995             - id
996           match_type: ''
997           name: ''
998           on_delete: ''
999           on_update: ''
1000           options: []
1001           reference_fields: []
1002           reference_table: ''
1003           type: PRIMARY KEY
1004         - deferrable: 1
1005           expression: ''
1006           fields:
1007             - bug
1008             - message
1009           match_type: ''
1010           name: bug_message_bug_message_idx
1011           on_delete: ''
1012           on_update: ''
1013           options: []
1014           reference_fields: []
1015           reference_table: ''
1016           type: UNIQUE
1017         - deferrable: 0
1018           expression: ''
1019           fields:
1020             - bug
1021           match_type: ''
1022           name: bug_message_fk_bug
1023           on_delete: CASCADE
1024           on_update: CASCADE
1025           options: []
1026           reference_fields:
1027             - id
1028           reference_table: bug
1029           type: FOREIGN KEY
1030         - deferrable: 0
1031           expression: ''
1032           fields:
1033             - message
1034           match_type: ''
1035           name: bug_message_fk_message
1036           on_delete: CASCADE
1037           on_update: CASCADE
1038           options: []
1039           reference_fields:
1040             - id
1041           reference_table: message
1042           type: FOREIGN KEY
1043       fields:
1044         bug:
1045           data_type: integer
1046           default_value: ~
1047           is_nullable: 0
1048           is_primary_key: 0
1049           is_unique: 1
1050           name: bug
1051           order: 2
1052           size:
1053             - 0
1054         bug_log_offset:
1055           data_type: integer
1056           default_value: ~
1057           is_nullable: 1
1058           is_primary_key: 0
1059           is_unique: 0
1060           name: bug_log_offset
1061           order: 5
1062           size:
1063             - 0
1064         id:
1065           data_type: integer
1066           default_value: ~
1067           is_auto_increment: 1
1068           is_nullable: 0
1069           is_primary_key: 1
1070           is_unique: 0
1071           name: id
1072           order: 1
1073           size:
1074             - 0
1075         message:
1076           data_type: integer
1077           default_value: ~
1078           is_nullable: 0
1079           is_primary_key: 0
1080           is_unique: 1
1081           name: message
1082           order: 3
1083           size:
1084             - 0
1085         message_number:
1086           data_type: integer
1087           default_value: ~
1088           is_nullable: 0
1089           is_primary_key: 0
1090           is_unique: 0
1091           name: message_number
1092           order: 4
1093           size:
1094             - 0
1095         offset_valid:
1096           data_type: timestamp with time zone
1097           default_value: ~
1098           is_nullable: 1
1099           is_primary_key: 0
1100           is_unique: 0
1101           name: offset_valid
1102           order: 6
1103           size:
1104             - 0
1105       indices:
1106         - fields:
1107             - bug
1108           name: bug_message_idx_bug
1109           options: []
1110           type: NORMAL
1111         - fields:
1112             - message
1113           name: bug_message_idx_message
1114           options: []
1115           type: NORMAL
1116       name: bug_message
1117       options: []
1118       order: 23
1119     bug_package:
1120       constraints: []
1121       fields:
1122         bug:
1123           data_type: integer
1124           default_value: ~
1125           is_nullable: 1
1126           is_primary_key: 0
1127           is_unique: 0
1128           name: bug
1129           order: 1
1130           size:
1131             - 0
1132         package:
1133           data_type: text
1134           default_value: ~
1135           is_nullable: 1
1136           is_primary_key: 0
1137           is_unique: 0
1138           name: package
1139           order: 4
1140           size:
1141             - 0
1142         pkg_id:
1143           data_type: integer
1144           default_value: ~
1145           is_nullable: 1
1146           is_primary_key: 0
1147           is_unique: 0
1148           name: pkg_id
1149           order: 2
1150           size:
1151             - 0
1152         pkg_type:
1153           data_type: text
1154           default_value: ~
1155           is_nullable: 1
1156           is_primary_key: 0
1157           is_unique: 0
1158           name: pkg_type
1159           order: 3
1160           size:
1161             - 0
1162       indices: []
1163       name: bug_package
1164       options: []
1165       order: 4
1166     bug_srcpackage:
1167       constraints:
1168         - deferrable: 1
1169           expression: ''
1170           fields:
1171             - id
1172           match_type: ''
1173           name: ''
1174           on_delete: ''
1175           on_update: ''
1176           options: []
1177           reference_fields: []
1178           reference_table: ''
1179           type: PRIMARY KEY
1180         - deferrable: 1
1181           expression: ''
1182           fields:
1183             - bug
1184             - src_pkg
1185           match_type: ''
1186           name: bug_srcpackage_id_pkg
1187           on_delete: ''
1188           on_update: ''
1189           options: []
1190           reference_fields: []
1191           reference_table: ''
1192           type: UNIQUE
1193         - deferrable: 0
1194           expression: ''
1195           fields:
1196             - bug
1197           match_type: ''
1198           name: bug_srcpackage_fk_bug
1199           on_delete: NO ACTION
1200           on_update: NO ACTION
1201           options: []
1202           reference_fields:
1203             - id
1204           reference_table: bug
1205           type: FOREIGN KEY
1206         - deferrable: 0
1207           expression: ''
1208           fields:
1209             - src_pkg
1210           match_type: ''
1211           name: bug_srcpackage_fk_src_pkg
1212           on_delete: CASCADE
1213           on_update: CASCADE
1214           options: []
1215           reference_fields:
1216             - id
1217           reference_table: src_pkg
1218           type: FOREIGN KEY
1219       fields:
1220         bug:
1221           data_type: integer
1222           default_value: ~
1223           is_nullable: 0
1224           is_primary_key: 0
1225           is_unique: 1
1226           name: bug
1227           order: 2
1228           size:
1229             - 0
1230         id:
1231           data_type: integer
1232           default_value: ~
1233           is_auto_increment: 1
1234           is_nullable: 0
1235           is_primary_key: 1
1236           is_unique: 0
1237           name: id
1238           order: 1
1239           size:
1240             - 0
1241         src_pkg:
1242           data_type: integer
1243           default_value: ~
1244           is_nullable: 0
1245           is_primary_key: 0
1246           is_unique: 1
1247           name: src_pkg
1248           order: 3
1249           size:
1250             - 0
1251       indices:
1252         - fields:
1253             - bug
1254           name: bug_srcpackage_idx_bug
1255           options: []
1256           type: NORMAL
1257         - fields:
1258             - src_pkg
1259           name: bug_srcpackage_idx_src_pkg
1260           options: []
1261           type: NORMAL
1262       name: bug_srcpackage
1263       options: []
1264       order: 24
1265     bug_status_cache:
1266       constraints:
1267         - deferrable: 1
1268           expression: ''
1269           fields:
1270             - id
1271           match_type: ''
1272           name: ''
1273           on_delete: ''
1274           on_update: ''
1275           options: []
1276           reference_fields: []
1277           reference_table: ''
1278           type: PRIMARY KEY
1279         - deferrable: 1
1280           expression: ''
1281           fields:
1282             - bug
1283             - suite
1284             - arch
1285           match_type: ''
1286           name: bug_status_cache_bug_suite_arch_idx
1287           on_delete: ''
1288           on_update: ''
1289           options: []
1290           reference_fields: []
1291           reference_table: ''
1292           type: UNIQUE
1293         - deferrable: 0
1294           expression: ''
1295           fields:
1296             - arch
1297           match_type: ''
1298           name: bug_status_cache_fk_arch
1299           on_delete: CASCADE
1300           on_update: CASCADE
1301           options: []
1302           reference_fields:
1303             - id
1304           reference_table: arch
1305           type: FOREIGN KEY
1306         - deferrable: 0
1307           expression: ''
1308           fields:
1309             - bug
1310           match_type: ''
1311           name: bug_status_cache_fk_bug
1312           on_delete: CASCADE
1313           on_update: CASCADE
1314           options: []
1315           reference_fields:
1316             - id
1317           reference_table: bug
1318           type: FOREIGN KEY
1319         - deferrable: 0
1320           expression: ''
1321           fields:
1322             - suite
1323           match_type: ''
1324           name: bug_status_cache_fk_suite
1325           on_delete: CASCADE
1326           on_update: CASCADE
1327           options: []
1328           reference_fields:
1329             - id
1330           reference_table: suite
1331           type: FOREIGN KEY
1332       fields:
1333         arch:
1334           data_type: integer
1335           default_value: ~
1336           is_nullable: 1
1337           is_primary_key: 0
1338           is_unique: 1
1339           name: arch
1340           order: 4
1341           size:
1342             - 0
1343         asof:
1344           data_type: timestamp with time zone
1345           default_value: !!perl/ref
1346             =: current_timestamp
1347           is_nullable: 0
1348           is_primary_key: 0
1349           is_unique: 0
1350           name: asof
1351           order: 7
1352           size:
1353             - 0
1354         bug:
1355           data_type: integer
1356           default_value: ~
1357           is_nullable: 0
1358           is_primary_key: 0
1359           is_unique: 1
1360           name: bug
1361           order: 2
1362           size:
1363             - 0
1364         id:
1365           data_type: integer
1366           default_value: ~
1367           is_auto_increment: 1
1368           is_nullable: 0
1369           is_primary_key: 1
1370           is_unique: 0
1371           name: id
1372           order: 1
1373           size:
1374             - 0
1375         modified:
1376           data_type: timestamp with time zone
1377           default_value: !!perl/ref
1378             =: current_timestamp
1379           is_nullable: 0
1380           is_primary_key: 0
1381           is_unique: 0
1382           name: modified
1383           order: 6
1384           size:
1385             - 0
1386         status:
1387           data_type: enum
1388           default_value: ~
1389           extra:
1390             custom_type_name: bug_status_type
1391             list:
1392               - pending
1393               - forwarded
1394               - pending-fixed
1395               - fixed
1396               - absent
1397               - done
1398           is_nullable: 0
1399           is_primary_key: 0
1400           is_unique: 0
1401           name: status
1402           order: 5
1403           size:
1404             - 0
1405         suite:
1406           data_type: integer
1407           default_value: ~
1408           is_nullable: 1
1409           is_primary_key: 0
1410           is_unique: 1
1411           name: suite
1412           order: 3
1413           size:
1414             - 0
1415       indices:
1416         - fields:
1417             - arch
1418           name: bug_status_cache_idx_arch
1419           options: []
1420           type: NORMAL
1421         - fields:
1422             - bug
1423           name: bug_status_cache_idx_bug
1424           options: []
1425           type: NORMAL
1426         - fields:
1427             - suite
1428           name: bug_status_cache_idx_suite
1429           options: []
1430           type: NORMAL
1431       name: bug_status_cache
1432       options: []
1433       order: 26
1434     bug_tag:
1435       constraints:
1436         - deferrable: 1
1437           expression: ''
1438           fields:
1439             - id
1440           match_type: ''
1441           name: ''
1442           on_delete: ''
1443           on_update: ''
1444           options: []
1445           reference_fields: []
1446           reference_table: ''
1447           type: PRIMARY KEY
1448         - deferrable: 1
1449           expression: ''
1450           fields:
1451             - bug
1452             - tag
1453           match_type: ''
1454           name: bug_tag_bug_tag
1455           on_delete: ''
1456           on_update: ''
1457           options: []
1458           reference_fields: []
1459           reference_table: ''
1460           type: UNIQUE
1461         - deferrable: 0
1462           expression: ''
1463           fields:
1464             - bug
1465           match_type: ''
1466           name: bug_tag_fk_bug
1467           on_delete: NO ACTION
1468           on_update: NO ACTION
1469           options: []
1470           reference_fields:
1471             - id
1472           reference_table: bug
1473           type: FOREIGN KEY
1474         - deferrable: 0
1475           expression: ''
1476           fields:
1477             - tag
1478           match_type: ''
1479           name: bug_tag_fk_tag
1480           on_delete: NO ACTION
1481           on_update: NO ACTION
1482           options: []
1483           reference_fields:
1484             - id
1485           reference_table: tag
1486           type: FOREIGN KEY
1487       fields:
1488         bug:
1489           data_type: integer
1490           default_value: ~
1491           is_nullable: 0
1492           is_primary_key: 0
1493           is_unique: 1
1494           name: bug
1495           order: 2
1496           size:
1497             - 0
1498         id:
1499           data_type: integer
1500           default_value: ~
1501           is_auto_increment: 1
1502           is_nullable: 0
1503           is_primary_key: 1
1504           is_unique: 0
1505           name: id
1506           order: 1
1507           size:
1508             - 0
1509         tag:
1510           data_type: integer
1511           default_value: ~
1512           is_nullable: 0
1513           is_primary_key: 0
1514           is_unique: 1
1515           name: tag
1516           order: 3
1517           size:
1518             - 0
1519       indices:
1520         - fields:
1521             - bug
1522           name: bug_tag_idx_bug
1523           options: []
1524           type: NORMAL
1525         - fields:
1526             - tag
1527           name: bug_tag_idx_tag
1528           options: []
1529           type: NORMAL
1530       name: bug_tag
1531       options: []
1532       order: 25
1533     bug_ver:
1534       constraints:
1535         - deferrable: 1
1536           expression: ''
1537           fields:
1538             - id
1539           match_type: ''
1540           name: ''
1541           on_delete: ''
1542           on_update: ''
1543           options: []
1544           reference_fields: []
1545           reference_table: ''
1546           type: PRIMARY KEY
1547         - deferrable: 1
1548           expression: ''
1549           fields:
1550             - bug
1551             - ver_string
1552             - found
1553           match_type: ''
1554           name: bug_ver_bug_ver_string_found_idx
1555           on_delete: ''
1556           on_update: ''
1557           options: []
1558           reference_fields: []
1559           reference_table: ''
1560           type: UNIQUE
1561         - deferrable: 0
1562           expression: ''
1563           fields:
1564             - bug
1565           match_type: ''
1566           name: bug_ver_fk_bug
1567           on_delete: RESTRICT
1568           on_update: CASCADE
1569           options: []
1570           reference_fields:
1571             - id
1572           reference_table: bug
1573           type: FOREIGN KEY
1574         - deferrable: 0
1575           expression: ''
1576           fields:
1577             - src_pkg
1578           match_type: ''
1579           name: bug_ver_fk_src_pkg
1580           on_delete: SET NULL
1581           on_update: CASCADE
1582           options: []
1583           reference_fields:
1584             - id
1585           reference_table: src_pkg
1586           type: FOREIGN KEY
1587         - deferrable: 0
1588           expression: ''
1589           fields:
1590             - src_ver
1591           match_type: ''
1592           name: bug_ver_fk_src_ver
1593           on_delete: SET NULL
1594           on_update: CASCADE
1595           options: []
1596           reference_fields:
1597             - id
1598           reference_table: src_ver
1599           type: FOREIGN KEY
1600       fields:
1601         bug:
1602           data_type: integer
1603           default_value: ~
1604           is_nullable: 0
1605           is_primary_key: 0
1606           is_unique: 1
1607           name: bug
1608           order: 2
1609           size:
1610             - 0
1611         creation:
1612           data_type: timestamp with time zone
1613           default_value: !!perl/ref
1614             =: current_timestamp
1615           is_nullable: 0
1616           is_primary_key: 0
1617           is_unique: 0
1618           name: creation
1619           order: 7
1620           size:
1621             - 0
1622         found:
1623           data_type: boolean
1624           default_value: !!perl/ref
1625             =: true
1626           is_nullable: 0
1627           is_primary_key: 0
1628           is_unique: 1
1629           name: found
1630           order: 6
1631           size:
1632             - 0
1633         id:
1634           data_type: integer
1635           default_value: ~
1636           is_auto_increment: 1
1637           is_nullable: 0
1638           is_primary_key: 1
1639           is_unique: 0
1640           name: id
1641           order: 1
1642           size:
1643             - 0
1644         last_modified:
1645           data_type: timestamp with time zone
1646           default_value: !!perl/ref
1647             =: current_timestamp
1648           is_nullable: 0
1649           is_primary_key: 0
1650           is_unique: 0
1651           name: last_modified
1652           order: 8
1653           size:
1654             - 0
1655         src_pkg:
1656           data_type: integer
1657           default_value: ~
1658           is_nullable: 1
1659           is_primary_key: 0
1660           is_unique: 0
1661           name: src_pkg
1662           order: 4
1663           size:
1664             - 0
1665         src_ver:
1666           data_type: integer
1667           default_value: ~
1668           is_nullable: 1
1669           is_primary_key: 0
1670           is_unique: 0
1671           name: src_ver
1672           order: 5
1673           size:
1674             - 0
1675         ver_string:
1676           data_type: text
1677           default_value: ~
1678           is_nullable: 1
1679           is_primary_key: 0
1680           is_unique: 1
1681           name: ver_string
1682           order: 3
1683           size:
1684             - 0
1685       indices:
1686         - fields:
1687             - bug
1688           name: bug_ver_idx_bug
1689           options: []
1690           type: NORMAL
1691         - fields:
1692             - src_pkg
1693           name: bug_ver_idx_src_pkg
1694           options: []
1695           type: NORMAL
1696         - fields:
1697             - src_ver
1698           name: bug_ver_idx_src_ver
1699           options: []
1700           type: NORMAL
1701       name: bug_ver
1702       options: []
1703       order: 29
1704     column_comments:
1705       constraints:
1706         - deferrable: 1
1707           expression: ''
1708           fields:
1709             - table_name
1710             - column_name
1711           match_type: ''
1712           name: column_comments_table_name_column_name_idx
1713           on_delete: ''
1714           on_update: ''
1715           options: []
1716           reference_fields: []
1717           reference_table: ''
1718           type: UNIQUE
1719       fields:
1720         column_name:
1721           data_type: text
1722           default_value: ~
1723           is_nullable: 0
1724           is_primary_key: 0
1725           is_unique: 1
1726           name: column_name
1727           order: 2
1728           size:
1729             - 0
1730         comment_text:
1731           data_type: text
1732           default_value: ~
1733           is_nullable: 0
1734           is_primary_key: 0
1735           is_unique: 0
1736           name: comment_text
1737           order: 3
1738           size:
1739             - 0
1740         table_name:
1741           data_type: text
1742           default_value: ~
1743           is_nullable: 0
1744           is_primary_key: 0
1745           is_unique: 1
1746           name: table_name
1747           order: 1
1748           size:
1749             - 0
1750       indices: []
1751       name: column_comments
1752       options: []
1753       order: 5
1754     correspondent:
1755       constraints:
1756         - deferrable: 1
1757           expression: ''
1758           fields:
1759             - id
1760           match_type: ''
1761           name: ''
1762           on_delete: ''
1763           on_update: ''
1764           options: []
1765           reference_fields: []
1766           reference_table: ''
1767           type: PRIMARY KEY
1768         - deferrable: 1
1769           expression: ''
1770           fields:
1771             - addr
1772           match_type: ''
1773           name: correspondent_addr_idx
1774           on_delete: ''
1775           on_update: ''
1776           options: []
1777           reference_fields: []
1778           reference_table: ''
1779           type: UNIQUE
1780       fields:
1781         addr:
1782           data_type: text
1783           default_value: ~
1784           is_nullable: 0
1785           is_primary_key: 0
1786           is_unique: 1
1787           name: addr
1788           order: 2
1789           size:
1790             - 0
1791         id:
1792           data_type: integer
1793           default_value: ~
1794           is_auto_increment: 1
1795           is_nullable: 0
1796           is_primary_key: 1
1797           is_unique: 0
1798           name: id
1799           order: 1
1800           size:
1801             - 0
1802       indices: []
1803       name: correspondent
1804       options: []
1805       order: 6
1806     correspondent_full_name:
1807       constraints:
1808         - deferrable: 1
1809           expression: ''
1810           fields:
1811             - id
1812           match_type: ''
1813           name: ''
1814           on_delete: ''
1815           on_update: ''
1816           options: []
1817           reference_fields: []
1818           reference_table: ''
1819           type: PRIMARY KEY
1820         - deferrable: 1
1821           expression: ''
1822           fields:
1823             - correspondent
1824             - full_name
1825           match_type: ''
1826           name: correspondent_full_name_correspondent_full_name_idx
1827           on_delete: ''
1828           on_update: ''
1829           options: []
1830           reference_fields: []
1831           reference_table: ''
1832           type: UNIQUE
1833         - deferrable: 0
1834           expression: ''
1835           fields:
1836             - correspondent
1837           match_type: ''
1838           name: correspondent_full_name_fk_correspondent
1839           on_delete: CASCADE
1840           on_update: CASCADE
1841           options: []
1842           reference_fields:
1843             - id
1844           reference_table: correspondent
1845           type: FOREIGN KEY
1846       fields:
1847         correspondent:
1848           data_type: integer
1849           default_value: ~
1850           is_nullable: 0
1851           is_primary_key: 0
1852           is_unique: 1
1853           name: correspondent
1854           order: 2
1855           size:
1856             - 0
1857         full_name:
1858           data_type: text
1859           default_value: ~
1860           is_nullable: 0
1861           is_primary_key: 0
1862           is_unique: 1
1863           name: full_name
1864           order: 3
1865           size:
1866             - 0
1867         id:
1868           data_type: integer
1869           default_value: ~
1870           is_auto_increment: 1
1871           is_nullable: 0
1872           is_primary_key: 1
1873           is_unique: 0
1874           name: id
1875           order: 1
1876           size:
1877             - 0
1878         last_seen:
1879           data_type: timestamp
1880           default_value: !!perl/ref
1881             =: current_timestamp
1882           is_nullable: 0
1883           is_primary_key: 0
1884           is_unique: 0
1885           name: last_seen
1886           order: 4
1887           size:
1888             - 0
1889       indices:
1890         - fields:
1891             - correspondent
1892           name: correspondent_full_name_idx_correspondent
1893           options: []
1894           type: NORMAL
1895       name: correspondent_full_name
1896       options: []
1897       order: 14
1898     dbix_class_deploymenthandler_versions:
1899       constraints:
1900         - deferrable: 1
1901           expression: ''
1902           fields:
1903             - id
1904           match_type: ''
1905           name: ''
1906           on_delete: ''
1907           on_update: ''
1908           options: []
1909           reference_fields: []
1910           reference_table: ''
1911           type: PRIMARY KEY
1912         - deferrable: 1
1913           expression: ''
1914           fields:
1915             - version
1916           match_type: ''
1917           name: dbix_class_deploymenthandler_versions_version
1918           on_delete: ''
1919           on_update: ''
1920           options: []
1921           reference_fields: []
1922           reference_table: ''
1923           type: UNIQUE
1924       fields:
1925         ddl:
1926           data_type: text
1927           default_value: ~
1928           is_nullable: 1
1929           is_primary_key: 0
1930           is_unique: 0
1931           name: ddl
1932           order: 3
1933           size:
1934             - 0
1935         id:
1936           data_type: integer
1937           default_value: ~
1938           is_auto_increment: 1
1939           is_nullable: 0
1940           is_primary_key: 1
1941           is_unique: 0
1942           name: id
1943           order: 1
1944           size:
1945             - 0
1946         upgrade_sql:
1947           data_type: text
1948           default_value: ~
1949           is_nullable: 1
1950           is_primary_key: 0
1951           is_unique: 0
1952           name: upgrade_sql
1953           order: 4
1954           size:
1955             - 0
1956         version:
1957           data_type: varchar
1958           default_value: ~
1959           is_nullable: 0
1960           is_primary_key: 0
1961           is_unique: 1
1962           name: version
1963           order: 2
1964           size:
1965             - 50
1966       indices: []
1967       name: dbix_class_deploymenthandler_versions
1968       options: []
1969       order: 7
1970     maintainer:
1971       constraints:
1972         - deferrable: 1
1973           expression: ''
1974           fields:
1975             - id
1976           match_type: ''
1977           name: ''
1978           on_delete: ''
1979           on_update: ''
1980           options: []
1981           reference_fields: []
1982           reference_table: ''
1983           type: PRIMARY KEY
1984         - deferrable: 1
1985           expression: ''
1986           fields:
1987             - name
1988           match_type: ''
1989           name: maintainer_name_idx
1990           on_delete: ''
1991           on_update: ''
1992           options: []
1993           reference_fields: []
1994           reference_table: ''
1995           type: UNIQUE
1996         - deferrable: 0
1997           expression: ''
1998           fields:
1999             - correspondent
2000           match_type: ''
2001           name: maintainer_fk_correspondent
2002           on_delete: NO ACTION
2003           on_update: NO ACTION
2004           options: []
2005           reference_fields:
2006             - id
2007           reference_table: correspondent
2008           type: FOREIGN KEY
2009       fields:
2010         correspondent:
2011           data_type: integer
2012           default_value: ~
2013           is_nullable: 0
2014           is_primary_key: 0
2015           is_unique: 0
2016           name: correspondent
2017           order: 3
2018           size:
2019             - 0
2020         created:
2021           data_type: timestamp with time zone
2022           default_value: !!perl/ref
2023             =: current_timestamp
2024           is_nullable: 0
2025           is_primary_key: 0
2026           is_unique: 0
2027           name: created
2028           order: 4
2029           size:
2030             - 0
2031         id:
2032           data_type: integer
2033           default_value: ~
2034           is_auto_increment: 1
2035           is_nullable: 0
2036           is_primary_key: 1
2037           is_unique: 0
2038           name: id
2039           order: 1
2040           size:
2041             - 0
2042         modified:
2043           data_type: timestamp with time zone
2044           default_value: !!perl/ref
2045             =: current_timestamp
2046           is_nullable: 0
2047           is_primary_key: 0
2048           is_unique: 0
2049           name: modified
2050           order: 5
2051           size:
2052             - 0
2053         name:
2054           data_type: text
2055           default_value: ~
2056           is_nullable: 0
2057           is_primary_key: 0
2058           is_unique: 1
2059           name: name
2060           order: 2
2061           size:
2062             - 0
2063       indices:
2064         - fields:
2065             - correspondent
2066           name: maintainer_idx_correspondent
2067           options: []
2068           type: NORMAL
2069       name: maintainer
2070       options: []
2071       order: 15
2072     message:
2073       constraints:
2074         - deferrable: 1
2075           expression: ''
2076           fields:
2077             - id
2078           match_type: ''
2079           name: ''
2080           on_delete: ''
2081           on_update: ''
2082           options: []
2083           reference_fields: []
2084           reference_table: ''
2085           type: PRIMARY KEY
2086       fields:
2087         from_addr:
2088           data_type: text
2089           default_value: ~
2090           is_nullable: 1
2091           is_primary_key: 0
2092           is_unique: 0
2093           name: from_addr
2094           order: 4
2095           size:
2096             - 0
2097         from_complete:
2098           data_type: text
2099           default_value: ~
2100           is_nullable: 1
2101           is_primary_key: 0
2102           is_unique: 0
2103           name: from_complete
2104           order: 3
2105           size:
2106             - 0
2107         id:
2108           data_type: integer
2109           default_value: ~
2110           is_auto_increment: 1
2111           is_nullable: 0
2112           is_primary_key: 1
2113           is_unique: 0
2114           name: id
2115           order: 1
2116           size:
2117             - 0
2118         is_spam:
2119           data_type: boolean
2120           default_value: !!perl/ref
2121             =: false
2122           is_nullable: 1
2123           is_primary_key: 0
2124           is_unique: 0
2125           name: is_spam
2126           order: 11
2127           size:
2128             - 0
2129         msgid:
2130           data_type: text
2131           default_value: ~
2132           is_nullable: 1
2133           is_primary_key: 0
2134           is_unique: 0
2135           name: msgid
2136           order: 2
2137           size:
2138             - 0
2139         refs:
2140           data_type: text
2141           default_value: ''
2142           is_nullable: 0
2143           is_primary_key: 0
2144           is_unique: 0
2145           name: refs
2146           order: 9
2147           size:
2148             - 0
2149         sent_date:
2150           data_type: timestamp with time zone
2151           default_value: ~
2152           is_nullable: 1
2153           is_primary_key: 0
2154           is_unique: 0
2155           name: sent_date
2156           order: 8
2157           size:
2158             - 0
2159         spam_score:
2160           data_type: double precision
2161           default_value: ~
2162           is_nullable: 1
2163           is_primary_key: 0
2164           is_unique: 0
2165           name: spam_score
2166           order: 10
2167           size:
2168             - 0
2169         subject:
2170           data_type: text
2171           default_value: ''
2172           is_nullable: 0
2173           is_primary_key: 0
2174           is_unique: 0
2175           name: subject
2176           order: 7
2177           size:
2178             - 0
2179         to_addr:
2180           data_type: text
2181           default_value: ~
2182           is_nullable: 1
2183           is_primary_key: 0
2184           is_unique: 0
2185           name: to_addr
2186           order: 6
2187           size:
2188             - 0
2189         to_complete:
2190           data_type: text
2191           default_value: ~
2192           is_nullable: 1
2193           is_primary_key: 0
2194           is_unique: 0
2195           name: to_complete
2196           order: 5
2197           size:
2198             - 0
2199       indices: []
2200       name: message
2201       options: []
2202       order: 8
2203     message_correspondent:
2204       constraints:
2205         - deferrable: 1
2206           expression: ''
2207           fields:
2208             - id
2209           match_type: ''
2210           name: ''
2211           on_delete: ''
2212           on_update: ''
2213           options: []
2214           reference_fields: []
2215           reference_table: ''
2216           type: PRIMARY KEY
2217         - deferrable: 1
2218           expression: ''
2219           fields:
2220             - message
2221             - correspondent
2222             - correspondent_type
2223           match_type: ''
2224           name: message_correspondent_message_correspondent_correspondent_t_idx
2225           on_delete: ''
2226           on_update: ''
2227           options: []
2228           reference_fields: []
2229           reference_table: ''
2230           type: UNIQUE
2231         - deferrable: 0
2232           expression: ''
2233           fields:
2234             - correspondent
2235           match_type: ''
2236           name: message_correspondent_fk_correspondent
2237           on_delete: CASCADE
2238           on_update: CASCADE
2239           options: []
2240           reference_fields:
2241             - id
2242           reference_table: correspondent
2243           type: FOREIGN KEY
2244         - deferrable: 0
2245           expression: ''
2246           fields:
2247             - message
2248           match_type: ''
2249           name: message_correspondent_fk_message
2250           on_delete: CASCADE
2251           on_update: CASCADE
2252           options: []
2253           reference_fields:
2254             - id
2255           reference_table: message
2256           type: FOREIGN KEY
2257       fields:
2258         correspondent:
2259           data_type: integer
2260           default_value: ~
2261           is_nullable: 0
2262           is_primary_key: 0
2263           is_unique: 1
2264           name: correspondent
2265           order: 3
2266           size:
2267             - 0
2268         correspondent_type:
2269           data_type: enum
2270           default_value: to
2271           extra:
2272             custom_type_name: message_correspondent_type
2273             list:
2274               - to
2275               - from
2276               - envfrom
2277               - cc
2278           is_nullable: 0
2279           is_primary_key: 0
2280           is_unique: 1
2281           name: correspondent_type
2282           order: 4
2283           size:
2284             - 0
2285         id:
2286           data_type: integer
2287           default_value: ~
2288           is_auto_increment: 1
2289           is_nullable: 0
2290           is_primary_key: 1
2291           is_unique: 0
2292           name: id
2293           order: 1
2294           size:
2295             - 0
2296         message:
2297           data_type: integer
2298           default_value: ~
2299           is_nullable: 0
2300           is_primary_key: 0
2301           is_unique: 1
2302           name: message
2303           order: 2
2304           size:
2305             - 0
2306       indices:
2307         - fields:
2308             - correspondent
2309           name: message_correspondent_idx_correspondent
2310           options: []
2311           type: NORMAL
2312         - fields:
2313             - message
2314           name: message_correspondent_idx_message
2315           options: []
2316           type: NORMAL
2317       name: message_correspondent
2318       options: []
2319       order: 18
2320     message_refs:
2321       constraints:
2322         - deferrable: 1
2323           expression: ''
2324           fields:
2325             - id
2326           match_type: ''
2327           name: ''
2328           on_delete: ''
2329           on_update: ''
2330           options: []
2331           reference_fields: []
2332           reference_table: ''
2333           type: PRIMARY KEY
2334         - deferrable: 1
2335           expression: ''
2336           fields:
2337             - message
2338             - refs
2339           match_type: ''
2340           name: message_refs_message_refs_idx
2341           on_delete: ''
2342           on_update: ''
2343           options: []
2344           reference_fields: []
2345           reference_table: ''
2346           type: UNIQUE
2347         - deferrable: 0
2348           expression: ''
2349           fields:
2350             - message
2351           match_type: ''
2352           name: message_refs_fk_message
2353           on_delete: CASCADE
2354           on_update: CASCADE
2355           options: []
2356           reference_fields:
2357             - id
2358           reference_table: message
2359           type: FOREIGN KEY
2360         - deferrable: 0
2361           expression: ''
2362           fields:
2363             - refs
2364           match_type: ''
2365           name: message_refs_fk_refs
2366           on_delete: CASCADE
2367           on_update: CASCADE
2368           options: []
2369           reference_fields:
2370             - id
2371           reference_table: message
2372           type: FOREIGN KEY
2373       fields:
2374         id:
2375           data_type: integer
2376           default_value: ~
2377           is_auto_increment: 1
2378           is_nullable: 0
2379           is_primary_key: 1
2380           is_unique: 0
2381           name: id
2382           order: 1
2383           size:
2384             - 0
2385         inferred:
2386           data_type: boolean
2387           default_value: !!perl/ref
2388             =: false
2389           is_nullable: 1
2390           is_primary_key: 0
2391           is_unique: 0
2392           name: inferred
2393           order: 4
2394           size:
2395             - 0
2396         message:
2397           data_type: integer
2398           default_value: ~
2399           is_nullable: 0
2400           is_primary_key: 0
2401           is_unique: 1
2402           name: message
2403           order: 2
2404           size:
2405             - 0
2406         primary_ref:
2407           data_type: boolean
2408           default_value: !!perl/ref
2409             =: false
2410           is_nullable: 1
2411           is_primary_key: 0
2412           is_unique: 0
2413           name: primary_ref
2414           order: 5
2415           size:
2416             - 0
2417         refs:
2418           data_type: integer
2419           default_value: ~
2420           is_nullable: 0
2421           is_primary_key: 0
2422           is_unique: 1
2423           name: refs
2424           order: 3
2425           size:
2426             - 0
2427       indices:
2428         - fields:
2429             - message
2430           name: message_refs_idx_message
2431           options: []
2432           type: NORMAL
2433         - fields:
2434             - refs
2435           name: message_refs_idx_refs
2436           options: []
2437           type: NORMAL
2438       name: message_refs
2439       options: []
2440       order: 16
2441     severity:
2442       constraints:
2443         - deferrable: 1
2444           expression: ''
2445           fields:
2446             - id
2447           match_type: ''
2448           name: ''
2449           on_delete: ''
2450           on_update: ''
2451           options: []
2452           reference_fields: []
2453           reference_table: ''
2454           type: PRIMARY KEY
2455         - deferrable: 1
2456           expression: ''
2457           fields:
2458             - severity
2459           match_type: ''
2460           name: severity_severity_idx
2461           on_delete: ''
2462           on_update: ''
2463           options: []
2464           reference_fields: []
2465           reference_table: ''
2466           type: UNIQUE
2467       fields:
2468         id:
2469           data_type: integer
2470           default_value: ~
2471           is_auto_increment: 1
2472           is_nullable: 0
2473           is_primary_key: 1
2474           is_unique: 0
2475           name: id
2476           order: 1
2477           size:
2478             - 0
2479         obsolete:
2480           data_type: boolean
2481           default_value: !!perl/ref
2482             =: false
2483           is_nullable: 1
2484           is_primary_key: 0
2485           is_unique: 0
2486           name: obsolete
2487           order: 5
2488           size:
2489             - 0
2490         ordering:
2491           data_type: integer
2492           default_value: 5
2493           is_nullable: 0
2494           is_primary_key: 0
2495           is_unique: 0
2496           name: ordering
2497           order: 3
2498           size:
2499             - 0
2500         severity:
2501           data_type: text
2502           default_value: ~
2503           is_nullable: 0
2504           is_primary_key: 0
2505           is_unique: 1
2506           name: severity
2507           order: 2
2508           size:
2509             - 0
2510         strong:
2511           data_type: boolean
2512           default_value: !!perl/ref
2513             =: false
2514           is_nullable: 1
2515           is_primary_key: 0
2516           is_unique: 0
2517           name: strong
2518           order: 4
2519           size:
2520             - 0
2521       indices: []
2522       name: severity
2523       options: []
2524       order: 9
2525     src_associations:
2526       constraints:
2527         - deferrable: 1
2528           expression: ''
2529           fields:
2530             - id
2531           match_type: ''
2532           name: ''
2533           on_delete: ''
2534           on_update: ''
2535           options: []
2536           reference_fields: []
2537           reference_table: ''
2538           type: PRIMARY KEY
2539         - deferrable: 0
2540           expression: ''
2541           fields:
2542             - source
2543           match_type: ''
2544           name: src_associations_fk_source
2545           on_delete: CASCADE
2546           on_update: CASCADE
2547           options: []
2548           reference_fields:
2549             - id
2550           reference_table: src_ver
2551           type: FOREIGN KEY
2552         - deferrable: 0
2553           expression: ''
2554           fields:
2555             - suite
2556           match_type: ''
2557           name: src_associations_fk_suite
2558           on_delete: CASCADE
2559           on_update: CASCADE
2560           options: []
2561           reference_fields:
2562             - id
2563           reference_table: suite
2564           type: FOREIGN KEY
2565       fields:
2566         created:
2567           data_type: timestamp with time zone
2568           default_value: !!perl/ref
2569             =: current_timestamp
2570           is_nullable: 0
2571           is_primary_key: 0
2572           is_unique: 0
2573           name: created
2574           order: 4
2575           size:
2576             - 0
2577         id:
2578           data_type: integer
2579           default_value: ~
2580           is_auto_increment: 1
2581           is_nullable: 0
2582           is_primary_key: 1
2583           is_unique: 0
2584           name: id
2585           order: 1
2586           size:
2587             - 0
2588         modified:
2589           data_type: timestamp with time zone
2590           default_value: !!perl/ref
2591             =: current_timestamp
2592           is_nullable: 0
2593           is_primary_key: 0
2594           is_unique: 0
2595           name: modified
2596           order: 5
2597           size:
2598             - 0
2599         source:
2600           data_type: integer
2601           default_value: ~
2602           is_nullable: 0
2603           is_primary_key: 0
2604           is_unique: 0
2605           name: source
2606           order: 3
2607           size:
2608             - 0
2609         suite:
2610           data_type: integer
2611           default_value: ~
2612           is_nullable: 0
2613           is_primary_key: 0
2614           is_unique: 0
2615           name: suite
2616           order: 2
2617           size:
2618             - 0
2619       indices:
2620         - fields:
2621             - source
2622           name: src_associations_idx_source
2623           options: []
2624           type: NORMAL
2625         - fields:
2626             - suite
2627           name: src_associations_idx_suite
2628           options: []
2629           type: NORMAL
2630       name: src_associations
2631       options: []
2632       order: 27
2633     src_pkg:
2634       constraints:
2635         - deferrable: 1
2636           expression: ''
2637           fields:
2638             - id
2639           match_type: ''
2640           name: ''
2641           on_delete: ''
2642           on_update: ''
2643           options: []
2644           reference_fields: []
2645           reference_table: ''
2646           type: PRIMARY KEY
2647         - deferrable: 1
2648           expression: ''
2649           fields:
2650             - pkg
2651             - disabled
2652           match_type: ''
2653           name: src_pkg_pkg_disabled
2654           on_delete: ''
2655           on_update: ''
2656           options: []
2657           reference_fields: []
2658           reference_table: ''
2659           type: UNIQUE
2660         - deferrable: 0
2661           expression: ''
2662           fields:
2663             - alias_of
2664           match_type: ''
2665           name: src_pkg_fk_alias_of
2666           on_delete: CASCADE
2667           on_update: CASCADE
2668           options: []
2669           reference_fields:
2670             - id
2671           reference_table: src_pkg
2672           type: FOREIGN KEY
2673       fields:
2674         alias_of:
2675           data_type: integer
2676           default_value: ~
2677           is_nullable: 1
2678           is_primary_key: 0
2679           is_unique: 0
2680           name: alias_of
2681           order: 4
2682           size:
2683             - 0
2684         creation:
2685           data_type: timestamp with time zone
2686           default_value: !!perl/ref
2687             =: current_timestamp
2688           is_nullable: 1
2689           is_primary_key: 0
2690           is_unique: 0
2691           name: creation
2692           order: 5
2693           size:
2694             - 0
2695         disabled:
2696           data_type: timestamp with time zone
2697           default_value: ~
2698           is_nullable: 1
2699           is_primary_key: 0
2700           is_unique: 1
2701           name: disabled
2702           order: 6
2703           size:
2704             - 0
2705         id:
2706           data_type: integer
2707           default_value: ~
2708           is_auto_increment: 1
2709           is_nullable: 0
2710           is_primary_key: 1
2711           is_unique: 0
2712           name: id
2713           order: 1
2714           size:
2715             - 0
2716         last_modified:
2717           data_type: timestamp with time zone
2718           default_value: !!perl/ref
2719             =: current_timestamp
2720           is_nullable: 1
2721           is_primary_key: 0
2722           is_unique: 0
2723           name: last_modified
2724           order: 7
2725           size:
2726             - 0
2727         obsolete:
2728           data_type: boolean
2729           default_value: !!perl/ref
2730             =: false
2731           is_nullable: 1
2732           is_primary_key: 0
2733           is_unique: 0
2734           name: obsolete
2735           order: 8
2736           size:
2737             - 0
2738         pkg:
2739           data_type: text
2740           default_value: ~
2741           is_nullable: 0
2742           is_primary_key: 0
2743           is_unique: 1
2744           name: pkg
2745           order: 2
2746           size:
2747             - 0
2748         pseduopkg:
2749           data_type: boolean
2750           default_value: !!perl/ref
2751             =: false
2752           is_nullable: 1
2753           is_primary_key: 0
2754           is_unique: 0
2755           name: pseduopkg
2756           order: 3
2757           size:
2758             - 0
2759       indices:
2760         - fields:
2761             - alias_of
2762           name: src_pkg_idx_alias_of
2763           options: []
2764           type: NORMAL
2765       name: src_pkg
2766       options: []
2767       order: 10
2768     src_ver:
2769       constraints:
2770         - deferrable: 1
2771           expression: ''
2772           fields:
2773             - id
2774           match_type: ''
2775           name: ''
2776           on_delete: ''
2777           on_update: ''
2778           options: []
2779           reference_fields: []
2780           reference_table: ''
2781           type: PRIMARY KEY
2782         - deferrable: 1
2783           expression: ''
2784           fields:
2785             - src_pkg
2786             - ver
2787           match_type: ''
2788           name: src_ver_src_pkg_id_ver
2789           on_delete: ''
2790           on_update: ''
2791           options: []
2792           reference_fields: []
2793           reference_table: ''
2794           type: UNIQUE
2795         - deferrable: 0
2796           expression: ''
2797           fields:
2798             - based_on
2799           match_type: ''
2800           name: src_ver_fk_based_on
2801           on_delete: CASCADE
2802           on_update: CASCADE
2803           options: []
2804           reference_fields:
2805             - id
2806           reference_table: src_ver
2807           type: FOREIGN KEY
2808         - deferrable: 0
2809           expression: ''
2810           fields:
2811             - maintainer
2812           match_type: ''
2813           name: src_ver_fk_maintainer
2814           on_delete: SET NULL
2815           on_update: CASCADE
2816           options: []
2817           reference_fields:
2818             - id
2819           reference_table: maintainer
2820           type: FOREIGN KEY
2821         - deferrable: 0
2822           expression: ''
2823           fields:
2824             - src_pkg
2825           match_type: ''
2826           name: src_ver_fk_src_pkg
2827           on_delete: CASCADE
2828           on_update: CASCADE
2829           options: []
2830           reference_fields:
2831             - id
2832           reference_table: src_pkg
2833           type: FOREIGN KEY
2834       fields:
2835         based_on:
2836           data_type: integer
2837           default_value: ~
2838           is_nullable: 1
2839           is_primary_key: 0
2840           is_unique: 0
2841           name: based_on
2842           order: 6
2843           size:
2844             - 0
2845         id:
2846           data_type: integer
2847           default_value: ~
2848           is_auto_increment: 1
2849           is_nullable: 0
2850           is_primary_key: 1
2851           is_unique: 0
2852           name: id
2853           order: 1
2854           size:
2855             - 0
2856         maintainer:
2857           data_type: integer
2858           default_value: ~
2859           is_nullable: 1
2860           is_primary_key: 0
2861           is_unique: 0
2862           name: maintainer
2863           order: 4
2864           size:
2865             - 0
2866         src_pkg:
2867           data_type: integer
2868           default_value: ~
2869           is_nullable: 0
2870           is_primary_key: 0
2871           is_unique: 1
2872           name: src_pkg
2873           order: 2
2874           size:
2875             - 0
2876         upload_date:
2877           data_type: timestamp with time zone
2878           default_value: !!perl/ref
2879             =: current_timestamp
2880           is_nullable: 0
2881           is_primary_key: 0
2882           is_unique: 0
2883           name: upload_date
2884           order: 5
2885           size:
2886             - 0
2887         ver:
2888           data_type: debversion
2889           default_value: ~
2890           is_nullable: 0
2891           is_primary_key: 0
2892           is_unique: 1
2893           name: ver
2894           order: 3
2895           size:
2896             - 0
2897       indices:
2898         - fields:
2899             - based_on
2900           name: src_ver_idx_based_on
2901           options: []
2902           type: NORMAL
2903         - fields:
2904             - maintainer
2905           name: src_ver_idx_maintainer
2906           options: []
2907           type: NORMAL
2908         - fields:
2909             - src_pkg
2910           name: src_ver_idx_src_pkg
2911           options: []
2912           type: NORMAL
2913       name: src_ver
2914       options: []
2915       order: 21
2916     suite:
2917       constraints:
2918         - deferrable: 1
2919           expression: ''
2920           fields:
2921             - id
2922           match_type: ''
2923           name: ''
2924           on_delete: ''
2925           on_update: ''
2926           options: []
2927           reference_fields: []
2928           reference_table: ''
2929           type: PRIMARY KEY
2930         - deferrable: 1
2931           expression: ''
2932           fields:
2933             - suite_name
2934           match_type: ''
2935           name: suite_suite_name_key
2936           on_delete: ''
2937           on_update: ''
2938           options: []
2939           reference_fields: []
2940           reference_table: ''
2941           type: UNIQUE
2942       fields:
2943         active:
2944           data_type: boolean
2945           default_value: !!perl/ref
2946             =: true
2947           is_nullable: 1
2948           is_primary_key: 0
2949           is_unique: 0
2950           name: active
2951           order: 5
2952           size:
2953             - 0
2954         codename:
2955           data_type: text
2956           default_value: ~
2957           is_nullable: 1
2958           is_primary_key: 0
2959           is_unique: 0
2960           name: codename
2961           order: 4
2962           size:
2963             - 0
2964         id:
2965           data_type: integer
2966           default_value: ~
2967           is_auto_increment: 1
2968           is_nullable: 0
2969           is_primary_key: 1
2970           is_unique: 0
2971           name: id
2972           order: 1
2973           size:
2974             - 0
2975         suite_name:
2976           data_type: text
2977           default_value: ~
2978           is_nullable: 0
2979           is_primary_key: 0
2980           is_unique: 1
2981           name: suite_name
2982           order: 2
2983           size:
2984             - 0
2985         version:
2986           data_type: text
2987           default_value: ~
2988           is_nullable: 1
2989           is_primary_key: 0
2990           is_unique: 0
2991           name: version
2992           order: 3
2993           size:
2994             - 0
2995       indices: []
2996       name: suite
2997       options: []
2998       order: 11
2999     table_comments:
3000       constraints:
3001         - deferrable: 1
3002           expression: ''
3003           fields:
3004             - table_name
3005           match_type: ''
3006           name: table_comments_table_name_key
3007           on_delete: ''
3008           on_update: ''
3009           options: []
3010           reference_fields: []
3011           reference_table: ''
3012           type: UNIQUE
3013       fields:
3014         comment_text:
3015           data_type: text
3016           default_value: ~
3017           is_nullable: 0
3018           is_primary_key: 0
3019           is_unique: 0
3020           name: comment_text
3021           order: 2
3022           size:
3023             - 0
3024         table_name:
3025           data_type: text
3026           default_value: ~
3027           is_nullable: 0
3028           is_primary_key: 0
3029           is_unique: 1
3030           name: table_name
3031           order: 1
3032           size:
3033             - 0
3034       indices: []
3035       name: table_comments
3036       options: []
3037       order: 12
3038     tag:
3039       constraints:
3040         - deferrable: 1
3041           expression: ''
3042           fields:
3043             - id
3044           match_type: ''
3045           name: ''
3046           on_delete: ''
3047           on_update: ''
3048           options: []
3049           reference_fields: []
3050           reference_table: ''
3051           type: PRIMARY KEY
3052         - deferrable: 1
3053           expression: ''
3054           fields:
3055             - tag
3056           match_type: ''
3057           name: tag_tag_key
3058           on_delete: ''
3059           on_update: ''
3060           options: []
3061           reference_fields: []
3062           reference_table: ''
3063           type: UNIQUE
3064       fields:
3065         id:
3066           data_type: integer
3067           default_value: ~
3068           is_auto_increment: 1
3069           is_nullable: 0
3070           is_primary_key: 1
3071           is_unique: 0
3072           name: id
3073           order: 1
3074           size:
3075             - 0
3076         obsolete:
3077           data_type: boolean
3078           default_value: !!perl/ref
3079             =: false
3080           is_nullable: 1
3081           is_primary_key: 0
3082           is_unique: 0
3083           name: obsolete
3084           order: 3
3085           size:
3086             - 0
3087         tag:
3088           data_type: text
3089           default_value: ~
3090           is_nullable: 0
3091           is_primary_key: 0
3092           is_unique: 1
3093           name: tag
3094           order: 2
3095           size:
3096             - 0
3097       indices: []
3098       name: tag
3099       options: []
3100       order: 13
3101   triggers: {}
3102   views: {}
3103 translator:
3104   add_drop_table: 0
3105   filename: ~
3106   no_comments: 0
3107   parser_args:
3108     sources:
3109       - Arch
3110       - BinAssociation
3111       - BinPkg
3112       - BinVer
3113       - BinaryVersion
3114       - Bug
3115       - BugBinpackage
3116       - BugBlock
3117       - BugMerged
3118       - BugMessage
3119       - BugPackage
3120       - BugSrcpackage
3121       - BugStatusCache
3122       - BugTag
3123       - BugVer
3124       - ColumnComment
3125       - Correspondent
3126       - CorrespondentFullName
3127       - DbixClassDeploymenthandlerVersion
3128       - Maintainer
3129       - Message
3130       - MessageCorrespondent
3131       - MessageRef
3132       - Severity
3133       - SrcAssociation
3134       - SrcPkg
3135       - SrcVer
3136       - Suite
3137       - TableComment
3138       - Tag
3139   parser_type: SQL::Translator::Parser::DBIx::Class
3140   producer_args: {}
3141   producer_type: SQL::Translator::Producer::YAML
3142   show_warnings: 0
3143   trace: 0
3144   version: 0.11018