77 name: bin_associations_bin_suite
89 name: bin_associations_fk_bin
95 reference_table: bin_ver
102 name: bin_associations_fk_suite
108 reference_table: suite
122 data_type: timestamp with time zone
123 default_value: !!perl/ref
144 data_type: timestamp with time zone
145 default_value: !!perl/ref
167 name: bin_associations_idx_bin
172 name: bin_associations_idx_suite
175 name: bin_associations
197 name: bin_pkg_pkg_key
251 name: bin_ver_bin_pkg_id_arch_idx
263 name: bin_ver_fk_arch
269 reference_table: arch
276 name: bin_ver_fk_bin_pkg
282 reference_table: bin_pkg
289 name: bin_ver_fk_src_ver
295 reference_table: src_ver
340 data_type: debversion
352 name: bin_ver_idx_arch
357 name: bin_ver_idx_bin_pkg
362 name: bin_ver_idx_src_ver
367 name: bin_ver_ver_id_idx
372 name: bin_ver_bin_pkg_id_idx
377 name: bin_ver_src_ver_id_idx
383 name: bin_ver_src_ver_id_arch_idx
414 reference_table: correspondent
427 reference_table: correspondent
434 name: bug_fk_severity
440 reference_table: severity
447 name: bug_fk_submitter
453 reference_table: correspondent
458 default_value: !!perl/ref
468 data_type: timestamp with time zone
469 default_value: !!perl/ref
519 data_type: timestamp with time zone
520 default_value: !!perl/ref
530 data_type: timestamp with time zone
531 default_value: !!perl/ref
621 data_type: timestamp with time zone
636 name: unknown_packages
653 name: bug_idx_severity
658 name: bug_idx_submitter
668 name: bug_idxsubmitter
678 name: bug_idxforwarded
683 name: bug_idxlast_modified
688 name: bug_idxseverity
693 name: bug_idxcreation
698 name: bug_idxlog_modified
704 bug_affects_binpackage:
712 name: bug_affects_binpackage_id_pkg
724 name: bug_affects_binpackage_fk_bin_pkg
730 reference_table: bin_pkg
737 name: bug_affects_binpackage_fk_bug
769 name: bug_affects_binpackage_idx_bin_pkg
774 name: bug_affects_binpackage_idx_bug
777 name: bug_affects_binpackage
780 bug_affects_srcpackage:
788 name: bug_affects_srcpackage_id_pkg
800 name: bug_affects_srcpackage_fk_bug
813 name: bug_affects_srcpackage_fk_src_pkg
819 reference_table: src_pkg
845 name: bug_affects_srcpackage_idx_bug
850 name: bug_affects_srcpackage_idx_src_pkg
853 name: bug_affects_srcpackage
864 name: bug_binpackage_id_pkg
876 name: bug_binpackage_fk_bin_pkg
882 reference_table: bin_pkg
889 name: bug_binpackage_fk_bug
921 name: bug_binpackage_idx_bin_pkg
926 name: bug_binpackage_idx_bug
931 name: bug_binpackage_bin_pkg_idx
957 name: bug_blocks_bug_id_blocks_idx
969 name: bug_blocks_fk_blocks
982 name: bug_blocks_fk_bug
1014 is_auto_increment: 1
1025 name: bug_blocks_idx_blocks
1030 name: bug_blocks_idx_bug
1035 name: bug_blocks_bug_idx
1040 name: bug_blocks_blocks_idx
1057 reference_fields: []
1066 name: bug_merged_bug_id_merged_idx
1070 reference_fields: []
1078 name: bug_merged_fk_bug
1079 on_delete: NO ACTION
1080 on_update: NO ACTION
1084 reference_table: bug
1091 name: bug_merged_fk_merged
1092 on_delete: NO ACTION
1093 on_update: NO ACTION
1097 reference_table: bug
1113 is_auto_increment: 1
1134 name: bug_merged_idx_bug
1139 name: bug_merged_idx_merged
1144 name: bug_merged_bug_idx
1149 name: bug_merged_merged_idx
1163 name: bug_message_bug_message_idx
1167 reference_fields: []
1175 name: bug_message_fk_bug
1181 reference_table: bug
1188 name: bug_message_fk_message
1194 reference_table: message
1213 name: bug_log_offset
1233 name: message_number
1238 data_type: timestamp with time zone
1250 name: bug_message_idx_bug
1255 name: bug_message_idx_message
1261 name: bug_message_idx_bug_message_number
1275 name: bug_srcpackage_id_pkg
1279 reference_fields: []
1287 name: bug_srcpackage_fk_bug
1288 on_delete: NO ACTION
1289 on_update: NO ACTION
1293 reference_table: bug
1300 name: bug_srcpackage_fk_src_pkg
1306 reference_table: src_pkg
1332 name: bug_srcpackage_idx_bug
1337 name: bug_srcpackage_idx_src_pkg
1342 name: bug_srcpackage_src_pkg_idx
1345 name: bug_srcpackage
1357 name: bug_status_cache_bug_suite_arch_idx
1361 reference_fields: []
1369 name: bug_status_cache_fk_arch
1375 reference_table: arch
1382 name: bug_status_cache_fk_bug
1388 reference_table: bug
1395 name: bug_status_cache_fk_suite
1401 reference_table: suite
1415 data_type: timestamp with time zone
1416 default_value: !!perl/ref
1417 =: current_timestamp
1436 data_type: timestamp with time zone
1437 default_value: !!perl/ref
1438 =: current_timestamp
1450 custom_type_name: bug_status_type
1478 name: bug_status_cache_idx_arch
1483 name: bug_status_cache_idx_bug
1488 name: bug_status_cache_idx_suite
1491 name: bug_status_cache
1502 name: bug_tag_bug_tag
1506 reference_fields: []
1514 name: bug_tag_fk_bug
1515 on_delete: NO ACTION
1516 on_update: NO ACTION
1520 reference_table: bug
1527 name: bug_tag_fk_tag
1528 on_delete: NO ACTION
1529 on_update: NO ACTION
1533 reference_table: tag
1559 name: bug_tag_idx_bug
1564 name: bug_tag_idx_tag
1583 name: bug_user_tag_bug_tag
1587 reference_fields: []
1595 name: bug_user_tag_fk_bug
1596 on_delete: NO ACTION
1597 on_update: NO ACTION
1601 reference_table: bug
1608 name: bug_user_tag_fk_user_tag
1609 on_delete: NO ACTION
1610 on_update: NO ACTION
1614 reference_table: user_tag
1640 name: bug_user_tag_idx_bug
1645 name: bug_user_tag_idx_user_tag
1650 name: bug_user_tag_tag
1667 reference_fields: []
1677 name: bug_ver_bug_ver_string_found_idx
1681 reference_fields: []
1689 name: bug_ver_fk_bug
1695 reference_table: bug
1702 name: bug_ver_fk_src_pkg
1708 reference_table: src_pkg
1715 name: bug_ver_fk_src_ver
1721 reference_table: src_ver
1735 data_type: timestamp with time zone
1736 default_value: !!perl/ref
1737 =: current_timestamp
1747 default_value: !!perl/ref
1759 is_auto_increment: 1
1768 data_type: timestamp with time zone
1769 default_value: !!perl/ref
1770 =: current_timestamp
1811 name: bug_ver_idx_bug
1816 name: bug_ver_idx_src_pkg
1821 name: bug_ver_idx_src_ver
1826 name: bug_ver_src_pkg_id_idx
1831 name: bug_ver_src_ver_id_idx
1837 name: bug_ver_src_pkg_id_src_ver_id_idx
1851 name: column_comments_table_name_column_name_idx
1855 reference_fields: []
1890 name: column_comments
1904 reference_fields: []
1912 name: correspondent_addr_idx
1916 reference_fields: []
1933 is_auto_increment: 1
1945 correspondent_full_name:
1953 name: correspondent_full_name_correspondent_full_name_idx
1957 reference_fields: []
1965 name: correspondent_full_name_fk_correspondent
1971 reference_table: correspondent
1995 data_type: timestamp
1996 default_value: !!perl/ref
1997 =: current_timestamp
2008 name: correspondent_full_name_idx_correspondent
2013 name: correspondent_full_name_idx_full_name
2018 name: correspondent_full_name_idx_last_seen
2021 name: correspondent_full_name
2035 reference_fields: []
2043 name: maintainer_name_idx
2047 reference_fields: []
2055 name: maintainer_fk_correspondent
2056 on_delete: NO ACTION
2057 on_update: NO ACTION
2061 reference_table: correspondent
2075 data_type: timestamp with time zone
2076 default_value: !!perl/ref
2077 =: current_timestamp
2088 is_auto_increment: 1
2097 data_type: timestamp with time zone
2098 default_value: !!perl/ref
2099 =: current_timestamp
2120 name: maintainer_idx_correspondent
2137 reference_fields: []
2148 name: message_msgid_from_complete_to_complete_subject_idx
2152 reference_fields: []
2169 is_auto_increment: 1
2179 default_value: !!perl/ref
2209 data_type: timestamp with time zone
2219 data_type: double precision
2251 name: message_msgid_idx
2256 name: message_subject_idx
2262 message_correspondent:
2269 - correspondent_type
2271 name: message_correspondent_message_correspondent_correspondent_t_idx
2275 reference_fields: []
2283 name: message_correspondent_fk_correspondent
2289 reference_table: correspondent
2296 name: message_correspondent_fk_message
2302 reference_table: message
2319 custom_type_name: message_correspondent_type
2329 name: correspondent_type
2346 name: message_correspondent_idx_correspondent
2351 name: message_correspondent_idx_message
2356 name: message_correspondent_idxcorrespondent
2361 name: message_correspondent_idxmessage
2364 name: message_correspondent
2375 name: message_refs_message_refs_idx
2379 reference_fields: []
2387 name: message_refs_fk_message
2393 reference_table: message
2400 name: message_refs_fk_refs
2406 reference_table: message
2411 default_value: !!perl/ref
2432 default_value: !!perl/ref
2454 name: message_refs_idx_message
2459 name: message_refs_idx_refs
2476 reference_fields: []
2484 name: severity_severity_idx
2488 reference_fields: []
2495 is_auto_increment: 1
2505 default_value: !!perl/ref
2536 default_value: !!perl/ref
2548 name: severity_ordering_idx
2565 reference_fields: []
2574 name: src_associations_source_suite
2578 reference_fields: []
2586 name: src_associations_fk_source
2592 reference_table: src_ver
2599 name: src_associations_fk_suite
2605 reference_table: suite
2609 data_type: timestamp with time zone
2610 default_value: !!perl/ref
2611 =: current_timestamp
2622 is_auto_increment: 1
2631 data_type: timestamp with time zone
2632 default_value: !!perl/ref
2633 =: current_timestamp
2664 name: src_associations_idx_source
2669 name: src_associations_idx_suite
2672 name: src_associations
2686 reference_fields: []
2695 name: src_pkg_pkg_disabled
2699 reference_fields: []
2707 name: src_pkg_fk_alias_of
2713 reference_table: src_pkg
2727 data_type: timestamp with time zone
2728 default_value: !!perl/ref
2729 =: current_timestamp
2738 data_type: timestamp with time zone
2739 default_value: infinity
2750 is_auto_increment: 1
2759 data_type: timestamp with time zone
2760 default_value: !!perl/ref
2761 =: current_timestamp
2771 default_value: !!perl/ref
2792 default_value: !!perl/ref
2804 name: src_pkg_idx_alias_of
2826 reference_fields: []
2835 name: src_ver_src_pkg_id_ver
2839 reference_fields: []
2847 name: src_ver_fk_based_on
2853 reference_table: src_ver
2860 name: src_ver_fk_maintainer
2866 reference_table: maintainer
2873 name: src_ver_fk_src_pkg
2879 reference_table: src_pkg
2895 is_auto_increment: 1
2924 data_type: timestamp with time zone
2925 default_value: !!perl/ref
2926 =: current_timestamp
2935 data_type: debversion
2947 name: src_ver_idx_based_on
2952 name: src_ver_idx_maintainer
2957 name: src_ver_idx_src_pkg
2974 reference_fields: []
2982 name: suite_idx_codename
2986 reference_fields: []
2994 name: suite_idx_version
2998 reference_fields: []
3006 name: suite_suite_name_key
3010 reference_fields: []
3016 default_value: !!perl/ref
3038 is_auto_increment: 1
3077 name: table_comments_table_name_idx
3081 reference_fields: []
3089 name: table_comments_table_name_key
3093 reference_fields: []
3118 name: table_comments
3132 reference_fields: []
3144 reference_fields: []
3151 is_auto_increment: 1
3161 default_value: !!perl/ref
3195 reference_fields: []
3204 name: user_tag_tag_correspondent
3208 reference_fields: []
3216 name: user_tag_fk_correspondent
3217 on_delete: NO ACTION
3218 on_update: NO ACTION
3222 reference_table: correspondent
3238 is_auto_increment: 1
3259 name: user_tag_idx_correspondent
3264 name: user_tag_correspondent
3281 name: binary_versions
3284 SELECT sp.pkg AS src_pkg, sv.ver AS src_ver, bp.pkg AS bin_pkg, a.arch AS arch, b.ver AS bin_ver,
3285 svb.ver AS src_ver_based_on, spb.pkg AS src_pkg_based_on
3286 FROM bin_ver b JOIN arch a ON b.arch = a.id
3287 JOIN bin_pkg bp ON b.bin_pkg = bp.id
3288 JOIN src_ver sv ON b.src_ver = sv.id
3289 JOIN src_pkg sp ON sv.src_pkg = sp.id
3290 LEFT OUTER JOIN src_ver svb ON sv.based_on = svb.id
3291 LEFT OUTER JOIN src_pkg spb ON spb.id = svb.src_pkg;
3301 SELECT b.bug,b.bin_pkg,'binary',bp.pkg FROM bug_binpackage b JOIN bin_pkg bp ON bp.id=b.bin_pkg UNION
3302 SELECT s.bug,s.src_pkg,'source',sp.pkg FROM bug_srcpackage s JOIN src_pkg sp ON sp.id=s.src_pkg;
3315 - BugAffectsBinpackage
3316 - BugAffectsSrcpackage
3329 - CorrespondentFullName
3332 - MessageCorrespondent
3342 parser_type: SQL::Translator::Parser::DBIx::Class
3344 producer_type: SQL::Translator::Producer::YAML