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
393 reference_table: correspondent
406 reference_table: correspondent
413 name: bug_fk_severity
419 reference_table: severity
426 name: bug_fk_submitter
432 reference_table: correspondent
437 default_value: !!perl/ref
447 data_type: timestamp with time zone
448 default_value: !!perl/ref
498 data_type: timestamp with time zone
499 default_value: !!perl/ref
509 data_type: timestamp with time zone
510 default_value: !!perl/ref
600 data_type: timestamp with time zone
615 name: unknown_packages
632 name: bug_idx_severity
637 name: bug_idx_submitter
643 bug_affects_binpackage:
651 name: bug_affects_binpackage_id_pkg
663 name: bug_affects_binpackage_fk_bin_pkg
669 reference_table: bin_pkg
676 name: bug_affects_binpackage_fk_bug
708 name: bug_affects_binpackage_idx_bin_pkg
713 name: bug_affects_binpackage_idx_bug
716 name: bug_affects_binpackage
719 bug_affects_srcpackage:
727 name: bug_affects_srcpackage_id_pkg
739 name: bug_affects_srcpackage_fk_bug
752 name: bug_affects_srcpackage_fk_src_pkg
758 reference_table: src_pkg
784 name: bug_affects_srcpackage_idx_bug
789 name: bug_affects_srcpackage_idx_src_pkg
792 name: bug_affects_srcpackage
803 name: bug_binpackage_id_pkg
815 name: bug_binpackage_fk_bin_pkg
821 reference_table: bin_pkg
828 name: bug_binpackage_fk_bug
860 name: bug_binpackage_idx_bin_pkg
865 name: bug_binpackage_idx_bug
891 name: bug_blocks_bug_id_blocks_idx
903 name: bug_blocks_fk_blocks
916 name: bug_blocks_fk_bug
959 name: bug_blocks_idx_blocks
964 name: bug_blocks_idx_bug
990 name: bug_merged_bug_id_merged_idx
1002 name: bug_merged_fk_bug
1003 on_delete: NO ACTION
1004 on_update: NO ACTION
1008 reference_table: bug
1015 name: bug_merged_fk_merged
1016 on_delete: NO ACTION
1017 on_update: NO ACTION
1021 reference_table: bug
1037 is_auto_increment: 1
1058 name: bug_merged_idx_bug
1063 name: bug_merged_idx_merged
1077 name: bug_message_bug_message_idx
1081 reference_fields: []
1089 name: bug_message_fk_bug
1095 reference_table: bug
1102 name: bug_message_fk_message
1108 reference_table: message
1127 name: bug_log_offset
1147 name: message_number
1152 data_type: timestamp with time zone
1164 name: bug_message_idx_bug
1169 name: bug_message_idx_message
1183 name: bug_srcpackage_id_pkg
1187 reference_fields: []
1195 name: bug_srcpackage_fk_bug
1196 on_delete: NO ACTION
1197 on_update: NO ACTION
1201 reference_table: bug
1208 name: bug_srcpackage_fk_src_pkg
1214 reference_table: src_pkg
1240 name: bug_srcpackage_idx_bug
1245 name: bug_srcpackage_idx_src_pkg
1248 name: bug_srcpackage
1260 name: bug_status_cache_bug_suite_arch_idx
1264 reference_fields: []
1272 name: bug_status_cache_fk_arch
1278 reference_table: arch
1285 name: bug_status_cache_fk_bug
1291 reference_table: bug
1298 name: bug_status_cache_fk_suite
1304 reference_table: suite
1318 data_type: timestamp with time zone
1319 default_value: !!perl/ref
1320 =: current_timestamp
1339 data_type: timestamp with time zone
1340 default_value: !!perl/ref
1341 =: current_timestamp
1353 custom_type_name: bug_status_type
1381 name: bug_status_cache_idx_arch
1386 name: bug_status_cache_idx_bug
1391 name: bug_status_cache_idx_suite
1394 name: bug_status_cache
1405 name: bug_tag_bug_tag
1409 reference_fields: []
1417 name: bug_tag_fk_bug
1418 on_delete: NO ACTION
1419 on_update: NO ACTION
1423 reference_table: bug
1430 name: bug_tag_fk_tag
1431 on_delete: NO ACTION
1432 on_update: NO ACTION
1436 reference_table: tag
1462 name: bug_tag_idx_bug
1467 name: bug_tag_idx_tag
1481 name: bug_user_tag_bug_tag
1485 reference_fields: []
1493 name: bug_user_tag_fk_bug
1494 on_delete: NO ACTION
1495 on_update: NO ACTION
1499 reference_table: bug
1506 name: bug_user_tag_fk_user_tag
1507 on_delete: NO ACTION
1508 on_update: NO ACTION
1512 reference_table: user_tag
1538 name: bug_user_tag_idx_bug
1543 name: bug_user_tag_idx_user_tag
1560 reference_fields: []
1570 name: bug_ver_bug_ver_string_found_idx
1574 reference_fields: []
1582 name: bug_ver_fk_bug
1588 reference_table: bug
1595 name: bug_ver_fk_src_pkg
1601 reference_table: src_pkg
1608 name: bug_ver_fk_src_ver
1614 reference_table: src_ver
1628 data_type: timestamp with time zone
1629 default_value: !!perl/ref
1630 =: current_timestamp
1640 default_value: !!perl/ref
1652 is_auto_increment: 1
1661 data_type: timestamp with time zone
1662 default_value: !!perl/ref
1663 =: current_timestamp
1704 name: bug_ver_idx_bug
1709 name: bug_ver_idx_src_pkg
1714 name: bug_ver_idx_src_ver
1728 name: column_comments_table_name_column_name_idx
1732 reference_fields: []
1767 name: column_comments
1781 reference_fields: []
1789 name: correspondent_addr_idx
1793 reference_fields: []
1810 is_auto_increment: 1
1822 correspondent_full_name:
1830 name: correspondent_full_name_correspondent_full_name_idx
1834 reference_fields: []
1842 name: correspondent_full_name_fk_correspondent
1848 reference_table: correspondent
1872 data_type: timestamp
1873 default_value: !!perl/ref
1874 =: current_timestamp
1885 name: correspondent_full_name_idx_correspondent
1888 name: correspondent_full_name
1902 reference_fields: []
1910 name: maintainer_name_idx
1914 reference_fields: []
1922 name: maintainer_fk_correspondent
1923 on_delete: NO ACTION
1924 on_update: NO ACTION
1928 reference_table: correspondent
1942 data_type: timestamp with time zone
1943 default_value: !!perl/ref
1944 =: current_timestamp
1955 is_auto_increment: 1
1964 data_type: timestamp with time zone
1965 default_value: !!perl/ref
1966 =: current_timestamp
1987 name: maintainer_idx_correspondent
2004 reference_fields: []
2015 name: message_msgid_from_complete_to_complete_subject_idx
2019 reference_fields: []
2036 is_auto_increment: 1
2046 default_value: !!perl/ref
2076 data_type: timestamp with time zone
2086 data_type: double precision
2119 message_correspondent:
2126 - correspondent_type
2128 name: message_correspondent_message_correspondent_correspondent_t_idx
2132 reference_fields: []
2140 name: message_correspondent_fk_correspondent
2146 reference_table: correspondent
2153 name: message_correspondent_fk_message
2159 reference_table: message
2176 custom_type_name: message_correspondent_type
2186 name: correspondent_type
2203 name: message_correspondent_idx_correspondent
2208 name: message_correspondent_idx_message
2211 name: message_correspondent
2222 name: message_refs_message_refs_idx
2226 reference_fields: []
2234 name: message_refs_fk_message
2240 reference_table: message
2247 name: message_refs_fk_refs
2253 reference_table: message
2258 default_value: !!perl/ref
2279 default_value: !!perl/ref
2301 name: message_refs_idx_message
2306 name: message_refs_idx_refs
2323 reference_fields: []
2331 name: severity_severity_idx
2335 reference_fields: []
2342 is_auto_increment: 1
2352 default_value: !!perl/ref
2383 default_value: !!perl/ref
2407 reference_fields: []
2416 name: src_associations_source_suite
2420 reference_fields: []
2428 name: src_associations_fk_source
2434 reference_table: src_ver
2441 name: src_associations_fk_suite
2447 reference_table: suite
2451 data_type: timestamp with time zone
2452 default_value: !!perl/ref
2453 =: current_timestamp
2464 is_auto_increment: 1
2473 data_type: timestamp with time zone
2474 default_value: !!perl/ref
2475 =: current_timestamp
2506 name: src_associations_idx_source
2511 name: src_associations_idx_suite
2514 name: src_associations
2528 reference_fields: []
2537 name: src_pkg_pkg_disabled
2541 reference_fields: []
2549 name: src_pkg_fk_alias_of
2555 reference_table: src_pkg
2569 data_type: timestamp with time zone
2570 default_value: !!perl/ref
2571 =: current_timestamp
2580 data_type: timestamp with time zone
2581 default_value: infinity
2592 is_auto_increment: 1
2601 data_type: timestamp with time zone
2602 default_value: !!perl/ref
2603 =: current_timestamp
2613 default_value: !!perl/ref
2634 default_value: !!perl/ref
2646 name: src_pkg_idx_alias_of
2663 reference_fields: []
2672 name: src_ver_src_pkg_id_ver
2676 reference_fields: []
2684 name: src_ver_fk_based_on
2690 reference_table: src_ver
2697 name: src_ver_fk_maintainer
2703 reference_table: maintainer
2710 name: src_ver_fk_src_pkg
2716 reference_table: src_pkg
2732 is_auto_increment: 1
2761 data_type: timestamp with time zone
2762 default_value: !!perl/ref
2763 =: current_timestamp
2772 data_type: debversion
2784 name: src_ver_idx_based_on
2789 name: src_ver_idx_maintainer
2794 name: src_ver_idx_src_pkg
2811 reference_fields: []
2819 name: suite_idx_codename
2823 reference_fields: []
2831 name: suite_idx_version
2835 reference_fields: []
2843 name: suite_suite_name_key
2847 reference_fields: []
2853 default_value: !!perl/ref
2875 is_auto_increment: 1
2914 name: table_comments_table_name_idx
2918 reference_fields: []
2926 name: table_comments_table_name_key
2930 reference_fields: []
2955 name: table_comments
2969 reference_fields: []
2981 reference_fields: []
2988 is_auto_increment: 1
2998 default_value: !!perl/ref
3032 reference_fields: []
3041 name: user_tag_tag_correspondent
3045 reference_fields: []
3053 name: user_tag_fk_correspondent
3054 on_delete: NO ACTION
3055 on_update: NO ACTION
3059 reference_table: correspondent
3075 is_auto_increment: 1
3096 name: user_tag_idx_correspondent
3113 name: binary_versions
3116 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,
3117 svb.ver AS src_ver_based_on, spb.pkg AS src_pkg_based_on
3118 FROM bin_ver b JOIN arch a ON b.arch = a.id
3119 JOIN bin_pkg bp ON b.bin_pkg = bp.id
3120 JOIN src_ver sv ON b.src_ver = sv.id
3121 JOIN src_pkg sp ON sv.src_pkg = sp.id
3122 LEFT OUTER JOIN src_ver svb ON sv.based_on = svb.id
3123 LEFT OUTER JOIN src_pkg spb ON spb.id = svb.src_pkg;
3133 SELECT b.bug,b.bin_pkg,'binary',bp.pkg FROM bug_binpackage b JOIN bin_pkg bp ON bp.id=b.bin_pkg UNION
3134 SELECT s.bug,s.src_pkg,'source',sp.pkg FROM bug_srcpackage s JOIN src_pkg sp ON sp.id=s.src_pkg;
3147 - BugAffectsBinpackage
3148 - BugAffectsSrcpackage
3161 - CorrespondentFullName
3164 - MessageCorrespondent
3174 parser_type: SQL::Translator::Parser::DBIx::Class
3176 producer_type: SQL::Translator::Producer::YAML