t/data/diff/create2.yml

   1 ---
   2 schema:
   3   procedures: {}
   4   tables:
   5     added:
   6       constraints: []
   7       fields:
   8         id:
   9           data_type: int
  10           default_value: ~
  11           extra: {}
  12           is_nullable: 1
  13           is_primary_key: 0
  14           is_unique: 0
  15           name: id
  16           order: 10
  17           size:
  18             - 11
  19       indices: []
  20       name: added
  21       options: []
  22       order: 3
  23     employee:
  24       constraints:
  25         - deferrable: 1
  26           expression: ''
  27           fields:
  28             - employee_id
  29           match_type: ''
  30           name: FK5302D47D93FE702E_diff
  31           on_delete: ''
  32           on_update: ''
  33           options: []
  34           reference_fields:
  35             - person_id
  36           reference_table: person
  37           type: FOREIGN KEY
  38         - deferrable: 1
  39           expression: ''
  40           fields:
  41             - employee_id
  42             - position
  43           match_type: ''
  44           name: ''
  45           on_delete: ''
  46           on_update: ''
  47           options: []
  48           reference_fields: []
  49           reference_table: ''
  50           type: PRIMARY KEY
  51       fields:
  52         employee_id:
  53           data_type: int
  54           default_value: ~
  55           extra: {}
  56           is_nullable: 0
  57           is_primary_key: 1
  58           is_unique: 0
  59           name: employee_id
  60           order: 9
  61           size:
  62             - 11
  63         position:
  64           data_type: varchar
  65           default_value: ~
  66           extra: {}
  67           is_nullable: 0
  68           is_primary_key: 1
  69           is_unique: 0
  70           name: position
  71           order: 8
  72           size:
  73             - 50
  74       indices: []
  75       name: employee
  76       options:
  77         - ENGINE: InnoDB
  78       order: 2
  79     person:
  80       constraints:
  81         - deferrable: 1
  82           expression: ''
  83           fields:
  84             - person_id
  85           match_type: ''
  86           name: ''
  87           on_delete: ''
  88           on_update: ''
  89           options: []
  90           reference_fields: []
  91           reference_table: ''
  92           type: PRIMARY KEY
  93         - deferrable: 1
  94           expression: ''
  95           fields:
  96             - person_id
  97           match_type: ''
  98           name: UC_person_id
  99           on_delete: ''
 100           on_update: ''
 101           options: []
 102           reference_fields: []
 103           reference_table: ''
 104           type: UNIQUE
 105         - deferrable: 1
 106           expression: ''
 107           fields:
 108             - age
 109             - name
 110           match_type: ''
 111           name: UC_age_name
 112           on_delete: ''
 113           on_update: ''
 114           options: []
 115           reference_fields: []
 116           reference_table: ''
 117           type: UNIQUE
 118       fields:
 119         age:
 120           data_type: int
 121           default_value: 18
 122           extra: {}
 123           is_nullable: 1
 124           is_primary_key: 0
 125           is_unique: 1
 126           name: age
 127           order: 3
 128           size:
 129             - 11
 130         iq:
 131           data_type: int
 132           default_value: 0
 133           extra: {}
 134           is_nullable: 1
 135           is_primary_key: 0
 136           is_unique: 0
 137           name: iq
 138           order: 5
 139           size:
 140             - 11
 141         is_rock_star:
 142           data_type: tinyint
 143           default_value: 1
 144           extra: {}
 145           is_nullable: 1
 146           is_primary_key: 0
 147           is_unique: 0
 148           name: is_rock_star
 149           order: 6
 150           size:
 151             - 4
 152         name:
 153           data_type: varchar
 154           default_value: ~
 155           extra: {}
 156           is_nullable: 0
 157           is_primary_key: 0
 158           is_unique: 1
 159           name: name
 160           order: 2
 161           size:
 162             - 20
 163         person_id:
 164           data_type: int
 165           default_value: ~
 166           extra: {}
 167           is_auto_increment: 1
 168           is_nullable: 0
 169           is_primary_key: 1
 170           is_unique: 1
 171           name: person_id
 172           order: 1
 173           size:
 174             - 11
 175         physical_description:
 176           data_type: text
 177           default_value: ~
 178           extra:
 179             renamed_from: 'description'
 180           is_nullable: 1
 181           is_primary_key: 0
 182           is_unique: 0
 183           name: physical_description
 184           order: 7
 185           size:
 186             - 65535
 187         weight:
 188           data_type: double
 189           default_value: ~
 190           extra: {}
 191           is_nullable: 1
 192           is_primary_key: 0
 193           is_unique: 0
 194           name: weight
 195           order: 4
 196           size:
 197             - 11
 198             - 2
 199       indices:
 200         - fields:
 201             - name
 202           name: unique_name
 203           options: []
 204           type: UNIQUE
 205       name: person
 206       options:
 207         - ENGINE: InnoDB
 208       order: 1
 209   triggers: {}
 210   views: {}
 211 translator:
 212   add_drop_table: 0
 213   filename: t/data/mysql/create2.sql
 214   no_comments: 0
 215   parser_args:
 216     db_password: ~
 217     db_user: ~
 218     dsn: ~
 219     field_separator: ~
 220     mysql_parser_version: ~
 221     record_separator: ~
 222     scan_fields: 1
 223     trim_fields: 1
 224   parser_type: SQL::Translator::Parser::MySQL
 225   producer_args:
 226     add_prefix: ~
 227     add_truncate: ~
 228     db_password: ~
 229     db_user: ~
 230     dsn: ~
 231     imap_file: ~
 232     imap_url: ~
 233     indent: ~
 234     newlines: ~
 235     package_name: ~
 236     prefix: ~
 237     pretty: ~
 238     skip: ~
 239     skiplike: ~
 240     title: ~
 241     tt_conf: {}
 242     tt_vars: {}
 243     ttfile: ~
 244   producer_type: SQL::Translator::Producer::YAML
 245   show_warnings: 0
 246   trace: 0
 247   version: 0.0899_01