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             - full_name
2013           name: correspondent_full_name_idx_full_name
2014           options: []
2015           type: NORMAL
2016         - fields:
2017             - last_seen
2018           name: correspondent_full_name_idx_last_seen
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         - fields:
2355             - correspondent
2356           name: message_correspondent_idxcorrespondent
2357           options: []
2358           type: NORMAL
2359         - fields:
2360             - message
2361           name: message_correspondent_idxmessage
2362           options: []
2363           type: NORMAL
2364       name: message_correspondent
2365       options: []
2366       order: 16
2367     message_refs:
2368       constraints:
2369         - deferrable: 1
2370           expression: ''
2371           fields:
2372             - message
2373             - refs
2374           match_type: ''
2375           name: message_refs_message_refs_idx
2376           on_delete: ''
2377           on_update: ''
2378           options: []
2379           reference_fields: []
2380           reference_table: ''
2381           type: UNIQUE
2382         - deferrable: 0
2383           expression: ''
2384           fields:
2385             - message
2386           match_type: ''
2387           name: message_refs_fk_message
2388           on_delete: CASCADE
2389           on_update: CASCADE
2390           options: []
2391           reference_fields:
2392             - id
2393           reference_table: message
2394           type: FOREIGN KEY
2395         - deferrable: 0
2396           expression: ''
2397           fields:
2398             - refs
2399           match_type: ''
2400           name: message_refs_fk_refs
2401           on_delete: CASCADE
2402           on_update: CASCADE
2403           options: []
2404           reference_fields:
2405             - id
2406           reference_table: message
2407           type: FOREIGN KEY
2408       fields:
2409         inferred:
2410           data_type: boolean
2411           default_value: !!perl/ref
2412             =: false
2413           is_nullable: 1
2414           is_primary_key: 0
2415           is_unique: 0
2416           name: inferred
2417           order: 3
2418           size:
2419             - 0
2420         message:
2421           data_type: integer
2422           default_value: ~
2423           is_nullable: 0
2424           is_primary_key: 0
2425           is_unique: 1
2426           name: message
2427           order: 1
2428           size:
2429             - 0
2430         primary_ref:
2431           data_type: boolean
2432           default_value: !!perl/ref
2433             =: false
2434           is_nullable: 1
2435           is_primary_key: 0
2436           is_unique: 0
2437           name: primary_ref
2438           order: 4
2439           size:
2440             - 0
2441         refs:
2442           data_type: integer
2443           default_value: ~
2444           is_nullable: 0
2445           is_primary_key: 0
2446           is_unique: 1
2447           name: refs
2448           order: 2
2449           size:
2450             - 0
2451       indices:
2452         - fields:
2453             - message
2454           name: message_refs_idx_message
2455           options: []
2456           type: NORMAL
2457         - fields:
2458             - refs
2459           name: message_refs_idx_refs
2460           options: []
2461           type: NORMAL
2462       name: message_refs
2463       options: []
2464       order: 13
2465     severity:
2466       constraints:
2467         - deferrable: 1
2468           expression: ''
2469           fields:
2470             - id
2471           match_type: ''
2472           name: ''
2473           on_delete: ''
2474           on_update: ''
2475           options: []
2476           reference_fields: []
2477           reference_table: ''
2478           type: PRIMARY KEY
2479         - deferrable: 1
2480           expression: ''
2481           fields:
2482             - severity
2483           match_type: ''
2484           name: severity_severity_idx
2485           on_delete: ''
2486           on_update: ''
2487           options: []
2488           reference_fields: []
2489           reference_table: ''
2490           type: UNIQUE
2491       fields:
2492         id:
2493           data_type: integer
2494           default_value: ~
2495           is_auto_increment: 1
2496           is_nullable: 0
2497           is_primary_key: 1
2498           is_unique: 0
2499           name: id
2500           order: 1
2501           size:
2502             - 0
2503         obsolete:
2504           data_type: boolean
2505           default_value: !!perl/ref
2506             =: false
2507           is_nullable: 1
2508           is_primary_key: 0
2509           is_unique: 0
2510           name: obsolete
2511           order: 5
2512           size:
2513             - 0
2514         ordering:
2515           data_type: integer
2516           default_value: 5
2517           is_nullable: 0
2518           is_primary_key: 0
2519           is_unique: 0
2520           name: ordering
2521           order: 3
2522           size:
2523             - 0
2524         severity:
2525           data_type: text
2526           default_value: ~
2527           is_nullable: 0
2528           is_primary_key: 0
2529           is_unique: 1
2530           name: severity
2531           order: 2
2532           size:
2533             - 0
2534         strong:
2535           data_type: boolean
2536           default_value: !!perl/ref
2537             =: false
2538           is_nullable: 1
2539           is_primary_key: 0
2540           is_unique: 0
2541           name: strong
2542           order: 4
2543           size:
2544             - 0
2545       indices:
2546         - fields:
2547             - ordering
2548           name: severity_ordering_idx
2549           options: []
2550           type: NORMAL
2551       name: severity
2552       options: []
2553       order: 6
2554     src_associations:
2555       constraints:
2556         - deferrable: 1
2557           expression: ''
2558           fields:
2559             - id
2560           match_type: ''
2561           name: ''
2562           on_delete: ''
2563           on_update: ''
2564           options: []
2565           reference_fields: []
2566           reference_table: ''
2567           type: PRIMARY KEY
2568         - deferrable: 1
2569           expression: ''
2570           fields:
2571             - source
2572             - suite
2573           match_type: ''
2574           name: src_associations_source_suite
2575           on_delete: ''
2576           on_update: ''
2577           options: []
2578           reference_fields: []
2579           reference_table: ''
2580           type: UNIQUE
2581         - deferrable: 0
2582           expression: ''
2583           fields:
2584             - source
2585           match_type: ''
2586           name: src_associations_fk_source
2587           on_delete: CASCADE
2588           on_update: CASCADE
2589           options: []
2590           reference_fields:
2591             - id
2592           reference_table: src_ver
2593           type: FOREIGN KEY
2594         - deferrable: 0
2595           expression: ''
2596           fields:
2597             - suite
2598           match_type: ''
2599           name: src_associations_fk_suite
2600           on_delete: CASCADE
2601           on_update: CASCADE
2602           options: []
2603           reference_fields:
2604             - id
2605           reference_table: suite
2606           type: FOREIGN KEY
2607       fields:
2608         created:
2609           data_type: timestamp with time zone
2610           default_value: !!perl/ref
2611             =: current_timestamp
2612           is_nullable: 0
2613           is_primary_key: 0
2614           is_unique: 0
2615           name: created
2616           order: 4
2617           size:
2618             - 0
2619         id:
2620           data_type: integer
2621           default_value: ~
2622           is_auto_increment: 1
2623           is_nullable: 0
2624           is_primary_key: 1
2625           is_unique: 0
2626           name: id
2627           order: 1
2628           size:
2629             - 0
2630         modified:
2631           data_type: timestamp with time zone
2632           default_value: !!perl/ref
2633             =: current_timestamp
2634           is_nullable: 0
2635           is_primary_key: 0
2636           is_unique: 0
2637           name: modified
2638           order: 5
2639           size:
2640             - 0
2641         source:
2642           data_type: integer
2643           default_value: ~
2644           is_nullable: 0
2645           is_primary_key: 0
2646           is_unique: 1
2647           name: source
2648           order: 3
2649           size:
2650             - 0
2651         suite:
2652           data_type: integer
2653           default_value: ~
2654           is_nullable: 0
2655           is_primary_key: 0
2656           is_unique: 1
2657           name: suite
2658           order: 2
2659           size:
2660             - 0
2661       indices:
2662         - fields:
2663             - source
2664           name: src_associations_idx_source
2665           options: []
2666           type: NORMAL
2667         - fields:
2668             - suite
2669           name: src_associations_idx_suite
2670           options: []
2671           type: NORMAL
2672       name: src_associations
2673       options: []
2674       order: 28
2675     src_pkg:
2676       constraints:
2677         - deferrable: 1
2678           expression: ''
2679           fields:
2680             - id
2681           match_type: ''
2682           name: ''
2683           on_delete: ''
2684           on_update: ''
2685           options: []
2686           reference_fields: []
2687           reference_table: ''
2688           type: PRIMARY KEY
2689         - deferrable: 1
2690           expression: ''
2691           fields:
2692             - pkg
2693             - disabled
2694           match_type: ''
2695           name: src_pkg_pkg_disabled
2696           on_delete: ''
2697           on_update: ''
2698           options: []
2699           reference_fields: []
2700           reference_table: ''
2701           type: UNIQUE
2702         - deferrable: 0
2703           expression: ''
2704           fields:
2705             - alias_of
2706           match_type: ''
2707           name: src_pkg_fk_alias_of
2708           on_delete: CASCADE
2709           on_update: CASCADE
2710           options: []
2711           reference_fields:
2712             - id
2713           reference_table: src_pkg
2714           type: FOREIGN KEY
2715       fields:
2716         alias_of:
2717           data_type: integer
2718           default_value: ~
2719           is_nullable: 1
2720           is_primary_key: 0
2721           is_unique: 0
2722           name: alias_of
2723           order: 4
2724           size:
2725             - 0
2726         creation:
2727           data_type: timestamp with time zone
2728           default_value: !!perl/ref
2729             =: current_timestamp
2730           is_nullable: 0
2731           is_primary_key: 0
2732           is_unique: 0
2733           name: creation
2734           order: 5
2735           size:
2736             - 0
2737         disabled:
2738           data_type: timestamp with time zone
2739           default_value: infinity
2740           is_nullable: 0
2741           is_primary_key: 0
2742           is_unique: 1
2743           name: disabled
2744           order: 6
2745           size:
2746             - 0
2747         id:
2748           data_type: integer
2749           default_value: ~
2750           is_auto_increment: 1
2751           is_nullable: 0
2752           is_primary_key: 1
2753           is_unique: 0
2754           name: id
2755           order: 1
2756           size:
2757             - 0
2758         last_modified:
2759           data_type: timestamp with time zone
2760           default_value: !!perl/ref
2761             =: current_timestamp
2762           is_nullable: 0
2763           is_primary_key: 0
2764           is_unique: 0
2765           name: last_modified
2766           order: 7
2767           size:
2768             - 0
2769         obsolete:
2770           data_type: boolean
2771           default_value: !!perl/ref
2772             =: false
2773           is_nullable: 0
2774           is_primary_key: 0
2775           is_unique: 0
2776           name: obsolete
2777           order: 8
2778           size:
2779             - 0
2780         pkg:
2781           data_type: text
2782           default_value: ~
2783           is_nullable: 0
2784           is_primary_key: 0
2785           is_unique: 1
2786           name: pkg
2787           order: 2
2788           size:
2789             - 0
2790         pseduopkg:
2791           data_type: boolean
2792           default_value: !!perl/ref
2793             =: false
2794           is_nullable: 0
2795           is_primary_key: 0
2796           is_unique: 0
2797           name: pseduopkg
2798           order: 3
2799           size:
2800             - 0
2801       indices:
2802         - fields:
2803             - alias_of
2804           name: src_pkg_idx_alias_of
2805           options: []
2806           type: NORMAL
2807         - fields:
2808             - pkg
2809           name: src_pkg_pkg
2810           options: []
2811           type: NORMAL
2812       name: src_pkg
2813       options: []
2814       order: 7
2815     src_ver:
2816       constraints:
2817         - deferrable: 1
2818           expression: ''
2819           fields:
2820             - id
2821           match_type: ''
2822           name: ''
2823           on_delete: ''
2824           on_update: ''
2825           options: []
2826           reference_fields: []
2827           reference_table: ''
2828           type: PRIMARY KEY
2829         - deferrable: 1
2830           expression: ''
2831           fields:
2832             - src_pkg
2833             - ver
2834           match_type: ''
2835           name: src_ver_src_pkg_id_ver
2836           on_delete: ''
2837           on_update: ''
2838           options: []
2839           reference_fields: []
2840           reference_table: ''
2841           type: UNIQUE
2842         - deferrable: 0
2843           expression: ''
2844           fields:
2845             - based_on
2846           match_type: ''
2847           name: src_ver_fk_based_on
2848           on_delete: CASCADE
2849           on_update: CASCADE
2850           options: []
2851           reference_fields:
2852             - id
2853           reference_table: src_ver
2854           type: FOREIGN KEY
2855         - deferrable: 0
2856           expression: ''
2857           fields:
2858             - maintainer
2859           match_type: ''
2860           name: src_ver_fk_maintainer
2861           on_delete: SET NULL
2862           on_update: CASCADE
2863           options: []
2864           reference_fields:
2865             - id
2866           reference_table: maintainer
2867           type: FOREIGN KEY
2868         - deferrable: 0
2869           expression: ''
2870           fields:
2871             - src_pkg
2872           match_type: ''
2873           name: src_ver_fk_src_pkg
2874           on_delete: CASCADE
2875           on_update: CASCADE
2876           options: []
2877           reference_fields:
2878             - id
2879           reference_table: src_pkg
2880           type: FOREIGN KEY
2881       fields:
2882         based_on:
2883           data_type: integer
2884           default_value: ~
2885           is_nullable: 1
2886           is_primary_key: 0
2887           is_unique: 0
2888           name: based_on
2889           order: 6
2890           size:
2891             - 0
2892         id:
2893           data_type: integer
2894           default_value: ~
2895           is_auto_increment: 1
2896           is_nullable: 0
2897           is_primary_key: 1
2898           is_unique: 0
2899           name: id
2900           order: 1
2901           size:
2902             - 0
2903         maintainer:
2904           data_type: integer
2905           default_value: ~
2906           is_nullable: 1
2907           is_primary_key: 0
2908           is_unique: 0
2909           name: maintainer
2910           order: 4
2911           size:
2912             - 0
2913         src_pkg:
2914           data_type: integer
2915           default_value: ~
2916           is_nullable: 0
2917           is_primary_key: 0
2918           is_unique: 1
2919           name: src_pkg
2920           order: 2
2921           size:
2922             - 0
2923         upload_date:
2924           data_type: timestamp with time zone
2925           default_value: !!perl/ref
2926             =: current_timestamp
2927           is_nullable: 0
2928           is_primary_key: 0
2929           is_unique: 0
2930           name: upload_date
2931           order: 5
2932           size:
2933             - 0
2934         ver:
2935           data_type: debversion
2936           default_value: ~
2937           is_nullable: 0
2938           is_primary_key: 0
2939           is_unique: 1
2940           name: ver
2941           order: 3
2942           size:
2943             - 0
2944       indices:
2945         - fields:
2946             - based_on
2947           name: src_ver_idx_based_on
2948           options: []
2949           type: NORMAL
2950         - fields:
2951             - maintainer
2952           name: src_ver_idx_maintainer
2953           options: []
2954           type: NORMAL
2955         - fields:
2956             - src_pkg
2957           name: src_ver_idx_src_pkg
2958           options: []
2959           type: NORMAL
2960       name: src_ver
2961       options: []
2962       order: 19
2963     suite:
2964       constraints:
2965         - deferrable: 1
2966           expression: ''
2967           fields:
2968             - id
2969           match_type: ''
2970           name: ''
2971           on_delete: ''
2972           on_update: ''
2973           options: []
2974           reference_fields: []
2975           reference_table: ''
2976           type: PRIMARY KEY
2977         - deferrable: 1
2978           expression: ''
2979           fields:
2980             - codename
2981           match_type: ''
2982           name: suite_idx_codename
2983           on_delete: ''
2984           on_update: ''
2985           options: []
2986           reference_fields: []
2987           reference_table: ''
2988           type: UNIQUE
2989         - deferrable: 1
2990           expression: ''
2991           fields:
2992             - version
2993           match_type: ''
2994           name: suite_idx_version
2995           on_delete: ''
2996           on_update: ''
2997           options: []
2998           reference_fields: []
2999           reference_table: ''
3000           type: UNIQUE
3001         - deferrable: 1
3002           expression: ''
3003           fields:
3004             - suite_name
3005           match_type: ''
3006           name: suite_suite_name_key
3007           on_delete: ''
3008           on_update: ''
3009           options: []
3010           reference_fields: []
3011           reference_table: ''
3012           type: UNIQUE
3013       fields:
3014         active:
3015           data_type: boolean
3016           default_value: !!perl/ref
3017             =: true
3018           is_nullable: 1
3019           is_primary_key: 0
3020           is_unique: 0
3021           name: active
3022           order: 5
3023           size:
3024             - 0
3025         codename:
3026           data_type: text
3027           default_value: ~
3028           is_nullable: 0
3029           is_primary_key: 0
3030           is_unique: 1
3031           name: codename
3032           order: 2
3033           size:
3034             - 0
3035         id:
3036           data_type: integer
3037           default_value: ~
3038           is_auto_increment: 1
3039           is_nullable: 0
3040           is_primary_key: 1
3041           is_unique: 0
3042           name: id
3043           order: 1
3044           size:
3045             - 0
3046         suite_name:
3047           data_type: text
3048           default_value: ~
3049           is_nullable: 1
3050           is_primary_key: 0
3051           is_unique: 1
3052           name: suite_name
3053           order: 3
3054           size:
3055             - 0
3056         version:
3057           data_type: text
3058           default_value: ~
3059           is_nullable: 1
3060           is_primary_key: 0
3061           is_unique: 1
3062           name: version
3063           order: 4
3064           size:
3065             - 0
3066       indices: []
3067       name: suite
3068       options: []
3069       order: 8
3070     table_comments:
3071       constraints:
3072         - deferrable: 1
3073           expression: ''
3074           fields:
3075             - table_name
3076           match_type: ''
3077           name: table_comments_table_name_idx
3078           on_delete: ''
3079           on_update: ''
3080           options: []
3081           reference_fields: []
3082           reference_table: ''
3083           type: UNIQUE
3084         - deferrable: 1
3085           expression: ''
3086           fields:
3087             - table_name
3088           match_type: ''
3089           name: table_comments_table_name_key
3090           on_delete: ''
3091           on_update: ''
3092           options: []
3093           reference_fields: []
3094           reference_table: ''
3095           type: UNIQUE
3096       fields:
3097         comment_text:
3098           data_type: text
3099           default_value: ~
3100           is_nullable: 0
3101           is_primary_key: 0
3102           is_unique: 0
3103           name: comment_text
3104           order: 2
3105           size:
3106             - 0
3107         table_name:
3108           data_type: text
3109           default_value: ~
3110           is_nullable: 0
3111           is_primary_key: 0
3112           is_unique: 1
3113           name: table_name
3114           order: 1
3115           size:
3116             - 0
3117       indices: []
3118       name: table_comments
3119       options: []
3120       order: 9
3121     tag:
3122       constraints:
3123         - deferrable: 1
3124           expression: ''
3125           fields:
3126             - id
3127           match_type: ''
3128           name: ''
3129           on_delete: ''
3130           on_update: ''
3131           options: []
3132           reference_fields: []
3133           reference_table: ''
3134           type: PRIMARY KEY
3135         - deferrable: 1
3136           expression: ''
3137           fields:
3138             - tag
3139           match_type: ''
3140           name: tag_tag_key
3141           on_delete: ''
3142           on_update: ''
3143           options: []
3144           reference_fields: []
3145           reference_table: ''
3146           type: UNIQUE
3147       fields:
3148         id:
3149           data_type: integer
3150           default_value: ~
3151           is_auto_increment: 1
3152           is_nullable: 0
3153           is_primary_key: 1
3154           is_unique: 0
3155           name: id
3156           order: 1
3157           size:
3158             - 0
3159         obsolete:
3160           data_type: boolean
3161           default_value: !!perl/ref
3162             =: false
3163           is_nullable: 1
3164           is_primary_key: 0
3165           is_unique: 0
3166           name: obsolete
3167           order: 3
3168           size:
3169             - 0
3170         tag:
3171           data_type: text
3172           default_value: ~
3173           is_nullable: 0
3174           is_primary_key: 0
3175           is_unique: 1
3176           name: tag
3177           order: 2
3178           size:
3179             - 0
3180       indices: []
3181       name: tag
3182       options: []
3183       order: 10
3184     user_tag:
3185       constraints:
3186         - deferrable: 1
3187           expression: ''
3188           fields:
3189             - id
3190           match_type: ''
3191           name: ''
3192           on_delete: ''
3193           on_update: ''
3194           options: []
3195           reference_fields: []
3196           reference_table: ''
3197           type: PRIMARY KEY
3198         - deferrable: 1
3199           expression: ''
3200           fields:
3201             - tag
3202             - correspondent
3203           match_type: ''
3204           name: user_tag_tag_correspondent
3205           on_delete: ''
3206           on_update: ''
3207           options: []
3208           reference_fields: []
3209           reference_table: ''
3210           type: UNIQUE
3211         - deferrable: 0
3212           expression: ''
3213           fields:
3214             - correspondent
3215           match_type: ''
3216           name: user_tag_fk_correspondent
3217           on_delete: NO ACTION
3218           on_update: NO ACTION
3219           options: []
3220           reference_fields:
3221             - id
3222           reference_table: correspondent
3223           type: FOREIGN KEY
3224       fields:
3225         correspondent:
3226           data_type: integer
3227           default_value: ~
3228           is_nullable: 0
3229           is_primary_key: 0
3230           is_unique: 1
3231           name: correspondent
3232           order: 3
3233           size:
3234             - 0
3235         id:
3236           data_type: integer
3237           default_value: ~
3238           is_auto_increment: 1
3239           is_nullable: 0
3240           is_primary_key: 1
3241           is_unique: 0
3242           name: id
3243           order: 1
3244           size:
3245             - 0
3246         tag:
3247           data_type: text
3248           default_value: ~
3249           is_nullable: 0
3250           is_primary_key: 0
3251           is_unique: 1
3252           name: tag
3253           order: 2
3254           size:
3255             - 0
3256       indices:
3257         - fields:
3258             - correspondent
3259           name: user_tag_idx_correspondent
3260           options: []
3261           type: NORMAL
3262         - fields:
3263             - correspondent
3264           name: user_tag_correspondent
3265           options: []
3266           type: NORMAL
3267       name: user_tag
3268       options: []
3269       order: 14
3270   triggers: {}
3271   views:
3272     binary_versions:
3273       fields:
3274         - src_pkg
3275         - src_ver
3276         - bin_pkg
3277         - arch
3278         - bin_ver
3279         - src_ver_based_on
3280         - src_pkg_based_on
3281       name: binary_versions
3282       order: 1
3283       sql: |
3284         SELECT sp.pkg AS src_pkg, sv.ver AS src_ver, bp.pkg AS bin_pkg, a.arch AS arch, b.ver AS bin_ver,
3285         svb.ver AS src_ver_based_on, spb.pkg AS src_pkg_based_on
3286         FROM bin_ver b JOIN arch a ON b.arch = a.id
3287                               JOIN bin_pkg bp ON b.bin_pkg  = bp.id
3288                        JOIN src_ver sv ON b.src_ver  = sv.id
3289                        JOIN src_pkg sp ON sv.src_pkg = sp.id
3290                        LEFT OUTER JOIN src_ver svb ON sv.based_on = svb.id
3291                        LEFT OUTER JOIN src_pkg spb ON spb.id = svb.src_pkg;
3292     bug_package:
3293       fields:
3294         - bug
3295         - pkg_id
3296         - pkg_type
3297         - package
3298       name: bug_package
3299       order: 2
3300       sql: |
3301         SELECT b.bug,b.bin_pkg,'binary',bp.pkg FROM bug_binpackage b JOIN bin_pkg bp ON bp.id=b.bin_pkg UNION
3302                SELECT s.bug,s.src_pkg,'source',sp.pkg FROM bug_srcpackage s JOIN src_pkg sp ON sp.id=s.src_pkg;
3303 translator:
3304   add_drop_table: 0
3305   filename: ~
3306   no_comments: 0
3307   parser_args:
3308     sources:
3309       - Arch
3310       - BinAssociation
3311       - BinPkg
3312       - BinVer
3313       - BinaryVersion
3314       - Bug
3315       - BugAffectsBinpackage
3316       - BugAffectsSrcpackage
3317       - BugBinpackage
3318       - BugBlock
3319       - BugMerged
3320       - BugMessage
3321       - BugPackage
3322       - BugSrcpackage
3323       - BugStatusCache
3324       - BugTag
3325       - BugUserTag
3326       - BugVer
3327       - ColumnComment
3328       - Correspondent
3329       - CorrespondentFullName
3330       - Maintainer
3331       - Message
3332       - MessageCorrespondent
3333       - MessageRef
3334       - Severity
3335       - SrcAssociation
3336       - SrcPkg
3337       - SrcVer
3338       - Suite
3339       - TableComment
3340       - Tag
3341       - UserTag
3342   parser_type: SQL::Translator::Parser::DBIx::Class
3343   producer_args: {}
3344   producer_type: SQL::Translator::Producer::YAML
3345   show_warnings: 0
3346   trace: 0
3347   version: 0.11021