t/data/diff/create1.yml

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