t/data/diff/pgsql/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: 1
  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       order: 2
  77     new_name:
  78       name: new_name
  79       extra:
  80         renamed_from: old_name
  81       fields:
  82         pk:
  83           data_type: int
  84           default_value: ~
  85           extra: {}
  86           is_auto_increment: 1
  87           is_nullable: 0
  88           is_primary_key: 1
  89           is_unique: 1
  90           name: pk
  91           order: 1
  92         other:
  93           data_type: int
  94           name: new_field
  95           order: 2
  96       order: 4
  97     person:
  98       constraints:
  99         - deferrable: 1
 100           expression: ''
 101           fields:
 102             - person_id
 103           match_type: ''
 104           name: ''
 105           on_delete: ''
 106           on_update: ''
 107           options: []
 108           reference_fields: []
 109           reference_table: ''
 110           type: PRIMARY KEY
 111         - deferrable: 1
 112           expression: ''
 113           fields:
 114             - person_id
 115           match_type: ''
 116           name: UC_person_id
 117           on_delete: ''
 118           on_update: ''
 119           options: []
 120           reference_fields: []
 121           reference_table: ''
 122           type: UNIQUE
 123         - deferrable: 1
 124           expression: ''
 125           fields:
 126             - age
 127             - name
 128           match_type: ''
 129           name: UC_age_name
 130           on_delete: ''
 131           on_update: ''
 132           options: []
 133           reference_fields: []
 134           reference_table: ''
 135           type: UNIQUE
 136       fields:
 137         age:
 138           data_type: int
 139           default_value: 18
 140           extra: {}
 141           is_nullable: 1
 142           is_primary_key: 0
 143           is_unique: 1
 144           name: age
 145           order: 3
 146           size:
 147             - 11
 148         iq:
 149           data_type: int
 150           default_value: 0
 151           is_nullable: 1
 152           is_primary_key: 0
 153           is_unique: 0
 154           name: iq
 155           order: 5
 156           size:
 157             - 11
 158         is_rock_star:
 159           data_type: smallint
 160           default_value: 1
 161           extra: {}
 162           is_nullable: 1
 163           is_primary_key: 0
 164           is_unique: 0
 165           name: is_rock_star
 166           order: 6
 167           size:
 168             - 4
 169         name:
 170           data_type: varchar
 171           default_value: ~
 172           extra: {}
 173           is_nullable: 0
 174           is_primary_key: 0
 175           is_unique: 1
 176           name: name
 177           order: 2
 178           size:
 179             - 20
 180         person_id:
 181           data_type: int
 182           default_value: ~
 183           extra: {}
 184           is_auto_increment: 1
 185           is_nullable: 0
 186           is_primary_key: 1
 187           is_unique: 1
 188           name: person_id
 189           order: 1
 190           size:
 191             - 11
 192         physical_description:
 193           data_type: text
 194           default_value: ~
 195           extra:
 196             renamed_from: 'description'
 197           is_nullable: 1
 198           is_primary_key: 0
 199           is_unique: 0
 200           name: physical_description
 201           order: 7
 202           size:
 203             - 65535
 204         weight:
 205           data_type: numeric
 206           default_value: ~
 207           extra: {}
 208           is_nullable: 1
 209           is_primary_key: 0
 210           is_unique: 0
 211           name: weight
 212           order: 4
 213           size:
 214             - 11
 215             - 2
 216       indices:
 217         - fields:
 218             - name
 219           name: unique_name
 220           options: []
 221           type: UNIQUE
 222       name: person
 223       order: 1
 224   triggers: {}
 225   views: {}
 226 translator:
 227   add_drop_table: 0
 228   filename: t/data/pgsql/create2.sql
 229   no_comments: 0
 230   parser_args:
 231     db_password: ~
 232     db_user: ~
 233     dsn: ~
 234     field_separator: ~
 235     mysql_parser_version: ~
 236     record_separator: ~
 237     scan_fields: 1
 238     trim_fields: 1
 239   parser_type: SQL::Translator::Parser::PostgreSQL
 240   producer_args:
 241     add_prefix: ~
 242     add_truncate: ~
 243     db_password: ~
 244     db_user: ~
 245     dsn: ~
 246     imap_file: ~
 247     imap_url: ~
 248     indent: ~
 249     newlines: ~
 250     package_name: ~
 251     prefix: ~
 252     pretty: ~
 253     skip: ~
 254     skiplike: ~
 255     title: ~
 256     tt_conf: {}
 257     tt_vars: {}
 258     ttfile: ~
 259   producer_type: SQL::Translator::Producer::YAML
 260   show_warnings: 0
 261   trace: 0
 262   version: 0.0899_01