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