t/data/template/testresult_basic.txt

   1 Schema:
   2 Database:
   3
   4 Foo: bar
   5 Hello: world
   6
   7 Table: Basic
   8 ==========================================================================
   9
  10 Fields
  11     id
  12         data_type:             int
  13         size:                  10
  14         is_nullable:           0
  15         default_value:
  16         is_primary_key:        1
  17         is_unique:             0
  18         is_auto_increment:     1
  19         is_foreign_key:        0
  20         foreign_key_reference:
  21         is_valid:              1
  22         order:                 1
  23         table:                 Basic
  24
  25     title
  26         data_type:             varchar
  27         size:                  100
  28         is_nullable:           0
  29         default_value:         hello
  30         is_primary_key:        0
  31         is_unique:             1
  32         is_auto_increment:     0
  33         is_foreign_key:        0
  34         foreign_key_reference:
  35         is_valid:              1
  36         order:                 2
  37         table:                 Basic
  38
  39     description
  40         data_type:             text
  41         size:                  0
  42         is_nullable:           1
  43         default_value:
  44         is_primary_key:        0
  45         is_unique:             0
  46         is_auto_increment:     0
  47         is_foreign_key:        0
  48         foreign_key_reference:
  49         is_valid:              1
  50         order:                 3
  51         table:                 Basic
  52
  53     email
  54         data_type:             varchar
  55         size:                  500
  56         is_nullable:           1
  57         default_value:
  58         is_primary_key:        0
  59         is_unique:             1
  60         is_auto_increment:     0
  61         is_foreign_key:        0
  62         foreign_key_reference:
  63         is_valid:              1
  64         order:                 4
  65         table:                 Basic
  66
  67     explicitnulldef
  68         data_type:             varchar
  69         size:                  0
  70         is_nullable:           1
  71         default_value:
  72         is_primary_key:        0
  73         is_unique:             0
  74         is_auto_increment:     0
  75         is_foreign_key:        0
  76         foreign_key_reference:
  77         is_valid:              1
  78         order:                 5
  79         table:                 Basic
  80
  81     explicitemptystring
  82         data_type:             varchar
  83         size:                  0
  84         is_nullable:           1
  85         default_value:
  86         is_primary_key:        0
  87         is_unique:             0
  88         is_auto_increment:     0
  89         is_foreign_key:        0
  90         foreign_key_reference:
  91         is_valid:              1
  92         order:                 6
  93         table:                 Basic
  94
  95     emptytagdef
  96         data_type:             varchar
  97         size:                  0
  98         is_nullable:           1
  99         default_value:
 100         is_primary_key:        0
 101         is_unique:             0
 102         is_auto_increment:     0
 103         is_foreign_key:        0
 104         foreign_key_reference:
 105         is_valid:              1
 106         order:                 7
 107         table:                 Basic
 108
 109     another_id
 110         data_type:             int
 111         size:                  10
 112         is_nullable:           1
 113         default_value:         2
 114         is_primary_key:        0
 115         is_unique:             0
 116         is_auto_increment:     0
 117         is_foreign_key:        1
 118         foreign_key_reference: Another
 119         is_valid:              1
 120         order:                 8
 121         table:                 Basic
 122
 123     timest
 124         data_type:             timestamp
 125         size:                  0
 126         is_nullable:           1
 127         default_value:
 128         is_primary_key:        0
 129         is_unique:             0
 130         is_auto_increment:     0
 131         is_foreign_key:        0
 132         foreign_key_reference:
 133         is_valid:              1
 134         order:                 9
 135         table:                 Basic
 136
 137
 138 Indices
 139     titleindex
 140         table:    Basic
 141         fields:   title
 142         type:     NORMAL
 143         options:
 144         is_valid: 1
 145
 146
 147 Constraints
 148     ?
 149         type:             PRIMARY KEY
 150         fields:           id
 151         expression:
 152         match_type:
 153         reference_fields:
 154         reference_table:
 155         deferrable:       1
 156         on_delete:
 157         on_update:
 158         options:
 159         is_valid:         1
 160
 161     emailuniqueindex
 162         type:             UNIQUE
 163         fields:           email
 164         expression:
 165         match_type:
 166         reference_fields:
 167         reference_table:
 168         deferrable:       1
 169         on_delete:
 170         on_update:
 171         options:
 172         is_valid:         1
 173
 174     very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms
 175         type:             UNIQUE
 176         fields:           title
 177         expression:
 178         match_type:
 179         reference_fields:
 180         reference_table:
 181         deferrable:       1
 182         on_delete:
 183         on_update:
 184         options:
 185         is_valid:         1
 186
 187     ?
 188         type:             FOREIGN KEY
 189         fields:           another_id
 190         expression:
 191         match_type:
 192         reference_fields: id
 193         reference_table:  Another
 194         deferrable:       1
 195         on_delete:
 196         on_update:
 197         options:
 198         is_valid:         1
 199
 200 Table: Another
 201 ==========================================================================
 202
 203 Fields
 204     id
 205         data_type:             int
 206         size:                  10
 207         is_nullable:           0
 208         default_value:
 209         is_primary_key:        1
 210         is_unique:             0
 211         is_auto_increment:     1
 212         is_foreign_key:        0
 213         foreign_key_reference:
 214         is_valid:              1
 215         order:                 1
 216         table:                 Another
 217
 218     num
 219         data_type:             numeric
 220         size:                  10,2
 221         is_nullable:           1
 222         default_value:
 223         is_primary_key:        0
 224         is_unique:             0
 225         is_auto_increment:     0
 226         is_foreign_key:        0
 227         foreign_key_reference:
 228         is_valid:              1
 229         order:                 2
 230         table:                 Another
 231
 232
 233 Indices
 234
 235 Constraints
 236     ?
 237         type:             PRIMARY KEY
 238         fields:           id
 239         expression:
 240         match_type:
 241         reference_fields:
 242         reference_table:
 243         deferrable:       1
 244         on_delete:
 245         on_update:
 246         options:
 247         is_valid:         1
 248