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