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: 10
  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: 8
  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: 9
  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: 7
  93           size:
  94             - 50
  95       indices: []
  96       name: employee
  97       options:
  98         - ENGINE: InnoDB
  99       order: 2
 100     person:
 101       constraints:
 102         - deferrable: 1
 103           expression: ''
 104           fields:
 105             - person_id
 106           match_type: ''
 107           name: ''
 108           on_delete: ''
 109           on_update: ''
 110           options: []
 111           reference_fields: []
 112           reference_table: ''
 113           type: PRIMARY KEY
 114         - deferrable: 1
 115           expression: ''
 116           fields:
 117             - age
 118           match_type: ''
 119           name: UC_age_name
 120           on_delete: ''
 121           on_update: ''
 122           options: []
 123           reference_fields: []
 124           reference_table: ''
 125           type: UNIQUE
 126       fields:
 127         age:
 128           data_type: int
 129           default_value: ~
 130           extra: {}
 131           is_nullable: 1
 132           is_primary_key: 0
 133           is_unique: 1
 134           name: age
 135           order: 3
 136           size:
 137             - 11
 138         description:
 139           data_type: text
 140           default_value: ~
 141           extra: {}
 142           is_nullable: 1
 143           is_primary_key: 0
 144           is_unique: 0
 145           name: description
 146           order: 6
 147           size:
 148             - 65535
 149         iq:
 150           data_type: tinyint
 151           default_value: 0
 152           extra: {}
 153           is_nullable: 1
 154           is_primary_key: 0
 155           is_unique: 0
 156           name: iq
 157           order: 5
 158           size:
 159             - 4
 160         name:
 161           data_type: varchar
 162           default_value: ~
 163           extra: {}
 164           is_nullable: 1
 165           is_primary_key: 0
 166           is_unique: 0
 167           name: name
 168           order: 2
 169           size:
 170             - 20
 171         person_id:
 172           data_type: int
 173           default_value: ~
 174           extra: {}
 175           is_nullable: 0
 176           is_primary_key: 1
 177           is_unique: 0
 178           name: person_id
 179           order: 1
 180           size:
 181             - 11
 182         weight:
 183           data_type: double
 184           default_value: ~
 185           extra: {}
 186           is_nullable: 1
 187           is_primary_key: 0
 188           is_unique: 0
 189           name: weight
 190           order: 4
 191           size:
 192             - 11
 193             - 2
 194       indices:
 195         - fields:
 196             - name
 197           name: u_name
 198           options: []
 199           type: UNIQUE
 200       name: person
 201       options:
 202         - ENGINE: MyISAM
 203       order: 1
 204   triggers: {}
 205   views: {}
 206 translator:
 207   add_drop_table: 0
 208   filename: t/data/mysql/create.sql
 209   no_comments: 0
 210   parser_args:
 211     db_password: ~
 212     db_user: ~
 213     dsn: ~
 214     field_separator: ~
 215     mysql_parser_version: ~
 216     record_separator: ~
 217     scan_fields: 1
 218     trim_fields: 1
 219   parser_type: SQL::Translator::Parser::MySQL
 220   producer_args:
 221     add_prefix: ~
 222     add_truncate: ~
 223     db_password: ~
 224     db_user: ~
 225     dsn: ~
 226     imap_file: ~
 227     imap_url: ~
 228     indent: ~
 229     newlines: ~
 230     package_name: ~
 231     prefix: ~
 232     pretty: ~
 233     skip: ~
 234     skiplike: ~
 235     title: ~
 236     tt_conf: {}
 237     tt_vars: {}
 238     ttfile: ~
 239   producer_type: SQL::Translator::Producer::YAML
 240   show_warnings: 0
 241   trace: 0
 242   version: 0.0899_01